Reading error in cassandra
<p>I'm having a weir error trying to read data from a Cassandra table. I have a single-node installation, with the default setup. This is the query I'm making:</p>

<pre><code>  SELECT component_id,
         reading_1,
         reading_2,
         reading_3,
         date
  FROM component_readings
  WHERE park_id=2
        AND component_id IN (479)
        AND date &gt;= '2016-04-09+0000'
        AND date &lt;= '2016-05-08+0000';
</code></pre>

<p><code>component_readings</code> is a simple table, with no clustering conditions:</p>

<pre><code>CREATE TABLE component_readings (
    park_id int,
    component_id int,
    date timestamp,
    reading_1 decimal,
    reading_2 decimal,
    ...
    PRIMARY KEY ((park_id), component_id, date)
);
</code></pre>

<p>With some <code>component_id</code> values, it works, and with another values, it fails. This is the error I'm getting:</p>

<pre><code>cassandra.ReadFailure: code=1300 [Replica(s) failed to execute read] 
message="Operation failed - received 0 responses and 1 failures"
info={'required_responses': 1, 'received_responses': 0, 'failures': 1,
'consistency': 'LOCAL_ONE'}
</code></pre>

<p>And the cassandra's system.log shows this error:</p>

<pre><code>ERROR [SharedPool-Worker-1] 2016-05-09 15:33:58,872 StorageProxy.java:1818 - 
Scanned over 100001 tombstones during query 'SELECT * FROM xrem.component_readings
WHERE park_id, component_id = 2, 479 AND date &gt;= 2016-04-09 02:00+0200 AND date &lt;=
2016-05-08 02:00+0200 LIMIT 5000' (last scanned row partion key was ((2, 479),
2016-05-04 17:30+0200)); query aborted
</code></pre>

<p>The weird thing is that I get the error only when making the query from an external program (via the python cassandra-connector). If I make it directly in the cqlsh shell, it works perfectly.</p>

<p>My installation was cassandra 2.2, but I've upgraded to 3.5, and I get the same error.</p>