MySQL Bugs: #62489: DROPed PROCEDURE reappearing

Bug #62489	DROPed PROCEDURE reappearing
Submitted:	21 Sep 2011 8:17	Modified:	22 Sep 2011 16:11
Reporter:	Jonathan Hartley	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	Various	OS:	Linux (SuSE 11.1,3,4)
Assigned to:		CPU Architecture:	Any

Description:
5.1.40-enterprise-gpl-advanced
5.1.50-enterprise-gpl-advanced
5.5.14

Procedures dropped reappear in a random amount of time.

On three versions above, I create a procedure - up to 10 different ones and if I remove it it reappears with nothing in the error log, the real problem occurs when you overwrite (i.e drop and recreate) a procedure, in a random amount of time it reverts back to the old version.
It can be between 12 hours and a couple of weeks.
This has happened on 3 servers running 5.1.50-enterprise-gpl-advanced
Two servers running 5.1.40-enterprise-gpl-advanced and one server running 5.5.14

How to repeat:
Create a procedure then drop it and wait

Suggested fix:
Is the information_schema.ROUTINES table not being flushed?

We need a 100% repeatable test case to fix this. So, please, try to reproduce this problem in some testing environment with your procedures, using 5.5.14 or, even better, 5.5.16 that was recently released. 

We must be sure that there are no dump/restore operations happening on a regular basis etc. So, test environment is a key requirement.