[jira] [Commented] (CASSANDRA-10785) Lightweight transactions problem: SERIAL is not supported as conditional update commit consistency

["Sylvain Lebresne (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CASSANDRA-10785?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15031584#comment-15031584 ] 

Sylvain Lebresne commented on CASSANDRA-10785:
----------------------------------------------

While the 2 lines you've posted should obviously not trigger that exception, I doubt your program contains those 2 lines so you might have a configuration error somewhere else. In any case, this is almost surely a driver-side error: either a mis-configuration on your side, or a bug/confusing behavior of the driver, not a server-side problem.

So I would start by asking for help on the java driver mailing list (java-driver-user@lists.datastax.com), maybe joining a complete example that triggers that exception. If, after working with the java driver maintainers, you have further evidence that strongly suggest a server-side problem, then feel free to re-open with that additional evidence. But for now, closing as this has all the signs of a driver-side problem.


> Lightweight transactions problem: SERIAL is not supported as conditional update commit consistency
> --------------------------------------------------------------------------------------------------
>
>                 Key: CASSANDRA-10785
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-10785
>             Project: Cassandra
>          Issue Type: Bug
>            Reporter: ant_nebula
>
> {code}
> preparedStatement = session.prepare("insert into table_x(key) values (?) IF NOT EXISTS")
> preparedStatement.setConsistencyLevel(ConsistencyLevel.ONE)
> {code}
> this code sometimes throw Exception :
> {code}
> com.datastax.driver.core.exceptions.InvalidQueryException: SERIAL is not supported as conditional update commit consistency. Use ANY if you mean "make sure it is accepted but I don't care how many replicas commit it for non-SERIAL reads"
>         at com.datastax.driver.core.exceptions.InvalidQueryException.copy(InvalidQueryException.java:35)
>         at com.datastax.driver.core.DefaultResultSetFuture.extractCauseFromExecutionException(DefaultResultSetFuture.java:289)
>         at com.datastax.driver.core.DefaultResultSetFuture.getUninterruptibly(DefaultResultSetFuture.java:205)
>         at com.datastax.driver.core.AbstractSession.execute(AbstractSession.java:52)
>         at sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>         at java.lang.reflect.Method.invoke(Method.java:606)
>         at com.datastax.spark.connector.cql.SessionProxy.invoke(SessionProxy.scala:33)
>         at com.sun.proxy.$Proxy20.execute(Unknown Source)
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)