| Bug #41111 | events_bugs fails sporadically on pushbuild | ||
|---|---|---|---|
| Submitted: | 28 Nov 2008 18:18 | Modified: | 21 Jan 2009 16:20 |
| Reporter: | Matthias Leich | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Tests | Severity: | S3 (Non-critical) |
| Version: | 5.1 | OS: | Any |
| Assigned to: | Matthias Leich | CPU Architecture: | Any |
| Tags: | sporadic | ||
[28 Nov 2008 18:25]
Matthias Leich
One more problem: 5.1-bugteam (2008 End of Nov) ----------------------------------------------- --- r/events_bugs.result +++ r/events_bugs.reject @@ -130,8 +130,6 @@ set global event_scheduler= off; select * from events_smode_test order by ev_name, a; ev_name a -ee_16407_3 1980-02-19 -ee_16407_3 1980-02-29 ee_16407_4 0000-00-00 "OK, last check before we drop them" select event_schema, event_name, sql_mode from information_schema.events order by event_schema, event_name; @@ -183,6 +181,8 @@ event_scheduler localhost NULL NULL select * from events_smode_test order by ev_name, a; ev_name a +ee_16407_3 1980-02-19 +ee_16407_3 1980-02-29 ee_16407_6 2004-02-29 "And here we check one more time before we drop the events" select event_schema, event_name, sql_mode from information_schema.events order by event_schema, event_name;
[17 Dec 2008 20:44]
Matthias Leich
1. "2. mysql-6.0-rpl 2008-10-14" is most probably no more relevant because the version of this tests within 6.0-rpl was outdated. 2. 5.1-bugteam (2008 End of Nov) difference line 130 is most probably an effect of concurrent_inserts = on. difference 183 is most probably an effect of concurrent_inserts = on, but I have in this case doubts if this effect is legal 3. 5.1-rpl 2008-11-21 difference line 170 Unfortunate SELECTs (wait routine + current one) catch the event executor in a too early phase.
[5 Jan 2009 12:53]
Matthias Leich
See also Bug#41655 sporadic pushbuild failure in events_bugs: missing lines in output http://bugs.mysql.com/bug.php?id=41655
[7 Jan 2009 21:18]
Matthias Leich
The fix for the test should also contain a workaround for Bug#41925 Warning 1366 Incorrect string value: ... for column processlist.info
[9 Jan 2009 14:09]
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/62835 2726 Matthias Leich 2009-01-09 1. Fix for Bug#41111 events_bugs fails sporadically on pushbuild 2. Avoid bad effects of bug 41925 Warning 1366 Incorrect string value: ... for column processlist.info 3. Add poll routines which ensure that subtests meet stable scenarios. This does not change the sense of the subtests.
[12 Jan 2009 21:03]
Patrick Crews
ok to push.
[13 Jan 2009 16:27]
Matthias Leich
Pushed to 6.0-bugteam 5.1-bugteam
[14 Jan 2009 9:33]
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/63197 2748 He Zhenxing 2009-01-14 [merge] Auto merge
[15 Jan 2009 6:33]
Bugs System
Pushed into 5.1.31 (revid:joro@sun.com-20090115053147-tx1oapthnzgvs1ro) (version source revid:chad@mysql.com-20090114155637-vi1ld8rpsfh465go) (merge vers: 5.1.31) (pib:6)
[16 Jan 2009 3:46]
Paul DuBois
Test case changes. No changelog entry needed. Setting report to NDI pending push into 6.0.x.
[19 Jan 2009 11:26]
Bugs System
Pushed into 5.1.31-ndb-6.2.17 (revid:tomas.ulin@sun.com-20090119095303-uwwvxiibtr38djii) (version source revid:tomas.ulin@sun.com-20090115073240-1wanl85vlvw2she1) (merge vers: 5.1.31-ndb-6.2.17) (pib:6)
[19 Jan 2009 13:04]
Bugs System
Pushed into 5.1.31-ndb-6.3.21 (revid:tomas.ulin@sun.com-20090119104956-guxz190n2kh31fxl) (version source revid:tomas.ulin@sun.com-20090119104956-guxz190n2kh31fxl) (merge vers: 5.1.31-ndb-6.3.21) (pib:6)
[19 Jan 2009 15:42]
Jon Stephens
Setting status back to NDI pending merge to 6.0 tree.
[19 Jan 2009 16:10]
Bugs System
Pushed into 5.1.31-ndb-6.4.1 (revid:tomas.ulin@sun.com-20090119144033-4aylstx5czzz88i5) (version source revid:tomas.ulin@sun.com-20090119144033-4aylstx5czzz88i5) (merge vers: 5.1.31-ndb-6.4.1) (pib:6)
[20 Jan 2009 18:57]
Bugs System
Pushed into 6.0.10-alpha (revid:joro@sun.com-20090119171328-2hemf2ndc1dxl0et) (version source revid:timothy.smith@sun.com-20090114143745-x2dvnmix6gjlt6z6) (merge vers: 6.0.10-alpha) (pib:6)
[21 Jan 2009 16:20]
Paul DuBois
Test case changes. No changelog entry needed.
Description: 1. 5.1-rpl 2008-11-21 -------------------------------------------------- --- r/events_bugs.result 2008-11-21 +++ r/events_bugs.reject 2008-11-21 @@ -170,6 +170,11 @@ order by info; user host db info event_scheduler localhost NULL NULL +root localhost events_test CREATE PROCEDURE `ee_16407_2`() SQL SECURITY INVOKER begin +select get_lock('ee_16407_2', 60) /*ee_16407_2*/; +select release_lock('ee_16407_2'); +insert into events_test.events_smode_test values('ee_16407_2','1980-19-02'); +end root localhost events_test select get_lock('ee_16407_5', 60) root localhost events_test select get_lock('ee_16407_5', 60) select release_lock('ee_16407_5'); 2. mysql-6.0-rpl 2008-10-14 --------------------------- --- r/events_bugs.result +++ r/events_bugs.reject @@ -61,6 +61,7 @@ "Now if everything is fine the event has compiled and is locked" select /*1*/ user, host, db, info from information_schema.processlist where command!='Daemon' and (info is null or info not like '%processlist%') order by info; user host db info +root localhost NULL NULL root localhost events_test select get_lock('test_bug16407', 60) select release_lock('test_bug16407'); release_lock('test_bug16407') Here is an xref link that shows all the four symptoms above: http://tinyurl.com/6d347q How to repeat: See above