MySQL Bugs: #26338: events_bugs.test fail on Debian

Bug #26338	events_bugs.test fail on Debian
Submitted:	13 Feb 2007 19:15	Modified:	2 Jun 2007 13:03
Reporter:	Ingo Strüwing	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Stored Routines	Severity:	S2 (Serious)
Version:	5.1.16	OS:	Linux (varying)
Assigned to:	Konstantin Osipov	CPU Architecture:	Any

Description:
Assigned directly to Tomash on his request.

This could be similar to Bug#25211 (events_bugs.test fails on sapsrv1).

events_bugs                    [ fail ]

Errors are (from /home/mydev/mysql-5.1-bug25460/mysql-test/var/log/mysqltest-time) :
mysqltest: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/events_bugs.result        2007-01-19 18:33:45.000000000 +0300
--- r/events_bugs.reject        2007-02-13 21:33:52.000000000 +0300
***************
*** 108,113 ****
--- 108,114 ----
  select /*2*/ user, host, db, info from information_schema.processlist where (command!='Daemon' || user='event_scheduler') and (info is null or info not like '%processlist%') order by info;
  user  host    db      info
  event_scheduler       localhost       NULL    NULL
+ event_scheduler       localhost       events_test     NULL
  root  localhost       events_test     select get_lock('ee_16407_2', 60)
  root  localhost       events_test     select get_lock('ee_16407_2', 60)
  root  localhost       events_test     select get_lock('ee_16407_2', 60)
-------------------------------------------------------
Please follow the instructions outlined at

It is possible that the problem appears on my system only due to Linux kernel Debian Sid kernel 2.6.16 PREEMPT. HW: Pentium4 (32 bit) 2.4GHz 2GB RAM.

How to repeat:
BUILD/compile-pentium-debug-max --with-debug=full --prefix="/home/mydev/install-5.1-bug25460"
cd mysql-test ; \
        /usr/bin/perl ./mysql-test-run.pl --force --mysqld=--binlog-format=mixed
Logging: ./mysql-test-run.pl --force --mysqld=--binlog-format=mixed
MySQL Version 5.1.16
Using binlog format 'mixed'
Using ndbcluster when necessary, mysqld supports it
Setting mysqld to support SSL connections
Binaries are debug compiled
Using MTR_BUILD_THREAD      = 80
Using MASTER_MYPORT         = 10800
Using MASTER_MYPORT1        = 10801
Using SLAVE_MYPORT          = 10802
Using SLAVE_MYPORT1         = 10803
Using SLAVE_MYPORT2         = 10804
Using NDBCLUSTER_PORT       = 10805
Using NDBCLUSTER_PORT_SLAVE = 10806
Using IM_PORT               = 10807
Using IM_MYSQLD1_PORT       = 10808
Using IM_MYSQLD2_PORT       = 10809

Closing this issue after speaking with Ingo and Shane. This bug can't currently be reproduced.

Re-opening this bug, because that "select" does not always yield the expected result.

In 5.1.18 test builds on RHAS3/ia64 (RPM build), I had:
-------------------------------------------------------
*** r/events_bugs.result
--- r/events_bugs.reject
***************
*** 114,119
--- 114,120
  select /*2*/ user, host, db, info from information_schema.processlist where (command!='Daemon' || user='event_scheduler')
 and (info is null or info not like '%processlist%') order by info;
  user  host    db      info
  event_scheduler       localhost       NULL    NULL
+ root  localhost       events_test     drop table "hashed_num"
  root  localhost       events_test     select get_lock('ee_16407_2', 60)
  root  localhost       events_test     select get_lock('ee_16407_2', 60)
  root  localhost       events_test     select get_lock('ee_16407_2', 60)
-------------------------------------------------------

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/26819

ChangeSet@1.2523, 2007-05-16 15:55:53+04:00, kostja@vajra.(none) +2 -0
  An attempt to fix event_bugs.test failure on Debian
  (Bug#26338 "events_bugs.test fail on Debian")

Pushed into 5.1.19-beta

Joerg, could you please check if this problem is still present?
A fix was pushed for this particular race, and there are other races, so I'm inlined to close the bug.

I started a 5.1.19-beta test build with the current BK sources on May 19,
and in this run this bug did not show up.

I do not take this as a proof the bug is fixed, because this one happens only sometimes, but there is some hope.

The other current "events_bugs" bug, bug#28285, re-occurred.

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/27389

ChangeSet@1.2517, 2007-05-26 16:36:38+02:00, andrey@whirlpool.mysql.com +10 -0
  Fix for
  bug#26338 events_bugs.test fail on Debian
  and
  bug#28285 Test "events_bugs" has instable results of "select /*1*/ ... from processlist"

Pushed into 5.1.20-beta

Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at

    http://dev.mysql.com/doc/en/installing-source.html

Documented bugfix in 5.1.20 changelog.