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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.042 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.