Issue Resolved: Logs Explorer Not Showing Logs
TLDR Henri reported logs not displaying in explorer. nitya-signoz identified issue as incomplete migration in otel collector. Upon correction, issue was resolved.
nitya-signoz
Fri, 17 Nov 2023 09:01:44 UTCThis means your otel collector migrator didn’t run successfully and the corresponding migration was not complete.
nitya-signoz
Fri, 17 Nov 2023 09:01:52 UTCAre you running on docker or kubernetes.
Henri
Fri, 17 Nov 2023 09:02:09 UTCDocker
nitya-signoz
Fri, 17 Nov 2023 09:02:43 UTCcan you check logs of `otel-collector-migrator` ? and try rerunning the container as well ?
Henri
Fri, 17 Nov 2023 09:04:38 UTCI see now that we do not have the migrator. Was this added recently? We'll add it and report back. Thanks for the quick response! :slightly_smiling_face:
nitya-signoz
Fri, 17 Nov 2023 09:04:54 UTCyeah it was added recently.
Henri
Fri, 17 Nov 2023 11:24:47 UTCThat was it! Now I see the logs again :pray:
SigNoz Community
Indexed 1060 threads
Built with ClickHouse as datastore, SigNoz is an open-source APM to help you find issues in your deployed applications & solve them quickly | Knowledge Base powered by Struct.AI
View in App
Henri
Fri, 17 Nov 2023 08:48:46 UTCHi, Logs explorer no longer shows any logs in the list view. Currently have installed v0.34.0. I believe this was happening already in v0.33.1. We see this happening in the developer tools console. <@4K3c8e> ```Error: API responded with 400 - encountered multiple errors: error in query-A: code: 47, message: Missing columns: 'attributes_bool_key' 'attributes_bool_value' while processing query: 'SELECT timestamp, id, trace_id, span_id, trace_flags, severity_text, severity_number, body, CAST((attributes_string_key, attributes_string_value), 'Map(String, String)') AS attributes_string, CAST((attributes_int64_key, attributes_int64_value), 'Map(String, Int64)') AS attributes_int64, CAST((attributes_float64_key, attributes_float64_value), 'Map(String, Float64)') AS attributes_float64, CAST((attributes_bool_key, attributes_bool_value), 'Map(String, Bool)') AS attributes_bool, CAST((resources_string_key, resources_string_value), 'Map(String, String)') AS resources_string FROM signoz_logs.distributed_logs WHERE (timestamp >= 1700208960000000000) AND (timestamp <= 1700210760000000000) ORDER BY timestamp DESC LIMIT 0, 100', required columns: 'trace_id' 'span_id' 'attributes_bool_value' 'timestamp' 'id' 'body' 'trace_flags' 'severity_number' 'attributes_int64_key' 'attributes_float64_value' 'resources_string_value' 'resources_string_key' 'severity_text' 'attributes_string_key' 'attributes_int64_value' 'attributes_string_value' 'attributes_float64_key' 'attributes_bool_key', maybe you meant: 'trace_id', 'span_id', 'attributes_int64_value', 'timestamp', 'id', 'body', 'trace_flags', 'severity_number', 'attributes_int64_key', 'attributes_float64_value', 'resources_string_value', 'resources_string_key', 'severity_text', 'attributes_string_key', 'attributes_string_value' or 'attributes_float64_key' at src_lib_dashboard_getQueryResults_ts.8141b02d95bd8fc761e7.js:2:15653 at p (src_lib_dashboard_getQueryResults_ts.8141b02d95bd8fc761e7.js:2:9155) at Generator. (src_lib_dashboard_getQueryResults_ts.8141b02d95bd8fc761e7.js:2:10501)
at Generator.next (src_lib_dashboard_getQueryResults_ts.8141b02d95bd8fc761e7.js:2:9584)
at f (src_lib_dashboard_getQueryResults_ts.8141b02d95bd8fc761e7.js:2:15070)
at i (src_lib_dashboard_getQueryResults_ts.8141b02d95bd8fc761e7.js:2:16239)```