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: | |
Category: | MySQL Administrator | Severity: | S3 (Non-critical) |
Version: | 1.0.3 Alpha | OS: | Windows (Windows 2003) |
Assigned to: | Ulrich Bayer | CPU Architecture: | Any |
[20 Apr 2004 17:41]
Chris Gorton
[19 May 2004 5:46]
Todd Morgan
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).
[30 Jun 2004 20:44]
Ulrich Bayer
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.