Importing YAML breaks sequence IDs #1232

New Issue

MrUnknownDE · 2026-04-05T22:23:31+02:00

MrUnknownDE commented

2026-04-05 22:23:31 +02:00

Originally created by @Etibru on 9/17/2025

NetBox Edition

NetBox Community

NetBox Version

v4.2.7

Python Version

3.10

Steps to Reproduce

Import a YAML of Device Type (with, interfaces, power port, ...)
ex:

manufacturer: Legrand
model: PX4-2699-E7V2
slug: legrand-px4-2699-e7v2
description: ''
default_platform: null
part_number: PX4-2699-E7V2
u_height: 0.0
is_full_depth: false
subdevice_role: null
airflow: null
weight: 7.8
weight_unit: kg
comments: '[Rack PDU | PX4-2699-E7V2 | Product Selector - Raritan](https://www.raritan.com/product-selector/pdu-detail/PX4-2699-E7V2)'
power-ports:
- name: Power Port 1
  type: iec-60309-3p-n-e-6h
  maximum_draw: 22200
  allocated_draw: null
  label: ''
  description: ''
power-outlets:
- name: Outlet 1.1
  type: iec-60320-c13
  power_port: Power Port 1
  feed_leg: A
  label: ''
  description: ''
- name: Outlet 1.2
  type: iec-60320-c13
  power_port: Power Port 1
  feed_leg: A
  label: ''
  description: ''
- name: Outlet 1.3
  type: iec-60320-c13
  power_port: Power Port 1
  feed_leg: A
  label: ''
  description: ''
- name: Outlet 1.4
  type: hdot-cx
  power_port: Power Port 1
  feed_leg: A
  label: ''
  description: ''
- name: Outlet 1.5
  type: hdot-cx
  power_port: Power Port 1
  feed_leg: A
  label: ''
  description: ''
- name: Outlet 1.6
  type: hdot-cx
  power_port: Power Port 1
  feed_leg: A
  label: ''
  description: ''
- name: Outlet 1.7
  type: iec-60320-c13
  power_port: Power Port 1
  feed_leg: B
  label: ''
  description: ''
- name: Outlet 1.8
  type: iec-60320-c13
  power_port: Power Port 1
  feed_leg: B
  label: ''
  description: ''
- name: Outlet 1.9
  type: iec-60320-c13
  power_port: Power Port 1
  feed_leg: B
  label: ''
  description: ''
- name: Outlet 1.10
  type: hdot-cx
  power_port: Power Port 1
  feed_leg: B
  label: ''
  description: ''
- name: Outlet 1.11
  type: hdot-cx
  power_port: Power Port 1
  feed_leg: B
  label: ''
  description: ''
- name: Outlet 1.12
  type: hdot-cx
  power_port: Power Port 1
  feed_leg: B
  label: ''
  description: ''
- name: Outlet 1.13
  type: iec-60320-c13
  power_port: Power Port 1
  feed_leg: C
  label: ''
  description: ''
- name: Outlet 1.14
  type: iec-60320-c13
  power_port: Power Port 1
  feed_leg: C
  label: ''
  description: ''
- name: Outlet 1.15
  type: iec-60320-c13
  power_port: Power Port 1
  feed_leg: C
  label: ''
  description: ''
- name: Outlet 1.16
  type: hdot-cx
  power_port: Power Port 1
  feed_leg: C
  label: ''
  description: ''
- name: Outlet 1.17
  type: hdot-cx
  power_port: Power Port 1
  feed_leg: C
  label: ''
  description: ''
- name: Outlet 1.18
  type: hdot-cx
  power_port: Power Port 1
  feed_leg: C
  label: ''
  description: ''
- name: Outlet 1.19
  type: iec-60320-c13
  power_port: Power Port 1
  feed_leg: A
  label: ''
  description: ''
- name: Outlet 1.20
  type: iec-60320-c13
  power_port: Power Port 1
  feed_leg: A
  label: ''
  description: ''
- name: Outlet 1.21
  type: iec-60320-c13
  power_port: Power Port 1
  feed_leg: A
  label: ''
  description: ''
- name: Outlet 1.22
  type: hdot-cx
  power_port: Power Port 1
  feed_leg: A
  label: ''
  description: ''
- name: Outlet 1.23
  type: hdot-cx
  power_port: Power Port 1
  feed_leg: A
  label: ''
  description: ''
- name: Outlet 1.24
  type: hdot-cx
  power_port: Power Port 1
  feed_leg: A
  label: ''
  description: ''
- name: Outlet 1.25
  type: iec-60320-c13
  power_port: Power Port 1
  feed_leg: B
  label: ''
  description: ''
- name: Outlet 1.26
  type: iec-60320-c13
  power_port: Power Port 1
  feed_leg: B
  label: ''
  description: ''
