You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by J T <jt...@googlemail.com> on 2010/10/15 20:06:12 UTC
BUG: secondaryIndexes AND multiple index expressions THAT fail to match
Hi,
If I do a secondary index look up with multiple index expressions (>1) that
do not result in a match then I get a looping entry in the log until I
terminate the cassandra server.
e.g. (I'll use a pseudo notation to indicate the examples)
lookup( [ { SecondaryIndexedColumnName, "ColumnValue" } ] ).
If a match is found then I get a valid result set, otherwise if no match is
found then I get an empty list. This is correct.
lookup( [ { SecondaryIndexedColumnName, "eq", "ColumnValue" }, {
NonIndexedColumnName, "eq", "Value" ] ).
If a match is found for both the first & the second index expression, then I
get a valid result set.
However, if a match is found on the SecondaryIndexColumnName but it is
discounted because it fails to match the second non-indexed column
expression then the thrift connection times out and if I look in the
cassandra server log I can see this:
INFO [ScheduledTasks:1] 2010-10-15 18:59:37,365 GCInspector.java (line 183)
MyKeySpace.MessageLists 0,0 0/25
2/25
DEBUG [ScheduledTasks:1] 2010-10-15 18:59:38,699 StorageLoadBalancer.java
(line 349) Disseminating load info ...
DEBUG [pool-1-thread-1] 2010-10-15 19:00:19,610 ClientState.java (line 81)
logged in: #<User allow_all groups=[]>
DEBUG [pool-1-thread-2] 2010-10-15 19:00:19,616 ClientState.java (line 81)
logged in: #<User allow_all groups=[]>
DEBUG [pool-1-thread-3] 2010-10-15 19:00:19,626 ClientState.java (line 81)
logged in: #<User allow_all groups=[]>
DEBUG [pool-1-thread-4] 2010-10-15 19:00:19,632 ClientState.java (line 81)
logged in: #<User allow_all groups=[]>
DEBUG [pool-1-thread-5] 2010-10-15 19:00:19,640 ClientState.java (line 81)
logged in: #<User allow_all groups=[]>
DEBUG [pool-1-thread-6] 2010-10-15 19:00:19,650 ClientState.java (line 81)
logged in: #<User allow_all groups=[]>
DEBUG [pool-1-thread-7] 2010-10-15 19:00:19,656 ClientState.java (line 81)
logged in: #<User allow_all groups=[]>
DEBUG [pool-1-thread-8] 2010-10-15 19:00:19,667 ClientState.java (line 81)
logged in: #<User allow_all groups=[]>
DEBUG [pool-1-thread-9] 2010-10-15 19:00:19,677 ClientState.java (line 81)
logged in: #<User allow_all groups=[]>
DEBUG [pool-1-thread-10] 2010-10-15 19:00:19,684 ClientState.java (line 81)
logged in: #<User allow_all groups=[]>
DEBUG [pool-1-thread-10] 2010-10-15 19:00:27,878 CassandraServer.java (line
531) scan
DEBUG [pool-1-thread-10] 2010-10-15 19:00:27,897 StorageProxy.java (line
563) restricted single token match for query [0,0]
DEBUG [pool-1-thread-10] 2010-10-15 19:00:27,897 StorageProxy.java (line
649) scan ranges are [0,0]
DEBUG [pool-1-thread-10] 2010-10-15 19:00:27,925 StorageProxy.java (line
669) reading org.apache.cassandra.db.IndexScanCommand@42a6eb from
52@localhost/127.0.0.1
DEBUG [ReadStage:2] 2010-10-15 19:00:27,931 SliceQueryFilter.java (line 121)
collecting 0 of 1: null:false:0@1287103291
DEBUG [ReadStage:2] 2010-10-15 19:00:27,933 SliceQueryFilter.java (line 121)
collecting 0 of 2147483647: is_confirmed:false:4@1287103291
DEBUG [ReadStage:2] 2010-10-15 19:00:27,934 SliceQueryFilter.java (line 121)
collecting 1 of 2147483647: request_type:false:6@1287103291
DEBUG [ReadStage:2] 2010-10-15 19:00:27,935 SliceQueryFilter.java (line 121)
collecting 2 of 2147483647: requested:false:58@1287103291
DEBUG [ReadStage:2] 2010-10-15 19:00:27,935 SliceQueryFilter.java (line 121)
collecting 3 of 2147483647: requested_network:false:57@1287103291
DEBUG [ReadStage:2] 2010-10-15 19:00:27,936 SliceQueryFilter.java (line 121)
collecting 4 of 2147483647: requestor:false:58@1287103291
DEBUG [ReadStage:2] 2010-10-15 19:00:27,937 SliceQueryFilter.java (line 121)
collecting 5 of 2147483647: requestor_network:false:57@1287103291
DEBUG [ReadStage:2] 2010-10-15 19:00:27,942 SliceQueryFilter.java (line 121)
collecting 0 of 1: null:false:0@1287103291
DEBUG [ReadStage:2] 2010-10-15 19:00:27,943 SliceQueryFilter.java (line 121)
collecting 0 of 1: null:false:0@1287103291
DEBUG [ReadStage:2] 2010-10-15 19:00:27,945 SliceQueryFilter.java (line 121)
collecting 0 of 1: null:false:0@1287103291
DEBUG [ReadStage:2] 2010-10-15 19:00:27,946 SliceQueryFilter.java (line 121)
collecting 0 of 1: null:false:0@1287103291
DEBUG [ReadStage:2] 2010-10-15 19:00:27,949 SliceQueryFilter.java (line 121)
collecting 0 of 1: null:false:0@1287103291
DEBUG [ReadStage:2] 2010-10-15 19:00:27,953 SliceQueryFilter.java (line 121)
collecting 0 of 1: null:false:0@1287103291
DEBUG [ReadStage:2] 2010-10-15 19:00:27,954 SliceQueryFilter.java (line 121)
collecting 0 of 1: null:false:0@1287103291
DEBUG [ReadStage:2] 2010-10-15 19:00:27,956 SliceQueryFilter.java (line 121)
collecting 0 of 1: null:false:0@1287103291
.. this last line repeats forever until I terminate cassandra and until I do
that all subsequent client connection operations timeout.
This is on a single server setup.
Re: BUG: secondaryIndexes AND multiple index expressions THAT fail to match
Posted by Jonathan Ellis <jb...@gmail.com>.
Sounds good. You're right, CLI doesn't support this yet (but will shortly!)
On Fri, Oct 15, 2010 at 2:30 PM, J T <jt...@googlemail.com> wrote:
> Hmm, I don't have a java client that does all this. All of my stuff is in
> erlang using the thrift client.
> I can certainly raise a ticket and describe the problem though.
> If the CLI supported querying by index I'd see if I could knock up an script
> that did it but I don't think it does.
> If you wanted a Java test case it would take me quite a while as I am
> completely unfamiliar with the Java client api.
> I'll raise a descriptive ticket for now and see where we go from there.
> Jason
>
> On Fri, Oct 15, 2010 at 7:12 PM, Jonathan Ellis <jb...@gmail.com> wrote:
>>
>> can you create a ticket with a test case?
>>
>> On Fri, Oct 15, 2010 at 1:06 PM, J T <jt...@googlemail.com> wrote:
>> > Hi,
>> > If I do a secondary index look up with multiple index expressions (>1)
>> > that
>> > do not result in a match then I get a looping entry in the log until I
>> > terminate the cassandra server.
>> > e.g. (I'll use a pseudo notation to indicate the examples)
>> > lookup( [ { SecondaryIndexedColumnName, "ColumnValue" } ] ).
>> > If a match is found then I get a valid result set, otherwise if no match
>> > is
>> > found then I get an empty list. This is correct.
>> > lookup( [ { SecondaryIndexedColumnName, "eq", "ColumnValue" }, {
>> > NonIndexedColumnName, "eq", "Value" ] ).
>> > If a match is found for both the first & the second index expression,
>> > then I
>> > get a valid result set.
>> > However, if a match is found on the SecondaryIndexColumnName but it is
>> > discounted because it fails to match the second non-indexed column
>> > expression then the thrift connection times out and if I look in the
>> > cassandra server log I can see this:
>> >
>> > INFO [ScheduledTasks:1] 2010-10-15 18:59:37,365 GCInspector.java (line
>> > 183)
>> > MyKeySpace.MessageLists 0,0 0/25
>> > 2/25
>> > DEBUG [ScheduledTasks:1] 2010-10-15 18:59:38,699
>> > StorageLoadBalancer.java
>> > (line 349) Disseminating load info ...
>> > DEBUG [pool-1-thread-1] 2010-10-15 19:00:19,610 ClientState.java (line
>> > 81)
>> > logged in: #<User allow_all groups=[]>
>> > DEBUG [pool-1-thread-2] 2010-10-15 19:00:19,616 ClientState.java (line
>> > 81)
>> > logged in: #<User allow_all groups=[]>
>> > DEBUG [pool-1-thread-3] 2010-10-15 19:00:19,626 ClientState.java (line
>> > 81)
>> > logged in: #<User allow_all groups=[]>
>> > DEBUG [pool-1-thread-4] 2010-10-15 19:00:19,632 ClientState.java (line
>> > 81)
>> > logged in: #<User allow_all groups=[]>
>> > DEBUG [pool-1-thread-5] 2010-10-15 19:00:19,640 ClientState.java (line
>> > 81)
>> > logged in: #<User allow_all groups=[]>
>> > DEBUG [pool-1-thread-6] 2010-10-15 19:00:19,650 ClientState.java (line
>> > 81)
>> > logged in: #<User allow_all groups=[]>
>> > DEBUG [pool-1-thread-7] 2010-10-15 19:00:19,656 ClientState.java (line
>> > 81)
>> > logged in: #<User allow_all groups=[]>
>> > DEBUG [pool-1-thread-8] 2010-10-15 19:00:19,667 ClientState.java (line
>> > 81)
>> > logged in: #<User allow_all groups=[]>
>> > DEBUG [pool-1-thread-9] 2010-10-15 19:00:19,677 ClientState.java (line
>> > 81)
>> > logged in: #<User allow_all groups=[]>
>> > DEBUG [pool-1-thread-10] 2010-10-15 19:00:19,684 ClientState.java (line
>> > 81)
>> > logged in: #<User allow_all groups=[]>
>> > DEBUG [pool-1-thread-10] 2010-10-15 19:00:27,878 CassandraServer.java
>> > (line
>> > 531) scan
>> > DEBUG [pool-1-thread-10] 2010-10-15 19:00:27,897 StorageProxy.java (line
>> > 563) restricted single token match for query [0,0]
>> > DEBUG [pool-1-thread-10] 2010-10-15 19:00:27,897 StorageProxy.java (line
>> > 649) scan ranges are [0,0]
>> > DEBUG [pool-1-thread-10] 2010-10-15 19:00:27,925 StorageProxy.java (line
>> > 669) reading org.apache.cassandra.db.IndexScanCommand@42a6eb from
>> > 52@localhost/127.0.0.1
>> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,931 SliceQueryFilter.java (line
>> > 121)
>> > collecting 0 of 1: null:false:0@1287103291
>> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,933 SliceQueryFilter.java (line
>> > 121)
>> > collecting 0 of 2147483647: is_confirmed:false:4@1287103291
>> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,934 SliceQueryFilter.java (line
>> > 121)
>> > collecting 1 of 2147483647: request_type:false:6@1287103291
>> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,935 SliceQueryFilter.java (line
>> > 121)
>> > collecting 2 of 2147483647: requested:false:58@1287103291
>> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,935 SliceQueryFilter.java (line
>> > 121)
>> > collecting 3 of 2147483647: requested_network:false:57@1287103291
>> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,936 SliceQueryFilter.java (line
>> > 121)
>> > collecting 4 of 2147483647: requestor:false:58@1287103291
>> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,937 SliceQueryFilter.java (line
>> > 121)
>> > collecting 5 of 2147483647: requestor_network:false:57@1287103291
>> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,942 SliceQueryFilter.java (line
>> > 121)
>> > collecting 0 of 1: null:false:0@1287103291
>> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,943 SliceQueryFilter.java (line
>> > 121)
>> > collecting 0 of 1: null:false:0@1287103291
>> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,945 SliceQueryFilter.java (line
>> > 121)
>> > collecting 0 of 1: null:false:0@1287103291
>> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,946 SliceQueryFilter.java (line
>> > 121)
>> > collecting 0 of 1: null:false:0@1287103291
>> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,949 SliceQueryFilter.java (line
>> > 121)
>> > collecting 0 of 1: null:false:0@1287103291
>> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,953 SliceQueryFilter.java (line
>> > 121)
>> > collecting 0 of 1: null:false:0@1287103291
>> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,954 SliceQueryFilter.java (line
>> > 121)
>> > collecting 0 of 1: null:false:0@1287103291
>> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,956 SliceQueryFilter.java (line
>> > 121)
>> > collecting 0 of 1: null:false:0@1287103291
>> >
>> > .. this last line repeats forever until I terminate cassandra and until
>> > I do
>> > that all subsequent client connection operations timeout.
>> > This is on a single server setup.
>> >
>> >
>>
>>
>>
>> --
>> Jonathan Ellis
>> Project Chair, Apache Cassandra
>> co-founder of Riptano, the source for professional Cassandra support
>> http://riptano.com
>
>
--
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of Riptano, the source for professional Cassandra support
http://riptano.com
Re: BUG: secondaryIndexes AND multiple index expressions THAT fail to match
Posted by J T <jt...@googlemail.com>.
Hmm, I don't have a java client that does all this. All of my stuff is in
erlang using the thrift client.
I can certainly raise a ticket and describe the problem though.
If the CLI supported querying by index I'd see if I could knock up an script
that did it but I don't think it does.
If you wanted a Java test case it would take me quite a while as I am
completely unfamiliar with the Java client api.
I'll raise a descriptive ticket for now and see where we go from there.
Jason
On Fri, Oct 15, 2010 at 7:12 PM, Jonathan Ellis <jb...@gmail.com> wrote:
> can you create a ticket with a test case?
>
> On Fri, Oct 15, 2010 at 1:06 PM, J T <jt...@googlemail.com> wrote:
> > Hi,
> > If I do a secondary index look up with multiple index expressions (>1)
> that
> > do not result in a match then I get a looping entry in the log until I
> > terminate the cassandra server.
> > e.g. (I'll use a pseudo notation to indicate the examples)
> > lookup( [ { SecondaryIndexedColumnName, "ColumnValue" } ] ).
> > If a match is found then I get a valid result set, otherwise if no match
> is
> > found then I get an empty list. This is correct.
> > lookup( [ { SecondaryIndexedColumnName, "eq", "ColumnValue" }, {
> > NonIndexedColumnName, "eq", "Value" ] ).
> > If a match is found for both the first & the second index expression,
> then I
> > get a valid result set.
> > However, if a match is found on the SecondaryIndexColumnName but it is
> > discounted because it fails to match the second non-indexed column
> > expression then the thrift connection times out and if I look in the
> > cassandra server log I can see this:
> >
> > INFO [ScheduledTasks:1] 2010-10-15 18:59:37,365 GCInspector.java (line
> 183)
> > MyKeySpace.MessageLists 0,0 0/25
> > 2/25
> > DEBUG [ScheduledTasks:1] 2010-10-15 18:59:38,699 StorageLoadBalancer.java
> > (line 349) Disseminating load info ...
> > DEBUG [pool-1-thread-1] 2010-10-15 19:00:19,610 ClientState.java (line
> 81)
> > logged in: #<User allow_all groups=[]>
> > DEBUG [pool-1-thread-2] 2010-10-15 19:00:19,616 ClientState.java (line
> 81)
> > logged in: #<User allow_all groups=[]>
> > DEBUG [pool-1-thread-3] 2010-10-15 19:00:19,626 ClientState.java (line
> 81)
> > logged in: #<User allow_all groups=[]>
> > DEBUG [pool-1-thread-4] 2010-10-15 19:00:19,632 ClientState.java (line
> 81)
> > logged in: #<User allow_all groups=[]>
> > DEBUG [pool-1-thread-5] 2010-10-15 19:00:19,640 ClientState.java (line
> 81)
> > logged in: #<User allow_all groups=[]>
> > DEBUG [pool-1-thread-6] 2010-10-15 19:00:19,650 ClientState.java (line
> 81)
> > logged in: #<User allow_all groups=[]>
> > DEBUG [pool-1-thread-7] 2010-10-15 19:00:19,656 ClientState.java (line
> 81)
> > logged in: #<User allow_all groups=[]>
> > DEBUG [pool-1-thread-8] 2010-10-15 19:00:19,667 ClientState.java (line
> 81)
> > logged in: #<User allow_all groups=[]>
> > DEBUG [pool-1-thread-9] 2010-10-15 19:00:19,677 ClientState.java (line
> 81)
> > logged in: #<User allow_all groups=[]>
> > DEBUG [pool-1-thread-10] 2010-10-15 19:00:19,684 ClientState.java (line
> 81)
> > logged in: #<User allow_all groups=[]>
> > DEBUG [pool-1-thread-10] 2010-10-15 19:00:27,878 CassandraServer.java
> (line
> > 531) scan
> > DEBUG [pool-1-thread-10] 2010-10-15 19:00:27,897 StorageProxy.java (line
> > 563) restricted single token match for query [0,0]
> > DEBUG [pool-1-thread-10] 2010-10-15 19:00:27,897 StorageProxy.java (line
> > 649) scan ranges are [0,0]
> > DEBUG [pool-1-thread-10] 2010-10-15 19:00:27,925 StorageProxy.java (line
> > 669) reading org.apache.cassandra.db.IndexScanCommand@42a6eb from
> > 52@localhost/127.0.0.1
> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,931 SliceQueryFilter.java (line
> 121)
> > collecting 0 of 1: null:false:0@1287103291
> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,933 SliceQueryFilter.java (line
> 121)
> > collecting 0 of 2147483647: is_confirmed:false:4@1287103291
> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,934 SliceQueryFilter.java (line
> 121)
> > collecting 1 of 2147483647: request_type:false:6@1287103291
> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,935 SliceQueryFilter.java (line
> 121)
> > collecting 2 of 2147483647: requested:false:58@1287103291
> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,935 SliceQueryFilter.java (line
> 121)
> > collecting 3 of 2147483647: requested_network:false:57@1287103291
> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,936 SliceQueryFilter.java (line
> 121)
> > collecting 4 of 2147483647: requestor:false:58@1287103291
> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,937 SliceQueryFilter.java (line
> 121)
> > collecting 5 of 2147483647: requestor_network:false:57@1287103291
> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,942 SliceQueryFilter.java (line
> 121)
> > collecting 0 of 1: null:false:0@1287103291
> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,943 SliceQueryFilter.java (line
> 121)
> > collecting 0 of 1: null:false:0@1287103291
> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,945 SliceQueryFilter.java (line
> 121)
> > collecting 0 of 1: null:false:0@1287103291
> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,946 SliceQueryFilter.java (line
> 121)
> > collecting 0 of 1: null:false:0@1287103291
> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,949 SliceQueryFilter.java (line
> 121)
> > collecting 0 of 1: null:false:0@1287103291
> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,953 SliceQueryFilter.java (line
> 121)
> > collecting 0 of 1: null:false:0@1287103291
> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,954 SliceQueryFilter.java (line
> 121)
> > collecting 0 of 1: null:false:0@1287103291
> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,956 SliceQueryFilter.java (line
> 121)
> > collecting 0 of 1: null:false:0@1287103291
> >
> > .. this last line repeats forever until I terminate cassandra and until I
> do
> > that all subsequent client connection operations timeout.
> > This is on a single server setup.
> >
> >
>
>
>
> --
> Jonathan Ellis
> Project Chair, Apache Cassandra
> co-founder of Riptano, the source for professional Cassandra support
> http://riptano.com
>
Re: BUG: secondaryIndexes AND multiple index expressions THAT fail to match
Posted by Jonathan Ellis <jb...@gmail.com>.
can you create a ticket with a test case?
On Fri, Oct 15, 2010 at 1:06 PM, J T <jt...@googlemail.com> wrote:
> Hi,
> If I do a secondary index look up with multiple index expressions (>1) that
> do not result in a match then I get a looping entry in the log until I
> terminate the cassandra server.
> e.g. (I'll use a pseudo notation to indicate the examples)
> lookup( [ { SecondaryIndexedColumnName, "ColumnValue" } ] ).
> If a match is found then I get a valid result set, otherwise if no match is
> found then I get an empty list. This is correct.
> lookup( [ { SecondaryIndexedColumnName, "eq", "ColumnValue" }, {
> NonIndexedColumnName, "eq", "Value" ] ).
> If a match is found for both the first & the second index expression, then I
> get a valid result set.
> However, if a match is found on the SecondaryIndexColumnName but it is
> discounted because it fails to match the second non-indexed column
> expression then the thrift connection times out and if I look in the
> cassandra server log I can see this:
>
> INFO [ScheduledTasks:1] 2010-10-15 18:59:37,365 GCInspector.java (line 183)
> MyKeySpace.MessageLists 0,0 0/25
> 2/25
> DEBUG [ScheduledTasks:1] 2010-10-15 18:59:38,699 StorageLoadBalancer.java
> (line 349) Disseminating load info ...
> DEBUG [pool-1-thread-1] 2010-10-15 19:00:19,610 ClientState.java (line 81)
> logged in: #<User allow_all groups=[]>
> DEBUG [pool-1-thread-2] 2010-10-15 19:00:19,616 ClientState.java (line 81)
> logged in: #<User allow_all groups=[]>
> DEBUG [pool-1-thread-3] 2010-10-15 19:00:19,626 ClientState.java (line 81)
> logged in: #<User allow_all groups=[]>
> DEBUG [pool-1-thread-4] 2010-10-15 19:00:19,632 ClientState.java (line 81)
> logged in: #<User allow_all groups=[]>
> DEBUG [pool-1-thread-5] 2010-10-15 19:00:19,640 ClientState.java (line 81)
> logged in: #<User allow_all groups=[]>
> DEBUG [pool-1-thread-6] 2010-10-15 19:00:19,650 ClientState.java (line 81)
> logged in: #<User allow_all groups=[]>
> DEBUG [pool-1-thread-7] 2010-10-15 19:00:19,656 ClientState.java (line 81)
> logged in: #<User allow_all groups=[]>
> DEBUG [pool-1-thread-8] 2010-10-15 19:00:19,667 ClientState.java (line 81)
> logged in: #<User allow_all groups=[]>
> DEBUG [pool-1-thread-9] 2010-10-15 19:00:19,677 ClientState.java (line 81)
> logged in: #<User allow_all groups=[]>
> DEBUG [pool-1-thread-10] 2010-10-15 19:00:19,684 ClientState.java (line 81)
> logged in: #<User allow_all groups=[]>
> DEBUG [pool-1-thread-10] 2010-10-15 19:00:27,878 CassandraServer.java (line
> 531) scan
> DEBUG [pool-1-thread-10] 2010-10-15 19:00:27,897 StorageProxy.java (line
> 563) restricted single token match for query [0,0]
> DEBUG [pool-1-thread-10] 2010-10-15 19:00:27,897 StorageProxy.java (line
> 649) scan ranges are [0,0]
> DEBUG [pool-1-thread-10] 2010-10-15 19:00:27,925 StorageProxy.java (line
> 669) reading org.apache.cassandra.db.IndexScanCommand@42a6eb from
> 52@localhost/127.0.0.1
> DEBUG [ReadStage:2] 2010-10-15 19:00:27,931 SliceQueryFilter.java (line 121)
> collecting 0 of 1: null:false:0@1287103291
> DEBUG [ReadStage:2] 2010-10-15 19:00:27,933 SliceQueryFilter.java (line 121)
> collecting 0 of 2147483647: is_confirmed:false:4@1287103291
> DEBUG [ReadStage:2] 2010-10-15 19:00:27,934 SliceQueryFilter.java (line 121)
> collecting 1 of 2147483647: request_type:false:6@1287103291
> DEBUG [ReadStage:2] 2010-10-15 19:00:27,935 SliceQueryFilter.java (line 121)
> collecting 2 of 2147483647: requested:false:58@1287103291
> DEBUG [ReadStage:2] 2010-10-15 19:00:27,935 SliceQueryFilter.java (line 121)
> collecting 3 of 2147483647: requested_network:false:57@1287103291
> DEBUG [ReadStage:2] 2010-10-15 19:00:27,936 SliceQueryFilter.java (line 121)
> collecting 4 of 2147483647: requestor:false:58@1287103291
> DEBUG [ReadStage:2] 2010-10-15 19:00:27,937 SliceQueryFilter.java (line 121)
> collecting 5 of 2147483647: requestor_network:false:57@1287103291
> DEBUG [ReadStage:2] 2010-10-15 19:00:27,942 SliceQueryFilter.java (line 121)
> collecting 0 of 1: null:false:0@1287103291
> DEBUG [ReadStage:2] 2010-10-15 19:00:27,943 SliceQueryFilter.java (line 121)
> collecting 0 of 1: null:false:0@1287103291
> DEBUG [ReadStage:2] 2010-10-15 19:00:27,945 SliceQueryFilter.java (line 121)
> collecting 0 of 1: null:false:0@1287103291
> DEBUG [ReadStage:2] 2010-10-15 19:00:27,946 SliceQueryFilter.java (line 121)
> collecting 0 of 1: null:false:0@1287103291
> DEBUG [ReadStage:2] 2010-10-15 19:00:27,949 SliceQueryFilter.java (line 121)
> collecting 0 of 1: null:false:0@1287103291
> DEBUG [ReadStage:2] 2010-10-15 19:00:27,953 SliceQueryFilter.java (line 121)
> collecting 0 of 1: null:false:0@1287103291
> DEBUG [ReadStage:2] 2010-10-15 19:00:27,954 SliceQueryFilter.java (line 121)
> collecting 0 of 1: null:false:0@1287103291
> DEBUG [ReadStage:2] 2010-10-15 19:00:27,956 SliceQueryFilter.java (line 121)
> collecting 0 of 1: null:false:0@1287103291
>
> .. this last line repeats forever until I terminate cassandra and until I do
> that all subsequent client connection operations timeout.
> This is on a single server setup.
>
>
--
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of Riptano, the source for professional Cassandra support
http://riptano.com