Attachment issues after upgrade from 10.11 to 11.0

Hi, today I run the upgrade from 10.11 to 11.0.

Now, I have issues accessing the attachments.

I see printouts like: Error number 3002 in 3: The attachment [/var/lib/xwiki/data/store/file/xwiki/8/b/5d9ddb6d59fb0aafdbe5b27612a12b/attachments/6/e/83a8c60520acf74bcbc5924ec73d0b/f.png

The data is still available at /var/lib/xwiki/data/store/file/xwiki on the file system.

Can anybody give me a hint, please?

Would be great if you could get the migration log (printed the first time you accessed XWiki after the upgrade).

Do you get the issue with all attachments ?

Do you have anything in /var/lib/xwiki/data/store/file/xwiki which is not a single character folder ?

Obviously, not all files are missing. I thought all files… Because the most used are missing :smiley:

An error occured the first time. Then I restarted the server and the second migration process worked fine. Maybe this is the case actually? Is it possible to restart the HibernateDataMigrationManager process? Currently, I get No data migration to apply for wiki [xwiki] currently in version [1100000].

2019-01-29 09:00:45,020 [XWiki initialization] INFO 1100000XWIKI15620DataMigration - Moving document folder [/var/lib/xwiki/data/store/file/xwiki/%50roducts/%46asteners/%42olt %50roducts/%4B%58 %42%4F%4C%54 %4Canguage/%42olt %53ections/%42olt %53ection (%53%48%41%46%54)/%57eb%48ome/~this] to new location [/var/lib/xwiki/data/store/file/xwiki/2/4/98192f46037a1f4bf5a8285466d67d]
2019-01-29 09:00:45,061 [XWiki initialization] ERROR .HibernateDataMigrationManager - Failed to migrate database [xwiki]…
com.xpn.xwiki.store.migration.DataMigrationException: Data migration R1100000XWIKI15620 failed
at com.xpn.xwiki.store.migration.hibernate.AbstractHibernateDataMigration.migrate(AbstractHibernateDataMigration.java:120)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrations(AbstractDataMigrationManager.java:848)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.migrateDatabase(AbstractDataMigrationManager.java:743)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrations(AbstractDataMigrationManager.java:664)
at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.startMigrations(HibernateDataMigrationManager.java:346)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrationsOnlyOnce(AbstractDataMigrationManager.java:644)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.tryToProcceedToMigration(AbstractDataMigrationManager.java:621)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:538)
at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:339)
at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:302)
at com.xpn.xwiki.internal.store.hibernate.HibernateStore.beginTransaction(HibernateStore.java:472)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:682)
at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:894)
at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:353)
at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1916)
at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1978)
at com.xpn.xwiki.XWiki.initializeMandatoryDocument(XWiki.java:1333)
at com.xpn.xwiki.XWiki.initializeMandatoryDocuments(XWiki.java:1307)
at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1225)
at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1167)
at com.xpn.xwiki.XWiki.(XWiki.java:1140)
at com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:117)
at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:236)
at org.xwiki.job.AbstractJob.run(AbstractJob.java:213)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate execute
at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:927)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernateBaseStore.java:1036)
at org.xwiki.store.filesystem.internal.migration.R1100000XWIKI15620DataMigration.hibernateMigrate(R1100000XWIKI15620DataMigration.java:121)
at com.xpn.xwiki.store.migration.hibernate.AbstractHibernateDataMigration.migrate(AbstractHibernateDataMigration.java:118)
… 24 common frames omitted

Would be great if you could paste the complete stack trace for this one (I’m especially interested in the last “caused by”).

Here is the full stack:

