Bug #34155 Backup: restore hangs if 2712 rows
Submitted: 30 Jan 2008 0:12 Modified: 27 Feb 2008 21:55
Reporter: Peter Gulutzan Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Backup Severity:S3 (Non-critical)
Version:6.0.5-alpha-debug OS:Linux (SUSE 10 64-bit)
Assigned to: Chuck Bell CPU Architecture:Any

[30 Jan 2008 0:12] Peter Gulutzan 
Description:
I'm using 6.0-backup.

I create a MyISAM table with 2711 rows.
I say BACKUP + RESTORE. RESTORE takes 0.3 seconds.

I create a MyISAM table with 2712 rows.
I say BACKUP + RESTORE. RESTORE takes forever.

How to repeat:
/*
The only difference between the following
two scripts is: the first says '2711', the
second says '2712'. The first succeeds.
The second fails.
*/

delimiter //
use test
drop database w//
create database w//
use w
create table t (s1 int) engine=myisam//
create procedure p (param1 int)
begin
  declare v int default 0;
  while v < param1 do
    insert into t values (1);
    set v = v + 1;
    end while;
  end//
call p(2711)//
backup database w to '2711'//
restore from '2711'//

delimiter //
use test
drop database w//
create database w//
use w
create table t (s1 int) engine=myisam//
create procedure p (param1 int)
begin
  declare v int default 0;
  while v < param1 do
    insert into t values (1);
    set v = v + 1;
    end while;
  end//
call p(2712)//
backup database w to '2712'//
restore from '2712'//
[30 Jan 2008 9:25] MySQL Verification Team 
Thank you for the bug report. Verified as described.
[27 Feb 2008 21:55] Chuck Bell 
Retested bug in latest mysql-6.0-backup tree. Bug does not appear.