# Upgrade to 2.25.0 - qan-api2 down - Dirty database version 14

**URL:** <https://forums.percona.com/t/upgrade-to-2-25-0-qan-api2-down-dirty-database-version-14/14171>\
**Category:** PMM 2.x\
**Created:** [January 31, 2022, 1:51pm UTC](https://forums.percona.com/t/upgrade-to-2-25-0-qan-api2-down-dirty-database-version-14/14171 "2022-01-31T13:51:22Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kevin\_Huet](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kevin_huet/32/72_2.png) [@Kevin\_Huet](https://forums.percona.com/u/Kevin_Huet)\
**Post date:** [January 31, 2022, 1:51pm UTC](https://forums.percona.com/t/upgrade-to-2-25-0-qan-api2-down-dirty-database-version-14/14171/1 "2022-01-31T13:51:22Z")

</div>

Hi,

I’ve upgraded PMM2 from 2.14.0 to 2.25.0 and I faced the following issue on qan-api2 :  
`INFO[2022-01-31T13:44:51.386+00:00] Log level: info. stdlog: dsn: clickhouse://127.0.0.1:9000?database=pmm&block_size=10000&pool_size=2 stdlog: Migrations: Dirty database version 14. Fix and force version.`

I’ve checked [this thread](https://forums.percona.com/t/pmm-upgrade-from-2-16-to-2-21-query-analytics-not-starting-qan-doesnt-display-any-data/12226/9) and ran the migration manually from [here](https://github.com/percona/qan-api2/blob/main/migrations/sql/14_pg_stat_monitor_09_queryplan.up.sql), and the following statement :

execute `insert into schema_migrations (version, dirty, sequence) values(14, 0, toUnixTimestamp(NOW())*1000000000);`

Now it’s started, but just to be 100% sure, can someone confirm me that it was the good thing to do ?

Thanks a lot 🙂

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [January 31, 2022, 7:06pm UTC](https://forums.percona.com/t/upgrade-to-2-25-0-qan-api2-down-dirty-database-version-14/14171/2 "2022-01-31T19:06:49Z")

</div>

If you are not seeing the error anymore and everything is working, then I’d say you are good to go!

---

<div class="post-metadata">

**Author:** ![Kevin\_Huet](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kevin_huet/32/72_2.png) [@Kevin\_Huet](https://forums.percona.com/u/Kevin_Huet)\
**Post date:** [February 1, 2022, 11:30am UTC](https://forums.percona.com/t/upgrade-to-2-25-0-qan-api2-down-dirty-database-version-14/14171/3 "2022-02-01T11:30:06Z")

</div>

Well, it looks OK for now 🤞

Thanks 🙂