2019-01-29 09:00:45,061 [XWiki initialization] ERROR .HibernateDataMigrationManager - Failed to migrate database [xwiki]…
com.xpn.xwiki.store.migration.DataMigrationException: Data migration R1100000XWIKI15620 failed
at com.xpn.xwiki.store.migration.hibernate.AbstractHibernateDataMigration.migrate(AbstractHibernateDataMigration.java:120)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrations(AbstractDataMigrationManager.java:848)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.migrateDatabase(AbstractDataMigrationManager.java:743)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrations(AbstractDataMigrationManager.java:664)
at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.startMigrations(HibernateDataMigrationManager.java:346)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrationsOnlyOnce(AbstractDataMigrationManager.java:644)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.tryToProcceedToMigration(AbstractDataMigrationManager.java:621)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:538)
at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:339)
at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:302)
at com.xpn.xwiki.internal.store.hibernate.HibernateStore.beginTransaction(HibernateStore.java:472)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:682)
at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:894)
at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:353)
at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1916)
at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1978)
at com.xpn.xwiki.XWiki.initializeMandatoryDocument(XWiki.java:1333)
at com.xpn.xwiki.XWiki.initializeMandatoryDocuments(XWiki.java:1307)
at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1225)
at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1167)
at com.xpn.xwiki.XWiki.(XWiki.java:1140)
at com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:117)
at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:236)
at org.xwiki.job.AbstractJob.run(AbstractJob.java:213)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate execute
at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:927)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernateBaseStore.java:1036)
at org.xwiki.store.filesystem.internal.migration.R1100000XWIKI15620DataMigration.hibernateMigrate(R1100000XWIKI15620DataMigration.java:121)
at com.xpn.xwiki.store.migration.hibernate.AbstractHibernateDataMigration.migrate(AbstractHibernateDataMigration.java:118)
… 24 common frames omitted
Caused by: org.hibernate.HibernateException: Failed to refactor filesystem store paths
at org.xwiki.store.filesystem.internal.migration.R1100000XWIKI15620DataMigration.lambda$hibernateMigrate$0(R1100000XWIKI15620DataMigration.java:125)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:921)
… 27 common frames omitted
Caused by: java.lang.NumberFormatException: For input string: “id59”
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Long.parseLong(Long.java:589)
at java.lang.Long.parseLong(Long.java:631)
at org.xwiki.store.filesystem.internal.migration.R1100000XWIKI15620DataMigration.migrateDeletedAttachments(R1100000XWIKI15620DataMigration.java:247)
at org.xwiki.store.filesystem.internal.migration.R1100000XWIKI15620DataMigration.migrateDocumentContent(R1100000XWIKI15620DataMigration.java:177)
at org.xwiki.store.filesystem.internal.migration.R1100000XWIKI15620DataMigration.migrate(R1100000XWIKI15620DataMigration.java:152)
at org.xwiki.store.filesystem.internal.migration.R1100000XWIKI15620DataMigration.migrate(R1100000XWIKI15620DataMigration.java:154)
at org.xwiki.store.filesystem.internal.migration.R1100000XWIKI15620DataMigration.migrate(R1100000XWIKI15620DataMigration.java:154)
at org.xwiki.store.filesystem.internal.migration.R1100000XWIKI15620DataMigration.migrate(R1100000XWIKI15620DataMigration.java:154)
at org.xwiki.store.filesystem.internal.migration.R1100000XWIKI15620DataMigration.migrate(R1100000XWIKI15620DataMigration.java:154)
at org.xwiki.store.filesystem.internal.migration.R1100000XWIKI15620DataMigration.migrate(R1100000XWIKI15620DataMigration.java:154)
at org.xwiki.store.filesystem.internal.migration.R1100000XWIKI15620DataMigration.migrate(R1100000XWIKI15620DataMigration.java:154)
at org.xwiki.store.filesystem.internal.migration.R1100000XWIKI15620DataMigration.migrate(R1100000XWIKI15620DataMigration.java:154)
at org.xwiki.store.filesystem.internal.migration.R1100000XWIKI15620DataMigration.lambda$hibernateMigrate$0(R1100000XWIKI15620DataMigration.java:123)
… 28 common frames omitted
2019-01-29 09:00:45,061 [XWiki initialization] ERROR .HibernateDataMigrationManager - Main wiki database migration failed, it is not safe to continue!
2019-01-29 09:00:45,063 [XWiki initialization] ERROR c.x.x.XWiki - Failed to initialize mandatory document

