Not the answer you need?
Register and ask your own question!

mysql8 won't start after migration from 5.7

chase.millerchase.miller EntrantCurrent User Role Novice
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?

Comments

  • FreddyFreddy Current User Role Beginner
    We have the same issue :( 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.
  • PeterPeter Percona CEO Percona Moderator Role
    This might be related to this issue 
    https://bugs.mysql.com/bug.php?id=97295
    What do you have in your log file before this specific error. 
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.