bug(srql): SNMP query is broken #387

New issue

Closed

opened 2026-03-28 04:24:05 +00:00 by mfreeman451 · 0 comments

mfreeman451 commented

2026-03-28 04:24:05 +00:00

Owner

Imported from GitHub.

Original GitHub issue: #1188
Original author: @mfreeman451
Original URL: https://github.com/carverauto/serviceradar/issues/1188
Original created: 2025-07-07T06:13:08Z

Jul 07 06:10:25 demo-staging node[64370]: Fetching SNMP status for 10 devices using SRQL
Jul 07 06:10:25 demo-staging node[64370]: SNMP SRQL query failed: 500 {"message":"failed to execute query: query error: failed to execute query: code: 47, message: Missing columns: 'oid_name' while processing query: 'SELECT\n  timestamp, poller_id, agent_id, metric_name, metric_type, device_id, value, unit, tags, partition, scale, is_delta, target_device_ip, ifIndex, metadata, _tp_time\nFROM\n  table(timeseries_metrics)\nWHERE\n  (timestamp \u003e= '2025-07-07T04:10:25.197Z') AND (device_id IN ('default:192.168.10.1', 'default:192.168.2.1', 'default:192.168.2.10', 'default:192.168.2.11', 'default:192.168.2.12', 'default:192.168.2.13', 'default:192.168.2.14', 'default:192.168.2.18', 'default:192.168.2.19', 'default:192.168.2.23')) AND (metric_type = 'snmp')\nORDER BY\n  timestamp DESC, oid_name DESC\nLIMIT 10', required columns: 'poller_id' 'agent_id' 'metric_name' 'timestamp' 'metric_type' 'device_id' 'unit' 'is_delta' 'oid_name' '_tp_time' 'target_device_ip' 'scale' 'value' 'tags' 'partition' 'ifIndex' 'metadata', maybe you meant: ['poller_id','agent_id','metric_name','timestamp','metric_type','device_id','unit','is_delta','_tp_time','target_device_ip','scale','value','tags','partition','ifIndex','metadata']","status":500}
Jul 07 06:10:25 demo-staging node[64370]: SNMP SRQL query failed, returning no devices with metrics

Imported from GitHub. Original GitHub issue: #1188 Original author: @mfreeman451 Original URL: https://github.com/carverauto/serviceradar/issues/1188 Original created: 2025-07-07T06:13:08Z --- ``` Jul 07 06:10:25 demo-staging node[64370]: Fetching SNMP status for 10 devices using SRQL Jul 07 06:10:25 demo-staging node[64370]: SNMP SRQL query failed: 500 {"message":"failed to execute query: query error: failed to execute query: code: 47, message: Missing columns: 'oid_name' while processing query: 'SELECT\n timestamp, poller_id, agent_id, metric_name, metric_type, device_id, value, unit, tags, partition, scale, is_delta, target_device_ip, ifIndex, metadata, _tp_time\nFROM\n table(timeseries_metrics)\nWHERE\n (timestamp \u003e= '2025-07-07T04:10:25.197Z') AND (device_id IN ('default:192.168.10.1', 'default:192.168.2.1', 'default:192.168.2.10', 'default:192.168.2.11', 'default:192.168.2.12', 'default:192.168.2.13', 'default:192.168.2.14', 'default:192.168.2.18', 'default:192.168.2.19', 'default:192.168.2.23')) AND (metric_type = 'snmp')\nORDER BY\n timestamp DESC, oid_name DESC\nLIMIT 10', required columns: 'poller_id' 'agent_id' 'metric_name' 'timestamp' 'metric_type' 'device_id' 'unit' 'is_delta' 'oid_name' '_tp_time' 'target_device_ip' 'scale' 'value' 'tags' 'partition' 'ifIndex' 'metadata', maybe you meant: ['poller_id','agent_id','metric_name','timestamp','metric_type','device_id','unit','is_delta','_tp_time','target_device_ip','scale','value','tags','partition','ifIndex','metadata']","status":500} Jul 07 06:10:25 demo-staging node[64370]: SNMP SRQL query failed, returning no devices with metrics ```

Rows
Columns