You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Thomas D'Silva (JIRA)" <ji...@apache.org> on 2015/12/09 20:47:11 UTC

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

     [ https://issues.apache.org/jira/browse/PHOENIX-2484?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Thomas D'Silva updated PHOENIX-2484:
------------------------------------
    Fix Version/s: 4.7.0

> 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
>            Assignee: Thomas D'Silva
>             Fix For: 4.7.0
>
>
> 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)