Bug #12442 NDB and Query Cache make test fail
Submitted: 8 Aug 2005 18:13 Modified: 7 Feb 2006 5:57
Reporter: Joerg Bruehe Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:5.0.11 and up OS:MacOS (Mac OS X 10.4 64bit (PowerPC))
Assigned to: Assigned Account CPU Architecture:Any

[8 Aug 2005 18:13] Joerg Bruehe
Description:
Build of 5.0.11, based on ChangeSet
  1.1950.1.1 05/08/06 03:10:35 kent@mysql.com +1 -0
  make_win_src_distribution.sh:
    Added missing backslashes

Test failure on "xserve-64bit", both "max" and "cluster", both default and PS tests:
-------------------------------------------------------
*** r/ndb_cache_multi2.result
--- r/ndb_cache_multi2.reject
***************
*** 61,76
  Qcache_hits   0
  select * from t1;
  a
! 3
  show status like "Qcache_queries_in_cache";
  Variable_name Value
  Qcache_queries_in_cache       2
  show status like "Qcache_inserts";
  Variable_name Value
! Qcache_inserts        3
  show status like "Qcache_hits";
  Variable_name Value
! Qcache_hits   0
  drop table t1, t2;
  set GLOBAL query_cache_size=0;
  set GLOBAL ndb_cache_check_time=0;
--- 61,76
  Qcache_hits   0
  select * from t1;
  a
! 2
  show status like "Qcache_queries_in_cache";
  Variable_name Value
  Qcache_queries_in_cache       2
  show status like "Qcache_inserts";
  Variable_name Value
! Qcache_inserts        2
  show status like "Qcache_hits";
  Variable_name Value
! Qcache_hits   1
  drop table t1, t2;
  set GLOBAL query_cache_size=0;
  set GLOBAL ndb_cache_check_time=0;
-------------------------------------------------------

How to repeat:
Test suite failure.
[5 Sep 2005 7:54] Stewart Smith
Cannot reproduce on x86 or ppc32 linux with latest BK. Will need access to specific machine to do further examination.
[5 Oct 2005 14:10] Joerg Bruehe
Again occurred in 5.0.14-rc, same symptom in these runs:
xserve-64bit-5.0-max.log   normal
xserve-64bit-5.0-max.log   ps-protocol
[19 Dec 2005 17:57] Joerg Bruehe
Continues to occur, for example in 5.0.17.
Never encountered on any other platform.
[7 Feb 2006 5:57] Jonas Oreland
dup, 16795