Bug #22069 skip_name_resolve, sp-threads, and sp_notembedded fail on pending events
Submitted: 7 Sep 2006 7:29 Modified: 15 Sep 2006 21:14
Reporter: Ingo Strüwing Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S2 (Serious)
Version:5.1.12 OS:Linux (Linux)
Assigned to: Stewart Smith CPU Architecture:Any

[7 Sep 2006 7:29] Ingo Strüwing
Description:
skip_name_resolve              [ fail ]

Errors are (from /mnt/hdb7/mytest/testdir-5.1-auto-1/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/skip_name_resolve.result  2006-05-23 13:10:00.000000000 +0300
--- r/skip_name_resolve.reject  2006-09-07 09:32:52.000000000 +0300
***************
*** 10,15 ****
--- 10,16 ----
  #
  show processlist;
  Id    User    Host    db      Command Time    State   Info
+ <id>  system user     <host>  NULL    <command>       <time>  <state> <info>
  <id>  event_scheduler <host>  NULL    <command>       <time>  <state> <info>
  <id>  root    <host>  test    <command>       <time>  <state> <info>
  <id>  root    <host>  test    <command>       <time>  <state> <info>
-------------------------------------------------------
Please follow the instructions outlined at

sp-threads                     [ fail ]

Errors are (from /mnt/hdb7/mytest/testdir-5.1-auto-1/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/sp-threads.result 2006-05-23 14:32:12.000000000 +0300
--- r/sp-threads.reject 2006-09-07 09:35:19.000000000 +0300
***************
*** 34,39 ****
--- 34,40 ----
   call bug9486();
  show processlist;
  Id    User    Host    db      Command Time    State   Info
+ #     system user     localhost               Daemon  #       Waiting for event from ndbcluster       NULL
  #     event_scheduler localhost       NULL    Connect #       Suspended       NULL
  #     root    localhost       test    Sleep   #               NULL
  #     root    localhost       test    Query   #       Locked  update t1, t2 set val= 1 where id1=id2
-------------------------------------------------------
Please follow the instructions outlined at

sp_notembedded                 [ fail ]

Errors are (from /mnt/hdb7/mytest/testdir-5.1-auto-1/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/sp_notembedded.result     2006-07-26 13:40:19.000000000 +0300
--- r/sp_notembedded.reject     2006-09-07 09:36:56.000000000 +0300
***************
*** 18,27 ****
--- 18,29 ----
  end|
  call bug4902_2()|
  Id    User    Host    db      Command Time    State   Info
+ #     system user     localhost               Daemon  #       Waiting for event from ndbcluster       NULL
  #     event_scheduler localhost       NULL    Connect #       Suspended       NULL
  #     root    localhost       test    Query   #       NULL    show processlist
  call bug4902_2()|
  Id    User    Host    db      Command Time    State   Info
+ #     system user     localhost               Daemon  #       Waiting for event from ndbcluster       NULL
  #     event_scheduler localhost       NULL    Connect #       Suspended       NULL
  #     root    localhost       test    Query   #       NULL    show processlist
  drop procedure bug4902_2|
-------------------------------------------------------
Please follow the instructions outlined at

How to repeat:
BUILD/compile-pentium-debug-max
cd mysql-test
./mysql-test-run.pl skip_name_resolve sp-threads sp_notembedded
[7 Sep 2006 11:18] Andrey Hristov
The thread is the ndb binlog injector. Changing the category to cluster.
[15 Sep 2006 21:14] Jonas Oreland
I run the command supplied in a loop a 100 times wo/ getting this.
We need more info.
[16 Sep 2006 2:22] Stewart Smith
I've seen something like this on some other tests but only --with-ndbcluster to mysql-test-run.pl.

I also remember filing some bugs about it (think i even got some fixes pushed). I have a patch here that "properly" fixes it by allowing you to easily exclude the ndb binlog thread (by its User) that will be a complete fix.