- name: Outlet 1.27
  type: iec-60320-c13
  power_port: Power Port 1
  feed_leg: B
  label: ''
  description: ''
- name: Outlet 1.28
  type: hdot-cx
  power_port: Power Port 1
  feed_leg: B
  label: ''
  description: ''
- name: Outlet 1.29
  type: hdot-cx
  power_port: Power Port 1
  feed_leg: B
  label: ''
  description: ''
- name: Outlet 1.30
  type: hdot-cx
  power_port: Power Port 1
  feed_leg: B
  label: ''
  description: ''
- name: Outlet 1.31
  type: iec-60320-c13
  power_port: Power Port 1
  feed_leg: C
  label: ''
  description: ''
- name: Outlet 1.32
  type: iec-60320-c13
  power_port: Power Port 1
  feed_leg: C
  label: ''
  description: ''
- name: Outlet 1.33
  type: iec-60320-c13
  power_port: Power Port 1
  feed_leg: C
  label: ''
  description: ''
- name: Outlet 1.34
  type: hdot-cx
  power_port: Power Port 1
  feed_leg: C
  label: ''
  description: ''
- name: Outlet 1.35
  type: hdot-cx
  power_port: Power Port 1
  feed_leg: C
  label: ''
  description: ''
- name: Outlet 1.36
  type: hdot-cx
  power_port: Power Port 1
  feed_leg: C
  label: ''
  description: ''
interfaces:
- name: Link-a
  type: 100base-tx
  enabled: true
  mgmt_only: false
  label: ''
  description: ''
  bridge: null
  poe_mode: null
  poe_type: null
  rf_role: null
- name: Link-b
  type: 100base-tx
  enabled: true
  mgmt_only: true
  label: ''
  description: ''
  bridge: null
  poe_mode: null
  poe_type: null
  rf_role: null

Create another device type and add manually an interface, power port, ... (objects of the type previously created by the import)
Internal Server error

Expected Behavior

Importing an object should not redefine session IDs in the database.

Observed Behavior

Pkey already exists :

To solve the problem, you must go through the database like this:
SELECT setval('dcim_powerporttemplate_id_seq', (SELECT MAX(id) from dcim_powerporttemplate));

*Originally created by @Etibru on 9/17/2025* ### NetBox Edition NetBox Community ### NetBox Version v4.2.7 ### Python Version 3.10 ### Steps to Reproduce 1. Import a YAML of Device Type (with, interfaces, power port, ...) ex: ```yaml manufacturer: Legrand model: PX4-2699-E7V2 slug: legrand-px4-2699-e7v2 description: '' default_platform: null part_number: PX4-2699-E7V2 u_height: 0.0 is_full_depth: false subdevice_role: null airflow: null weight: 7.8 weight_unit: kg comments: '[Rack PDU | PX4-2699-E7V2 | Product Selector - Raritan](https://www.raritan.com/product-selector/pdu-detail/PX4-2699-E7V2)' power-ports: - name: Power Port 1 type: iec-60309-3p-n-e-6h maximum_draw: 22200 allocated_draw: null label: '' description: '' power-outlets: - name: Outlet 1.1 type: iec-60320-c13 power_port: Power Port 1 feed_leg: A label: '' description: '' - name: Outlet 1.2 type: iec-60320-c13 power_port: Power Port 1 feed_leg: A label: '' description: '' - name: Outlet 1.3 type: iec-60320-c13 power_port: Power Port 1 feed_leg: A label: '' description: '' - name: Outlet 1.4 type: hdot-cx power_port: Power Port 1 feed_leg: A label: '' description: '' - name: Outlet 1.5 type: hdot-cx power_port: Power Port 1 feed_leg: A label: '' description: '' - name: Outlet 1.6 type: hdot-cx power_port: Power Port 1 feed_leg: A label: '' description: '' - name: Outlet 1.7 type: iec-60320-c13 power_port: Power Port 1 feed_leg: B label: '' description: '' - name: Outlet 1.8 type: iec-60320-c13 power_port: Power Port 1 feed_leg: B label: '' description: '' - name: Outlet 1.9 type: iec-60320-c13 power_port: Power Port 1 feed_leg: B label: '' description: '' - name: Outlet 1.10 type: hdot-cx power_port: Power Port 1 feed_leg: B label: '' description: '' - name: Outlet 1.11 type: hdot-cx power_port: Power Port 1 feed_leg: B label: '' description: '' - name: Outlet 1.12 type: hdot-cx power_port: Power Port 1 feed_leg: B label: '' description: '' - name: Outlet 1.13 type: iec-60320-c13 power_port: Power Port 1 feed_leg: C label: '' description: '' - name: Outlet 1.14 type: iec-60320-c13 power_port: Power Port 1 feed_leg: C label: '' description: '' - name: Outlet 1.15 type: iec-60320-c13 power_port: Power Port 1 feed_leg: C label: '' description: '' - name: Outlet 1.16 type: hdot-cx power_port: Power Port 1 feed_leg: C label: '' description: '' - name: Outlet 1.17 type: hdot-cx power_port: Power Port 1 feed_leg: C label: '' description: '' - name: Outlet 1.18 type: hdot-cx power_port: Power Port 1 feed_leg: C label: '' description: '' - name: Outlet 1.19 type: iec-60320-c13 power_port: Power Port 1 feed_leg: A label: '' description: '' - name: Outlet 1.20 type: iec-60320-c13 power_port: Power Port 1 feed_leg: A label: '' description: '' - name: Outlet 1.21 type: iec-60320-c13 power_port: Power Port 1 feed_leg: A label: '' description: '' - name: Outlet 1.22 type: hdot-cx power_port: Power Port 1 feed_leg: A label: '' description: '' - name: Outlet 1.23 type: hdot-cx power_port: Power Port 1 feed_leg: A label: '' description: '' - name: Outlet 1.24 type: hdot-cx power_port: Power Port 1 feed_leg: A label: '' description: '' - name: Outlet 1.25 type: iec-60320-c13 power_port: Power Port 1 feed_leg: B label: '' description: '' - name: Outlet 1.26 type: iec-60320-c13 power_port: Power Port 1 feed_leg: B label: '' description: '' - name: Outlet 1.27 type: iec-60320-c13 power_port: Power Port 1 feed_leg: B label: '' description: '' - name: Outlet 1.28 type: hdot-cx power_port: Power Port 1 feed_leg: B label: '' description: '' - name: Outlet 1.29 type: hdot-cx power_port: Power Port 1 feed_leg: B label: '' description: '' - name: Outlet 1.30 type: hdot-cx power_port: Power Port 1 feed_leg: B label: '' description: '' - name: Outlet 1.31 type: iec-60320-c13 power_port: Power Port 1 feed_leg: C label: '' description: '' - name: Outlet 1.32 type: iec-60320-c13 power_port: Power Port 1 feed_leg: C label: '' description: '' - name: Outlet 1.33 type: iec-60320-c13 power_port: Power Port 1 feed_leg: C label: '' description: '' - name: Outlet 1.34 type: hdot-cx power_port: Power Port 1 feed_leg: C label: '' description: '' - name: Outlet 1.35 type: hdot-cx power_port: Power Port 1 feed_leg: C label: '' description: '' - name: Outlet 1.36 type: hdot-cx power_port: Power Port 1 feed_leg: C label: '' description: '' interfaces: - name: Link-a type: 100base-tx enabled: true mgmt_only: false label: '' description: '' bridge: null poe_mode: null poe_type: null rf_role: null - name: Link-b type: 100base-tx enabled: true mgmt_only: true label: '' description: '' bridge: null poe_mode: null poe_type: null rf_role: null ``` 2. Create another device type and add manually an interface, power port, ... (objects of the type previously created by the import) 3. Internal Server error ### Expected Behavior Importing an object should not redefine session IDs in the database. ### Observed Behavior Pkey already exists : <img width="1027" height="534" alt="Image" src="https://github.com/user-attachments/assets/67dbecbe-fdaf-4716-90fd-450c27d42507" /> To solve the problem, you must go through the database like this: `SELECT setval('dcim_powerporttemplate_id_seq', (SELECT MAX(id) from dcim_powerporttemplate));`

MrUnknownDE closed this issue

2026-04-05 22:23:31 +02:00

Sign in to join this conversation.

Branches Tags

main

21455-sql-indexes-audit

21357-register-model-actions

feature

20924-plugin-ui-components

21766-improve-test-coverage-for-sortable-table-columns

21157-export-template-public-models

21025-pre-render-config-contexts

21364-swagger

feature-ip-prefix-link

20911-dropdown-3

fix_module_substitution

21160-filterset

20911-dropdown-2

20044-elevation-stuck-lightmode

7604-filter-modifiers-v3

20660-script-load

19724-graphql

14884-script

19720-macaddress-interface-generic-relation

fix-19669-api-image-download

7604-filter-modifiers

19275-fixes-interface-bulk-edit

fix-17794-get_field_value_return_list

11507-show-aggregate-and-rir-on-api

9583-add_column_specific_search_field_to_tables

No Label pending closure pending closure pending closure pending closure pending closure pending closure pending closure pending closure pending closure pending closure pending closure pending closure pending closure pending closure pending closure pending closure pending closure pending closure pending closure pending closure pending closure pending closure pending closure pending closure pending closure pending closure pending closure pending closure pending closure pending closure pending closure pending closure pending closure pending closure pending closure pending closure pending closure type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug type: bug

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github/netbox#1232