MySQL Forums
Forum List  »  Replication

Got fatal error 1236 from master when reading data from binary log
Posted by: sungju hong
Date: January 20, 2013 05:10AM

Hello

mysql version : 5.5.23
OS : ubuntu 11

The server that mysql master was running went down abnormally.
I booted server, ran mysql and it has no problem now.
But mysql slave is not replicating with following errors.

mysql> show slave status \G
*************************** 1. row ***************************
Slave_IO_State:
Master_Host: MYPSG-DB2
Master_User: repl_user
Master_Port: 3306
Connect_Retry: 5
Master_Log_File: mysql-bin.005880
Read_Master_Log_Pos: 1072130652
Relay_Log_File: relay-bin.001258
Relay_Log_Pos: 1072130798
Relay_Master_Log_File: mysql-bin.005880
Slave_IO_Running: No
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: 1072130652
Relay_Log_Space: 1072130991
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: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 1236
Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Client requested master to start replication from impossible position; the first event 'mysql-bin.005880' at 1072130652, the last event read from '/chaton/mysql/binlog/CHATON/mysql-bin.005880' at 4, the last byte read from '/chaton/mysql/binlog/CHATON/mysql-bin.005880' at 4.'
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 31
1 row in set (0.00 sec)

mysql>

error.log
130120 9:43:26 [ERROR] Error reading packet from server: Client requested master to start replication from impossible position; the first event 'mysql-bin.005880' at 1072130652, the last event read from '/chaton/mysql/binlog/CHATON/mysql-bin.005880' at 4, the last byte read from '/chaton/mysql/binlog/CHATON/mysql-bin.005880' at 4. ( server_errno=1236)
130120 9:43:26 [ERROR] Slave I/O: Got fatal error 1236 from master when reading data from binary log: 'Client requested master to start replication from impossible position; the first event 'mysql-bin.005880' at 1072130652, the last event read from '/chaton/mysql/binlog/CHATON/mysql-bin.005880' at 4, the last byte read from '/chaton/mysql/binlog/CHATON/mysql-bin.005880' at 4.', Error_code: 1236
130120 9:43:26 [Note] Slave I/O thread exiting, read up to log 'mysql-bin.005880', position 1072130652
130120 9:58:33 [Note] Error reading relay log event: slave SQL thread was killed
130120 9:58:37 [Note] Slave I/O thread: connected to master 'repl_user@MYPSG-DB2:3306',replication started in log 'mysql-bin.005880' at position 1072130652

Can anyone help me solve the problem ?

Options: ReplyQuote


Subject
Views
Written By
Posted
Got fatal error 1236 from master when reading data from binary log
51526
January 20, 2013 05:10AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.