You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Samarth Jain (JIRA)" <ji...@apache.org> on 2015/12/03 21:33:11 UTC

[jira] [Created] (PHOENIX-2484) sqlline is spitting out too many loglines

Samarth Jain created PHOENIX-2484:
-------------------------------------

             Summary: sqlline is spitting out too many loglines 
                 Key: PHOENIX-2484
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2484
             Project: Phoenix
          Issue Type: Bug
            Reporter: Samarth Jain


I am seeing a lot of debug log lines (both zookeeper and phoenix related) being spit out on the console when using sqlline.py. 

DEBUG org.apache.zookeeper.ClientCnxn - Reading reply sessionid:0x151693d86cc0006, packet:: clientPath:null serverPath:null finished:false header:: 6,4  replyHeader:: 6,1200,0  request:: '/hbase/meta-region-server,F  response:: #ffffffff0001a726567696f6e7365727665723a3630353230ffffffceffffffbb71ffffffc1ffffffaff6c2250425546a16a96c6f63616c686f737410ffffffe8ffffffd8318ffffff81fffffff5fffffff8ffffffc9ffffff962a100183,s{1125,1125,1449169670901,1449169670901,0,0,0,0,63,0,1125} 
11:09:58.812 [main-SendThread(samarthjai-ltm3-2.local:2181)] DEBUG org.apache.zookeeper.ClientCnxn - Reading reply sessionid:0x151693d86cc0006, packet:: clientPath:null serverPath:null finished:false header:: 7,4  replyHeader:: 7,1200,0  request:: '/hbase/meta-region-server,F  response:: #ffffffff0001a726567696f6e7365727665723a3630353230ffffffceffffffbb71ffffffc1ffffffaff6c2250425546a16a96c6f63616c686f737410ffffffe8ffffffd8318ffffff81fffffff5fffffff8ffffffc9ffffff962a100183,s{1125,1125,1449169670901,1449169670901,0,0,0,0,63,0,1125} 
11:09:58.815 [main-SendThread(samarthjai-ltm3-2.local:2181)] DEBUG org.apache.zookeeper.ClientCnxn - Reading reply sessionid:0x151693d86cc0006, packet:: clientPath:null serverPath:null finished:false header:: 8,4  replyHeader:: 8,1200,0  request:: '/hbase/meta-region-server,F  response:: #ffffffff0001a726567696f6e7365727665723a3630353230ffffffceffffffbb71ffffffc1ffffffaff6c2250425546a16a96c6f63616c686f737410ffffffe8ffffffd8318ffffff81fffffff5fffffff8ffffffc9ffffff962a100183,s{1125,1125,1449169670901,1449169670901,0,0,0,0,63,0,1125} 
11:09:58.819 [main] DEBUG o.a.p.iterate.BaseResultIterators - Guideposts: ]
11:09:58.821 [main] DEBUG o.a.p.iterate.BaseResultIterators - Getting iterators for ResultIterators [name=PARALLEL,id=41e3889e-556a-4497-b54d-8bdc1db4bfbf,scans=[[{"timeRange":[0,1449169798802],"batch":-1,"startRow":"","stopRow":"","loadColumnFamiliesOnDemand":null,"totalColumns":1,"cacheBlocks":true,"families":{"0":["ALL"]},"maxResultSize":-1,"maxVersions":1,"filter":"FilterList AND (2/2): [FirstKeyOnlyFilter, ]","caching":100}]]]
11:09:58.859 [phoenix-1-thread-1] DEBUG o.a.p.iterate.ParallelIterators - Id: 41e3889e-556a-4497-b54d-8bdc1db4bfbf, Time: 38ms, Scan: {"timeRange":[0,1449169798802],"batch":-1,"startRow":"","stopRow":"","loadColumnFamiliesOnDemand":null,"totalColumns":1,"cacheBlocks":true,"families":{"0":["ALL"]},"maxResultSize":-1,"maxVersions":1,"filter":"FilterList AND (2/2): [FirstKeyOnlyFilter, ]","caching":100}
 

This is making sqlline somewhat unusable as log lines show up even before I end up typing the query completely.

[~tdsilva], [~mujtabachohan] - any ideas?



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)