[jira] [Created] (IGNITE-10057) SQL queries hang during rebalance if there are LOST partitions

[Anton Vinogradov (Jira)]

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)