Top Menu

Jump to content
Home
    Modules
      • Projects
      • Activity
      • Work packages
      • Gantt charts
      • Calendars
      • Team planners
      • Boards
      • News
    • Getting started
    • Introduction video
      Welcome to OpenProject Community
      Get a quick overview of project management and team collaboration with OpenProject. You can restart this video from the help menu.
    • Help and support
    • Upgrade to Enterprise edition
    • User guides
    • Videos
    • Shortcuts
    • Community forum
    • Enterprise support
    • Additional resources
    • Data privacy and security policy
    • Digital accessibility (DE)
    • OpenProject website
    • Security alerts / Newsletter
    • OpenProject blog
    • Release notes
    • Report a bug
    • Development roadmap
    • Add and edit translations
    • API documentation
  • Sign in
      Forgot your password?

      or sign in with your existing account

      Google

Side Menu

  • Overview
  • Activity
    Activity
  • Roadmap
  • Work packages
    Work packages
  • Gantt charts
    Gantt charts
  • Calendars
    Calendars
  • Team planners
    Team planners
  • Boards
    Boards
  • News
  • Forums

Content

Support Installation & Updates
  1. OpenProject
  2. Forums
  3. Support Installation & Updates
  4. Docker: "DATABASE INCOMPATIBILITY ERROR" after upgrade to 12.1.1

Docker: "DATABASE INCOMPATIBILITY ERROR" after upgrade to 12.1.1

Added by Andreas Korbmann about 3 years ago

Hello together,

After upgrading Openproject to version 12.1.1, a DATABASE INCOMPATIBILITY ERROR occurs when starting:

2022-05-05 08:48:36 stdout         (StructuredWarnings::StandardWarning)
2022-05-05 08:48:36 stdout        ---------------------------------------------------
2022-05-05 08:48:36 stdout        https://www.openproject.org/operations/upgrading/
2022-05-05 08:48:36 stdout        For more information, visit our upgrading documentation:
2022-05-05 08:48:36 stdout        
2022-05-05 08:48:36 stdout        Database server version mismatch: Required version is 10.0.0, but current version is 9.6.24
2022-05-05 08:48:36 stdout        
2022-05-05 08:48:36 stdout        DATABASE INCOMPATIBILITY ERROR
2022-05-05 08:48:36 stdout        ---------------------------------------------------
2022-05-05 08:48:36 stdout        /app/lib/tasks/database.rake:77:in `rescue in block (3 levels) in <top (required)>': 
2022-05-05 08:48:36 stdout        /app/vendor/bundle/ruby/3.0.0/gems/activerecord-6.1.5.1/lib/active_record/railtie.rb:152:in `block (3 levels) in <class:Railtie>': Ignoring /app/db/schema_cache.yml because it has expired. The current schema version is 20211118203332, but the one in the cache is 20220428071221. (StructuredWarnings::StandardWarning)
2022-05-05 08:48:30 stdout        /app/config/constants/settings/definition.rb:307:in `find_env_var_override': Using unprefixed environment variables is deprecated. Please use OPENPROJECT_RAILS_CACHE_STORE instead of RAILS_CACHE_STORE (StructuredWarnings::StandardWarning)
2022-05-05 08:48:30 stdout        /app/config/constants/settings/definition.rb:307:in `find_env_var_override': Using unprefixed environment variables is deprecated. Please use OPENPROJECT_ATTACHMENTS_STORAGE_PATH instead of ATTACHMENTS_STORAGE_PATH (StructuredWarnings::StandardWarning)
2022-05-05 08:48:18 stdout -----> Running migrations...
2022-05-05 08:48:18 stdout        Starting memcached: memcached.
2022-05-05 08:48:18 stdout        Trying to contact PostgreSQL server instance or waiting for it to come online.
2022-05-05 08:48:18 stdout        server started
2022-05-05 08:48:18 stdout        waiting for server to start..... done
2022-05-05 08:48:15 stdout -----> Database cluster already exists, not modifying.
2022-05-05 08:48:15 stdout -----> Starting the all-in-one OpenProject setup at /app/docker/prod/supervisord...
2022-05-05 08:48:14 stdout -----> Setting PGVERSION=9.6 PGBIN=/usr/lib/postgresql/9.6/bin PGCONF_FILE=/etc/postgresql/9.6/main/postgresql.conf
2022-05-05 08:48:14 stdout -----> Existing PostgreSQL cluster found in /var/openproject/pgdata.

What can I do?


Replies (4)

RE: Docker: "DATABASE INCOMPATIBILITY ERROR" after upgrade to 12.1.1 - Added by Marek Kivitalo about 3 years ago

Hello,

Having the same problem on Unraid docker install after upgrade.

(StructuredWarnings::StandardWarning)
-----> Existing PostgreSQL cluster found in /var/openproject/pgdata.
-----> Setting PGVERSION=9.6 PGBIN=/usr/lib/postgresql/9.6/bin PGCONF_FILE=/etc/postgresql/9.6/main/postgresql.conf
-----> Starting the all-in-one OpenProject setup at /app/docker/prod/supervisord...
-----> Database cluster already exists, not modifying.
waiting for server to start...... done
server started
Trying to contact PostgreSQL server instance or waiting for it to come online.
Starting memcached: memcached.
-----> Running migrations...
/app/config/constants/settings/definition.rb:307:in `find_env_var_override': Using unprefixed environment variables is deprecated. Please use OPENPROJECT_ATTACHMENTS_STORAGE_PATH instead of ATTACHMENTS_STORAGE_PATH (StructuredWarnings::StandardWarning)
/app/config/constants/settings/definition.rb:307:in `find_env_var_override': Using unprefixed environment variables is deprecated. Please use OPENPROJECT_RAILS_CACHE_STORE instead of RAILS_CACHE_STORE (StructuredWarnings::StandardWarning)
/app/vendor/bundle/ruby/3.0.0/gems/activerecord-6.1.5.1/lib/active_record/railtie.rb:152:in `block (3 levels) in <class:Railtie>': Ignoring /app/db/schema_cache.yml because it has expired. The current schema version is 20220106145037, but the one in the cache is 20220428071221. (StructuredWarnings::StandardWarning)
/app/lib/tasks/database.rake:77: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)

RE: RE: Docker: "DATABASE INCOMPATIBILITY ERROR" after upgrade to 12.1.1 - Added by James Dean about 3 years ago

Did anyone fix this?

RE: Docker: "DATABASE INCOMPATIBILITY ERROR" after upgrade to 12.1.1 - Added by Andreas Korbmann almost 3 years ago

Hi,

yes, I was able to solve it with this guide:

Migrating your OpenProject installation to PostgreSQL 13

RE: Docker: \"DATABASE INCOMPATIBILITY ERROR\" after upgrade to 12.1.1 - Added by Hubertus Paar almost 3 years ago

Hi I followed the guide but this is what I get when running the upgrade:

The database cluster will be initialized with locale "C.UTF-8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /var/openproject/pgdata-next ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... 2022-05-25 09:15:48.495 UTC [38] LOG:  could not link file "pg_wal/xlogtemp.38" to "pg_wal/000000010000000000000001": Function not implemented
2022-05-25 09:15:48.497 UTC [38] FATAL:  could not open file "pg_wal/000000010000000000000001": No such file or directory
child process exited with exit code 1
initdb: removing contents of data directory "/var/openproject/pgdata-next"
  • (1 - 4/4)
Loading...