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

R160100000XWIKI21738 migration error related to unknown column required right

    XMLWordPrintable

Details

    • Unknown

    Description

      The following stack trace might appear during the migration, but it doesn't prevent the migration to be executed:

      2025-03-01 18:11:40,231 [XWiki initialization] INFO  .HibernateDataMigrationManager -   R160500000XWIKI22271 - Ensure that filters related to deleted wiki are clean up. 
      2025-03-01 18:11:40,231 [XWiki initialization] INFO  .HibernateDataMigrationManager - Checking Hibernate mapping and updating schema if needed for wiki [xwiki] 
      2025-03-01 18:11:41,161 [XWiki initialization] INFO  .HibernateDataMigrationManager - Starting data migration [R160100000XWIKI21738] with version [160100000] on database [xwiki] 
      2025-03-01 18:11:41,254 [XWiki initialization] INFO  0100000XWIKI21738DataMigration - Found [1] filters to migrate... 
      2025-03-01 18:11:41,255 [XWiki initialization] INFO  0100000XWIKI21738DataMigration - Migrating filters for [1] entities 
      2025-03-01 18:11:41,650 [XWiki initialization] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 1054, SQLState: 42S22 
      2025-03-01 18:11:41,650 [XWiki initialization] ERROR o.h.e.j.s.SqlExceptionHelper   - Unknown column 'xwikidocum0_.XWD_ENFORCE_REQUIRED_RIGHTS' in 'field list' 
      2025-03-01 18:11:41,652 [XWiki initialization] ERROR PreferencesConfigurationSource - Failed to access configuration value for property [notifications.rest.cache]. Ignoring by returning null 
      com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while reading document [techtest01localusers:XWiki.XWikiPreferences()]
              at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:1219)
              at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:420)
              at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2197)
              at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2259)
              at org.xwiki.configuration.internal.AbstractXWikiPreferencesConfigurationSource.getBaseObject(AbstractXWikiPreferencesConfigurationSource.java:86)
              at org.xwiki.configuration.internal.AbstractXWikiPreferencesConfigurationSource.getBaseProperty(AbstractXWikiPreferencesConfigurationSource.java:139)
              at org.xwiki.configuration.internal.AbstractXWikiPreferencesConfigurationSource.getBaseProperty(AbstractXWikiPreferencesConfigurationSource.java:156)
              at org.xwiki.configuration.internal.AbstractDocumentConfigurationSource.getPropertyValue(AbstractDocumentConfigurationSource.java:348)
              at org.xwiki.configuration.internal.AbstractDocumentConfigurationSource.containsKey(AbstractDocumentConfigurationSource.java:203)
              at org.xwiki.configuration.internal.AbstractCompositeConfigurationSource.containsKey(AbstractCompositeConfigurationSource.java:45)
              at org.xwiki.configuration.internal.AbstractCompositeConfigurationSource.getProperty(AbstractCompositeConfigurationSource.java:95)
              at org.xwiki.notifications.internal.DefaultNotificationConfiguration.isRestCacheEnabled(DefaultNotificationConfiguration.java:67)
              at org.xwiki.notifications.notifiers.internal.DefaultNotificationCacheManager.flushLongCache(DefaultNotificationCacheManager.java:205)
              at org.xwiki.notifications.rest.internal.NotificationEventExecutorListener.onEvent(NotificationEventExecutorListener.java:77)
              at org.xwiki.observation.internal.DefaultObservationManager.notify(DefaultObservationManager.java:338)
              at org.xwiki.observation.internal.DefaultObservationManager.notify(DefaultObservationManager.java:303)
              at org.xwiki.notifications.filters.internal.NotificationFilterPreferenceStore.lambda$saveFilterPreferences$10(NotificationFilterPreferenceStore.java:485)
              at org.xwiki.notifications.filters.internal.NotificationFilterPreferenceStore.configureContextWrapper(NotificationFilterPreferenceStore.java:513)
              at org.xwiki.notifications.filters.internal.NotificationFilterPreferenceStore.saveFilterPreferences(NotificationFilterPreferenceStore.java:456)
              at org.xwiki.notifications.filters.internal.NotificationFilterPreferenceStore.saveFilterPreferences(NotificationFilterPreferenceStore.java:427)
              at org.xwiki.notifications.filters.migration.R160100000XWIKI21738DataMigration.migrateFilters(R160100000XWIKI21738DataMigration.java:198)
              at org.xwiki.notifications.filters.migration.R160100000XWIKI21738DataMigration.hibernateMigrate(R160100000XWIKI21738DataMigration.java:144)
              at com.xpn.xwiki.store.migration.hibernate.AbstractHibernateDataMigration.migrate(AbstractHibernateDataMigration.java:118)
              at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrations(AbstractDataMigrationManager.java:882)
              at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.migrateDatabase(AbstractDataMigrationManager.java:781)
              at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrations(AbstractDataMigrationManager.java:702)
              at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.startMigrations(HibernateDataMigrationManager.java:363)
              at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrationsOnlyOnce(AbstractDataMigrationManager.java:682)
              at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.tryToProcceedToMigration(AbstractDataMigrationManager.java:659)
              at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:584)
              at com.xpn.xwiki.internal.store.hibernate.HibernateStore.beginTransaction(HibernateStore.java:867)
              at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:576)
              at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:1068)
              at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:420)
              at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2197)
              at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2259)
              at com.xpn.xwiki.XWiki.initializeMandatoryDocument(XWiki.java:1460)
              at com.xpn.xwiki.XWiki.initializeMandatoryDocuments(XWiki.java:1427)
              at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1355)
              at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1292)
              at com.xpn.xwiki.XWiki.<init>(XWiki.java:1265)
              at com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:103)
              at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:246)
              at org.xwiki.job.AbstractJob.run(AbstractJob.java:223)
              at java.base/java.lang.Thread.run(Thread.java:1583)
      Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
              at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
              at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:37)
              at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
              at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
              at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:67)
              at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.getResultSet(AbstractLoadPlanBasedLoader.java:390)
              at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeQueryStatement(AbstractLoadPlanBasedLoader.java:163)
              at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:104)
              at org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntityLoader.load(AbstractLoadPlanBasedEntityLoader.java:285)
              at org.hibernate.persister.entity.AbstractEntityPersister.doLoad(AbstractEntityPersister.java:4550)
              at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:4540)
              at org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:571)
              at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:539)
              at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:208)
              at org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:327)
              at org.hibernate.event.internal.DefaultLoadEventListener.doOnLoad(DefaultLoadEventListener.java:108)
              at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:74)
              at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:118)
              at org.hibernate.internal.SessionImpl.fireLoadNoChecks(SessionImpl.java:1231)
              at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1220)
              at org.hibernate.internal.SessionImpl.access$2100(SessionImpl.java:202)
              at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.doLoad(SessionImpl.java:2848)
              at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.lambda$load$1(SessionImpl.java:2825)
              at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.perform(SessionImpl.java:2781)
              at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.load(SessionImpl.java:2825)
              at org.hibernate.internal.SessionImpl.get(SessionImpl.java:1019)
              at org.hibernate.engine.spi.SessionDelegatorBaseImpl.get(SessionDelegatorBaseImpl.java:1000)
              at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:1073)
              ... 44 common frames omitted
      Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'xwikidocum0_.XWD_ENFORCE_REQUIRED_RIGHTS' in 'field list'
              at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
              at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
              at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
              at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:972)
              at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:123)
              at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:123)
              at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:123)
              at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
              ... 67 common frames omitted
      2025-03-01 18:11:41,683 [XWiki initialization] INFO  0100000XWIKI21738DataMigration - No more filters found to migrate. 
      

      Attachments

        Issue Links

          Activity

            People

              surli Simon Urli
              surli Simon Urli
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated: