bug(core-elx): Interface graph upsert failed #915

New issue

Closed

opened 2026-03-28 04:29:51 +00:00 by mfreeman451 · 1 comment

mfreeman451 commented

2026-03-28 04:29:51 +00:00

Owner

Imported from GitHub.

Original GitHub issue: #2612
Original author: @mfreeman451
Original URL: https://github.com/carverauto/serviceradar/issues/2612
Original created: 2026-01-30T16:31:14Z

Describe the bug

core-elx 16:30:37.742 [warning] Interface graph upsert failed: %Postgrex.Error{message: nil, postgres: %{code: :insufficient_privilege, line: "2812", message: "permission denied for schema serv
iceradar", position: "92", file: "aclchk.c", unknown: "ERROR", severity: "ERROR", pg_code: "42501", routine: "aclcheck_error"}, connection_id: 185240, query: "SELECT ag_catalog.agtype_to_text(v)\nFROM ag_catalog.cypher('serviceradar', $sr_188082be7fc4$MERGE (d:Device {id: 'sr:7588d12c-e8da-4b9e-a21d-8cc5c7faef38'})\nMERGE (i:Interface {id: 'sr:7588d12c-e8da-4b9e-a21d-8cc5c7faef38/eth1'})\nSET i.device_id = 'sr:7588d12c-e8da-4b9e-a21d-8cc5c7faef38'\nSET i.name = 'eth1'\nSET i.ifindex = 16\nSET i.descr = 'eth1'\n\nSET i.mac = '0c:ea:14:32:d2:78'\nSET i.ip_addresses = []\nMER
GE (d)-[r:HAS_INTERFACE]->(i)\nSET r.source = 'mapper'\n$sr_188082be7fc4$) AS (v agtype)\n"}                                                                                                     core-elx 16:30:37.743 [warning] Interface graph upsert failed: %Postgrex.Error{message: nil, postgres: %{code: :insufficient_privilege, line: "2812", message: "permission denied for schema serviceradar", position: "92", file: "aclchk.c", unknown: "ERROR", severity: "ERROR", pg_code: "42501", routine: "aclcheck_error"}, connection_id: 185238, query: "SELECT ag_catalog.agtype_to_text(v
)\nFROM ag_catalog.cypher('serviceradar', $sr_36bcc9cddbdd$MERGE (d:Device {id: 'sr:7588d12c-e8da-4b9e-a21d-8cc5c7faef38'})\nMERGE (i:Interface {id: 'sr:7588d12c-e8da-4b9e-a21d-8cc5c7faef38/eth8.202'})\nSET i.device_id = 'sr:7588d12c-e8da-4b9e-a21d-8cc5c7faef38'\nSET i.name = 'eth8.202'\nSET i.ifindex = 29\nSET i.descr = 'eth8.202'\n\nSET i.mac = '0c:ea:14:32:d2:7f'\nSET i.ip_addresses = []\nMERGE (d)-[r:HAS_INTERFACE]->(i)\nSET r.source = 'mapper'\n$sr_36bcc9cddbdd$) AS (v agtype)\n"}

To Reproduce
Steps to reproduce the behavior:

Go to '...'
Click on '....'
Scroll down to '....'
See error

Expected behavior
A clear and concise description of what you expected to happen.

Screenshots
If applicable, add screenshots to help explain your problem.

Desktop (please complete the following information):

OS: [e.g. iOS]
Browser [e.g. chrome, safari]
Version [e.g. 22]

Smartphone (please complete the following information):

Device: [e.g. iPhone6]
OS: [e.g. iOS8.1]
Browser [e.g. stock browser, safari]
Version [e.g. 22]

Additional context
Add any other context about the problem here.

Imported from GitHub. Original GitHub issue: #2612 Original author: @mfreeman451 Original URL: https://github.com/carverauto/serviceradar/issues/2612 Original created: 2026-01-30T16:31:14Z --- **Describe the bug** ``` core-elx 16:30:37.742 [warning] Interface graph upsert failed: %Postgrex.Error{message: nil, postgres: %{code: :insufficient_privilege, line: "2812", message: "permission denied for schema serv iceradar", position: "92", file: "aclchk.c", unknown: "ERROR", severity: "ERROR", pg_code: "42501", routine: "aclcheck_error"}, connection_id: 185240, query: "SELECT ag_catalog.agtype_to_text(v)\nFROM ag_catalog.cypher('serviceradar', $sr_188082be7fc4$MERGE (d:Device {id: 'sr:7588d12c-e8da-4b9e-a21d-8cc5c7faef38'})\nMERGE (i:Interface {id: 'sr:7588d12c-e8da-4b9e-a21d-8cc5c7faef38/eth1'})\nSET i.device_id = 'sr:7588d12c-e8da-4b9e-a21d-8cc5c7faef38'\nSET i.name = 'eth1'\nSET i.ifindex = 16\nSET i.descr = 'eth1'\n\nSET i.mac = '0c:ea:14:32:d2:78'\nSET i.ip_addresses = []\nMER GE (d)-[r:HAS_INTERFACE]->(i)\nSET r.source = 'mapper'\n$sr_188082be7fc4$) AS (v agtype)\n"} core-elx 16:30:37.743 [warning] Interface graph upsert failed: %Postgrex.Error{message: nil, postgres: %{code: :insufficient_privilege, line: "2812", message: "permission denied for schema serviceradar", position: "92", file: "aclchk.c", unknown: "ERROR", severity: "ERROR", pg_code: "42501", routine: "aclcheck_error"}, connection_id: 185238, query: "SELECT ag_catalog.agtype_to_text(v )\nFROM ag_catalog.cypher('serviceradar', $sr_36bcc9cddbdd$MERGE (d:Device {id: 'sr:7588d12c-e8da-4b9e-a21d-8cc5c7faef38'})\nMERGE (i:Interface {id: 'sr:7588d12c-e8da-4b9e-a21d-8cc5c7faef38/eth8.202'})\nSET i.device_id = 'sr:7588d12c-e8da-4b9e-a21d-8cc5c7faef38'\nSET i.name = 'eth8.202'\nSET i.ifindex = 29\nSET i.descr = 'eth8.202'\n\nSET i.mac = '0c:ea:14:32:d2:7f'\nSET i.ip_addresses = []\nMERGE (d)-[r:HAS_INTERFACE]->(i)\nSET r.source = 'mapper'\n$sr_36bcc9cddbdd$) AS (v agtype)\n"} ``` **To Reproduce** Steps to reproduce the behavior: 1. Go to '...' 2. Click on '....' 3. Scroll down to '....' 4. See error **Expected behavior** A clear and concise description of what you expected to happen. **Screenshots** If applicable, add screenshots to help explain your problem. **Desktop (please complete the following information):** - OS: [e.g. iOS] - Browser [e.g. chrome, safari] - Version [e.g. 22] **Smartphone (please complete the following information):** - Device: [e.g. iPhone6] - OS: [e.g. iOS8.1] - Browser [e.g. stock browser, safari] - Version [e.g. 22] **Additional context** Add any other context about the problem here.

mfreeman451 added this to the 1.1.0 milestone

2026-03-28 04:29:51 +00:00

mfreeman451 commented

2026-03-28 04:29:51 +00:00

Author

Owner

Imported GitHub comment.

Original author: @mfreeman451
Original URL: https://github.com/carverauto/serviceradar/issues/2612#issuecomment-3844774325
Original created: 2026-02-04T01:47:08Z

Still seeing this:

core-elx 01:45:18.017 [warning] Interface graph upsert failed: %Postgrex.Error{message: nil, postgres: %{code: :insufficient_privilege, line: "2812", message: "permission denied for schema serv
iceradar", position: "92", file: "aclchk.c", unknown: "ERROR", severity: "ERROR", pg_code: "42501", routine: "aclcheck_error"}, connection_id: 816036, query: "SELECT ag_catalog.agtype_to_text(v
)\nFROM ag_catalog.cypher('serviceradar', $sr_7ff47b5346bd$MERGE (d:Device {id: 'sr:7588d12c-e8da-4b9e-a21d-8cc5c7faef38'})\nMERGE (i:Interface {id: 'sr:7588d12c-e8da-4b9e-a21d-8cc5c7faef38/eth
4'})\nSET i.device_id = 'sr:7588d12c-e8da-4b9e-a21d-8cc5c7faef38'\nSET i.name = 'eth4'\nSET i.ifindex = 19\nSET i.descr = 'eth4'\n\nSET i.mac = '0c:ea:14:32:d2:7b'\nSET i.ip_addresses = []\nMER
GE (d)-[r:HAS_INTERFACE]->(i)\nSET r.source = 'mapper'\n$sr_7ff47b5346bd$) AS (v agtype)\n"}
core-elx 01:45:18.018 [warning] Interface graph upsert failed: %Postgrex.Error{message: nil, postgres: %{code: :insufficient_privilege, line: "2812", message: "permission denied for schema serv
iceradar", position: "92", file: "aclchk.c", unknown: "ERROR", severity: "ERROR", pg_code: "42501", routine: "aclcheck_error"}, connection_id: 816038, query: "SELECT ag_catalog.agtype_to_text(v
)\nFROM ag_catalog.cypher('serviceradar', $sr_3d824a079316$MERGE (d:Device {id: 'sr:7588d12c-e8da-4b9e-a21d-8cc5c7faef38'})\nMERGE (i:Interface {id: 'sr:7588d12c-e8da-4b9e-a21d-8cc5c7faef38/swi
tch0.104'})\nSET i.device_id = 'sr:7588d12c-e8da-4b9e-a21d-8cc5c7faef38'\nSET i.name = 'switch0.104'\nSET i.ifindex = 34\nSET i.descr = 'switch0.104'\n\nSET i.mac = '0e:ea:14:32:d2:78'\nSET i.i
p_addresses = []\nMERGE (d)-[r:HAS_INTERFACE]->(i)\nSET r.source = 'mapper'\n$sr_3d824a079316$) AS (v agtype)\n"}
core-elx 01:45:18.019 [warning] Interface graph upsert failed: %Postgrex.Error{message: nil, postgres: %{code: :insufficient_privilege, line: "2812", message: "permission denied for schema serv
iceradar", position: "92", file: "aclchk.c", unknown: "ERROR", severity: "ERROR", pg_code: "42501", routine: "aclcheck_error"}, connection_id: 816004, query: "SELECT ag_catalog.agtype_to_text(v
)\nFROM ag_catalog.cypher('serviceradar', $sr_0c9202db9c95$MERGE (d:Device {id: 'sr:7588d12c-e8da-4b9e-a21d-8cc5c7faef38'})\nMERGE (i:Interface {id: 'sr:7588d12c-e8da-4b9e-a21d-8cc5c7faef38/Ann
apurna Labs Ltd. SFP+ 10G Ethernet Adapter'})\nSET i.device_id = 'sr:7588d12c-e8da-4b9e-a21d-8cc5c7faef38'\nSET i.name = 'Annapurna Labs Ltd. SFP+ 10G Ethernet Adapter'\nSET i.ifindex = 3\nSET
i.descr = 'Annapurna Labs Ltd. SFP+ 10G Ethernet Adapter'\n\nSET i.mac = '0c:ea:14:32:d2:80'\nSET i.ip_addresses = ['216.17.46.98']\nMERGE (d)-[r:HAS_INTERFACE]->(i)\nSET r.source = 'mapper'\n$
sr_0c9202db9c95$) AS (v agtype)\n"}

not sure why it is trying to do things in the 'serviceradar' schema, should be platform.

Imported GitHub comment. Original author: @mfreeman451 Original URL: https://github.com/carverauto/serviceradar/issues/2612#issuecomment-3844774325 Original created: 2026-02-04T01:47:08Z --- Still seeing this: ``` core-elx 01:45:18.017 [warning] Interface graph upsert failed: %Postgrex.Error{message: nil, postgres: %{code: :insufficient_privilege, line: "2812", message: "permission denied for schema serv iceradar", position: "92", file: "aclchk.c", unknown: "ERROR", severity: "ERROR", pg_code: "42501", routine: "aclcheck_error"}, connection_id: 816036, query: "SELECT ag_catalog.agtype_to_text(v )\nFROM ag_catalog.cypher('serviceradar', $sr_7ff47b5346bd$MERGE (d:Device {id: 'sr:7588d12c-e8da-4b9e-a21d-8cc5c7faef38'})\nMERGE (i:Interface {id: 'sr:7588d12c-e8da-4b9e-a21d-8cc5c7faef38/eth 4'})\nSET i.device_id = 'sr:7588d12c-e8da-4b9e-a21d-8cc5c7faef38'\nSET i.name = 'eth4'\nSET i.ifindex = 19\nSET i.descr = 'eth4'\n\nSET i.mac = '0c:ea:14:32:d2:7b'\nSET i.ip_addresses = []\nMER GE (d)-[r:HAS_INTERFACE]->(i)\nSET r.source = 'mapper'\n$sr_7ff47b5346bd$) AS (v agtype)\n"} core-elx 01:45:18.018 [warning] Interface graph upsert failed: %Postgrex.Error{message: nil, postgres: %{code: :insufficient_privilege, line: "2812", message: "permission denied for schema serv iceradar", position: "92", file: "aclchk.c", unknown: "ERROR", severity: "ERROR", pg_code: "42501", routine: "aclcheck_error"}, connection_id: 816038, query: "SELECT ag_catalog.agtype_to_text(v )\nFROM ag_catalog.cypher('serviceradar', $sr_3d824a079316$MERGE (d:Device {id: 'sr:7588d12c-e8da-4b9e-a21d-8cc5c7faef38'})\nMERGE (i:Interface {id: 'sr:7588d12c-e8da-4b9e-a21d-8cc5c7faef38/swi tch0.104'})\nSET i.device_id = 'sr:7588d12c-e8da-4b9e-a21d-8cc5c7faef38'\nSET i.name = 'switch0.104'\nSET i.ifindex = 34\nSET i.descr = 'switch0.104'\n\nSET i.mac = '0e:ea:14:32:d2:78'\nSET i.i p_addresses = []\nMERGE (d)-[r:HAS_INTERFACE]->(i)\nSET r.source = 'mapper'\n$sr_3d824a079316$) AS (v agtype)\n"} core-elx 01:45:18.019 [warning] Interface graph upsert failed: %Postgrex.Error{message: nil, postgres: %{code: :insufficient_privilege, line: "2812", message: "permission denied for schema serv iceradar", position: "92", file: "aclchk.c", unknown: "ERROR", severity: "ERROR", pg_code: "42501", routine: "aclcheck_error"}, connection_id: 816004, query: "SELECT ag_catalog.agtype_to_text(v )\nFROM ag_catalog.cypher('serviceradar', $sr_0c9202db9c95$MERGE (d:Device {id: 'sr:7588d12c-e8da-4b9e-a21d-8cc5c7faef38'})\nMERGE (i:Interface {id: 'sr:7588d12c-e8da-4b9e-a21d-8cc5c7faef38/Ann apurna Labs Ltd. SFP+ 10G Ethernet Adapter'})\nSET i.device_id = 'sr:7588d12c-e8da-4b9e-a21d-8cc5c7faef38'\nSET i.name = 'Annapurna Labs Ltd. SFP+ 10G Ethernet Adapter'\nSET i.ifindex = 3\nSET i.descr = 'Annapurna Labs Ltd. SFP+ 10G Ethernet Adapter'\n\nSET i.mac = '0c:ea:14:32:d2:80'\nSET i.ip_addresses = ['216.17.46.98']\nMERGE (d)-[r:HAS_INTERFACE]->(i)\nSET r.source = 'mapper'\n$ sr_0c9202db9c95$) AS (v agtype)\n"} ``` not sure why it is trying to do things in the 'serviceradar' schema, should be `platform`.

mfreeman451 closed this issue

2026-03-28 04:29:51 +00:00