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

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

Bob Rumsby created DRILL-1719:
---------------------------------

             Summary: 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


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)