Description:
The problem found for bug#37710.
Even bug appears for replication it is not a replication issue.
There are master and slave. Master has the corrupted table mysql.proc.
DROP DATABASE on master performed successfully but returns following warning:
Warnings:
Error 1017 Can't find file: 'proc' (errno: 2)
Same statement on slave returns the error :
Query caused different errors on master and slave. Error on master:
'Can't find file: '%-.200s' (errno: %d)' (1017), Error on slave: 'no error' (0). Default
database: 'mysqltest1'. Query: 'DROP DATABASE mysqltest1'
How to repeat:
Please use description or attached file with test case.
Suggested fix:
Mats suggestion:
Probably there are two options to solve the problem:
1. It is not critical and then it should not be an error in the warning stack
2.It is critical and do not allow the DROP statement to proceed, effectively leaving database in place.