Database upgrade issues

[groovyloopylou]

1.21.11
previous CP version: 23.4b
Version with issue: 24.0

We updated the plugin and see this in console [14:14:54 INFO]: [CoreProtect] Database upgrade in progress. Please wait...
There's no eta on how long it will take and we cant see any changes on the db server indicating anything is actually happening.
If a server gets rebooted during this it will fail to start up and on servers still up it wont record any data.

We have downgraded.

[PatchedNotFixed]

extra info,

we do have an older database and they are on the lager side, on one of our servers the co_block is 154G by its self.

[groovyloopylou]

We went back to 24.0
One server did finish an update after 3h

[Intelli]

The v24.0 performs ALTER queries on the co_sign, co_container, co_item, and co_skull tables for MySQL databases (SQLite databases don't perform any upgrades).

The co_block table doesn't have any schema changes in v24.0.

[PatchedNotFixed]

thank for that info, co_block was just being used for example.

that is strange checking those tables they are not that large, not something I would expect to cause a mysql server to read/write 100m/sec for 6+ hours.

ALTER TABLE co_container MODIFY metadata MEDIUMBLOB been running for 3.105 hours.