hyperdx icon indicating copy to clipboard operation
hyperdx copied to clipboard

UI: Can't open log detailed info

Open msotnikov opened this issue 4 months ago • 0 comments

Some messsages contains quotes, and it cannot be opened because the query can't find it. The query looks like below. A commented part queries non-existent data. Btw, might be better to search using Body here?

Fields ScopeAttributes and LogAttributes have JSON type.

SELECT *
,Timestamp AS "__hdx_timestamp"
,Body AS "__hdx_body"
,TraceId AS "__hdx_trace_id"
,SpanId AS "__hdx_span_id"
,SeverityText AS "__hdx_severity_text"
,ServiceName AS "__hdx_service_name"
,ResourceAttributes AS "__hdx_resource_attributes"
,LogAttributes AS "__hdx_event_attributes" FROM otel_distributed.otel_logs 
WHERE (Timestamp=parseDateTime64BestEffort('2025-08-28T09:53:47.737000000Z', 9) 
AND ServiceName='postgresql' AND SeverityText='fatal' 
------
--AND toString(LogAttributes.message)='pg_hba.conf rejects connection for host \\\"10.8.7.20\\\", user \\\"hidden_user\\\", database \\\"hidden\\\", no encryption' 
-------
AND toString(ResourceAttributes.service.instance.id)='hidden:5432' 
AND toDateTime(Timestamp)=parseDateTime64BestEffort('2025-08-28T09:53:47Z', 9)) LIMIT 1

Image

Image

msotnikov avatar Aug 28 '25 10:08 msotnikov