Issue while upgrade. #4007

Closed
opened 2025-12-29 18:32:35 +01:00 by adam · 1 comment
Owner

Originally created by @shnacharya on GitHub (Aug 21, 2020).

Applying virtualization.0016_replicate_interfaces...
Replicating 42 VM interfaces...
Traceback (most recent call last):
File "/opt/dcim/venv/lib64/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 "virtualization_vminterfa_virtual_machine_id_name_cfb9c423_uniq"
DETAIL: Key (virtual_machine_id, name)=(5, ens18) 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/dcim/venv/lib64/python3.6/site-packages/django/core/management/init.py", line 401, in execute_from_command_line
utility.execute()
File "/opt/dcim/venv/lib64/python3.6/site-packages/django/core/management/init.py", line 395, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/opt/dcim/venv/lib64/python3.6/site-packages/django/core/management/base.py", line 330, in run_from_argv
self.execute(*args, **cmd_options)
File "/opt/dcim/venv/lib64/python3.6/site-packages/django/core/management/base.py", line 371, in execute
output = self.handle(*args, **options)
File "/opt/dcim/venv/lib64/python3.6/site-packages/django/core/management/base.py", line 85, in wrapped
res = handle_func(*args, **kwargs)
File "/opt/dcim/venv/lib64/python3.6/site-packages/django/core/management/commands/migrate.py", line 245, in handle
fake_initial=fake_initial,
File "/opt/dcim/venv/lib64/python3.6/site-packages/django/db/migrations/executor.py", line 117, in migrate
state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial)
File "/opt/dcim/venv/lib64/python3.6/site-packages/django/db/migrations/executor.py", line 147, in _migrate_all_forwards
state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial)
File "/opt/dcim/venv/lib64/python3.6/site-packages/django/db/migrations/executor.py", line 227, in apply_migration
state = migration.apply(state, schema_editor)
File "/opt/dcim/venv/lib64/python3.6/site-packages/django/db/migrations/migration.py", line 124, in apply
operation.database_forwards(self.app_label, schema_editor, old_state, project_state)
File "/opt/dcim/venv/lib64/python3.6/site-packages/django/db/migrations/operations/special.py", line 190, in database_forwards
self.code(from_state.apps, schema_editor)
File "/opt/dcim/netbox/virtualization/migrations/0016_replicate_interfaces.py", line 37, in replicate_interfaces
VMInterface.objects.bulk_create(new_interfaces, batch_size=1000)
File "/opt/dcim/venv/lib64/python3.6/site-packages/django/db/models/manager.py", line 85, in manager_method
return getattr(self.get_queryset(), name)(*args, **kwargs)
File "/opt/dcim/venv/lib64/python3.6/site-packages/cacheops/query.py", line 373, in bulk_create
objs = self._no_monkey.bulk_create(self, objs, *args, **kwargs)
File "/opt/dcim/venv/lib64/python3.6/site-packages/django/db/models/query.py", line 507, in bulk_create
objs_without_pk, fields, batch_size, ignore_conflicts=ignore_conflicts,
File "/opt/dcim/venv/lib64/python3.6/site-packages/django/db/models/query.py", line 1269, in _batched_insert
ignore_conflicts=ignore_conflicts,
File "/opt/dcim/venv/lib64/python3.6/site-packages/django/db/models/query.py", line 1249, in _insert
return query.get_compiler(using=using).execute_sql(returning_fields)
File "/opt/dcim/venv/lib64/python3.6/site-packages/django/db/models/sql/compiler.py", line 1395, in execute_sql
cursor.execute(sql, params)
File "/opt/dcim/venv/lib64/python3.6/site-packages/cacheops/transaction.py", line 93, in execute
result = self._no_monkey.execute(self, sql, params)
File "/opt/dcim/venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 66, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/opt/dcim/venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/opt/dcim/venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
File "/opt/dcim/venv/lib64/python3.6/site-packages/django/db/utils.py", line 90, in exit
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/opt/dcim/venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
django.db.utils.IntegrityError: duplicate key value violates unique constraint "virtualization_vminterfa_virtual_machine_id_name_cfb9c423_uniq"
DETAIL: Key (virtual_machine_id, name)=(5, ens18) already exists.

