i am seeing a weird issue. i have signoz setup in ...
# support
a
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.
Copy code
"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?"
h
Were you migrating Production from a much older version? There's quite a few upgrade stops and some of them require pausing for a retention period while data is streamed to two tables.
a
no. This was a fresh installation.
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.