[
https://issues.apache.org/jira/browse/DRILL-971?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14044911#comment-14044911
]
Tomer Shiran commented on DRILL-971:
------------------------------------
tshiran-laptop:bin tshiran$ ./sqlline -u 'jdbc:drill:zk=local'
20:31:58,146 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could
NOT find resource [logback.groovy]
20:31:58,147 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could
NOT find resource [logback-test.xml]
20:31:58,147 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Found
resource [logback.xml] at
[file:/Users/tshiran/Development/drill/incubator-drill/distribution/target/apache-drill-1.0.0-m2-incubating-SNAPSHOT-binary-release/apache-drill-1.0.0-m2-incubating-SNAPSHOT/conf/logback.xml]
20:31:58,341 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction
- debug attribute not set
20:31:58,560 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About
to instantiate appender of type
[de.huxhorn.lilith.logback.appender.ClassicMultiplexSocketAppender]
20:31:58,575 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming
appender as [SOCKET]
20:31:58,627 |-INFO in
de.huxhorn.lilith.logback.appender.ClassicMultiplexSocketAppender[SOCKET] -
Waiting 1s to establish connections.
20:31:59,627 |-INFO in
de.huxhorn.lilith.logback.appender.ClassicMultiplexSocketAppender[SOCKET] -
Started
de.huxhorn.lilith.logback.appender.ClassicMultiplexSocketAppender[SOCKET]
20:31:59,627 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About
to instantiate appender of type [ch.qos.logback.core.ConsoleAppender]
20:31:59,632 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming
appender as [STDOUT]
20:31:59,641 |-INFO in ch.qos.logback.core.joran.action.NestedComplexPropertyIA
- Assuming default type [ch.qos.logback.classic.encoder.PatternLayoutEncoder]
for [encoder] property
20:31:59,753 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About
to instantiate appender of type
[ch.qos.logback.core.rolling.RollingFileAppender]
20:31:59,757 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming
appender as [FILE]
20:31:59,776 |-INFO in
ch.qos.logback.core.rolling.FixedWindowRollingPolicy@c14a82 - No compression
will be used
20:31:59,786 |-INFO in ch.qos.logback.core.joran.action.NestedComplexPropertyIA
- Assuming default type [ch.qos.logback.classic.encoder.PatternLayoutEncoder]
for [encoder] property
20:31:59,787 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender[FILE] -
Active log file name: /var/log/drill/sqlline.log
20:31:59,787 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender[FILE] -
File property is set to [/var/log/drill/sqlline.log]
20:31:59,789 |-ERROR in ch.qos.logback.core.rolling.RollingFileAppender[FILE] -
Failed to create parent directories for [/var/log/drill/sqlline.log]
20:31:59,790 |-ERROR in ch.qos.logback.core.rolling.RollingFileAppender[FILE] -
openFile(/var/log/drill/sqlline.log,true) call failed.
java.io.FileNotFoundException: /var/log/drill/sqlline.log (No such file or
directory)
at java.io.FileNotFoundException: /var/log/drill/sqlline.log (No such
file or directory)
at at java.io.FileOutputStream.open(Native Method)
at at java.io.FileOutputStream.<init>(FileOutputStream.java:221)
at at
ch.qos.logback.core.recovery.ResilientFileOutputStream.<init>(ResilientFileOutputStream.java:28)
at at
ch.qos.logback.core.FileAppender.openFile(FileAppender.java:149)
at at ch.qos.logback.core.FileAppender.start(FileAppender.java:108)
at at
ch.qos.logback.core.rolling.RollingFileAppender.start(RollingFileAppender.java:86)
at at
ch.qos.logback.core.joran.action.AppenderAction.end(AppenderAction.java:96)
at at
ch.qos.logback.core.joran.spi.Interpreter.callEndAction(Interpreter.java:317)
at at
ch.qos.logback.core.joran.spi.Interpreter.endElement(Interpreter.java:196)
at at
ch.qos.logback.core.joran.spi.Interpreter.endElement(Interpreter.java:182)
at at
ch.qos.logback.core.joran.spi.EventPlayer.play(EventPlayer.java:62)
at at
ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:149)
at at
ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:135)
at at
ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:99)
at at
ch.qos.logback.core.joran.GenericConfigurator.doConfigure(GenericConfigurator.java:49)
at at
ch.qos.logback.classic.util.ContextInitializer.configureByResource(ContextInitializer.java:75)
at at
ch.qos.logback.classic.util.ContextInitializer.autoConfig(ContextInitializer.java:148)
at at
org.slf4j.impl.StaticLoggerBinder.init(StaticLoggerBinder.java:85)
at at
org.slf4j.impl.StaticLoggerBinder.<clinit>(StaticLoggerBinder.java:55)
at at org.slf4j.LoggerFactory.bind(LoggerFactory.java:128)
at at
org.slf4j.LoggerFactory.performInitialization(LoggerFactory.java:107)
at at
org.slf4j.LoggerFactory.getILoggerFactory(LoggerFactory.java:295)
at at org.slf4j.LoggerFactory.getLogger(LoggerFactory.java:269)
at at org.slf4j.LoggerFactory.getLogger(LoggerFactory.java:281)
at at
org.apache.drill.jdbc.DrillConnectionImpl.<clinit>(DrillConnectionImpl.java:52)
at at
org.apache.drill.jdbc.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:56)
at at
org.apache.drill.jdbc.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:43)
at at
org.apache.drill.jdbc.DrillFactory.newConnection(DrillFactory.java:51)
at at
net.hydromatic.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:126)
at at sqlline.SqlLine$DatabaseConnection.connect(SqlLine.java:4732)
at at
sqlline.SqlLine$DatabaseConnection.getConnection(SqlLine.java:4786)
at at sqlline.SqlLine$Commands.connect(SqlLine.java:4026)
at at sqlline.SqlLine$Commands.connect(SqlLine.java:3935)
at at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at at java.lang.reflect.Method.invoke(Method.java:606)
at at
sqlline.SqlLine$ReflectiveCommandHandler.execute(SqlLine.java:2884)
at at sqlline.SqlLine.dispatch(SqlLine.java:885)
at at sqlline.SqlLine.initArgs(SqlLine.java:693)
at at sqlline.SqlLine.begin(SqlLine.java:745)
at at sqlline.SqlLine.start(SqlLine.java:498)
at at sqlline.SqlLine.main(SqlLine.java:460)
20:31:59,790 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction -
Setting additivity of logger [org.apache.drill] to false
20:31:59,790 |-INFO in ch.qos.logback.classic.joran.action.LevelAction -
org.apache.drill level set to INFO
20:31:59,790 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction -
Attaching appender named [FILE] to Logger[org.apache.drill]
20:31:59,791 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction -
Setting additivity of logger [org.apache.drill] to false
20:31:59,791 |-INFO in ch.qos.logback.classic.joran.action.LevelAction -
org.apache.drill level set to DEBUG
20:31:59,791 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction -
Attaching appender named [SOCKET] to Logger[org.apache.drill]
20:31:59,791 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - ROOT
level set to ERROR
20:31:59,791 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction -
Attaching appender named [STDOUT] to Logger[ROOT]
20:31:59,791 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction
- End of configuration.
20:31:59,792 |-INFO in ch.qos.logback.classic.joran.JoranConfigurator@6d1dfaf2
- Registering current configuration as safe fallback point
> sqlline cleanup needed
> ----------------------
>
> Key: DRILL-971
> URL: https://issues.apache.org/jira/browse/DRILL-971
> Project: Apache Drill
> Issue Type: Bug
> Components: Client - CLI
> Reporter: Tomer Shiran
> Assignee: Tomer Shiran
> Attachments: DRILL-971.1.patch.txt
>
>
> We should clean up the logging in sqlline so that by default if everything is
> working no messages show up. Maybe just disable INFO level?
--
This message was sent by Atlassian JIRA
(v6.2#6252)