Originally created by @shnacharya on GitHub (Aug 21, 2020). Applying virtualization.0016_replicate_interfaces... Replicating 42 VM interfaces... Traceback (most recent call last): File "/opt/dcim/venv/lib64/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 "virtualization_vminterfa_virtual_machine_id_name_cfb9c423_uniq" DETAIL: Key (virtual_machine_id, name)=(5, ens18) 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 <module> execute_from_command_line(sys.argv) File "/opt/dcim/venv/lib64/python3.6/site-packages/django/core/management/__init__.py", line 401, in execute_from_command_line utility.execute() File "/opt/dcim/venv/lib64/python3.6/site-packages/django/core/management/__init__.py", line 395, in execute self.fetch_command(subcommand).run_from_argv(self.argv) File "/opt/dcim/venv/lib64/python3.6/site-packages/django/core/management/base.py", line 330, in run_from_argv self.execute(*args, **cmd_options) File "/opt/dcim/venv/lib64/python3.6/site-packages/django/core/management/base.py", line 371, in execute output = self.handle(*args, **options) File "/opt/dcim/venv/lib64/python3.6/site-packages/django/core/management/base.py", line 85, in wrapped res = handle_func(*args, **kwargs) File "/opt/dcim/venv/lib64/python3.6/site-packages/django/core/management/commands/migrate.py", line 245, in handle fake_initial=fake_initial, File "/opt/dcim/venv/lib64/python3.6/site-packages/django/db/migrations/executor.py", line 117, in migrate state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial) File "/opt/dcim/venv/lib64/python3.6/site-packages/django/db/migrations/executor.py", line 147, in _migrate_all_forwards state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial) File "/opt/dcim/venv/lib64/python3.6/site-packages/django/db/migrations/executor.py", line 227, in apply_migration state = migration.apply(state, schema_editor) File "/opt/dcim/venv/lib64/python3.6/site-packages/django/db/migrations/migration.py", line 124, in apply operation.database_forwards(self.app_label, schema_editor, old_state, project_state) File "/opt/dcim/venv/lib64/python3.6/site-packages/django/db/migrations/operations/special.py", line 190, in database_forwards self.code(from_state.apps, schema_editor) File "/opt/dcim/netbox/virtualization/migrations/0016_replicate_interfaces.py", line 37, in replicate_interfaces VMInterface.objects.bulk_create(new_interfaces, batch_size=1000) File "/opt/dcim/venv/lib64/python3.6/site-packages/django/db/models/manager.py", line 85, in manager_method return getattr(self.get_queryset(), name)(*args, **kwargs) File "/opt/dcim/venv/lib64/python3.6/site-packages/cacheops/query.py", line 373, in bulk_create objs = self._no_monkey.bulk_create(self, objs, *args, **kwargs) File "/opt/dcim/venv/lib64/python3.6/site-packages/django/db/models/query.py", line 507, in bulk_create objs_without_pk, fields, batch_size, ignore_conflicts=ignore_conflicts, File "/opt/dcim/venv/lib64/python3.6/site-packages/django/db/models/query.py", line 1269, in _batched_insert ignore_conflicts=ignore_conflicts, File "/opt/dcim/venv/lib64/python3.6/site-packages/django/db/models/query.py", line 1249, in _insert return query.get_compiler(using=using).execute_sql(returning_fields) File "/opt/dcim/venv/lib64/python3.6/site-packages/django/db/models/sql/compiler.py", line 1395, in execute_sql cursor.execute(sql, params) File "/opt/dcim/venv/lib64/python3.6/site-packages/cacheops/transaction.py", line 93, in execute result = self._no_monkey.execute(self, sql, params) File "/opt/dcim/venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 66, in execute return self._execute_with_wrappers(sql, params, many=False, executor=self._execute) File "/opt/dcim/venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers return executor(sql, params, many, context) File "/opt/dcim/venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute return self.cursor.execute(sql, params) File "/opt/dcim/venv/lib64/python3.6/site-packages/django/db/utils.py", line 90, in __exit__ raise dj_exc_value.with_traceback(traceback) from exc_value File "/opt/dcim/venv/lib64/python3.6/site-packages/django/db/backends/utils.py", line 84, in _execute return self.cursor.execute(sql, params) django.db.utils.IntegrityError: duplicate key value violates unique constraint "virtualization_vminterfa_virtual_machine_id_name_cfb9c423_uniq" DETAIL: Key (virtual_machine_id, name)=(5, ens18) already exists.
adam closed this issue 2025-12-29 18:32:35 +01:00
Author
Owner

@jeremystretch commented on GitHub (Aug 21, 2020):

Thank you for your interest in NetBox. GitHub issues are intended for reporting reproducible bugs and requesting features, and must be submitted using one of the templates provided here. For general discussion, questions, or assistance with installation issues, please post to our mailing list instead.

@jeremystretch commented on GitHub (Aug 21, 2020): Thank you for your interest in NetBox. GitHub issues are intended for reporting reproducible bugs and requesting features, and must be submitted using one of the templates provided [here](https://github.com/netbox-community/netbox/issues/new/choose). For general discussion, questions, or assistance with installation issues, please post to our [mailing list](https://groups.google.com/forum/#!forum/netbox-discuss) instead.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/netbox#4007