Re: Error message on OS freebsd

[Aaron Durrani]

This is the error when I start mysqld_safe

error: " starting proccess 13006

Starting upgrade of data directory

InnoDB initialization has started

InnoDB Multiple files found for the same tablespace ID

InnoDB Tablespace ID: 1 = [' mysql/innodb_table_stats.ibd',

'sys/sys_config.ibd']

InnoDB Plugin initialization aborted with error failed. retry may
succeed.

Failed to initialize DD Storage Engine.

Data Dictionary initialization failed

Aborting

/usr/local/libexec/mysqld : Shutdown complete. "


above is what it shows in the logs. It doesn't show anything on the screen when I try to start mysql.

I looked at that link provided before and didn't do that since I didn't move files around.

This happened when I updated freebsd from 12.0 to 12.1 and then upgrade all software. Mysql was working when i upgraded from mysql 5.7 to 8.0 now ever if I go back to mysql 5.7 it has this error.

I tried to move sys/sys_config.ibd files out of the folder to another one. I then tried to run mysqld_Safe again but I get the same error and the server doesn't start. I did this after reading on serverfaul.com someone having the same error but fixed their issue by doing this.

The error tells me that the tablespace of 2 files ibd have the same id. How can I change this id? and where do I make changes to this id?