Exception Attributes Query in ClickHouse Table
TLDR Vishnu needed help locating exception attributes in ClickHouse table. Srikanth confirmed that the attributes are stored in signoz_index_v2
, not the exceptions table, and recommended creating an issue for further development.
May 11, 2023 (7 months ago)
Vishnu
03:52 PMI want to create dashboard/query for the exceptions recorded grouped by a custom field like userId/tenantId.
While recording the exception in the application, we have the option to pass Attributes with opentelemetry.
Span.current().recordException(throwable, Attributes.of(AttributeKey.stringKey("userId"), userId));
Can you please let me know which table in clickhouse will store this attribute or query to achieve the above. I checked in signoz_traces.signoz_error_index_v2 table.
Also please share if there is any documentation on the database schema for clickhouse.
May 12, 2023 (7 months ago)
Srikanth
02:18 AMYou are looking at the right table
Vishnu
08:43 AMSrikanth
03:37 PMVishnu
05:03 PMMay 15, 2023 (7 months ago)
Vishnu
04:35 AMSrikanth
04:48 AMsignoz_index_v2
which has stringified event json.Vishnu
04:54 AMSrikanth
06:46 AMVishnu
07:22 AMDone Srikanth, let me know if i need to update anything here.
SigNoz Community
Indexed 1023 threads (61% resolved)
Similar Threads
Issues with SigNoz Setup and Data Persistence in AKS
Vaibhavi experienced issues setting up SigNoz in AKS, and faced data persistence issues after installation. Srikanth provided guidance on ClickHouse version compatibility and resource requirements, helping Vaibhavi troubleshoot and resolve the issue.
Kubernetes Signoz-otel-collector Issue and Clickhouse Cold Storage
Pruthvi faced an issue with Kubernetes signoz-otel-collector. nitya-signoz suggested deleting the `signoz_logs` database and restarting collectors. Pruthvi then asked about Clickhouse cold storage on S3 and observed a spike in cost, which Ankit agreed to investigate further.
Dashboard Load Issues and Possible Solutions
Al experiences dashboard loading issues since updating to `0.18.1`. Srikanth believes the issue is not version related and suggests examining queries, memory resources, and server distribution for improvements.
Issues with Installing Signoz on Standalone VM with Two Additional Disks
vvpreo is having difficulty installing Signoz on a standalone VM due to an issue with OTEL collector not starting because of migration problems. Ankit and vishal-signoz proposed various solutions, but the issue remained unresolved. They planned a screen-sharing session to resolve it.
Resolving Signoz Query Service Error
Einav encountered an error related to a missing table in the Signoz service which was preventing data visibility in the UI. Srikanth guided them to restart specific components and drop a database table, which resolved the issue.