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
174
August 08, 2020 07:17PM
59
August 08, 2020 07:22PM
66
August 08, 2020 07:25PM
61
August 08, 2020 09:53PM
60
August 08, 2020 10:05PM
67
August 08, 2020 10:25PM
Re: Error message on OS freebsd
76
August 09, 2020 11:19AM
67
August 09, 2020 12:41PM
63
August 09, 2020 06:40PM
60
August 09, 2020 08:36PM
64
August 12, 2020 08:48PM
60
August 13, 2020 08:26AM
62
August 13, 2020 09:48AM


Sorry, only registered users may post in this forum.

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.