Skip navigation links

MySQL Forums :: Replication :: Got fatal error 1236 from master when reading data from binary log


Advanced Search

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 24129 sungju hong 01/20/2013 05:10AM
Re: Got fatal error 1236 from master when reading data from binary log 15931 Rick James 01/21/2013 10:41AM
Re: Got fatal error 1236 from master when reading data from binary log 10504 sungju hong 01/22/2013 06:21AM
Re: Got fatal error 1236 from master when reading data from binary log 10069 Rick James 01/23/2013 09:49PM
Re: Got fatal error 1236 from master when reading data from binary log 7333 sungju hong 01/30/2013 09:31PM


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.