cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Duncan Sands <>
Subject Re: error deleting messages
Date Tue, 24 Mar 2015 12:50:35 GMT
Hi Joss,

On 24/03/15 12:58, joss Earl wrote:
> I run into trouble after a while if I delete rows, this happens in both 2.1.3
> and 2.0.13, and I encountered the same problem when using either the datastax
> java driver or the stock python driver.
> The problem is reproducible using the attached python program.
> Once the problem is encountered, the table becomes unusable..
> cqlsh:test1> select id from msg limit 1;
> Request did not complete within rpc_timeout.

my guess is that due to previous delete attempts your table is filled with 
tombstones, and this is why the read times out: it hits the tombstone limit. 
Check your Cassandra node logs to see if they mention tombstones.

Ciao, Duncan.

> So, questions are:
> am I doing something wrong ?
> is this expected behaviour ?
> is there some way to fix the table and make it usable again once this has happened ?
> if this is a bug, what is the best way of reporting it ?
> Many thanks
> Joss

View raw message