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 ACB281837D for ; Thu, 4 Feb 2016 21:02:29 +0000 (UTC) Received: (qmail 69452 invoked by uid 500); 4 Feb 2016 21:02:17 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 69407 invoked by uid 500); 4 Feb 2016 21:02:17 -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 69397 invoked by uid 99); 4 Feb 2016 21:02:17 -0000 Received: from Unknown (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 04 Feb 2016 21:02:17 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 4D0BCC0D8E for ; Thu, 4 Feb 2016 21:02:17 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.279 X-Spam-Level: * X-Spam-Status: No, score=1.279 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=eventbrite-com.20150623.gappssmtp.com Received: from mx1-us-east.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id 2wlXeVQ4jPD4 for ; Thu, 4 Feb 2016 21:02:16 +0000 (UTC) Received: from mail-lf0-f54.google.com (mail-lf0-f54.google.com [209.85.215.54]) by mx1-us-east.apache.org (ASF Mail Server at mx1-us-east.apache.org) with ESMTPS id 09E794380B for ; Thu, 4 Feb 2016 21:02:16 +0000 (UTC) Received: by mail-lf0-f54.google.com with SMTP id m1so45480342lfg.0 for ; Thu, 04 Feb 2016 13:02:15 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eventbrite-com.20150623.gappssmtp.com; s=20150623; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=hRQ4M7kb+wn102tCEHYb6081Z8EJYO1pdIneUti5xgw=; b=drC0yVkgiy7rYtNQqtsa4w9rl2l+kp/Mwc0HfPtXmKoAo6iHurfFS+tLhP4TW9p+ih Jgz5dMyQmlkhonsIUE61PICu/LTM+zuIGFsWFpwLWCSnnXS3vVEKuhTJcinIUe94goag EPcgZetMncN5nw8lmU4eh5stRKiXbh8zXe6RIAlXIr7hG6ztpeT3HpzuCV+D/NPNFO8V Lf0RfCGLmU3qNSWsJA0Nrtt58spetIvg+e+do2CQ4kZGRANMwUuJOhgI4zoB8oI93BK/ zHq62fVvpRu72avwDmLLxzrcpiq78Ihrv1p6KPzkkQk47dH0F5MWc1w4xUm14FnTDmd9 iL9w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:to:content-type; bh=hRQ4M7kb+wn102tCEHYb6081Z8EJYO1pdIneUti5xgw=; b=V+3QUGvTJUls7D3RR2sPzFRXbC941Z4qMCsKfeNJ7XPixQBytYydX7kyKdDN8g2kds jTFI5V2VPeyQqgFmR75FcuskgFAd7Dah/QFAIuPfomRnokkUiV3Ya6dDCUrUQN6FaVRg xY8Xn/3Xv0bdf3pV779JsZIkg3OdijMow+aH5k8shA7BpFOgsKUbb7Dwjzj1eJPP6RB4 8oTQpbP7TjKm6bcMIEJVVSCPMGf55gVdopUAaehygroTEieACFtlAP9v/8XiqA+dS2Tk US/8Zus1e57EAxTlvhxbCFCF9ht6dYZ0gbBBWYrlDDaD9lRmQlx5dpVLhdCATAo5A6Rp yccQ== X-Gm-Message-State: AG10YOQw2Yfiv0MHSrPC/gatCQkQc037zftnmdw1NI7YkN65pfxtJ2H2D9dxLBggxKr+ysX2iRGg6HtvNRe//RHJ MIME-Version: 1.0 X-Received: by 10.25.156.83 with SMTP id f80mr4577082lfe.75.1454619728836; Thu, 04 Feb 2016 13:02:08 -0800 (PST) Received: by 10.114.172.4 with HTTP; Thu, 4 Feb 2016 13:02:08 -0800 (PST) In-Reply-To: References: Date: Thu, 4 Feb 2016 13:02:08 -0800 Message-ID: Subject: Re: "Not enough replicas available for query" after reboot From: Robert Coli To: "user@cassandra.apache.org" Content-Type: multipart/alternative; boundary=001a11410756389c23052af80c8d --001a11410756389c23052af80c8d Content-Type: text/plain; charset=UTF-8 On Thu, Feb 4, 2016 at 12:53 PM, Flavien Charlon wrote: > My cluster was running fine. I rebooted all three nodes (one by one), and > now all nodes are back up and running. "nodetool status" shows UP for all > three nodes on all three nodes: > > -- Address Load Tokens Owns Host ID > Rack > UN xx.xx.xx.xx 331.84 GB 1 ? > d3d3a79b-9ca5-43f9-88c4-c3c7f08ca538 RAC1 > UN xx.xx.xx.xx 317.2 GB 1 ? > de7917ed-0de9-434d-be88-bc91eb4f8713 RAC1 > UN xx.xx.xx.xx 291.61 GB 1 ? > b489c970-68db-44a7-90c6-be734b41475f RAC1 > > However, now the client application fails to run queries on the cluster > with: > > Cassandra.UnavailableException: Not enough replicas available for query at >> consistency Quorum (2 required but only 1 alive) > > Do *all* nodes see each other as UP/UN? =Rob --001a11410756389c23052af80c8d Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
On T= hu, Feb 4, 2016 at 12:53 PM, Flavien Charlon <flavien.charlon@gma= il.com> wrote:
My cluster was running fine. I rebooted all three nodes (one by o= ne), and now all nodes are back up and running. "nodetool status"= shows UP for all three nodes on all three nodes:

=
-- =C2=A0Address =C2=A0 =C2=A0 =C2=A0 =C2=A0Load =C2=A0 =C2=A0 =C2=A0 = Tokens =C2=A0Owns =C2=A0 =C2=A0Host ID =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Rack<= /div>
UN =C2=A0xx.xx.xx.xx =C2=A0 =C2=A0331.84 GB =C2=A01 =C2=A0 =C2=A0= =C2=A0 ? =C2=A0 =C2=A0 =C2=A0 d3d3a79b-9ca5-43f9-88c4-c3c7f08ca538 =C2=A0R= AC1
UN =C2=A0xx.xx.xx.xx=C2=A0=C2=A0 =C2=A0317.2 GB =C2=A0 1 =C2= =A0 =C2=A0 =C2=A0 ? =C2=A0 =C2=A0 =C2=A0 de7917ed-0de9-434d-be88-bc91eb4f87= 13 =C2=A0RAC1
UN =C2=A0xx.xx.xx.xx=C2=A0=C2=A0291.61 GB =C2=A01 = =C2=A0 =C2=A0 =C2=A0 ? =C2=A0 =C2=A0 =C2=A0 b489c970-68db-44a7-90c6-be734b4= 1475f =C2=A0RAC1

However, now the client app= lication fails to run queries on the cluster with:

Cassandra.UnavailableException: Not enough replicas available = for query at consistency Quorum (2 required but only 1 alive)
<= /div>

Do *all* nodes see each other as UP/U= N?

=3DRob
=C2=A0
--001a11410756389c23052af80c8d--