Hi, 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? Thanks, Eran Chinthaka Withana
