Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 36B55200B98 for ; Mon, 3 Oct 2016 22:55:17 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 351B4160ADC; Mon, 3 Oct 2016 20:55:17 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 35996160ACD for ; Mon, 3 Oct 2016 22:55:15 +0200 (CEST) Received: (qmail 81669 invoked by uid 500); 3 Oct 2016 20:55:13 -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 81659 invoked by uid 99); 3 Oct 2016 20:55:13 -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; Mon, 03 Oct 2016 20:55:13 +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 EA84DC0D64 for ; Mon, 3 Oct 2016 20:55:12 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 3 X-Spam-Level: *** X-Spam-Status: No, score=3 tagged_above=-999 required=6.31 tests=[HTML_MESSAGE=2, KAM_LAZY_DOMAIN_SECURITY=1] autolearn=disabled Received: from mx2-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 049QRsfxf8kV for ; Mon, 3 Oct 2016 20:55:08 +0000 (UTC) Received: from mx0b-00206401.pphosted.com (mx0b-00206401.pphosted.com [148.163.152.21]) by mx2-lw-us.apache.org (ASF Mail Server at mx2-lw-us.apache.org) with ESMTPS id 38FAC5FBB7 for ; Mon, 3 Oct 2016 20:55:07 +0000 (UTC) Received: from pps.filterd (m0093025.ppops.net [127.0.0.1]) by mx0b-00206401.pphosted.com (8.16.0.17/8.16.0.17) with SMTP id u93Ksa5B020901 for ; Mon, 3 Oct 2016 13:55:01 -0700 Received: from ee01.crowdstrike.sys (dragosx.crowdstrike.com [208.42.231.60]) by mx0b-00206401.pphosted.com with ESMTP id 25tc1a14gu-1 (version=TLSv1 cipher=ECDHE-RSA-AES256-SHA bits=256 verify=NOT) for ; Mon, 03 Oct 2016 13:55:01 -0700 Received: from casmbox02.crowdstrike.sys (10.3.0.20) by ee01.crowdstrike.sys (10.100.0.12) with Microsoft SMTP Server (TLS) id 15.0.847.32; Mon, 3 Oct 2016 13:55:03 -0700 Received: from Casmbox03.crowdstrike.sys (10.100.11.66) by casmbox02.crowdstrike.sys (10.3.0.20) with Microsoft SMTP Server (TLS) id 15.0.1210.3; Mon, 3 Oct 2016 13:54:58 -0700 Received: from Casmbox03.crowdstrike.sys ([fe80::791d:4b4b:db82:a11a]) by Casmbox03.crowdstrike.sys ([fe80::791d:4b4b:db82:a11a%25]) with mapi id 15.00.1210.000; Mon, 3 Oct 2016 13:54:57 -0700 From: Jeff Jirsa To: "user@cassandra.apache.org" Subject: Re: Row cache not working Thread-Topic: Row cache not working Thread-Index: AQHSG4IJYm+CLenAIEin/JkqHqLd2KCXiDWA//+rEICAAHc9gP//j0QA Date: Mon, 3 Oct 2016 20:54:57 +0000 Message-ID: <3DD75384-1382-44E2-86B2-0230DC5E3752@crowdstrike.com> References: <625FE3A2-00DA-41CF-9C1D-04E843EEAE71@crowdstrike.com> In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: yes X-MS-TNEF-Correlator: x-ms-exchange-messagesentrepresentingtype: 1 x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [10.100.0.9] x-disclaimer: USA Content-Type: multipart/signed; protocol="application/pkcs7-signature"; micalg=sha256; boundary="B_3558347696_1781181876" MIME-Version: 1.0 X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:,, definitions=2016-10-03_11:,, signatures=0 X-Proofpoint-Spam-Details: rule=russia_temp_notspam policy=russia_temp score=0 priorityscore=1501 malwarescore=0 suspectscore=0 phishscore=0 bulkscore=0 spamscore=0 clxscore=1015 lowpriorityscore=0 impostorscore=0 adultscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.0.1-1609280000 definitions=main-1610030357 archived-at: Mon, 03 Oct 2016 20:55:17 -0000 --B_3558347696_1781181876 Content-type: multipart/alternative; boundary="B_3558347696_489946133" --B_3558347696_489946133 Content-transfer-encoding: quoted-printable Content-Type: text/plain; charset="utf-8" Seems like it=E2=80=99s probably worth opening a jira issue to track it (ei= ther to confirm it=E2=80=99s a bug, or to be able to better explain if/that= it=E2=80=99s working as intended =E2=80=93 the row cache is probably missi= ng because trace indicates the read isn=E2=80=99t cacheable, but I suspect = it should be cacheable).=20 =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=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=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=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=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= =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=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=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=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=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= =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=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=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=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=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= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=20 Do note, though, that setting rows_per_partition to ALL can be very very ve= ry dangerous if you have very wide rows in any of your tables with row cach= e enabled. =20 =20 =20 From: Abhinav Solan Reply-To: "user@cassandra.apache.org" Date: Monday, October 3, 2016 at 1:38 PM To: "user@cassandra.apache.org" Subject: Re: Row cache not working =20 It's cassandra 3.0.7,=20=20 I had to set caching =3D {'keys': 'ALL', 'rows_per_partition': 'ALL'}, then= only it works don't know why. If I set 'rows_per_partition':'1' then it does not work. =20 Also wanted to ask one thing, if I set row_cache_save_period: 60 then this = cache would be refreshed automatically or it would be lazy, whenever the fe= tch call is made then only it caches it. =20 On Mon, Oct 3, 2016 at 1:31 PM Jeff Jirsa wrot= e: Which version of Cassandra are you running (I can tell it=E2=80=99s newer t= han 2.1, but exact version would be useful)?=20 =20 From: Abhinav Solan Reply-To: "user@cassandra.apache.org" Date: Monday, October 3, 2016 at 11:35 AM To: "user@cassandra.apache.org" Subject: Re: Row cache not working =20 Hi, can anyone please help me with this=20 =20 Thanks, Abhinav =20 On Fri, Sep 30, 2016 at 6:20 PM Abhinav Solan wro= te: Hi Everyone,=20 =20 My table looks like this - CREATE TABLE test.reads ( svc_pt_id bigint, meas_type_id bigint, flags bigint, read_time timestamp, value double, PRIMARY KEY ((svc_pt_id, meas_type_id)) ) WITH bloom_filter_fp_chance =3D 0.1 AND caching =3D {'keys': 'ALL', 'rows_per_partition': '10'} AND comment =3D '' AND compaction =3D {'class': 'org.apache.cassandra.db.compaction.Levele= dCompactionStrategy'} AND compression =3D {'chunk_length_in_kb': '64', 'class': 'org.apache.c= assandra.io.compress.LZ4Compressor'} AND crc_check_chance =3D 1.0 AND dclocal_read_repair_chance =3D 0.1 AND default_time_to_live =3D 0 AND gc_grace_seconds =3D 864000 AND max_index_interval =3D 2048 AND memtable_flush_period_in_ms =3D 0 AND min_index_interval =3D 128 AND read_repair_chance =3D 0.0 AND speculative_retry =3D '99PERCENTILE'; =20 Have set up the C* nodes with row_cache_size_in_mb: 1024 row_cache_save_period: 14400 =20 and I am making this query=20 select svc_pt_id, meas_type_id, read_time, value FROM cts_svc_pt_latest_int= _read where svc_pt_id =3D -9941235 and meas_type_id =3D 146; =20 with tracing on every time it says Row cache miss =20 activity = = | timestamp | source | source_elapsed ---------------------------------------------------------------------------= ---------------------------------------------------------------------------= -------------+----------------------------+-----------------+--------------= -- = Execut= e CQL3 query | 2016-09-30 18:15:00.446000 | 192.168.199.75 | 0 Parsing select svc_pt_id, meas_type_id, read_time, value FROM cts_svc_pt_l= atest_int_read where svc_pt_id =3D -9941235 and meas_type_id =3D 146; [Shar= edPool-Worker-1] | 2016-09-30 18:15:00.446000 | 192.168.199.75 | = 111 = Preparing statement [SharedPo= ol-Worker-1] | 2016-09-30 18:15:00.446000 | 192.168.199.75 | 209 = reading data from /192.168.170.186 [SharedPo= ol-Worker-1] | 2016-09-30 18:15:00.446001 | 192.168.199.75 | 370 = Sending READ message to /192.168.170.186 [MessagingService-Outgoing-/192.= 168.170.186] | 2016-09-30 18:15:00.446001 | 192.168.199.75 | 450 REQUEST_RESPO= NSE message received from /192.168.170.186 [MessagingService-Incoming-/192.= 168.170.186] | 2016-09-30 18:15:00.448000 | 192.168.199.75 | 2469 = Processing response from /192.168.170.186 [SharedPo= ol-Worker-8] | 2016-09-30 18:15:00.448000 | 192.168.199.75 | 2609 = READ message received from /192.168.199.75 [MessagingService-Incoming-/192= .168.199.75] | 2016-09-30 18:15:00.449000 | 192.168.170.186 | 75 = Row cache miss [SharedPo= ol-Worker-2] | 2016-09-30 18:15:00.449000 | 192.168.170.186 | 218 Fetching data but not populat= ing cache as query does not query from the start of the partition [SharedPo= ol-Worker-2] | 2016-09-30 18:15:00.449000 | 192.168.170.186 | 246 = Executing single-partition query on cts_svc_pt_latest_int_read [SharedPo= ol-Worker-2] | 2016-09-30 18:15:00.449000 | 192.168.170.186 | 259 = Acquiring sstable references [SharedPo= ol-Worker-2] | 2016-09-30 18:15:00.449001 | 192.168.170.186 | 281 = Merging memtable contents [SharedPo= ol-Worker-2] | 2016-09-30 18:15:00.449001 | 192.168.170.186 | 295 = Merging data from sstable 8 [SharedPo= ol-Worker-2] | 2016-09-30 18:15:00.449001 | 192.168.170.186 | 326 = Key cache hit for sstable 8 [SharedPo= ol-Worker-2] | 2016-09-30 18:15:00.449001 | 192.168.170.186 | 351 = Merging data from sstable 7 [SharedPo= ol-Worker-2] | 2016-09-30 18:15:00.449001 | 192.168.170.186 | 439 = Key cache hit for sstable 7 [SharedPo= ol-Worker-2] | 2016-09-30 18:15:00.449001 | 192.168.170.186 | 468 = Read 1 live and 0 tombstone cells [SharedPo= ol-Worker-2] | 2016-09-30 18:15:00.449001 | 192.168.170.186 | 615 = Enqueuing response to /192.168.199.75 [SharedPo= ol-Worker-2] | 2016-09-30 18:15:00.449002 | 192.168.170.186 | 766 Sending = REQUEST_RESPONSE message to /192.168.199.75 [MessagingService-Outgoing-/192= .168.199.75] | 2016-09-30 18:15:00.449002 | 192.168.170.186 | 897 = Requ= est complete | 2016-09-30 18:15:00.448888 | 192.168.199.75 | 2888 =20 Can please anyone tell me what I am doing wrong? =20 Thanks, Abhinav ____________________________________________________________________ CONFIDENTIALITY NOTE: This e-mail and any attachments are confidential and = may be legally privileged. If you are not the intended recipient, do not di= sclose, copy, distribute, or use this email or any attachments. If you have= received this in error please let the sender know and then delete the emai= l and all attachments. ____________________________________________________________________ CONFIDENTIALITY NOTE: This e-mail and any attachments are confidential and = may be legally privileged. If you are not the intended recipient, do not di= sclose, copy, distribute, or use this email or any attachments. If you have= received this in error please let the sender know and then delete the emai= l and all attachments. --B_3558347696_489946133 Content-transfer-encoding: quoted-printable Content-Type: text/html; charset="utf-8"

