[
https://issues.apache.org/jira/browse/CASSANDRA-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13791840#comment-13791840
]
Sam Tunnicliffe commented on CASSANDRA-5732:
--------------------------------------------
Yeah, unfortunately that failed lookup was only masking the other problem I
mentioned. Even with the v2 fix, without the index cfm in Schema, you fall foul
(silently, except for debug) of
https://github.com/apache/cassandra/blob/cassandra-1.2/src/java/org/apache/cassandra/db/ColumnFamilySerializer.java#L183
and so the row cache is effectively bypassed for 2i cfs.
> 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
> Assignee: Sam Tunnicliffe
> Attachments: 5732-1.2, 5732-v2.txt
>
>
> 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 was sent by Atlassian JIRA
(v6.1#6144)
