Barrett Oglesby created GEODE-9030:
--------------------------------------

             Summary: The PartitionedIndex arbitraryBucketIndex doesn't get 
reset when the BucketRegion defining it is moved
                 Key: GEODE-9030
                 URL: https://issues.apache.org/jira/browse/GEODE-9030
             Project: Geode
          Issue Type: Bug
          Components: querying
            Reporter: Barrett Oglesby


This causes a RegionDestroyedException like this when executing a query 
containing a != clause:
{noformat}
Exception in thread "main" 
org.apache.geode.cache.client.ServerOperationException: remote server on 
10.166.145.16(client:27461:loner):58776:dfd3ba27:client: While performing a 
remote query
        at 
org.apache.geode.cache.client.internal.AbstractOp.processChunkedResponse(AbstractOp.java:342)
        at 
org.apache.geode.cache.client.internal.QueryOp$QueryOpImpl.processResponse(QueryOp.java:168)
        at 
org.apache.geode.cache.client.internal.AbstractOp.processResponse(AbstractOp.java:224)
        at 
org.apache.geode.cache.client.internal.AbstractOp.attemptReadResponse(AbstractOp.java:197)
        at 
org.apache.geode.cache.client.internal.AbstractOp.attempt(AbstractOp.java:384)
        at 
org.apache.geode.cache.client.internal.ConnectionImpl.execute(ConnectionImpl.java:284)
        at 
org.apache.geode.cache.client.internal.pooling.PooledConnection.execute(PooledConnection.java:355)
        at 
org.apache.geode.cache.client.internal.OpExecutorImpl.executeWithPossibleReAuthentication(OpExecutorImpl.java:756)
        at 
org.apache.geode.cache.client.internal.OpExecutorImpl.execute(OpExecutorImpl.java:142)
        at 
org.apache.geode.cache.client.internal.OpExecutorImpl.execute(OpExecutorImpl.java:112)
        at 
org.apache.geode.cache.client.internal.PoolImpl.execute(PoolImpl.java:797)
        at 
org.apache.geode.cache.client.internal.QueryOp.execute(QueryOp.java:59)
        at 
org.apache.geode.cache.client.internal.ServerProxy.query(ServerProxy.java:59)
        at 
org.apache.geode.cache.query.internal.DefaultQuery.executeOnServer(DefaultQuery.java:327)
        at 
org.apache.geode.cache.query.internal.DefaultQuery.execute(DefaultQuery.java:215)
        at 
org.apache.geode.cache.query.internal.DefaultQuery.execute(DefaultQuery.java:197)
Caused by: org.apache.geode.cache.query.QueryInvocationTargetException: The 
Region on which query is executed may have been 
destroyed.BucketRegion[path='/__PR/_B__trade_0;serial=12;primary=false]
        at 
org.apache.geode.internal.cache.PRQueryProcessor.executeQueryOnBuckets(PRQueryProcessor.java:264)
        at 
org.apache.geode.internal.cache.PRQueryProcessor.executeSequentially(PRQueryProcessor.java:214)
        at 
org.apache.geode.internal.cache.PRQueryProcessor.executeQuery(PRQueryProcessor.java:124)
        at 
org.apache.geode.internal.cache.partitioned.QueryMessage.operateOnPartitionedRegion(QueryMessage.java:210)
Caused by: org.apache.geode.cache.RegionDestroyedException: 
BucketRegion[path='/__PR/_B__trade_0;serial=12;primary=false]
        at 
org.apache.geode.internal.cache.LocalRegion.checkRegionDestroyed(LocalRegion.java:7352)
        at 
org.apache.geode.internal.cache.LocalRegion.checkReadiness(LocalRegion.java:2757)
        at 
org.apache.geode.internal.cache.BucketRegion.checkReadiness(BucketRegion.java:1437)
        at 
org.apache.geode.internal.cache.LocalRegion.size(LocalRegion.java:8313)
        at 
org.apache.geode.cache.query.internal.index.CompactRangeIndex.getSizeEstimate(CompactRangeIndex.java:331)
        at 
org.apache.geode.cache.query.internal.CompiledComparison.getSizeEstimate(CompiledComparison.java:337)
        at 
org.apache.geode.cache.query.internal.GroupJunction.organizeOperands(GroupJunction.java:146)
        at 
org.apache.geode.cache.query.internal.AbstractGroupOrRangeJunction.filterEvaluate(AbstractGroupOrRangeJunction.java:148)
        at 
org.apache.geode.cache.query.internal.CompiledJunction.filterEvaluate(CompiledJunction.java:190)
        at 
org.apache.geode.cache.query.internal.CompiledSelect.evaluate(CompiledSelect.java:538)
        at 
org.apache.geode.cache.query.internal.CompiledSelect.evaluate(CompiledSelect.java:53)
        at 
org.apache.geode.cache.query.internal.DefaultQuery.executeUsingContext(DefaultQuery.java:357)
        at 
org.apache.geode.internal.cache.PRQueryProcessor.executeQueryOnBuckets(PRQueryProcessor.java:248)
{noformat}
Here is an example query that fails:
{noformat}
SELECT * FROM /trade WHERE arrangementId = 'aId_1' AND tradeStatus.toString() 
!= 'CLOSED'
{noformat}
Here is a test that reproduces it:
 * start one server with region configured as PARTITION with:
 ** 2 buckets
 ** PartitionResolver that puts the first entry in bucket 0, every other entry 
in bucket 1
 * load N entries
 * the index in bucket 0 becomes the arbitraryBucketIndex
 * start a second server
 * rebalance
 * bucket 0 moves from the first server to the second server
 * run the query



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to