Seems like it’s probably worth opening = a jira issue to track it (either to confirm it’s a bug, or to be able= to better explain if/that it’s working as intended – the row c= ache is probably missing because trace indicates the read isn’t cache= able, but I suspect it should be cacheable).

=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=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=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=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=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=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=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=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=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=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=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=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=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=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=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=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0

<= p class=3DMsoNormal>Do= note, though, that setting rows_per_partition to ALL can be very very very= dangerous if you have very wide rows in any of your tables with row cache = enabled.

 

 

 

From: Abhinav Solan <abhinav.solan@gmail.com&g= t;
Reply-To: "user@cassandra.apache.org" <user@cassa= ndra.apache.org>
Date: Monday, October 3, 2016 at 1:38 PM
<= b>To: "user@cassandra.apache.org" <user@cassandra.apache.o= rg>
Subject: Re: Row cache not working

 

It's cassandra 3.0.7, 

I had to set caching =3D {'keys': 'ALL', 'rows_per_partit= ion': 'ALL'}, then only it works don't know why.

<= p class=3DMsoNormal>If I set 'rows_per_partition':'1' then it does not work= .

 

=

Also wanted to ask one thing, if I set row_cache_= save_period: 60 then this cache would be refreshed automatically or it woul= d be lazy, whenever the fetch call is made then only it caches it.

 

