HTTP 500 after upgrade

I upgraded to 13.1 on Ubuntu 20.04 and xwiki will not initialise. The stack trace attached shows some issue with casting a date type to a string. This looks like a bug in liquibase Bad cast in StandardChangeLogHistoryService.getRanChangeSets() · Issue #1647 · liquibase/liquibase · GitHub

java.lang.ClassCastException: java.time.LocalDateTime cannot be cast to java.lang.String
liquibase.changelog.StandardChangeLogHistoryService.getRanChangeSets(StandardChangeLogHistoryService.java:324)
liquibase.changelog.AbstractChangeLogHistoryService.upgradeChecksums(AbstractChangeLogHistoryService.java:66)
liquibase.changelog.StandardChangeLogHistoryService.upgradeChecksums(StandardChangeLogHistoryService.java:293)
liquibase.Liquibase.checkLiquibaseTables(Liquibase.java:1221)
liquibase.Liquibase.update(Liquibase.java:193)
liquibase.Liquibase.update(Liquibase.java:179)
liquibase.Liquibase.update(Liquibase.java:175)
com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager$2.lambda$doInHibernate$0(HibernateDataMigrationManager.java:313)
org.hibernate.jdbc.WorkExecutor.executeWork(WorkExecutor.java:37)
org.hibernate.internal.AbstractSharedSessionContract.lambda$doWork$1(AbstractSharedSessionContract.java:1068)
org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:306)
org.hibernate.internal.AbstractSharedSessionContract.doWork(AbstractSharedSessionContract.java:1084)
org.hibernate.internal.AbstractSharedSessionContract.doWork(AbstractSharedSessionContract.java:1071)
org.hibernate.engine.spi.SessionDelegatorBaseImpl.doWork(SessionDelegatorBaseImpl.java:1105)
com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager$2.doInHibernate(HibernateDataMigrationManager.java:293)
com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:820)
com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:889)
com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.liquibaseUpdate(HibernateDataMigrationManager.java:288)
com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.updateSchema(HibernateDataMigrationManager.java:187)
com.xpn.xwiki.store.migration.AbstractDataMigrationManager.migrateDatabase(AbstractDataMigrationManager.java:735)
com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrations(AbstractDataMigrationManager.java:657)
com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.startMigrations(HibernateDataMigrationManager.java:361)
com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrationsOnlyOnce(AbstractDataMigrationManager.java:637)
com.xpn.xwiki.store.migration.AbstractDataMigrationManager.tryToProcceedToMigration(AbstractDataMigrationManager.java:614)
com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:539)
com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:671)
com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:632)
com.xpn.xwiki.internal.store.hibernate.HibernateStore.beginTransaction(HibernateStore.java:810)
com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:577)
com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:976)
com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:393)
com.xpn.xwiki.XWiki.getDocument(XWiki.java:2141)
com.xpn.xwiki.XWiki.getDocument(XWiki.java:2203)
com.xpn.xwiki.XWiki.initializeMandatoryDocument(XWiki.java:1418)
com.xpn.xwiki.XWiki.initializeMandatoryDocuments(XWiki.java:1385)
com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1290)
com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1227)
com.xpn.xwiki.XWiki.(XWiki.java:1200)
com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:117)
org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:243)
org.xwiki.job.AbstractJob.run(AbstractJob.java:220)
java.lang.Thread.run(Thread.java:748)

xwiki.log (31.6 KB)

I remember seeing this error when a half executed Liquibase migration was left in the database. The workaround was to delete the following two tables in the database: DATABASECHANGELOG and DATABASECHANGELOGLOCK.

Thanks, this looks interesting indeed. I did not notice any new release of liquibase in a while but maybe the id changed, I will check it. Created https://jira.xwiki.org/browse/XWIKI-18515.

I found that the tables DATABASECHANGELOG and DATABASECHANGELOGLOCK still existed in the database. I dropped these tables and restarted tomcat - xwiki started okay.