bug(web-ui): search w/ partition is broken #382

New issue

Open

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

mfreeman451 commented

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

Owner

Imported from GitHub.

Original GitHub issue: #1168
Original author: @mfreeman451
Original URL: https://github.com/carverauto/serviceradar/issues/1168
Original created: 2025-06-29T02:46:22Z

API request failed: 500 - {"message":"failed to execute query: query error: failed to execute query: code: 47, message: Missing columns: 'partition' while processing query: 'SELECT\n device_id, ip, poller_id, hostname, mac, discovery_sources, is_available, first_seen, last_seen, metadata, agent_id, device_type, service_type, service_status, last_heartbeat, os_info, version_info, _tp_time\nFROM\n table(unified_devices)\nWHERE\n partition = 'default'\nORDER BY\n _tp_time DESC, ip DESC\nLIMIT 20', required columns: 'device_id' 'ip' 'poller_id' 'discovery_sources' 'device_type' 'metadata' 'service_type' 'agent_id' 'mac' 'hostname' 'last_heartbeat' 'os_info' 'is_available' 'first_seen' '_tp_time' 'service_status' 'version_info' 'last_seen' 'partition', maybe you meant: ['device_id','ip','poller_id','discovery_sources','device_type','metadata','service_type','agent_id','mac','hostname','last_heartbeat','os_info','is_available','first_seen','_tp_time','service_status','version_info','last_seen']","status":500}

Imported from GitHub. Original GitHub issue: #1168 Original author: @mfreeman451 Original URL: https://github.com/carverauto/serviceradar/issues/1168 Original created: 2025-06-29T02:46:22Z --- ```API request failed: 500 - {"message":"failed to execute query: query error: failed to execute query: code: 47, message: Missing columns: 'partition' while processing query: 'SELECT\n device_id, ip, poller_id, hostname, mac, discovery_sources, is_available, first_seen, last_seen, metadata, agent_id, device_type, service_type, service_status, last_heartbeat, os_info, version_info, _tp_time\nFROM\n table(unified_devices)\nWHERE\n partition = 'default'\nORDER BY\n _tp_time DESC, ip DESC\nLIMIT 20', required columns: 'device_id' 'ip' 'poller_id' 'discovery_sources' 'device_type' 'metadata' 'service_type' 'agent_id' 'mac' 'hostname' 'last_heartbeat' 'os_info' 'is_available' 'first_seen' '_tp_time' 'service_status' 'version_info' 'last_seen' 'partition', maybe you meant: ['device_id','ip','poller_id','discovery_sources','device_type','metadata','service_type','agent_id','mac','hostname','last_heartbeat','os_info','is_available','first_seen','_tp_time','service_status','version_info','last_seen']","status":500}```

Rows
Columns