On Mon, Oct 3, 2016 at 1:31 PM Jeff Jirsa <jeff.jirsa@crowdstrike.com> wrote:<= o:p>

Which version of Cassandra are you running (I can tell it’s = newer than 2.1, but exact version would be useful)?

 

From: Abhinav Solan <abhinav.solan@gmail.com>
Reply-To: = "user@c= assandra.apache.org" <user@cassandra.apache.org>
Date: Monday, October 3, 2016 at 11:35 AM
To: "user@cassandra.apache.org" <user@cassandra.apac= he.org>
Subject: Re: Row cac= he not working

 

Hi, can anyone ple= ase help me with this

 

Thanks,

Abhinav

=

 

On Fri, Sep 30, 20= 16 at 6:20 PM Abhinav Solan <abhinav.solan@gmail.com> wrote:

Hi Everyone,

 <= o:p>

My table looks like this -

CREATE TABLE test.reads (

    svc_pt_id bigint,

  =   meas_type_id bigint,

    f= lags bigint,

    read_time timest= amp,

    value double,=

    PRIMARY KEY ((svc_pt_id, meas_type_id))=

) WITH bloom_filter_fp_chance =3D 0.1=

    AND caching =3D {'keys': 'ALL', '= rows_per_partition': '10'}

    AN= D comment =3D ''

    AND compacti= on =3D {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrat= egy'}

    AND compression =3D {'c= hunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Com= pressor'}

    AND crc_check_chanc= e =3D 1.0

    AND dclocal_read_re= pair_chance =3D 0.1

    AND defau= lt_time_to_live =3D 0

    AND g= c_grace_seconds =3D 864000

    AN= D max_index_interval =3D 2048

   = AND memtable_flush_period_in_ms =3D 0

&nbs= p;   AND min_index_interval =3D 128

&= nbsp;   AND read_repair_chance =3D 0.0

    AND speculative_retry =3D '99PERCENTILE';

 

Have set up the = C* nodes with

row_cache_size_in_mb: 1024

row_cache_save_period: 14400

 

and I am making thi= s query 

select svc_pt_id, meas_type_i= d, read_time, value FROM cts_svc_pt_latest_int_read where svc_pt_id =3D -99= 41235 and meas_type_id =3D 146;

 =

with tracing on every time it says Row cache mi= ss

 

activity                  =                     &nbs= p;                     &n= bsp;                     =                      = ;                     &nb= sp;                     &= nbsp;      | timestamp           &n= bsp;      | source          | sourc= e_elapsed

---------------------------------= ---------------------------------------------------------------------------= -------------------------------------------------------+-------------------= ---------+-----------------+----------------

                    &nb= sp;                     &= nbsp;                    =                     &nbs= p;                     &n= bsp;                     =                 Execute CQL3 query = | 2016-09-30 18:15:00.446000 |  192.168.199.75 |       =        0

 Parsing = select svc_pt_id, meas_type_id, read_time, value FROM cts_svc_pt_latest_int= _read where svc_pt_id =3D -9941235 and meas_type_id =3D 146; [SharedPool-Wo= rker-1] | 2016-09-30 18:15:00.446000 |  192.168.199.75 |    =        111

  &nbs= p;                     &n= bsp;                     =                      = ;                     &nb= sp;                     &= nbsp;          Preparing statement [SharedPool-Wor= ker-1] | 2016-09-30 18:15:00.446000 |  192.168.199.75 |     =        209

   = ;                     &nb= sp;                     &= nbsp;                    =                     &nbs= p;                 reading data fro= m /192.168.170.186 [SharedPool-Worker-1= ] | 2016-09-30 18:15:00.446001 |  192.168.199.75 |      = ;      370

    &nb= sp;                     &= nbsp;                    =                     &nbs= p;        Sending READ message to /192.168.170.186 [MessagingService-Outgoing-/192.168.170.186] | 2016-09-30 18:15:00.446001 |  = 192.168.199.75 |            450

                =                      = ;                     &nb= sp;   REQUEST_RESPONSE message received from /192.168.170.186 [MessagingService-Incoming-/192.168.170.186] | 2016-09-30 18:15:00.448000 |  192.= 168.199.75 |           2469

                  &n= bsp;                     =                      = ;                     &nb= sp;                Processing respo= nse from /192.168.170.186 [SharedPool-W= orker-8] | 2016-09-30 18:15:00.448000 |  192.168.199.75 |    = ;       2609

    &= nbsp;                    =                     &nbs= p;                     &n= bsp;       READ message received from /192.168.199.75 [MessagingService-Incoming-/192.168.199.75] | 2016-09-30 18:15:00.449000 | 192.168.170.186 |         =     75

       = ;                     &nb= sp;                     &= nbsp;                    =                     &nbs= p;                     &n= bsp;           Row cache miss [SharedPool-Worker-2= ] | 2016-09-30 18:15:00.449000 | 192.168.17= 0.186 |            218

                 = ;                     &nb= sp;       Fetching data but not populating cache as query do= es not query from the start of the partition [SharedPool-Worker-2] | 2016-0= 9-30 18:15:00.449000 | 192.168.170.186 = |            246

                    &= nbsp;                    =                     &nbs= p;               Executing single-partit= ion query on cts_svc_pt_latest_int_read [SharedPool-Worker-2] | 2016-09-30 = 18:15:00.449000 | 192.168.170.186 | &= nbsp;          259

                    &nbs= p;                     &n= bsp;                     =                      = ;                     &nb= sp;     Acquiring sstable references [SharedPool-Worker-2] | 2016= -09-30 18:15:00.449001 | 192.168.170.186 |            281

               = ;                     &nb= sp;                     &= nbsp;                    =                     &nbs= p;            Merging data from sstable 8 [Sh= aredPool-Worker-2] | 2016-09-30 18:15:00.449001 | 192.168.170.186 |            326

            &n= bsp;                     =                      = ;                     &nb= sp;                     &= nbsp;              Key cache hit for sst= able 8 [SharedPool-Worker-2] | 2016-09-30 18:15:00.449001 | 192.168.170.186 |           &= nbsp;351

         =                     &nbs= p;                     &n= bsp;                     =                      = ;                  Merging dat= a from sstable 7 [SharedPool-Worker-2] | 2016-09-30 18:15:00.449001 | 192.168.170.186 |       &nb= sp;    439

      &= nbsp;                    =                     &nbs= p;                     &n= bsp;                     =                      = ;Key cache hit for sstable 7 [SharedPool-Worker-2] | 2016-09-30 18:15:00.44= 9001 | 192.168.170.186 |     =        468

   = ;                     &nb= sp;                     &= nbsp;                    =                     &nbs= p;                  Read 1 liv= e and 0 tombstone cells [SharedPool-Worker-2] | 2016-09-30 18:15:00.449001 = | 192.168.170.186 |      = ;      615

    &nb= sp;                     &= nbsp;                    =                     &nbs= p;                     &n= bsp;            Enqueuing response to /192.168.199.75 [SharedPool-Worker-2] | 2016-09= -30 18:15:00.449002 | 192.168.170.186 |=            766

                    &n= bsp;                     =                      = ;    Sending REQUEST_RESPONSE message to /192.168.199.75 [MessagingService-Outgoing-/192.168.199.75] | 2016-09-30 18:15:00.449002 | 192.168.170.186 |         &n= bsp;  897

        =                      = ;                     &nb= sp;                     &= nbsp;                    =                     &nbs= p;                     &n= bsp;         Request complete | 2016-09-30 18:15:00.448= 888 |  192.168.199.75 |           2888

 

Can = please anyone tell me what I am doing wrong?

 

Thanks,

<= p class=3DMsoNormal style=3D'mso-margin-top-alt:auto;mso-margin-bottom-alt:= auto'>Abhinav

____________________________________= ________________________________
CONFIDENTIALITY NOTE: This e-mail and a= ny attachments are confidential and may be legally privileged. If you are n= ot the intended recipient, do not disclose, copy, distribute, or use this e= mail or any attachments. If you have received this in error please let the = sender know and then delete the email and all attachments.

____________________________________________________________________
CONFIDENTIALITY NOTE: This e-mail and any attachments are confidential and = may be legally privileged. If you are not the intended recipient, do not di= sclose, copy, distribute, or use this email or any attachments. If you have= received this in error please let the sender know and then delete the emai= l and all attachments.
--B_3558347696_489946133-- --B_3558347696_1781181876 Content-Type: application/pkcs7-signature; name="smime.p7s" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="smime.p7s" MIIRKwYJKoZIhvcNAQcCoIIRHDCCERgCAQExDzANBglghkgBZQMEAgEFADALBgkqhkiG9w0B BwGggg6dMIIFTDCCBDSgAwIBAgIRAIeX7oQRaz3bAAAAAEw1XuAwDQYJKoZIhvcNAQELBQAw gaUxCzAJBgNVBAYTAlVTMRYwFAYDVQQKEw1FbnRydXN0LCBJbmMuMTkwNwYDVQQLEzB3d3cu ZW50cnVzdC5uZXQvQ1BTIGlzIGluY29ycG9yYXRlZCBieSByZWZlcmVuY2UxHzAdBgNVBAsT FihjKSAyMDEwIEVudHJ1c3QsIEluYy4xIjAgBgNVBAMTGUVudHJ1c3QgQ2xhc3MgMiBDbGll bnQgQ0EwHhcNMTYwOTIwMjIxMTIwWhcNMTkwOTMwMjI0MTE3WjCBjTELMAkGA1UEBhMCVVMx EzARBgNVBAgTCkNhbGlmb3JuaWExDzANBgNVBAcTBklydmluZTEaMBgGA1UEChMRQ3Jvd2RT dHJpa2UsIEluYy4xPDARBgNVBAMTCkplZmYgSmlyc2EwJwYJKoZIhvcNAQkBFhpqZWZmLmpp cnNhQGNyb3dkc3RyaWtlLmNvbTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAM8/ kM42VwiKXDU7EgjPU7wyr7KRidCCUqlqfSJ9pcvlNzqluaTAYfoAALsc8vYhIxw7h9qJPVC9 xXdgQGXJcHeVfHwslf0jUWezmnk4jXOuhhiGKF8hCDR2OK1vwl495dCVl8ui+Xly59MMxIvc uAVieWJ8+E5JLa0/IQVPHg3OHB4vWfipOnp9ZXyXWvwtbU6px4vV5tG80PXBeMPUO3vT7XTe rQuua+nZTiqh3VnVuOxdxr1ttkxu3Gn5SqBLwbuPlMrBYtJVa5nAMPo+fVgUmV+aSCCjG/x+ Vy6dFutaIyLXyB2jiQx3t9mX0Iu2Nnc2rtpezj+g0FP6dB703nsCAwEAAaOCAYswggGHMA4G A1UdDwEB/wQEAwIFoDAdBgNVHSUEFjAUBggrBgEFBQcDAgYIKwYBBQUHAwQwQgYDVR0gBDsw OTA3BgtghkgBhvpsCgEEAjAoMCYGCCsGAQUFBwIBFhpodHRwOi8vd3d3LmVudHJ1c3QubmV0 L3JwYTBqBggrBgEFBQcBAQReMFwwIwYIKwYBBQUHMAGGF2h0dHA6Ly9vY3NwLmVudHJ1c3Qu bmV0MDUGCCsGAQUFBzAChilodHRwOi8vYWlhLmVudHJ1c3QubmV0LzIwNDhjbGFzczJzaGEy LmNlcjA0BgNVHR8ELTArMCmgJ6AlhiNodHRwOi8vY3JsLmVudHJ1c3QubmV0L2NsYXNzMmNh LmNybDAlBgNVHREEHjAcgRpqZWZmLmppcnNhQGNyb3dkc3RyaWtlLmNvbTAfBgNVHSMEGDAW gBQJkaW66fIuKnXfzX7+d8ry3mubJDAdBgNVHQ4EFgQUSw+neOez3ZJWkkEF36O0c2skDkAw CQYDVR0TBAIwADANBgkqhkiG9w0BAQsFAAOCAQEAoQiIaUSkRZecrnLGP6/as+GANvfMnFNL i5wawcZljyeJg8e7p6+ZcXUSI0GOPs/Wl9paitiIIhGuvD2iD3+cvJQlrC+8LT2PFkRUu81B riyF3QzWygI1hCdFQcRY+9Fox1zKT0+5SwfOPstSBLHuYAUfRQrc9WtoqF70xbngPUCfGZVJ +8l9kJgCnXqwmfTu8s2d1Q5MCdz68g8geVU3nYnJ7ONPvvgsdlgywW0sNLLhn4iqGY6y5xSh uR2GYgSwcYrvKfU56sHYc2JLyyUzUm3r3BWE+CedpBg+B4Al6XsgqJPu2t2hgSrcDoHrpEsV +hTUoTgWxZlqHh7bcQdRhjCCBOkwggPRoAMCAQICBEwOjDgwDQYJKoZIhvcNAQEFBQAwgbQx FDASBgNVBAoTC0VudHJ1c3QubmV0MUAwPgYDVQQLFDd3d3cuZW50cnVzdC5uZXQvQ1BTXzIw NDggaW5jb3JwLiBieSByZWYuIChsaW1pdHMgbGlhYi4pMSUwIwYDVQQLExwoYykgMTk5OSBF bnRydXN0Lm5ldCBMaW1pdGVkMTMwMQYDVQQDEypFbnRydXN0Lm5ldCBDZXJ0aWZpY2F0aW9u IEF1dGhvcml0eSAoMjA0OCkwHhcNMTExMTExMTUzODM0WhcNMjExMTEyMDAxNzM0WjCBpTEL MAkGA1UEBhMCVVMxFjAUBgNVBAoTDUVudHJ1c3QsIEluYy4xOTA3BgNVBAsTMHd3dy5lbnRy dXN0Lm5ldC9DUFMgaXMgaW5jb3Jwb3JhdGVkIGJ5IHJlZmVyZW5jZTEfMB0GA1UECxMWKGMp IDIwMTAgRW50cnVzdCwgSW5jLjEiMCAGA1UEAxMZRW50cnVzdCBDbGFzcyAyIENsaWVudCBD QTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAMQyjULQnhmdW5BaEEy1EAAhuQdI 3q5ugNb/FFAG6HWva0aO56VPrcOMsPp74BmR/fBjrXFJ86gcH6s0GSBOS1TpAJO+cAgx3olT rFe8JO8qj0LU9+qVJV0UdtLNpxL6G7K0XGFAvV/dV5tEVdjFiRk8ZT256NSlLcIs0+qDMaII PF5ZrhIuKgqMXvOzMa4KrX7ssEkJ/KcuIh5oZDSdFuOmPQMxQBb3lPZLGTTJl+YinEjeZKCD C1gFmMQiRokF/aO+9klMYQMWpPgKmRziwMZ+aQIyV5ADrwCUobnczq/v9HwYzjALyof41V8f WVHYiwu5OMZYwlN82ibU2/K9kM0CAwEAAaOCAQ4wggEKMA4GA1UdDwEB/wQEAwIBBjASBgNV HRMBAf8ECDAGAQH/AgEAMDMGCCsGAQUFBwEBBCcwJTAjBggrBgEFBQcwAYYXaHR0cDovL29j c3AuZW50cnVzdC5uZXQwMgYDVR0fBCswKTAnoCWgI4YhaHR0cDovL2NybC5lbnRydXN0Lm5l dC8yMDQ4Y2EuY3JsMDsGA1UdIAQ0MDIwMAYEVR0gADAoMCYGCCsGAQUFBwIBFhpodHRwOi8v d3d3LmVudHJ1c3QubmV0L3JwYTAdBgNVHQ4EFgQUCZGluunyLip1381+/nfK8t5rmyQwHwYD VR0jBBgwFoAUVeSB0RGAvtiJuQijMfmhJAkWuXAwDQYJKoZIhvcNAQEFBQADggEBAAqJtbEz ORCxLAl57vMbbah2SrTDeOPn/ydhNMxK7NiC7h9jSuF9RXpERqpWxoBM38h1CZxhIdk+Tcug GvSRiiWlem0buWcZPyUz1EEfYT8YIpPIPvfD6Q/nWPSeH07jn+HV3ze6/LHtgDZmZoUmV2K1 4m6wgmrQrCMT0RcVRglZds6ncKeIHnEnPh3e2eqdCIp/K5byi5sUf8pFck8KLVu/zrl76IyI TI/XXgmQoOfI+YA+rcEyskbD/c0MDOXC/U8Jt4IgkrzTZJ8HMU32zzVpN6TvRz8lK3sO35s7 snE9J86ULnsmrUifBH+fG4fMeh2xIJAVCK4CEdPDAD2o60cwggRcMIIDRKADAgECAgQ4Y7lm MA0GCSqGSIb3DQEBBQUAMIG0MRQwEgYDVQQKEwtFbnRydXN0Lm5ldDFAMD4GA1UECxQ3d3d3 LmVudHJ1c3QubmV0L0NQU18yMDQ4IGluY29ycC4gYnkgcmVmLiAobGltaXRzIGxpYWIuKTEl MCMGA1UECxMcKGMpIDE5OTkgRW50cnVzdC5uZXQgTGltaXRlZDEzMDEGA1UEAxMqRW50cnVz dC5uZXQgQ2VydGlmaWNhdGlvbiBBdXRob3JpdHkgKDIwNDgpMB4XDTk5MTIyNDE3NTA1MVoX DTE5MTIyNDE4MjA1MVowgbQxFDASBgNVBAoTC0VudHJ1c3QubmV0MUAwPgYDVQQLFDd3d3cu ZW50cnVzdC5uZXQvQ1BTXzIwNDggaW5jb3JwLiBieSByZWYuIChsaW1pdHMgbGlhYi4pMSUw IwYDVQQLExwoYykgMTk5OSBFbnRydXN0Lm5ldCBMaW1pdGVkMTMwMQYDVQQDEypFbnRydXN0 Lm5ldCBDZXJ0aWZpY2F0aW9uIEF1dGhvcml0eSAoMjA0OCkwggEiMA0GCSqGSIb3DQEBAQUA A4IBDwAwggEKAoIBAQCtTUupEoay6qMgBxUWZCorS9G/C0pNju2AdqVnt3hAwHNCyGjA21Mr 3V64dpg1k4sanXwTOg4fW7cez+UkFB6xgamNfbjMa0sD8QIM3KulQCQAf3SUoZ0IKbOIC/WH d51VzeTDftdqZKuFFIaVW5cyUG89yLpmDOP8vbhJwXaJSRn9wKi9iaNnL8afvHEZYLgt6SzJ kHZme5Tir3jWZVNdPNacss8pA/kvpFCy1EjOBTJViv2yZEwO5JgHddt/37kIVWCFMCn5e0ik aYbjNT8ehl16ehW97wCOFSJUFwCQJpO8Dklokb/4R9OdlULBDk3fbybPwxghYmZDcNbVwAfh AgMBAAGjdDByMBEGCWCGSAGG+EIBAQQEAwIABzAfBgNVHSMEGDAWgBRV5IHREYC+2Im5CKMx +aEkCRa5cDAdBgNVHQ4EFgQUVeSB0RGAvtiJuQijMfmhJAkWuXAwHQYJKoZIhvZ9B0EABBAw DhsIVjUuMDo0LjADAgSQMA0GCSqGSIb3DQEBBQUAA4IBAQBZR6whhIoXyZyJUx66gIUaxjxO PrGctnzGkl0YZALj0wYIEWF8Y+MrnTEDcHbSoyig9LuaY3PtbeUq2+0UqSvGNhHQK+sHi6Xa nlwZnVYS9VQpyAXtshIqjfQDG//nkhCHsDq1w50FNxKjx/QVudWkORabUzojkfGogqJqiGjB eQIivKqm1q7fsBRfuIfQ3Xx/e/+vHM/m2wetXtuFndArDTPbBNHmSUATK3b7PumciQ8Vzhiw hXghT2tPDvo2Z80H8v8I0OLe2b8qr7iHhiE8BMq3lGh/zzzpmNc4/+zA2VDwLktYrkZv0C7D YNpyVXK9TEWeYbq/hIGSA9HSaXzFMYICUjCCAk4CAQEwgbswgaUxCzAJBgNVBAYTAlVTMRYw FAYDVQQKEw1FbnRydXN0LCBJbmMuMTkwNwYDVQQLEzB3d3cuZW50cnVzdC5uZXQvQ1BTIGlz IGluY29ycG9yYXRlZCBieSByZWZlcmVuY2UxHzAdBgNVBAsTFihjKSAyMDEwIEVudHJ1c3Qs IEluYy4xIjAgBgNVBAMTGUVudHJ1c3QgQ2xhc3MgMiBDbGllbnQgQ0ECEQCHl+6EEWs92wAA AABMNV7gMA0GCWCGSAFlAwQCAQUAoGkwLwYJKoZIhvcNAQkEMSIEIDsHEuYIOAkd6pfog7uq bo2ZSDl7GKW2gQB9mlrpBbCFMBgGCSqGSIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJKoZIhvcN AQkFMQ8XDTE2MTAwMzIwNTQ1NlowDQYJKoZIhvcNAQEBBQAEggEAxRzQ8oju7G8buiJCtKYP trDUCYEaectP8wwz/yuGTGJEDOdZnNAEB/AcWG8sTm758Dy+FYR+I5Hsb7iGhR8TkfYvgZFY PQHOLb0bL/o8yEtri9dLg3rpRRFrgVAe+jPckzxkTOw1a0P81D64ymFUfaOgKtTm6x4rEKBJ jQy080dDtrbIJIVlRKytc3pciSbEdXiWc3xPQY9ZRXOJBOY67xwwE94x+2PxlSboemgl/E+U ygsaPmb40rjJnsFOWNNzG/chXW78WaJ8cP5REw1maER5o+fR0INjfwFCzQ9VqUi2V+Oy0A3d AsC1/Y6b9MHKi9I9fs+zIIcxrUDh9C/xAw== --B_3558347696_1781181876--