Bug #17577 "SELECT ... FROM information_schema.events" fails when using PS protocol
Submitted: 20 Feb 2006 11:46 Modified: 17 Mar 2006 9:07
Reporter: Joerg Bruehe Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Prepared statements Severity:S2 (Serious)
Version:5.1.7-beta OS:several Unix
Assigned to: Assigned Account CPU Architecture:Any

[20 Feb 2006 11:46] Joerg Bruehe
Description:
Build of 5.1.7-beta, based on ChangeSet
  1.2139 06/02/20 00:32:07 kent@mysql.com +3 -0
  mysql-test-run.pl:
    Added --restart-cleanup option
  drop-on-restart.inc:
    DROP commands to cleanup on restart
    new file
  mysqltest.c:
    Added option --include=<sql-file>

This occurs in several test runs using the "PS" protocol:
-------------------------------------------------------
*** r/events.result
--- r/events.reject
***************
*** 301,309
  events_test   one_event       root@localhost  RECURRING       NULL    10      SECOND  #       #       ENABLED
  SELECT EVENT_CATALOG, EVENT_SCHEMA, EVENT_NAME, DEFINER, EVENT_BODY, EVENT_TYPE, EXECUTE_AT, INTERVAL_VALUE, INTERVAL_FIELD, STATUS,ON_COMPLETION, EVENT_COMMENT from information_schema.events;
  EVENT_CATALOG EVENT_SCHEMA    EVENT_NAME      DEFINER EVENT_BODY      EVENT_TYPE      EXECUTE_AT      INTERVAL_VALUE  INTERVAL_FIELD  STATUS  ON_COMPLETION   EVENT_COMMENT
- NULL  events_test     one_event       ev_test@localhost       select 123      RECURRING       NULL    20      SECOND  ENABLED NOT PRESERVE
- NULL  events_test     three_event     ev_test@localhost       select 123      RECURRING       NULL    20      SECOND  ENABLED PRESERVE        three event
- NULL  events_test     two_event       ev_test@localhost       select 123      RECURRING       NULL    20      SECOND  ENABLED NOT PRESERVE    two event
  NULL  events_test     one_event       root@localhost  select 123      RECURRING       NULL    10      SECOND  ENABLED NOT PRESERVE
  drop event one_event;
  drop event two_event;
--- 301,306
-------------------------------------------------------

Occurs:
aix52-64bit-5.1.log   ps
aix52-64bit-5.1.log   ps+rowrepl
bsd53-5.1.log   ps
cane-linuxthreads-5.1.log   ps
cane-linuxthreads-5.1.log   ps+rowrepl
etpglb0-5.1.log   ps
etpglb0-5.1.log   ps+rowrepl
pegasos3-glibc23-5.1.log   ps
pegasos3-glibc23-5.1.log   ps+rowrepl
powermacg5-5.1.log   ps
sol10-amd64-a-5.1.log   ps
sol10-amd64-a-5.1.log   ps+rowrepl
opnsrv6c-5.1.log   ps

Also (additional: timing issue in "show processlist", reported separate):
hammer-glibc23-5.1.log   ps
hammer-glibc23-5.1.log   ps+rowrepl
aix52-5.1.log   ps
aix52-5.1.log   ps+rowrepl

How to repeat:
Detected by running the test suite.
[17 Mar 2006 9:07] Andrey Hristov
Race condition, known, will be fixed as part of bug #17619