In the zeppelin-interpreter log…
ERROR [2017-10-23 00:00:03,759] ({BoneCP-pool-watch-thread}
PoolWatchThread.java[fillConnections]:118) - Error in trying to obtain a
connection. Retrying in 7000ms
java.sql.SQLException: A read-only user or a user in a read-only database is
not permitted to disable read-only mode on a connection.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.setReadOnly(Unknown
Source)
at
com.jolbox.bonecp.ConnectionHandle.setReadOnly(ConnectionHandle.java:1324)
at com.jolbox.bonecp.ConnectionHandle.<init>(ConnectionHandle.java:262)
at
com.jolbox.bonecp.PoolWatchThread.fillConnections(PoolWatchThread.java:115)
The log file rolled, and it looks like this was the start…
ERROR [2017-10-22 00:00:00,012] ({BoneCP-pool-watch-thread}
PoolWatchThread.java[fillConnections]:118) - Error in trying to obtain a
connection. Retrying in 7000ms
java.sql.SQLException: A read-only user or a user in a read-only database is
not permitted to disable read-only mode on a connection.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.setReadOnly(Unknown
Source)
at
com.jolbox.bonecp.ConnectionHandle.setReadOnly(ConnectionHandle.java:1324)
at com.jolbox.bonecp.ConnectionHandle.<init>(ConnectionHandle.java:262)
at
com.jolbox.bonecp.PoolWatchThread.fillConnections(PoolWatchThread.java:115)
at com.jolbox.bonecp.PoolWatchThread.run(PoolWatchThread.java:82)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: A read-only user or a user in a read-only
database is not permitted to disable read-only mode on a connection.
at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
at
org.apache.derby.impl.jdbc.SQLExceptionFactory40.wrapArgsForTransportAcrossDRDA(Unknown
Source)
Thx
-Mike
On Oct 23, 2017, at 6:42 AM, Michael Segel
<[email protected]<mailto:[email protected]>> wrote:
Hi Jeff,
The error occurred after I tried to save the interpreter…
In a pop-up I saw :
Error setting properties for interpreter 'jdbc.hive': Could not find artifact
jdk.tools:jdk.tools:jar:1.6 at specified path
/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.144-0.b01.el7_4.x86_64/jre/../lib/tools.jar
I’ll check the logs and see what the say.
My first thought was that there’s an old reference to Java 1.6 in a config file
that I didn’t update , or was changed when I compiled version 0.7.2
Thx
-Mike
On Oct 22, 2017, at 10:14 PM, Jeff Zhang
<[email protected]<mailto:[email protected]>> wrote:
It is hard to tell without the full log. Could you paste the log ? And what
dependency do you specify for your hive interpreter ?
Michael Segel
<[email protected]<mailto:[email protected]>>于2017年10月23日周一
上午11:08写道：
I’m trying to set up a hive interpreter for Zeppelin 0.7.2
(I compiled from source. )
I got the following error, but not sure where I’m picking up a reference to
Java 1.6.
Error setting properties for interpreter 'jdbc.hive': Could not find artifact
jdk.tools:jdk.tools:jar:1.6 at specified path
/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.144-0.b01.el7_4.x86_64/jre/../lib/tools.jar
Any suggestions?
Thx
