Missing values in signoz_metrics.distributed_metadata

[juliuskoval]

Bug description

Running select attr_string_value from signoz_metrics.distributed_metadata where attr_name = 'table' and metric_name = 'exporter_db_write_latency.sum' only returns distributed_exp_hist. If I search for the metric exporter_db_write_latency.sum in a metrics explorer and aggregate by table, I get multiple different values.

Expected behavior

Running select attr_string_value from signoz_metrics.distributed_metadata where attr_name = 'table' and metric_name = 'exporter_db_write_latency.sum' should return all the relevant values.

How to reproduce

Go to a metrics explorer and look for the suggested values of the table attribute in the exporter_db_write_latency.sum metric.
Alternatively, directly run the query select attr_string_value from signoz_metrics.distributed_metadata where attr_name = 'table' and metric_name = 'exporter_db_write_latency.sum' in ClickHouse.

Version information

• Signoz version: v0.104.0
• Browser version: Google Chrome latest
• Your OS and version: Windows 11
• Your CPU Architecture(ARM/Intel): x64

Additional context

The same issue appeared for multiple metrics; this was just an example. Likely relevant to #7791

Thank you for your bug report – we love squashing them!

[welcome]

Thanks for opening this issue. A team member should give feedback soon. In the meantime, feel free to check out the contributing guidelines.