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. Database migration issue Kubernetes

Database migration issue Kubernetes

Added by Seth Deegan 9 months ago

I have deployed openproject with the k8s helm chart. I have been upgrading openproject just by changing the openproject image version in the helm chart. At some point my database schema became wrong from upgrading from 12.3 to like 14 and I now get this error when going to the notifications page:

SELECT "notifications"."project\_id", COUNT(\*) FROM "notifica...  
              ^  
: PG::UndefinedColumn: ERROR:  column notifications.project\_id does not exist

Should I delete the notifications table (which I'm okay with doing since this installation is relatively new)? Will the seeder container recreate it? Should I manually add the project_id column? Should I do something else?

I also noticed when the seeder container ran it gave the warning

The current schema version is 20240820123011, but the one in the schema cache file is 20240808133947

This probably is indicative of my problem. What's the proper procedure of upgrading a Helm installation of OpenProject? I don't see anything in the docs.


Loading...