MySQL Bugs: #38603: rpl_trigger failed on pushbuild inside 'copy

Bug #38603	rpl_trigger failed on pushbuild inside 'copy_file' call
Submitted:	6 Aug 2008 12:40	Modified:	3 Feb 2009 14:20
Reporter:	Sven Sandberg	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Tests: Replication	Severity:	S7 (Test Cases)
Version:	5.0	OS:	Any
Assigned to:	Serge Kozlov	CPU Architecture:	Any
Tags:	copy_file, pushbuild, rpl_trigger, test failure

Description:
rpl_trigger failed on pushbuild with the following message:

rpl.rpl_trigger                [ fail ]

CURRENT_TEST: rpl.rpl_trigger
mysqltest: At line 306: command "copy_file" failed with error 1

The result from queries just before the failure was:
< snip >
UPDATE t11 SET f1=1 where f1=-1;
SELECT * from t11 /* must be f1 5 ... 1 */;
f1
5
4
3
2
1
SELECT * from t31 /* must be f3 5 * 100 ...  100 */;
f3
500
400
300
200
100
drop trigger trg11;
drop table t21,t31;
drop table t11;
STOP SLAVE;
FLUSH LOGS;

More results from queries before failure can be found in e:\var-ps_stm-102\log\rpl_trigger.log

Stopping all servers...
Saving datadirs...
 - saving 'e:/var-ps_stm-102/mysqld.1'
 - saving 'e:/var-ps_stm-102/mysqld.2'
Resuming tests...

Retrying, attempt(1/3)...

Restarting all servers

How to repeat:
https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0-rpl&order=11 vm-win2003-64-b/ps_stm

I think you can also look at updating mysqltest.c so that when it decides to "die" due to this error, it prints the errno.

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/64007

2718 Serge Kozlov	2009-01-25
      Bug#38603: 
      The patch adds restart of mysql server and replacing of binlog file 
      when mysql server is stopped.

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/64937

2766 Serge Kozlov	2009-02-03
      Bug#38603: 
      The patch adds restart of mysql server and replacing of binlog file when mysql server is stopped.

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/64941

2766 Serge Kozlov	2009-02-03
      Bug#38603: 
      The patch adds restart of mysql server and replacing of binlog file 
      when mysql server is stopped.

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/64942

3005 Serge Kozlov	2009-02-03 [merge]
      Bug#38603: 
      The patch adds restart of mysql server and replacing of binlog file 
      when mysql server is stopped.

Pushed into 5.1.32 (revid:joro@sun.com-20090203090549-gos3v4320vimrzg6) (version source revid:serge.kozlov@sun.com-20090202212649-m2hmzjuhgqskzwjr) (merge vers: 5.1.32) (pib:6)

No user-facing changes to document; closed without any further action.

Pushed into 6.0.10-alpha (revid:kostja@sun.com-20090204104420-mw1i2u9lum4bxjo6) (version source revid:serge.kozlov@sun.com-20090202212918-635naa9e1190hd6i) (merge vers: 6.0.10-alpha) (pib:6)

Pushed into 5.1.32-ndb-6.3.23 (revid:tomas.ulin@sun.com-20090217131017-6u8qz1edkjfiobef) (version source revid:tomas.ulin@sun.com-20090203133556-9rclp06ol19bmzs4) (merge vers: 5.1.32-ndb-6.3.22) (pib:6)

Pushed into 5.1.32-ndb-6.4.3 (revid:tomas.ulin@sun.com-20090217134419-5ha6xg4dpedrbmau) (version source revid:tomas.ulin@sun.com-20090203133556-9rclp06ol19bmzs4) (merge vers: 5.1.32-ndb-6.3.22) (pib:6)

Pushed into 5.1.32-ndb-6.2.17 (revid:tomas.ulin@sun.com-20090217134216-5699eq74ws4oxa0j) (version source revid:tomas.ulin@sun.com-20090203064601-uyuzm4mielj3fz76) (merge vers: 5.1.32-ndb-6.2.17) (pib:6)