Upgrade from 3.4.4 to 3.7.0 failed due to migrations applied in wrong order #9029

New Issue

adam · 2025-12-29T20:44:23+01:00

adam commented

2025-12-29 20:44:23 +01:00

Originally created by @skyhisi on GitHub (Jan 3, 2024).

Deployment Type

Self-hosted

NetBox Version

v3.7.0

Python Version

3.9

Steps to Reproduce

When upgrading from 3.4.4 to 3.7.0, the upgrade.sh script failed with the error:

  Applying ipam.0064_clear_search_cache...Skipping config initialization (database unavailable)
Traceback (most recent call last):
  File "/opt/netbox/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 89, in _execute
    return self.cursor.execute(sql, params)
  File "/opt/netbox/venv/lib/python3.9/site-packages/psycopg/cursor.py", line 737, in execute
    raise ex.with_traceback(None)
psycopg.errors.InFailedSqlTransaction: current transaction is aborted, commands ignored until end of transaction block

Postgres logged the following:

2024-01-03 19:15:27.450 UTC [67224] netbox@netbox ERROR:  relation "core_configrevision" does not exist at character 136
2024-01-03 19:15:27.450 UTC [67224] netbox@netbox STATEMENT:  SELECT "core_configrevision"."id", "core_configrevision"."created", "core_configrevision"."comment", "core_configrevision"."data" FROM "core_configrevision" ORDER BY "core_configrevision"."created" ASC LIMIT 1
2024-01-03 19:15:27.460 UTC [67224] netbox@netbox ERROR:  current transaction is aborted, commands ignored until end of transaction block

I was able to work around the issue by manually running the migration to move configrevision:

./venv/bin/python3 netbox/manage.py migrate extras 0102_move_configrevision

After this the upgrade was able to work as expected.

Expected Behavior

Database migrations should have worked

Observed Behavior

Database migrations were applied in wrong order

Originally created by @skyhisi on GitHub (Jan 3, 2024). ### Deployment Type Self-hosted ### NetBox Version v3.7.0 ### Python Version 3.9 ### Steps to Reproduce When upgrading from 3.4.4 to 3.7.0, the upgrade.sh script failed with the error: ``` Applying ipam.0064_clear_search_cache...Skipping config initialization (database unavailable) Traceback (most recent call last): File "/opt/netbox/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 89, in _execute return self.cursor.execute(sql, params) File "/opt/netbox/venv/lib/python3.9/site-packages/psycopg/cursor.py", line 737, in execute raise ex.with_traceback(None) psycopg.errors.InFailedSqlTransaction: current transaction is aborted, commands ignored until end of transaction block ``` Postgres logged the following: ``` 2024-01-03 19:15:27.450 UTC [67224] netbox@netbox ERROR: relation "core_configrevision" does not exist at character 136 2024-01-03 19:15:27.450 UTC [67224] netbox@netbox STATEMENT: SELECT "core_configrevision"."id", "core_configrevision"."created", "core_configrevision"."comment", "core_configrevision"."data" FROM "core_configrevision" ORDER BY "core_configrevision"."created" ASC LIMIT 1 2024-01-03 19:15:27.460 UTC [67224] netbox@netbox ERROR: current transaction is aborted, commands ignored until end of transaction block ``` I was able to work around the issue by manually running the migration to move configrevision: ``` ./venv/bin/python3 netbox/manage.py migrate extras 0102_move_configrevision ``` After this the upgrade was able to work as expected. ### Expected Behavior Database migrations should have worked ### Observed Behavior Database migrations were applied in wrong order

adam closed this issue

2025-12-29 20:44:23 +01:00

Sign in to join this conversation.

Branches Tags

main

update-changelog-comments-docs

feature-removal-issue-type

20911-dropdown

20239-plugin-menu-classes-mutable-state

21097-graphql-id-lookups

feature

fix_module_substitution

20923-dcim-templates

20044-elevation-stuck-lightmode

feature-ip-prefix-link

v4.5-beta1-release

20068-import-moduletype-attrs

20766-fix-german-translation-code-literals

20378-del-script

7604-filter-modifiers-v3

circuit-swap

12318-case-insensitive-uniqueness

20637-improve-device-q-filter

20660-script-load

19724-graphql

20614-update-ruff

14884-script

02496-max-page

19720-macaddress-interface-generic-relation

19408-circuit-terminations-export-templates

20203-openapi-check

fix-19669-api-image-download

7604-filter-modifiers

19275-fixes-interface-bulk-edit

fix-17794-get_field_value_return_list

11507-show-aggregate-and-rir-on-api

9583-add_column_specific_search_field_to_tables

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: starred/netbox#9029