#support

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.

Powered by Struct AI
May 11, 2023 (7 months ago)
Vishnu
Photo of md5-5b8bec7eb3801153a6bbb2ffec57863b
Vishnu
03:52 PM
Hi,
I 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
Photo of md5-ce04a9988e2fd758a659dc55be6f2543
Srikanth
02:18 AM
> 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.
You are looking at the right table
Vishnu
Photo of md5-5b8bec7eb3801153a6bbb2ffec57863b
Vishnu
08:43 AM
Srikanth Not able to find that field in this table, can you please let me know the column. There is a column of resourceTagsMap but that dosen't contain this
Srikanth
Photo of md5-ce04a9988e2fd758a659dc55be6f2543
Srikanth
03:37 PM
I just realised we are not storing all the exception attributes. This needs some development work. Would you mind opening an issue?
Vishnu
Photo of md5-5b8bec7eb3801153a6bbb2ffec57863b
Vishnu
05:03 PM
Srikanth Sure will do that, but i can see the attribute on the event tab of the trace where the exception is recorded. But could not find in the table that i mentioned above.
May 15, 2023 (7 months ago)
Vishnu
Photo of md5-5b8bec7eb3801153a6bbb2ffec57863b
Vishnu
04:35 AM
Srikanth I can see the new attributes on the ui, not sure which table this is being stored.
Image 1 for <@4K1456> I can see the new attributes on the ui, not sure which table this is being stored.
Srikanth
Photo of md5-ce04a9988e2fd758a659dc55be6f2543
Srikanth
04:48 AM
They are not part of the exceptions table. They are part of the signoz_index_v2 which has stringified event json.
Vishnu
Photo of md5-5b8bec7eb3801153a6bbb2ffec57863b
Vishnu
04:54 AM
Understood. These should be present in the error index as well. Should i create a issue?
Srikanth
Photo of md5-ce04a9988e2fd758a659dc55be6f2543
Srikanth
06:46 AM
Yes, please do.
Vishnu
Photo of md5-5b8bec7eb3801153a6bbb2ffec57863b
Vishnu
07:22 AM
https://github.com/SigNoz/signoz/issues/2691
Done Srikanth, let me know if i need to update anything here.

SigNoz Community

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

Indexed 1023 threads (61% resolved)

Join Our Community

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.

59
8mo

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.

ack

2

31
8mo

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.

1

15
7mo

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.

1

30
2mo

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.

17
3mo