Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (nike.apache.org: domain of jbellis@gmail.com designates
 74.125.82.172 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type:content-transfer-encoding;
        b=hMltzfiTqzpJDRjOL6FY6w9sSHsbjWEX3yDYWK8PAe7olhUw3zabzOYjJNDTb9BWtm
         +MuIkt5bTsZL6WuNoxhoLc2LWNwgPRuv3VqU/+AeblfRkQjYJo1Q2rRMU0mXNOdvhYPy
         H2EkrIvih9/tGma5FaXrI8hGGExGjWOv9yiSs=
MIME-Version: 1.0
In-Reply-To: <AANLkTi=8MrgC1JRYhyKYBU-ARBdfPQnfpS0Lgr4BMzJs@mail.gmail.com>
References: <AANLkTinrLkysy5J+TJ92e2t+Lx=j08Wy8SciW+Kr_zPg@mail.gmail.com>
	<AANLkTim-mLHYPN5ZXoXs52x9MyqUPhU63k-BtAxYdRpG@mail.gmail.com>
	<AANLkTi=8MrgC1JRYhyKYBU-ARBdfPQnfpS0Lgr4BMzJs@mail.gmail.com>
Date: Fri, 15 Oct 2010 14:36:29 -0500
Message-ID: <AANLkTimM2f-oUBA39fprPrormOVk42c4bAcRZMBTk62q@mail.gmail.com>
Subject: Re: BUG: secondaryIndexes AND multiple index expressions THAT fail to
 match
From: Jonathan Ellis <jbellis@gmail.com>
To: user <user@cassandra.apache.org>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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 <jt4websites@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 scr=
ipt
> 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 <jbellis@gmail.com> wrote=
:
>>
>> can you create a ticket with a test case?
>>
>> On Fri, Oct 15, 2010 at 1:06 PM, J T <jt4websites@googlemail.com> wrote:
>> > Hi,
>> > If I do a secondary index look up =A0with 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( [ =A0{ SecondaryIndexedColumnName, "ColumnValue" } ] ).
>> > If a match is found then I get a valid result set, otherwise if no mat=
ch
>> > is
>> > found then I get an empty list. This is correct.
>> > lookup( [ =A0{ SecondaryIndexedColumnName, "eq", =A0"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:
>> >
>> > =A0INFO [ScheduledTasks:1] 2010-10-15 18:59:37,365 GCInspector.java (l=
ine
>> > 183)
>> > MyKeySpace.MessageLists =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A00,0=
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A00/25
>> > =A0 =A0 =A0 =A02/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=3D[]>
>> > DEBUG [pool-1-thread-2] 2010-10-15 19:00:19,616 ClientState.java (line
>> > 81)
>> > logged in: #<User allow_all groups=3D[]>
>> > DEBUG [pool-1-thread-3] 2010-10-15 19:00:19,626 ClientState.java (line
>> > 81)
>> > logged in: #<User allow_all groups=3D[]>
>> > DEBUG [pool-1-thread-4] 2010-10-15 19:00:19,632 ClientState.java (line
>> > 81)
>> > logged in: #<User allow_all groups=3D[]>
>> > DEBUG [pool-1-thread-5] 2010-10-15 19:00:19,640 ClientState.java (line
>> > 81)
>> > logged in: #<User allow_all groups=3D[]>
>> > DEBUG [pool-1-thread-6] 2010-10-15 19:00:19,650 ClientState.java (line
>> > 81)
>> > logged in: #<User allow_all groups=3D[]>
>> > DEBUG [pool-1-thread-7] 2010-10-15 19:00:19,656 ClientState.java (line
>> > 81)
>> > logged in: #<User allow_all groups=3D[]>
>> > DEBUG [pool-1-thread-8] 2010-10-15 19:00:19,667 ClientState.java (line
>> > 81)
>> > logged in: #<User allow_all groups=3D[]>
>> > DEBUG [pool-1-thread-9] 2010-10-15 19:00:19,677 ClientState.java (line
>> > 81)
>> > logged in: #<User allow_all groups=3D[]>
>> > DEBUG [pool-1-thread-10] 2010-10-15 19:00:19,684 ClientState.java (lin=
e
>> > 81)
>> > logged in: #<User allow_all groups=3D[]>
>> > 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 (li=
ne
>> > 563) restricted single token match for query [0,0]
>> > DEBUG [pool-1-thread-10] 2010-10-15 19:00:27,897 StorageProxy.java (li=
ne
>> > 649) scan ranges are [0,0]
>> > DEBUG [pool-1-thread-10] 2010-10-15 19:00:27,925 StorageProxy.java (li=
ne
>> > 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 (lin=
e
>> > 121)
>> > collecting 0 of 1: null:false:0@1287103291
>> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,933 SliceQueryFilter.java (lin=
e
>> > 121)
>> > collecting 0 of 2147483647: is_confirmed:false:4@1287103291
>> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,934 SliceQueryFilter.java (lin=
e
>> > 121)
>> > collecting 1 of 2147483647: request_type:false:6@1287103291
>> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,935 SliceQueryFilter.java (lin=
e
>> > 121)
>> > collecting 2 of 2147483647: requested:false:58@1287103291
>> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,935 SliceQueryFilter.java (lin=
e
>> > 121)
>> > collecting 3 of 2147483647: requested_network:false:57@1287103291
>> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,936 SliceQueryFilter.java (lin=
e
>> > 121)
>> > collecting 4 of 2147483647: requestor:false:58@1287103291
>> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,937 SliceQueryFilter.java (lin=
e
>> > 121)
>> > collecting 5 of 2147483647: requestor_network:false:57@1287103291
>> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,942 SliceQueryFilter.java (lin=
e
>> > 121)
>> > collecting 0 of 1: null:false:0@1287103291
>> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,943 SliceQueryFilter.java (lin=
e
>> > 121)
>> > collecting 0 of 1: null:false:0@1287103291
>> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,945 SliceQueryFilter.java (lin=
e
>> > 121)
>> > collecting 0 of 1: null:false:0@1287103291
>> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,946 SliceQueryFilter.java (lin=
e
>> > 121)
>> > collecting 0 of 1: null:false:0@1287103291
>> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,949 SliceQueryFilter.java (lin=
e
>> > 121)
>> > collecting 0 of 1: null:false:0@1287103291
>> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,953 SliceQueryFilter.java (lin=
e
>> > 121)
>> > collecting 0 of 1: null:false:0@1287103291
>> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,954 SliceQueryFilter.java (lin=
e
>> > 121)
>> > collecting 0 of 1: null:false:0@1287103291
>> > DEBUG [ReadStage:2] 2010-10-15 19:00:27,956 SliceQueryFilter.java (lin=
e
>> > 121)
>> > collecting 0 of 1: null:false:0@1287103291
>> >
>> > .. this last line repeats forever until I terminate cassandra and unti=
l
>> > 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
>
>


--=20
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of Riptano, the source for professional Cassandra support
http://riptano.com