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

Failing migration on a wiki which id contains only digits

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Major
    • None
    • 12.10.2
    • Old Core
    • None
    • MariaDB 15.1
    • Unknown

    Description

      The migration of the wiki "114" on myxwiki.org is failing with:

      [2021-01-05 14:49:44] [info] Caused by: org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL "create index EVENTSTATUS_ENTITYID on 114.activitystream_events_status (ases_entityid)" via JDBC Statement
      [2021-01-05 14:49:44] [info] #011at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
      [2021-01-05 14:49:44] [info] #011at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:559)
      [2021-01-05 14:49:44] [info] #011at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:504)
      [2021-01-05 14:49:44] [info] #011at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyIndexes(AbstractSchemaMigrator.java:331)
      [2021-01-05 14:49:44] [info] #011at org.hibernate.tool.schema.internal.GroupedSchemaMigratorImpl.performTablesMigration(GroupedSchemaMigratorImpl.java:84)
      [2021-01-05 14:49:44] [info] #011at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:207)
      [2021-01-05 14:49:44] [info] #011at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:114)
      [2021-01-05 14:49:44] [info] #011at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:93)
      [2021-01-05 14:49:44] [info] #011at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:62)
      [2021-01-05 14:49:44] [info] #011at com.xpn.xwiki.internal.store.hibernate.HibernateStore.updateDatabase(HibernateStore.java:1077)
      [2021-01-05 14:49:44] [info] #011... 28 common frames omitted
      [2021-01-05 14:49:44] [info] Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '114.activitystream_events_status (ases_entityid)' at line 1
      [2021-01-05 14:49:44] [info] #011at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
      [2021-01-05 14:49:44] [info] #011at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
      [2021-01-05 14:49:44] [info] #011at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
      [2021-01-05 14:49:44] [info] #011at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:764)
      [2021-01-05 14:49:44] [info] #011at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648)
      [2021-01-05 14:49:44] [info] #011at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194)
      [2021-01-05 14:49:44] [info] #011at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194)
      [2021-01-05 14:49:44] [info] #011at org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194)
      [2021-01-05 14:49:44] [info] #011at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:54)
      [2021-01-05 14:49:44] [info] #011... 37 common frames omitted
      

      Complete stack trace is attached.

      The workaround (other than not using this kind of name) is to execute (the fixed version) of this kind of request by hand and restart.

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated: