cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Wojciech Pietrzok <>
Subject Inconsistent results using secondary indexes between two DC
Date Sun, 15 May 2011 21:33:58 GMT

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?


View raw message