Hello,
We are upgrading from 5.6, to 5.7, to 8; all has went well on previous servers and test.
Our current issue is that once we go to 8, mysql won’t start, gives this error.
Starting upgrade of data directory.
690311Z 1 [ERROR] [MY-011006] [Server] Got error 197 from SE while migrating tablespaces.
703943Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
704465Z 0 [ERROR] [MY-010119] [Server] Aborting
2020-01-13T15:48:28.339918Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.18-9) Percona Server (GPL), Release 9, Revision 53e606f.
Any thing I can do to get a more verbose error on what schema it may be failing on?
and would love to have the answer… we are currently on latest version of 5.7 and tried upgrading to 8.0.16/17/18/19 and they all fail with the same issue. We have used mysqlsh upgrade-checker and it all looks ok. Made sure there are no conflicts from the Mysql docs for the upgrade and everything there is also good. This is a large database and a dump/restore is not a option.