Thanks.

Seems a deleted attachment have an unexpected folder name. I will need to check something.

I think I fixed it in https://jira.xwiki.org/browse/XWIKI-16076 and 11.0.1 will be released ASAP. Would be great if you could confirm it by replacing /usr/lib/xwiki/WEB-INF/lib/xwiki-platform-store-filesystem-oldcore-11.0.jar with the last jar on http://nexus.xwiki.org/nexus/content/repositories/snapshots/org/xwiki/platform/xwiki-platform-store-filesystem-oldcore/11.0.1-SNAPSHOT/.

Thanks.

I replaced the filesystem-oldcore using http://nexus.xwiki.org/nexus/content/repositories/snapshots/org/xwiki/platform/xwiki-platform-store-filesystem-oldcore/11.0.1-SNAPSHOT/xwiki-platform-store-filesystem-oldcore-11.0.1-20190130.074856-5.jar

Unfortunately, the same behaviour as before. There was no migration process. Is this correct?
I restarted Tomcat and here is the log:

2019-01-30 09:41:42,338 [XWiki initialization] INFO .HibernateDataMigrationManager - Storage schema updates and data migrations are enabled
2019-01-30 09:41:42,513 [XWiki initialization] INFO .HibernateDataMigrationManager - No data migration to apply for wiki [xwiki] currently in version [1100000]
2019-01-30 09:41:42,514 [XWiki initialization] INFO .HibernateDataMigrationManager - Checking Hibernate mapping and updating schema if needed for wiki [xwiki]
2019-01-30 09:41:48,018 [XWiki initialization] INFO ationFilterPreferencesMigrator - Wiki [xwiki] has already been migrated.

2019-01-30 09:42:40,391 [XWiki Solr index thread] ERROR ttachmentSolrMetadataExtractor - Failed to retrieve the content of attachment [Attachment xwiki:XWiki.Notifications.MailTemplate@NEWiki.png]
com.xpn.xwiki.XWikiException: Error number 3002 in 3: The attachment [/var/lib/xwiki/data/store/file/xwiki/5/4/8461a18320e9f8764e4858557cd5ed/attachments/b/a/69c9363e66952675742956ae1ee91f/f.png] could not be found in the filesystem attachment store.
at org.xwiki.store.legacy.store.internal.FilesystemAttachmentStore.loadAttachmentContent(FilesystemAttachmentStore.java:214)
at com.xpn.xwiki.doc.XWikiAttachment.loadAttachmentContent(XWikiAttachment.java:1073)
at com.xpn.xwiki.doc.XWikiAttachment.reloadAttachmentContent(XWikiAttachment.java:893)
at com.xpn.xwiki.doc.XWikiAttachment.getContentInputStream(XWikiAttachment.java:871)
at org.xwiki.search.solr.internal.metadata.AbstractSolrMetadataExtractor.getContentAsText(AbstractSolrMetadataExtractor.java:506)
at org.xwiki.search.solr.internal.metadata.AttachmentSolrMetadataExtractor.setLocaleAndContentFields(AttachmentSolrMetadataExtractor.java:111)
at org.xwiki.search.solr.internal.metadata.AttachmentSolrMetadataExtractor.setFieldsInternal(AttachmentSolrMetadataExtractor.java:93)
at org.xwiki.search.solr.internal.metadata.AbstractSolrMetadataExtractor.getSolrDocument(AbstractSolrMetadataExtractor.java:133)
at org.xwiki.search.solr.internal.DefaultSolrIndexer.getSolrDocument(DefaultSolrIndexer.java:504)
at org.xwiki.search.solr.internal.DefaultSolrIndexer.processBatch(DefaultSolrIndexer.java:411)
at org.xwiki.search.solr.internal.DefaultSolrIndexer.run(DefaultSolrIndexer.java:377)
at java.lang.Thread.run(Thread.java:748)

Have you reseted the data before trying again ? The migration is not designed to be retried after a failured (need to improve that) so it simply did nothing the second time I think (which explain why XWiki cannot find the attachment you printed, it was not migrated to the new format).

Is there some info how to reset the data for migration? I’ve got the same problem but i don’t have a snapshot or possibility to rollback to 10.11 and restart the upgrade process.
Removing /var/lib/xwiki/data/store and inserting the last backup from 10.11 /var/lib/xwiki/data/storage does not retrigger a migration on restart of tomcat.
Do I have to do something else to re-trigger the migration? Setting the version in the table xwikidbversion did not work either…

The currently released 11.0.1 has some retry (but it might be skipping the specific document on which the migration failed).

It will in 11.0.1. The problem is that in 11.0 the migration is totally skipped if it started in a previous run.

I’m also interested in without restoring the wiki.

Are the folder names generated randomly or is there a pattern like hash function? Probably we can write a script which will move the old files to the new location.

That’s what the migration does but in 11.0 it crash when hitting a deleted attachment. See https://jira.xwiki.org/browse/XWIKI-16076.

11.0.1 is now released (on Debian repository too). If you have a partially migrated 11.0 the best if to reset to previous data but if you cannot then you should make sure the version in the database (table xwikidbversion ) is just lower than 1100000, like 1099999 (so that it’s triggered) before starting XWiki.

It might still miss the specific document on which the 11.0 migration failed.

First, I would like to thank you supporting us.

I just installed the 11.0.1, but now I’am getting a huge amount of errors:

2019-01-30 13:49:31,062 [Scriptint Documentation binding initialization] ERROR PreferencesConfigurationSource - Failed to access configuration property

com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while reading document [xwiki:Main.WebPreferences]

at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:1022)

at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:353)

at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1916)

at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1978)

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:323)

at org.xwiki.configuration.internal.AbstractDocumentConfigurationSource.containsKey(AbstractDocumentConfigurationSource.java:196)

at org.xwiki.configuration.internal.AbstractSpacesConfigurationSource$SpaceConfigurationSource.containsKey(AbstractSpacesConfigurationSource.java:172)

at org.xwiki.configuration.internal.AbstractCompositeConfigurationSource.containsKey(AbstractCompositeConfigurationSource.java:45)

at org.xwiki.configuration.internal.AbstractCompositeConfigurationSource.containsKey(AbstractCompositeConfigurationSource.java:45)

at org.xwiki.configuration.internal.AbstractCompositeConfigurationSource.getProperty(AbstractCompositeConfigurationSource.java:95)

at org.xwiki.extension.internal.DefaultExtensionManagerConfiguration.getUserAgent(DefaultExtensionManagerConfiguration.java:273)

at org.xwiki.extension.repository.http.internal.DefaultHttpClientFactory.createHttpClientBuilder(DefaultHttpClientFactory.java:65)

at org.xwiki.extension.repository.http.internal.DefaultHttpClientFactory.createClient(DefaultHttpClientFactory.java:81)

at org.xwiki.extension.repository.xwiki.internal.XWikiExtensionRepository.getRESTResource(XWikiExtensionRepository.java:234)

at org.xwiki.extension.repository.xwiki.internal.XWikiExtensionRepository.getRESTObject(XWikiExtensionRepository.java:305)

at org.xwiki.extension.repository.xwiki.internal.XWikiExtensionRepository.resolveExtensionVersions(XWikiExtensionRepository.java:408)

at org.xwiki.extension.repository.xwiki.internal.XWikiExtensionRepository.resolveVersions(XWikiExtensionRepository.java:419)

at org.xwiki.extension.repository.internal.DefaultExtensionRepositoryManager.resolveVersions(DefaultExtensionRepositoryManager.java:384)

