MySQL Bugs: #12431: mysqld-max.exe crashes when creating stored procedures

Bug #12431	mysqld-max.exe crashes when creating stored procedures
Submitted:	8 Aug 2005 12:07	Modified:	13 Aug 2005 7:39
Reporter:	Brad Tyler	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	5.0.10a-beta	OS:	Windows (Windows XP Pro)
Assigned to:		CPU Architecture:	Any

Description:
I just installed 5.0.10a-beta and I can no longer create stored procedures.  The previously installed version was 5.0.4 (and I was able to create stored procedures).  Now, whenever I attempt to create a stored procedure, mysqld-max.exe crashes (...The memory could not be "read").  Also, when I installed 5.0.10a-beta, my stored procedures disappeared.

How to repeat:
mysqld-max.exe consistantly crashes when attempting to create stored procedures, using both MySQL Query Browser and Administrator.

Could you please write here example store procedure which crashes mysql ?

Any stored procedure (even the most basic) I try to create will cause mysqld-max.exe to crash:

DELIMITER $$

DROP PROCEDURE IF EXISTS `in_out`.`GetStatus`$$
CREATE PROCEDURE `in_out`.`GetStatus` ()
BEGIN
  SELECT message_id, message
  from in_out.status;
END$$

DELIMITER ;

OS: Windows 2000
MySQL version: 5.0.10a-beta

I upgrade MySQL from 5.0.3 and now I can't create SP!

Example:

delimiter //
CREATE PROCEDURE simpletestprocedure ()
BEGIN

select 2;

END//
delimiter ;

Dies with error 2013 (HY000): Lost connection to MySQL server during query and error window pops-up:

mysqld-nt.exe - Application Error
The instruction at "0x0052da46" referenced memory at "0x70747365".
The memory could not be "read".
OK to terminate! :-(

Sorry...probably the bug was fixed. I was not able reproduce it on 5.0.11.
I tested on Windows 2003 and Linux SUSE 9.3.

Got the same error. I finally did the following:

1) Uninstalled all MySQL related items (Server, Administrator and Query Browser)
2) Deleted what was left in the MySQL directory after the unistalled (You must have a backup of your databases and all Stored Procedures of course)
3) Reinstalled everything (I did a complete install for the Server)
4) Ran my database backup scripts in Adminsitrator
4) Ran my Stored Procedure Scripts in Query Browser

And voila! After all that it finally worked.

It's possible that the databases were corrupted and that deleting everything solved the problem.

It's possible also that Query Browser was to blame. Before I reinstalled version 1.1.13, when I looked in the about window it stated that version 1.1.13 was installed but I'm really not sure it was really the case. The version number might have been wrong and by reinstalling everything, I finally installed the real version 1.1.13 and it worked. 

So before reinstalling everything, you might want to try uninstalling Query Browser and installing the last version.

I ended up installing version 5.0.10 on another PC (also XP pro).  This was a clean install and I was able to create/modify etc. stored procedures.  I then tried to create a stored procedure on the PC I was having problems with (connecting remotely via the other PC) and I got the same error.  I even tried a trial version of Navicat and still got the same error.  I also tried upgrading to version 5.0.11, but still had the same problem.  I ended up doing  a complete uninstall and reinstalled 5.0.11 and now everything is working fine.