Bug #43790 Procedure does not exits. while proc is allready there.
Submitted: 22 Mar 2009 13:51 Modified: 22 Apr 2009 14:42
Reporter: Iresh Patel Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Stored Routines Severity:S3 (Non-critical)
Version:mysql 5.0.51b OS:Windows (server 2003 rs standard edition)
Assigned to: CPU Architecture:Any
Tags: PROCEDURE

[22 Mar 2009 13:51] Iresh Patel
Description:
I am facing funny problem. Since y'day,it was ok. but today i am getting error "Procedure does not exits". I checked in query browser it is not showing in database. i checked in information_schema.routine table, it is not showing there. 

from mysql query browser 
When i go to create procedure it is giving "procedure allready exists" 
when i go to drop procedure it is giving "procedure does not exits" 

I developed my full system and running online since last 3 years. there are many procedure and triggers. it was running fine.since today morning facing problem. 
Can anybody help me ? 

Edited for :email me about replies to this topic 

How to repeat:
Here is code. it is giving aalatul procedure allready exists. 

delimiter // 
drop procedure if exists spStockSummary_updOp// 
Create Procedure spStockSummary_updOp () 
begin 
update stocksummary 
set opqty = 0 

end; 
//
[22 Mar 2009 14:42] MySQL Verification Team
Thank you for the bug report. The server version reported is quite older, could you please upgrade to the latest version and test again. Thanks in advance.
[22 Apr 2009 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".