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

[25 Aug 2008 17:34] Chuck Bell
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-*.
[25 Aug 2008 17:34] Chuck Bell
A portion of this test has been disabled pending the fix for this bug. See test file for more information.
[25 Aug 2008 18:15] Bugs System
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.
[25 Aug 2008 18:16] Bugs System
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.
[26 Aug 2008 9:51] Jørgen Løland
Duplicate of bug#38910
[26 Aug 2008 13:29] Bugs System
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.
[26 Aug 2008 13:34] Bugs System
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.
[10 Sep 2008 15:29] Bugs System
Pushed into 6.0.7-alpha  (revid:cbell@mysql.com-20080825181440-mchedihtqr60nr7v) (version source revid:oystein.grovlen@sun.com-20080902114026-4cz1ru0c8mb135hg) (pib:3)
[11 Sep 2008 22:38] Bugs System
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
[13 Sep 2008 21:00] Bugs System
Pushed into 6.0.7-alpha  (revid:cbell@mysql.com-20080825181440-mchedihtqr60nr7v) (version source revid:hakan@mysql.com-20080725175322-8wgujj5xuzrjz3ke) (pib:3)
[23 Sep 2008 11:13] Bugs System
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