Bug #18602 mysql.exe locks up
Submitted: 29 Mar 2006 3:45 Modified: 31 Aug 2006 9:27
Reporter: Jim Michaels Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:5.0.19 OS:Windows (Windows XP Pro MP)
Assigned to: Mike Lischke CPU Architecture:Any

[29 Mar 2006 3:45] Jim Michaels
Description:
after executing a 7MB script generated by mysqladministrator backup (with BLOBs) and server disconnecting and locking out mysql.exe from access, a service restart doesn't fix the problem. a subsequent run of mysql.exe causes a lockup.

How to repeat:
after executing a 7MB script generated by mysqladministrator backup (with BLOBs) and server disconnecting and locking out mysql.exe from access, a service restart doesn't fix the problem. a subsequent run of mysql.exe causes a lockup.

this is my best recollection.

Suggested fix:
if there is a loop trying to connect to the database, don't do it forever.
[29 Mar 2006 13:20] MySQL Verification Team
Thank you for the bug report. Is possible for you to provide the
dump file for to try on our side?. You can upload the zip file
at: ftp://ftp.mysql.com/pub/mysql/upload/

Thanks in advance.
[11 Apr 2006 23:18] Jim Michaels
script includes information_schema.  this  is the source of the problem.  should this be a problem?
[11 Apr 2006 23:27] Jim Michaels
in your upload directory, OVERFLOW.ZIP
[11 Jul 2006 13:15] MySQL Verification Team
Yes the source of the problem is the information_schema which now
isn't included when dumping with mysqldump client, then the workaround
when using MySQL Administrator is not check information_schema in the
dump list.
[31 Aug 2006 9:27] Mike Lischke
Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html