[ 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