Re: TRUNCATE throws OperationTimedOut randomly

2016-09-29 Thread Romain Hardouin
Hi, @Edward > In older versions you can not control when this call will timeout,truncate_request_timeout_in_ms is available for many years, starting from 1.2. Maybe you have another setting parameter in mind? @GeorgeTry to put cassandra logs in debug Best, Romain Le Mercredi 28 septembre 2

Re: TRUNCATE throws OperationTimedOut randomly

2016-09-28 Thread George Sigletos
Even when I set a lower request-timeout in order to trigger a timeout, still no WARN or ERROR in the logs On Wed, Sep 28, 2016 at 8:22 PM, George Sigletos wrote: > Hi Joaquin, > > Unfortunately neither WARN nor ERROR found in the system logs across the > cluster when executing truncate. Sometime

Re: TRUNCATE throws OperationTimedOut randomly

2016-09-28 Thread George Sigletos
Hi Joaquin, Unfortunately neither WARN nor ERROR found in the system logs across the cluster when executing truncate. Sometimes it executes immediately, other times it takes 25 seconds, given that I have connected with --request-timeout=30 seconds. The nodes are a bit busy compacting. On a freshl

Re: TRUNCATE throws OperationTimedOut randomly

2016-09-28 Thread Joaquin Casares
Hi George, Try grepping for WARN and ERROR on the system.logs across all nodes when you run the command. Could you post any of the recent stacktraces that you see? Cheers, Joaquin Casares Consultant Austin, TX Apache Cassandra Consulting http://www.thelastpickle.com On Wed, Sep 28, 2016 at 12:

Re: TRUNCATE throws OperationTimedOut randomly

2016-09-28 Thread George Sigletos
Thanks a lot for your reply. I understand that truncate is an expensive operation. But throwing a timeout while truncating a table that is already empty? A workaround is to set a high --request-timeout when connecting. Even 20 seconds is not always enough Kind regards, George On Wed, Sep 28, 2

Re: TRUNCATE throws OperationTimedOut randomly

2016-09-28 Thread Edward Capriolo
Truncate does a few things (based on version) truncate takes snapshots truncate causes a flush in very old versions truncate causes a schema migration. In newer versions like cassandra 3.4 you have this knob. # How long the coordinator should wait for truncates to complete # (This can be mu

TRUNCATE throws OperationTimedOut randomly

2016-09-28 Thread George Sigletos
Hello, I keep executing a TRUNCATE command on an empty table and it throws OperationTimedOut randomly: cassandra@cqlsh> truncate test.mytable; OperationTimedOut: errors={}, last_host=cassiebeta-01 cassandra@cqlsh> truncate test.mytable; OperationTimedOut: errors={}, last_host=cassiebeta-01 Havin