Uploaded image for project: 'Coopr'
  1. Coopr
  2. COOPR-706

Scheduling jobs fails after upgrade

    XMLWordPrintableJSON

    Details

    • Rank:
      1|hzyndb:

      Description

      When trying to run a reconfigure on a cluster that was built with 0.9.8, then Coopr was upgraded to 0.9.9 (snapshot), I get the following error and it fails scheduling.

      2015-02-19 02:49:33,643 - ERROR [scheduler-3:c.c.c.s.ClusterScheduler@131] - Got exception while scheduling. Failing the job:
      java.io.IOException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'type' in 'field list'
      	at co.cask.coopr.store.cluster.SQLClusterStore.writeClusterTask(SQLClusterStore.java:189) ~[coopr-0.9.9-SNAPSHOT-jar-with-dependencies.jar:na]
      	at co.cask.coopr.scheduler.ClusterScheduler.createClusterTasks(ClusterScheduler.java:181) ~[coopr-0.9.9-SNAPSHOT-jar-with-dependencies.jar:na]
      	at co.cask.coopr.scheduler.ClusterScheduler.run(ClusterScheduler.java:116) ~[coopr-0.9.9-SNAPSHOT-jar-with-dependencies.jar:na]
      	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) ~[na:1.6.0_34]
      	at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:351) ~[na:1.6.0_34]
      	at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:178) ~[na:1.6.0_34]
      	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:165) ~[na:1.6.0_34]
      	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:267) ~[na:1.6.0_34]
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1146) ~[na:1.6.0_34]
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) ~[na:1.6.0_34]
      	at java.lang.Thread.run(Thread.java:701) ~[na:1.6.0_34]
      Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'type' in 'field list'
      	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.6.0_34]
      	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[na:1.6.0_34]
      	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.6.0_34]
      	at java.lang.reflect.Constructor.newInstance(Constructor.java:534) ~[na:1.6.0_34]
      	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connector-java-5.1.17.jar:na]
      	at com.mysql.jdbc.Util.getInstance(Util.java:386) ~[mysql-connector-java-5.1.17.jar:na]
      	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052) ~[mysql-connector-java-5.1.17.jar:na]
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597) ~[mysql-connector-java-5.1.17.jar:na]
      	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529) ~[mysql-connector-java-5.1.17.jar:na]
      	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990) ~[mysql-connector-java-5.1.17.jar:na]
      	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151) ~[mysql-connector-java-5.1.17.jar:na]
      	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625) ~[mysql-connector-java-5.1.17.jar:na]
      	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119) ~[mysql-connector-java-5.1.17.jar:na]
      	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2415) ~[mysql-connector-java-5.1.17.jar:na]
      	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2333) ~[mysql-connector-java-5.1.17.jar:na]
      	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2318) ~[mysql-connector-java-5.1.17.jar:na]
      	at co.cask.coopr.store.DBPut.executePut(DBPut.java:37) ~[coopr-0.9.9-SNAPSHOT-jar-with-dependencies.jar:na]
      	at co.cask.coopr.store.cluster.SQLClusterStore.writeClusterTask(SQLClusterStore.java:184) ~[coopr-0.9.9-SNAPSHOT-jar-with-dependencies.jar:na]
      	... 10 common frames omitted
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                chris Chris Gianelloni
                Reporter:
                chris Chris Gianelloni
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: