You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Stanislav Lukyanov (JIRA)" <ji...@apache.org> on 2018/10/30 07:34:00 UTC
[jira] [Created] (IGNITE-10057) SQL queries hang during rebalance
if there are LOST partitions
Stanislav Lukyanov created IGNITE-10057:
-------------------------------------------
Summary: SQL queries hang during rebalance if there are LOST partitions
Key: IGNITE-10057
URL: https://issues.apache.org/jira/browse/IGNITE-10057
Project: Ignite
Issue Type: Bug
Components: sql
Reporter: Stanislav Lukyanov
When there are both LOST and MOVING partitions in the cluster, SQL queries will hang until rebalance has completed and there aren't any MOVING partitions. During that time the reducer node keeps printing
{code}
[2018-10-30 10:26:06,787][INFO ][test-runner-#1%cache.IndexingCachePartitionLossPolicySelfTest%][GridReduceQueryExecutor] Failed to calculate nodes for SQL query (partition has no owners, but corresponding cache group has data nodes) [qryId=13, cacheIds=[1254100233], cacheName=partitioned, cacheId=1254100233, part=0, cacheGroupId=1254100233]
[2018-10-30 10:26:06,798][INFO ][test-runner-#1%cache.IndexingCachePartitionLossPolicySelfTest%][GridReduceQueryExecutor] Failed to calculate nodes for SQL query (partition has no owners, but corresponding cache group has data nodes) [qryId=14, cacheIds=[1254100233], cacheName=partitioned, cacheId=1254100233, part=0, cacheGroupId=1254100233]
[2018-10-30 10:26:06,818][INFO ][test-runner-#1%cache.IndexingCachePartitionLossPolicySelfTest%][GridReduceQueryExecutor] Failed to calculate nodes for SQL query (partition has no owners, but corresponding cache group has data nodes) [qryId=15, cacheIds=[1254100233], cacheName=partitioned, cacheId=1254100233, part=0, cacheGroupId=1254100233]
[2018-10-30 10:26:06,849][INFO ][test-runner-#1%cache.IndexingCachePartitionLossPolicySelfTest%][GridReduceQueryExecutor] Failed to calculate nodes for SQL query (partition has no owners, but corresponding cache group has data nodes) [qryId=16, cacheIds=[1254100233], cacheName=partitioned, cacheId=1254100233, part=0, cacheGroupId=1254100233]
[2018-10-30 10:26:06,889][INFO ][test-runner-#1%cache.IndexingCachePartitionLossPolicySelfTest%][GridReduceQueryExecutor] Failed to calculate nodes for SQL query (partition has no owners, but corresponding cache group has data nodes) [qryId=17, cacheIds=[1254100233], cacheName=partitioned, cacheId=1254100233, part=0, cacheGroupId=1254100233]
[2018-10-30 10:26:06,940][INFO ][test-runner-#1%cache.IndexingCachePartitionLossPolicySelfTest%][GridReduceQueryExecutor] Failed to calculate nodes for SQL query (partition has no owners, but corresponding cache group has data nodes) [qryId=18, cacheIds=[1254100233], cacheName=partitioned, cacheId=1254100233, part=0, cacheGroupId=1254100233]
[2018-10-30 10:26:07,001][INFO ][test-runner-#1%cache.IndexingCachePartitionLossPolicySelfTest%][GridReduceQueryExecutor] Failed to calculate nodes for SQL query (partition has no owners, but corresponding cache group has data nodes) [qryId=19, cacheIds=[1254100233], cacheName=partitioned, cacheId=1254100233, part=0, cacheGroupId=1254100233]
[2018-10-30 10:26:07,072][INFO ][test-runner-#1%cache.IndexingCachePartitionLossPolicySelfTest%][GridReduceQueryExecutor] Failed to calculate nodes for SQL query (partition has no owners, but corresponding cache group has data nodes) [qryId=20, cacheIds=[1254100233], cacheName=partitioned, cacheId=1254100233, part=0, cacheGroupId=1254100233]
[2018-10-30 10:26:07,152][INFO ][test-runner-#1%cache.IndexingCachePartitionLossPolicySelfTest%][GridReduceQueryExecutor] Failed to calculate nodes for SQL query (partition has no owners, but corresponding cache group has data nodes) [qryId=21, cacheIds=[1254100233], cacheName=partitioned, cacheId=1254100233, part=0, cacheGroupId=1254100233]
[2018-10-30 10:26:07,243][INFO ][test-runner-#1%cache.IndexingCachePartitionLossPolicySelfTest%][GridReduceQueryExecutor] Failed to calculate nodes for SQL query (partition has no owners, but corresponding cache group has data nodes) [qryId=22, cacheIds=[1254100233], cacheName=partitioned, cacheId=1254100233, part=0, cacheGroupId=1254100233]
[2018-10-30 10:26:07,343][INFO ][test-runner-#1%cache.IndexingCachePartitionLossPolicySelfTest%][GridReduceQueryExecutor] Failed to calculate nodes for SQL query (partition has no owners, but corresponding cache group has data nodes) [qryId=23, cacheIds=[1254100233], cacheName=partitioned, cacheId=1254100233, part=0, cacheGroupId=1254100233]
[2018-10-30 10:26:07,454][INFO ][test-runner-#1%cache.IndexingCachePartitionLossPolicySelfTest%][GridReduceQueryExecutor] Failed to calculate nodes for SQL query (partition has no owners, but corresponding cache group has data nodes) [qryId=24, cacheIds=[1254100233], cacheName=partitioned, cacheId=1254100233, part=0, cacheGroupId=1254100233]
[2018-10-30 10:26:07,575][INFO ][test-runner-#1%cache.IndexingCachePartitionLossPolicySelfTest%][GridReduceQueryExecutor] Failed to calculate nodes for SQL query (partition has no owners, but corresponding cache group has data nodes) [qryId=25, cacheIds=[1254100233], cacheName=partitioned, cacheId=1254100233, part=0, cacheGroupId=1254100233]
[2018-10-30 10:26:07,705][INFO ][test-runner-#1%cache.IndexingCachePartitionLossPolicySelfTest%][GridReduceQueryExecutor] Failed to calculate nodes for SQL query (partition has no owners, but corresponding cache group has data nodes) [qryId=26, cacheIds=[1254100233], cacheName=partitioned, cacheId=1254100233, part=0, cacheGroupId=1254100233]
[2018-10-30 10:26:07,846][INFO ][test-runner-#1%cache.IndexingCachePartitionLossPolicySelfTest%][GridReduceQueryExecutor] Failed to calculate nodes for SQL query (partition has no owners, but corresponding cache group has data nodes) [qryId=27, cacheIds=[1254100233], cacheName=partitioned, cacheId=1254100233, part=0, cacheGroupId=1254100233]
[2018-10-30 10:26:07,997][INFO ][test-runner-#1%cache.IndexingCachePartitionLossPolicySelfTest%][GridReduceQueryExecutor] Failed to calculate nodes for SQL query (partition has no owners, but corresponding cache group has data nodes) [qryId=28, cacheIds=[1254100233], cacheName=partitioned, cacheId=1254100233, part=0, cacheGroupId=1254100233]
[2018-10-30 10:26:08,158][INFO ][test-runner-#1%cache.IndexingCachePartitionLossPolicySelfTest%][GridReduceQueryExecutor] Failed to calculate nodes for SQL query (partition has no owners, but corresponding cache group has data nodes) [qryId=29, cacheIds=[1254100233], cacheName=partitioned, cacheId=1254100233, part=0, cacheGroupId=1254100233]
[2018-10-30 10:26:08,328][INFO ][test-runner-#1%cache.IndexingCachePartitionLossPolicySelfTest%][GridReduceQueryExecutor] Failed to calculate nodes for SQL query (partition has no owners, but corresponding cache group has data nodes) [qryId=30, cacheIds=[1254100233], cacheName=partitioned, cacheId=1254100233, part=0, cacheGroupId=1254100233]
[2018-10-30 10:26:08,508][INFO ][test-runner-#1%cache.IndexingCachePartitionLossPolicySelfTest%][GridReduceQueryExecutor] Failed to calculate nodes for SQL query (partition has no owners, but corresponding cache group has data nodes) [qryId=31, cacheIds=[1254100233], cacheName=partitioned, cacheId=1254100233, part=0, cacheGroupId=1254100233]
[2018-10-30 10:26:08,699][INFO ][test-runner-#1%cache.IndexingCachePartitionLossPolicySelfTest%][GridReduceQueryExecutor] Failed to calculate nodes for SQL query (partition has no owners, but corresponding cache group has data nodes) [qryId=32, cacheIds=[1254100233], cacheName=partitioned, cacheId=1254100233, part=0, cacheGroupId=1254100233]
[2018-10-30 10:26:08,899][INFO ][test-runner-#1%cache.IndexingCachePartitionLossPolicySelfTest%][GridReduceQueryExecutor] Failed to calculate nodes for SQL query (partition has no owners, but corresponding cache group has data nodes) [qryId=33, cacheIds=[1254100233], cacheName=partitioned, cacheId=1254100233, part=0, cacheGroupId=1254100233]
[2018-10-30 10:26:09,109][INFO ][test-runner-#1%cache.IndexingCachePartitionLossPolicySelfTest%][GridReduceQueryExecutor] Failed to calculate nodes for SQL query (partition has no owners, but corresponding cache group has data nodes) [qryId=34, cacheIds=[1254100233], cacheName=partitioned, cacheId=1254100233, part=0, cacheGroupId=1254100233]
[2018-10-30 10:26:09,330][INFO ][test-runner-#1%cache.IndexingCachePartitionLossPolicySelfTest%][GridReduceQueryExecutor] Failed to calculate nodes for SQL query (partition has no owners, but corresponding cache group has data nodes) [qryId=35, cacheIds=[1254100233], cacheName=partitioned, cacheId=1254100233, part=0, cacheGroupId=1254100233]
[2018-10-30 10:26:09,560][INFO ][test-runner-#1%cache.IndexingCachePartitionLossPolicySelfTest%][GridReduceQueryExecutor] Failed to calculate nodes for SQL query (partition has no owners, but corresponding cache group has data nodes) [qryId=36, cacheIds=[1254100233], cacheName=partitioned, cacheId=1254100233, part=0, cacheGroupId=1254100233]
{code}
The reason is that `GridReduceQueryExecutor::partitionedUnstableDataNodes` fails if a partition doesn't have OWNING copies.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)