Replies: 2 comments 2 replies
-
|
This is weird. It works fine for me on a system migrated from 2.11.12 to 3.0.1:
A number of small bugs were fixed in 3.0.1, although I don't see this referred to in the release notes it might be worth upgrading before continuing. I cannot see why deleting and recreating the device identically would make a difference. Did you trim your API results? I see much more (e.g. interface types). Is it possible there was a cable between the devices, and it's showing interfaces where the other end is the same device_id? (I'm just clutching at straws here) And are you 100% sure you didn't have a URL typo like |
Beta Was this translation helpful? Give feedback.
1 reply
-
|
@candlerb
The problems occurs again:
{
"count": 2,
"next": null,
"previous": null,
"results": [
{
"id": 27339,
"url": "https://netbox-instance.it/api/dcim/interfaces/27339/",
"display": "Ethernet1/1",
"device": {
"id": 364,
"url": "https://netbox-instance.it/api/dcim/devices/364/",
"display": "nexus1",
"name": "nexus1"
},
"name": "Ethernet1/1",
"label": "",
"type": {
"value": "other",
"label": "Other"
},
"enabled": true,
"parent": null,
"lag": null,
"mtu": null,
"mac_address": "8C:60:60:60:60:88",
"mgmt_only": false,
"description": "test interface",
"mode": {
"value": "access",
"label": "Access"
},
"untagged_vlan": {
"id": 3389,
"url": "https://netbox-instance.it/api/ipam/vlans/3389/",
"display": "test_vlan (102)",
"vid": 102,
"name": "test_vlan"
},
"tagged_vlans": [],
"mark_connected": false,
"cable": null,
"cable_peer": null,
"cable_peer_type": null,
"connected_endpoint": null,
"connected_endpoint_type": null,
"connected_endpoint_reachable": null,
"tags": [],
"custom_fields": {},
"created": "2021-08-27",
"last_updated": "2021-08-27T05:05:44.495255Z",
"count_ipaddresses": 0,
"_occupied": false
},
{
"id": 27638,
"url": "https://netbox-instance.it/api/dcim/interfaces/27638/",
"display": "Ethernet1/1",
"device": {
"id": 365,
"url": "https://netbox-instance.it/api/dcim/devices/365/",
"display": "nexus2",
"name": "nexus2"
},
"name": "Ethernet1/1",
"label": "",
"type": {
"value": "other",
"label": "Other"
},
"enabled": true,
"parent": null,
"lag": null,
"mtu": null,
"mac_address": "8C:88:88:88:88:28",
"mgmt_only": false,
"description": "test interface",
"mode": {
"value": "access",
"label": "Access"
},
"untagged_vlan": {
"id": 3389,
"url": "https://netbox-instance.it/api/ipam/vlans/3389/",
"display": "test_vlan (102)",
"vid": 102,
"name": "test_vlan"
},
"tagged_vlans": [],
"mark_connected": false,
"cable": null,
"cable_peer": null,
"cable_peer_type": null,
"connected_endpoint": null,
"connected_endpoint_type": null,
"connected_endpoint_reachable": null,
"tags": [],
"custom_fields": {},
"created": "2021-08-27",
"last_updated": "2021-08-27T05:10:56.713074Z",
"count_ipaddresses": 0,
"_occupied": false
}
]
}I don't really now how to troubleshoot this problem Netbox log outputSQL output when API called// This returns 1 record: the device with id 364
SELECT "dcim_device"."created",
"dcim_device"."last_updated",
"dcim_device"."custom_field_data",
"dcim_device"."id",
"dcim_device"."local_context_data",
"dcim_device"."device_type_id",
"dcim_device"."device_role_id",
"dcim_device"."tenant_id",
"dcim_device"."platform_id",
"dcim_device"."name",
"dcim_device"."_name",
"dcim_device"."serial",
"dcim_device"."asset_tag",
"dcim_device"."site_id",
"dcim_device"."location_id",
"dcim_device"."rack_id",
"dcim_device"."position",
"dcim_device"."face",
"dcim_device"."status",
"dcim_device"."primary_ip4_id",
"dcim_device"."primary_ip6_id",
"dcim_device"."cluster_id",
"dcim_device"."virtual_chassis_id",
"dcim_device"."vc_position",
"dcim_device"."vc_priority",
"dcim_device"."comments"
FROM "dcim_device"
WHERE "dcim_device"."id" = 364
LIMIT 21;
// This returns 594 records: interface IDs - trimmed in next selects
SELECT "dcim_interface"."id"
FROM "dcim_interface"
INNER JOIN "dcim_device"
ON ( "dcim_interface"."device_id" = "dcim_device"."id" )
WHERE ( "dcim_interface"."device_id" = 364
OR ( "dcim_device"."virtual_chassis_id" = 1
AND NOT "dcim_interface"."mgmt_only" ) )
ORDER BY "dcim_device"."_name" ASC,
"dcim_device"."id" ASC,
( "dcim_interface"."_name" ) COLLATE "C" ASC;
// Returns Count(*) = 2
SELECT Count(*)
FROM (SELECT DISTINCT "dcim_interface"."created" AS Col1,
"dcim_interface"."last_updated" AS Col2,
"dcim_interface"."custom_field_data" AS Col3,
"dcim_interface"."id" AS Col4,
"dcim_interface"."device_id" AS Col5,
"dcim_interface"."name" AS Col6,
"dcim_interface"."label" AS Col7,
"dcim_interface"."description" AS Col8,
"dcim_interface"."cable_id" AS Col9,
"dcim_interface"."_cable_peer_type_id" AS Col10,
"dcim_interface"."_cable_peer_id" AS Col11,
"dcim_interface"."mark_connected" AS Col12,
"dcim_interface"."_path_id" AS Col13,
"dcim_interface"."enabled" AS Col14,
"dcim_interface"."mac_address" AS Col15,
"dcim_interface"."mtu" AS Col16,
"dcim_interface"."mode" AS Col17,
"dcim_interface"."_name" AS Col18,
"dcim_interface"."parent_id" AS Col19,
"dcim_interface"."lag_id" AS Col20,
"dcim_interface"."type" AS Col21,
"dcim_interface"."mgmt_only" AS Col22,
"dcim_interface"."untagged_vlan_id" AS Col23
FROM "dcim_interface"
WHERE ( "dcim_interface"."name" = 'Ethernet1/1'
AND "dcim_interface"."id" IN ( 27339
"TRIMMED OUTPUT"
, 27739 ) )) subquery;
// RETURNS 2 Records - Device id 364 and 365 and interface Ethernet1/1
SELECT DISTINCT "dcim_interface"."created",
"dcim_interface"."last_updated",
"dcim_interface"."custom_field_data",
"dcim_interface"."id",
"dcim_interface"."device_id",
"dcim_interface"."name",
"dcim_interface"."label",
"dcim_interface"."description",
"dcim_interface"."cable_id",
"dcim_interface"."_cable_peer_type_id",
"dcim_interface"."_cable_peer_id",
"dcim_interface"."mark_connected",
"dcim_interface"."_path_id",
"dcim_interface"."enabled",
"dcim_interface"."mac_address",
"dcim_interface"."mtu",
"dcim_interface"."mode",
"dcim_interface"."_name",
"dcim_interface"."parent_id",
"dcim_interface"."lag_id",
"dcim_interface"."type",
"dcim_interface"."mgmt_only",
"dcim_interface"."untagged_vlan_id",
"dcim_device"."_name",
"dcim_device"."id",
( "dcim_interface"."_name" ) COLLATE "C"
FROM "dcim_interface"
INNER JOIN "dcim_device"
ON ( "dcim_interface"."device_id" = "dcim_device"."id" )
WHERE ( "dcim_interface"."name" = 'Ethernet1/1'
AND "dcim_interface"."id" IN ( 27339,
"TRIMMED OUTPUT"
27739 ) )
ORDER BY "dcim_device"."_name" ASC,
"dcim_device"."id" ASC,
( "dcim_interface"."_name" ) COLLATE "C" ASC
LIMIT 50;
// Returns device 364 and 365 - I suppose this IDs are taken from previous command
SELECT "dcim_device"."created",
"dcim_device"."last_updated",
"dcim_device"."custom_field_data",
"dcim_device"."id",
"dcim_device"."local_context_data",
"dcim_device"."device_type_id",
"dcim_device"."device_role_id",
"dcim_device"."tenant_id",
"dcim_device"."platform_id",
"dcim_device"."name",
"dcim_device"."_name",
"dcim_device"."serial",
"dcim_device"."asset_tag",
"dcim_device"."site_id",
"dcim_device"."location_id",
"dcim_device"."rack_id",
"dcim_device"."position",
"dcim_device"."face",
"dcim_device"."status",
"dcim_device"."primary_ip4_id",
"dcim_device"."primary_ip6_id",
"dcim_device"."cluster_id",
"dcim_device"."virtual_chassis_id",
"dcim_device"."vc_position",
"dcim_device"."vc_priority",
"dcim_device"."comments"
FROM "dcim_device"
WHERE "dcim_device"."id" IN ( 364, 365 )
ORDER BY "dcim_device"."_name" ASC,
"dcim_device"."id" ASC;
// Several sql calls follows, but I think the problem is in the fourth SQL query |
Beta Was this translation helpful? Give feedback.
-
|
Were these devices part of a virtual chassis by chance? |
Beta Was this translation helpful? Give feedback.
1 reply
-
|
You are right, both devices are a part of a
ON ( "dcim_interface"."device_id" = "dcim_device"."id" )
WHERE ( "dcim_interface"."device_id" = 364
OR ( "dcim_device"."virtual_chassis_id" = 1
AND NOT "dcim_interface"."mgmt_only" ) )After removing devices from the |
Beta Was this translation helpful? Give feedback.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
Problem
Hello,
i've just migrated from
Netbox v2.11.12toNetbox 3.0and frompostgres 12topostgres 13.After the migration the API call
api/dcim/interfaces/?device_id=364&name=Ethernet1%2F1returns multiple results (multiple devices) even if thedevice_idandinterface nameis specified.The result of API call:
{ "count": 2, "results": [ { "id": 27339, "url": "https://netbox.test/api/dcim/interfaces/27339/", "display": "Ethernet1/1", "device": { "id": 364, "url": "https://netbox.test/api/dcim/devices/364/", "display": "nexus1", "name": "nexus1" }, "name": "Ethernet1/1", }, { "id": 27638, "url": "https://netbox.test/api/dcim/interfaces/27638/", "display": "Ethernet1/1", "device": { "id": 365, "url": "https://netbox.test/api/dcim/devices/365/", "display": "nexus2", "name": "nexus2" }, "name": "Ethernet1/1", } ] }As can be seen, the interface name matches, but the device_id is returned for devices 364 (nexus1) and 365 (nexus2) even if the
device_id = 365is in the call.Quick fix
I've removed both devices (nexus1 and nexus2) and then I create them again in the Netbox. After the "re-creation" it works fine. But I don't want to recreate all devices, because I don't know where the problem could appear again. Also a lot of changelogs is generated when recreating devices.
My Postgres migration process
Netbox v2.11.12 + Postgre 12- database backup (SQL)Netbox v.3.0 + Postgre 13- clean database createdNetbox v3.0migrationsQuestion
What could cause the problem with the API call?
Beta Was this translation helpful? Give feedback.
All reactions