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

["Josh Elser (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/PHOENIX-2484?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15052146#comment-15052146 ] 

Josh Elser edited comment on PHOENIX-2484 at 12/11/15 4:30 AM:
---------------------------------------------------------------

Seems like logback gets pulled in via tephra into phoenix-client.jar. A quick test of excluding logback-classic and logback-core from the tephra-core dependency gets rid of the logging in sqlline.py.

Need to look at logback again, figure out how logging should actually work and why we were getting extra logging..


was (Author: elserj):
Seems like logback gets pulled in via tephra into phoenix-client.jar.

> 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: Josh Elser
>             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)