[ERROR] Failed to open log
版本:5.5.14
效能測試部-測試環境資料庫
1、在效能測試過程中大量的日誌,測試人員直接使用 rm -rf 刪除所有
2、重啟資料庫時,出現報錯,導致資料庫無法啟動,檢視報錯日誌,報錯資訊如下:
/export/servers/mysql/bin/mysqld: File './mysql-bin.000003' not found (Errcode: 2)
140325 16:31:16 [ERROR] Failed to open log (file './mysql-bin.000003', errno 2)
140325 16:31:16 [ERROR] Could not open log file
140325 16:31:16 [ERROR] Can't init tc log
140325 16:31:16 [ERROR] Aborting
3、雖然mysql-bin.000003日誌不存在,但是在mysql-bin.index裡有mysql-bin.000003記錄
解決方法:
cp mysql-bin.index mysql-bin.index.bak
編輯 vi mysql-bin.index
刪除缺少的mysql-bin.0000日誌即可,重啟資料庫OK。
效能測試部-測試環境資料庫
1、在效能測試過程中大量的日誌,測試人員直接使用 rm -rf 刪除所有
2、重啟資料庫時,出現報錯,導致資料庫無法啟動,檢視報錯日誌,報錯資訊如下:
/export/servers/mysql/bin/mysqld: File './mysql-bin.000003' not found (Errcode: 2)
140325 16:31:16 [ERROR] Failed to open log (file './mysql-bin.000003', errno 2)
140325 16:31:16 [ERROR] Could not open log file
140325 16:31:16 [ERROR] Can't init tc log
140325 16:31:16 [ERROR] Aborting
3、雖然mysql-bin.000003日誌不存在,但是在mysql-bin.index裡有mysql-bin.000003記錄
解決方法:
cp mysql-bin.index mysql-bin.index.bak
編輯 vi mysql-bin.index
刪除缺少的mysql-bin.0000日誌即可,重啟資料庫OK。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/28939273/viewspace-1129286/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- DBLOGIN ERROR: Failed to open data source for user OGG.ErrorAI
- ascp: Failed to open TCP connection for SSH, exiting. Session Stop (Error: Failed to open TCP connection for SSH)AITCPSessionError
- 解決 yum clean all Error rpmdb open failedErrorAI
- weblogic報錯: OPatch failed with error code 73WebAIError
- LOGIN:ERROR-Failed to initialize policy manager(轉)ErrorAI
- nginx: [error] open() “/var/run/nginx/nginx.pid“ failed (2: No such file or directory)NginxErrorAI
- sqlserver 2008 login failed: error 18456SQLServerAIError
- ORA-00313 open failed for members of log group解決辦法AI
- 【ERROR】OPatch failed with error code 73ErrorAI
- Failed to open service <OracleOraDb10g_home1TNSListener>, error 1060AIOracleError
- smplx 的 libGL error: MESA-LOADER: failed to open swrast 的解決方法ErrorAIAST
- open failed: EBUSY (Device or resource busy)AIdev
- 【Mysql】ERROR 1872 (HY000): Slave failed to initialize relay log infoMySqlErrorAI
- cacti-不出圖形,cacti.log中出“ERROR: SQL Assoc Failed!ErrorSQLAI
- ∵∵∵open log for mysql∵∵∵MySql
- ftp 報錯 550 Failed to open fileFTPAI
- AIX scp Failed to open devpkcs11AIdev
- OPatch failed with error code 73AIError
- Error: failed PB timebomb checkErrorAI
- Failed to load libGL.so error libGL.so: cannot open shared object file: No such file or directoryAIErrorObject
- alter database open resetlogs;Database
- ERROR: UTL_SMTP.OPEN_CONNECTIONError
- FAILED_LOGIN_ATTEMPTSAI
- maridb Error 'Operation DROP USER failed forErrorAI
- Opiino: Attach Failed! Error=-1 Ifvp=0AIError
- MySQL error log和bin logMySqlError
- nmap報錯: Failed to open device ethxxxAIdev
- [ERROR] Can't open the mysql.plugin tableErrorMySqlPlugin
- xtrabackup: Error: cannot open /../../base/xtrabackup_checkpointsError
- FATAL - Fatal error: Target Interaction Manager failed at StartupErrorAI
- Android 3.0 DELETE_FAILED_INTERNAL_ERRORAndroiddeleteAIError
- error log about AIXErrorAI
- Android Bugs——Error:java.lang.RuntimeException: Some file crunching failed, see logs for detailsAndroidErrorJavaExceptionAI
- Android Gradle Build Error:Some file crunching failed, see logs for details解決辦法AndroidGradleUIErrorAI
- 遷移過程中出現的open failed錯誤AI
- Top free and open source log management software
- ORA-15186: ASMLIB error function = [asm_open], error = [1]ASMErrorFunction
- How to audit failed logon attemptsAIGo