使用Gocql获取超时错误

Question

I am getting following errors while inserting data in Cassandra. I am using gocql client for Cassandra.

{"error":"gocql: too many query timeouts on the connection","status":500}

{"error":"gocql: no response received from cassandra within timeout period","status":500}

{"error":"write tcp 172.23.15.226:36954-\u003e172.23.16.15:9042: use of closed network connection","status":500}

Can anybody help me with this?

Answer 1

Try to increase timeouts in Cassandra config file (write_request_timeout_in_ms - for writes) and concurrent writes (concurrent_writes).

Also, try to lower NumConns parameter in your gocql driver. If you are using goroutines, try to lower their number and verify that you are reusing same session object for all goroutines.

If you are using protocol version prior to 4, you can try to set Timeout paramter of cluster object in gocql to higher value.