QAN empty after upgrade

Hi,

I upgrade PMM server from v2.39 to v2.44, running on docker.
followed this link - Docker - Percona Monitoring and Management

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,

What should I fix in order to resolve it?

Thanks,
Eldad

Hi @eldad ,

Did you also check the upgrade logs? Does the clickhouse error log show any other messages regarding failures in the upgrade process?

Hi @eldad,

Some other people have encountered the same, they proposed a possible solution in this github issue.

Let’s see if it helps.

Hi @Ademidoff and @Agustin_G,

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.

Thanks,
Eldad
desc_metrics.txt (108.0 KB)

Hi @eldad,

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.