Got fatal error 1236 from master when reading data from binary log
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 ?
Subject
Views
Written By
Posted
Got fatal error 1236 from master when reading data from binary log
51525
January 20, 2013 05:10AM
27341
January 21, 2013 10:41AM
16579
January 22, 2013 06:21AM
16027
January 23, 2013 09:49PM
11905
January 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.