[
https://issues.apache.org/jira/browse/PHOENIX-2484?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gabriel Reid resolved PHOENIX-2484.
-----------------------------------
Resolution: Fixed
Pushed to master and 4.x branches. I tried out sqlline in the binary dist as
well to verify that it all still works.
> 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: Gabriel Reid
> Fix For: 4.7.0
>
> Attachments: PHOENIX-2484.patch
>
>
> 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)
