[ https://issues.apache.org/jira/browse/CASSANDRA-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13704647#comment-13704647 ]
Tony Anecito commented on CASSANDRA-5732: ----------------------------------------- Hi Janne, There are simularities. Mine though is a solid failure and I narrowed it down to what I said so the Cassandra team should be able to solve the issue. Best Regards, -Tony From: Janne Jalkanen (JIRA) <j...@apache.org> To: adanec...@yahoo.com Sent: Wednesday, July 10, 2013 9:05 AM Subject: [jira] [Commented] (CASSANDRA-5732) Can not query secondary index [ https://issues.apache.org/jira/browse/CASSANDRA-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13704633#comment-13704633 ] Janne Jalkanen commented on CASSANDRA-5732: ------------------------------------------- Is this the same as CASSANDRA-4785? -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira > Can not query secondary index > ----------------------------- > > Key: CASSANDRA-5732 > URL: https://issues.apache.org/jira/browse/CASSANDRA-5732 > Project: Cassandra > Issue Type: Bug > Components: Core > Affects Versions: 1.2.5 > Environment: Windows 8, Jre 1.6.0_45 32-bit > Reporter: Tony Anecito > > 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 -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira