CODEWITHSUNDEEP
cassandra
Neha Dave
Neha Dave

Reputation: 27

Upgrading Cassandra from 2.0 to 2.1

  1. I upgraded Cassandra 2.0.9 to 2.1

Query on the index does not work after upgrading Cassandra from 2.0.9 to 2.1. Anything that I am missing.

Query on the Primary Key works Eg. select userid,name from user where userid='lll';

I have Indexed on "name" and if i query select userid,name from user where name='abc'; Does not work. This was working before Upgrade.

Upvotes: 0

Views: 712

Answers (1)

Aaron
Aaron

Reputation: 57748

Did you run nodetool upgradesstables? Going by the steps give in the DataStax Upgrade Guide, that is the step that is most-often forgotten.

Otherwise, you can rebuild each index through nodetool.

nodetool rebuild_index MyKeyspaceName MyColumnFamilyName MyIndexName

Your indexes should work after that, but that will eat I/O and CPU, so it should be a last resort. Definitely make sure that upgradesstables was run first.

Upvotes: 1

Related Questions