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

[Kevin_Huet]

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 and ran the migration manually from here, 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

[matthewb]

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

[Kevin_Huet]

Well, it looks OK for now

Thanks