MySQL Bugs: #37729: 'Could not fetch stored procedures' error message when try to open schema

Bug #37729	'Could not fetch stored procedures' error message when try to open schema
Submitted:	29 Jun 2008 20:38	Modified:	9 Dec 2010 5:09
Reporter:	Arsen Barbakadze	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S1 (Critical)
Version:	1.2.12	OS:	Windows (Windows XP)
Assigned to:		CPU Architecture:	Any

Description:
When first time click on dropdown symbol of schema in order to see tables content then appears 'fetching data under schema name and then error message 'Could not fetch stored procedures'. Click on 'Ok' button and appears content of the schema. But when try run any script then every address to schema calls this error message again and the script is stopped.

How to repeat:
1.Launch browser
2.Click on dropdown triangle symbol next to the name of the schema comprising stored procedures.
3.Under schema name appears 'fetching data'
3. Observe that then appears error message 'Could not fetch stored procedures'
4.Click 'Ok' button, error message disappears and content of schema is showed
5.Run script which contains a reference to this schema like "use 'schema_name"
6. Script is stopped and again appears the same error message 'Could not fetch stored procedures'

Thank you for a problem report. What exact version of MySQL server are you connecting to?

The server version is 5.0.45.
Thank you.

Hey, Valeriy! Where are you? Tell me how I can handle this problem.
I cannot run my scripts. May be it's possible to switch off those procedures because I don't use them in my scripts? Or may be I have to be granted by any priveleges to see those procedures? When I run my scripts on version 4.1.12 there are no problem because it doesn't support stored procedures. Any idea?

Is it newly installed 5.0.45 or you had upgraded from some older version of MySQL?  

Please, send the results of:

use mysql;
show tables;

from it. Can you control that server completely or run mysql_upgrade utility on it?

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".

We experienced the exact problem and it turned out the issue was a bad naming of a stored procedure with a tick (`). 

Example procedure defintion:

DROP PROCEDURE IF EXISTS mydb.test $$
CREATE PROCEDURE mydb.t`est () 

Solution:

Edit the procedure name in the mysql.proc table to omit the tick.

Hope this helps,

Gary

the bug is: Could not fetch stored procedures

what is the solution for that?

hi there! 

is there anyone who can help me from my problem in mysql?

the problem is:  I lost my "Stored Procedures" in schema and when everytime i will open the schema,there is a dialog box containing "Could not fetch stored procedures"

How can I fixed this problem?How can I restore all those Stored Procedures? 

thanks!

hoping for your help..

John,

Do you still use MySQL Query Browser? Had you tried to use MySQL Workbench 5.2.30 instead?

Yes, I'm still using mysql querry browser.

Can you help me regarding my problem in MySql?

Good Day! thanks

Sorry, but old GUI tools are unsupported for almost a year already. It means that no bugs will be fixed in them.