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.44 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to
         :content-type;
        b=XijhaAWZUKtx7bSIBiNbBoK2ebIuN3YBE3u6YoNFFzD85cQOHzRKTVpG8tYxARkghK
         qBYdXCfGq7gjmQ0NKk+gaWTBGkNtifGIxFcMvwYQ0lxbJfcupyf060lptJhjtBcInlEj
         Yo8oV2eV/8zOukIhOE+u/JsDUKKF9NAYDn2FY=
MIME-Version: 1.0
In-Reply-To: <BANLkTinAXWLi824vCsUer4Dyhoc5mLRv2Q@mail.gmail.com>
References: <BANLkTinAXWLi824vCsUer4Dyhoc5mLRv2Q@mail.gmail.com>
From: Jonathan Ellis <jbellis@gmail.com>
Date: Tue, 17 May 2011 11:08:43 -0500
Message-ID: <BANLkTikV2R8EOqmmK2ND+LEuXELiS8FGdw@mail.gmail.com>
Subject: Re: Inconsistent results using secondary indexes between two DC
To: user@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1

Nothing comes to mind.

I'd start by using sstable2json to see if the missing rows are in the
main data CF -- i.e., are they just unindexed, or are they missing
completely?

On Sun, May 15, 2011 at 4:33 PM, Wojciech Pietrzok <kosciak1@gmail.com> wrote:
> Hello,
>
> I've noticed strange behaviour of Cassandra when using secondary indexes.
> There are 2 Data Centers, each with 2 nodes, RF=4, on all nodes
> Cassandra 0.7.5 is installed.
> When I connect to one of the nodes in DC1 and perform query using
> secondary indexes ("get ColumnFamily where column = 'foo'" in
> cassandra-cli) I always get correct number of rows returned, no matter
> which ConsistencyLevel is set.
> When I connect to one of the nodes in DC2 and perform same query using
> ConsistencyLevel LOCAL_QUORUM the results are correct. But using
> ConsistencyLevel ONE Cassandra doesn't return correct number of rows
> (it seems that most of the times there some of the rows are missing).
> Tried running nodetool repair, and nodetool scrub but this doesn't seem to help.
>
> What might the cause of such behaviour?
>
> --
> KosciaK
>


-- 
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of DataStax, the source for professional Cassandra support
http://www.datastax.com