[
https://issues.apache.org/jira/browse/PHOENIX-2484?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15052186#comment-15052186
]
Josh Elser commented on PHOENIX-2484:
-------------------------------------
bq. Wow, I would love to learn how you figured that out.
Cosmic justice for an otherwise frustrating Kerberos day :D. But in all
seriousness:
1. git-bisect to find this commit, simple local deploy and test sqlline.py to
see if it has extra logging
2. {{jar tf}} the good and bad client jar (as a guess)
3. Removed logback classes from the client jar under another guess
4. Leads to logback documentation.
bq. Maybe we can somehow just disable the logging in sqlline? I'm not sure what
log lines are being displayed - presumably the debug level log lines on the
client.
Check out the pull request. I tried turning off all logging through logback
except classes in {{co.cask.tephra}}. I'm not sure if the slf4j loggers that
tephra (assumably) uses would get logged when we want them. Would be good to
confirm as that's just a guess.
> 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)
