Bug #21647 events tests fails with --with-ndbcluster
Submitted: 15 Aug 2006 6:10 Modified: 1 Sep 2006 7:56
Reporter: Stewart Smith Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Tests Severity:S3 (Non-critical)
Version:5.1.12bk OS:
Assigned to: Stewart Smith CPU Architecture:Any

[15 Aug 2006 6:10] Stewart Smith
Description:
*** r/events.result     2006-06-28 15:10:23.000000000 +0300
--- r/events.reject     2006-08-15 09:02:45.200620500 +0300
***************
*** 312,317 ****
--- 312,318 ----
  select /*1*/ user, host, db, command, state, info from information_schema.processlist where info is null or info not like '%processlist%' order by info;
  user  host    db      command state   info
  event_scheduler       localhost       NULL    Connect Suspended       NULL
+ system user                   Daemon  Waiting for event from ndbclus  NULL
  select release_lock("test_lock1");
  release_lock("test_lock1")
  1
***************
*** 332,337 ****
--- 333,339 ----
  select /*2*/ user, host, db, command, state, info from information_schema.processlist where info is null or info not like '%processlist%' order by info;
  user  host    db      command state   info
  event_scheduler       localhost       NULL    Connect Sleeping        NULL
+ system user                   Daemon  Waiting for event from ndbclus  NULL
  root  localhost       events_test     Connect User lock       select get_lock("test_lock2", 20)
  "Release the mutex, the event worker should finish."
  "Release the mutex, the event worker should finish."
***************
*** 348,359 ****
--- 350,363 ----
  select /*3*/ user, host, db, command, state, info from information_schema.processlist where info is null or info not like '%processlist%' order by info;
  user  host    db      command state   info
  event_scheduler       localhost       NULL    Connect Sleeping        NULL
+ system user                   Daemon  Waiting for event from ndbclus  NULL
  root  localhost       events_test     Connect User lock       select get_lock("test_lock2_1", 20)
  set global event_scheduler=2;
  "Should have only our process now:"
  select /*4*/ user, host, db, command, state, info from information_schema.processlist where info is null or info not like '%processlist%' order by info;
  user  host    db      command state   info
  event_scheduler       localhost       NULL    Connect Suspended       NULL
+ system user                   Daemon  Waiting for event from ndbclus  NULL
  root  localhost       events_test     Connect User lock       select get_lock("test_lock2_1", 20)
  drop event закачка21;
  create table t_16 (s1 int);
-------------------------------------------------------

How to repeat:
 ./mysql-test-run.pl --with-ndbcluster events 

Suggested fix:
events test case handle presence of ndb injector thread
[15 Aug 2006 11:47] Stewart Smith
also events_bugs (possibly others)
[15 Aug 2006 11:53] 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/10464

ChangeSet@1.2276, 2006-08-15 19:53:16+08:00, stewart@willster.(none) +4 -0
  BUG#21647 events tests fails with --with-ndbcluster
  
  ignore the ndb injector thread when selecting from INFORMATION_SCHEMA.PROCESSLIST
[15 Aug 2006 12:15] Stewart Smith
approved by martin, pushed to 5.1-ndb tree
[1 Sep 2006 7:56] Jonas Oreland
pushed to 5.1 no need to document