incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Eran Chinthaka Withana <>
Subject Fixing / Rebuilding Secondary Index
Date Wed, 14 Nov 2012 19:50:25 GMT

I have a secondary index for a column family which is connected to a
keyspace that spans over three data centers. I observed that the index is
not complete on one of the data centers. Reason for that conclusion is, I
tried to retrieve an object, using the secondary index, in DC1 and it was a
success. Then I used a node in DC2 to retrieve the object the same way but
it returned nothing.

Can someone please help me to understand why this is happening and how I
can fix this? Yesterday, through #cassandra IRC, I learnt that one can
initiate a secondary index re-build by calling a refresh (and copying a new
sstable) and I did just that. But for about 12 hours the secondary index
has completed only 3%.

I use Cassandra 1.0.7 and use CL of ONE for my read requests.

Finally, since I want to fix this issue faster, I am thinking of either

   1. copying full copy of data from DC1 into each and every node in DC2
   and start a cleanup/repair, or
   2. drop the secondary index and re-create it using "update column
   family" in CLI

What do you think about those approaches?

Eran Chinthaka Withana

View raw message