# QAN empty after upgrade

**URL:** <https://forums.percona.com/t/qan-empty-after-upgrade/36155>\
**Category:** PMM 2.x\
**Tags:** pmm\
**Created:** [January 15, 2025, 10:45am UTC](https://forums.percona.com/t/qan-empty-after-upgrade/36155 "2025-01-15T10:45:57Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![eldad](https://avatars.discourse-cdn.com/v4/letter/e/bc8723/32.png) [@eldad](https://forums.percona.com/u/eldad)\
**Post date:** [January 15, 2025, 10:45am UTC](https://forums.percona.com/t/qan-empty-after-upgrade/36155/1 "2025-01-15T10:45:57Z")

</div>

Hi,

I upgrade PMM server from v2.39 to v2.44, running on docker.  
followed this link - [Percona Monitoring and Management](https://docs.percona.com/percona-monitoring-and-management/setting-up/server/docker.html#upgrade)

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,

> **[Percona Monitoring and Management](https://docs.percona.com/percona-monitoring-and-management/3/404.html)**
>
> Documentation

What should I fix in order to resolve it?

Thanks,  
Eldad

---

<div class="post-metadata">

**Author:** ![Agustin\_G](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/agustin_g/32/14111_2.png) [@Agustin\_G](https://forums.percona.com/u/Agustin_G)\
**Post date:** [January 16, 2025, 3:06am UTC](https://forums.percona.com/t/qan-empty-after-upgrade/36155/2 "2025-01-16T03:06:10Z")

</div>

Hi @eldad ,

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

---

<div class="post-metadata">

**Author:** ![ademidoff](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ademidoff/32/14234_2.png) [@ademidoff](https://forums.percona.com/u/ademidoff)\
**Post date:** [January 16, 2025, 7:10am UTC](https://forums.percona.com/t/qan-empty-after-upgrade/36155/3 "2025-01-16T07:10:36Z")

</div>

Hi @eldad,

Some other people have encountered the same, they proposed a possible solution in [this](https://github.com/percona/pmm/issues/3288) github issue.

Let’s see if it helps.

---

<div class="post-metadata">

**Author:** ![eldad](https://avatars.discourse-cdn.com/v4/letter/e/bc8723/32.png) [@eldad](https://forums.percona.com/u/eldad)\
**Post date:** [January 22, 2025, 10:01am UTC](https://forums.percona.com/t/qan-empty-after-upgrade/36155/4 "2025-01-22T10:01:12Z")

</div>

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](https://forums.percona.com/uploads/short-url/40J386F85yEtc2tMxfYIbDZuYKH.txt) (108.0 KB)

---

<div class="post-metadata">

**Author:** ![Agustin\_G](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/agustin_g/32/14111_2.png) [@Agustin\_G](https://forums.percona.com/u/Agustin_G)\
**Post date:** [January 24, 2025, 7:08pm UTC](https://forums.percona.com/t/qan-empty-after-upgrade/36155/5 "2025-01-24T19:08:06Z")

</div>

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.