Problem: OpenProject blocks the upgrade to UCS 5

Knowledge Base Community
, , , , ,
#1

Problem:

The upgrade to UCS 5 failed, and the /var/log/univention/updater.log shows you, that the app OpenProject blocks the upgrade.

The system can not be updated to UCS 5.0 due to the following reasons:
 
blocking_apps:
The update to 5.0 is currently not possible,
because the following Apps are not available for UCS 5.0:
* OpenProject

Hint
Your system may currently have OpenProject version 12.0.7 installed. Upgrading the application will actually make the problem worse, because the Docker container for OpenProject version 12.2.2 will install incorrectly on UCS 4.4-9 and will not start.

Docker logs shows some like:

-----> Setting PGVERSION=13 PGBIN=/usr/lib/postgresql/13/bin PGCONF_FILE=/etc/postgresql/13/main/postgresql.conf
-----> Starting the all-in-one OpenProject setup at /app/docker/prod/supervisord...
-----> You're using an external database. Not initializing a local database cluster.
       Trying to contact PostgreSQL server instance or waiting for it to come online.
       Starting memcached: memcached.
-----> Running migrations...
       /app/config/constants/settings/definition.rb:295:in `find_env_var_override': Using unprefixed environment variables is deprecated. Pl
ease use OPENPROJECT_RAILS_CACHE_STORE instead of RAILS_CACHE_STORE (StructuredWarnings::StandardWarning)
       /app/vendor/bundle/ruby/3.1.0/gems/activerecord-7.0.3.1/lib/active_record/railtie.rb:164:in `block (3 levels) in <class:Railtie>': Ig
noring /app/db/schema_cache.yml because it has expired. The current schema version is 20220106145037, but the one in the schema cache file i
s 20220818074159. (StructuredWarnings::StandardWarning)
       /app/lib/tasks/database.rake:75:in `rescue in block (3 levels) in <top (required)>': 
       ---------------------------------------------------
       DATABASE INCOMPATIBILITY ERROR
       
       Database server version mismatch: Required version is 10.0.0, but current version is 9.6.24
       
       For more information, visit our upgrading documentation:
       https://www.openproject.org/operations/upgrading/
       ---------------------------------------------------
        (StructuredWarnings::StandardWarning)

The OpenProject vendor itself is responsible for this.

Hint

For UCS 4.4-9 still use OpenProject version 12.0.7

Solution:

The solution here is to remove the app, upgrade UCS, and then reinstall the app in the latest version.

Hint

Uninstalling usually does not remove the configurations, but I recommend making a snapshot or backup before you start.

1. Remove the app OpenProject with:

univention-app remove openproject

2. Start the upgrade for UCS

univention-upgrade

With the upgrade to UCS 5, postgresql is also upgraded and the dependency for newer OpenProject versions is fulfilled.

3. After the successfully upgrade to UCS 5, install the app OpenProject

univention-app install openproject

The above command will install the application in the latest available version for UCS 5, but if you want to install a specific version, this article will be helpful.

#2

This topic was automatically closed after 24 hours. New replies are no longer allowed.

Mastodon