Details
-
Bug
-
Resolution: Unresolved
-
Major
-
None
-
12.10.2
-
None
-
MariaDB 15.1
-
Unknown
-
Description
The migration of the wiki ("cinqtulipes") is failing on myxwiki.org with:
[2021-01-05 14:51:30] [info] 2021-01-05 14:51:30,511 [XWiki initialization] INFO .HibernateDataMigrationManager - The following data migration(s) will be applied for wiki [cinqtulipes] currently in version [1138000]: [2021-01-05 14:51:30] [info] 2021-01-05 14:51:30,511 [XWiki initialization] INFO .HibernateDataMigrationManager - R120901000XWIKI17761 - Move old Ratings XObject to the default Solr rating store. [2021-01-05 14:51:30] [info] 2021-01-05 14:51:30,511 [XWiki initialization] INFO .HibernateDataMigrationManager - R121001000XWIKI18145 - Ensure that foreign keys have the proper name. [2021-01-05 14:51:31] [info] 2021-01-05 14:51:31,047 [XWiki initialization] INFO .HibernateDataMigrationManager - Checking Hibernate mapping and updating schema if needed for wiki [cinqtulipes] [2021-01-05 14:51:32] [info] 2021-01-05 14:51:32,289 [XWiki initialization] ERROR c.x.x.i.s.h.HibernateStore - Error executing DDL "alter table cinqtulipes.xwikilists add constraint FKsneohafq81w2sgywprwl5o1lh foreign key (XWL_ID, XWL_NAME) references cinqtulipes.xwikiproperties (XWP_ID, XWP_NAME)" via JDBC Statement [2021-01-05 14:51:32] [info] org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table cinqtulipes.xwikilists add constraint FKsneohafq81w2sgywprwl5o1lh foreign key (XWL_ID, XWL_NAME) references cinqtulipes.xwikiproperties (XWP_ID, XWP_NAME)" via JDBC Statement [2021-01-05 14:51:32] [info] #011at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67) [2021-01-05 14:51:32] [info] #011at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559) [2021-01-05 14:51:32] [info] #011at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504) [2021-01-05 14:51:32] [info] #011at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433) [2021-01-05 14:51:32] [info] #011at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249) [2021-01-05 14:51:32] [info] #011at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114) [2021-01-05 14:51:32] [info] #011at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:93) [2021-01-05 14:51:32] [info] #011at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:62) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.internal.store.hibernate.HibernateStore.updateDatabase(HibernateStore.java:1077) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.internal.store.hibernate.HibernateStore.updateDatabase(HibernateStore.java:944) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.internal.store.hibernate.HibernateStore.updateDatabase(HibernateStore.java:1111) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:274) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.hibernateShemaUpdate(HibernateDataMigrationManager.java:207) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.updateSchema(HibernateDataMigrationManager.java:188) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.migrateDatabase(AbstractDataMigrationManager.java:735) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrations(AbstractDataMigrationManager.java:667) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.startMigrations(HibernateDataMigrationManager.java:361) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrationsOnlyOnce(AbstractDataMigrationManager.java:637) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.tryToProcceedToMigration(AbstractDataMigrationManager.java:614) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:539) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:672) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:633) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.internal.store.hibernate.HibernateStore.beginTransaction(HibernateStore.java:811) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:577) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:976) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:394) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2144) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2206) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.XWiki.initializeMandatoryDocument(XWiki.java:1418) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.XWiki.initializeMandatoryDocuments(XWiki.java:1385) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1290) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1227) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.XWiki.<init>(XWiki.java:1200) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:117) [2021-01-05 14:51:32] [info] #011at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:243) [2021-01-05 14:51:32] [info] #011at org.xwiki.job.AbstractJob.run(AbstractJob.java:220) [2021-01-05 14:51:32] [info] #011at java.base/java.lang.Thread.run(Thread.java:834) [2021-01-05 14:51:32] [info] Caused by: java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`cinqtulipes`.`#sql-3218_33768`, CONSTRAINT `FKsneohafq81w2sgywprwl5o1lh` FOREIGN KEY (`XWL_ID`, `XWL_NAME`) REFERENCES `xwikiproperties` (`XWP_ID`, `XWP_NAME`)) [2021-01-05 14:51:32] [info] #011at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117) [2021-01-05 14:51:32] [info] #011at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) [2021-01-05 14:51:32] [info] #011at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) [2021-01-05 14:51:32] [info] #011at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764) [2021-01-05 14:51:32] [info] #011at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648) [2021-01-05 14:51:32] [info] #011at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194) [2021-01-05 14:51:32] [info] #011at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194) [2021-01-05 14:51:32] [info] #011at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194) [2021-01-05 14:51:32] [info] #011at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54) [2021-01-05 14:51:32] [info] #011... 36 common frames omitted [2021-01-05 14:51:32] [info] 2021-01-05 14:51:32,291 [XWiki initialization] ERROR .HibernateDataMigrationManager - Failed to migrate database [cinqtulipes]... [2021-01-05 14:51:32] [info] com.xpn.xwiki.store.migration.DataMigrationException: Unable to update schema of wiki [cinqtulipes] [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.updateSchema(HibernateDataMigrationManager.java:192) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.migrateDatabase(AbstractDataMigrationManager.java:735) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrations(AbstractDataMigrationManager.java:667) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.startMigrations(HibernateDataMigrationManager.java:361) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrationsOnlyOnce(AbstractDataMigrationManager.java:637) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.tryToProcceedToMigration(AbstractDataMigrationManager.java:614) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:539) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:672) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:633) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.internal.store.hibernate.HibernateStore.beginTransaction(HibernateStore.java:811) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:577) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:976) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:394) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2144) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2206) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.XWiki.initializeMandatoryDocument(XWiki.java:1418) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.XWiki.initializeMandatoryDocuments(XWiki.java:1385) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1290) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1227) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.XWiki.<init>(XWiki.java:1200) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:117) [2021-01-05 14:51:32] [info] #011at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:243) [2021-01-05 14:51:32] [info] #011at org.xwiki.job.AbstractJob.run(AbstractJob.java:220) [2021-01-05 14:51:32] [info] #011at java.base/java.lang.Thread.run(Thread.java:834) [2021-01-05 14:51:32] [info] Caused by: org.hibernate.HibernateException: Failed to update the database. See the log for all errors [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.internal.store.hibernate.HibernateStore.updateDatabase(HibernateStore.java:1090) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.internal.store.hibernate.HibernateStore.updateDatabase(HibernateStore.java:944) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.internal.store.hibernate.HibernateStore.updateDatabase(HibernateStore.java:1111) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:274) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.hibernateShemaUpdate(HibernateDataMigrationManager.java:207) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.updateSchema(HibernateDataMigrationManager.java:188) [2021-01-05 14:51:32] [info] #011... 23 common frames omitted [2021-01-05 14:51:32] [info] Caused by: org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "alter table cinqtulipes.xwikilists add constraint FKsneohafq81w2sgywprwl5o1lh foreign key (XWL_ID, XWL_NAME) references cinqtulipes.xwikiproperties (XWP_ID, XWP_NAME)" via JDBC Statement [2021-01-05 14:51:32] [info] #011at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67) [2021-01-05 14:51:32] [info] #011at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559) [2021-01-05 14:51:32] [info] #011at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504) [2021-01-05 14:51:32] [info] #011at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyForeignKeys(AbstractSchemaMigrator.java:433) [2021-01-05 14:51:32] [info] #011at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:249) [2021-01-05 14:51:32] [info] #011at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114) [2021-01-05 14:51:32] [info] #011at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:93) [2021-01-05 14:51:32] [info] #011at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:62) [2021-01-05 14:51:32] [info] #011at com.xpn.xwiki.internal.store.hibernate.HibernateStore.updateDatabase(HibernateStore.java:1077) [2021-01-05 14:51:32] [info] #011... 28 common frames omitted [2021-01-05 14:51:32] [info] Caused by: java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`cinqtulipes`.`#sql-3218_33768`, CONSTRAINT `FKsneohafq81w2sgywprwl5o1lh` FOREIGN KEY (`XWL_ID`, `XWL_NAME`) REFERENCES `xwikiproperties` (`XWP_ID`, `XWP_NAME`)) [2021-01-05 14:51:32] [info] #011at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117) [2021-01-05 14:51:32] [info] #011at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) [2021-01-05 14:51:32] [info] #011at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) [2021-01-05 14:51:32] [info] #011at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764) [2021-01-05 14:51:32] [info] #011at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648) [2021-01-05 14:51:32] [info] #011at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194) [2021-01-05 14:51:32] [info] #011at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194) [2021-01-05 14:51:32] [info] #011at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194) [2021-01-05 14:51:32] [info] #011at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54) [2021-01-05 14:51:32] [info] #011... 36 common frames omitted