at org.xwiki.scripting.documentation.internal.ExtensionBindingResource.getLastReleasedVersion(ExtensionBindingResource.java:306)

at org.xwiki.scripting.documentation.internal.ExtensionBindingResource.resolve(ExtensionBindingResource.java:291)

at org.xwiki.scripting.documentation.internal.ExtensionBindingResource.getGroupId(ExtensionBindingResource.java:223)

at org.xwiki.scripting.documentation.internal.ExtensionResourceResolver.internalResolve(ExtensionResourceResolver.java:51)

at org.xwiki.scripting.documentation.internal.AbstractResourceResolver.resolve(AbstractResourceResolver.java:66)

at org.xwiki.scripting.documentation.internal.DefaultResourceResolver.internalResolve(DefaultResourceResolver.java:61)

at org.xwiki.scripting.documentation.internal.AbstractResourceResolver.resolve(AbstractResourceResolver.java:56)

at org.xwiki.scripting.documentation.internal.AbstractTypeInformationFinder.newBinding(AbstractTypeInformationFinder.java:88)

at org.xwiki.scripting.documentation.internal.AbstractScriptBindingsFinder.newBinding(AbstractScriptBindingsFinder.java:133)

at org.xwiki.scripting.documentation.internal.AbstractScriptBindingsFinder.find(AbstractScriptBindingsFinder.java:110)

at org.xwiki.scripting.documentation.internal.AbstractScriptBindingsFinder.find(AbstractScriptBindingsFinder.java:47)

at org.xwiki.scripting.documentation.internal.DefaultScriptBindingsFinder.find(DefaultScriptBindingsFinder.java:96)

at org.xwiki.scripting.documentation.internal.ScriptBindingsFinderInitializerListener$1.run(ScriptBindingsFinderInitializerListener.java:94)

at java.lang.Thread.run(Thread.java:748)

Caused by: com.xpn.xwiki.XWikiException: Error number 3301 in 3: Exception while switching to database xwiki

at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:345)

at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:302)

at com.xpn.xwiki.internal.store.hibernate.HibernateStore.beginTransaction(HibernateStore.java:472)

at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:682)

at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:894)

… 34 common frames omitted

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 [1099999] while the required version is [1100000].

at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.preventAccessToOutdatedDb(AbstractDataMigrationManager.java:594)

at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:541)

at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:339)

… 38 common frames omitted

Caused by: com.xpn.xwiki.store.migration.DataMigrationException: Data migration R1100000XWIKI15620 failed

at com.xpn.xwiki.store.migration.hibernate.AbstractHibernateDataMigration.migrate(AbstractHibernateDataMigration.java:120)

at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrations(AbstractDataMigrationManager.java:848)

at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.migrateDatabase(AbstractDataMigrationManager.java:743)

at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrations(AbstractDataMigrationManager.java:664)

at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.startMigrations(HibernateDataMigrationManager.java:346)

at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrationsOnlyOnce(AbstractDataMigrationManager.java:644)

at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.tryToProcceedToMigration(AbstractDataMigrationManager.java:621)

at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:538)

at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:339)

at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:302)

at com.xpn.xwiki.internal.store.hibernate.HibernateStore.beginTransaction(HibernateStore.java:472)

at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:682)

at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:894)

at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:353)

at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1916)

at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1978)

at com.xpn.xwiki.XWiki.initializeMandatoryDocument(XWiki.java:1333)

at com.xpn.xwiki.XWiki.initializeMandatoryDocuments(XWiki.java:1307)

at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1225)

at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1167)

at com.xpn.xwiki.XWiki.<init>(XWiki.java:1140)

at com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:117)

at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:236)

at org.xwiki.job.AbstractJob.run(AbstractJob.java:213)

… 1 common frames omitted

