Re: Secondary index partially created

2012-08-27 Thread Richard Crowley
On Mon, Aug 27, 2012 at 12:59 AM, aaron morton wrote: > If you are still having problems can you post the query and the output from > nodetool cfstats on one of the nodes that fails ? driftx got me sorted. It escaped me that a rolling restart was necessary to build secondary indexes, which was m

Re: Secondary index partially created

2012-08-27 Thread aaron morton
If you are still having problems can you post the query and the output from nodetool cfstats on one of the nodes that fails ? cfstats will tell us if the secondary index was built. Cheers - Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 25/08/2

Re: Secondary index partially created

2012-08-24 Thread Roshni Rajagopal
What does List my_column_family in CLI show on all the nodes? Perhaps the syntax u're using isn't correct? You should be getting the same data on all the nodes irrespective of which node's CLI you use. The replication factor is for redundancy to have copies of the data on different nodes to help i

Re: Secondary index partially created

2012-08-24 Thread Richard Crowley
On Thu, Aug 23, 2012 at 6:54 PM, Richard Crowley wrote: > I have a three-node cluster running Cassandra 1.0.10. In this cluster > is a keyspace with RF=3. I *updated* a column family via Astyanax to > add a column definition with an index on that column. Then I ran a > backfill to populate the

Secondary index partially created

2012-08-23 Thread Richard Crowley
I have a three-node cluster running Cassandra 1.0.10. In this cluster is a keyspace with RF=3. I *updated* a column family via Astyanax to add a column definition with an index on that column. Then I ran a backfill to populate the column in every row. Then I tried to query the index from Java a