Terracotta Discussion Forums (LEGACY READ-ONLY ARCHIVE)

Could you help me fix a issue with "relation "qrtz_locks" does not exist"?

I use Spring + Quartz + PostgreSQL architecture. The quartz is serialized/deserialized in database.

Му application context:
Code:

<beans>
 ...
     <bean id="scheduler" class="org.springframework.scheduling.quartz.SchedulerFactoryBean">
         <property name="dataSource" ref="dataSource"/>
         <property name="triggers">
 	        <list>
                       ...
 	        </list>
         </property>
     </bean>
 ...
 </beans>

During the application start I'm having the exception (see below):
Invocation of init method failed; nested exception is org.quartz.SchedulerConfigException: Failure occured during job recovery. [See nested exception: org.quartz.impl.jdbcjobstore.LockException: Failure obtaining db row lock: ERROR: relation "qrtz_locks" does not exist [See nested exception: org.postgresql.util.PSQLException: ERROR: relation "qrtz_locks" does not exist]]

We use also H2 database with the same configuration and don't have such exception.

Thanks a lot in advance.

P.S.I found a lot of posts in Internet about the issue, but there're not any solutions how to fix it.

This means one of:

* the quartz tables have not been created in the database
* you configured quartz to connect to the wrong database (or with the wrong db user)
* The tables have been created but they have been created with a prefix other than "qrtz_" and the configuration hasn't been set to use something other than "qrtz_".

Thanks for sharing !