Bug #32654 rpl_view.test fails randomly
Submitted: 23 Nov 2007 12:01 Modified: 30 Jan 2009 16:57
Reporter: Ingo Strüwing Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Replication Severity:S7 (Test Cases)
Version:5.0.54 OS:Any
Assigned to: Serge Kozlov CPU Architecture:Any
Tags: pbfail

[23 Nov 2007 12: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 10:23] Bugs System 
Pushed into 6.0.4-alpha
[28 Nov 2007 10:25] Bugs System 
Pushed into 5.1.23-rc
[28 Nov 2007 10:27] Bugs System 
Pushed into 5.0.54
[4 Apr 2008 10: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 11: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 11: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 18: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 18:56] Patrick Crews 
Pushed into 5.1.28
Pushed into 6.0.7
[28 Jul 2008 19:01] Paul DuBois 
Test case change. No changelog entry needed.
[14 Sep 2008 3: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 8: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 12: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 16: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 21: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 22: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 9: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 2009 12:55] Lars Thalmann 
This test is still failing in rpl trees.
Re-opening the bug.
[28 Jan 2009 21: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 2009 9: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 2009 13: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 2009 16:57] Paul DuBois 
Test case changes. No changelog entry needed.