Upgrade 16.10.2 -error

Help / Discuss
1

Hi
I’m trying to upgrade my xwiki from 15.10.12 to 16.10.2
I’m using MSSQL and for some reason the database won’t update.

20-Jan-2025 10:05:22.531 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version name:   Apache Tomcat/9.0.73
20-Jan-2025 10:05:22.538 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built:          Feb 27 2023 15:33:40 UTC
20-Jan-2025 10:05:22.538 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version number: 9.0.73.0
20-Jan-2025 10:05:22.538 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name:               Windows Server 2019
20-Jan-2025 10:05:22.538 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version:            10.0
20-Jan-2025 10:05:22.538 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture:          amd64
20-Jan-2025 10:05:22.538 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home:             C:\Program Files\Eclipse Adoptium\jdk-17.0.13.11-hotspot
20-Jan-2025 10:05:22.538 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version:           17.0.13+11
20-Jan-2025 10:05:22.538 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor:            Eclipse Adoptium

My log with error

xwikiBug.txt (32.0 KB)

2

You should find a similar error, but more complete (it’s missing the root cause here), in the Tomcat log. This should help understand why exactly MSSQL does not like the following request generated by Hibernate to add a column to the document table:

alter table xwiki.xwikidoc add XWD_ENFORCE_REQUIRED_RIGHTS bit default false not null

Note that MSSQL is not really a database engine officially supported by XWiki, but it’s still interesting to know what’s wrong with it since you were apparently using it without too much problems.

3

thanks
I was focusing on something else and didn’t notice it. If I have a database with data, there is a problem with adding a column with a default value and not null. Before upgreading xwiki, I created a new column and updated my data

4

@ewa If you find more details in the log about the root cause of the error it would be interesting to create a jira issue about it as we might still consider fixing it if it’s easy (@MichaelHamann suggested it might be that false might not be a valid value for a bit in MSSQL and XWiki should indicate 0 instead, which is an easy fix).