drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Charles Givre <cgi...@gmail.com>
Subject Re: Excessive Logging Messages
Date Mon, 27 Feb 2017 12:57:15 GMT
Hi Jinfeng, 
Thank you so much for your help.  It turns out the problem was that I was working on another
project and inadvertently copied the wrong slf4j binding into my classpath.  Once I got rid
of that, things returned to normal.
Best,
— C

> On Feb 27, 2017, at 02:26, Jinfeng Ni <jni@apache.org> wrote:
> 
> I assume what you want is to disable those INFO level log messages in
> your drillbit.log (or sqlline.log, if it's embedded drill). If that's
> what you want, when you start sqlline to connect to drillbit, it will
> show the following information,
> 
> 23:15:23,654 |-INFO in ch.qos.logback.classic.LoggerContext[default] -
> Found resource [logback.xml] at
> [file:/private/etc/drill/conf/logback.xml]
> 
> 23:15:25,636 |-INFO in
> ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity
> of logger [org.apache.drill] to false
> 23:15:25,637 |-INFO in ch.qos.logback.classic.joran.action.LevelAction
> - org.apache.drill level set to WARN
> 
> The first one tells you which logback.xml is used. Please make sure
> your modify the one list there. The second/third entries confirm log
> level for classes in package org.apache.drill.
> 
> btw: in my previous email, I used cap "INFO", "WARN". Please use
> low-case ones. I tried the above approach, and it seemed to work.
> 
> 
> 
> 
> On Sun, Feb 26, 2017 at 8:40 PM, Charles Givre <cgivre@gmail.com> wrote:
>> Hi Jinfeng,
>> That didn’t seem to do the trick.  Any other suggestions?
>> 
>>> On Feb 26, 2017, at 23:23, Jinfeng Ni <jni@apache.org> wrote:
>>> 
>>> You can modify logback.xml in your drill conf directory
>>> (DRILL_HOME/conf/logback.xml).
>>> 
>>> <logger name="org.apache.drill" additivity="false">
>>>   <level value="info" />                             --> Change INFO
>>> to either WARN or ERROR
>>>   <appender-ref ref="FILE" />
>>> </logger>
>>> 
>>> 
>>> 
>>> On Sun, Feb 26, 2017 at 7:17 PM, Charles Givre <cgivre@gmail.com> wrote:
>>>> Hello all,
>>>> I was doing some unrelated work and somehow made it so that every time I
execute a query in Drill from the command line, I get all these INFO messages. Could someone
please explain how to disable these?
>>>> Thanks,
>>>> — Charles
>>>> 
>>>> 
>>>> 
>>>> : jdbc:drill:zk=local> SELECT `Asking - Sold Delta Percent` AS `Asking
- Sold Delta Percent` FROM dfs.test.`comps.xlsx` WHERE `Close Date` >= '2014-02-24 00:07:38'
  AND `Close Date` <= '2017-02-24 00:07:38' LIMIT 50000;
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.exec.work.foreman.Foreman run
>>>> INFO: Query text for query id 274c6cc2-7e8e-c652-812b-2cd6414e453a: SELECT
`Asking - Sold Delta Percent` AS `Asking - Sold Delta Percent` FROM dfs.test.`comps.xlsx`
WHERE `Close Date` >= '2014-02-24 00:07:38'   AND `Close Date` <= '2017-02-24 00:07:38'
LIMIT 50000
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.common.scanner.persistence.ScanResult
getImplementations
>>>> INFO: loading 11 classes for org.apache.drill.exec.store.dfs.FormatPlugin
took 0ms
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.common.scanner.persistence.ScanResult
getImplementations
>>>> INFO: loading 12 classes for org.apache.drill.common.logical.FormatPluginConfig
took 0ms
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.common.scanner.persistence.ScanResult
getImplementations
>>>> INFO: loading 12 classes for org.apache.drill.common.logical.FormatPluginConfig
took 0ms
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.common.scanner.persistence.ScanResult
getImplementations
>>>> INFO: loading 12 classes for org.apache.drill.common.logical.FormatPluginConfig
took 0ms
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.common.scanner.persistence.ScanResult
getImplementations
>>>> INFO: loading 12 classes for org.apache.drill.common.logical.FormatPluginConfig
took 0ms
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.common.scanner.persistence.ScanResult
getImplementations
>>>> INFO: loading 12 classes for org.apache.drill.common.logical.FormatPluginConfig
took 0ms
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.common.scanner.persistence.ScanResult
getImplementations
>>>> INFO: loading 12 classes for org.apache.drill.common.logical.FormatPluginConfig
took 0ms
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.common.scanner.persistence.ScanResult
getImplementations
>>>> INFO: loading 12 classes for org.apache.drill.common.logical.FormatPluginConfig
took 0ms
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.common.scanner.persistence.ScanResult
getImplementations
>>>> INFO: loading 12 classes for org.apache.drill.common.logical.FormatPluginConfig
took 0ms
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.common.scanner.persistence.ScanResult
getImplementations
>>>> INFO: loading 12 classes for org.apache.drill.common.logical.FormatPluginConfig
took 0ms
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.common.scanner.persistence.ScanResult
getImplementations
>>>> INFO: loading 12 classes for org.apache.drill.common.logical.FormatPluginConfig
took 0ms
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.exec.store.dfs.FileSelection getStatuses
>>>> INFO: FileSelection.getStatuses() took 0 ms, numFiles: 1
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.exec.store.dfs.FileSelection getStatuses
>>>> INFO: FileSelection.getStatuses() took 0 ms, numFiles: 1
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.exec.store.dfs.FileSelection getStatuses
>>>> INFO: FileSelection.getStatuses() took 0 ms, numFiles: 1
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.exec.store.dfs.FileSelection getStatuses
>>>> INFO: FileSelection.getStatuses() took 0 ms, numFiles: 1
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.exec.store.dfs.FileSelection getStatuses
>>>> INFO: FileSelection.getStatuses() took 0 ms, numFiles: 1
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.exec.store.dfs.FileSelection getStatuses
>>>> INFO: FileSelection.getStatuses() took 0 ms, numFiles: 1
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.exec.store.dfs.FileSelection getStatuses
>>>> INFO: FileSelection.getStatuses() took 0 ms, numFiles: 1
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.exec.store.dfs.FileSelection getStatuses
>>>> INFO: FileSelection.getStatuses() took 0 ms, numFiles: 1
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.exec.store.dfs.FileSelection getStatuses
>>>> INFO: FileSelection.getStatuses() took 0 ms, numFiles: 1
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.exec.store.dfs.FileSelection getStatuses
>>>> INFO: FileSelection.getStatuses() took 0 ms, numFiles: 1
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.exec.store.schedule.BlockMapBuilder
getEndpointByteMap
>>>> INFO: Failure finding Drillbit running on host localhost.  Skipping affinity
to that host.
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.exec.store.TimedRunnable run
>>>> INFO: Get block maps: Executed 1 out of 1 using 1 threads. Time: 0ms total,
0.729272ms avg, 0ms max.
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.exec.store.TimedRunnable run
>>>> INFO: Get block maps: Executed 1 out of 1 using 1 threads. Earliest start:
0.824000 μs, Latest start: 0.824000 μs, Average start: 0.824000 μs .
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.exec.planner.logical.partition.PruneScanRule
doOnMatch
>>>> INFO: Beginning partition pruning, pruning class: org.apache.drill.exec.planner.logical.partition.PruneScanRule$DirPruneScanFilterOnScanRule
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.exec.planner.logical.partition.PruneScanRule
doOnMatch
>>>> INFO: No partition columns are projected from the scan..continue. Total pruning
elapsed time: 0 ms
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.exec.work.fragment.FragmentExecutor
updateState
>>>> INFO: 274c6cc2-7e8e-c652-812b-2cd6414e453a:0:0: State change requested AWAITING_ALLOCATION
--> RUNNING
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.exec.work.fragment.FragmentStatusReporter
stateChanged
>>>> INFO: 274c6cc2-7e8e-c652-812b-2cd6414e453a:0:0: State to report: RUNNING
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.exec.work.fragment.FragmentExecutor
updateState
>>>> INFO: 274c6cc2-7e8e-c652-812b-2cd6414e453a:0:0: State change requested RUNNING
--> FINISHED
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.exec.work.fragment.FragmentStatusReporter
stateChanged
>>>> INFO: 274c6cc2-7e8e-c652-812b-2cd6414e453a:0:0: State to report: FINISHED
>>>> Feb 26, 2017 9:47:25 PM org.apache.drill.exec.work.foreman.Foreman$ForemanResult
logQuerySummary
>>>> INFO: {"queryId":"274c6cc2-7e8e-c652-812b-2cd6414e453a","schema":"","queryText":"SELECT
`Asking - Sold Delta Percent` AS `Asking - Sold Delta Percent` FROM dfs.test.`comps.xlsx`
WHERE `Close Date` >= '2014-02-24 00:07:38'   AND `Close Date` <= '2017-02-24 00:07:38'
LIMIT 50000","start":1488163645452,"finish":1488163645633,"outcome":"COMPLETED","username":"anonymous","remoteAddress":"192.168.1.151:54865"}
>>>> 
>>>> 
>>>> 
>>>> 
>> 


Mime
View raw message