Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 1E102174B7 for ; Fri, 30 Jan 2015 13:38:00 +0000 (UTC) Received: (qmail 35385 invoked by uid 500); 30 Jan 2015 13:37:57 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 35347 invoked by uid 500); 30 Jan 2015 13:37:57 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 35336 invoked by uid 99); 30 Jan 2015 13:37:57 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 Jan 2015 13:37:57 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of mlowicki@gmail.com designates 74.125.82.181 as permitted sender) Received: from [74.125.82.181] (HELO mail-we0-f181.google.com) (74.125.82.181) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 30 Jan 2015 13:37:31 +0000 Received: by mail-we0-f181.google.com with SMTP id k48so27206084wev.12 for ; Fri, 30 Jan 2015 05:37:30 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=T0qQSLhCaNl6WHZEWDsIEzVTwD28WNdDlItCD+POrks=; b=Mm5MrxfQfLXi4Qat2cDlzH5S/fNPjT01h+UGnykwLJ9PkskAsJTnighVDFzISViind HVhbadg5p5sk2vQnacq5USjeFxALQfBKYerJsZ20pHzi4I4CojkMteYPUPPK/JVCnG5J N3C5EInfsFmv8x2zvjoUY+pDBbKtx2SWTUSxg37meMAL5CAqGjhidh99ijFNtt4smHeX Z3b7VArlfUlkKYON2lESNtF2+axV+SXpMExEJYPaC1oQyegCUrhXAwOLlPxE9s7qOO6S WXY7gvwPOb1xXIgilVghTRgYkWiWOsBMKsq/OnoRrxcvwgHqqa8tK1fdxBQo54hCeukI 2vnw== MIME-Version: 1.0 X-Received: by 10.180.207.83 with SMTP id lu19mr4905104wic.52.1422625049417; Fri, 30 Jan 2015 05:37:29 -0800 (PST) Received: by 10.194.6.38 with HTTP; Fri, 30 Jan 2015 05:37:29 -0800 (PST) In-Reply-To: <1136326405.1810907.1422624518948.JavaMail.yahoo@mail.yahoo.com> References: <1136326405.1810907.1422624518948.JavaMail.yahoo@mail.yahoo.com> Date: Fri, 30 Jan 2015 14:37:29 +0100 Message-ID: Subject: Re: Timeouts but returned consistency level is invalid From: =?UTF-8?B?TWljaGHFgiDFgW93aWNraQ==?= To: user@cassandra.apache.org, Jan Content-Type: multipart/alternative; boundary=001a11c3a6b8b81efe050ddeb46a X-Virus-Checked: Checked by ClamAV on apache.org --001a11c3a6b8b81efe050ddeb46a Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi Jan, I'm using only one keyspace. Even if it defaults to ONE why sometimes ALL is returned? On Fri, Jan 30, 2015 at 2:28 PM, Jan wrote: > HI Michal; > > The consistency level defaults to ONE for all write and read operations. > However consistency level is also set for the keyspace. > > Could it be possible that your queries are spanning multiple keyspaces > which bear different levels of consistency ? > > cheers > Jan > > C* Architect > > > On Friday, January 30, 2015 1:36 AM, Micha=C5=82 =C5=81owicki > wrote: > > > Hi, > > We're using C* 2.1.2, django-cassandra-engine which in turn uses > cqlengine. LOCAL_QUROUM is set as default consistency level. From time to > time we get timeouts while talking to the database but what is strange > returned consistency level is not LOCAL_QUROUM: > > code=3D1200 [Coordinator node timed out waiting for replica nodes' respon= ses] message=3D"Operation timed out - received only 3 responses." info=3D{'= received_responses': 3, 'required_responses': 4, 'consistency': 'ALL'} > > > code=3D1200 [Coordinator node timed out waiting for replica nodes' respon= ses] message=3D"Operation timed out - received only 1 responses." info=3D{'= received_responses': 1, 'required_responses': 2, 'consistency': 'LOCAL_QUOR= UM'} > > > code=3D1100 [Coordinator node timed out waiting for replica nodes' respon= ses] message=3D"Operation timed out - received only 0 responses." info=3D{'= received_responses': 0, 'required_responses': 1, 'consistency': 'ONE'} > > > Any idea why it might happen? > > -- > BR, > Micha=C5=82 =C5=81owicki > > > --=20 BR, Micha=C5=82 =C5=81owicki --001a11c3a6b8b81efe050ddeb46a Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi Jan,

I'm using only one keyspace= . Even if it defaults to ONE why sometimes ALL is returned?

On Fri, Jan 30, 2015 = at 2:28 PM, Jan <cnet62@yahoo.com> wrote:
HI Michal;=C2=A0

The consistency level defaults to ONE for all write and read ope= rations.
However=C2=A0consistency level is also set=C2=A0for the keyspace.=C2=A0

Could it be possible that your queries are span= ning multiple keyspaces which bear different levels of consistency ? =C2=A0=

cheers
Jan

C* Architect


=
=
On Friday, January 30, 2015 1:36 A= M, Micha=C5=82 =C5=81owicki <mlowicki@gmail.com> wrote:


=
Hi,

We're using C* 2.1.2= , django-cassandra-engine which in turn uses cqlengine. LOCAL_QUROUM is set= as default consistency level. From time to time we get timeouts while talk= ing to the database but what is strange returned consistency level is not L= OCAL_QUROUM:

code=3D1200 [Coordinator node ti=
med out waiting for replica nodes' responses] message=3D"Operation=
 timed out - received only 3 responses." info=3D{'received_respons=
es': 3, 'required_responses': 4, 'consistency': 'AL=
L'}

code=3D1200 [Coordinator n=
ode timed out waiting for replica nodes' responses] message=3D"Ope=
ration timed out - received only 1 responses." info=3D{'received_r=
esponses': 1, 'required_responses': 2, 'consistency': &=
#39;LOCAL_QUORUM'}

code=3D1=
100 [Coordinator node timed out waiting for replica nodes' responses] m=
essage=3D"Operation timed out - received only 0 responses." info=
=3D{'received_responses': 0, 'required_responses': 1, '=
consistency': 'ONE'}

Any = idea why it might happen?

--
BR,
Micha=C5= =82 =C5=81owicki


<= /div>



--
BR,
Micha=C5=82 =C5=81owicki
--001a11c3a6b8b81efe050ddeb46a--