[jira] [Resolved] (CASSANDRA-5599) Intermittently, CQL SELECT with WHERE on secondary indexed field value returns null when there are rows

["Jonathan Ellis (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CASSANDRA-5599?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jonathan Ellis resolved CASSANDRA-5599.
---------------------------------------

    Resolution: Fixed

bq. my guess its occurring when we keep deleting the same content and recreate it over a period of time

Suspect this has been addressed by one of the index tickets recently (CASSANDRA-5614, CASSANDRA-5732).

> 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 was sent by Atlassian JIRA
(v6.1#6144)