[jira] [Created] (ZEPPELIN-1348) JDBC interpreter with MySql : Running a paragraphs fails for first time when executed

["Pankaj Singh (JIRA)" <ji...@apache.org>]

Pankaj Singh created ZEPPELIN-1348:
--------------------------------------

             Summary: JDBC interpreter with MySql : Running a paragraphs fails for first time  when executed 
                 Key: ZEPPELIN-1348
                 URL: https://issues.apache.org/jira/browse/ZEPPELIN-1348
             Project: Zeppelin
          Issue Type: Bug
          Components: zeppelin-interpreter
    Affects Versions: 0.6.0
         Environment: Zeppelin server running on CentOS release 6.8 (Final)
            Reporter: Pankaj Singh
             Fix For: 0.6.2


I have couple of notebooks which uses %jdbc interpreter to connect to mysql database and run couple of queries. The paragraph uses dynamic form (textbox)

Whenever i open the notebook in the morning for the first time and execute a paragraph it fails with error. re-executing it works.
{code}
class com.mysql.jdbc.exceptions.jdbc4.CommunicationsException
sun.reflect.GeneratedConstructorAccessor9.newInstance(Unknown Source)
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
java.lang.reflect.Constructor.newInstance(Constructor.java:422)
com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:981)
com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3465)
com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3365)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3805)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2547)
com.mysql.jdbc.ConnectionImpl.setSessionMaxRows(ConnectionImpl.java:5469)
com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:836)
com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:740)
org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:312)
org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(JDBCInterpreter.java:396)
org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:94)
org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:341)
org.apache.zeppelin.scheduler.Job.run(Job.java:176)
org.apache.zeppelin.scheduler.ParallelScheduler$JobRunner.run(ParallelScheduler.java:162)
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
java.util.concurrent.FutureTask.run(FutureTask.java:266)
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
java.lang.Thread.run(Thread.java:745)

{code}



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