Could not execute Write_rows event on table time_task.tt_log
報錯:
Could not execute Write_rows event on table time_task.tt_log; Duplicate entry '1483968' for key 'PRIMARY', Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event's master log mysql-bin.000001, end_log_pos 2474
解決問題:
主庫操作:
mysql> SHOW BINARY LOGS;
+------------------+-----------+
| Log_name | File_size |
+------------------+-----------+
| mysql-bin.000001 | 289246 |
+------------------+-----------+
1 row in set (0.00 sec)
mysql> PURGE BINARY LOGS TO 'mysql-bin.000001';
Query OK, 0 rows affected (0.01 sec)
mysql> RESET MASTER;
Query OK, 0 rows affected (0.01 sec)
從庫操作:
mysql> stop slave;
Query OK, 0 rows affected (0.00 sec)
mysql> CHANGE MASTER TO MASTER_HOST='192.168.60.80', MASTER_PORT=3306,MASTER_USER='repl',
MASTER_PASSWORD='XXX';
Query OK, 0 rows affected, 2 warnings (0.00 sec)
mysql> start slave;
Query OK, 0 rows affected (0.00 sec)
mysql> show slave status\G;
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.60.80
Master_User: repl
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000001
Read_Master_Log_Pos: 12716
Relay_Log_File: mysql-relay.000002
Relay_Log_Pos: 12929
Relay_Master_Log_File: mysql-bin.000001
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 12716
Relay_Log_Space: 13132
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 186
Master_UUID: 93228932-a66b-11eb-ab7b-005056a51cd1
Master_Info_File: /var/lib/mysql/master.info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set:
Auto_Position: 0
Replicate_Rewrite_DB:
Channel_Name:
Master_TLS_Version:
1 row in set (0.00 sec)
ERROR:
No query specified
主從恢復正常。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22996654/viewspace-2771402/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Last_SQL_Error: Could not execute Update_rows eventASTSQLError
- ORACLE _small_table_threshold與eventOracle
- NoSuchObjectException(message:ods_db.event table not found)ObjectException
- MySQL案例01:Last_SQL_Errno: 1755 Cannot execute the current event group in the parallel modeMySqlASTParallel
- hibernate配置級聯刪除時報錯:could not execute statement; SQL [n/a]; constraint [null]SQLAINull
- The Execute Disable/No Execute CPU feature is not enabled for this machineMac
- mysql從庫伺服器down機報錯Could not parse relay log event entryMySql伺服器
- 解析MYSQL BINLOG 二進位制格式(4)--TABLE_MAP_EVENTMySql
- VMware: ESXi requires the Execute Disable/No Execute CPU feature to be enabledUI
- java cmd executeJava
- Extracting Data from a Corrupt Table using DBMS_REPAIR or Event 10231AI
- Execute to Parse 指標指標
- event_x ()、event_y ()、event_x_root ()、event_y_root ()
- app:processReleaseResources, Failed to execute aaptAPPAIAPT
- 理解EXECUTE_TO_PARSE(二)
- 理解EXECUTE_TO_PARSE(一)
- EXECUTE IMMEDIATE dynamic sql in procedureSQL
- ExecutorService之submit與executeMIT
- SQL can execute in wrong SchemaSQL
- Spring CouldSpring
- i_init_func_execute_data
- AWR Execute to Parse引數解析
- execute shell script from stored procedure
- EXECUTE DBMS_LOGSTDBY.BUILDUI
- execute immediate 語法小結
- event.preventDefault()和event.stopPropagation()
- JavaScript EventJavaScript
- Event LoopOOP
- apt could not get lockAPT
- VS Could not evaluate expressionExpress
- could not initialize proxy - no SessionSession
- Event ID: 1111 , Event Source: TermServDevicesdev
- Apache httpclient的execute方法除錯ApacheHTTPclient除錯
- 載入驅動三種execute
- execute immediate的簡單用法(oracle)Oracle
- 11g DBMS_PARALLEL_EXECUTEParallel
- revoke EXECUTE privileges on powerful packages from PUBLICPackage
- 在QTP中使用Eval與ExecuteQT