relation "netbox_topology_views_coordinategroup" already exists

[Azmodeszer]

I'm trying to install v3.6.0-beta.2 since I need the BASE_PATH fix for icon images, but when I try to migrate this happens:

Operations to perform:
  Apply all migrations: netbox_topology_views
Running migrations:
  Applying netbox_topology_views.0004_coordinategroup_coordinate...Traceback (most recent call last):
  File "/opt/netbox/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 87, in _execute
    return self.cursor.execute(sql)
psycopg2.errors.DuplicateTable: relation "netbox_topology_views_coordinategroup" already exists


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

Traceback (most recent call last):
  File "/opt/netbox/netbox/manage.py", line 10, in <module>
    execute_from_command_line(sys.argv)
  File "/opt/netbox/venv/lib/python3.9/site-packages/django/core/management/__init__.py", line 446, in execute_from_command_line
    utility.execute()
  File "/opt/netbox/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/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/venv/lib/python3.9/site-packages/django/core/management/base.py", line 448, in execute
    output = self.handle(*args, **options)
  File "/opt/netbox/venv/lib/python3.9/site-packages/django/core/management/base.py", line 96, in wrapped
    res = handle_func(*args, **kwargs)
  File "/opt/netbox/venv/lib/python3.9/site-packages/django/core/management/commands/migrate.py", line 349, in handle
    post_migrate_state = executor.migrate(
  File "/opt/netbox/venv/lib/python3.9/site-packages/django/db/migrations/executor.py", line 135, in migrate
    state = self._migrate_all_forwards(
  File "/opt/netbox/venv/lib/python3.9/site-packages/django/db/migrations/executor.py", line 167, in _migrate_all_forwards
    state = self.apply_migration(
  File "/opt/netbox/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/venv/lib/python3.9/site-packages/django/db/migrations/migration.py", line 130, in apply
    operation.database_forwards(
  File "/opt/netbox/venv/lib/python3.9/site-packages/django/db/migrations/operations/models.py", line 96, in database_forwards
    schema_editor.create_model(model)
  File "/opt/netbox/venv/lib/python3.9/site-packages/django/db/backends/base/schema.py", line 447, in create_model
    self.execute(sql, params or None)
  File "/opt/netbox/venv/lib/python3.9/site-packages/django/db/backends/base/schema.py", line 199, in execute
    cursor.execute(sql, params)
  File "/opt/netbox/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 67, in execute
    return self._execute_with_wrappers(
  File "/opt/netbox/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers
    return executor(sql, params, many, context)
  File "/opt/netbox/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 89, in _execute
    return self.cursor.execute(sql, params)
  File "/opt/netbox/venv/lib/python3.9/site-packages/django/db/utils.py", line 91, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/opt/netbox/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 87, in _execute
    return self.cursor.execute(sql)
django.db.utils.ProgrammingError: relation "netbox_topology_views_coordinategroup" already exists

The migration/install works fine when I do it through pip3 install netbox-topology-views, but that installs the 3.5 version, which doesn't have the fix I need.

NetBox v3.5.4
Python v3.9.2
OS: Debian 11

[dreng]

Hi @Azmodeszer,

thank you for trying the beta.

psycopg2.errors.DuplicateTable: relation "netbox_topology_views_coordinategroup" already exists

Looks like you tried some kind of migration before. If you didn't the relation wouldn't exist. The easiest fix is to restore a database backup but that might lead to other problems if it's you production system.

You can use "python3 manage.py dbshell" in order to drop the table netbox_topology_views_coordinategroup and probably also netbox_topology_views_coordinate.

Let us know if you need further assistance with dbshell.

[dreng]

In this case it is completely safe to drop those tables as they will be re-created when you run the non-successful migration again.

You may have to delete a record in the table django_migrations as well. I'm not 100% sure about that at this moment so I suggest that you just drop the tables in the first place and run the migration again.

Pro tip: If it's a critical production system witch is used at high frequency, then make a backup/snapshot first and make all systems and persons stop interacting with it!

[Azmodeszer]

Done.

Now I get:

django.db.utils.ProgrammingError: column "save_coords" of relation "netbox_topology_views_individualoptions" already exists

Should I just drop all the previous plugin-related tables from the db?

[dreng]

You can drop that table as well but you will loose all individual options. You may just alter the table instead and delete the column save_coords.

[Azmodeszer]

Okay, thanks for your help.

[dreng]

Thought about that again and I think, dropping the table is not a good idea. If you like to go this way, consider renaming the table instead in order to revert the change in case of desaster.