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 freshly restarted cluster, truncate seems to work without problems. Some warnings that I see around that time but not exactly when executing truncate are: WARN [CompactionExecutor:2] 2016-09-28 20:03:29,646 SSTableWriter.java:241 - Compacting large partition system/hints:6f2c3b31-4975-470b-8f91-e706be89a83a (133819308 bytes Kind regards, George On Wed, Sep 28, 2016 at 7:54 PM, Joaquin Casares <joaq...@thelastpickle.com> wrote: > 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:43 PM, George Sigletos <sigle...@textkernel.nl> > wrote: > >> 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, 2016 at 6:59 PM, Edward Capriolo <edlinuxg...@gmail.com> >> wrote: >> >>> 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 much longer, because unless auto_snapshot is disabled >>> # we need to flush first so we can snapshot before removing the data.) >>> truncate_request_timeout_in_ms: 60000 >>> >>> >>> In older versions you can not control when this call will timeout, it is >>> fairly normal that it does! >>> >>> >>> On Wed, Sep 28, 2016 at 12:50 PM, George Sigletos < >>> sigle...@textkernel.nl> wrote: >>> >>>> 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 >>>> >>>> Having a 3 node cluster running 2.1.14. No connectivity problems. Has >>>> anybody come across the same error? >>>> >>>> Thanks, >>>> George >>>> >>>> >>> >> >