Bug #41186 rpl_stm_mystery22 fails sporadically on pushbuild while waiting for slave start
| Submitted: | 2 Dec 2008 19:54 | Modified: | 2 Jan 2009 17:07 |
|---|---|---|---|
| Reporter: | Sven Sandberg | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | Tests: Replication | Severity: | S7 (Test Cases) |
| Version: | 6.0-rpl, 5.1 | OS: | Any |
| Assigned to: | Assigned Account | CPU Architecture: | Any |
| Tags: | 6.0-rpl-green, pushbuild, sporadic, test failure | ||
[2 Dec 2008 19:54]
Sven Sandberg
[7 Dec 2008 20:44]
Serge Kozlov
Possible reason of error is following code: insert into t1 values(NULL,'new'); insert into t1 values(NULL,'new'); save_master_pos; connection slave; # wait until the slave tries to run the query, fails and abort slave thread source include/wait_for_slave_sql_error.inc Last line waits any SQL error therefore any unexpected SQL error will passed by test code as correct. We need to wait exact error number.
[7 Dec 2008 21:22]
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/60838 2747 Serge Kozlov 2008-12-08 Bug#41186: Possible reason of bug is waiting any sql error on slave instead exact number of error. The patch does following: 1) Add new parameter $slave_sql_errno for wait_for_slave_sql_error.inc 2) Add waiting error 1062 (Duplicate PK) for slave SQL thread in test case.
[12 Dec 2008 11:41]
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/61471 2708 Serge Kozlov 2008-12-12 Bug#41186: Possible reason of bug is waiting any sql error on slave instead exact number of error. The patch does following: 1) Add new parameter $slave_sql_errno for wait_for_slave_sql_error.inc 2) Add waiting error 1062 (Duplicate PK) for slave SQL thread in test case.
[12 Dec 2008 13:08]
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/61480 2751 Serge Kozlov 2008-12-12 [merge] Merge. Bug#40142, Bug#41108, Bug#41186
[15 Dec 2008 9:23]
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/61645 2743 He Zhenxing 2008-12-15 [merge] Auto merge
[19 Dec 2008 8:29]
Sven Sandberg
The bug causing this test to fail has not been fixed. However, the test has been rewritten so that the next failure will give a message pointing to the reason for the failure. Since it will fail with different symptoms, we will open a new bug for that and close the present bug.
[2 Jan 2009 14:20]
Sven Sandberg
The failure showed up once again in 6.0-rpl after the above patch was pushed (see xref), with the same symptom as before.
[2 Jan 2009 17:07]
Sven Sandberg
This is a duplicate of BUG#37718. See my comment on BUG#37718 from Jan 2 18:06.
[30 Jan 2009 13:30]
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 15:10]
Bugs System
Pushed into 5.1.32 (revid:luis.soares@sun.com-20090129165946-d6jnnfqfokuzr09y) (version source revid:alfranio.correia@sun.com-20081213194819-3u93g1xpzyy18u28) (merge vers: 5.1.31) (pib:6)
[17 Feb 2009 14:59]
Bugs System
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)
[17 Feb 2009 16:46]
Bugs System
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)
[17 Feb 2009 18:22]
Bugs System
Pushed into 5.1.32-ndb-6.2.17 (revid:tomas.ulin@sun.com-20090217134216-5699eq74ws4oxa0j) (version source revid:tomas.ulin@sun.com-20090201210519-vehobc4sy3g9s38e) (merge vers: 5.1.32-ndb-6.2.17) (pib:6)
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.050 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.