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:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:5.1 OS:Any
Assigned to: Matthias Leich CPU Architecture:Any
Tags: sporadic
Triage: Triaged: D3 (Medium)

[28 Nov 2008 18:18] Matthias Leich
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
[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.