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

Cannot update to XWiki 13.10.2: "Index column size too large. The maximum column size is 767 bytes"

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • 13.4.7, 14.0-rc-1, 13.10.3
    • 13.10.2
    • None
    • None
    • Debian 10.11; Package xwiki-tomcat9-mariadb; MariaDB 'Ver 15.1 Distrib 10.3.31-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2'
    • Unknown
    • N/A
    • N/A

    Description

      When trying to update from 13.10.1 to 13.10.2 XWiki failed to start with the error message (sorry for the long stack trace, just try to make sure nothing is missing):

       

      [2021-12-28 10:53:26] [info] 2021-12-28 10:53:26,548 [XWiki initialization] ERROR .HibernateDataMigrationManager - Failed to migrate database [xwiki]...
[2021-12-28 10:53:26] [info] com.xpn.xwiki.store.migration.DataMigrationException: Unable to update schema of wiki [xwiki]
[2021-12-28 10:53:26] [info] #011at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.updateSchema(HibernateDataMigrationManager.java:193)
[2021-12-28 10:53:26] [info] #011at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.migrateDatabase(AbstractDataMigrationManager.java:735)
[2021-12-28 10:53:26] [info] #011at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrations(AbstractDataMigrationManager.java:657)
[2021-12-28 10:53:26] [info] #011at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.startMigrations(HibernateDataMigrationManager.java:362)
[2021-12-28 10:53:26] [info] #011at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrationsOnlyOnce(AbstractDataMigrationManager.java:637)
[2021-12-28 10:53:26] [info] #011at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.tryToProcceedToMigration(AbstractDataMigrationManager.java:614)
[2021-12-28 10:53:26] [info] #011at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:539)
[2021-12-28 10:53:26] [info] #011at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:673)
[2021-12-28 10:53:26] [info] #011at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:634)
[2021-12-28 10:53:26] [info] #011at com.xpn.xwiki.internal.store.hibernate.HibernateStore.beginTransaction(HibernateStore.java:811)
[2021-12-28 10:53:26] [info] #011at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:577)
[2021-12-28 10:53:26] [info] #011at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:1020)
[2021-12-28 10:53:26] [info] #011at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:394)
[2021-12-28 10:53:26] [info] #011at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2137)
[2021-12-28 10:53:26] [info] #011at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2199)
[2021-12-28 10:53:26] [info] #011at com.xpn.xwiki.XWiki.initializeMandatoryDocument(XWiki.java:1412)
[2021-12-28 10:53:26] [info] #011at com.xpn.xwiki.XWiki.initializeMandatoryDocuments(XWiki.java:1379)
[2021-12-28 10:53:26] [info] #011at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1288)
[2021-12-28 10:53:26] [info] #011at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1225)
[2021-12-28 10:53:26] [info] #011at com.xpn.xwiki.XWiki.<init>(XWiki.java:1198)
[2021-12-28 10:53:26] [info] #011at com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:117)
[2021-12-28 10:53:26] [info] #011at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:243)
[2021-12-28 10:53:26] [info] #011at org.xwiki.job.AbstractJob.run(AbstractJob.java:220)
[2021-12-28 10:53:26] [info] #011at java.base/java.lang.Thread.run(Thread.java:829)
[2021-12-28 10:53:26] [info] Caused by: com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate execute
[2021-12-28 10:53:26] [info] #011at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:826)
[2021-12-28 10:53:26] [info] #011at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:889)
[2021-12-28 10:53:26] [info] #011at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.liquibaseUpdate(HibernateDataMigrationManager.java:289)
[2021-12-28 10:53:26] [info] #011at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.updateSchema(HibernateDataMigrationManager.java:188)
[2021-12-28 10:53:26] [info] #011... 23 common frames omitted
[2021-12-28 10:53:26] [info] Caused by: org.hibernate.HibernateException: com.xpn.xwiki.XWikiException: Error number 3005 in 3: Unable to update schema of database xwiki.
[2021-12-28 10:53:26] [info] #011at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager$2.lambda$doInHibernate$0(HibernateDataMigrationManager.java:318)
[2021-12-28 10:53:26] [info] #011at org.hibernate.jdbc.WorkExecutor.executeWork(WorkExecutor.java:37)
[2021-12-28 10:53:26] [info] #011at org.hibernate.internal.AbstractSharedSessionContract.lambda$doWork$1(AbstractSharedSessionContract.java:1095)
[2021-12-28 10:53:26] [info] #011at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.coordinateWork(JdbcCoordinatorImpl.java:308)
[2021-12-28 10:53:26] [info] #011at org.hibernate.internal.AbstractSharedSessionContract.doWork(AbstractSharedSessionContract.java:1111)
[2021-12-28 10:53:26] [info] #011at org.hibernate.internal.AbstractSharedSessionContract.doWork(AbstractSharedSessionContract.java:1098)
[2021-12-28 10:53:26] [info] #011at org.hibernate.engine.spi.SessionDelegatorBaseImpl.doWork(SessionDelegatorBaseImpl.java:1105)
[2021-12-28 10:53:26] [info] #011at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager$2.doInHibernate(HibernateDataMigrationManager.java:294)
[2021-12-28 10:53:26] [info] #011at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:820)
[2021-12-28 10:53:26] [info] #011... 26 common frames omitted
[2021-12-28 10:53:26] [info] Caused by: com.xpn.xwiki.XWikiException: Error number 3005 in 3: Unable to update schema of database xwiki.
[2021-12-28 10:53:26] [info] #011... 35 common frames omitted
[2021-12-28 10:53:26] [info] Caused by: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase.xml::R1304
06000::xwiki:
[2021-12-28 10:53:26] [info]      Reason: liquibase.exception.DatabaseException: (conn=3017) Index column size too large. The maximum column size is 767 bytes [Failed SQL: (1709)
 ALTER TABLE xwiki_main.xwikiattrecyclebin DROP KEY XDA_DOCID]
