Upgrade v2.7.11 -> v2.10.4 database duplicate key value

[CraigRMoore]

Hi All,

I'm trying to upgrade to v2.10.4 and it seems we have some duplicate key values, we've not made any changes to the database schema:

Checking for missing cable paths (python3 netbox/manage.py trace_paths --no-input)...
Retracing 57 cabled circuit terminations...
Side Z 89
Traceback (most recent call last):
File "/opt/netbox-2.10.4/venv/lib/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint "dcim_cablepath_origin_type_id_origin_id_41b6f814_uniq"
DETAIL: Key (origin_type_id, origin_id)=(10, 89) already exists.

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "netbox/manage.py", line 10, in
execute_from_command_line(sys.argv)
File "/opt/netbox-2.10.4/venv/lib/python3.6/site-packages/django/core/management/init.py", line 401, in

Looks very similar to the problem described in #2696

I can look up /dcim/cables/10 & /dcim/cables/89 OK when running v2.7.11 so not sure how to fix.

Any ideas?

Thanks,
Craig.

[CraigRMoore]

Just an update to this, I've restored the database into our dev instance, deleted the two offending cables (10,89) then run the upgrade which finished successfully. At least there were no more duplicates so minimal data re-entry.