relation "netbox_routing_ospfinterface_unique_interface" already exists

[lukassavukaitis]

Plugin Version

0.5.5

NetBox Version

4.2.9

Python Version

3.12

Steps to Reproduce

1. Install the Netbox Routing and Netbox Branching plugins
2. Try to create a new branch
3. Receive an error on branch provisioning job.
   A similar issue was reported here (for different model though) - relation "dcim_cabletermination_unique_termination" already exists #260

Expected Behavior

A branch provisions successfully.

Observed Behavior

Receive an error on branch provisioning job -
"ALTER INDEX branch_tndulxrd.netbox_routing_eigrpinterface_interface_id_idx RENAME TO netbox_routing_eigrpinterface_interface_id_b8020ff1", "ALTER INDEX branch_tndulxrd.netbox_routing_eigrpinterface_router_id_idx RENAME TO netbox_routing_eigrpinterface_router_id_0a466234", "ALTER INDEX branch_tndulxrd.netbox_routing_eigrpnetwork_router_id_address_family_id_net_key RENAME TO netbox_routing_eigrpnetwork_unique_network", "ALTER INDEX branch_tndulxrd.netbox_routing_eigrpnetwork_address_family_id_idx RENAME TO netbox_routing_eigrpnetwork_address_family_id_90b1622f", "ALTER INDEX branch_tndulxrd.netbox_routing_eigrpnetwork_network_id_idx RENAME TO netbox_routing_eigrpnetwork_network_id_56d65d36", "ALTER INDEX branch_tndulxrd.netbox_routing_eigrpnetwork_router_id_idx RENAME TO netbox_routing_eigrpnetwork_router_id_257a5471", "ALTER INDEX branch_tndulxrd.netbox_routing_eigrprouter_device_id_idx RENAME TO netbox_routing_eigrprouter_device_id_33edf364", "ALTER INDEX branch_tndulxrd.netbox_routing_ospfinstance_device_id_idx RENAME TO netbox_routing_ospfinstance_device_id_b96072df", "ALTER INDEX branch_tndulxrd.netbox_routing_ospfinstance_vrf_id_idx RENAME TO netbox_routing_ospfinstance_vrf_id_87f63b8b", "ALTER INDEX branch_tndulxrd.netbox_routing_ospfinterface_interface_id_key RENAME TO netbox_routing_ospfinterface_unique_interface", "ALTER INDEX branch_tndulxrd.netbox_routing_ospfinterface_area_id_idx RENAME TO netbox_routing_ospfinterface_area_id_cad425e6", "ALTER INDEX branch_tndulxrd.netbox_routing_ospfinterface_instance_id_idx RENAME TO netbox_routing_ospfinterface_instance_id_23fc4c92", "ALTER INDEX branch_tndulxrd.netbox_routing_ospfinterface_interface_id_idx RENAME TO netbox_routing_ospfinterface_unique_interface", "relation \"netbox_routing_ospfinterface_unique_interface\" already exists"

[DanSheps]

Provisioning Log:

netbox_branching.netbox_routing_log.json

Indexes (a little easier to read):

indexes_on_table.txt

List of indexes using the query:

[jeremystretch]

The exception occurs due to the behavior of PostgreSQL when replicating a table with the CREATE TABLE foo (LIKE bar INCLUDING INDEXES) command. PostgreSQL does not retain the original index names, so any duplicate index definitions result in an error.

The duplicate indexes need to be removed from the plugin via a database migration just as we removed duplicate indexes from NetBox. (The fix for #260 was merely a temporary stopgap to fix compatibility with NetBox releases earlier than v4.3.0.)

[DanSheps]

Table Layout:

CREATE UNIQUE INDEX netbox_routing_ospfinterface_pkey ON branch_wb4zqq9i.netbox_routing_ospfinterface USING btree (id)
CREATE UNIQUE INDEX netbox_routing_ospfinterface_unique_interface ON branch_wb4zqq9i.netbox_routing_ospfinterface USING btree (interface_id)
CREATE INDEX netbox_routing_ospfinterface_area_id_cad425e6 ON branch_wb4zqq9i.netbox_routing_ospfinterface USING btree (area_id)
CREATE INDEX netbox_routing_ospfinterface_instance_id_23fc4c92 ON branch_wb4zqq9i.netbox_routing_ospfinterface USING btree (instance_id)
CREATE INDEX netbox_routing_ospfinterface_interface_id_idx ON branch_wb4zqq9i.netbox_routing_ospfinterface USING btree (interface_id)