Re: error 1236 - missing file, but file still exists!

[Irfan Ali]

It look likes slave has forgotten replication positions.

Note down Exec_Master_Log_Pos from show slave status from slave.
and search noted position in master binary log noted from show slave status Relay_Master_Log_File value.

Once you find that position in master binary log via
master$ mysqlbinlog binlog-name | less
search for position

find
than

come to slave.
RESET SLAVE and restart replication from that position via CHANGE MASTER TO command

Somehow, if noted positon of slave didn't come up on master binary log than that's the problem and you need to manually verify till the position at which positon slave had replicated (via queries) and reset slave from that position but that's risky or you can reclone slave.