This issue has been created
There is 1 update.
 
 
XWiki Platform / cid:jira-generated-image-avatar-93c9be53-0f19-4487-8ba5-dbfb16c95c0c XWIKI-22954 Open

R160100000XWIKI21738 migration error related to unknown column required right
 
View issue   ยท   Add comment
 

Issue created

 
cid:jira-generated-image-avatar-921c6f87-1772-489f-af3e-7fc77697b59a Simon Urli created this issue on 06/Mar/25 09:19
 
Summary: R160100000XWIKI21738 migration error related to unknown column required right
Issue Type: cid:jira-generated-image-avatar-93c9be53-0f19-4487-8ba5-dbfb16c95c0c Bug
Affects Versions: 16.1.0
Assignee: Unassigned
Components: Notifications
Created: 06/Mar/25 09:19
Priority: cid:jira-generated-image-static-blocker-cd6b2a3b-cbf8-4bb5-85e7-0acb4e0fbfd7 Blocker
Reporter: Simon Urli
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.
 
 

1 update

 
cid:jira-generated-image-avatar-921c6f87-1772-489f-af3e-7fc77697b59a Changes by Simon Urli on 06/Mar/25 09:28
 
Labels: regression
 
 
This message was sent by Atlassian Jira (v9.3.0#930000-sha1:287aeb6) Atlassian logo
If image attachments aren't displayed, see this article.