From user-return-64005-archive-asf-public=cust-asf.ponee.io@cassandra.apache.org Wed Jun 12 03:29:58 2019 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with SMTP id E7192180627 for ; Wed, 12 Jun 2019 05:29:57 +0200 (CEST) Received: (qmail 10612 invoked by uid 500); 12 Jun 2019 03:29:52 -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 10602 invoked by uid 99); 12 Jun 2019 03:29:52 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 12 Jun 2019 03:29:52 +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 CA6BAC2852 for ; Wed, 12 Jun 2019 03:29:51 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 0.001 X-Spam-Level: X-Spam-Status: No, score=0.001 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H2=-0.001, SPF_HELO_NONE=0.001, SPF_NONE=0.001] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=pbandjelly-org.20150623.gappssmtp.com Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id X4T4pKIUICs8 for ; Wed, 12 Jun 2019 03:29:50 +0000 (UTC) Received: from mail-it1-f180.google.com (mail-it1-f180.google.com [209.85.166.180]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTPS id CE56C5FBCA for ; Wed, 12 Jun 2019 03:29:49 +0000 (UTC) Received: by mail-it1-f180.google.com with SMTP id k134so3703355ith.1 for ; Tue, 11 Jun 2019 20:29:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pbandjelly-org.20150623.gappssmtp.com; s=20150623; h=sender:subject:to:references:from:message-id:date:user-agent :mime-version:in-reply-to:content-language:content-transfer-encoding; bh=AAXcJaCrmmbSMwZegDAtdV5ad8uiYDbVKm6ni6iq3jM=; b=jV1hNgSEA2Nopo5vC4tiKFV0eFRp+3RHFLtHxzuXiknG/Gcn7cYUYFLQbitgnQ7rbS tF44yGbWICIndU65PMKcgOzmN/8Xek2qpV8rzrld5LkLHih0goOjRg2KVhgOFE0i0nAD dc8mqr1ZrJnFfU6W2lFzoq3gzDdrs2E+Qjz21+QpDPZ1Y7LMXj5z/wyCQtTvZnbNZlrI nD49LRekzWZO9mc8Si7nPsiccnKKmZRJ2NisG/B15gYcI9sMLvRx6YeVISCUOHbTF5hl bfwczxK9upeW8KBWh5X8c2TY+YClMRcE+kiqqqC7DNLq3EncMv3K65KBFXOpjffjrDIZ a7Jw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:sender:subject:to:references:from:message-id :date:user-agent:mime-version:in-reply-to:content-language :content-transfer-encoding; bh=AAXcJaCrmmbSMwZegDAtdV5ad8uiYDbVKm6ni6iq3jM=; b=kB+4Nq+7nMJTnLw0SKkcsiGF5T8wNScQ1A/ZGTQdwPPdvUptXsh5UeFaIFpP3PU662 fe/DnQ1nnIjWDy8T/ivutSAa6wdyXS8hMT8sRg31G/IoYJ9atlvrGppsbjotkpW3GaeX 8WiQmwaFLHMWwYa4mmB/wbk03Sm/ospCEyrrlwCQ58U5jBvfkt9asVUZWQnRnC/OTXxY rDvHFV6tc1oCBSaMycrH7KV7kMYr49HeSpYCEu5D5PpZ6KpHU27WiUn0sOb9ObmZuxMD uAYtzzUdOQAt4NjihEd9+sDAjhFEc9PIAS86OcQ+KIhXr+xnx+IftYQnRp0lF/tRcwAW nZJw== X-Gm-Message-State: APjAAAXP43msZ5DIsMlqHnJNeJjzojMgqgBHl17pjBRuYp/ovQk5F0wW VXgqooHad+LmWxPfwrMuzOgFrhN+T5k= X-Google-Smtp-Source: APXvYqxcRW6qmDZGIOpVopmEC7APDtCT8CJ/L87Dgc/J0Osm9h3O3Fr4Rp4EQPtE6aYw4g9zcqzmtQ== X-Received: by 2002:a24:9302:: with SMTP id y2mr10462026itd.77.1560310189030; Tue, 11 Jun 2019 20:29:49 -0700 (PDT) Received: from [192.168.1.43] (072-182-033-162.res.spectrum.com. [72.182.33.162]) by smtp.googlemail.com with ESMTPSA id q9sm5271127iot.80.2019.06.11.20.29.47 for (version=TLS1_3 cipher=AEAD-AES128-GCM-SHA256 bits=128/128); Tue, 11 Jun 2019 20:29:48 -0700 (PDT) Sender: Michael Shuler Subject: Re: Is my range read query behaving strange ? To: user@cassandra.apache.org References: From: Michael Shuler Message-ID: Date: Tue, 11 Jun 2019 22:29:46 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.7.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: en-US Content-Transfer-Encoding: 8bit (dropped dev@ x-post; user@ was correct) Possibly #12765, fixed in 2.1.17. Wouldn't hurt to update to latest 2.1.21. https://issues.apache.org/jira/browse/CASSANDRA-12765 https://github.com/apache/cassandra/blob/cassandra-2.1/CHANGES.txt#L1-L36 Michael On 6/11/19 9:58 PM, Laxmikant Upadhyay wrote: > Does range query ignore purgable tombstone (which crossed grace period) > in some cases? > > On Tue, Jun 11, 2019, 2:56 PM Laxmikant Upadhyay > > wrote: > > In a 3 node cassandra 2.1.16 cluster where, one node has old > mutation and two nodes have evict-able (crossed gc grace period) > tombstone produced by TTL. A read range  query with local quorum > return the old mutation as result. However expected result should be > empty. Next time running the same query results no data as expected. > Why this strange behaviour? > > > *Steps to Reproduce :* > Create a cassandra-2.1.16  3 node cluster. Disable hinted handoff > for each node. > > #ccm node1 nodetool ring > Datacenter: datacenter1 > ========== > Address    Rack        Status State   Load            Owns >      Token > >       3074457345618258602 > 127.0.0.1  rack1       Up     Normal  175.12 KB       100.00% >       -9223372036854775808 > 127.0.0.2  rack1       Up   Normal  177.87 KB       100.00% >     -3074457345618258603 > 127.0.0.3  rack1       Up   Normal  175.13 KB       100.00% >     3074457345618258602 > > #Connect to cqlsh and set CONISISTENCY LOCAL_QUORUM; > > cqlsh> CREATE KEYSPACE IF NOT EXISTS test WITH REPLICATION = { > 'class' : 'NetworkTopologyStrategy', 'datacenter1' : 3 }; > cqlsh> CREATE TABLE test.table1 (key text, col text, val > text,PRIMARY KEY ((key), col)); > cqlsh> ALTER TABLE test.table1  with GC_GRACE_SECONDS = 120; > > cqlsh> INSERT INTO test.table1  (key, col, val) VALUES ('key2', > 'abc','xyz'); > > #ccm flush > > #ccm node3 stop > > cqlsh> INSERT INTO test.table1  (key, col, val) VALUES ('key2', > 'abc','xyz') USING TTL 60; > > #ccm flush > > #wait for 3 min so that the tombstone crosses its gc grace period. > > #ccm node3 start > > cqlsh> select * from test.table1 where token (key) > > 3074457345618258602 and token (key) < -9223372036854775808 ; > >  key  | col | val > ------+-----+----- >  key2 | abc | xyz > > (1 rows) > > #ccm flush > -> Here read repair triggers and the old mutation moves to the one > of the node where tombstone is present (not both the node) > > > cqlsh> select * from test.vouchers where token (key) > > 3074457345618258602 and token (key) < -9223372036854775808 ; > >  key | col | val > -----+-----+----- > > (0 rows) > > > -- > > regards, > Laxmikant Upadhyay > --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscribe@cassandra.apache.org For additional commands, e-mail: user-help@cassandra.apache.org