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 1CD7D103E8 for ; Tue, 12 Nov 2013 02:15:22 +0000 (UTC) Received: (qmail 79564 invoked by uid 500); 12 Nov 2013 02:15:19 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 79537 invoked by uid 500); 12 Nov 2013 02:15:19 -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 79529 invoked by uid 99); 12 Nov 2013 02:15:19 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Nov 2013 02:15:19 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of hemapani@gmail.com designates 209.85.160.43 as permitted sender) Received: from [209.85.160.43] (HELO mail-pb0-f43.google.com) (209.85.160.43) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Nov 2013 02:15:13 +0000 Received: by mail-pb0-f43.google.com with SMTP id md4so6056697pbc.30 for ; Mon, 11 Nov 2013 18:14:52 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:reply-to:sender:in-reply-to:references:date:message-id :subject:from:to:cc:content-type; bh=WT3ntY4NXseisReE7iy1bcDtYr/rjSXhXD6PfN82Zzo=; b=QTFDWQkz1Yzd2puw+PkrkcQuYjX6kePpJqLruySziFCGX255Q8z1+EC710E7nWGjKI mfCEP/jSdEwfVAPRVgT6JHq+7oEqKUWXI0MV7F4rU0x52x+UjyJOpf0KS1/tDb5bY/um hdr2a7/okEOtkIEQqIt6yg8zP4oh+KFBoIJ5hXcmq2JwDviHgOZPE4766OKG08OnMVkm RfdLWTnNpADYCZYwUUFbsoDnWp04I7Q4ZLeEiuf34JzK0M/k2Xu43R4TrVMwtuvVaAmi 9YttCFgBhZjL9stL6Xo3mfDgD4uh+eFpEWvAftPHO22nNGAt9m6t5ncYOqQmAdhprZel hYaA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=wso2.com; s=google; h=mime-version:reply-to:sender:in-reply-to:references:date:message-id :subject:from:to:cc:content-type; bh=WT3ntY4NXseisReE7iy1bcDtYr/rjSXhXD6PfN82Zzo=; b=ASs4WaCxTau1g0K1NiGmSh34rHryx5VojFzYbRFLpKS3aCaEBUyLLFAl+wr1l5KS+l p7LjNlS+3elIzEQuAGVxTsjMGVDWkzwKelJADbZUL54IWXLFDqCW65kMXjp0R0Kp6yD6 cd8YGhKDboleihf9BkbNba87tvXQyfzIR1Kxc= MIME-Version: 1.0 X-Received: by 10.68.201.138 with SMTP id ka10mr555089pbc.192.1384222492604; Mon, 11 Nov 2013 18:14:52 -0800 (PST) Reply-To: srinath@wso2.com Sender: hemapani@gmail.com Received: by 10.68.149.167 with HTTP; Mon, 11 Nov 2013 18:14:52 -0800 (PST) In-Reply-To: References: Date: Tue, 12 Nov 2013 07:44:52 +0530 X-Google-Sender-Auth: ujaj4IlHVRhX3ZdDVQMoqHxuz_o Message-ID: Subject: Re: Tracing Queries at Cassandra Server From: Srinath Perera To: Takenori Sato Cc: "user@cassandra.apache.org" Content-Type: multipart/alternative; boundary=e89a8fb2043ef649a104eaf169f0 X-Virus-Checked: Checked by ClamAV on apache.org --e89a8fb2043ef649a104eaf169f0 Content-Type: text/plain; charset=UTF-8 Thanks Takenori! I tried adding that, but I can only see following logs. I am using 1.27, are there new logs added in new ones? DEBUG [Thrift:45] 2013-11-11 08:38:14,525 StorageProxy.java (line 1347) Schemas are in agreement. DEBUG [Thrift:1317] 2013-11-11 15:07:14,368 StorageProxy.java (line 1522) Starting a blocking truncate operation on keyspace QpidKeySpace, CF GlobalQueue DEBUG [Thrift:1317] 2013-11-11 15:07:20,125 StorageProxy.java (line 1522) Starting a blocking truncate operation on keyspace QpidKeySpace, CF GlobalQueue DEBUG [Thrift:1923] 2013-11-12 06:32:52,974 StorageProxy.java (line 942) Read timeout; received 0 of 1 responses DEBUG [Thrift:1921] 2013-11-12 06:32:52,974 StorageProxy.java (line 942) Read timeout; received 0 of 1 responses On Mon, Nov 11, 2013 at 8:30 AM, Takenori Sato wrote: > In addition to CassandraServer, add StorageProxy for details as follows. > > log4j.logger.org.apache.cassandra.service.StorageProxy=DEBUG > log4j.logger.org.apache.cassandra.thrift.CassandraServer=DEBUG > > Hope it would help. > > > On Mon, Nov 11, 2013 at 11:25 AM, Srinath Perera wrote: > >> I am talking to Cassandra using Hector. Is there a way that I can trace >> the executed queries at the server? >> >> I have tired adding Enable DEBUG logging for >> org.apache.cassandra.thrift.CassandraServer as mentioned in Cassandra vs >> logging activity. >> But that does not provide much info (e.g. says slice query executed, but >> does not give more info). >> >> What I look for is something like SQL tracing in MySQL, so all queries >> executed are logged. >> >> --Srinath >> >> >> > -- ============================ Srinath Perera, Ph.D. Director, Research, WSO2 Inc. Visiting Faculty, University of Moratuwa Member, Apache Software Foundation Research Scientist, Lanka Software Foundation Blog: http://srinathsview.blogspot.com/ Photos: http://www.flickr.com/photos/hemapani/ Phone: 0772360902 --e89a8fb2043ef649a104eaf169f0 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Thanks=C2=A0Takenori!

