[ https://issues.apache.org/jira/browse/DRILL-1719?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Patrick Wong updated DRILL-1719: -------------------------------- Attachment: DRILL-1719.1.patch.txt DRILL-1719.1.patch.txt - handle the case in which /var/log/drill exists but the current user does not have permission to write to it > 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 > > Attachments: DRILL-1719.1.patch.txt > > > 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)