Hello everyone, I run a 2.2.3 cluster and I've found that sometimes queries by secondary indexes don't return the expected results, even though the data is in the table. I'm sure the data is in there because queries by partition key or without WHERE clause do return the expected data.
The only issues I could find that sound similar to what I'm experiencing are these: https://issues.apache.org/jira/browse/CASSANDRA-6782 https://issues.apache.org/jira/browse/CASSANDRA-8206 In my case, there are updates with TTL involved too. However, the changelog shows that those issues are supposedly fixed in 2.2.3, so it could be a red herring. Does anybody know of other related issues around this that might have been fixed in later releases? It definitely sounds like a bug, but I haven't been able to find anything else on the matter. Thanks in advance. Kind regards, -- Enrique Bautista Software Engineer OpenJaw Technologies -- *The information in this e-mail and any attachments is confidential. It is intended solely for the addressee(s) named above. If you are not an intended recipient, please notify the sender and delete the message and any attachments from your system. Any use, copying or disclosure of the contents is unauthorised unless expressly permitted. Any views expressed in this message are those of the sender unless expressly stated to be those of OpenJaw. Virus checking of emails and attachments is the responsibility of the recipient and OpenJaw cannot accept responsibility for any loss or damage arising from the use of this email or attachments. OpenJaw Technologies Limited is a limited company registered in Ireland having registration number 353613 and registered office at Grattan Bridge House, 1 Ormond Quay Upper, Dublin 7.*