Compatibility issue with Netbox Branching

[lukassavukaitis]

Plugin version

v0.3.1

NetBox version

v4.3.3

Python version

3.12

Steps to Reproduce

1. Install Netbox Branching plugin
2. Install Netbox Routing plugin
3. Create a new branch

Expected Behavior

Branch provisions successfully

Observed Behavior

Branch provisioning fails with this -
ProgrammingError('relation "netbox_routing_ospfinterface_unique_interface" already exists')

Job log says this -

...
"Creating table branch_kdb505nm.netbox_routing_bgpaddressfamily",
"Creating table branch_kdb505nm.netbox_routing_bgppeer",
"Creating table branch_kdb505nm.netbox_routing_bgppeeraddressfamily",
"Creating table branch_kdb505nm.netbox_routing_bgppeertemplate",
"Creating table branch_kdb505nm.netbox_routing_bgppoliytemplate",
"Creating table branch_kdb505nm.netbox_routing_bgprouter",
"Creating table branch_kdb505nm.netbox_routing_bgpscope",
"Creating table branch_kdb505nm.netbox_routing_bgpsessiontemplate",
"Creating table branch_kdb505nm.netbox_routing_bgpsetting",
"Creating table branch_kdb505nm.netbox_routing_eigrpaddressfamily",
"Creating table branch_kdb505nm.netbox_routing_eigrpinterface",
"Creating table branch_kdb505nm.netbox_routing_eigrpnetwork",
"Creating table branch_kdb505nm.netbox_routing_eigrprouter",
"Creating table branch_kdb505nm.netbox_routing_ospfarea",
"Creating table branch_kdb505nm.netbox_routing_ospfinstance",
"Creating table branch_kdb505nm.netbox_routing_ospfinterface",
"Creating table branch_kdb505nm.netbox_routing_prefixlist",
"Creating table branch_kdb505nm.netbox_routing_prefixlistentry",
"Creating table branch_kdb505nm.netbox_routing_routemap",
"Creating table branch_kdb505nm.netbox_routing_routemapentry",
"Creating table branch_kdb505nm.netbox_routing_staticroute",
"Creating table branch_kdb505nm.netbox_routing_staticroute_devices",
...
"ALTER INDEX branch_kdb505nm.netbox_routing_eigrpnetwork_router_id_idx RENAME TO netbox_routing_eigrpnetwork_router_id_257a5471",
"ALTER INDEX branch_kdb505nm.netbox_routing_eigrprouter_device_id_idx RENAME TO netbox_routing_eigrprouter_device_id_33edf364",
"ALTER INDEX branch_kdb505nm.netbox_routing_ospfinstance_device_id_idx RENAME TO netbox_routing_ospfinstance_device_id_b96072df",
"ALTER INDEX branch_kdb505nm.netbox_routing_ospfinstance_vrf_id_idx RENAME TO netbox_routing_ospfinstance_vrf_id_87f63b8b",
"ALTER INDEX branch_kdb505nm.netbox_routing_ospfinterface_interface_id_key RENAME TO netbox_routing_ospfinterface_unique_interface",
"ALTER INDEX branch_kdb505nm.netbox_routing_ospfinterface_area_id_idx RENAME TO netbox_routing_ospfinterface_area_id_cad425e6",
"ALTER INDEX branch_kdb505nm.netbox_routing_ospfinterface_instance_id_idx RENAME TO netbox_routing_ospfinterface_instance_id_23fc4c92",
"ALTER INDEX branch_kdb505nm.netbox_routing_ospfinterface_interface_id_idx RENAME TO netbox_routing_ospfinterface_unique_interface",
"relation \"netbox_routing_ospfinterface_unique_interface\" already exists"

I raised this before here - #78 - and was advised to raise this with Netbox Branching devs however it seems that Routing plugin needs to be updated to get this to work; see here - netboxlabs/netbox-branching#269

[DanSheps]

Yeah, unfortunately the issue is still on netbox-branching.

I will eventually get around to writing a fix for it, but the issue is multiple indexes with the same fields but not the same usage(unique index vs index). Netbox Branching does not take this use case into account. It will not be fixed here, but I will submit a PR when I can to netbox-branching.

[DanSheps]

For now, I am going to convert to a OneToOneField, since we don't need the extra index and we are only doing it to enforce a OneToOne relationship.

[lukassavukaitis]

Thanks @DanSheps
Can I just confirm the requirement for ('dcim', '0215_rackreservation_status'), in 0016 migrations.py? Doesn't that mean I need to use Netbox 4.4 before using this plugin?

[DanSheps]

Yes, that constraint shouldn't be there however so I will push that to main and it will get into the next release. If you want to manually edit and remove that on your install you can.