Issue when calling the cassandra-driver. Error doesn't occur in cqlsh

[Anand Sampat]

I'm facing touch issue where randomly for some requests I am unable to get a response. Specifically, when I make the following statement in cqlsh, it works perfectly 

select * from social_media.posts where query_id='286eb6b6-5fc4-59a6-8fff-40035101708d' and source='twitter' and relevant=true limit 10000 allow filtering;

But when I use the same query using the cassandra-driver execute function I run into the following error. 

[Replica(s) failed to execute read] message="Operation failed - received 0 responses and 1 failures" info={'failures': 1, 'received_responses': 0, 'required_responses': 1, 'consistency': 'QUORUM'}

Is this even possible? Other queries work normally, but once in a while I get this error for a subset of my queries. As of now this is completely breaking our data flow and we can't find a workaround. 

For reference we set the consistency to QUORUM when we initiate the connection to the db. 

[Adam Holmberg]

What is your cluster nodetool status when this fails? What is your replication factor on the keyspace? Based on the error message, it looks like it might be ONE, in which case you will suffer availability loss whenever any node becomes unavailable. If that is the case, you should raise the replication factor and run repair to populate more nodes with existing data.

Regards,

Adam Holmberg

--
You received this message because you are subscribed to the Google Groups "DataStax Python Driver for Apache Cassandra User Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to python-driver-u...@lists.datastax.com.