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 <[email protected]> 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 <[email protected]> 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<http://stackoverflow.com/questions/9604554/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
