You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Bhavesh Prajapati <bh...@adobe.com.INVALID> on 2019/05/01 07:57:00 UTC
Exception while running two CQL queries in Parallel
I had two queries run on same row in parallel (that's a use-case). While Batch Query 2 completed successfully, query 1 failed with exception.
Following are driver logs and sequence of log events.
QUERY 1: STARTED
2019-04-30T13:14:50.858+0000 CQL update "EACH_QUORUM" "UPDATE dir SET bid='value' WHERE repoid='06A7490B5CBFA1DE0A494027' IF EXISTS;"
QUERY 2: STARTED
2019-04-30T13:14:51.161+0000 CQL BEGIN BATCH
2019-04-30T13:14:51.161+0000 CQL batch-update "06A7490B5CBFA1DE0A494027"
2019-04-30T13:14:51.161+0000 CQL batch-delete "06A7490B5CBFA1DE0A494027"
2019-04-30T13:14:51.161+0000 CQL APPLY BATCH
2019-04-30T13:14:51.165+0000 Cassandra delete directory call completed successfully for "06A7490B5CBFA1DE0A494027"
QUERY 2: COMPLETED - WITH SUCCESS
QUERY 1: FAILED
2019-04-30T13:14:52.311+0000 CQL "org.springframework.cassandra.support.exception.CassandraWriteTimeoutException" "Cassandra timeout during write query at consistency SERIAL (5 replica were required but only 0 acknowledged the write); nested exception is com.datastax.driver.core.exceptions.WriteTimeoutException: Cassandra timeout during write query at consistency SERIAL (5 replica were required but only 0 acknowledged the write)"
org.springframework.cassandra.support.exception.CassandraWriteTimeoutException: Cassandra timeout during write query at consistency SERIAL (5 replica were required but only 0 acknowledged the write); nested exception is com.datastax.driver.core.exceptions.WriteTimeoutException: Cassandra timeout during write query at consistency SERIAL (5 replica were required but only 0 acknowledged the write)
at org.springframework.cassandra.support.CassandraExceptionTranslator.translateExceptionIfPossible(CassandraExceptionTranslator.java:95) ~[spring-cql-1.5.18.RELEASE.jar!/:?]
at org.springframework.cassandra.core.CqlTemplate.potentiallyConvertRuntimeException(CqlTemplate.java:946) ~[spring-cql-1.5.18.RELEASE.jar!/:?]
at org.springframework.cassandra.core.CqlTemplate.translateExceptionIfPossible(CqlTemplate.java:930) ~[spring-cql-1.5.18.RELEASE.jar!/:?]
What could have caused this exception ?
How to resolve or handle such situation ?
Thanks,
Bhavesh
Re: Exception while running two CQL queries in Parallel
Posted by Stefan Miklosovic <st...@instaclustr.com>.
what are your replication factors for that keyspace? why are you using
each quorum?
might be handy https://docs.datastax.com/en/cassandra/3.0/cassandra/dml/dmlConfigSerialConsistency.html
On Wed, 1 May 2019 at 17:57, Bhavesh Prajapati
<bh...@adobe.com.invalid> wrote:
>
> I had two queries run on same row in parallel (that’s a use-case). While Batch Query 2 completed successfully, query 1 failed with exception.
>
> Following are driver logs and sequence of log events.
>
>
>
> QUERY 1: STARTED
>
> 2019-04-30T13:14:50.858+0000 CQL update "EACH_QUORUM" "UPDATE dir SET bid='value' WHERE repoid='06A7490B5CBFA1DE0A494027' IF EXISTS;"
>
>
>
> QUERY 2: STARTED
>
> 2019-04-30T13:14:51.161+0000 CQL BEGIN BATCH
>
> 2019-04-30T13:14:51.161+0000 CQL batch-update "06A7490B5CBFA1DE0A494027"
>
> 2019-04-30T13:14:51.161+0000 CQL batch-delete "06A7490B5CBFA1DE0A494027"
>
> 2019-04-30T13:14:51.161+0000 CQL APPLY BATCH
>
> 2019-04-30T13:14:51.165+0000 Cassandra delete directory call completed successfully for "06A7490B5CBFA1DE0A494027"
>
> QUERY 2: COMPLETED - WITH SUCCESS
>
>
>
> QUERY 1: FAILED
>
> 2019-04-30T13:14:52.311+0000 CQL "org.springframework.cassandra.support.exception.CassandraWriteTimeoutException" "Cassandra timeout during write query at consistency SERIAL (5 replica were required but only 0 acknowledged the write); nested exception is com.datastax.driver.core.exceptions.WriteTimeoutException: Cassandra timeout during write query at consistency SERIAL (5 replica were required but only 0 acknowledged the write)"
>
> org.springframework.cassandra.support.exception.CassandraWriteTimeoutException: Cassandra timeout during write query at consistency SERIAL (5 replica were required but only 0 acknowledged the write); nested exception is com.datastax.driver.core.exceptions.WriteTimeoutException: Cassandra timeout during write query at consistency SERIAL (5 replica were required but only 0 acknowledged the write)
>
> at org.springframework.cassandra.support.CassandraExceptionTranslator.translateExceptionIfPossible(CassandraExceptionTranslator.java:95) ~[spring-cql-1.5.18.RELEASE.jar!/:?]
>
> at org.springframework.cassandra.core.CqlTemplate.potentiallyConvertRuntimeException(CqlTemplate.java:946) ~[spring-cql-1.5.18.RELEASE.jar!/:?]
>
> at org.springframework.cassandra.core.CqlTemplate.translateExceptionIfPossible(CqlTemplate.java:930) ~[spring-cql-1.5.18.RELEASE.jar!/:?]
>
>
>
> What could have caused this exception ?
>
> How to resolve or handle such situation ?
>
>
>
> Thanks,
>
> Bhavesh
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org
For additional commands, e-mail: user-help@cassandra.apache.org