Unable to query racks after migration #3247

New Issue

adam · 2025-12-29T18:27:04+01:00

adam commented

2025-12-29 18:27:04 +01:00

Originally created by @henyxia on GitHub (Jan 30, 2020).

Originally assigned to: @jeremystretch on GitHub.

Environment

Python version: 3.7.6
NetBox version: 2.7.3

Steps to Reproduce

GET on /api/dcim/racks/8381/

What did you expect to happen?

Get the rack information

Observed Behavior

A 500 page with the error:

<class 'KeyError'>

'1000'

Additional information

After some digging, I think the issue comes from some racks where the outer_unit field was improperly migrated (going from 2.6.5 to 2.7.3).
In the database, I can see:

netbox=> select count(1), outer_unit from dcim_rack group by outer_unit;

 count | outer_unit
-------+------------
     9 | 1000
  4413 |
(2 rows)

Note

The issue might be related to https://github.com/netbox-community/netbox/issues/3967

Originally created by @henyxia on GitHub (Jan 30, 2020). Originally assigned to: @jeremystretch on GitHub.  ### Environment * Python version: 3.7.6 * NetBox version: 2.7.3 ### Steps to Reproduce 1. GET on /api/dcim/racks/8381/ ### What did you expect to happen? Get the rack information ### Observed Behavior A 500 page with the error: ``` <class 'KeyError'> '1000' ``` ### Additional information After some digging, I think the issue comes from some racks where the `outer_unit` field was improperly migrated (going from 2.6.5 to 2.7.3). In the database, I can see: ``` netbox=> select count(1), outer_unit from dcim_rack group by outer_unit; count | outer_unit -------+------------ 9 | 1000 4413 | (2 rows) ``` ### Note The issue might be related to https://github.com/netbox-community/netbox/issues/3967

adam added the type: bug status: accepted labels 2025-12-29 18:27:04 +01:00

adam closed this issue

2025-12-29 18:27:04 +01:00

adam commented

2025-12-29 18:27:05 +01:00

@DanSheps commented on GitHub (Jan 30, 2020):

I just checked, the migration is there so this will need a test migration from 2.6.x, I will check later this afternoon and let you know

@DanSheps commented on GitHub (Jan 30, 2020): I just checked, the migration is there so this will need a test migration from 2.6.x, I will check later this afternoon and let you know

adam commented

2025-12-29 18:27:05 +01:00

@jeremystretch commented on GitHub (Jan 30, 2020):

Yep, I see the issue. There's a typo in rack_outer_unit_to_slug(), similar to #4027. Will be fixed in the next release. Yet another example of something that should have been caught during the v2.7 beta, unfortunately.

As an immediate workaround, you can do this:

$ ./manage.py nbshell
### NetBox interactive shell (jstretch-workstation)
### Python 3.6.9 | Django 2.2.9 | NetBox 2.7.4-dev
### lsmodels() will show available models. Use help(<model>) for more info.
>>> Rack.objects.filter(outer_unit='1000').update(outer_unit='mm')
0
>>> Rack.objects.filter(outer_unit='2000').update(outer_unit='in')
0

(The number returned by either command indicates the number of rows that were updated.)

@jeremystretch commented on GitHub (Jan 30, 2020): Yep, I see the issue. There's a typo in `rack_outer_unit_to_slug()`, similar to #4027. Will be fixed in the next release. Yet another example of something that should have been caught during the v2.7 beta, unfortunately. As an immediate workaround, you can do this: ``` $ ./manage.py nbshell ### NetBox interactive shell (jstretch-workstation) ### Python 3.6.9 | Django 2.2.9 | NetBox 2.7.4-dev ### lsmodels() will show available models. Use help(<model>) for more info. >>> Rack.objects.filter(outer_unit='1000').update(outer_unit='mm') 0 >>> Rack.objects.filter(outer_unit='2000').update(outer_unit='in') 0 ``` (The number returned by either command indicates the number of rows that were updated.)

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#3247