Skip to content

mysql slave reports an error during replication #359

@ownerlan

Description

@ownerlan

root@mysqldb 18:37: [(none)]> show slave status\G;
*************************** 1. row ***************************
Slave_IO_State:
Master_Host: 10.0.111.152
Master_User: crimoon
Master_Port: 23306
Connect_Retry: 60
Master_Log_File: INVALID
Read_Master_Log_Pos: 0
Relay_Log_File: NULL
Relay_Log_Pos: NULL
Relay_Master_Log_File: INVALID
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Slavete_Do_DB: NULL
Slavete_Ignore_DB: NULL
Slavete_Do_Table:
Slavete_Ignore_Table:
Slavete_Wild_Do_Table: NULL
Slavete_Wild_Ignore_Table: NULL
Last_Errno: 1105
Last_Error: received unknown event: {[13 222 174 104 29 1 0 0 0 120 0 0 0 159 13 0 0 128 0 96 105 110 115 101 114 116 32 105 110 116 111 32 97 99 99 111 117 110 116 32 118 97 108 117 101 115 40 49 48 48 48 48 48 50 44 53 44 39 122 122 95 122 122 122 53 50 49 51 53 57
Skip_Counter: NULL
Exec_Master_Log_Pos: 0
Relay_Log_Space: NULL
Until_Condition: None
Until_Log_File: NULL
Until_Log_Pos: NULL
Master_SSL_Allowed: Ignored
Master_SSL_CA_File: NULL
Master_SSL_CA_Path: NULL
Master_SSL_Cert: NULL
Master_SSL_Cipher: NULL
Master_SSL_CRL_File: NULL
Master_SSL_CRL_Path: NULL
Master_SSL_Key: NULL
Master_SSL_Verify_Server_Cert: NULL
Seconds_Behind_Master: 0
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 1105
Last_SQL_Error: received unknown event: {[13 222 174 104 29 1 0 0 0 120 0 0 0 159 13 0 0 128 0 96 105 110 115 101 114 116 32 105 110 116 111 32 97 99 99 111 117 110 116 32 118 97 108 117 101 115 40 49 48 48 48 48 48 50 44 53 44 39 122 122 95 122 122 122 53 50 49 51 53 57
Slavete_Ignore_Server_Ids: NULL
Master_Server_Id: 1
Master_UUID: b76f9ca1-830a-11f0-a599-0242ac110006
Master_Info_File: NULL
SQL_Delay: 0
SQL_Remaining_Delay: 0
Slave_SQL_Running_State: NULL
Master_Retry_Count: 86400
Master_Bind: NULL
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp: Wed Aug 27 10:29:33 UTC 2025
Retrieved_Gtid_Set: b76f9ca1-830a-11f0-a599-0242ac110006:1-4328
Executed_Gtid_Set: b76f9ca1-830a-11f0-a599-0242ac110006:1-4328
Auto_Position: 1
Slavete_Rewrite_DB: NULL
1 row in set (0.00 sec)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions