MySQL啟動報錯InnoDB: The innodb_system data file './ibdata1' is of a different
MySQL異機遷移後，啟動資料庫報錯
# /data/mysql_57_software/bin/mysqld_safe --defaults-file=/etc/my3319.cnf --user=mysql & # tail -20 /var/log/mysqld3319.log 2019-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 file! 2019-01-02T07:11:01.716832Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2019-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
報錯原因：
引數檔案中的系統表空間大於實際的系統表空間大小，導致啟動報錯。
# du -sh /data/mysql_3319/ibdata1 268M /data/mysql_3319/ibdata1 # cat /etc/my3319.cnf # innodb innodb_data_file_path=ibdata1:1000M;ibdata2:1000M:autoextend
解決辦法：
將引數檔案中系統表空間的大小改為小於實際系統表空間大小的值。
# innodb innodb_data_file_path=ibdata1:256M;ibdata2:256M:autoextend
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26506993/viewspace-2287203/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- The innodb_system data file 'ibdata1' must be writable
- mysql錯誤： [ERROR] InnoDB: auto-extending data file /data/ibdata1 is of a different size 768 pages...MySqlError
- [ERROR] InnoDB: ibdata1 different size (rounded down to MB)Error
- innodb_undo_tablespaces導致Mysql啟動報錯MySql
- MySQL啟動報錯：The server quit without updating PID fileMySqlServerUI
- mysql啟動報錯Manager of pid-file quit without updating file.[FAILED]MySqlUIAI
- mysql起動報錯TheserverquitwithoutupdatingPIDfile/usr/local/mysql/data/MySqlServerUI
- mysql 啟動錯誤(InnoDB: Operating system error number 13 )MySqlError
- Mysql啟動錯誤-server PID file could not be foundMySqlServer
- mysql之 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11MySqlError
- mysql 啟動報錯Can't connect to local MySQL server through socket '/data/mysql/mysql/mysql.sock'(111)MySqlServer
- InnoDB: Error: log file ./ib_logfile0 is of different size 5242880 bytesError
- VMware 啟動報錯 "Failed to lock the file"解決辦法AI
- oracle 匯入報錯：field in data file exceeds maximum lengthOracle
- 【MySQL】mysql啟動常見報錯 mysqld_safe mysqld from pid file hostname.pid endedMySql
- mysql安裝/啟動報錯彙總MySql
- 【ASM】Oracle RAC css啟動報錯"Duplicate voting file found"ASMOracleCSS
- set up different data screen(masterial master) for different userAST
- MySQL 啟動報錯 Table 'mysql.plugin' doesn't existMySqlPlugin
- MySQL 啟動服務報錯解決方案MySql
- mysql [ERROR] InnoDB: ./ibdata1 can't be opened in read-write modeMySqlError
- mysql innodb_data_file_path引數忘記設定或者重新調整辦法MySql
- MYSQL啟動後報：ERROR! The server quit without updating PID file錯誤的問題解決MySqlErrorServerUI
- kafka啟動報錯：kafka.common.KafkaException: Failed to acquire lock on file .lockKafkaExceptionAIUI
- 自定義容器啟動指令碼報錯：exec user process caused "no such file or directory"指令碼
- mysql 啟動錯誤MySql
- mongodb 啟動報錯MongoDB
- php啟動報錯PHP
- 【MySQL】mysql啟動報錯./mysqld_safe: my_print_defaults: not foundMySql
- MySQL InnoDB File-Per-Table表空間MySql
- MySQL中innodb_file_per_table引數MySql
- [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11Error
- MySQL 5.7啟動資料庫報錯'does not exist or is not executable'MySql資料庫
- Oracle啟動報錯：ORA-03113: end-of-file on communication channelOracle
- MySQL：Innodb表 Data free 的計算概要MySql
- mysql innodb_log_file_size 和innodb_log_buffer_size引數MySql
- myeclipse啟動報錯Eclipse
- 本地nacos啟動報錯