Bug #20290 Event mechanism incompatible with embedded server, but tests tried
Submitted: 6 Jun 2006 12:04 Modified: 26 Jun 2006 18:51
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:5.1.11-beta OS:Any (all)
Assigned to: Andrey Hristov CPU Architecture:Any

[6 Jun 2006 12:04] Joerg Bruehe
Description:
Build of 5.1.11-beta, based on ChangeSet
  1.2184.1.2 06/05/26 17:11:21 elliot@mysql.com +2 -0
  BUG#15868 InnoDB thread thrashing
  Restoring default innodb_thread_concurrency to 8
  This default now matches 5.0

All platforms fail all tests of the event mechanism when running "embedded":

=====
events                         [ fail ]

Errors are (from /PATH/mysqltest-time) :
YYMMDD HH:MM:SS [Warning] mysql_embedded: unknown variable 'loose-binlog-show-xid=0'

YYMMDD HH:MM:SS [Warning] mysql_embedded: unknown variable 'loose-binlog-show-xid=0'

mysqltest: At line NNN: query 'SET GLOBAL event_scheduler=1' failed: 1290: The MySQL server is running with the --event-scheduler=0 option so it cannot execute this statement
(the last lines may be the most important ones)
Result from queries before failure can be found in r/events.log
=====

Similar failures in the other event-related tests.

How to repeat:
Build + test the embedded server.

Suggested fix:
Disable tests of the event mechanism when testing the embedded server.
[23 Jun 2006 7:40] 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/8125
[26 Jun 2006 18:52] Andrey Hristov
The fixed test cases has been tested by pushbuild and have passed.