And I’am getting now a HTTP500 error:
javax.servlet.ServletException: com.xpn.xwiki.XWikiException: Error number 11007 in 0: Failed to extract Entity Resource Reference from URL [http://xxx.org/xwiki/bin/view/Main/]
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:520)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:427)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
javax.servlet.http.HttpServlet.service(HttpServlet.java:622)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
com.xpn.xwiki.web.ActionFilter.doFilter(ActionFilter.java:112)
org.xwiki.wysiwyg.filter.ConversionFilter.doFilter(ConversionFilter.java:109)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
org.xwiki.container.servlet.filters.internal.SetHTTPHeaderFilter.doFilter(SetHTTPHeaderFilter.java:63)
org.xwiki.container.servlet.filters.internal.SavedRequestRestorerFilter.doFilter(SavedRequestRestorerFilter.java:208)
org.xwiki.container.servlet.filters.internal.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:111)
org.xwiki.resource.servlet.RoutingFilter.doFilter(RoutingFilter.java:132)

Phew! Thank you very much for your effort. I finally got my Wiki working again…

These were the steps to get the migration working:

  • update table xwikidbversion to 109999
  • copy backup of file storage to /var/lib/xwiki/data/storage
  • don’t move or remove the partially migrated file store under /var/lib/xwiki/data/store
  • start the upgrade via apt
  • finish the flavor upgrade
  • done

I got the same migration failed errors as before when i missed copying the backup of the old storage to /var/lib/xwiki/data/storage

That’s weird it should not be needed.

  • copy backup of file storage to /var/lib/xwiki/data/storage
  • don’t move or remove the partially migrated file store under /var/lib/xwiki/data/store

It’s not very clear to me what you exactly mean, if you have a pre migration back to restore you should not keep the partially migrated store.

@ThomasFa could you pasted the complete stack trace of this error with all the “Caused by” .

