Hi, Looks like I was premature in my response.
I had cause today to wipe my datastore and restart cassandra and reload the .yaml containing the schema definition. After doing a restart of my app which essentially inserted into a CF with a 2ndary idx and then queried that CF I was left with log files full of the following. DEBUG [ReadStage:1] 2010-10-12 07:29:26,849 SliceQueryFilter.java (line 122) collecting 0 of 1: null:false:0...@1286840713 DEBUG [ReadStage:1] 2010-10-12 07:29:26,850 SliceQueryFilter.java (line 122) collecting 0 of 1: null:false:0...@1286840713 DEBUG [ReadStage:1] 2010-10-12 07:29:26,851 SliceQueryFilter.java (line 122) collecting 0 of 1: null:false:0...@1286840713 DEBUG [ReadStage:1] 2010-10-12 07:29:26,852 SliceQueryFilter.java (line 122) collecting 0 of 1: null:false:0...@1286840713 DEBUG [ReadStage:3] 2010-10-12 07:29:26,798 SliceQueryFilter.java (line 122) collecting 0 of 1: null:false:0...@1286840713 DEBUG [ReadStage:1] 2010-10-12 07:29:26,853 SliceQueryFilter.java (line 122) collecting 0 of 1: null:false:0...@1286840713 DEBUG [ReadStage:3] 2010-10-12 07:29:26,854 SliceQueryFilter.java (line 122) collecting 0 of 1: null:false:0...@1286840713 DEBUG [ReadStage:1] 2010-10-12 07:29:26,854 SliceQueryFilter.java (line 122) collecting 0 of 1: null:false:0...@1286840713 DEBUG [ReadStage:3] 2010-10-12 07:29:26,855 SliceQueryFilter.java (line 122) collecting 0 of 1: null:false:0...@1286840713 DEBUG [ReadStage:1] 2010-10-12 07:29:26,855 SliceQueryFilter.java (line 122) collecting 0 of 1: null:false:0...@1286840713 DEBUG [ReadStage:3] 2010-10-12 07:29:26,856 SliceQueryFilter.java (line 122) collecting 0 of 1: null:false:0...@1286840713 DEBUG [ReadStage:1] 2010-10-12 07:29:26,856 SliceQueryFilter.java (line 122) collecting 0 of 1: null:false:0...@1286840713 DEBUG [ReadStage:3] 2010-10-12 07:29:26,857 SliceQueryFilter.java (line 122) collecting 0 of 1: null:false:0...@1286840713 DEBUG [ReadStage:3] 2010-10-12 07:29:26,858 SliceQueryFilter.java (line 122) collecting 0 of 1: null:false:0...@1286840713 DEBUG [ReadStage:3] 2010-10-12 07:29:26,859 SliceQueryFilter.java (line 122) collecting 0 of 1: null:false:0...@1286840713 This resulted in timeouts in my app. Jason On Wed, Oct 6, 2010 at 7:11 PM, J T <jt4websi...@googlemail.com> wrote: > Hi, > > On a first pass, that patch seems to have solved the problem. > I'll be testing that functionality repeatedly in the next day or so I'll > let you know how it fairs. > > Thanks > > Jason > > > On Wed, Oct 6, 2010 at 4:06 PM, Stu Hood <stu.h...@rackspace.com> wrote: > >> Hey JT, >> >> I believe this issue should be fixed by CASSANDRA-1571... if you're able >> to test that patch, it would be very helpful. >> >> Thanks, >> Stu >> >> -----Original Message----- >> From: "J T" <jt4websi...@googlemail.com> >> Sent: Tuesday, October 5, 2010 9:50pm >> To: cassandra-u...@incubator.apache.org >> Subject: Null Pointer Exception / Secondary Indices >> >> Hi, >> >> I've been battling against some errors that only seem to crop up when I'm >> messing around with secondary indices in 0.7-beta2. >> >> Namely I seem to get errors like this start to happen, after I 'delete' a >> row in a CF that has a couple of secondary indices on it and then at some >> point later try to query for any rows from that CF. >> Usually I don;t get the Null pointer exception below, instead what often >> happens is that the SliceQueryFilter.java line before it, repeats itself >> forever bever stopping until I kill the server >> >> On this occasion I got a null pointer exception as well. This is on trunk >> as >> of tonight (but I was getting it over the weekend as well). >> >> DEBUG [pool-1-thread-149] 2010-10-06 03:43:15,436 ClientState.java (line >> 102) logged in: #<User allow_all groups=[]> >> DEBUG [pool-1-thread-99] 2010-10-06 03:43:15,444 CassandraServer.java >> (line >> 536) scan >> DEBUG [pool-1-thread-99] 2010-10-06 03:43:15,444 StorageProxy.java (line >> 571) computing restricted ranges for query [0,0] >> DEBUG [pool-1-thread-99] 2010-10-06 03:43:15,445 StorageProxy.java (line >> 583) Adding to restricted ranges >> (91870423363853801063842423182856312085,0] >> for >> >> (91870423363853801063842423182856312085,91870423363853801063842423182856312085] >> DEBUG [pool-1-thread-99] 2010-10-06 03:43:15,446 StorageProxy.java (line >> 583) Adding to restricted ranges >> (0,91870423363853801063842423182856312085] >> for >> >> (91870423363853801063842423182856312085,91870423363853801063842423182856312085] >> DEBUG [pool-1-thread-99] 2010-10-06 03:43:15,447 StorageProxy.java (line >> 617) Sorted ranges are [(0,91870423363853801063842423182856312085], >> (91870423363853801063842423182856312085,0]] >> DEBUG [pool-1-thread-99] 2010-10-06 03:43:15,447 StorageProxy.java (line >> 680) scan ranges are >> >> (0,91870423363853801063842423182856312085],(91870423363853801063842423182856312085,0] >> DEBUG [pool-1-thread-99] 2010-10-06 03:43:15,448 StorageProxy.java (line >> 700) reading org.apache.cassandra.db.indexscancomm...@1422265 from >> 1...@localhost/127.0.0.1 >> *DEBUG [ReadStage:24] 2010-10-06 03:43:15,450 SliceQueryFilter.java (line >> 122) collecting 0 of 1: null:false:0...@1286332576* >> ERROR [ReadStage:24] 2010-10-06 03:43:15,451 >> DebuggableThreadPoolExecutor.java (line 103) Error in ThreadPoolExecutor >> java.lang.RuntimeException: java.lang.NullPointerException >> at >> >> org.apache.cassandra.service.IndexScanVerbHandler.doVerb(IndexScanVerbHandler.java:50) >> at >> >> org.apache.cassandra.net.MessageDeliveryTask.run(MessageDeliveryTask.java:50) >> at >> >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) >> at >> >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) >> at java.lang.Thread.run(Thread.java:636) >> Caused by: java.lang.NullPointerException >> at >> >> org.apache.cassandra.db.ColumnFamilyStore.satisfies(ColumnFamilyStore.java:1297) >> at >> >> org.apache.cassandra.db.ColumnFamilyStore.scan(ColumnFamilyStore.java:1245) >> at >> >> org.apache.cassandra.service.IndexScanVerbHandler.doVerb(IndexScanVerbHandler.java:41) >> ... 4 more >> ERROR [ReadStage:24] 2010-10-06 03:43:15,453 AbstractCassandraDaemon.java >> (line 88) Fatal exception in thread Thread[ReadStage:24,5,main] >> java.lang.RuntimeException: java.lang.NullPointerException >> at >> >> org.apache.cassandra.service.IndexScanVerbHandler.doVerb(IndexScanVerbHandler.java:50) >> at >> >> org.apache.cassandra.net.MessageDeliveryTask.run(MessageDeliveryTask.java:50) >> at >> >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) >> at >> >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) >> at java.lang.Thread.run(Thread.java:636) >> Caused by: java.lang.NullPointerException >> at >> >> org.apache.cassandra.db.ColumnFamilyStore.satisfies(ColumnFamilyStore.java:1297) >> at >> >> org.apache.cassandra.db.ColumnFamilyStore.scan(ColumnFamilyStore.java:1245) >> at >> >> org.apache.cassandra.service.IndexScanVerbHandler.doVerb(IndexScanVerbHandler.java:41) >> ... 4 more >> >> >> >
