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 E6CFE4E86 for ; Mon, 11 Jul 2011 18:38:33 +0000 (UTC) Received: (qmail 47440 invoked by uid 500); 11 Jul 2011 18:38:31 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 47409 invoked by uid 500); 11 Jul 2011 18:38:31 -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 47401 invoked by uid 99); 11 Jul 2011 18:38:30 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 11 Jul 2011 18:38:30 +0000 X-ASF-Spam-Status: No, hits=2.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_SOFTFAIL X-Spam-Check-By: apache.org Received-SPF: softfail (nike.apache.org: transitioning domain of hfyuan@rhapsody.com does not designate 74.125.83.44 as permitted sender) Received: from [74.125.83.44] (HELO mail-gw0-f44.google.com) (74.125.83.44) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 11 Jul 2011 18:38:21 +0000 Received: by gwb20 with SMTP id 20so1951600gwb.31 for ; Mon, 11 Jul 2011 11:38:01 -0700 (PDT) Received: by 10.142.249.27 with SMTP id w27mr2106072wfh.78.1310409480752; Mon, 11 Jul 2011 11:38:00 -0700 (PDT) Received: from cafebabe.sea1.rhapsody.com (rev-66-150-171-4.rhapsody.com [66.150.171.4]) by mx.google.com with ESMTPS id z39sm8837343wfd.23.2011.07.11.11.37.59 (version=TLSv1/SSLv3 cipher=OTHER); Mon, 11 Jul 2011 11:37:59 -0700 (PDT) From: Hefeng Yuan Mime-Version: 1.0 (Apple Message framework v1084) Content-Type: multipart/alternative; boundary=Apple-Mail-5--757677433 Subject: Secondary Index doesn't work with LOCAL_QUORUM Date: Mon, 11 Jul 2011 11:38:07 -0700 In-Reply-To: <8802FA2D-4115-4EF2-94DE-38F3657DD7EF@rhapsody.com> To: user@cassandra.apache.org References: <8802FA2D-4115-4EF2-94DE-38F3657DD7EF@rhapsody.com> Message-Id: <8E7F617B-748B-40AC-8C95-EDFB4C7CD47D@rhapsody.com> X-Mailer: Apple Mail (2.1084) X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail-5--757677433 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Hi, We're using Cassandra with 2 DC - one OLTP Cassandra, 6 nodes, with RF3 - the other is a Brisk, 3 nodes, with RF1 We noticed that when I do a write-then-read operation on the Cassandra = DC, it fails with the following information (from cqlsh): Unable to complete request: one or more nodes were unavailable. - write: LOCAL_QUORUM, successful - read: LOCAL_QUORUM, using the secondary indexed column, fail Seems it's taking a long while working on this. When I retry the same = query after ~10 minutes, it succeeds actually. Any help is appreciated. Thanks, Hefeng= --Apple-Mail-5--757677433 Content-Transfer-Encoding: 7bit Content-Type: text/html; charset=us-ascii Hi,

We're using Cassandra with 2 DC
- one OLTP Cassandra, 6 nodes, with RF3
- the other is a Brisk, 3 nodes, with RF1

We noticed that when I do a write-then-read operation on the Cassandra DC, it fails with the following information (from cqlsh):
Unable to complete request: one or more nodes were unavailable.
- write: LOCAL_QUORUM, successful
- read: LOCAL_QUORUM, using the secondary indexed column, fail

Seems it's taking a long while working on this. When I retry the same query after ~10 minutes, it succeeds actually.

Any help is appreciated.

Thanks,
Hefeng
--Apple-Mail-5--757677433--