[2021-12-28 10:53:26] [info] #011at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:124)
[2021-12-28 10:53:26] [info] #011at liquibase.Liquibase.lambda$null$0(Liquibase.java:265)
[2021-12-28 10:53:26] [info] #011at liquibase.Scope.lambda$child$0(Scope.java:177)
[2021-12-28 10:53:26] [info] #011at liquibase.Scope.child(Scope.java:186)
[2021-12-28 10:53:26] [info] #011at liquibase.Scope.child(Scope.java:176)
[2021-12-28 10:53:26] [info] #011at liquibase.Scope.child(Scope.java:155)
[2021-12-28 10:53:26] [info] #011at liquibase.Scope.child(Scope.java:240)
[2021-12-28 10:53:26] [info] #011at liquibase.Liquibase.lambda$update$1(Liquibase.java:264)
[2021-12-28 10:53:26] [info] #011at liquibase.Scope.lambda$child$0(Scope.java:177)
[2021-12-28 10:53:26] [info] #011at liquibase.Scope.child(Scope.java:186)
[2021-12-28 10:53:26] [info] #011at liquibase.Scope.child(Scope.java:176)
[2021-12-28 10:53:26] [info] #011at liquibase.Scope.child(Scope.java:155)
[2021-12-28 10:53:26] [info] #011at liquibase.Liquibase.runInScope(Liquibase.java:2404)
[2021-12-28 10:53:26] [info] #011at liquibase.Liquibase.update(Liquibase.java:211)
[2021-12-28 10:53:26] [info] #011at liquibase.Liquibase.update(Liquibase.java:197)
[2021-12-28 10:53:26] [info] #011at liquibase.Liquibase.update(Liquibase.java:193)
[2021-12-28 10:53:26] [info] #011at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager$2.lambda$doInHibernate$0(HibernateDataMigrationManager.java:314)
[2021-12-28 10:53:26] [info] #011... 34 common frames omitted
[2021-12-28 10:53:26] [info] Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase.xml::R130406000::xwiki:
[2021-12-28 10:53:26] [info]      Reason: liquibase.exception.DatabaseException: (conn=3017) Index column size too large. The maximum column size is 767 bytes [Failed SQL: (1709) ALTER TABLE xwiki_main.xwikiattrecyclebin DROP KEY XDA_DOCID]
[2021-12-28 10:53:26] [info] #011at liquibase.changelog.ChangeSet.execute(ChangeSet.java:695)
[2021-12-28 10:53:26] [info] #011at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:49)
[2021-12-28 10:53:26] [info] #011at liquibase.changelog.ChangeLogIterator$2.lambda$null$0(ChangeLogIterator.java:111)
[2021-12-28 10:53:26] [info] #011at liquibase.Scope.lambda$child$0(Scope.java:177)
[2021-12-28 10:53:26] [info] #011at liquibase.Scope.child(Scope.java:186)
[2021-12-28 10:53:26] [info] #011at liquibase.Scope.child(Scope.java:176)
[2021-12-28 10:53:26] [info] #011at liquibase.Scope.child(Scope.java:155)
[2021-12-28 10:53:26] [info] #011at liquibase.changelog.ChangeLogIterator$2.lambda$run$1(ChangeLogIterator.java:110)
[2021-12-28 10:53:26] [info] #011at liquibase.Scope.lambda$child$0(Scope.java:177)
[2021-12-28 10:53:26] [info] #011at liquibase.Scope.child(Scope.java:186)
[2021-12-28 10:53:26] [info] #011at liquibase.Scope.child(Scope.java:176)
[2021-12-28 10:53:26] [info] #011at liquibase.Scope.child(Scope.java:155)
[2021-12-28 10:53:26] [info] #011at liquibase.Scope.child(Scope.java:240)
[2021-12-28 10:53:26] [info] #011at liquibase.changelog.ChangeLogIterator$2.run(ChangeLogIterator.java:94)
[2021-12-28 10:53:26] [info] #011at liquibase.Scope.lambda$child$0(Scope.java:177)
[2021-12-28 10:53:26] [info] #011at liquibase.Scope.child(Scope.java:186)
[2021-12-28 10:53:26] [info] #011at liquibase.Scope.child(Scope.java:176)
[2021-12-28 10:53:26] [info] #011at liquibase.Scope.child(Scope.java:155)
[2021-12-28 10:53:26] [info] #011at liquibase.Scope.child(Scope.java:240)
[2021-12-28 10:53:26] [info] #011at liquibase.Scope.child(Scope.java:244)
[2021-12-28 10:53:26] [info] #011at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:66)
[2021-12-28 10:53:26] [info] #011... 50 common frames omitted
[2021-12-28 10:53:26] [info] Caused by: liquibase.exception.DatabaseException: (conn=3017) Index column size too large. The maximum column size is 767 bytes [Failed SQL: (1709) ALTER TABLE xwiki_main.xwikiattrecyclebin DROP KEY XDA_DOCID]
[2021-12-28 10:53:26] [info] #011at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:392)
[2021-12-28 10:53:26] [info] #011at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:81)
[2021-12-28 10:53:26] [info] #011at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:149)
[2021-12-28 10:53:26] [info] #011at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1279)
[2021-12-28 10:53:26] [info] #011at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1261)
[2021-12-28 10:53:26] [info] #011at liquibase.changelog.ChangeSet.execute(ChangeSet.java:660)
[2021-12-28 10:53:26] [info] #011... 70 common frames omitted
[2021-12-28 10:53:26] [info] Caused by: java.sql.SQLTransientConnectionException: (conn=3017) Index column size too large. The maximum column size is 767 bytes
[2021-12-28 10:53:26] [info] #011at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:79)
[2021-12-28 10:53:26] [info] #011at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:158)
[2021-12-28 10:53:26] [info] #011at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:266)
[2021-12-28 10:53:26] [info] #011at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:366)
[2021-12-28 10:53:26] [info] #011at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:504)
[2021-12-28 10:53:26] [info] #011at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:193)
[2021-12-28 10:53:26] [info] #011at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:193)
[2021-12-28 10:53:26] [info] #011at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:193)
[2021-12-28 10:53:26] [info] #011at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:388)
[2021-12-28 10:53:26] [info] #011... 75 common frames omitted
[2021-12-28 10:53:26] [info] Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Index column size too large. The maximum column size is 767 bytes
[2021-12-28 10:53:26] [info] #011at org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(MariaDbSqlException.java:34)
[2021-12-28 10:53:26] [info] #011at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:194)
[2021-12-28 10:53:26] [info] #011at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:262)
[2021-12-28 10:53:26] [info] #011at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:360)
[2021-12-28 10:53:26] [info] #011... 80 common frames omitted
[2021-12-28 10:53:26] [info] Caused by: java.sql.SQLException: Index column size too large. The maximum column size is 767 bytes
[2021-12-28 10:53:26] [info] #011at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1694)
[2021-12-28 10:53:26] [info] #011at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1556)
[2021-12-28 10:53:26] [info] #011at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1519)
[2021-12-28 10:53:26] [info] #011at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:256)
[2021-12-28 10:53:26] [info] #011... 81 common frames omitted
[2021-12-28 10:53:26] [info] 2021-12-28 10:53:26,557 [XWiki initialization] ERROR .HibernateDataMigrationManager - Main wiki database migration failed, it is not safe to continue!

      I guess Debian 10 is no longer supported? If yes, it would be nice to increase the dependency on the MariaDB package so that an upgrade on Debian10 is not possible due to missing dependencies.

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. XWIKI-19574 Short string columns are not resized anymore during migration on non MySQL/MariaDB databases

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. XWIKI-19207 Increase the limit of the parent size to the maximum supported by MySQL

          • Major - Major loss of function.
          • Closed

          Activity

            People

              tmortagne Thomas Mortagne
              camil7 Clemens Robbenhaar
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: