Shulou(Shulou.com)06/01 Report--

After MySQL is migrated, start the database to report an error.

# / data/mysql_57_software/bin/mysqld_safe-- defaults-file=/etc/my3319.cnf-- user=mysql & # tail-20 / var/log/mysqld3319.log2019-01-02T07:11:01.716793Z 0 [ERROR] InnoDB: The innodb_system data file'. / ibdata1' is of a different size 17152 pages (rounded down to MB) than the 64000 pages specified in the .cnf fileholders 2019-01-02T07:11:01.716832Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error2019-01 -02T07:11:02.317322Z 0 [ERROR] Plugin 'InnoDB' init function returned error.2019-01-02T07:11:02.317347Z 0 [ERROR] Plugin' InnoDB' registration as a STORAGE ENGINE failed.2019-01-02T07:11:02.317353Z 0 [ERROR] Failed to initialize plugins.2019-01-02T07:11:02.317361Z 0 [ERROR] Aborting

Reason for reporting an error:

The system tablespace in the parameter file is larger than the actual system tablespace size, resulting in a startup error.

# du-sh / data/mysql_3319/ibdata1268M / data/mysql_3319/ibdata1# cat / etc/my3319.cnf# innodbinnodb_data_file_path=ibdata1:1000M;ibdata2:1000M:autoextend

Solution:

Change the size of the system tablespace in the parameter file to a value less than the actual system tablespace size.

# innodbinnodb_data_file_path=ibdata1:256M;ibdata2:256M:autoextend

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.