Bug #32654 rpl_view.test fails randomly
Submitted: 23 Nov 2007 13:01 Modified: 30 Jan 17:57
Reporter: Ingo Strüwing
Status: Closed
Category:Tests: Replication Severity:S2 (Serious)
Version:5.0.54 OS:Any
Assigned to: Serge Kozlov Target Version:5.0+
Tags: pbfail
Triage: D3 (Medium)

[23 Nov 2007 13:01] Ingo Strüwing
Description:
rpl_view                       [ fail ]

ERROR: Failed to start slave mysqld 0

Stopping All Servers

Disabling test case. Please re-enable after fix.

How to repeat:
See pushbuild, for example
https://intranet.mysql.com/secure/pushbuild/showdir.pl?dir=mysql-5.0-engines
log
https://intranet.mysql.com/secure/pushbuild/getlog.pl?dir=mysql-5.0-engines&entry=rkalimul...
See also
https://intranet.mysql.com/secure/pushbuild/xref.pl?startdate=&enddate=&dir=&plat=&testtyp...
[28 Nov 2007 11:23] Bugs System
Pushed into 6.0.4-alpha
[28 Nov 2007 11:25] Bugs System
Pushed into 5.1.23-rc
[28 Nov 2007 11:27] Bugs System
Pushed into 5.0.54
[4 Apr 2008 12:47] Serge Kozlov
The slave server should be restarted because rpl_test has option file for slave. During
restarting slave DB directory should be recreated again. It happened under Windows and
probably some files still were 'in-use' by OS/mysql when mtr tried to deleted them.

Slave option file points to skip 'test.foo' table for replication. But table named 'foo'
doesn't used for test rpl_view. So option file 'rpl_view-slave.opt' can be removed and
mtr will not restart the slave before test case.
[4 Apr 2008 13:05] 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/44908

ChangeSet@1.2612, 2008-04-04 15:03:40+04:00, skozlov@mysql.com +2 -0
  Bug#32654. Removed option file for slave.
[4 Apr 2008 13:14] 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/44909

ChangeSet@1.2611, 2008-04-04 15:13:12+04:00, skozlov@mysql.com +2 -0
  Bug#32654, removed option file for slave
[6 Apr 2008 20:25] 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/44963

ChangeSet@1.2611, 2008-04-06 22:24:29+04:00, skozlov@mysql.com +2 -0
  Bug#32654. The reason of bug is incorrect clean up during restarting of mysqld under
Windows platform (seems some files were in-use). 
  Mtr restarts servers because an option file exist for slave.
  The option file for slave forces to skip test.foo table for replication. 
  But really test case does not invlved test.foo table at all.
  So option file can be removed and mtr will not restart servers for test case.
[28 Jul 2008 20:56] Patrick Crews
Pushed into 5.1.28
Pushed into 6.0.7
[28 Jul 2008 21:01] Paul DuBois
Test case change. No changelog entry needed.
[14 Sep 2008 5:43] Bugs System
Pushed into 6.0.7-alpha 
(revid:sp1r-skozlov/ksm@mysql.com/virtop.(none)-20080406182429-24492) (version source
revid:v.narayanan@sun.com-20080820070709-nx09bk6qx81osd5s) (pib:3)
[15 Sep 2008 10:13] Bugs System
Pushed into 5.0.70  (revid:sp1r-skozlov/ksm@mysql.com/virtop.(none)-20080406182429-24492)
(version source revid:vvaintroub@mysql.com-20080901112738-k8dc67kp067pyo7h) (pib:3)
[26 Sep 2008 14:30] 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/54543

2698 He Zhenxing	2008-09-26 [merge]
      Merge 5.1 main -> 5.1-rpl
[1 Oct 2008 18:06] Bugs System
Pushed into 5.1.28  (revid:sp1r-skozlov/ksm@mysql.com/virtop.(none)-20080406182429-24492)
(version source revid:vvaintroub@mysql.com-20080901100428-cbaww4rp1vdsujk7) (pib:4)
[28 Oct 2008 22:06] Bugs System
Pushed into 5.1.29-ndb-6.2.17 
(revid:sp1r-skozlov/ksm@mysql.com/virtop.(none)-20080406182429-24492) (version source
revid:tomas.ulin@sun.com-20081028140209-u4emkk1xphi5tkfb) (pib:5)
[28 Oct 2008 23:24] Bugs System
Pushed into 5.1.29-ndb-6.3.19 
(revid:sp1r-skozlov/ksm@mysql.com/virtop.(none)-20080406182429-24492) (version source
revid:tomas.ulin@sun.com-20081028194045-0353yg8cvd2c7dd1) (pib:5)
[1 Nov 2008 10:50] Bugs System
Pushed into 5.1.29-ndb-6.4.0 
(revid:sp1r-skozlov/ksm@mysql.com/virtop.(none)-20080406182429-24492) (version source
revid:jonas@mysql.com-20081101082305-qx5a1bj0z7i8ueys) (pib:5)
[28 Jan 13:55] Lars Thalmann
This test is still failing in rpl trees.
Re-opening the bug.
[28 Jan 22:12] 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/64395

2804 Serge Kozlov	2009-01-29
      Bug#32654. Re-enabled
[29 Jan 10:27] 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/64426

2803 Serge Kozlov	2009-01-29
      Bug#32654. Re-enabled
[30 Jan 14:27] Bugs System
Pushed into 6.0.10-alpha (revid:luis.soares@sun.com-20090129165607-wiskabxm948yx463)
(version source revid:luis.soares@sun.com-20090129163120-e2ntks4wgpqde6zt) (merge vers:
6.0.10-alpha) (pib:6)
[30 Jan 17:57] Paul DuBois
Test case changes. No changelog entry needed.