I tried adding that, but I can only see following logs. I am using= 1.27, are there new logs added in new ones?


DEBUG [Thrift:45] 2013-11-11 08= :38:14,525 StorageProxy.java (line 1347) Schemas are in agreement.
DEBUG [Thrift:1317] 2013-11-11 15:07:14,368 StorageProxy.java (line 1522) S= tarting a blocking truncate operation on keyspace QpidKeySpace, CF GlobalQu= eue
DEBUG [Thrift:1317] 2013-11-11 15:07:20,125 StorageProxy.java= (line 1522) Starting a blocking truncate operation on keyspace QpidKeySpac= e, CF GlobalQueue
DEBUG [Thrift:1923] 2013-11-12 06:32:52,974 StorageProxy.java (line 94= 2) Read timeout; received 0 of 1 responses
DEBUG [Thrift:1921] 20= 13-11-12 06:32:52,974 StorageProxy.java (line 942) Read timeout; received 0= of 1 responses


On Mon,= Nov 11, 2013 at 8:30 AM, Takenori Sato <tsato@cloudian.com> wrote:
In addition to CassandraSer= ver, add StorageProxy for details as follows.

log4j= .logger.org.apache.cassandra.service.StorageProxy=3DDEBUG
log4j.logger.org.apache.cassandra.thrift.CassandraServer=3DDEBUG

Hope it would help.


On Mon, Nov 11, 2013 at 11:25 AM, Srinath Perera <srinath@wso2.com= > wrote:
I am talking to Cassandra using Hector. Is there a w= ay that I can trace the executed queries at the server?

I have tired adding E= nable DEBUG logging for org.apache.cassandra.thrift.CassandraServer as ment= ioned in=C2=A0Cassandra vs logging activity. But that= does not provide much info (e.g. says slice query executed, but does not g= ive more info).

What I look for is somethi= ng like SQL tracing in MySQL, so all queries executed are logged.=C2=A0

--Srinath






--
=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D
Srinath Perera, Ph.D.
=C2=A0 Director, Re= search, WSO2 Inc.
=C2=A0 Visiting Faculty, University of Moratuwa
=C2=A0 Member, Apache Software Foundation
=C2=A0=C2=A0Research Scientist= , Lanka Software Foundation
=C2=A0=C2=A0Blog: http://srinathsview.blogspot.com/=
=C2=A0 Photos:=C2=A0http://www.flickr.com/photos/hemapani/
=C2=A0 =C2=A0Phone: 0772360902
--e89a8fb2043ef649a104eaf169f0--