2019-01-29 09:01:00,018 [XWiki Solr index thread] ERROR PreferencesConfigurationSource - Failed to access configuration property
com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while reading document [xwiki:XWiki.XWikiPreferences]
at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:1022)
at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:353)
at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1916)
at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1978)
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:323)
at org.xwiki.configuration.internal.AbstractDocumentConfigurationSource.containsKey(AbstractDocumentConfigurationSource.java:196)
at org.xwiki.configuration.internal.AbstractCompositeConfigurationSource.containsKey(AbstractCompositeConfigurationSource.java:45)
at org.xwiki.configuration.internal.AbstractCompositeConfigurationSource.getProperty(AbstractCompositeConfigurationSource.java:95)
at org.xwiki.url.internal.DefaultURLConfiguration.getURLFormatId(DefaultURLConfiguration.java:55)
at org.xwiki.url.internal.URLExecutionContextInitializer.initialize(URLExecutionContextInitializer.java:55)
at org.xwiki.context.internal.DefaultExecutionContextManager.runInitializers(DefaultExecutionContextManager.java:115)
at org.xwiki.context.internal.DefaultExecutionContextManager.initialize(DefaultExecutionContextManager.java:103)
at org.xwiki.search.solr.internal.DefaultSolrIndexer.processBatch(DefaultSolrIndexer.java:408)
at org.xwiki.search.solr.internal.DefaultSolrIndexer.run(DefaultSolrIndexer.java:377)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.xpn.xwiki.XWikiException: Error number 3301 in 3: Exception while switching to database xwiki
at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:345)
at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:302)
at com.xpn.xwiki.internal.store.hibernate.HibernateStore.beginTransaction(HibernateStore.java:472)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:682)
at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:894)
… 17 common frames omitted
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 [1008010] while the required version is [1100000].
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.preventAccessToOutdatedDb(AbstractDataMigrationManager.java:594)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:541)
at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:339)
… 21 common frames omitted
Caused by: com.xpn.xwiki.store.migration.DataMigrationException: Data migration R1100000XWIKI15620 failed
at com.xpn.xwiki.store.migration.hibernate.AbstractHibernateDataMigration.migrate(AbstractHibernateDataMigration.java:120)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrations(AbstractDataMigrationManager.java:848)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.migrateDatabase(AbstractDataMigrationManager.java:743)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrations(AbstractDataMigrationManager.java:664)
at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.startMigrations(HibernateDataMigrationManager.java:346)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.startMigrationsOnlyOnce(AbstractDataMigrationManager.java:644)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.tryToProcceedToMigration(AbstractDataMigrationManager.java:621)
at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:538)
at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:339)
at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:302)
at com.xpn.xwiki.internal.store.hibernate.HibernateStore.beginTransaction(HibernateStore.java:472)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:682)
at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:894)
at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:353)
at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1916)
at com.xpn.xwiki.XWiki.getDocument(XWiki.java:1978)
at com.xpn.xwiki.XWiki.initializeMandatoryDocument(XWiki.java:1333)
at com.xpn.xwiki.XWiki.initializeMandatoryDocuments(XWiki.java:1307)
at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1225)
at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:1167)
at com.xpn.xwiki.XWiki.(XWiki.java:1140)
at com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:117)
at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:236)
at org.xwiki.job.AbstractJob.run(AbstractJob.java:213)
… 1 common frames omitted
Caused by: com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate execute
at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:927)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeWrite(XWikiHibernateBaseStore.java:1036)
at org.xwiki.store.filesystem.internal.migration.R1100000XWIKI15620DataMigration.hibernateMigrate(R1100000XWIKI15620DataMigration.java:121)
at com.xpn.xwiki.store.migration.hibernate.AbstractHibernateDataMigration.migrate(AbstractHibernateDataMigration.java:118)
… 24 common frames omitted
Caused by: org.hibernate.HibernateException: Failed to refactor filesystem store paths
at org.xwiki.store.filesystem.internal.migration.R1100000XWIKI15620DataMigration.lambda$hibernateMigrate$0(R1100000XWIKI15620DataMigration.java:125)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:921)
… 27 common frames omitted
Caused by: java.lang.NumberFormatException: For input string: “id59”
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Long.parseLong(Long.java:589)
at java.lang.Long.parseLong(Long.java:631)
at org.xwiki.store.filesystem.internal.migration.R1100000XWIKI15620DataMigration.migrateDeletedAttachments(R1100000XWIKI15620DataMigration.java:247)
at org.xwiki.store.filesystem.internal.migration.R1100000XWIKI15620DataMigration.migrateDocumentContent(R1100000XWIKI15620DataMigration.java:177)
at org.xwiki.store.filesystem.internal.migration.R1100000XWIKI15620DataMigration.migrate(R1100000XWIKI15620DataMigration.java:152)
at org.xwiki.store.filesystem.internal.migration.R1100000XWIKI15620DataMigration.migrate(R1100000XWIKI15620DataMigration.java:154)
at org.xwiki.store.filesystem.internal.migration.R1100000XWIKI15620DataMigration.migrate(R1100000XWIKI15620DataMigration.java:154)
at org.xwiki.store.filesystem.internal.migration.R1100000XWIKI15620DataMigration.migrate(R1100000XWIKI15620DataMigration.java:154)
at org.xwiki.store.filesystem.internal.migration.R1100000XWIKI15620DataMigration.migrate(R1100000XWIKI15620DataMigration.java:154)
at org.xwiki.store.filesystem.internal.migration.R1100000XWIKI15620DataMigration.migrate(R1100000XWIKI15620DataMigration.java:154)
at org.xwiki.store.filesystem.internal.migration.R1100000XWIKI15620DataMigration.migrate(R1100000XWIKI15620DataMigration.java:154)
at org.xwiki.store.filesystem.internal.migration.R1100000XWIKI15620DataMigration.migrate(R1100000XWIKI15620DataMigration.java:154)
at org.xwiki.store.filesystem.internal.migration.R1100000XWIKI15620DataMigration.lambda$hibernateMigrate$0(R1100000XWIKI15620DataMigration.java:123)
… 28 common frames omitted

This error does not match 11.0.1 code. It looks like you are still running 11.0 or your pasted an old error.