时间戳

首页 > 解决方案 > heroku springboot quratz prostgesql 错误原因：org.postgresql.util.PSQLException：错误：关系“qrtz_locks”不存在

postgresql - heroku springboot quratz prostgesql 错误原因：org.postgresql.util.PSQLException：错误：关系“qrtz_locks”不存在

问题描述

当尝试在 heroku 中部署 springboot 石英 postgresesql 时遇到以下错误，

使用相同的配置，应用程序从我的 ide 连接到 postgrese 没有任何问题，任何帮助将不胜感激。

## QuartzProperties
spring.quartz.job-store-type=jdbc
spring.quartz.properties.org.quartz.threadPool.threadCount=5
spring.quartz.jdbc.initialize-schema=never
spring.quartz.jdbc.schema=pw


org.springframework.context.ApplicationContextException: Failed to start bean 'quartzScheduler'; nested exception is org.springframework.scheduling.SchedulingException: Could not start Quartz Scheduler; 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: current transaction is aborted, commands ignored until end of transaction block [See nested exception: org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block]]
Caused by: org.postgresql.util.PSQLException: ERROR: relation "qrtz_locks" does not exist

标签： postgresqlspring-bootherokuquartz

解决方案

推荐阅读