[
https://issues.apache.org/jira/browse/CASSANDRA-12045?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15373175#comment-15373175
]
Tyler Hobbs commented on CASSANDRA-12045:
-----------------------------------------
2GB is the theoretical max value size for a column. There are other limits
(like the {{commitlog_segment_size_in_mb}}) that may prevent you from hitting
that limit.
In any case, it's not a good idea to put huge values into a single column or
row. I recommend chunking values over 10mb into multiple rows. Plus, as
Sylvain says, compression would probably save you a great deal of space.
> 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.
> {noformat}
> 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)
> {noformat}
> It would be great if someone helps me out from this situation. Thanks
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
