Uploaded image for project: 'CMS'
  1. CMS
  2. CMS-8749

Scheduler does not work with hsqldb

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 4.0.4, 4.1.0
    • 4.1.0
    • None
    • None
    • 4.1 M5

      Date:			Thu Nov 16 14:11:32 CET 2017 (1510837892941)
      Thread:		localhost-startStop-1
      Message #:	356
      Level:		ERROR
      NDC:			
      Category:	org.ametys.plugins.core.schedule.Scheduler
      Message:		An exception occured during the scheduling of configurable runnables
      Location:	org.ametys.plugins.core.schedule.Scheduler._scheduleConfigurableJobs(Scheduler.java:282)
      Thrown:
      org.quartz.JobPersistenceException: Couldn't store job: data exception: string data, right truncation;  table: QRTZ_JOB_DETAILS column: JOB_DATA [See nested exception: java.sql.SQLDataException: data exception: string data, right truncation;  table: QRTZ_JOB_DETAILS column: JOB_DATA]
      	at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJob(JobStoreSupport.java:1123)
      	at org.quartz.impl.jdbcjobstore.JobStoreSupport$3.executeVoid(JobStoreSupport.java:1095)
      	at org.quartz.impl.jdbcjobstore.JobStoreSupport$VoidTransactionCallback.execute(JobStoreSupport.java:3765)
      	at org.quartz.impl.jdbcjobstore.JobStoreSupport$VoidTransactionCallback.execute(JobStoreSupport.java:3763)
      	at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3849)
      	at org.quartz.impl.jdbcjobstore.JobStoreTX.executeInLock(JobStoreTX.java:93)
      	at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJob(JobStoreSupport.java:1091)
      	at org.quartz.core.QuartzScheduler.addJob(QuartzScheduler.java:938)
      	at org.quartz.core.QuartzScheduler.addJob(QuartzScheduler.java:927)
      	at org.quartz.impl.StdScheduler.addJob(StdScheduler.java:268)
      	at org.ametys.plugins.core.schedule.Scheduler.scheduleJob(Scheduler.java:324)
      	at org.ametys.plugins.core.schedule.Scheduler._scheduleConfigurableJobs(Scheduler.java:277)
      	at org.ametys.plugins.core.schedule.Scheduler.start(Scheduler.java:235)
      	at org.ametys.plugins.core.schedule.SchedulerInit.init(SchedulerInit.java:41)
      	at org.ametys.runtime.servlet.RuntimeServlet._initPlugins(RuntimeServlet.java:369)
      	at org.ametys.runtime.servlet.RuntimeServlet._initAmetys(RuntimeServlet.java:307)
      	at org.ametys.runtime.servlet.RuntimeServlet.init(RuntimeServlet.java:208)
      	at javax.servlet.GenericServlet.init(GenericServlet.java:158)
      	at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1231)
      	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1144)
      	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1031)
      	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4913)
      	at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5200)
      	at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
      	at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
      	at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
      	at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
      	at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:581)
      	at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1720)
      	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
      	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      	at java.lang.Thread.run(Thread.java:745)
      Caused by: java.sql.SQLDataException: data exception: string data, right truncation;  table: QRTZ_JOB_DETAILS column: JOB_DATA
      	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
      	at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
      	at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)
      	at org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(Unknown Source)
      	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:384)
      	at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.insertJobDetail(StdJDBCDelegate.java:624)
      	at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJob(JobStoreSupport.java:1117)
      	... 33 more
      Caused by: org.hsqldb.HsqlException: data exception: string data, right truncation;  table: QRTZ_JOB_DETAILS column: JOB_DATA
      	at org.hsqldb.error.Error.error(Unknown Source)
      	at org.hsqldb.Table.enforceTypeLimits(Unknown Source)
      	at org.hsqldb.Table.generateAndCheckData(Unknown Source)
      	at org.hsqldb.Table.insertSingleRow(Unknown Source)
      	at org.hsqldb.StatementDML.insertSingleRow(Unknown Source)
      	at org.hsqldb.StatementInsert.getResult(Unknown Source)
      	at org.hsqldb.StatementDMQL.execute(Unknown Source)
      	at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
      	at org.hsqldb.Session.execute(Unknown Source)
      	... 38 more
      Caused by: org.hsqldb.HsqlException: data exception: string data, right truncation
      	at org.hsqldb.error.Error.error(Unknown Source)
      	at org.hsqldb.error.Error.error(Unknown Source)
      	at org.hsqldb.types.BinaryType.castOrConvertToType(Unknown Source)
      	at org.hsqldb.types.BinaryType.convertToTypeLimits(Unknown Source)
      	... 46 more
      

            sprieul Simon Prieul (Inactive)
            sprieul Simon Prieul (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: