[
https://issues.apache.org/jira/browse/CASSANDRA-5599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13701055#comment-13701055
]
Rao commented on CASSANDRA-5599:
--------------------------------
I could not reproduce it as well. But my guess its occurring when we keep
deleting the same content and recreate it over a period of time.
> 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