Hello,
We’ve tried this process a couple of times and all works well, but now we are running into a weird issue where no matter what we do we run into:
2025-03-11T18:03:24.400180Z 3 [ERROR] [MY-011006] [Server] Got error 197 from SE while migrating tablespaces.
2025-03-11T18:03:24.406636Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2025-03-11T18:03:24.406701Z 0 [ERROR] [MY-010119] [Server] Aborting
....
2025-03-11T18:03:26.410220Z 1 [ERROR] [MY-000000] [Galera] Exception: State wait was interrupted
2025-03-11T18:03:26.410311Z 1 [ERROR] [MY-000000] [Galera] View callback failed. This is unrecoverable, restart required. (FATAL)
at /mnt/jenkins/workspace/pxc80-autobuild-RELEASE/test/rpmbuild/BUILD/Percona-XtraDB-Cluster-8.0.39/percona-xtradb-cluster-galera/galera/src/replicator_smm.cpp:submit_view_info():2633
Unfortunately there’s nothing more in the logs to describe what is actually going on. There’s nothing telling us what tables/dbs are failing to convert.
We are taking a backup using xtrabackup, and restoring it to a new host, then running mysql 5.7 (this works and stands up fine) then we do an in-place upgrade to 8.0 and thats where we run into the logs below. (We use docker and mounted FS, so the data does not change between the two and we’ve used the mysql 8.0 container before without issues.
Here’s what we’ve done so far:
- Tried running mysqlsh util.checkForUpgrade() on the live side, this passes, and has 0 errors.
- Stood up mysql 5.7 from the restored data without problems.
Any ideas on how to fix this besides mysqldumps?
We haven’t modified anything on disk, and as noted we can create a cluster using mysql5.7 but 8.0 won’t convert it.
It does seem somewhat related to mysql8 won't start after migration from 5.7 and MySQL 8.0.26 won't start after upgrading from MySQL 5.7
But I went through both and couldn’t find a working solution from them.