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

Error upgrading xwiki on mysql 5.5

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 12.10.1, 12.6.6, 13.0
    • Fix Version/s: 12.10.5, 13.2-rc-1
    • Component/s: Old Core
    • Labels:
      None
    • Difficulty:
      Unknown
    • Documentation:
      N/A
    • Documentation in Release Notes:
      N/A
    • Similar issues:

      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

        Attachments

          Activity

            People

            Assignee:
            surli Simon Urli
            Reporter:
            SigWiki SigWiki
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Date of First Response: