SigNoz is an open-source APM. It helps developers monitor their applications & troubleshoot problems, an open-source alternative to DataDog, NewRelic, etc.

SigNoz Community

i am seeing a weird issue. i have signoz setup in production cluster, and I see an error when listing traces. The helm chart deployed is 0.86. I checked signoz_traces db and there are few tables missing, I submitted the migration job but those are not creating the missing tables. But I did not have this issue in dev. Is there a way to fix this ? Or should I create the missing tables manually.

```"error": "error while executing query: code: 60, message: Table signoz_traces.distributed_span_attributes_keys does not exist. Maybe you meant signoz_traces.distributed_tag_attributes_v2?"```

Were you migrating Production from a much older version? There's quite a few <https://signoz.io/docs/operate/migration/|upgrade stops> and some of them require pausing for a retention period while data is streamed to two tables.

I was able to create the tables in production since I have those tables in dev. However, if this appears in a fresh installation can I to get the table definition from somewhere to have the tables created. My production setup had 5 missing tables in signoz_traces database.

also the signoz migrator job does not create any tables in signoz_traces databases, I checked the logs and I could not find any CREATE Table for signoz_traces db.