org.quartz.SchedulerConfigException

Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't clean volatile data: Unknown column 'IS_VOLATILE' in 'where clause' [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'IS_VOLATILE' in 'where clause']]


Solutions on the web85

Solution icon of terracotta
via Terracotta by naveenj, 1 year ago
Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't clean volatile data: Unknown column 'IS_VOLATILE' in 'where clause' [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'IS_VOLATILE' in 'where clause']]

Solution icon of web
via liferay.com by Unknown author, 1 year ago
Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't retrieve trigger: Unknown column '' in 'field list' [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column '' in 'field list']]

Solution icon of liferay
via Liferay Issues by Michael Feichtegger, 1 year ago
Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't retrieve trigger: Unknown column '' in 'field list' [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column '' in 'field list']]

Solution icon of web
via wordpress.com by Unknown author, 1 year ago
Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn’t clean volatile data: DELETE command denied to user ‘pentaho_user’@’localhost’ for table ‘QRTZ_FIRED_TRIGGERS’ [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: DELETE command denied to user ‘pentaho_user’@’localhost’ for table ‘QRTZ_FIRED_TRIGGERS’]]

Solution icon of web
via liferay.com by Unknown author, 1 year ago
Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't clean volatile data: Table 'lportal.quartz_triggers' doesn't exist [See nested exception: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lportal.quartz_triggers' doesn't exist]]

Solution icon of terracotta
via Terracotta by kadya, 1 year ago
Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't clean volatile data: Couldn't find delegate constructor: org.quartz.impl.jdbcjobstore.SybaseDelegate.(org.apache.commons.logging.Log

Solution icon of oraclecommunity
via Oracle Community by Gaff, 1 year ago
Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't clean volatile data: ORA-00942: table or view does not exist [See nested exception: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist ]]

Solution icon of web
Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't clean volatile data: ERROR: permission denied for relation qrtz_triggers [See nested exception: org.postgresql.util.PSQLException: ERROR: permission denied for relation qrtz_triggers]]

Solution icon of web
via liferay.com by Unknown author, 1 year ago
Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't clean volatile data: ERROR: operator does not exist: character varying = boolean [See nested exception: org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = boolean]]

Solution icon of web
via liferay.com by Unknown author, 1 year ago
Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't clean volatile data: ERROR: operator does not exist: character varying = boolean [See nested exception: org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = boolean]]

Stack trace

  • org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.JobPersistenceException: Couldn't clean volatile data: Unknown column 'IS_VOLATILE' in 'where clause' [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'IS_VOLATILE' in 'where clause']] at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:606) at org.quartz.impl.jdbcjobstore.JobStoreTX.initialize(JobStoreTX.java:59) at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1225) at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1376) at com.hs18.schedular.TestClass.start(TestClass.java:30) at com.hs18.schedular.TestClass.main(TestClass.java:59) Caused by: org.quartz.JobPersistenceException: Couldn't clean volatile data: Unknown column 'IS_VOLATILE' in 'where clause' [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'IS_VOLATILE' in 'where clause'] at org.quartz.impl.jdbcjobstore.JobStoreSupport.cleanVolatileTriggerAndJobs(JobStoreSupport.java:789) at org.quartz.impl.jdbcjobstore.JobStoreSupport$1.execute(JobStoreSupport.java:750) at org.quartz.impl.jdbcjobstore.JobStoreSupport$41.execute(JobStoreSupport.java:3726) at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3760) at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3722) at org.quartz.impl.jdbcjobstore.JobStoreSupport.cleanVolatileTriggerAndJobs(JobStoreSupport.java:746) at org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:604) ... 5 more Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'IS_VOLATILE' in 'where clause' at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:409) at com.mysql.jdbc.Util.getInstance(Util.java:384) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1054) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2275) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:205) at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectVolatileTriggers(StdJDBCDelegate.java:3494) at org.quartz.impl.jdbcjobstore.JobStoreSupport.cleanVolatileTriggerAndJobs(JobStoreSupport.java:767) ... 11 more

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

2 times, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
23 times, 2 weeks ago
3 times, 4 weeks ago
118 more bugmates