From user-return-64309-archive-asf-public=cust-asf.ponee.io@cassandra.apache.org Mon Aug 5 07:08:43 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 82A5A180181 for ; Mon, 5 Aug 2019 09:08:43 +0200 (CEST) Received: (qmail 51172 invoked by uid 500); 5 Aug 2019 07:08:39 -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 51157 invoked by uid 99); 5 Aug 2019 07:08:39 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 05 Aug 2019 07:08:39 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id A5F311A33E7 for ; Mon, 5 Aug 2019 07:08:38 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.801 X-Spam-Level: * X-Spam-Status: No, score=1.801 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, HTML_MESSAGE=2, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=zalando.de Received: from mx1-he-de.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id PFaUv0FHlVJ5 for ; Mon, 5 Aug 2019 07:08:35 +0000 (UTC) Received-SPF: Pass (mailfrom) identity=mailfrom; client-ip=2a00:1450:4864:20::132; helo=mail-lf1-x132.google.com; envelope-from=oleksandr.shulgin@zalando.de; receiver= Received: from mail-lf1-x132.google.com (mail-lf1-x132.google.com [IPv6:2a00:1450:4864:20::132]) by mx1-he-de.apache.org (ASF Mail Server at mx1-he-de.apache.org) with ESMTPS id EE2E27DC5E for ; Mon, 5 Aug 2019 07:08:34 +0000 (UTC) Received: by mail-lf1-x132.google.com with SMTP id c19so57063726lfm.10 for ; Mon, 05 Aug 2019 00:08:34 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=zalando.de; s=google; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=dDhZswyUb5CdgM8rxDJOrcrOZavvgXDOK8rbkAbhkaU=; b=ANW76oe9P5UXRKxxotFanSlTEkNFH3SsrGsxKPFaJw0TTQ/u4p05scDWU5VPABHRWk UzFEfu/mNhna/rdPyT+4EEFNw01gdU8CKbSfPKkIUvgfQ14wdE4GaPTOkO3TC3H22sKh 9+6YpHDFswO4gtQU+sxkXRqfsXTcFFKX+jUe1VnBWo8NuW2fTsKVZsL5E3clIVoAxJrz WwqP1Tl2ddNOnrSkNPRusDN96IRsetpIlB3ow4jcMXkDqff2XbOMrZ5OSeaX9UxQKbs4 WQLYclZwFUyrsQC3UgytVsdwQeOtJ8KkslJZs75lYMtj7ttmhwEbZEXjju1Xj/jfaJDK YL5Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=dDhZswyUb5CdgM8rxDJOrcrOZavvgXDOK8rbkAbhkaU=; b=mB6DIV3SQdFRidbgc/1BJwU/juF/sEiVh/eWR+xT1WjBvc8XmoT/0BJo4UhaPK8BM4 81M/rePmwyNTW2JH+Q39UdWkm/h2h2HlaSBSYLM9/Jy780KuQr7cUPq1UPGwoREUjHNv LqBizfmc48TBjRd3p8IAzvUfg96UGzfPe3qJCk+9noHcOUA5Ui7UaLQQ2rfM3UXzJSps 9ienxMja6ujYL86ghxpgHLWWLGh9mVM44V1JNYj8vtXPR8CVL/HVanNMotusF8hl8mFy GZ/YFihRr4jPfCDorvgEFj96RsEigzJmGpK8N9drVoRqfkX59kHuNY+V2yllfyYmEVx4 qSZQ== X-Gm-Message-State: APjAAAUJwHFx8Ev1NY8OlvxvrHAPh4+RgzGH2GFrjLnP47jCvg87E28M E+OUFj1FeTKayxAgtYXgXfWphEQf1pwgUEtO+3BRAfuKNPcsuA== X-Google-Smtp-Source: APXvYqz07krzoVZ8yguJmzrOYqDbSZ1WRRP/HS0tG24KfLWLSvzWD7LY/rwqlr1I6ur25VQ8JVt/VumuZrfYwX7H+qM= X-Received: by 2002:a19:78e:: with SMTP id 136mr72120250lfh.48.1564988913767; Mon, 05 Aug 2019 00:08:33 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Oleksandr Shulgin Date: Mon, 5 Aug 2019 09:08:07 +0200 Message-ID: Subject: Re: Cassandra read requests not getting timeout To: User Content-Type: multipart/alternative; boundary="000000000000488949058f59608a" --000000000000488949058f59608a Content-Type: text/plain; charset="UTF-8" On Mon, Aug 5, 2019 at 8:50 AM nokia ceph wrote: > Hi Community, > > I am using Cassanadra 3.0.13 . 5 node cluster simple topology. Following > are the timeout parameters in yaml file: > > # grep timeout /etc/cassandra/conf/cassandra.yaml > cas_contention_timeout_in_ms: 1000 > counter_write_request_timeout_in_ms: 5000 > cross_node_timeout: false > range_request_timeout_in_ms: 10000 > read_request_timeout_in_ms: 10000 > request_timeout_in_ms: 10000 > truncate_request_timeout_in_ms: 60000 > write_request_timeout_in_ms: 2000 > > i'm trying a cassandra query using cqlsh and it is not getting timeout. > > #time cqlsh 10.50.11.11 -e "CONSISTENCY QUORUM; select > asset_name,profile_name,job_index,active,last_valid_op,last_valid_op_ts,status,status_description,live_depth,asset_type,dest_path,source_docroot_name,source_asset_name,start_time,end_time,iptv,drm,geo,last_gc > from cdvr.jobs where model_type ='asset' AND docroot_name='vx0000030' > LIMIT 100000 ALLOW FILTERING;" > Consistency level set to QUORUM. > (....) > (....) > (79024 rows) > > real 16m30.488s > user 0m39.761s > sys 0m3.896s > > The query took 16.5 minutes to display the output. But my > read_request_timeout is 10 seconds. why the query doesn't got timeout after > 10 s ?? > Hi Renoy, Have you tried the same query with enabling TRACING beforehand? https://docs.datastax.com/en/archived/cql/3.3/cql/cql_reference/cqlshTracing.html It doesn't sound all too likely that it has taken the client 16 minutes to display the resultset, but this is definitely not included in the request timeout from the server point of view. Cheers, -- Alex --000000000000488949058f59608a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Mon, Aug 5, 2019 at 8:50 AM nokia ceph= <nokiacephusers@gmail.com> wrote:
#time cqlsh 10.50.11.11 -e "CONSISTENCY QUORUM; select asse= t_name,profile_name,job_index,active,last_valid_op,last_valid_op_ts,status,= status_description,live_depth,asset_type,dest_path,source_docroot_name,sour= ce_asset_name,start_time,end_time,iptv,drm,geo,last_gc from cdvr.jobs where model_type =3D'asse= t' AND docroot_name=3D'vx0000030' =C2=A0LIMIT 100000 ALLOW FILT= ERING;"
Consistency level set to QUORUM.
(....)
(....= )
(79024 rows)

real =C2=A0 =C2=A016m30.488s
user =C2=A0= =C2=A00m39.761s
sys =C2=A0 =C2=A0 0m3.896s
=C2=A0
The query took 16.5 minutes=C2=A0 to display the output. But my read_req= uest_timeout is 10 seconds. why the query doesn't got timeout after 10 = s ??

Hi Renoy,

Have you tried the same query with enabling TRACING beforehand?

It doesn= 't sound all too likely that it has taken the client 16 minutes to disp= lay the resultset, but this is definitely not included in the request timeo= ut from the server point of view.

Cheers,
--
Alex

--000000000000488949058f59608a--