MySQL Bugs: #39017: backup_default test fails in pushbuild

Bug #39017	backup_default test fails in pushbuild
Submitted:	25 Aug 2008 17:34	Modified:	26 Aug 2008 9:51
Reporter:	Chuck Bell	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: Backup	Severity:	S3 (Non-critical)
Version:	6.0.7	OS:	Any
Assigned to:	Assigned Account	CPU Architecture:	Any

Description:
The test backup_default fails on 'sapsrv2' -max and 'pb-valgrind-*' Valgrind: in pushbuild with errors:

mysqltest: At line 67: query 'BACKUP DATABASE db1 to 'bup_falcon.bak'' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:
< snip >
DROP DATABASE db1;

Server should not crash for backup using default driver 
Partitioned Falcon tables
Test for bug#33566, bug#36792 

CREATE DATABASE db1;
USE db1;
CREATE TABLE partition_table (
int_column int(11), 
char_column char(5))
engine=falcon
PARTITION BY HASH (int_column);
INSERT INTO partition_table VALUES (0,'pVtIa');
INSERT INTO partition_table VALUES (5,'jTfSg');
INSERT INTO partition_table VALUES (20,'UezFi');
INSERT INTO partition_table VALUES (25,'cxmeH');
INSERT INTO partition_table VALUES (65,'lIuNS');
backup on partitioned falcon
BACKUP DATABASE db1 to 'bup_falcon.bak';

More results from queries before failure can be found in /dev/shm/var-n_mix-130/log/backup_default.log

Further investigation of the core file reveals:

(gdb) bt
#0  0x00002b636c1094c5 in _L_lock_13 () from /lib64/libpthread.so.0
#1  0x00002b636c109486 in pthread_rwlock_trywrlock ()
   from /lib64/libpthread.so.0
#2  0x0000000000000000 in ?? ()

How to repeat:
Run backup_default on sapsrv2 or pb-valgrind-*.

Suggested fix:
Debug this problem on a machine configured like sapsrv2 and pb-valgrind-*.

A portion of this test has been disabled pending the fix for this bug. See test file for more information.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/52478

2682 Chuck Bell	2008-08-25
      Disabled portion of tests. See BUG#39017 and BUG#39017.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/52479

2682 Chuck Bell	2008-08-25
      Disabled portion of tests. See BUG#39017 and BUG#39017.

Duplicate of bug#38910

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/52557

2683 Chuck Bell	2008-08-26
      Disabled another portion of the test for BUG#39017.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/52558

2683 Chuck Bell	2008-08-26
      Disabled another portion of the test for BUG#39017.

Pushed into 6.0.7-alpha  (revid:cbell@mysql.com-20080825181440-mchedihtqr60nr7v) (version source revid:oystein.grovlen@sun.com-20080902114026-4cz1ru0c8mb135hg) (pib:3)

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/53891

2693 He Zhenxing	2008-09-12 [merge]
      Merge 6.0 main -> 6.0-rpl

Pushed into 6.0.7-alpha  (revid:cbell@mysql.com-20080825181440-mchedihtqr60nr7v) (version source revid:hakan@mysql.com-20080725175322-8wgujj5xuzrjz3ke) (pib:3)

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/54481

2694 He Zhenxing	2008-09-22 [merge]
      Auto Merge