Upgrading from netbox 3.7.8 to 4.4.9 or 4.3.7

[remchuk]

NetBox Edition

NetBox Community

NetBox Version

v3.7.8

Python Version

3.11

Steps to Reproduce

We are using the image version of Netbox, so I tried upgrading from Netbox 3.5.6 to 3.7.8, so I uploaded the new image and from the Netbox-rqworker I run python3 manage.py migrate and it worked.

Later I tried doing the same procedure using 4.4.9 or 4.3.7.

Expected Behavior

The expected behavior is that The new 4.X.x version would work as 3.7.8 worked.

Observed Behavior

The script gave out the following error and killed the pod.

ALTER TABLE users_user_object_permissions RENAME CONSTRAINT users_objectpermission_users_user_id_16c0905d_fk_auth_user_id TO users_user_object_permissions_user_id_9d647aac_fk_users_user_id`; (params None)

psycopg.errors.UndefinedObject: constraint "users_user_object_permissions_user_id_9d647aac_fk_users_user_id" for table "users_user_object_permissions" does not exist

django.db.utils.ProgrammingError: constraint "users_user_object_permissions_user_id_9d647aac_fk_users_user_id" for table "users_user_object_permissions" does not exist

[arthanson]

@remchuk I wasn't getting the exact same error as you but was seeing a different migration error when jumping from v3.7.8 directly to v4.4.10 (which should work). As a workaround it looks like going to v4.3.7 first then going to v4.4.10 was working for me.

I was getting migration errors going directly from v3.7.8 to main, but first doing v4.3.7 doing a migrate then going to main was working.

psql netboxt < ~/dev/work/netbox-demo-data/sql/netbox-demo-v3.7.sql
git checkout main
python netbox/manage.py migrate

This failed

git checkout v4.3.7
python netbox/manage.py migrate
git checkout main
python netbox/manage.py migrate

worked.

[remchuk]

Going from

@remchuk I wasn't getting the exact same error as you but was seeing a different migration error when jumping from v3.7.8 directly to v4.4.10 (which should work). As a workaround it looks like going to v4.3.7 first then going to v4.4.10 was working for me.

I was getting migration errors going directly from v3.7.8 to main, but first doing v4.3.7 doing a migrate then going to main was working.

psql netboxt < ~/dev/work/netbox-demo-data/sql/netbox-demo-v3.7.sql
git checkout main
python netbox/manage.py migrate

This failed

git checkout v4.3.7
python netbox/manage.py migrate
git checkout main
python netbox/manage.py migrate

worked.

Going from 3.5.6 to 3.7.8 went smoothly, but no matter what version I'm going in 4.x.x I get the same error.

ALTER TABLE users_user_object_permissions RENAME CONSTRAINT users_objectpermission_users_user_id_16c0905d_fk_auth_user_id TO users_user_object_permissions_user_id_9d647aac_fk_users_user_id`; (params None)

psycopg.errors.UndefinedObject: constraint "users_user_object_permissions_user_id_9d647aac_fk_users_user_id" for table "users_user_object_permissions" does not exist

django.db.utils.ProgrammingError: constraint "users_user_object_permissions_user_id_9d647aac_fk_users_user_id" for table "users_user_object_permissions" does not exist

I tried: 4.0 & 4.3.7 & 4.4 & 4.4.9

Every time I ran manage.py it failed in the same place.