After the upgrade QAN is empty.
log show:
stdlog: qan-api2 v2.44.0.
time=“2025-01-15T10:24:35.723+00:00” level=info msg=“Log level: info.”
time=“2025-01-15T10:24:35.723+00:00” level=info msg=“DSN: clickhouse://127.0.0.1:9000?database=pmm&block_size=10000&pool_size=2” component=main
stdlog: dsn: clickhouse://127.0.0.1:9000?database=pmm&block_size=10000&pool_size=2
stdlog: Migrations: Dirty database version 17. Fix and force version.
Steps to Reproduce:
upgrade PMM server from v2.39 to v2.44, running on docker.
using docket upgrade,
Thank you for you reply.
I’m aware of the insert I need to do to schema_migrations but I need to make sure the metrics table has the latest updates.
The alter in that post is not relevant for the current version.
I’m attaching the current table structure, will be happy to know if I need to alter it.
Have you checked the upgrade log and full clickhouse log? You may find out which was the exact problematic step/query that failed and have a better idea on how to move forward with the fix.