[
https://issues.apache.org/jira/browse/CASSANDRA-5599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13701045#comment-13701045
]
Michał Michalski commented on CASSANDRA-5599:
---------------------------------------------
I had similar problem - repairing nodes and rebuilding index didn't help too
(and I couldn't drop & recreate it due to some other problems). I had to use
JMX to compact index CF.
So I can confirm that such problem exists, however I didn't manage to reproduce
it.
> Intermittently, CQL SELECT with WHERE on secondary indexed field value
> returns null when there are rows
> --------------------------------------------------------------------------------------------------------
>
> Key: CASSANDRA-5599
> URL: https://issues.apache.org/jira/browse/CASSANDRA-5599
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Affects Versions: 1.2.4, 1.2.5
> Environment: x86_64 / RedHat Enterprise Linux 4.x
> Reporter: Ravi Basawa
> Priority: Minor
>
> Intermittently, CQL SELECT with WHERE on secondary indexed field value
> returns null when there are rows.
> As it happens intermittently, it is difficult to replicate. To resolve we
> have had to recreate the index. Also using the nodetool to reindex did not
> help us either.
> We would create a table, create a secondary index for that table on a field,
> import data then when we try to select rows from that table with where on
> said field which should return results, we get a null back ...intermittently.
> Sometimes works, sometimes not.
--
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
