[CASSANDRA-5732] Can not query secondary index

• Type: Bug
• Status: Resolved
• Priority: Normal
• Resolution: Fixed
• Fix Version/s: 1.2.11, 2.0.2
• Component/s: Feature/2i Index

Environment

Windows 8, Jre 1.6.0_45 32-bit

• Severity: Normal
• Assignee: Sam Tunnicliffe
• Reporter: Tony Anecito

Authors

Sam Tunnicliffe

Reviewers

Jonathan Ellis

• Created: 08/Jul/13 21:35
• Updated: 16/Apr/19 09:32
• Resolved: 13/Oct/13 16:14

Description

Noticed after taking a column family that already existed and assigning to an IntegerType index_type:KEYS and the caching was already set to 'ALL' that the prepared statement do not return rows neither did it throw an exception. Here is the sequence.
1. Starting state query running with caching off for a Column Family with the query using the secondary index for te WHERE clause.
2, Set Column Family caching to ALL using Cassandra-CLI and update CQL. Cassandra-cli Describe shows column family caching set to ALL
3. Rerun query and it works.
4. Restart Cassandra and run query and no rows returned. Cassandra-cli Describe shows column family caching set to ALL
5. Set Column Family caching to NONE using Cassandra-cli and update CQL. Rerun query and no rows returned. Cassandra-cli Describe for column family shows caching set to NONE.
6. Restart Cassandra. Rerun query and it is working again. We are now back to the starting state.

Best Regards,
-Tony

Issue Links

• is related to: CASSANDRA-4785 Secondary Index Sporadically Doesn't Return Rows