Upgrade from 3.3.7 to 4.4.2 fails;;;

[christophenouvel]

NetBox version

v3.4.7

Python version

3.9

Steps to Reproduce

1. Prepare migration following https://docs.netbox.dev/en/stable/installation/upgrading/ as usual.
   Today from 3.3.7 to 4.4.2

2. run upgrade.sh

Expected Behavior

upgrade.sh returns no error.

Observed Behavior

Migration error :

Running migrations:
Applying virtualization.0033_unique_constraints...Traceback (most recent call last):
File "/opt/netbox-3.4.2/netbox/manage.py", line 10, in
execute_from_command_line(sys.argv)
File "/opt/netbox-3.4.2/venv/lib/python3.9/site-packages/django/core/management/init.py", line 446, in execute_from_command_line
utility.execute()
File "/opt/netbox-3.4.2/venv/lib/python3.9/site-packages/django/core/management/init.py", line 440, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/opt/netbox-3.4.2/venv/lib/python3.9/site-packages/django/core/management/base.py", line 402, in run_from_argv
self.execute(*args, **cmd_options)
File "/opt/netbox-3.4.2/venv/lib/python3.9/site-packages/django/core/management/base.py", line 448, in execute
output = self.handle(*args, **options)
File "/opt/netbox-3.4.2/venv/lib/python3.9/site-packages/django/core/management/base.py", line 96, in wrapped
res = handle_func(*args, **kwargs)
File "/opt/netbox-3.4.2/venv/lib/python3.9/site-packages/django/core/management/commands/migrate.py", line 349, in handle
post_migrate_state = executor.migrate(
File "/opt/netbox-3.4.2/venv/lib/python3.9/site-packages/django/db/migrations/executor.py", line 135, in migrate
state = self._migrate_all_forwards(
File "/opt/netbox-3.4.2/venv/lib/python3.9/site-packages/django/db/migrations/executor.py", line 167, in _migrate_all_forwards
state = self.apply_migration(
File "/opt/netbox-3.4.2/venv/lib/python3.9/site-packages/django/db/migrations/executor.py", line 252, in apply_migration
state = migration.apply(state, schema_editor)
File "/opt/netbox-3.4.2/venv/lib/python3.9/site-packages/django/db/migrations/migration.py", line 130, in apply
operation.database_forwards(
File "/opt/netbox-3.4.2/venv/lib/python3.9/site-packages/django/db/migrations/operations/models.py", line 564, in database_forwards
alter_together(
File "/opt/netbox-3.4.2/venv/lib/python3.9/site-packages/django/db/backends/base/schema.py", line 533, in alter_unique_together
self._delete_composed_index(
File "/opt/netbox-3.4.2/venv/lib/python3.9/site-packages/django/db/backends/base/schema.py", line 589, in _delete_composed_index
raise ValueError(
ValueError: Found wrong number (0) of constraints for virtualization_vminterface(virtual_machine_id, name)

Note :

• upgrade from 3.3.7 to 3.3.10 works as expected.
• upgrade from 3.3.7 to 4.4.0 fails with same error.
• upgrade from 3.3.10 to 4.4.0 fails with same error.

[candlerb]

(I think you mean 3.4.2, not 4.4.2)

Applying virtualization.0033_unique_constraints...

Check the release notes:

WARNING: NetBox v3.4 requires PostgreSQL 11 or later.

What version of Postgres are you running?

Breaking Changes

Device and virtual machine names are no longer case-sensitive. Attempting to create e.g. "device1" and "DEVICE1" within the same site will raise a validation error.

Do you have two VMs with names like "foo" and "Foo"?

[christophenouvel]

Hi Candlerb,

Of course I meant 3.4.2!

Yes, I checked release notes before upgrading (not enough!), and upgrade from 3.3.7 to 3.3.10 went well.

Netbox is running on a genuine Debian 11 (bullseye), and PostgreSQL version is :
netbox=# select version();
version

PostgreSQL 13.8 (Debian 13.8-0+deb11u1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
(1 ligne)

And YES, I have at least 2 VMs with mixed case names beeing the same.

But I also have non unique tuples (virtual_machine_id, name) in virtualization_vminterface table!
For some reason, every NIC of Windows VM have the same name??

Trying to solve these problems and try to upgrade again...

Thank you very much,

Christophe.

[candlerb]

But I also have non unique tuples (virtual_machine_id, name) in virtualization_vminterface table!

That shouldn't be possible, due to postgres-level uniqueness constraints:

netbox3=# \d virtualization_vminterface;
...
Indexes:
...
    "virtualization_vminterface_unique_virtual_machine_name" UNIQUE CONSTRAINT, btree (virtual_machine_id, name)

How many do you have? Try:

select virtual_machine_id, name, count(*) from virtualization_vminterface
    group by virtual_machine_id, name having count(*) > 1;

[christophenouvel]

Well, I've not exactely the same :

netbox=# \d virtualization_vminterface;
Table « public.virtualization_vminterface »
Colonne | Type | Collationnement | NULL-able | Par défaut
--------------------+--------------------------+-----------------+-----------+--------------------------------------------------------
id | bigint | | not null | nextval('virtualization_vminterface_id_seq'::regclass)
name | character varying(64) | | not null |
_name | character varying(100) | | not null |
enabled | boolean | | not null |
mac_address | macaddr | | |
mtu | integer | | |
mode | character varying(50) | | not null |
description | character varying(200) | | not null |
untagged_vlan_id | bigint | | |
virtual_machine_id | bigint | | not null |
created | timestamp with time zone | | |
last_updated | timestamp with time zone | | |
custom_field_data | jsonb | | not null |
parent_id | bigint | | |
bridge_id | bigint | | |
vrf_id | bigint | | |
Index :
"virtualization_vminterface_pkey" PRIMARY KEY, btree (id)
"virtualization_vminterface_bridge_id_7462b91e" btree (bridge_id)
"virtualization_vminterface_parent_id_f86958e1" btree (parent_id)
"virtualization_vminterface_untagged_vlan_id_aea4fc69" btree (untagged_vlan_id)
"virtualization_vminterface_virtual_machine_id_e9f89829" btree (virtual_machine_id)
"virtualization_vminterface_vrf_id_4b570a8c" btree (vrf_id)
Contraintes de vérification :
"virtualization_vminterface_mtu_check" CHECK (mtu >= 0)
Contraintes de clés étrangères :
"virtualization_vmint_bridge_id_7462b91e_fk_virtualiz" FOREIGN KEY (bridge_id) REFERENCES virtualization_vminterface(id) DEFERRABLE INITIALLY DEFERRED
"virtualization_vmint_parent_id_f86958e1_fk_virtualiz" FOREIGN KEY (parent_id) REFERENCES virtualization_vminterface(id) DEFERRABLE INITIALLY DEFERRED
"virtualization_vminterface_untagged_vlan_id_aea4fc69_fk" FOREIGN KEY (untagged_vlan_id) REFERENCES ipam_vlan(id) DEFERRABLE INITIALLY DEFERRED
"virtualization_vminterface_virtual_machine_id_e9f89829_fk" FOREIGN KEY (virtual_machine_id) REFERENCES virtualization_virtualmachine(id) DEFERRABLE INITIALLY DEFERRED
"virtualization_vminterface_vrf_id_4b570a8c_fk_ipam_vrf_id" FOREIGN KEY (vrf_id) REFERENCES ipam_vrf(id) DEFERRABLE INITIALLY DEFERRED
Référencé par :
TABLE "virtualization_vminterface" CONSTRAINT "virtualization_vmint_bridge_id_7462b91e_fk_virtualiz" FOREIGN KEY (bridge_id) REFERENCES virtualization_vminterface(id) DEFERRABLE INITIALLY DEFERRED
TABLE "virtualization_vminterface" CONSTRAINT "virtualization_vmint_parent_id_f86958e1_fk_virtualiz" FOREIGN KEY (parent_id) REFERENCES virtualization_vminterface(id) DEFERRABLE INITIALLY DEFERRED

But :
netbox=# select virtual_machine_id, name, count() from virtualization_vminterface
group by virtual_machine_id, name having count() > 1;
virtual_machine_id | name | count
--------------------+------+-------
(0 ligne)

netbox=#

Before that, I manually removed all virtual machine names like "Device1" and "device1".
And I also manually renames NIC cards for a given VM, so (virtual_machine_id, name) are unique now.

There is still this error message in upgrade.sh :
ValueError: Found wrong number (0) of constraints for virtualization_vminterface(virtual_machine_id, name)

Christophe.

[candlerb]

ValueError: Found wrong number (0) of constraints for virtualization_vminterface(virtual_machine_id, name)

OK, I guess this may actually be complaining that the constraint itself is missing then.

Here's mine, so you can patch up your table if needed.

                                           Table "public.virtualization_vminterface"
       Column       |           Type           | Collation | Nullable |                        Default
--------------------+--------------------------+-----------+----------+--------------------------------------------------------
 id                 | bigint                   |           | not null | nextval('virtualization_vminterface_id_seq'::regclass)
 name               | character varying(64)    |           | not null |
 _name              | character varying(100)   |           | not null |
 enabled            | boolean                  |           | not null |
 mac_address        | macaddr                  |           |          |
 mtu                | integer                  |           |          |
 mode               | character varying(50)    |           | not null |
 description        | character varying(200)   |           | not null |
 untagged_vlan_id   | bigint                   |           |          |
 virtual_machine_id | bigint                   |           | not null |
 created            | timestamp with time zone |           |          |
 last_updated       | timestamp with time zone |           |          |
 custom_field_data  | jsonb                    |           | not null |
 parent_id          | bigint                   |           |          |
 bridge_id          | bigint                   |           |          |
 vrf_id             | bigint                   |           |          |
Indexes:
    "virtualization_vminterface_pkey" PRIMARY KEY, btree (id)
    "virtualization_vminterface_unique_virtual_machine_name" UNIQUE CONSTRAINT, btree (virtual_machine_id, name)
    "virtualization_vminterface_bridge_id_7462b91e" btree (bridge_id)
    "virtualization_vminterface_parent_id_f86958e1" btree (parent_id)
    "virtualization_vminterface_untagged_vlan_id_aea4fc69" btree (untagged_vlan_id)
    "virtualization_vminterface_virtual_machine_id_e9f89829" btree (virtual_machine_id)
    "virtualization_vminterface_vrf_id_4b570a8c" btree (vrf_id)
Check constraints:
    "virtualization_vminterface_mtu_check" CHECK (mtu >= 0)
Foreign-key constraints:
    "virtualization_vmint_bridge_id_7462b91e_fk_virtualiz" FOREIGN KEY (bridge_id) REFERENCES virtualization_vminterface(id) DEFERRABLE INITIALLY DEFERRED
    "virtualization_vmint_parent_id_f86958e1_fk_virtualiz" FOREIGN KEY (parent_id) REFERENCES virtualization_vminterface(id) DEFERRABLE INITIALLY DEFERRED
    "virtualization_vminterface_untagged_vlan_id_aea4fc69_fk" FOREIGN KEY (untagged_vlan_id) REFERENCES ipam_vlan(id) DEFERRABLE INITIALLY DEFERRED
    "virtualization_vminterface_virtual_machine_id_e9f89829_fk" FOREIGN KEY (virtual_machine_id) REFERENCES virtualization_virtualmachine(id) DEFERRABLE INITIALLY DEFERRED
    "virtualization_vminterface_vrf_id_4b570a8c_fk_ipam_vrf_id" FOREIGN KEY (vrf_id) REFERENCES ipam_vrf(id) DEFERRABLE INITIALLY DEFERRED
Referenced by:
    TABLE "virtualization_vminterface" CONSTRAINT "virtualization_vmint_bridge_id_7462b91e_fk_virtualiz" FOREIGN KEY (bridge_id) REFERENCES virtualization_vminterface(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "virtualization_vminterface" CONSTRAINT "virtualization_vmint_parent_id_f86958e1_fk_virtualiz" FOREIGN KEY (parent_id) REFERENCES virtualization_vminterface(id) DEFERRABLE INITIALLY DEFERRED

Or the full dump (note my database and user are "netbox3" not "netbox"):

root@postgres:~# sudo -u postgres pg_dump -st virtualization_vminterface netbox3
--
-- PostgreSQL database dump
--

-- Dumped from database version 12.12 (Ubuntu 12.12-0ubuntu0.20.04.1)
-- Dumped by pg_dump version 12.12 (Ubuntu 12.12-0ubuntu0.20.04.1)

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: virtualization_vminterface; Type: TABLE; Schema: public; Owner: netbox3
--

CREATE TABLE public.virtualization_vminterface (
    id bigint NOT NULL,
    name character varying(64) NOT NULL,
    _name character varying(100) NOT NULL,
    enabled boolean NOT NULL,
    mac_address macaddr,
    mtu integer,
    mode character varying(50) NOT NULL,
    description character varying(200) NOT NULL,
    untagged_vlan_id bigint,
    virtual_machine_id bigint NOT NULL,
    created timestamp with time zone,
    last_updated timestamp with time zone,
    custom_field_data jsonb NOT NULL,
    parent_id bigint,
    bridge_id bigint,
    vrf_id bigint,
    CONSTRAINT virtualization_vminterface_mtu_check CHECK ((mtu >= 0))
);


ALTER TABLE public.virtualization_vminterface OWNER TO netbox3;

--
-- Name: virtualization_vminterface_id_seq; Type: SEQUENCE; Schema: public; Owner: netbox3
--

CREATE SEQUENCE public.virtualization_vminterface_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.virtualization_vminterface_id_seq OWNER TO netbox3;

--
-- Name: virtualization_vminterface_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: netbox3
--

ALTER SEQUENCE public.virtualization_vminterface_id_seq OWNED BY public.virtualization_vminterface.id;


--
-- Name: virtualization_vminterface id; Type: DEFAULT; Schema: public; Owner: netbox3
--

ALTER TABLE ONLY public.virtualization_vminterface ALTER COLUMN id SET DEFAULT nextval('public.virtualization_vminterface_id_seq'::regclass);


--
-- Name: virtualization_vminterface virtualization_vminterface_pkey; Type: CONSTRAINT; Schema: public; Owner: netbox3
--

ALTER TABLE ONLY public.virtualization_vminterface
    ADD CONSTRAINT virtualization_vminterface_pkey PRIMARY KEY (id);


--
-- Name: virtualization_vminterface virtualization_vminterface_unique_virtual_machine_name; Type: CONSTRAINT; Schema: public; Owner: netbox3
--

ALTER TABLE ONLY public.virtualization_vminterface
    ADD CONSTRAINT virtualization_vminterface_unique_virtual_machine_name UNIQUE (virtual_machine_id, name);


--
-- Name: virtualization_vminterface_bridge_id_7462b91e; Type: INDEX; Schema: public; Owner: netbox3
--

CREATE INDEX virtualization_vminterface_bridge_id_7462b91e ON public.virtualization_vminterface USING btree (bridge_id);


--
-- Name: virtualization_vminterface_parent_id_f86958e1; Type: INDEX; Schema: public; Owner: netbox3
--

CREATE INDEX virtualization_vminterface_parent_id_f86958e1 ON public.virtualization_vminterface USING btree (parent_id);


--
-- Name: virtualization_vminterface_untagged_vlan_id_aea4fc69; Type: INDEX; Schema: public; Owner: netbox3
--

CREATE INDEX virtualization_vminterface_untagged_vlan_id_aea4fc69 ON public.virtualization_vminterface USING btree (untagged_vlan_id);


--
-- Name: virtualization_vminterface_virtual_machine_id_e9f89829; Type: INDEX; Schema: public; Owner: netbox3
--

CREATE INDEX virtualization_vminterface_virtual_machine_id_e9f89829 ON public.virtualization_vminterface USING btree (virtual_machine_id);


--
-- Name: virtualization_vminterface_vrf_id_4b570a8c; Type: INDEX; Schema: public; Owner: netbox3
--

CREATE INDEX virtualization_vminterface_vrf_id_4b570a8c ON public.virtualization_vminterface USING btree (vrf_id);


--
-- Name: virtualization_vminterface virtualization_vmint_bridge_id_7462b91e_fk_virtualiz; Type: FK CONSTRAINT; Schema: public; Owner: netbox3
--

ALTER TABLE ONLY public.virtualization_vminterface
    ADD CONSTRAINT virtualization_vmint_bridge_id_7462b91e_fk_virtualiz FOREIGN KEY (bridge_id) REFERENCES public.virtualization_vminterface(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: virtualization_vminterface virtualization_vmint_parent_id_f86958e1_fk_virtualiz; Type: FK CONSTRAINT; Schema: public; Owner: netbox3
--

ALTER TABLE ONLY public.virtualization_vminterface
    ADD CONSTRAINT virtualization_vmint_parent_id_f86958e1_fk_virtualiz FOREIGN KEY (parent_id) REFERENCES public.virtualization_vminterface(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: virtualization_vminterface virtualization_vminterface_untagged_vlan_id_aea4fc69_fk; Type: FK CONSTRAINT; Schema: public; Owner: netbox3
--

ALTER TABLE ONLY public.virtualization_vminterface
    ADD CONSTRAINT virtualization_vminterface_untagged_vlan_id_aea4fc69_fk FOREIGN KEY (untagged_vlan_id) REFERENCES public.ipam_vlan(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: virtualization_vminterface virtualization_vminterface_virtual_machine_id_e9f89829_fk; Type: FK CONSTRAINT; Schema: public; Owner: netbox3
--

ALTER TABLE ONLY public.virtualization_vminterface
    ADD CONSTRAINT virtualization_vminterface_virtual_machine_id_e9f89829_fk FOREIGN KEY (virtual_machine_id) REFERENCES public.virtualization_virtualmachine(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: virtualization_vminterface virtualization_vminterface_vrf_id_4b570a8c_fk_ipam_vrf_id; Type: FK CONSTRAINT; Schema: public; Owner: netbox3
--

ALTER TABLE ONLY public.virtualization_vminterface
    ADD CONSTRAINT virtualization_vminterface_vrf_id_4b570a8c_fk_ipam_vrf_id FOREIGN KEY (vrf_id) REFERENCES public.ipam_vrf(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: TABLE virtualization_vminterface; Type: ACL; Schema: public; Owner: netbox3
--

GRANT SELECT ON TABLE public.virtualization_vminterface TO dhcp;


--
-- PostgreSQL database dump complete
--

[candlerb]

I note that the error comes from venv/lib/python3.8/site-packages/django/db/backends/base/schema.py:

    def _delete_composed_index(self, model, fields, constraint_kwargs, sql):
...
        if len(constraint_names) != 1:
            raise ValueError(
                "Found wrong number (%s) of constraints for %s(%s)"
                % (
                    len(constraint_names),
                    model._meta.db_table,
                    ", ".join(columns),
                )
            )

So it seems what's happening is that it's trying to find (and delete) an existing constraint, not finding it, and then barfing. i.e. it's a non-idempotent operation - perhaps got deleted by a previous attempt.

[christophenouvel]

Yes, this one was missing :

`ALTER TABLE ONLY public.virtualization_vminterface
ADD CONSTRAINT virtualization_vminterface_unique_virtual_machine_name UNIQUE (virtual_machine_id, name);

`

All is Ok now!

Thank you very much,

Christophe.

[TnTBass]

I have a similar but different issue. I'm getting an error upgrading from v3.3.10 to v3.4.0:

ValueError: Found wrong number (0) of constraints for dcim_device(virtual_chassis_id, vc_position)

Any ideas?

netbox=# \d dcim_device
                                           Table "public.dcim_device"
       Column       |           Type           | Collation | Nullable |                 Default
--------------------+--------------------------+-----------+----------+-----------------------------------------
 id                 | bigint                   |           | not null | nextval('dcim_device_id_seq'::regclass)
 created            | timestamp with time zone |           |          |
 last_updated       | timestamp with time zone |           |          |
 name               | character varying(64)    |           |          |
 serial             | character varying(50)    |           | not null |
 position           | numeric(4,1)             |           |          |
 face               | character varying(50)    |           | not null |
 status             | character varying(50)    |           | not null |
 comments           | text                     |           | not null |
 device_role_id     | bigint                   |           | not null |
 device_type_id     | bigint                   |           | not null |
 platform_id        | bigint                   |           |          |
 rack_id            | bigint                   |           |          |
 primary_ip4_id     | bigint                   |           |          |
 primary_ip6_id     | bigint                   |           |          |
 tenant_id          | bigint                   |           |          |
 asset_tag          | character varying(50)    |           |          |
 site_id            | bigint                   |           | not null |
 cluster_id         | bigint                   |           |          |
 virtual_chassis_id | bigint                   |           |          |
 vc_position        | smallint                 |           |          |
 vc_priority        | smallint                 |           |          |
 local_context_data | jsonb                    |           |          |
 _name              | character varying(100)   |           |          |
 custom_field_data  | jsonb                    |           | not null |
 location_id        | bigint                   |           |          |
 airflow            | character varying(50)    |           | not null |
Indexes:
    "dcim_device_pkey" PRIMARY KEY, btree (id)
    "dcim_device_asset_tag_key" UNIQUE CONSTRAINT, btree (asset_tag)
    "dcim_device_primary_ip4_id_key" UNIQUE CONSTRAINT, btree (primary_ip4_id)
    "dcim_device_primary_ip6_id_key" UNIQUE CONSTRAINT, btree (primary_ip6_id)
    "dcim_device_rack_id_43208a79_uniq" UNIQUE CONSTRAINT, btree (rack_id, "position", face)
    "dcim_device_site_id_tenant_id_name_93f4f962_uniq" UNIQUE CONSTRAINT, btree (site_id, tenant_id, name)
    "dcim_device_136ca3fc" btree (device_role_id)
    "dcim_device_21556361" btree (rack_id)
    "dcim_device_38543614" btree (tenant_id)
    "dcim_device_asset_tag_8dac1079_like" btree (asset_tag varchar_pattern_ops)
    "dcim_device_bddcf45f" btree (device_type_id)
    "dcim_device_cb857215" btree (platform_id)
    "dcim_device_cluster_id_cf852f78" btree (cluster_id)
    "dcim_device_location_id_11a7bedb" btree (location_id)
    "dcim_device_site_id_ff897cf6" btree (site_id)
    "dcim_device_virtual_chassis_id_aed51693" btree (virtual_chassis_id)
Check constraints:
    "dcim_device_vc_position_check" CHECK (vc_position >= 0)
    "dcim_device_vc_priority_check" CHECK (vc_priority >= 0)
Foreign-key constraints:
    "dcim_device_cluster_id_cf852f78_fk" FOREIGN KEY (cluster_id) REFERENCES virtualization_cluster(id) DEFERRABLE INITIALLY DEFERRED
    "dcim_device_device_role_id_682e8188_fk" FOREIGN KEY (device_role_id) REFERENCES dcim_devicerole(id) DEFERRABLE INITIALLY DEFERRED
    "dcim_device_device_type_id_d61b4086_fk" FOREIGN KEY (device_type_id) REFERENCES dcim_devicetype(id) DEFERRABLE INITIALLY DEFERRED
    "dcim_device_location_id_11a7bedb_fk_dcim_location_id" FOREIGN KEY (location_id) REFERENCES dcim_location(id) DEFERRABLE INITIALLY DEFERRED
    "dcim_device_platform_id_468138f1_fk" FOREIGN KEY (platform_id) REFERENCES dcim_platform(id) DEFERRABLE INITIALLY DEFERRED
    "dcim_device_primary_ip4_id_2ccd943a_fk" FOREIGN KEY (primary_ip4_id) REFERENCES ipam_ipaddress(id) DEFERRABLE INITIALLY DEFERRED
    "dcim_device_primary_ip6_id_d180fe91_fk" FOREIGN KEY (primary_ip6_id) REFERENCES ipam_ipaddress(id) DEFERRABLE INITIALLY DEFERRED
    "dcim_device_rack_id_23bde71f_fk" FOREIGN KEY (rack_id) REFERENCES dcim_rack(id) DEFERRABLE INITIALLY DEFERRED
    "dcim_device_site_id_ff897cf6_fk" FOREIGN KEY (site_id) REFERENCES dcim_site(id) DEFERRABLE INITIALLY DEFERRED
    "dcim_device_tenant_id_dcea7969_fk" FOREIGN KEY (tenant_id) REFERENCES tenancy_tenant(id) DEFERRABLE INITIALLY DEFERRED
    "dcim_device_virtual_chassis_id_aed51693_fk" FOREIGN KEY (virtual_chassis_id) REFERENCES dcim_virtualchassis(id) DEFERRABLE INITIALLY DEFERRED
Referenced by:
    TABLE "dcim_cabletermination" CONSTRAINT "dcim_cabletermination__device_id_f5884934_fk_dcim_device_id" FOREIGN KEY (_device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "dcim_consoleport" CONSTRAINT "dcim_consoleport_device_id_f2d90d3c_fk" FOREIGN KEY (device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "dcim_consoleserverport" CONSTRAINT "dcim_consoleserverport_device_id_d9866581_fk" FOREIGN KEY (device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "dcim_devicebay" CONSTRAINT "dcim_devicebay_device_id_0c8a1218_fk" FOREIGN KEY (device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "dcim_devicebay" CONSTRAINT "dcim_devicebay_installed_device_id_04618112_fk" FOREIGN KEY (installed_device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "dcim_frontport" CONSTRAINT "dcim_frontport_device_id_950557b5_fk" FOREIGN KEY (device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "dcim_interface" CONSTRAINT "dcim_interface_device_id_359c6115_fk" FOREIGN KEY (device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "dcim_inventoryitem" CONSTRAINT "dcim_inventoryitem_device_id_033d83f8_fk" FOREIGN KEY (device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "dcim_module" CONSTRAINT "dcim_module_device_id_53cfd5be_fk_dcim_device_id" FOREIGN KEY (device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "dcim_modulebay" CONSTRAINT "dcim_modulebay_device_id_3526abc2_fk_dcim_device_id" FOREIGN KEY (device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "dcim_poweroutlet" CONSTRAINT "dcim_poweroutlet_device_id_286351d7_fk" FOREIGN KEY (device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "dcim_powerport" CONSTRAINT "dcim_powerport_device_id_ef7185ae_fk" FOREIGN KEY (device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "dcim_rearport" CONSTRAINT "dcim_rearport_device_id_0bdfe9c0_fk" FOREIGN KEY (device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "dcim_vcmembership" CONSTRAINT "dcim_vcmembership_device_id_7e4d276c_fk_dcim_device_id" FOREIGN KEY (device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "dcim_virtualchassis" CONSTRAINT "dcim_virtualchassis_master_id_ab54cfc6_fk" FOREIGN KEY (master_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "ipam_service" CONSTRAINT "ipam_service_device_id_b4d2bb9c_fk" FOREIGN KEY (device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "virtualization_virtualmachine" CONSTRAINT "virtualization_virtu_device_id_5a49ed18_fk_dcim_devi" FOREIGN KEY (device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "wireless_wirelesslink" CONSTRAINT "wireless_wirelesslin__interface_a_device__6c8e042e_fk_dcim_devi" FOREIGN KEY (_interface_a_device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "wireless_wirelesslink" CONSTRAINT "wireless_wirelesslin__interface_b_device__43d5101a_fk_dcim_devi" FOREIGN KEY (_interface_b_device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED

[candlerb]

Sounds like same problem, different table.

From here:

netbox3=# \d dcim_device
                                           Table "public.dcim_device"
       Column       |           Type           | Collation | Nullable |                 Default
--------------------+--------------------------+-----------+----------+-----------------------------------------
 id                 | bigint                   |           | not null | nextval('dcim_device_id_seq'::regclass)
 created            | timestamp with time zone |           |          |
 last_updated       | timestamp with time zone |           |          |
 name               | character varying(64)    |           |          |
 serial             | character varying(50)    |           | not null |
 position           | numeric(4,1)             |           |          |
 face               | character varying(50)    |           | not null |
 status             | character varying(50)    |           | not null |
 comments           | text                     |           | not null |
 device_role_id     | bigint                   |           | not null |
 device_type_id     | bigint                   |           | not null |
 platform_id        | bigint                   |           |          |
 rack_id            | bigint                   |           |          |
 primary_ip4_id     | bigint                   |           |          |
 primary_ip6_id     | bigint                   |           |          |
 tenant_id          | bigint                   |           |          |
 asset_tag          | character varying(50)    |           |          |
 site_id            | bigint                   |           | not null |
 cluster_id         | bigint                   |           |          |
 virtual_chassis_id | bigint                   |           |          |
 vc_position        | smallint                 |           |          |
 vc_priority        | smallint                 |           |          |
 local_context_data | jsonb                    |           |          |
 _name              | character varying(100)   |           |          |
 custom_field_data  | jsonb                    |           | not null |
 location_id        | bigint                   |           |          |
 airflow            | character varying(50)    |           | not null |
 description        | character varying(200)   |           | not null |
Indexes:
    "dcim_device_pkey" PRIMARY KEY, btree (id)
    "dcim_device_asset_tag_key" UNIQUE CONSTRAINT, btree (asset_tag)
    "dcim_device_primary_ip4_id_key" UNIQUE CONSTRAINT, btree (primary_ip4_id)
    "dcim_device_primary_ip6_id_key" UNIQUE CONSTRAINT, btree (primary_ip6_id)
    "dcim_device_unique_name_site" UNIQUE, btree (lower(name::text), site_id) WHERE tenant_id IS NULL
    "dcim_device_unique_name_site_tenant" UNIQUE, btree (lower(name::text), site_id, tenant_id)
    "dcim_device_unique_rack_position_face" UNIQUE CONSTRAINT, btree (rack_id, "position", face)
    "dcim_device_unique_virtual_chassis_vc_position" UNIQUE CONSTRAINT, btree (virtual_chassis_id, vc_position)
    "dcim_device_asset_tag_8dac1079_like" btree (asset_tag varchar_pattern_ops)
    "dcim_device_cluster_id_cf852f78" btree (cluster_id)
    "dcim_device_device_role_id_682e8188" btree (device_role_id)
    "dcim_device_device_type_id_d61b4086" btree (device_type_id)
    "dcim_device_location_id_11a7bedb" btree (location_id)
    "dcim_device_platform_id_468138f1" btree (platform_id)
    "dcim_device_rack_id_23bde71f" btree (rack_id)
    "dcim_device_site_id_ff897cf6" btree (site_id)
    "dcim_device_tenant_id_dcea7969" btree (tenant_id)
    "dcim_device_virtual_chassis_id_aed51693" btree (virtual_chassis_id)
Check constraints:
    "dcim_device_vc_position_check" CHECK (vc_position >= 0)
    "dcim_device_vc_priority_check" CHECK (vc_priority >= 0)
Foreign-key constraints:
    "dcim_device_cluster_id_cf852f78_fk" FOREIGN KEY (cluster_id) REFERENCES virtualization_cluster(id) DEFERRABLE INITIALLY DEFERRED
    "dcim_device_device_role_id_682e8188_fk" FOREIGN KEY (device_role_id) REFERENCES dcim_devicerole(id) DEFERRABLE INITIALLY DEFERRED
    "dcim_device_device_type_id_d61b4086_fk" FOREIGN KEY (device_type_id) REFERENCES dcim_devicetype(id) DEFERRABLE INITIALLY DEFERRED
    "dcim_device_location_id_11a7bedb_fk_dcim_location_id" FOREIGN KEY (location_id) REFERENCES dcim_location(id) DEFERRABLE INITIALLY DEFERRED
    "dcim_device_platform_id_468138f1_fk" FOREIGN KEY (platform_id) REFERENCES dcim_platform(id) DEFERRABLE INITIALLY DEFERRED
    "dcim_device_primary_ip4_id_2ccd943a_fk" FOREIGN KEY (primary_ip4_id) REFERENCES ipam_ipaddress(id) DEFERRABLE INITIALLY DEFERRED
    "dcim_device_primary_ip6_id_d180fe91_fk" FOREIGN KEY (primary_ip6_id) REFERENCES ipam_ipaddress(id) DEFERRABLE INITIALLY DEFERRED
    "dcim_device_rack_id_23bde71f_fk" FOREIGN KEY (rack_id) REFERENCES dcim_rack(id) DEFERRABLE INITIALLY DEFERRED
    "dcim_device_site_id_ff897cf6_fk" FOREIGN KEY (site_id) REFERENCES dcim_site(id) DEFERRABLE INITIALLY DEFERRED
    "dcim_device_tenant_id_dcea7969_fk" FOREIGN KEY (tenant_id) REFERENCES tenancy_tenant(id) DEFERRABLE INITIALLY DEFERRED
    "dcim_device_virtual_chassis_id_aed51693_fk" FOREIGN KEY (virtual_chassis_id) REFERENCES dcim_virtualchassis(id) DEFERRABLE INITIALLY DEFERRED
Referenced by:
    TABLE "dcim_cabletermination" CONSTRAINT "dcim_cabletermination__device_id_f5884934_fk_dcim_device_id" FOREIGN KEY (_device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "dcim_consoleport" CONSTRAINT "dcim_consoleport_device_id_f2d90d3c_fk" FOREIGN KEY (device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "dcim_consoleserverport" CONSTRAINT "dcim_consoleserverport_device_id_d9866581_fk" FOREIGN KEY (device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "dcim_devicebay" CONSTRAINT "dcim_devicebay_device_id_0c8a1218_fk" FOREIGN KEY (device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "dcim_devicebay" CONSTRAINT "dcim_devicebay_installed_device_id_04618112_fk" FOREIGN KEY (installed_device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "dcim_frontport" CONSTRAINT "dcim_frontport_device_id_950557b5_fk" FOREIGN KEY (device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "dcim_interface" CONSTRAINT "dcim_interface_device_id_359c6115_fk" FOREIGN KEY (device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "dcim_inventoryitem" CONSTRAINT "dcim_inventoryitem_device_id_033d83f8_fk" FOREIGN KEY (device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "dcim_module" CONSTRAINT "dcim_module_device_id_53cfd5be_fk_dcim_device_id" FOREIGN KEY (device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "dcim_modulebay" CONSTRAINT "dcim_modulebay_device_id_3526abc2_fk_dcim_device_id" FOREIGN KEY (device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "dcim_poweroutlet" CONSTRAINT "dcim_poweroutlet_device_id_286351d7_fk" FOREIGN KEY (device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "dcim_powerport" CONSTRAINT "dcim_powerport_device_id_ef7185ae_fk" FOREIGN KEY (device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "dcim_rearport" CONSTRAINT "dcim_rearport_device_id_0bdfe9c0_fk" FOREIGN KEY (device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "dcim_virtualchassis" CONSTRAINT "dcim_virtualchassis_master_id_ab54cfc6_fk" FOREIGN KEY (master_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "dcim_virtualdevicecontext" CONSTRAINT "dcim_virtualdevicecontext_device_id_4f39274b_fk_dcim_device_id" FOREIGN KEY (device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "ipam_service" CONSTRAINT "ipam_service_device_id_b4d2bb9c_fk" FOREIGN KEY (device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "virtualization_virtualmachine" CONSTRAINT "virtualization_virtu_device_id_5a49ed18_fk_dcim_devi" FOREIGN KEY (device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "wireless_wirelesslink" CONSTRAINT "wireless_wirelesslin__interface_a_device__6c8e042e_fk_dcim_devi" FOREIGN KEY (_interface_a_device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "wireless_wirelesslink" CONSTRAINT "wireless_wirelesslin__interface_b_device__43d5101a_fk_dcim_devi" FOREIGN KEY (_interface_b_device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED

root@postgres:~# sudo -u postgres pg_dump -st dcim_interface netbox3
--
-- PostgreSQL database dump
--

-- Dumped from database version 12.12 (Ubuntu 12.12-0ubuntu0.20.04.1)
-- Dumped by pg_dump version 12.12 (Ubuntu 12.12-0ubuntu0.20.04.1)

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: dcim_interface; Type: TABLE; Schema: public; Owner: netbox3
--

CREATE TABLE public.dcim_interface (
    id bigint NOT NULL,
    name character varying(64) NOT NULL,
    type character varying(50) NOT NULL,
    mgmt_only boolean NOT NULL,
    description character varying(200) NOT NULL,
    device_id bigint NOT NULL,
    mac_address macaddr,
    lag_id bigint,
    enabled boolean NOT NULL,
    mtu integer,
    mode character varying(50) NOT NULL,
    untagged_vlan_id bigint,
    cable_id bigint,
    _name character varying(100) NOT NULL,
    label character varying(64) NOT NULL,
    _path_id bigint,
    created timestamp with time zone,
    custom_field_data jsonb NOT NULL,
    last_updated timestamp with time zone,
    mark_connected boolean NOT NULL,
    parent_id bigint,
    wwn macaddr8,
    bridge_id bigint,
    rf_role character varying(30) NOT NULL,
    rf_channel character varying(50) NOT NULL,
    rf_channel_frequency numeric(7,2),
    rf_channel_width numeric(7,3),
    tx_power smallint,
    wireless_link_id bigint,
    module_id bigint,
    vrf_id bigint,
    duplex character varying(50),
    speed integer,
    poe_mode character varying(50) NOT NULL,
    poe_type character varying(50) NOT NULL,
    cable_end character varying(1) NOT NULL,
    CONSTRAINT dcim_interface_mtu_check CHECK ((mtu >= 0)),
    CONSTRAINT dcim_interface_speed_check CHECK ((speed >= 0)),
    CONSTRAINT dcim_interface_tx_power_check CHECK ((tx_power >= 0))
);


ALTER TABLE public.dcim_interface OWNER TO netbox3;

--
-- Name: dcim_interface_id_seq; Type: SEQUENCE; Schema: public; Owner: netbox3
--

CREATE SEQUENCE public.dcim_interface_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.dcim_interface_id_seq OWNER TO netbox3;

--
-- Name: dcim_interface_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: netbox3
--

ALTER SEQUENCE public.dcim_interface_id_seq OWNED BY public.dcim_interface.id;


--
-- Name: dcim_interface id; Type: DEFAULT; Schema: public; Owner: netbox3
--

ALTER TABLE ONLY public.dcim_interface ALTER COLUMN id SET DEFAULT nextval('public.dcim_interface_id_seq'::regclass);


--
-- Name: dcim_interface dcim_interface_pkey; Type: CONSTRAINT; Schema: public; Owner: netbox3
--

ALTER TABLE ONLY public.dcim_interface
    ADD CONSTRAINT dcim_interface_pkey PRIMARY KEY (id);


--
-- Name: dcim_interface dcim_interface_unique_device_name; Type: CONSTRAINT; Schema: public; Owner: netbox3
--

ALTER TABLE ONLY public.dcim_interface
    ADD CONSTRAINT dcim_interface_unique_device_name UNIQUE (device_id, name);


--
-- Name: dcim_interface__path_id_f8f4f7f0; Type: INDEX; Schema: public; Owner: netbox3
--

CREATE INDEX dcim_interface__path_id_f8f4f7f0 ON public.dcim_interface USING btree (_path_id);


--
-- Name: dcim_interface_bridge_id_f2a8df85; Type: INDEX; Schema: public; Owner: netbox3
--

CREATE INDEX dcim_interface_bridge_id_f2a8df85 ON public.dcim_interface USING btree (bridge_id);


--
-- Name: dcim_interface_cable_id_1b264edb; Type: INDEX; Schema: public; Owner: netbox3
--

CREATE INDEX dcim_interface_cable_id_1b264edb ON public.dcim_interface USING btree (cable_id);


--
-- Name: dcim_interface_device_id_359c6115; Type: INDEX; Schema: public; Owner: netbox3
--

CREATE INDEX dcim_interface_device_id_359c6115 ON public.dcim_interface USING btree (device_id);


--
-- Name: dcim_interface_lag_id_ea1a1d12; Type: INDEX; Schema: public; Owner: netbox3
--

CREATE INDEX dcim_interface_lag_id_ea1a1d12 ON public.dcim_interface USING btree (lag_id);


--
-- Name: dcim_interface_module_id_05ca2da5; Type: INDEX; Schema: public; Owner: netbox3
--

CREATE INDEX dcim_interface_module_id_05ca2da5 ON public.dcim_interface USING btree (module_id);


--
-- Name: dcim_interface_parent_id_3e2b159b; Type: INDEX; Schema: public; Owner: netbox3
--

CREATE INDEX dcim_interface_parent_id_3e2b159b ON public.dcim_interface USING btree (parent_id);


--
-- Name: dcim_interface_untagged_vlan_id_838dc7be; Type: INDEX; Schema: public; Owner: netbox3
--

CREATE INDEX dcim_interface_untagged_vlan_id_838dc7be ON public.dcim_interface USING btree (untagged_vlan_id);


--
-- Name: dcim_interface_vrf_id_a92e59b2; Type: INDEX; Schema: public; Owner: netbox3
--

CREATE INDEX dcim_interface_vrf_id_a92e59b2 ON public.dcim_interface USING btree (vrf_id);


--
-- Name: dcim_interface_wireless_link_id_bc91108f; Type: INDEX; Schema: public; Owner: netbox3
--

CREATE INDEX dcim_interface_wireless_link_id_bc91108f ON public.dcim_interface USING btree (wireless_link_id);


--
-- Name: dcim_interface dcim_interface__path_id_f8f4f7f0_fk; Type: FK CONSTRAINT; Schema: public; Owner: netbox3
--

ALTER TABLE ONLY public.dcim_interface
    ADD CONSTRAINT dcim_interface__path_id_f8f4f7f0_fk FOREIGN KEY (_path_id) REFERENCES public.dcim_cablepath(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: dcim_interface dcim_interface_bridge_id_f2a8df85_fk_dcim_interface_id; Type: FK CONSTRAINT; Schema: public; Owner: netbox3
--

ALTER TABLE ONLY public.dcim_interface
    ADD CONSTRAINT dcim_interface_bridge_id_f2a8df85_fk_dcim_interface_id FOREIGN KEY (bridge_id) REFERENCES public.dcim_interface(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: dcim_interface dcim_interface_device_id_359c6115_fk; Type: FK CONSTRAINT; Schema: public; Owner: netbox3
--

ALTER TABLE ONLY public.dcim_interface
    ADD CONSTRAINT dcim_interface_device_id_359c6115_fk FOREIGN KEY (device_id) REFERENCES public.dcim_device(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: dcim_interface dcim_interface_lag_id_ea1a1d12_fk; Type: FK CONSTRAINT; Schema: public; Owner: netbox3
--

ALTER TABLE ONLY public.dcim_interface
    ADD CONSTRAINT dcim_interface_lag_id_ea1a1d12_fk FOREIGN KEY (lag_id) REFERENCES public.dcim_interface(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: dcim_interface dcim_interface_module_id_05ca2da5_fk_dcim_module_id; Type: FK CONSTRAINT; Schema: public; Owner: netbox3
--

ALTER TABLE ONLY public.dcim_interface
    ADD CONSTRAINT dcim_interface_module_id_05ca2da5_fk_dcim_module_id FOREIGN KEY (module_id) REFERENCES public.dcim_module(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: dcim_interface dcim_interface_parent_id_3e2b159b_fk_dcim_interface_id; Type: FK CONSTRAINT; Schema: public; Owner: netbox3
--

ALTER TABLE ONLY public.dcim_interface
    ADD CONSTRAINT dcim_interface_parent_id_3e2b159b_fk_dcim_interface_id FOREIGN KEY (parent_id) REFERENCES public.dcim_interface(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: dcim_interface dcim_interface_untagged_vlan_id_838dc7be_fk; Type: FK CONSTRAINT; Schema: public; Owner: netbox3
--

ALTER TABLE ONLY public.dcim_interface
    ADD CONSTRAINT dcim_interface_untagged_vlan_id_838dc7be_fk FOREIGN KEY (untagged_vlan_id) REFERENCES public.ipam_vlan(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: dcim_interface dcim_interface_vrf_id_a92e59b2_fk_ipam_vrf_id; Type: FK CONSTRAINT; Schema: public; Owner: netbox3
--

ALTER TABLE ONLY public.dcim_interface
    ADD CONSTRAINT dcim_interface_vrf_id_a92e59b2_fk_ipam_vrf_id FOREIGN KEY (vrf_id) REFERENCES public.ipam_vrf(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: dcim_interface dcim_interface_wireless_link_id_bc91108f_fk_wireless_; Type: FK CONSTRAINT; Schema: public; Owner: netbox3
--

ALTER TABLE ONLY public.dcim_interface
    ADD CONSTRAINT dcim_interface_wireless_link_id_bc91108f_fk_wireless_ FOREIGN KEY (wireless_link_id) REFERENCES public.wireless_wirelesslink(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: TABLE dcim_interface; Type: ACL; Schema: public; Owner: netbox3
--

GRANT SELECT ON TABLE public.dcim_interface TO dhcp;


--
-- PostgreSQL database dump complete
--

[TnTBass]

Interesting. I see you have a constraint I don't have:

   TABLE "dcim_virtualdevicecontext" CONSTRAINT "dcim_virtualdevicecontext_device_id_4f39274b_fk_dcim_device_id" FOREIGN KEY (device_id) REFERENCES dcim_device(id) DEFERRABLE INITIALLY DEFERRED

as well as an index I don't have

    "dcim_device_tenant_id_dcea7969" btree (tenant_id)

But I don't see either of these in your pg_dump. Am I just missing them, or are they not being included?

[TnTBass]

As advised here: #11424

ALTER TABLE dcim_device ADD CONSTRAINT temp_fix UNIQUE (virtual_chassis_id, vc_position);