[ https://issues.apache.org/jira/browse/CASSANDRA-2964?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13072326#comment-13072326 ]
Roland Gude commented on CASSANDRA-2964: ---------------------------------------- some log output from when the above testcase fails (the columnfamily name is different from the one in the testcase, because it is the original system - i have not yet been able to reproduce the issue on any other system) DEBUG [pool-1-thread-8858] 2011-07-28 14:45:19,103 CassandraServer.java (line 522) scan DEBUG [pool-1-thread-8858] 2011-07-28 14:45:19,103 StorageProxy.java (line 666) restricted ranges for query [-1,-1] are [[-1,0], (0,42535295865117307932921825928971026432], (425352958651173079329218259289710 26432,85070591730234615865843651857942052864], (85070591730234615865843651857942052864,127605887595351923798765477786913079296], (127605887595351923798765477786913079296,-1]] DEBUG [pool-1-thread-8858] 2011-07-28 14:45:19,103 StorageProxy.java (line 753) scan ranges are [-1,0],(0,42535295865117307932921825928971026432],(42535295865117307932921825928971026432,850705917302346158658 43651857942052864],(85070591730234615865843651857942052864,127605887595351923798765477786913079296],(127605887595351923798765477786913079296,-1] DEBUG [pool-1-thread-8858] 2011-07-28 14:45:19,104 ReadCallback.java (line 86) Blockfor/repair is 2/false; setting up requests to /10.234.81.208,/10.226.130.128 DEBUG [pool-1-thread-8858] 2011-07-28 14:45:19,107 StorageProxy.java (line 780) reading org.apache.cassandra.db.IndexScanCommand@31bcc110 from /10.234.81.208 DEBUG [pool-1-thread-8858] 2011-07-28 14:45:19,107 StorageProxy.java (line 780) reading org.apache.cassandra.db.IndexScanCommand@31bcc110 from /10.226.130.128 DEBUG [ReadStage:563] 2011-07-28 14:45:19,107 ColumnFamilyStore.java (line 1514) Primary scan clause is 00000000-0000-1000-0000-000000000000 DEBUG [ReadStage:563] 2011-07-28 14:45:19,108 ColumnFamilyStore.java (line 1569) Scanning index 'EventsByUser.00000000-0000-1000-0000-000000000000 EQ 41' starting with DEBUG [ReadStage:563] 2011-07-28 14:45:19,108 SliceQueryFilter.java (line 123) collecting 0 of 100: 74657374526573756c74446f6573436f6e7461696e436f727265637452616e67654578636c7564696e67496e6465786564526f77:fa lse:0@1311857119516000 DEBUG [ReadStage:555] 2011-07-28 14:45:19,173 ColumnFamilyStore.java (line 1581) fetched ColumnFamily(<anonymous> [74657374526573756c74446f6573436f6e7461696e436f727265637452616e67654578636c7564696e67496e6465 786564526f77:false:0@1311857119516000,]) DEBUG [ReadStage:555] 2011-07-28 14:45:19,173 IndexScanVerbHandler.java (line 46) Sending RangeSliceReply{rows=} to 14083152@/10.234.81.208 DEBUG [RequestResponseStage:3] 2011-07-28 14:45:19,173 ResponseVerbHandler.java (line 48) Processing response on a callback from 14083152@/10.234.81.208 DEBUG [pool-1-thread-8858] 2011-07-28 14:45:19,173 StorageProxy.java (line 780) reading org.apache.cassandra.db.IndexScanCommand@22bb5662 from /10.234.81.208 DEBUG [pool-1-thread-8858] 2011-07-28 14:45:19,173 StorageProxy.java (line 780) reading org.apache.cassandra.db.IndexScanCommand@22bb5662 from /10.227.141.155 DEBUG [RequestResponseStage:4] 2011-07-28 14:45:19,175 ResponseVerbHandler.java (line 48) Processing response on a callback from 14083153@/10.227.141.155 DEBUG [pool-1-thread-8858] 2011-07-28 14:45:19,175 ReadCallback.java (line 86) Blockfor/repair is 2/false; setting up requests to /10.234.81.208,/10.226.130.128 DEBUG [ReadStage:560] 2011-07-28 14:45:19,175 ColumnFamilyStore.java (line 1514) Primary scan clause is 00000000-0000-1000-0000-000000000000 DEBUG [ReadStage:560] 2011-07-28 14:45:19,176 ColumnFamilyStore.java (line 1569) Scanning index 'EventsByUser.00000000-0000-1000-0000-000000000000 EQ 41' starting with DEBUG [ReadStage:560] 2011-07-28 14:45:19,176 SliceQueryFilter.java (line 123) collecting 0 of 100: 74657374526573756c74446f6573436f6e7461696e436f727265637452616e67654578636c7564696e67496e6465786564526f77:fa lse:0@1311857119516000 DEBUG [ReadStage:560] 2011-07-28 14:45:19,176 ColumnFamilyStore.java (line 1581) fetched ColumnFamily(<anonymous> [74657374526573756c74446f6573436f6e7461696e436f727265637452616e67654578636c7564696e67496e6465 786564526f77:false:0@1311857119516000,]) DEBUG [ReadStage:560] 2011-07-28 14:45:19,176 SliceQueryFilter.java (line 123) collecting 0 of 1000: 8ab6d400-1dd2-11b2-8bac-0024e8e90693:true:4@1311850071466000 DEBUG [ReadStage:560] 2011-07-28 14:45:19,177 SliceQueryFilter.java (line 123) collecting 0 of 1000: 8ab6d400-1dd2-11b2-93fb-0024e8e90693:true:4@1311849715863000 DEBUG [ReadStage:560] 2011-07-28 14:45:19,177 SliceQueryFilter.java (line 123) collecting 0 of 1000: 8ab6d400-1dd2-11b2-ba61-0024e8e90693:false:0@1311857119500000 DEBUG [ReadStage:560] 2011-07-28 14:45:19,177 ColumnFamilyStore.java (line 1605) fetched data row ColumnFamily(EventsByUser -deleted at 1311849448186000- [8ab6d400-1dd2-11b2-8bac-0024e8e90693:true:4@13118500 71466000,8ab6d400-1dd2-11b2-93fb-0024e8e90693:true:4@1311849715863000,8ab6d400-1dd2-11b2-ba61-0024e8e90693:false:0@1311857119500000,]) DEBUG [ReadStage:560] 2011-07-28 14:45:19,177 ColumnFamilyStore.java (line 1616) adding extraFilter to cover additional expressions DEBUG [pool-1-thread-8858] 2011-07-28 14:45:19,177 StorageProxy.java (line 780) reading org.apache.cassandra.db.IndexScanCommand@39244dbe from /10.234.81.208 DEBUG [pool-1-thread-8858] 2011-07-28 14:45:19,177 StorageProxy.java (line 780) reading org.apache.cassandra.db.IndexScanCommand@39244dbe from /10.226.130.128 DEBUG [ReadStage:560] 2011-07-28 14:45:19,177 ColumnFamilyStore.java (line 1640) row ColumnFamily(EventsByUser -deleted at 1311849448186000- [00000000-0000-1000-0000-000000000000:false:1@1311857119516000,8ab 6d400-1dd2-11b2-8bac-0024e8e90693:true:4@1311850071466000,8ab6d400-1dd2-11b2-93fb-0024e8e90693:true:4@1311849715863000,8ab6d400-1dd2-11b2-ba61-0024e8e90693:false:0@1311857119500000,]) satisfies all clauses DEBUG [ReadStage:560] 2011-07-28 14:45:19,177 IndexScanVerbHandler.java (line 46) Sending RangeSliceReply{rows=Row(key=DecoratedKey(162359547821047417387034252314579509322, 74657374526573756c74446f6573436f6e 7461696e436f727265637452616e67654578636c7564696e67496e6465786564526f77), cf=ColumnFamily(EventsByUser -deleted at 1311849448186000- [00000000-0000-1000-0000-000000000000:false:1@1311857119516000,8ab6d400-1dd 2-11b2-8bac-0024e8e90693:true:4@1311850071466000,8ab6d400-1dd2-11b2-93fb-0024e8e90693:true:4@1311849715863000,8ab6d400-1dd2-11b2-ba61-0024e8e90693:false:0@1311857119500000,]))} to 14083154@/10.234.81.208 DEBUG [RequestResponseStage:3] 2011-07-28 14:45:19,178 ResponseVerbHandler.java (line 48) Processing response on a callback from 14083154@/10.234.81.208 DEBUG [RequestResponseStage:4] 2011-07-28 14:45:19,180 ResponseVerbHandler.java (line 48) Processing response on a callback from 14083155@/10.226.130.128 DEBUG [pool-1-thread-8858] 2011-07-28 14:45:19,181 SliceQueryFilter.java (line 123) collecting 0 of 2147483647: 00000000-0000-1000-0000-000000000000:false:1@1311857119516000 DEBUG [pool-1-thread-8858] 2011-07-28 14:45:19,181 SliceQueryFilter.java (line 123) collecting 1 of 2147483647: 8ab6d400-1dd2-11b2-8bac-0024e8e90693:true:4@1311850071466000 DEBUG [pool-1-thread-8858] 2011-07-28 14:45:19,181 SliceQueryFilter.java (line 123) collecting 1 of 2147483647: 8ab6d400-1dd2-11b2-93fb-0024e8e90693:true:4@1311849715863000 DEBUG [pool-1-thread-8858] 2011-07-28 14:45:19,181 SliceQueryFilter.java (line 123) collecting 1 of 2147483647: 8ab6d400-1dd2-11b2-ba61-0024e8e90693:false:0@1311857119500000 DEBUG [pool-1-thread-8858] 2011-07-28 14:45:19,181 StorageProxy.java (line 788) read Row(key=DecoratedKey(162359547821047417387034252314579509322, 74657374526573756c74446f6573436f6e7461696e436f72726563745261 6e67654578636c7564696e67496e6465786564526f77), cf=ColumnFamily(EventsByUser -deleted at 1311849448186000- [00000000-0000-1000-0000-000000000000:false:1@1311857119516000,8ab6d400-1dd2-11b2-8bac-0024e8e90693:t rue:4@1311850071466000,8ab6d400-1dd2-11b2-93fb-0024e8e90693:true:4@1311849715863000,8ab6d400-1dd2-11b2-ba61-0024e8e90693:false:0@1311857119500000,])) DEBUG [pool-1-thread-27] 2011-07-28 14:45:19,211 StorageService.java (line 1456) computing ranges for 0, 42535295865117307932921825928971026432, 85070591730234615865843651857942052864, 1276058875953519237987 65477786913079296 > IndexRangeSliceQuery results include index column even though it is not in > SliceRange > ------------------------------------------------------------------------------------- > > Key: CASSANDRA-2964 > URL: https://issues.apache.org/jira/browse/CASSANDRA-2964 > Project: Cassandra > Issue Type: Bug > Affects Versions: 0.7.7 > Reporter: Roland Gude > Attachments: TestIndexRangeSliceQuery.java, cassandra.yaml > > > When an IndexSlicwQuery is done the result contains the index column even > though it was not in the slice range. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira