mysql 待更新

mysql 主从 error：1236

slave端

MariaDB [one]> show slave status\G      或 show master logs;

*************************** 1. row ***************************

Slave_IO_State:

Master_Host: 192.168.1.38

Master_User: rep

Master_Port: 3306

Connect_Retry: 60

Master_Log_File: master-bin.000001

Read_Master_Log_Pos: 748

Relay_Log_File: salve-bin.000002

Relay_Log_Pos: 1036

Relay_Master_Log_File: master-bin.000001

Slave_IO_Running: No

Slave_SQL_Running: Yes

Exec_Master_Log_Pos: 748

Relay_Log_Space: 1327

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 'master-bin.000001' at 748, the last event read from 'master-bin.000001' at 4, the last byte read from 'master-bin.000001' at 4.'

master端

MariaDB [one]> reset master;

Query OK, 0 rows affected (0.17 sec)

MariaDB [one]>show master logs;

+-------------------+-----------+

| Log_name| File_size |

+-------------------+-----------+

| master-bin.000001 |313 |

+-------------------+-----------+

1 row in set (0.00 sec)

slave端

MariaDB [one]>stop slave;

Query OK, 0 rows affected (0.00 sec)

MariaDB [one]> change master to master_log_pos=313;

Query OK, 0 rows affected (0.02 sec)

MariaDB [one]> start slave;

Query OK, 0 rows affected (0.00 sec)

MariaDB [one]> show slave status\G

Last_SQL_Errno: 0

Last_SQL_Error: