Top Menu

Jump to content
    Global modules

    Global modules

    • Home
    • Projects
    • Activity
    • Work packages
    • Gantt charts
    • Calendars
    • Team planners
    • Boards
    • News
    Home
    Home
Help
    Getting started
    • Introduction video
  • 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

User menu

Sign in
Forgot your password?

or sign in with your existing account

OpenProject ID Google

Side Menu

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

Content

Expand project menu
Support Installation & Updates
  1. OpenProject Community
  2. OpenProject
  3. Forums
  4. Support Installation & Updates
  5. All-In-One OP down after Update to 16.1.1 and try to update to postgress 17

All-In-One OP down after Update to 16.1.1 and try to update to postgress 17

Added by Jan Schebeko about 2 months ago

Hi.

We use the ALL-IN-ONE postgres OP installation via docker.

i tried to update to postgres 17 after the OP Update to 16.1.1. Used this doku: https://www.openproject.org/docs/installation-and-operations/misc/migration-to-postgresql17/

As i run on the error most of the others also get with the ALL-IN-ONE Docker installation, i reset to the previous postgress version as mention in the troubleshotting advices in the buttom of the doku.

OP runs and everthing looks fine. But today the service is done and docker log show this:

waiting for server to start.... stopped waiting
-----> Existing PostgreSQL cluster found in /var/openproject/pgdata.
-----> 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...
-----> Database cluster already exists, not modifying.
pg_ctl: could not start server
Examine the log output.

As the container didnt start i cant look inside the container to logs or anything else.

Any tipp to fix this ? And how can i safe the OP date from the postgress database. Is it just the host folder: /var/lib/openproject/pgdata which is mounted to the container?

Kind regards 
Jan



Replies (3)

RE: All-In-One OP down after Update to 16.1.1 and try to update to postgress 17 - Added by Jan Schebeko about 2 months ago

Das Problem war nicht in OP oder Postgres zu suchen. Der Speicher war auf Grund eines Fehler beim Housekeeping im Backup-Prozess zugelaufen. Da nach lief alles wieder

RE: All-In-One OP down after Update to 16.1.1 and try to update to postgress 17 - Added by Jan Schebeko 2 days ago

I now have try to update the postgres DB to 17 with the new documentation.

Use All-In-On openproject and go truth the process to install a new pg_data17 DB folder like the documtation explained it.

After all is done and i restart the openprojekt container the login is not possible. 

Error: "Benutzer oder Kennwort ist ungültig oder der Account wurde wegen mehrfacher Falscheingabe temporär gesperrt, in diesem Fall wird er in Kürze automatisch wieder freigeschaltet."  English: "The username or password is invalid, or the account has been temporarily locked due to repeated incorrect entries. In this case, it will be automatically reactivated shortly."

Any Ideas? Should i remove the container and start it completly new with the new folder for pddata17?

Thx Jan

RE: All-In-One OP down after Update to 16.1.1 and try to update to postgress 17 - Added by Jan Schebeko 2 days ago

Start a complete new container works now. I had just restarted the old one. That was my fold.

  • (1 - 3/3)
Loading...