phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Josh Elser (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-2484) sqlline is spitting out too many loglines
Date Fri, 11 Dec 2015 05:11:10 GMT

    [ 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)

Mime
View raw message