Terracotta Discussion Forums

I downloaded Quartz 2.1.5 and configured JobStoreTX w/PostgreSQLDelegate pointed to my PostgreSQL 9.1 using the 9.1-901.jdbc4 JDBC driver.

I then ran the scripts found in docs/dbTables/tables_postgres.sql to set up my database.

Upon starting the scheduler and scheduling a NoOpJob w/repeating, started trigger I get the following error:

Code:

21:48:42.932 [Scheduler_QuartzSchedulerThread] DEBUG o.quartz.core.QuartzSchedulerThread - batch acquisition of 0 triggers
 21:48:42.941 [Swank Worker Thread] DEBUG o.q.i.jdbcjobstore.SimpleSemaphore - Lock 'TRIGGER_ACCESS' is desired by: Swank Worker Thread
 21:48:42.941 [Swank Worker Thread] DEBUG o.q.i.jdbcjobstore.SimpleSemaphore - Lock 'TRIGGER_ACCESS' is being obtained: Swank Worker Thread
 21:48:42.941 [Swank Worker Thread] DEBUG o.q.i.jdbcjobstore.SimpleSemaphore - Lock 'TRIGGER_ACCESS' given to: Swank Worker Thread
 21:48:42.971 [Swank Worker Thread] DEBUG o.q.i.jdbcjobstore.SimpleSemaphore - Lock 'TRIGGER_ACCESS' retuned by: Swank Worker Thread
 21:48:43.075 [Scheduler_QuartzSchedulerThread] ERROR org.quartz.core.ErrorLogger - An error occurred while scanning for the next triggers to fire.
 org.quartz.JobPersistenceException: Couldn't acquire next trigger: Couldn't retrieve trigger: Bad value for type long : \x
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2840) ~[quartz-2.1.5.jar:na]
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport$41.execute(JobStoreSupport.java:2755) ~[quartz-2.1.5.jar:na]
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3811) ~[quartz-2.1.5.jar:na]
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTriggers(JobStoreSupport.java:2751) ~[quartz-2.1.5.jar:na]
 	at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:264) ~[quartz-2.1.5.jar:na]
 Caused by: org.quartz.JobPersistenceException: Couldn't retrieve trigger: Bad value for type long : \x
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1524) ~[quartz-2.1.5.jar:na]
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2790) ~[quartz-2.1.5.jar:na]
 	... 4 common frames omitted
 Caused by: org.postgresql.util.PSQLException: Bad value for type long : \x
 	at org.postgresql.jdbc2.AbstractJdbc2ResultSet.toLong(AbstractJdbc2ResultSet.java:2796) ~[postgresql-9.1-901.jdbc4.jar:na]
 	at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getLong(AbstractJdbc2ResultSet.java:2019) ~[postgresql-9.1-901.jdbc4.jar:na]
 	at org.postgresql.jdbc4.Jdbc4ResultSet.getBlob(Jdbc4ResultSet.java:52) ~[postgresql-9.1-901.jdbc4.jar:na]
 	at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getBlob(AbstractJdbc2ResultSet.java:335) ~[postgresql-9.1-901.jdbc4.jar:na]
 	at com.mchange.v2.c3p0.impl.NewProxyResultSet.getBlob(NewProxyResultSet.java:285) ~[c3p0-0.9.1.1.jar:0.9.1.1]
 	at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.getObjectFromBlob(StdJDBCDelegate.java:3145) ~[quartz-2.1.5.jar:na]
 	at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTrigger(StdJDBCDelegate.java:1764) ~[quartz-2.1.5.jar:na]
 	at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1520) ~[quartz-2.1.5.jar:na]
 	... 5 common frames omitted

Since it appears to be a problem w/data types I tried switching:

Code:

org.quartz.jobStore.useProperties = true

to

Code:

org.quartz.jobStore.useProperties = false

but this didn't change anything.

hello,
can you please provide us with your quartz.properties settings file ? so that we can try to reproduce this error
Thanks

Code:

 
 # Scheduler
 org.quartz.scheduler.instanceName = Scheduler
 org.quartz.scheduler.skipUpdateCheck = true
 
 # Thread Pool
 org.quartz.threadPool.threadCount = 5
 
 # Job Store
 org.quartz.jobStore.class = org.quartz.impl.jdbcjobstore.JobStoreTX
 org.quartz.jobStore.useProperties = false # true
 org.quartz.jobStore.dataSource = default
 
 # Data Source
 org.quartz.dataSource.default.driver = org.quartz.impl.jdbcjobstore.PostgreSQLDelegate
 org.quartz.dataSource.default.URL = jdbc:postgresql://localhost/cloudi
 org.quartz.dataSource.default.user = postgres
 org.quartz.dataSource.default.password = 
 org.quartz.dataSource.default.maxConnections = 10

Hi,
your configuration is wrong, try this :

Code:

  # Job Store
  org.quartz.jobStore.class = org.quartz.impl.jdbcjobstore.JobStoreTX
  org.quartz.jobStore.useProperties = false
  org.quartz.jobStore.dataSource = default
  org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.PostgreSQLDelegate
   
  # Data Source
  org.quartz.dataSource.default.driver = org.postgresql.Driver
  org.quartz.dataSource.default.URL = jdbc:postgresql://localhost/cloudi
  org.quartz.dataSource.default.user = postgres
  org.quartz.dataSource.default.password = 
  org.quartz.dataSource.default.maxConnections = 10

making sure you have something like this in your pom (if using maven) :
<dependency>
<groupId>postgresql</groupId>
<artifactId>postgresql</artifactId>
<version>9.1-901.jdbc4</version>
</dependency>
Hope that helps,
Anthony