MySQL Bugs: #3516: Backup process bombs out with no error message

Bug #3516	Backup process bombs out with no error message
Submitted:	20 Apr 2004 17:41	Modified:	30 Jun 2004 20:44
Reporter:	Chris Gorton	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.0.3 Alpha	OS:	Microsoft Windows (Windows 2003)
Assigned to:	Bugs System	CPU Architecture:	Any

Description:
Backup process just stops part way through, progress window closes with no completion or error message appearing. 

File created is of variable length (3Mb upto 55Mb) so it's not failing at the same point each time, but it does appear to be at some point during the same table which is used for storing images on the database using field of type 'longblob'.

Process completes sucessfully on an identicle db with little or no data in this table or if the offending table is removed from the profile.

Table size is approx 65Mb for 900 images.

How to repeat:
Run backup for db with the problem table, fails every time

A similar failure occurs in Win2k SP4. 

I get partway through a backup and the process just stops prematurely.

I am attempting to backup an eventum database (as in the one produced by MySQL - http://dev.mysql.com/downloads/other/eventum/index.html).

I have recently added quite a few binary attachements to the system and the backup fails everytime at the same place - the eventum_issue_attachment_file table. The table definition is written out but then it fails.

Here is the last bit of the fragment of the backup file

CREATE TABLE `eventum_issue_attachment` (
  `iat_id` int(10) unsigned NOT NULL auto_increment,
  `iat_iss_id` int(10) unsigned NOT NULL default '0',
  `iat_usr_id` int(10) unsigned NOT NULL default '0',
  `iat_created_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `iat_description` text,
  PRIMARY KEY  (`iat_id`),
  KEY `iat_iss_id` (`iat_iss_id`,`iat_usr_id`)
) TYPE=MyISAM;
INSERT INTO `eventum_issue_attachment` (`iat_id`,`iat_iss_id`,`iat_usr_id`,`iat_created_date`,`iat_description`) VALUES (1,4,2,'2004-03-22 03:33:38',''),(2,13,2,'2004-04-30 00:47:44','COLS Reporting Extract for the Month of March as requested (in CSV format) and zipped.'),(3,16,2,'2004-05-06 01:04:25','Screen capture of the failure to create the account correctly within DTOL internal Site'),(4,16,2,'2004-05-06 01:12:15','Log Extracts - appear to indicate cause of the problem as being a string index out of bounds (not handled case) within the DB extraction code'),(5,17,2,'2004-05-11 06:03:45','Image detailing the way the creation of a Project dialog should occur');
CREATE TABLE `eventum_issue_attachment_file` (
  `iaf_id` int(10) unsigned NOT NULL auto_increment,
  `iaf_iat_id` int(10) unsigned NOT NULL default '0',
  `iaf_file` longblob,
  `iaf_filename` varchar(255) NOT NULL default '',
  `iaf_filetype` varchar(255) default NULL,
  `iaf_filesize` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`iaf_id`),
  KEY `iaf_iat_id` (`iaf_iat_id`)
) TYPE=MyISAM;

You should be able to recreate the problem by creating an eventum DB - as per the website, and then attaching various binary file types (jpg, gif and word docs).

Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/

Additional info:

Backup of tables that contain blobs should work in 1.0.5 already.