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

R140300001XWIKI19571DataMigration fails on postgres 12 db

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 14.3
    • Fix Version/s: 14.3.1, 14.4-rc-1
    • Component/s: Index
    • Labels:
      None
    • Environment:
      xwiki:stable-postgres docker image
      postgres 12 database
    • Tests:
      Unit
    • Difficulty:
      Unknown
    • Documentation:
      N/A
    • Documentation in Release Notes:
      N/A
    • Pull Request Status:
      Pull Request accepted
    • Similar issues:

      Description

      Attempting to migrate the xwiki postgres docker image from 14.2 -> 14.3 results in the below migration error.

      It appears that the migration detects that the table exists within the correct schema `xwikidb`, but when it tries to load all tasks from the table it tries to select from the table in the `public` schema.

      Logging into the database and copying the, empty, table with:

      create table xwikidocumentindexingqueue as (select * from xwikidb.xwikidocumentindexingqueue)
      

      allows the migration to succeed and xwiki to return to normal functionality.

      Caused by: com.xpn.xwiki.store.migration.DataMigrationException: Migration of database [xwiki] has failed, it could not be safely used! Database is currently in version [140200010] while the required version is [140300001].
      	at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.preventAccessToOutdatedDb(AbstractDataMigrationManager.java:591)
      	at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:542)
      	at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:700)	
        ... 18 common frames omittedCaused by: com.xpn.xwiki.store.migration.DataMigrationException: Unable to update schema of wiki [xwiki]
      	at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.updateSchema(HibernateDataMigrationManager.java:193)
      	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:357)
      	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:700)
      	at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:661)
      	at com.xpn.xwiki.internal.store.hibernate.HibernateStore.beginTransaction(HibernateStore.java:838)
      	at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:576)
      	at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:1024)
      	at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:395)
      	at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2150)
      	at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2212)
      	at com.xpn.xwiki.XWiki.initializeMandatoryDocument(XWiki.java:1425)
      	at com.xpn.xwiki.XWiki.initializeMandatoryDocuments(XWiki.java:1392)
      	at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1301)
      	at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1238)
      	at com.xpn.xwiki.XWiki.<init>(XWiki.java:1211)
      	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)	
        ... 1 common frames omittedCaused by: com.xpn.xwiki.store.migration.DataMigrationException: Error while loading the existing tasks.
      	at org.xwiki.index.migration.R140300001XWIKI19571DataMigration.getPreHibernateLiquibaseChangeLog(R140300001XWIKI19571DataMigration.java:111)
      	at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.liquibaseUpdate(HibernateDataMigrationManager.java:251)
      	at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.liquibaseUpdate(HibernateDataMigrationManager.java:228)
      	at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.updateSchema(HibernateDataMigrationManager.java:188)	
        ... 23 common frames omittedCaused by: org.postgresql.util.PSQLException: ERROR: relation "xwikidocumentindexingqueue" does not exist  Position: 79
      	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2553)
      	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2285)
      	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:323)
      	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:473)
      	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:393)
      	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:164)
      	at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:114)
      	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
      	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
      	at org.xwiki.index.migration.R140300001XWIKI19571DataMigration.saveTasks(R140300001XWIKI19571DataMigration.java:165)
      	at org.xwiki.index.migration.R140300001XWIKI19571DataMigration.getPreHibernateLiquibaseChangeLog(R140300001XWIKI19571DataMigration.java:102)
        .. 26 common frames omitted
      
      
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              mleduc Manuel Leduc
              Reporter:
              james.letendre James Letendre
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Date of First Response: