Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 45D46200B36 for ; Wed, 6 Jul 2016 12:05:18 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 4472F160A64; Wed, 6 Jul 2016 10:05:18 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 8A366160A36 for ; Wed, 6 Jul 2016 12:05:17 +0200 (CEST) Received: (qmail 17321 invoked by uid 500); 6 Jul 2016 10:05:11 -0000 Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cassandra.apache.org Delivered-To: mailing list commits@cassandra.apache.org Received: (qmail 17304 invoked by uid 99); 6 Jul 2016 10:05:11 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Jul 2016 10:05:11 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id 6CFEA2C02A4 for ; Wed, 6 Jul 2016 10:05:11 +0000 (UTC) Date: Wed, 6 Jul 2016 10:05:11 +0000 (UTC) From: "Sylvain Lebresne (JIRA)" To: commits@cassandra.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Resolved] (CASSANDRA-12045) Cassandra failure during write query at consistency LOCAL_QUORUM MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Wed, 06 Jul 2016 10:05:18 -0000 [ https://issues.apache.org/jira/browse/CASSANDRA-12045?page=3Dcom.atl= assian.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 ca= n't fit in a single commit log segment, which they have to). You can bump t= he {{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 t= o me that you're not compressing it, and given the size of your xml, I'd pe= rsonally 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=20 > ------------------------------------------------------------------ > > Key: CASSANDRA-12045 > URL: https://issues.apache.org/jira/browse/CASSANDRA-1204= 5 > 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 follo= wing exception.Its a 3 node cluster and All nodes are up. > com.datastax.driver.core.exceptions.WriteFailureException: Cassandra fail= ure during write query at consistency LOCAL_QUORUM (2 responses were requir= ed but only 0 replica responded, 1 failed) at com.datastax.driver.core.exce= ptions.WriteFailureException.copy(WriteFailureException.java:80) at com.dat= astax.driver.core.DriverThrowables.propagateCause(DriverThrowables.java:37)= at com.datastax.driver.core.DefaultResultSetFuture.getUninterruptibly(Defa= ultResultSetFuture.java:245) at com.datastax.driver.core.AbstractSession.ex= ecute(AbstractSession.java:55) at com.datastax.driver.core.AbstractSession.= execute(AbstractSession.java:39) at DBConnection.oracle2Cassandra(DBConnect= ion.java:267) at DBConnection.main(DBConnection.java:292) Caused by: com.da= tastax.driver.core.exceptions.WriteFailureException: Cassandra failure duri= ng write query at consistency LOCAL_QUORUM (2 responses were required but o= nly 0 replica responded, 1 failed) at com.datastax.driver.core.exceptions.W= riteFailureException.copy(WriteFailureException.java:91) at com.datastax.dr= iver.core.Responses$Error.asException(Responses.java:119) at com.datastax.d= river.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.s= etFinalResult(RequestHandler.java:754) at com.datastax.driver.core.RequestH= andler$SpeculativeExecution.onSet(RequestHandler.java:576) > It would be great if someone helps me out from this situation. Thanks > =20 -- This message was sent by Atlassian JIRA (v6.3.4#6332)