Getting SQL statements error after redis configuration

Ankush_Bandil — Fri, 31 Jul 2020 10:56:49 GMT

I am getting below errors after redis configurations. nuxeo.templates=postgresql-quartz-cluster,redis nuxeo.redis.enabled=true nuxeo.redis.host=localhost nuxeo.redis.port=6380 nuxeo.work.queuing=redis repository.clustering.invalidation=redis

2020-07-31T16:22:02,805 ERROR [QuartzScheduler_Quartz-ssg0252-Lenovo-V330-14IKB1596192240743_MisfireHandler] [org.quartz.impl.jdbcjobstore.JobStoreCMT] MisfireHandler: Error handling misfires: Database error recovering from misfires.
org.quartz.JobPersistenceException: Database error recovering from misfires.
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3259) ~[quartz-2.3.0.jar:?]
	at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.manage(JobStoreSupport.java:3997) [quartz-2.3.0.jar:?]
	at org.quartz.impl.jdbcjobstore.JobStoreSupport$MisfireHandler.run(JobStoreSupport.java:4018) [quartz-2.3.0.jar:?]
Caused by: org.h2.jdbc.JdbcSQLException: Table "QRTZ_TRIGGERS" not found; SQL statement:
SELECT COUNT(TRIGGER_NAME) FROM qrtz_TRIGGERS WHERE SCHED_NAME = 'Quartz' AND NOT (MISFIRE_INSTR = -1) AND NEXT_FIRE_TIME < ? AND TRIGGER_STATE = ? [42102-177]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:344) ~[h2-1.4.177-NX01.jar:1.4.177]
	at org.h2.message.DbException.get(DbException.java:178) ~[h2-1.4.177-NX01.jar:1.4.177]
	at org.h2.message.DbException.get(DbException.java:154) ~[h2-1.4.177-NX01.jar:1.4.177]
	at org.h2.command.Parser.readTableOrView(Parser.java:5213) ~[h2-1.4.177-NX01.jar:1.4.177]
	at org.h2.command.Parser.readTableFilter(Parser.java:1220) ~[h2-1.4.177-NX01.jar:1.4.177]
	at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1859) ~[h2-1.4.177-NX01.jar:1.4.177]
	at org.h2.command.Parser.parseSelectSimple(Parser.java:1968) ~[h2-1.4.177-NX01.jar:1.4.177]
	at org.h2.command.Parser.parseSelectSub(Parser.java:1853) ~[h2-1.4.177-NX01.jar:1.4.177]
	at org.h2.command.Parser.parseSelectUnion(Parser.java:1674) ~[h2-1.4.177-NX01.jar:1.4.177]
	at org.h2.command.Parser.parseSelect(Parser.java:1662) ~[h2-1.4.177-NX01.jar:1.4.177]
	at org.h2.command.Parser.parsePrepared(Parser.java:434) ~[h2-1.4.177-NX01.jar:1.4.177]
	at org.h2.command.Parser.parse(Parser.java:306) ~[h2-1.4.177-NX01.jar:1.4.177]
	at org.h2.command.Parser.parse(Parser.java:278) ~[h2-1.4.177-NX01.jar:1.4.177]
	at org.h2.command.Parser.prepareCommand(Parser.java:243) ~[h2-1.4.177-NX01.jar:1.4.177]
	at org.h2.engine.Session.prepareLocal(Session.java:442) ~[h2-1.4.177-NX01.jar:1.4.177]
	at org.h2.engine.Session.prepareCommand(Session.java:384) ~[h2-1.4.177-NX01.jar:1.4.177]
	at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1188) ~[h2-1.4.177-NX01.jar:1.4.177]
	at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:73) ~[h2-1.4.177-NX01.jar:1.4.177]
	at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:276) ~[h2-1.4.177-NX01.jar:1.4.177]
	at org.tranql.connector.jdbc.ConnectionHandle.prepareStatement(ConnectionHandle.java:241) ~[tranql-connector-1.8.jar:1.8]
	at sun.reflect.GeneratedMethodAccessor84.invoke(Unknown Source) ~[?:?]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_201]
	at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_201]
	at org.quartz.impl.jdbcjobstore.AttributeRestoringConnectionInvocationHandler.invoke(AttributeRestoringConnectionInvocationHandler.java:73) ~[quartz-2.3.0.jar:?]
	at com.sun.proxy.$Proxy89.prepareStatement(Unknown Source) ~[?:?]
	at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.countMisfiredTriggersInState(StdJDBCDelegate.java:390) ~[quartz-2.3.0.jar:?]
	at org.quartz.impl.jdbcjobstore.JobStoreSupport.doRecoverMisfires(JobStoreSupport.java:3238) ~[quartz-2.3.0.jar:?]
	... 2 more

topic Getting SQL statements error after redis configuration in Nuxeo Forum

Getting SQL statements error after redis configuration