[
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)
