[
https://issues.apache.org/jira/browse/CASSANDRA-5599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13701032#comment-13701032
]
Rao commented on CASSANDRA-5599:
--------------------------------
We have 2 dc and 2 nodes/dc. Heres the keyspace configuration:
CREATE KEYSPACE grd WITH replication = {
'class': 'NetworkTopologyStrategy',
'HYWRCA02': '2',
'CHRLNCUN': '2'
};
All these queries are executed on node1 on dc HYWRCA02. As you can see we only
see the results when consistency level is set to "ALL".
After repair on node1 (dc: HYWRCA02), its the same result.
After repair on node2 (dc: HYWRCA02), its the same result.
After repair on node1 (dc: CHRLNCUN), its the same result.
After repair on node2 (dc: CHRLNCUN), its the same result.
Let me know if you need any more info.
cqlsh> consistency one;
Consistency level set to ONE.
cqlsh> select count(*) from grd.route where
serviceidentifier='com.att.scld.GRMServerTestService'
... ;
count
-------
0
cqlsh> consistency local_quorum;
Consistency level set to LOCAL_QUORUM.
cqlsh> select count(*) from grd.route where
serviceidentifier='com.att.scld.GRMServerTestService';
count
-------
0
cqlsh> consistency all;
Consistency level set to ALL.
cqlsh> select count(*) from grd.route where
serviceidentifier='com.att.scld.GRMServerTestService' ;
count
-------
158
> 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
