Bug #6212 mysqldump causes MySQL to crash
Submitted: 22 Oct 2004 11:11 Modified: 22 Oct 2004 12:19
Reporter: Christopher Taylor Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: mysqldump Command-line Client Severity:S1 (Critical)
Version:4.0.21 OS:Windows (Windows XP SP 2)
Assigned to: CPU Architecture:Any

[22 Oct 2004 11:11] Christopher Taylor 
Description:
When trying to do a --opt mysqldump, MySQL crashes

How to repeat:
Load the following into the system:

CREATE TABLE background_task_definition (
  id bigint(32) unsigned NOT NULL auto_increment,
  class_name varchar(255) NOT NULL default '',
  description varchar(255) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=InnoDB;

--
-- Table structure for table `background_tasks`
--

CREATE TABLE background_tasks (
  id bigint(32) unsigned NOT NULL default '0',
  time time NOT NULL default '00:00:00',
  period varchar(100) NOT NULL default '',
  PRIMARY KEY  (id),
  CONSTRAINT `0_2015` FOREIGN KEY (`id`) REFERENCES `background_task_definition` (`id`) ON DELETE CASCADE
) TYPE=InnoDB;

You don't need any data for this to crash

Suggested fix:
Well, I've gone back to 4.0.20a without any problems.
[22 Oct 2004 12:19] Marko Mäkelä 
This is a duplicate of Bug #5538, which has been fixed in the not-yet-released 4.0.22.