Hi team, I see the message "max spans allowed in trace limit reached, please contact support for more details" when opening a particular trace. Is there a maximum limit for the no. of spans in a trace? How can I see the trace?

Yes, we limits set for very large traces to make sure large traces does not OOM the query-service container. @Vishal Sharma would be best person to explain this in detail.

Thanks for the info, Prashant. I'm seeing a trace that has been running for more than a day. I want to find the root span of this and figure out what's happening. Is there a way to view the trace in a paginated manner or any other way? Please suggest.

You try quering the clickhouse directly and search with the traceId and parentSpanId as empty to get the parent span

Unfortunately, there is no index on the traceID column in the signoz_index_v2 table. It is taking forever to produce results. @Prashant Shahi @Vishal Sharma Is this index not added intentionally or is this a bug? Because the Traces tab (beside List View) in the Traces Explorer is supposed to display the root span traces. It is also very slow to show the results.

@Prashanth Banda Try searching on signoz_spans table. It has index on traceId

Is there a way to find the root span from the signoz_spans table? As it doesn’t contain parentSpanId column in it.