Multiple unnamed device in same site isn't supported (dcim_device_unique_name_site) #7394

New Issue

adam · 2025-12-29T20:22:53+01:00

adam commented

2025-12-29 20:22:53 +01:00

Originally created by @ChrisdAutume on GitHub (Dec 20, 2022).

NetBox version

3.4.1

Python version

3.9

Steps to Reproduce

Create several unnamed devices in the same site

Expected Behavior

Device are created and excluded from dcim_device_unique_name_site constraint

Observed Behavior

Cannot create several unnamed devices in same site.

Originally created by @ChrisdAutume on GitHub (Dec 20, 2022). ### NetBox version 3.4.1 ### Python version 3.9 ### Steps to Reproduce - Create several unnamed devices in the same site ### Expected Behavior - Device are created and excluded from dcim_device_unique_name_site constraint ### Observed Behavior Cannot create several unnamed devices in same site.

adam added the type: bug label 2025-12-29 20:22:53 +01:00

adam closed this issue

2025-12-29 20:22:53 +01:00

adam commented

2025-12-29 20:22:54 +01:00

@PaulR282 commented on GitHub (Dec 21, 2022):

I couldn't reproduce it. Just creating 2 unnamed devices that are identical in the same rack or as non-racked worked for me.

@PaulR282 commented on GitHub (Dec 21, 2022): I couldn't reproduce it. Just creating 2 unnamed devices that are identical in the same rack or as non-racked worked for me.

adam commented

2025-12-29 20:22:54 +01:00

@julianstolp commented on GitHub (Dec 21, 2022):

I also couldn't reproduce it in our testing.

@julianstolp commented on GitHub (Dec 21, 2022): I also couldn't reproduce it in our testing.

adam commented

2025-12-29 20:22:55 +01:00

@ChrisdAutume commented on GitHub (Dec 21, 2022):

Well, to be more precise. It's happening during migration process when django is applying the new constraint. I checked through psql.

django.db.utils.IntegrityError: could not create unique index "dcim_device_unique_name_site"
DETAIL:  Key (lower(name::text), site_id)=(, 547) is duplicated

netbox=# select lower(name::text), count(*) from dcim_device group by lower(name::text) having count(*) > 1;
 lower | count 
-------+-------
       |  1100
       |   201
(2 rows)

@ChrisdAutume commented on GitHub (Dec 21, 2022): Well, to be more precise. It's happening during migration process when django is applying the new constraint. I checked through psql. ``` django.db.utils.IntegrityError: could not create unique index "dcim_device_unique_name_site" DETAIL: Key (lower(name::text), site_id)=(, 547) is duplicated ``` ``` netbox=# select lower(name::text), count(*) from dcim_device group by lower(name::text) having count(*) > 1; lower | count -------+------- | 1100 | 201 (2 rows) ```

adam commented

2025-12-29 20:22:55 +01:00

@julianstolp commented on GitHub (Dec 21, 2022):

Looks like the same issue #11266 and is very likely relating to the breaking change in 3.4.0 see (https://github.com/netbox-community/netbox/releases/tag/v3.4.0)

Device and virtual machine names are no longer case-sensitive. Attempting to create e.g. "device1" and "DEVICE1" within the same site will raise a validation error.

@julianstolp commented on GitHub (Dec 21, 2022): Looks like the same issue #11266 and is very likely relating to the breaking change in 3.4.0 see (https://github.com/netbox-community/netbox/releases/tag/v3.4.0) > - Device and virtual machine names are no longer case-sensitive. Attempting to create e.g. "device1" and "DEVICE1" within the same site will raise a validation error.

adam commented

2025-12-29 20:22:55 +01:00

@ChrisdAutume commented on GitHub (Dec 22, 2022):

I founded out that somes devices names was empty but not null in the DB.

update dcim_device set name=NULL where name='';

Correct the problems.

@ChrisdAutume commented on GitHub (Dec 22, 2022): I founded out that somes devices names was empty but not null in the DB. `update dcim_device set name=NULL where name='';` Correct the problems.

Sign in to join this conversation.

Branches Tags

main

update-changelog-comments-docs

feature-removal-issue-type

20911-dropdown

20239-plugin-menu-classes-mutable-state

21097-graphql-id-lookups

feature

fix_module_substitution

20923-dcim-templates

20044-elevation-stuck-lightmode

feature-ip-prefix-link

v4.5-beta1-release

20068-import-moduletype-attrs

20766-fix-german-translation-code-literals

20378-del-script

7604-filter-modifiers-v3

circuit-swap

12318-case-insensitive-uniqueness

20637-improve-device-q-filter

20660-script-load

19724-graphql

20614-update-ruff

14884-script

02496-max-page

19720-macaddress-interface-generic-relation

19408-circuit-terminations-export-templates

20203-openapi-check

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

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: starred/netbox#7394