Details
-
Bug
-
Resolution: Unresolved
-
Critical
-
None
-
16.1.0
-
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
- blocks
-
XWIKI-22130 ORA-00932 errors which prevent filtering and sorting Notifications filters by 'Events' column on Oracle
-
- Open
-
- relates to
-
XWIKI-22955 DefaultNotificationCacheManager shouldn't rely on a document configuration source
-
- Closed
-