My slave machine reset and now on SLAVE SHOW STATUS\G I have the error:
Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Client requested master to start replication from position > file size'
The slave settings are showing as:
Master_Log_File: bin.003767 Read_Master_Log_Pos: 751854814 Relay_Log_File: mysql-relay-bin.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: bin.003767 Slave_IO_Running: No Slave_SQL_Running: Yes
However the relay-bin files on the slave are: mysql-relay-bin.000001 with 1KB in size. The Master on the other hand has the files: bin.003767 at over 700 megs. But no relay files are being updated or copied to the slave.
Is there any way to resolve this without a full data synchronization from beginning? It takes days to achieve this.
Does anyone know what the issue is here?