You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Jacques Nadeau (JIRA)" <ji...@apache.org> on 2014/11/17 02:35:38 UTC

[jira] [Commented] (DRILL-1719) sqlline in embedded mode on MacOSX returns a long list of logback errors

    [ https://issues.apache.org/jira/browse/DRILL-1719?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14214172#comment-14214172 ] 

Jacques Nadeau commented on DRILL-1719:
---------------------------------------

Startup scripts to set log directory to a writable path.

> sqlline in embedded mode on MacOSX returns a long list of logback errors
> ------------------------------------------------------------------------
>
>                 Key: DRILL-1719
>                 URL: https://issues.apache.org/jira/browse/DRILL-1719
>             Project: Apache Drill
>          Issue Type: Bug
>         Environment: 0.6.0 and 0.7.0 on MacOSX in embedded mode
>            Reporter: Bob Rumsby
>            Assignee: Patrick Wong
>             Fix For: 0.7.0
>
>
> With both the released 0.6 version and the 0.7 snapshot, sqlline on my Mac returns a slew of log back errors but eventually starts. Jason commented: 
> "Looking in the output there is this line "java.io.FileNotFoundException:
> /var/log/drill/sqlline.log". The logging directory for drill is user
> configurable. It looks like this file is not on the machine, you can try to
> go into the conf directory of your install and edit the logback.xml file to
> set a different directory, or just create the logging file in the location
> its currently looking. I assume you will need to make the logging file
> writable by whatever user you run the drillbit process as."
> Here is the output I am seeing:
> Administrators-MacBook-Pro-149:apache-drill-0.7.0-incubating-SNAPSHOT brumsby$ bin/sqlline -u jdbc:drill:zk=local -n admin -p admin
> 18:35:03,880 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback.groovy]
> 18:35:03,880 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback-test.xml]
> 18:35:03,881 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Found resource [logback.xml] at [file:/Users/brumsby/drill/apache-drill-0.7.0-incubating-SNAPSHOT/conf/logback.xml]
> 18:35:04,029 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - debug attribute not set
> 18:35:04,315 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About to instantiate appender of type [ch.qos.logback.core.ConsoleAppender]
> 18:35:04,326 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as [STDOUT]
> 18:35:04,344 |-INFO in ch.qos.logback.core.joran.action.NestedComplexPropertyIA - Assuming default type [ch.qos.logback.classic.encoder.PatternLayoutEncoder] for [encoder] property
> 18:35:04,415 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About to instantiate appender of type [ch.qos.logback.core.rolling.RollingFileAppender]
> 18:35:04,418 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as [FILE]
> 18:35:04,434 |-INFO in ch.qos.logback.core.rolling.FixedWindowRollingPolicy@2777068f - No compression will be used
> 18:35:04,441 |-INFO in ch.qos.logback.core.joran.action.NestedComplexPropertyIA - Assuming default type [ch.qos.logback.classic.encoder.PatternLayoutEncoder] for [encoder] property
> 18:35:04,442 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender[FILE] - Active log file name: /var/log/drill/sqlline.log
> 18:35:04,442 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender[FILE] - File property is set to [/var/log/drill/sqlline.log]
> 18:35:04,443 |-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 (Permission denied)
> 	at java.io.FileNotFoundException: /var/log/drill/sqlline.log (Permission denied)
> 	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:51)
> 	at 	at org.apache.drill.jdbc.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:57)
> 	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)
> 18:35:04,444 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [org.apache.drill] to false
> 18:35:04,444 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - org.apache.drill level set to INFO
> 18:35:04,444 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [FILE] to Logger[org.apache.drill]
> 18:35:04,445 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - ROOT level set to ERROR
> 18:35:04,445 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [STDOUT] to Logger[ROOT]
> 18:35:04,445 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - End of configuration.
> 18:35:04,446 |-INFO in ch.qos.logback.classic.joran.JoranConfigurator@4ca384e3 - Registering current configuration as safe fallback point
> Nov 14, 2014 6:35:11 PM org.glassfish.jersey.server.ApplicationHandler initialize
> INFO: Initiating Jersey application, version Jersey: 2.8 2014-04-29 01:25:26...
> sqlline version 1.1.6
> 0: jdbc:drill:zk=local> 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)