[jira] [Resolved] (CASSANDRA-12045) Cassandra failure during write query at consistency LOCAL_QUORUM

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

     [ https://issues.apache.org/jira/browse/CASSANDRA-12045?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sylvain Lebresne resolved CASSANDRA-12045.
------------------------------------------
    Resolution: Not A Problem

As the error says, the values you are trying to insert are too big (they can't fit in a single commit log segment, which they have to). You can bump the {{commitlog_segment_size_in_mb}} segment *on all nodes* if you wish, but I wouldn't necessarilly advise it as Cassandra isn't optimized for storing large values. The fact you store your xml file in a text column suggests to me that you're not compressing it, and given the size of your xml, I'd personally definitively compress it (client side). Otherwise, the traditional way to deal with large values is to manually chunk them.

Overall, there is no bug here and this is a user question, so I'm going to close this ticket and please reach out on the user mailing list (see bottom of http://cassandra.apache.org/) if you need more info/help.


>  Cassandra failure during write query at consistency LOCAL_QUORUM 
> ------------------------------------------------------------------
>
>                 Key: CASSANDRA-12045
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-12045
>             Project: Cassandra
>          Issue Type: Bug
>          Components: CQL, Local Write-Read Paths
>         Environment: Eclipse java environment
>            Reporter: Raghavendra Pinninti
>             Fix For: 3.x
>
>   Original Estimate: 12h
>  Remaining Estimate: 12h
>
> While I am writing xml file into Cassandra table column I am facing following exception.Its a 3 node cluster and All nodes are up.
> com.datastax.driver.core.exceptions.WriteFailureException: Cassandra failure during write query at consistency LOCAL_QUORUM (2 responses were required but only 0 replica responded, 1 failed) at com.datastax.driver.core.exceptions.WriteFailureException.copy(WriteFailureException.java:80) at com.datastax.driver.core.DriverThrowables.propagateCause(DriverThrowables.java:37) at com.datastax.driver.core.DefaultResultSetFuture.getUninterruptibly(DefaultResultSetFuture.java:245) at com.datastax.driver.core.AbstractSession.execute(AbstractSession.java:55) at com.datastax.driver.core.AbstractSession.execute(AbstractSession.java:39) at DBConnection.oracle2Cassandra(DBConnection.java:267) at DBConnection.main(DBConnection.java:292) Caused by: com.datastax.driver.core.exceptions.WriteFailureException: Cassandra failure during write query at consistency LOCAL_QUORUM (2 responses were required but only 0 replica responded, 1 failed) at com.datastax.driver.core.exceptions.WriteFailureException.copy(WriteFailureException.java:91) at com.datastax.driver.core.Responses$Error.asException(Responses.java:119) at com.datastax.driver.core.DefaultResultSetFuture.onSet(DefaultResultSetFuture.java:180) at com.datastax.driver.core.RequestHandler.setFinalResult(RequestHandler.java:186) at com.datastax.driver.core.RequestHandler.access$2300(RequestHandler.java:44) at com.datastax.driver.core.RequestHandler$SpeculativeExecution.setFinalResult(RequestHandler.java:754) at com.datastax.driver.core.RequestHandler$SpeculativeExecution.onSet(RequestHandler.java:576)
> It would be great if someone helps me out from this situation. Thanks
>  



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