incubator-cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Cyril Scetbon <cyril.scet...@free.fr>
Subject Re: exception when attempting to truncate a table
Date Thu, 22 Mar 2012 08:56:41 GMT
On 3/21/12 10:47 PM, Viktor Jevdokimov wrote:
>
> This is a known issue(s) to be fixed (can't find exact tickets on the 
> tracker).
>
> Controller, that receives truncate command, checks all nodes up and 
> send truncate message to all (including itself), waiting for an answer 
> for rpc_timeout_in_ms (will be fixed to separate timeout setting).
>
> If any node timeouts, node unavailable exception will be thrown (this 
> will be fixed to timeout exception).
>
> Why truncate takes a long time? That because all memtables should be 
> flushed to free up commit logs, then truncated sstables should be 
> snapshotted (there will be introduced a setting to disable snapshots). 
> All this takes time for a truncate.
>
> But you can check with a short scan a few moments later after failed 
> truncate that the data is actually truncated.
>
Ok, that's what I've done, and as you mentioned I have some snapshots 
that killed my free space :( I didn't know that a snapshot was taken for 
each truncate request
>
> Best regards/ Pagarbiai
>
> *Viktor Jevdokimov*
>
> Senior Developer
>
> Email: Viktor.Jevdokimov@adform.com
>
> Phone: +370 5 212 3063. Fax: +370 5 261 0453
>
> J. Jasinskio 16C, LT-01112 Vilnius, Lithuania
>
> 	
>
> Adform news <http://www.adform.com/>
>
> Visit us!
>
> Follow:
>
> 	
>
> twitter <http://twitter.com/#%21/adforminsider>
>
> 	
>
> Visit our blog <http://www.adform.com/site/blog>
>
> Disclaimer: The information contained in this message and attachments 
> is intended solely for the attention and use of the named addressee 
> and may be confidential. If you are not the intended recipient, you 
> are reminded that the information remains the property of the sender. 
> You must not use, disclose, distribute, copy, print or rely on this 
> e-mail. If you have received this message in error, please contact the 
> sender immediately and irrevocably delete this message and any copies.
>
>
> *From:*Cyril Scetbon [mailto:cyril.scetbon@free.fr]
> *Sent:* Wednesday, March 21, 2012 20:33
> *To:* user@cassandra.apache.org
> *Subject:* exception when attempting to truncate a table
>
> Hi,
>
> I'm using version 1.0.7 and when I try to truncate a CF in cqlsh it 
> raises an error message, but it seems incorrect ...
>
> cqlsh:ks1> truncate core;
> Unable to complete request: *one or more nodes were unavailable*.
>
> >nodetool -h localhost ring
>                                                                               
> 155962751505430129087380028406227096917
> 10.0.0.61       DC1         RAC1        Up     Normal  75.8 GB         
> 8.33%   0
> 10.0.0.62       DC1         RAC1        Up     Normal  72.84 GB        
> 8.33%   14178431955039102644307275309657008810
> 10.0.1.61       DC2         RAC1        Up     Normal  72.54 GB        
> 8.33%   28356863910078205288614550619314017621
> 10.0.1.62       DC2         RAC1        Up     Normal  108.11 GB       
> 8.33%   42535295865117307932921825928971026432
> 10.0.0.63       DC1         RAC1        Up     Normal  72.37 GB        
> 8.33%   56713727820156410577229101238628035242
> 10.0.0.64       DC1         RAC1        Up     Normal  72.56 GB        
> 8.33%   70892159775195513221536376548285044053
> 10.0.1.63       DC2         RAC1        Up     Normal  73.09 GB        
> 8.33%   85070591730234615865843651857942052864
> 10.0.1.64       DC2         RAC1        Up     Normal  169.85 GB       
> 8.33%   99249023685273718510150927167599061674
> 10.0.0.65       DC1         RAC1        Up     Normal  72.33 GB        
> 8.33%   113427455640312821154458202477256070485
> 10.0.0.66       DC1         RAC1        Up     Normal  93.12 GB        
> 8.33%   127605887595351923798765477786913079296
> 10.0.1.65       DC2         RAC1        Up     Normal  88.16 GB        
> 8.33%   141784319550391026443072753096570088106
> 10.0.1.66       DC2         RAC1        Up     Normal  92.46 GB        
> 8.33%   155962751505430129087380028406227096917
>
> any idea ?
>
> thanks
>
> -- 
> Cyril SCETBON


-- 
Cyril SCETBON


Mime
View raw message