[
https://issues.apache.org/jira/browse/CASSANDRA-4785?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13577810#comment-13577810
]
Steve Hodecker commented on CASSANDRA-4785:
-------------------------------------------
I am seeing this behavior as wel1, with version 1.1.5. Following a restart of
a cassandra node, queries that use secondary indexes started failing for all
Column Families that had caching set to 'all'. My workaround was to change the
caching on these ColumnFamilies to 'keys_only';
> Secondary Index Sporadically Doesn't Return Rows
> ------------------------------------------------
>
> Key: CASSANDRA-4785
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4785
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Affects Versions: 1.1.5, 1.1.6
> Environment: Ubuntu 10.04
> Java 6 Sun
> Cassandra 1.1.5 upgraded from 1.1.2 -> 1.1.3 -> 1.1.5
> Reporter: Arya Goudarzi
>
> I have a ColumnFamily with caching = ALL. I have 2 secondary indexes on it. I
> have noticed if I query using the secondary index in the where clause,
> sometimes I get the results and sometimes I don't. Until 2 weeks ago, the
> caching option on this CF was set to NONE. So, I suspect something happened
> in secondary index caching scheme.
> Here are things I tried:
> 1. I rebuild indexes for that CF on all nodes;
> 2. I set the caching to KEYS_ONLY and rebuild the index again;
> 3. I set the caching to NONE and rebuild the index again;
> None of the above helped. I suppose the caching still exists as this behavior
> looks like cache mistmatch.
> I did a bit research, and found CASSANDRA-4197 that could be related.
> Please advice.
--
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
