MySQL Forums
Forum List  »  InnoDB

Re: Error message on OS freebsd
Posted by: Aaron Durrani
Date: August 09, 2020 11:19AM

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?

Options: ReplyQuote


Subject
Views
Written By
Posted
651
August 08, 2020 07:17PM
343
August 08, 2020 07:22PM
339
August 08, 2020 07:25PM
338
August 08, 2020 09:53PM
337
August 08, 2020 10:05PM
376
August 08, 2020 10:25PM
Re: Error message on OS freebsd
755
August 09, 2020 11:19AM
459
August 09, 2020 12:41PM
396
August 09, 2020 06:40PM
325
August 09, 2020 08:36PM
390
August 12, 2020 08:48PM
362
August 13, 2020 08:26AM
368
August 13, 2020 09:48AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.