unable to do DB Migration of defect dojo from 2.27.1 version to the latest 2.44.1

[jaideepwadhwa-eaton]

Hi,

We are trying to migrate from 2.27.1 version to 2.44.1. we ran the scripts of db migrations as well. After the upgrade some functionality is broken like metrics dashboard settings. When i look up the logs i can see this error
STATEMENT: SELECT "dojo_system_settings"."id", "dojo_system_settings"."enable_deduplication", "dojo_system_settings"."delete_duplicates", "dojo_system_settings"."max_dupes", "dojo_system_settings"."email_from", "dojo_system_settings"."enable_jira", "dojo_system_settings"."enable_jira_web_hook", "dojo_system_settings"."disable_jira_webhook_secret", "dojo_system_settings"."jira_webhook_secret", "dojo_system_settings"."jira_minimum_severity", "dojo_system_settings"."jira_labels", "dojo_system_settings"."add_vulnerability_id_to_jira_label", "dojo_system_settings"."enable_github", "dojo_system_settings"."enable_slack_notifications", "dojo_system_settings"."slack_channel", "dojo_system_settings"."slack_token", "dojo_system_settings"."slack_username", "dojo_system_settings"."enable_msteams_notifications", "dojo_system_settings"."msteams_url", "dojo_system_settings"."enable_mail_notifications", "dojo_system_settings"."mail_notifications_to", "dojo_system_settings"."enable_webhooks...
2025-03-11 17:21:44.140 GMT [99] ERROR: column dojo_system_settings.enable_webhooks_notifications does not exist at character 938.

Need help in how to run these migrations.

[valentijnscholten]

Can you provide information about your environment/deployment?

Deployment method (select with an X)

• Docker Compose
• Kubernetes
• GoDojo

Environment information

• Operating System: [e.g. Ubuntu 18.04]
• Docker Compose or Helm version (Output of docker compose version or helm version)
• DefectDojo version (see footer) or commit message: [use git show -s --format="[%ci] %h: %s [%d]"]

Logs
Use docker compose logs (or similar, depending on your deployment method) to get the logs and add the relevant sections here showing the error occurring (if applicable).

If you use the default docker compose deployment, the initializer container will run any unapplied migrations on startup every time you start Defect Dojo. Can you check/provide the logs of the first run of the initializer after upgrading?