Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-18203

Failing automatic constraint creation on a specific wiki

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Major
    • None
    • 12.10.2
    • Old Core
    • 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
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            tmortagne Thomas Mortagne
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: