DB netbox broken after upgrade 3.4

[marcucci-DAE]

NetBox version

v3.4.1

Python version

3.9

Steps to Reproduce

After running the ./upgrade.sh (as usually I do..) In the phase the manage.py migrate I receive this error .

django.db.utils.IntegrityError: could not create unique index "dcim_device_unique_name_site_tenant"
DETAIL: Key (lower(name::text), site_id, tenant_id)=(ap--n, 1, 1) is duplicated.

And the DB is not accessible from netbox...

Please help me

Expected Behavior

django.db.utils.IntegrityError: could not create unique index "dcim_device_unique_name_site_tenant"
DETAIL: Key (lower(name::text), site_id, tenant_id)=(ap--n, 1, 1) is duplicated.

Observed Behavior

django.db.utils.IntegrityError: could not create unique index "dcim_device_unique_name_site_tenant"
DETAIL: Key (lower(name::text), site_id, tenant_id)=(ap--n, 1, 1) is duplicated.

[renatoalmeidaoliveira]

It seems that you might have devices with the same name in some site, in version 3.4 the name is case unsensitive so:
Device == device.
Are you able to run nbshell to change the devices name, or rollback to 3.3 change the names and upgrade again?

[marcucci-DAE]

Thanks for your reply . How I can modify thesw device into db? Thanks Inviato da Outlook per Android<https://aka.ms/AAb9ysg>

…

________________________________ From: Renato Almeida de Oliveira ***@***.***> Sent: Tuesday, December 20, 2022 7:54:30 PM To: netbox-community/netbox ***@***.***> Cc: Tiziana Marcucci ***@***.***>; Author ***@***.***> Subject: [EXT] Re: [netbox-community/netbox] DB netbox broken after upgrade 3.4 (Issue #11266) ATTENZIONE: Questa email ha origine esterna all’organizzazione. Non aprire i link e MAI scaricare gli allegati, a meno di conoscere il mittente e di sapere che il contenuto sia attendibile. WARNING: This mail source is external to the organization. Do not open any link and NEVER download attachments, unless you trust the sender and its contents. It seems that you might have devices with the same name in some site, in version 3.4 the name is case unsensitive so: Device == device. — Reply to this email directly, view it on GitHub<#11266 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AWUSFH2JEPNMUGF3UZR5SA3WOH6GNANCNFSM6AAAAAATETRIKU>. You are receiving this because you authored the thread.Message ID: ***@***.***>

[renatoalmeidaoliveira]

Are you able to access nbshell?

[marcucci-DAE]

Yes of course. Da: Renato Almeida de Oliveira ***@***.***> Inviato: martedì 20 dicembre 2022 20:08 A: netbox-community/netbox ***@***.***> Cc: Tiziana Marcucci ***@***.***>; Author ***@***.***> Oggetto: [EXT] Re: [netbox-community/netbox] DB netbox broken after upgrade 3.4 (Issue #11266) ATTENZIONE: Questa email ha origine esterna all’organizzazione. Non aprire i link e MAI scaricare gli allegati, a meno di conoscere il mittente e di sapere che il contenuto sia attendibile. WARNING: This mail source is external to the organization. Do not open any link and NEVER download attachments, unless you trust the sender and its contents. Are you able to access nbshell? — Reply to this email directly, view it on GitHub<#11266 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AWUSFH7VHQ3KT6I3WJFF47LWOH723ANCNFSM6AAAAAATETRIKU>. You are receiving this because you authored the thread.Message ID: ***@***.***>

[renatoalmeidaoliveira]

You have two options here, export all your duplicated names to a csv and deal with then by script later, or append an index to each of then and deal in the web interface. Which one you prefer?

[marcucci-DAE]

The first tnks Da: Renato Almeida de Oliveira ***@***.***> Inviato: giovedì 22 dicembre 2022 14:56 A: netbox-community/netbox ***@***.***> Cc: Tiziana Marcucci ***@***.***>; Author ***@***.***> Oggetto: [EXT] Re: [netbox-community/netbox] DB netbox broken after upgrade 3.4 (Discussion #11293) ATTENZIONE: Questa email ha origine esterna all’organizzazione. Non aprire i link e MAI scaricare gli allegati, a meno di conoscere il mittente e di sapere che il contenuto sia attendibile. WARNING: This mail source is external to the organization. Do not open any link and NEVER download attachments, unless you trust the sender and its contents. You have two options here, export all your duplicated names to a csv and deal with then by script later, or append an index to each of then and deal in the web interface. Which one you prefer? — Reply to this email directly, view it on GitHub<#11293 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AWUSFH5URKISLRQVMYKFQB3WORMVVANCNFSM6AAAAAATGYAYLI>. You are receiving this because you authored the thread.Message ID: ***@***.***>

[marcucci-DAE]

Hi, i prefer following the first solution, Could you tell me how i do it? Thanks Tiziana Da: Renato Almeida de Oliveira ***@***.***> Inviato: giovedì 22 dicembre 2022 14:56 A: netbox-community/netbox ***@***.***> Cc: Tiziana Marcucci ***@***.***>; Author ***@***.***> Oggetto: [EXT] Re: [netbox-community/netbox] DB netbox broken after upgrade 3.4 (Discussion #11293) ATTENZIONE: Questa email ha origine esterna all’organizzazione. Non aprire i link e MAI scaricare gli allegati, a meno di conoscere il mittente e di sapere che il contenuto sia attendibile. WARNING: This mail source is external to the organization. Do not open any link and NEVER download attachments, unless you trust the sender and its contents. You have two options here, export all your duplicated names to a csv and deal with then by script later, or append an index to each of then and deal in the web interface. Which one you prefer? — Reply to this email directly, view it on GitHub<#11293 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AWUSFH5URKISLRQVMYKFQB3WORMVVANCNFSM6AAAAAATGYAYLI>. You are receiving this because you authored the thread.Message ID: ***@***.***>

[marcucci-DAE]

I have resolved this issue deleting manually the records duplicate