Bug #30719 MySQL Daemon crashes when executing backup from MySQL Administrator
Submitted: 30 Aug 2007 11:56 Modified: 4 Sep 2007 9:23
Reporter: Joseph Bonello Email Updates:
Status: Closed Impact on me:
Category:MySQL Server Severity:S2 (Serious)
Version:5.1.21 OS:Any
Assigned to: CPU Architecture:Any
Tags: administrator, Instance

[30 Aug 2007 11:56] Joseph Bonello
When executing backup from the MySQL administrator, instance crashes.

Upgraded from MySQL 5.1.16

Administrator version: 1.2.12

Left everything default

Reverted back to 5.1.16, it works perfectly.

How to repeat:
Upgrade from 5.1.16 on Windows XP

Run administrator and run a saved backup.
[3 Sep 2007 8:42] Sveta Smirnova
Thank you for the report.

There is no mention about MySQL Instance Manager in the description (http://dev.mysql.com/doc/refman/5.1/en/instance-manager.html). So I thougth category has been choosed by mistake and changed it. If I was wrong please provide information which role MySQL Instance Manager plays in the problem.

Also please provide your error log file and backup file which crashes MySQL server.
[3 Sep 2007 9:35] Joseph Bonello
Where can I get the log files/crash files?

Thanks and Regards
[4 Sep 2007 5:33] Valeriy Kravchuk
Please, read http://dev.mysql.com/doc/refman/5.1/en/error-log.html. 

Error log is usually a file <hostname>.err in the data directory.
[4 Sep 2007 5:43] Joseph Bonello
The error occurs on 5.1.21 only, after the database was upgraded. I tried uninstalling 5.1.16 first and then re-installing 5.1.21, but when I went to the Administrator to take a backup (not restore!), the mysql instance failed. The administrator application did not crash, only the server.

Thanks for your help.

[4 Sep 2007 8:36] Sveta Smirnova
Thank you for the feedback.

In your error log many errors showing you have not run mysql_upgrade script. Please run it and try again.

If you still get errors please provide the backup file.
[4 Sep 2007 9:23] Joseph Bonello
Yes, running the upgrade script solved the problem. Thanks for your help.