Bug #37932 binlog_killed_simulate fails sporadically on pushbuild
Submitted: 7 Jul 2008 15:03 Modified: 24 Feb 2009 1:40
Reporter: Sven Sandberg Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S7 (Test Cases)
Version:5.1+ OS:Any
Assigned to: Serge Kozlov CPU Architecture:Any
Tags: binlog_killed_simulate, disabled, pushbuild, sporadic, test failure

[7 Jul 2008 15:03] Sven Sandberg
Description:
binlog_killed_simulate fails in pushbuild with this error message:

binlog.binlog_killed_simulate  [ fail ]

CURRENT_TEST: binlog.binlog_killed_simulate
mysqltest: At line 49: query 'load data infile '../../std_data/rpl_loaddata.dat' into table t2 /* will be "killed" in the middle */' succeeded - should have failed with errno 1317...

The result from queries just before the failure was:
drop table if exists t1,t2;
create table t1  (a int) engine=MyISAM;
insert into t1 set a=1;
reset master;
update t1 set a=2 /* will be "killed" after work has been done */;
select
(@a:=load_file("MYSQLTEST_VARDIR/tmp/binlog_killed_bug27571.binlog"))
is not null;
(@a:=load_file("MYSQLTEST_VARDIR/tmp/binlog_killed_bug27571.binlog"))
is not null
1
select 1 /* must return 1 as query completed before got killed*/;
1
1
create table t2 (a int, b int) ENGINE=MyISAM;
reset master;
load data infile '../../std_data/rpl_loaddata.dat' into table t2 /* will be "killed" in the middle */;

More results from queries before failure can be found in /tmp/var-ps_stm_threadpool-6/log/binlog_killed_simulate.log

Stopping all servers...
Saving datadirs...
 - saving '/tmp/var-ps_stm_threadpool-6/mysqld.1'
Resuming tests...

Retrying, attempt(1/3)...

Restarting all servers

How to repeat:
 WHERE: 6.0-rpl/aelkin on Sat Jun 7 09:38:26 2008/'sol10-sparc-a' -max/ps_stm_threadpool
 URL: https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0-rpl&order=2

See also xref: http://tinyurl.com/57jscr
[8 Dec 2008 12:30] Alexander Nozdrin
binlog_killed_simulate.test is disabled due to this bug.
[15 Feb 2009 16:45] 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/66401

3048 Serge Kozlov	2009-02-15
      Bug#37932. Fixed by MTR2 patch and already re-enabled for 5.1.
      modified:
        mysql-test/suite/binlog/t/disabled.def

=== modified file 'mysql-test/suite/binlog/t/disabled.def'
--- a/mysql-test/suite/binlog/t/disabled.def	2009-02-15 11:45:53 +0000
+++ b/mysql-test/suite/binlog/t/disabled.def	2009-02-15 16:44:11 +0000
@@ -14,4 +14,3 @@ binlog_truncate_innodb	: BUG#42643 2009-
 binlog_multi_engine     : Bug#30544 istruewing 2007-11-26
 binlog_row_ctype_cp932  : Bug#33376 2007-12-19 mats Write set for table not set correctly when inserting an empty set
 binlog_base64_flag      : Bug#38316 sven 2007-12-14
-binlog_killed_simulate  : Bug#37932 kostja 2008-04-20

-- 
MySQL Code Commits Mailing List
For list archives: http://lists.mysql.com/commits
To unsubscribe:    http://lists.mysql.com/commits?unsub=commits@bugs.mysql.com
[19 Feb 2009 13:03] Bugs System
Pushed into 6.0.10-alpha (revid:sergey.glukhov@sun.com-20090218125737-5y5b2xo3duo1wlvo) (version source revid:serge.kozlov@sun.com-20090215164411-uydsh68gxid31yvg) (merge vers: 6.0.10-alpha) (pib:6)
[24 Feb 2009 1:40] Paul DuBois
Test case changes. No changelog entry needed.