Upgrading xwiki on a debian system

Help / Discuss
#1

Hello all,
I have a running system with xwiki 13.6 debian and a debian os 9 which needs an upgrade to the newest version.
It makes me some problems and I have to say that I’m not so familiar with unix distributions.
I did in the first steps the debian upgrades from 9 to 10 and then from 10 to 11. xwiki runs fine after I upgradet to debian 11. Finally, I want to do the xwiki upgrade with the following commands:
sudo wget https://maven.xwiki.org/xwiki-keyring.gpg -O /usr/share/keyrings/xwiki-keyring.gpg
sudo wget “https://maven.xwiki.org/stable/xwiki-stable.list” -O /etc/apt/sources.list.d/xwiki-stable.list
sudo apt-get update
Sudo apt-get dist-update
After the restart I got an error message “HTTP 500 - internal server error”
image

I have no ideas how I can workaround this problem(s).

maybe someone could help me.

Thank you in advance!

#2

Unfortunately, this error is more of a consequence of something else than the root problem.

Could you check the Tomcat log for the very first error you get after startup ? Should be located in /var/log/tomcat9/catalina.out.

#3

The logfiles are in Folder tomcat8.
The first error is a failed database migration the version is 121001000 and should be 150700001.
Unable to update schema xwiki
In addition some further errors:
-hibernate error executing DDL
-java.sql.SQLSyntaxErrorExeption: Row Size too large.
image

I’m quite sure that the upgrade of xwiki wasn’t successful. But what made I wrong?

#4

Could you paste the entire error, and as text instead of an image.

#5

These are the errors in as a Text:
2023-11-13 08:58:16,858 [http-nio-8080-exec-7 - http://localhost:8080/xwiki/bin/view/Main/] ERROR PreferencesConfigurationSource - Failed to access configuration value for property [url.format]. Ignoring by returning null
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:1184)
at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:399)
at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2196)
at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2258)
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)
Caused by: com.xpn.xwiki.XWikiException: Error number 3301 in 3: Exception while initializing the database
at com.xpn.xwiki.internal.store.hibernate.HibernateStore.beginTransaction(HibernateStore.java:869)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:576)
at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:1040)
… 59 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 [121001000] while the required version is [150700001].
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.beginTransaction(HibernateStore.java:867)
… 61 common frames omitted
Caused by: com.xpn.xwiki.store.migration.DataMigrationException: Unable to update schema of wiki [xwiki]

Caused by: org.hibernate.HibernateException: Failed to update the database. See the log for all errors
at com.xpn.xwiki.internal.store.hibernate.HibernateStore.updateDatabase(HibernateStore.java:1184)
at com.xpn.xwiki.internal.store.hibernate.HibernateStore.updateDatabase(HibernateStore.java:1038)
at com.xpn.xwiki.internal.store.hibernate.HibernateStore.updateDatabase(HibernateStore.java:1205)
at com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:264)
at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.hibernateShemaUpdate(HibernateDataMigrationManager.java:214)
at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.updateSchema(HibernateDataMigrationManager.java:195)
… 21 common frames omitted
Caused by: org.hibernate.tool.schema.spi.CommandAcceptanceException: Error executing DDL “alter table xwiki.xwikidoc add column XWD_ORIGINAL_METADATA_AUTHOR varchar(768)” via JDBC Statement
at org.hibernate.tool.schema.internal.exec.GenerationTargetToDatabase.accept(GenerationTargetToDatabase.java:67)
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlString(AbstractSchemaMigrator.java:581)
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applySqlStrings(AbstractSchemaMigrator.java:602)
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.migrateTable(AbstractSchemaMigrator.java:314)
at org.hibernate.tool.schema.internal.GroupedSchemaMigratorImpl.performTablesMigration(GroupedSchemaMigratorImpl.java:78)
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:220)
at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:123)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:94)
at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:63)
at com.xpn.xwiki.internal.store.hibernate.HibernateStore.updateDatabase(HibernateStore.java:1171)
… 26 common frames omitted
Caused by: java.sql.SQLSyntaxErrorException: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

2023-11-13 08:58:16,873 [http-nio-8080-exec-7 - http://localhost:8080/xwiki/bin/view/Main/] ERROR PreferencesConfigurationSource - Failed to access configuration value for property [url.format]. Ignoring by returning null
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:1184)
at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:399)
at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2196)
at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2258)

I hope the Text is not too long.

#6

The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

So this is the root problem here.

Which version of MySQL/MariaDB do you have ? Which version of XWiki are you trying to upgrade to ?

We do have a migration (“R140200010XWIKI19207”) which is supposed to make sure that all the tables are using DYNAMIC raw format (it’s the default in MySQL/MariaDB these days, but it’s not always been the case) but it might not be working (anymore ?) as well as I thought.

It would be great if you could create an issue on Loading... with the details of your current schema (no need for the data in it) so that we can try to reproduce and debug it.

In the meantime, you can make sure on your side that all the tables of the xwiki database have DYNAMIC raw format. For that you can use for example for the table xwikidoc ALTER TABLE xwiki.xwikidoc ROW_FORMAT=DYNAMIC;

#7

Hello,thank you very much for you helpful support! I will try to do the steps above.