mysql - Liquibase 抛出 "SQLException: connection is closed"

Question

   ERROR [kernel-Executor-1] liquibase:
      classpath:config/liquibase/changelog/00000000000000_initial_schema.xml::00000000000001::jhipster:
      Could not release lock liquibase.exception.LockException:
      liquibase.exception.DatabaseException:
      liquibase.exception.DatabaseException: java.sql.SQLException:
      Connection is closed
              at liquibase.lockservice.StandardLockService.releaseLock(StandardLockService.java:250)
              at liquibase.Liquibase.update(Liquibase.java:216)
              at liquibase.Liquibase.update(Liquibase.java:192)
              at liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:434)
              at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:391)
              at com.vadict.kernel.config.liquibase.AsyncSpringLiquibase.initDb(AsyncSpringLiquibase.java:66)
              at com.vadict.kernel.config.liquibase.AsyncSpringLiquibase.lambda$afterPropertiesSet$0(AsyncSpringLiquibase.java:49)
              at com.vadict.kernel.async.ExceptionHandlingAsyncTaskExecutor.lambda$createWrappedRunnable$1(ExceptionHandlingAsyncTaskExecutor.java:47)
              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
              at java.lang.Thread.run(Thread.java:745) Caused by: liquibase.exception.DatabaseException:
      liquibase.exception.DatabaseException: java.sql.SQLException:
      Connection is closed
              at liquibase.database.AbstractJdbcDatabase.rollback(AbstractJdbcDatabase.java:1143)
              at liquibase.lockservice.StandardLockService.releaseLock(StandardLockService.java:242)

我在运行 liquibase 脚本时遇到此错误。如何解决？

Answer 1

可能有一些迁移锁卡在数据库中，无法启动新的迁移脚本。截断表 DATABASECHANGELOGLOCK 以解决此问题。