mysql錯誤: [ERROR] InnoDB: auto-extending data file /data/ibdata1 is of a different size 768 pages...
mysql報錯:
2017-11-06 11:17:22 24013 [ERROR] InnoDB: auto-extending data file /data/ibdata1 is of a different size 768 pages (rounded down to MB) than specified in the .cnf file: initial 1600 pages, max 0 (relevant if non-zero) pages!
2017-11-06 11:17:22 24013 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
2017-11-06 11:17:22 24013 [ERROR] Plugin 'InnoDB' init function returned error.
2017-11-06 11:17:22 24013 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-11-06 11:17:22 24013 [ERROR] Unknown/unsupported storage engine: InnoDB
2017-11-06 11:17:22 24013 [ERROR] Aborting
問題解決:
切換到資料存放目錄,刪除下邊的檔案重啟即可
[root@test data]# rm ibdata1
rm:是否刪除普通檔案 "ibdata1"?y
[root@test data]# rm ib_logfile0
rm:是否刪除普通檔案 "ib_logfile0"?y
[root@test data]# rm ib_logfile1
rm:是否刪除普通檔案 "ib_logfile1"?y
相關文章
- MySQL啟動報錯InnoDB: The innodb_system data file './ibdata1' is of a differentMySql
- [ERROR] InnoDB: ibdata1 different size (rounded down to MB)Error
- The innodb_system data file 'ibdata1' must be writable
- InnoDB: Error: log file ./ib_logfile0 is of different size 5242880 bytesError
- mysql之 [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11MySqlError
- mysql innodb_log_file_size 和innodb_log_buffer_size引數MySql
- [ERROR] InnoDB: Unable to lock ./ibdata1, error: 11Error
- set up different data screen(masterial master) for different userAST
- MysqL錯誤之_ERROR! MySQL server PID file could not be found!MySqlErrorServer
- kernel_data_inpage_error藍屏錯誤怎麼修復Error
- mysql 啟動錯誤(InnoDB: Operating system error number 13 )MySqlError
- MySQL:Innodb表 Data free 的計算概要MySql
- mysql [ERROR] InnoDB: ./ibdata1 can't be opened in read-write modeMySqlError
- ERROR! The server quit without updating PID file (/opt/mysql/mysql/data/cvs.pid)ErrorServerUIMySql
- MySQL 儲存過程空結果集錯誤Error 1329 No data 的異常處理MySql儲存過程Error
- kernel_data_inpage_error藍色畫面錯誤怎麼修復Error
- MySQL error 錯 誤 碼MySqlError
- oracle 匯入報錯:field in data file exceeds maximum lengthOracle
- 密碼檔案導致Data Guard同步錯誤:error 12514,Error 1033 - 2密碼Error
- 密碼檔案導致Data Guard同步錯誤:error 12514,Error 1033 - 1密碼Error
- HP -Data Protector Restore file systemREST
- StartingMySQL.ERROR!TheserverquitwithoutupdatingPIDfile(/data/mysql/mysql.pid).MySqlErrorServerUI
- MySQL data pageMySql
- MySQL資料匯入匯出之Load data fileMySql
- /usr/bin/xauth: error in locking authority file錯誤Error
- TNS-04414 file error 錯誤解決Error
- ORA-01565: error in identifying file '+DATA/devdb/spfiledevdb.ora'ErrorIDEdev
- ORA-01565: error in identifying file '+DATA/rac/dataile/datfile/system'ErrorIDEAI
- sqlldr Field in data file exceeds maximum lengthSQL
- sqlldr匯入資料包錯 Field in data file exceeds maximum lengthSQL
- mysql起動報錯TheserverquitwithoutupdatingPIDfile/usr/local/mysql/data/MySqlServerUI
- tf.data.Dataset.shuffle(buffer_size)中buffer_size的理解
- MySQL innodb_buffer_pool_size 變數MySql變數
- python匯入資料錯誤:ParserError: Error tokenizing data. C error: Expected 1 fields in line 3, saw 2PythonError
- mysql 5.7.21 CMake Error: The source directory "/data/server/mysql" does not appear to contain CMakMySqlErrorServerAPPAI
- MySQL ERROR 1698 (28000) 錯誤MySqlError
- Unload data to a flat file from Oracle databaseOracleDatabase
- yii2 Unable to verify your data submission錯誤解決