Details
Blocker Description
Hi,
I tried to update xWIKI from 12.2.1 to 12.10.4. But the DB Update with liquibase failed. I tried also to update all plugins and to uninstall the "Activity Stream Application" but it doesn't solved the issue. Any idea?
Environment:
- CentOS 7.9.2009
- Tomcat 9.0.43
- MariaDB Ver 15.1
Error Message:
2021-03-05 16:46:16,385 [XWiki initialization] INFO .HibernateDataMigrationManager - Storage schema updates and data migrations are enabled
2021-03-05 16:46:16,627 [XWiki initialization] INFO .HibernateDataMigrationManager - The following data migration(s) will be applied for wiki [xwiki] currently in version [1138000]:
2021-03-05 16:46:16,628 [XWiki initialization] INFO .HibernateDataMigrationManager - R120901000XWIKI17761 - Move old Ratings XObject to the default Solr rating store.
2021-03-05 16:46:16,628 [XWiki initialization] INFO .HibernateDataMigrationManager - R121001000XWIKI18145 - Ensure that foreign keys have the proper name.
2021-03-05 16:46:16,682 [XWiki initialization] INFO 1001000XWIKI18145DataMigration - Dropping foreign key [activitystream_events_status.fkbf7104e8cb8c5002]: this key will be recreated with the following name: [FKmwu6uxkc2jl3yvej4wi1p0pv0]
2021-03-05 16:46:16,687 [XWiki initialization] INFO 1001000XWIKI18145DataMigration - Dropping foreign key [activitystream_events_targets.fk44132acc763934e1]: this key will be recreated with the following name: [FK2bj2ghquiq79toomkvugw7iie]
2021-03-05 16:46:16,694 [XWiki initialization] INFO 1001000XWIKI18145DataMigration - Dropping foreign key [feeds_aggregatorurlgroups.fk7b845b068e772cc]: this key will be recreated with the following name: [FKi44e1ie6x9s80y4umn09018ja]
2021-03-05 16:46:16,700 [XWiki initialization] INFO 1001000XWIKI18145DataMigration - Dropping foreign key [feeds_feedentrytags.fkbe0037834855150f]: this key will be recreated with the following name: [FK2u68px06ael6f73r3uudp6835]
2021-03-05 16:46:16,773 [XWiki initialization] INFO .HibernateDataMigrationManager - Running early schema updates (using liquibase) for database [xwiki]
2021-03-05 16:46:19,008 [XWiki initialization] ERROR l.c.ChangeSet - Change Set liquibase.xml::R121001000::xwikiorg failed. Error: (conn=21) Error on rename of './xwiki/activitystream_events_status' to './xwiki/#sql2-580-15' (errno: 152) [Failed SQL: ALTER TABLE xwiki.activitystream_events_status DROP FOREIGN KEY fkbf7104e8cb8c5002]
2021-03-05 16:46:19,018 [XWiki initialization] ERROR .HibernateDataMigrationManager - Failed to migrate database [xwiki]...
com.xpn.xwiki.store.migration.DataMigrationException: Unable to update schema of wiki [xwiki]
at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.updateSchema(HibernateDataMigrationManager.java:192)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.migrateDatabase(AbstractDataMigrationManager.java:735)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrations(AbstractDataMigrationManager.java:657)
at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.startMigrations(HibernateDataMigrationManager.java:361)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrationsOnlyOnce(AbstractDataMigrationManager.java:637)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.tryToProcceedToMigration(AbstractDataMigrationManager.java:614)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:539)
at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:671)
at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:632)
at com.xpn.xwiki.internal.store.hibernate.HibernateStore.beginTransaction(HibernateStore.java:810)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:577)
at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:976)
at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:394)
at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2144)
at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2206)
at com.xpn.xwiki.XWiki.initializeMandatoryDocument(XWiki.java:1418)
at com.xpn.xwiki.XWiki.initializeMandatoryDocuments(XWiki.java:1385)
at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1290)
at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1227)
at com.xpn.xwiki.XWiki.<init>(XWiki.java:1200)
at com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:117)
at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:243)
at org.xwiki.job.AbstractJob.run(AbstractJob.java:220)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate execute
at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:826)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:889)
at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.liquibaseUpdate(HibernateDataMigrationManager.java:288)
at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.updateSchema(HibernateDataMigrationManager.java:187)
... 23 common frames omitted