GTID複製報錯處理:Last_Error: Error 'Can't drop database 'test';
Mysql GTID複製報錯處理:Last_Error: Error 'Can't drop database 'test'; database doesn't
報錯顯示:
Slave_IO_Running: Yes Slave_SQL_Running: No Last_Error: Error 'Can't drop database 'test'; database doesn't exist' on query. Default database: 'test'. Query: 'drop database test' Retrieved_Gtid_Set: 988b8684-3e21-22e6-a801-24505689c77d:1-9 Executed_Gtid_Set: 檢視主庫上的binlog日誌,查詢drop database test相關的日誌: # at 151 #160630 1:55:19 server id 623306 end_log_pos 199 CRC32 0x5954bb4c GTID [commit=yes] SET @@SESSION.GTID_NEXT= '988b8684-3e21-22e6-a801-24505689c77d:1'/*!*/; # at 199 #160630 1:55:19 server id 623306 end_log_pos 284 CRC32 0x6db10369 Query thread_id=1 exec_time=0 error_code=0 SET TIMESTAMP=1467222919/*!*/; SET @@session.pseudo_thread_id=1/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1073741824/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C utf8 *//*!*/; SET @@session.character_set_client=83,@@session.collation_connection=83,@@session.collation_server=83/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; drop database test /*!*/; 問題找到了,drop database test對應的事務號是1,接下來就簡單了,按如下操作執行: mysql> stop slave; Query OK, 0 rows affected (0.00 sec) mysql> set gtid_next="988b8684-3e21-22e6-a801-24505689c77d:1"; Query OK, 0 rows affected (0.00 sec) mysql> begin;commit; Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.01 sec) mysql> set gtid_next="AUTOMATIC"; Query OK, 0 rows affected (0.00 sec) mysql> start slave; Query OK, 0 rows affected (0.00 sec) 檢視結果:
mysql> show slave status\G Slave_IO_Running: Yes Slave_SQL_Running: Yes Retrieved_Gtid_Set: 988b8684-3e21-22e6-a801-24505689c77d:1-9 Executed_Gtid_Set: 988b8684-3e21-22e6-a801-24505689c77d:1-9
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/70000068/viewspace-2772498/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- mysql複製報錯案例處理MySql
- Mysql報錯Fatal error:Can't open and lock privilege tablesMySqlError
- MySQL 5.5 原始碼安裝報錯"[ERROR] Can't start server"MySql原始碼ErrorServer
- 專案02(Mysql gtid複製故障處理01)MySql
- eslint --fix 報錯 can't not find modulesEsLint
- MongoDB報錯:"assertion" : "can't map file memory"MongoDB
- 【Mysql】Last_Error: 1778 @@SESSION.GTID_NEXT == 'UUID:NUMBER'.MySqlASTErrorSessionUI
- MySQL報錯Table 'plugin' is read only [ERROR] Can't open the mysql.plugin table.MySqlPluginError
- MySQL GTID複製錯誤修復演示MySql
- can't create PID file問題處理
- MySQl報錯之@@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_MODE = ONMySql
- MySQL GTID複製MySql
- ogg複製程式報ORA-01438錯誤處理
- 【crontab】“bad minute”及“errors in crontab file, can't install”錯誤處理Error
- MySQL 8 複製(四)——GTID與複製MySql
- MySQL 8 複製(五)——配置GTID複製MySql
- MySQL主從複製之GTID複製MySql
- [ERROR] Can't open the mysql.plugin tableErrorMySqlPlugin
- MySQL報錯'ERROR 2002 (HY000): Can't connect to local MySQL server through'MySqlErrorServer
- MysqL主從複製_模式之GTID複製MySql模式
- mysql [ERROR] Can't create IP socket: Permission deniedMySqlError
- Fatal NI connect error 12170.報錯處理Error
- ERROR in Entry module not found Error Can't resolve 'babel' in ' UseErrorBabel
- MariaDB GTID 複製同步
- mysql多源複製跳過錯誤處理方法MySql
- MySQL 5.6複製報錯Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND;MySqlError
- 15-錯誤處理(Error)Error
- MySQL 建立外來鍵報錯Can't write; duplicate key in tableMySql
- 錯誤處理--pure specifier can only be specified for functionsFunction
- MySQL 5.7 多主複製報錯Coordinator stopped because there were error(s)MySqlError
- Last_Error:Unabletouseslave'stemporarydirectory/var/tmpASTError
- 解決mysql使用GTID主從複製錯誤問題MySql
- mysql GTID 主從複製概述MySql
- Drop DatabaseDatabase
- [筆記].痛哉!!!Error: Can't access JTAG chain, Error: Operation failed筆記ErrorAI
- 線上將傳統模式複製改為GTID複製模式模式
- MYSQL報1022錯誤:Can't write;duplicate key in table '.....'MySql
- Can't use function return value in write context 使用empty遇到報錯FunctionContext