Bug #13698 MySQL server is hanging when I execute a bunch SP's in a script file.
Submitted: 3 Oct 2005 6:54 Modified: 3 Oct 2005 9:39
Reporter: Bharath J Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:MySql 5.0 RC OS:Windows (Win XP Prof SP2)
Assigned to: CPU Architecture:Any

[3 Oct 2005 6:54] Bharath J
Description:
[Bharath-Aztec]
Mysql Server is hanging when we execute a bunch of stored procedures in a script file.I tried to create and execute some stored procedures. I used mysql query browser and mysql command line client to execute these SP's.

Sometimes database is hanging and sometimes not. But if we repeat to execute the scripts continuously, we can observe a hang.If the hang happens, we don’t have any other option rather than forcibly closing that window.

How to repeat:
[Bharath-Aztec]
Steps to reproduce:

1.Copy the attached sql script file in you machine:

I assumed that you have Mysql 5.0.(RC Build) and Mysql query browser installed in your machine.

2.create a databse with name "test"

3.open MySql Query Browser,

4.Go to file menu and open script option,slect the script file to excute:

5.Now press the "execute" button.If it  is sucessfully executed try execute again and again.

We can see the hang even if we paste the scripts in command line client.
[3 Oct 2005 6:56] Bharath J
Script  file to reproduce this bug

Attachment: Scriptfile.sql (text/plain), 10.63 KiB.

[3 Oct 2005 9:39] Valeriy Kravchuk
I was unable to repeat the problem you described using the command line client (mysql) with 5.0.13-rc-nt. I've successfully pasted and executed your sript more then 10 times now...

But attempt to execute it second (!) time in the Query Browser (with mysql client session opened, that is, simultaneously) make the browser window hang for me. MySQL server still works after that.

So, this bug report has nothing to do with a server. You may open a new one for the Query Browser, in case you will be abke to repeat it each and every time using you script.