bug(srql): broken queries #456

New issue

Closed

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

mfreeman451 commented

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

Owner

Imported from GitHub.

Original GitHub issue: #1386
Original author: @mfreeman451
Original URL: https://github.com/carverauto/serviceradar/issues/1386
Original created: 2025-07-27T23:21:16Z

SHOW logs WHERE level = 'error' ORDER BY timestamp DESC LIMIT 50

API request failed: 500 - {"message":"failed to execute query: query error: failed to execute query: code: 47, message: Missing columns: 'level' while processing query: 'SELECT\n  timestamp, trace_id, span_id, severity_text, severity_number, body, service_name, service_version, service_instance, scope_name, scope_version, attributes, resource_attributes, raw_data, _tp_time\nFROM\n  table(logs)\nWHERE\n  level = 'error'\nORDER BY\n  timestamp DESC, trace_id DESC\nLIMIT 51', required columns: 'timestamp' 'severity_text' 'severity_number' 'body' 'service_name' 'service_version' 'service_instance' 'trace_id' '_tp_time' 'scope_name' 'span_id' 'attributes' 'scope_version' 'resource_attributes' 'raw_data' 'level', maybe you meant: ['timestamp','severity_text','severity_number','body','service_name','service_version','service_instance','trace_id','_tp_time','scope_name','span_id','attributes','scope_version','resource_attributes','raw_data']","status":500}

FIND cpu_metrics WHERE utilization > 90

Results
FIND cpu_metrics WHERE utilization > 90
JSON
Table

20
_tp_time	agent_id	device_id	device_ip	if_admin_status	if_alias	if_descr	if_index	if_name	if_oper_status	if_phys_address	if_speed	ip_addresses	metadata	poller_id	timestamp
2025-07-27T23:19:39.498Z	default-agent	default:192.168.1.231	192.168.1.231	1		Port 2	2	Port 2	2	78:45:58:6d:1e:4b	0	[]	{"discovery_id":"540fb444-ca1e-4a8b-a85b-34c00d38f97d","discovery_time":"2025-07-27T22:40:51Z","if_type":"6"}	demo-staging	2025-07-27T23:19:39Z
2025-07-27T23:19:39.497Z	default-agent	default:192.168.1.231	192.168.1.231	1		Port 1	1	Port 1	1	78:45:58:6d:1e:4b	10000000000	["127.0.0.1"]	{"discovery_id":"540fb444-ca1e-4a8b-a85b-34c00d38f97d","discovery_time":"2025-07-27T22:40:51Z","if_type":"6"}	demo-staging	2025-07-27T23:19:39Z
2025-07-27T23:19:39.496Z	default-agent	default:192.168.1.231	192.168.1.231

Imported from GitHub. Original GitHub issue: #1386 Original author: @mfreeman451 Original URL: https://github.com/carverauto/serviceradar/issues/1386 Original created: 2025-07-27T23:21:16Z --- `SHOW logs WHERE level = 'error' ORDER BY timestamp DESC LIMIT 50` ``` API request failed: 500 - {"message":"failed to execute query: query error: failed to execute query: code: 47, message: Missing columns: 'level' while processing query: 'SELECT\n timestamp, trace_id, span_id, severity_text, severity_number, body, service_name, service_version, service_instance, scope_name, scope_version, attributes, resource_attributes, raw_data, _tp_time\nFROM\n table(logs)\nWHERE\n level = 'error'\nORDER BY\n timestamp DESC, trace_id DESC\nLIMIT 51', required columns: 'timestamp' 'severity_text' 'severity_number' 'body' 'service_name' 'service_version' 'service_instance' 'trace_id' '_tp_time' 'scope_name' 'span_id' 'attributes' 'scope_version' 'resource_attributes' 'raw_data' 'level', maybe you meant: ['timestamp','severity_text','severity_number','body','service_name','service_version','service_instance','trace_id','_tp_time','scope_name','span_id','attributes','scope_version','resource_attributes','raw_data']","status":500} ``` `FIND cpu_metrics WHERE utilization > 90` ``` Results FIND cpu_metrics WHERE utilization > 90 JSON Table 20 _tp_time agent_id device_id device_ip if_admin_status if_alias if_descr if_index if_name if_oper_status if_phys_address if_speed ip_addresses metadata poller_id timestamp 2025-07-27T23:19:39.498Z default-agent default:192.168.1.231 192.168.1.231 1 Port 2 2 Port 2 2 78:45:58:6d:1e:4b 0 [] {"discovery_id":"540fb444-ca1e-4a8b-a85b-34c00d38f97d","discovery_time":"2025-07-27T22:40:51Z","if_type":"6"} demo-staging 2025-07-27T23:19:39Z 2025-07-27T23:19:39.497Z default-agent default:192.168.1.231 192.168.1.231 1 Port 1 1 Port 1 1 78:45:58:6d:1e:4b 10000000000 ["127.0.0.1"] {"discovery_id":"540fb444-ca1e-4a8b-a85b-34c00d38f97d","discovery_time":"2025-07-27T22:40:51Z","if_type":"6"} demo-staging 2025-07-27T23:19:39Z 2025-07-27T23:19:39.496Z default-agent default:192.168.1.231 192.168.1.231 ```

Rows
Columns