Bug #15620 Test case failure 'ndb_cache_multi2' on powermac
Submitted: 9 Dec 2005 9:35 Modified: 16 Jan 2006 16:19
Reporter: Kristian Nielsen Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:clone-5.0.17-build OS:MacOS (MacOSX 10.4)
Assigned to: Jonas Oreland CPU Architecture:Any

[9 Dec 2005 9:35] Kristian Nielsen
Description:
The test case 'ndb_cache_multi2' fails on MacOSX 10.4:

09631: ndb_cache_multi2               [ fail ]
09632: 
09633: Errors are (from /Users/mysqldev/xserve-64bit/test/mysql-max-5.0.17-osx10.4-powerpc-64bit/mysql-test/var/log/mysqltest-time) :
09634: mysqltest: At line 1400024: Result content mismatch
09635: (the last lines may be the most important ones)
09636: Below are the diffs between actual and expected results:
09637: -------------------------------------------------------
09638: *** r/ndb_cache_multi2.result	Thu Dec  8 08:59:34 2005
09639: --- r/ndb_cache_multi2.reject	Thu Dec  8 10:07:32 2005
09640: ***************
09641: *** 61,76 ****
09642:   Qcache_hits	0
09643:   select * from t1;
09644:   a
09645: ! 3
09646:   show status like "Qcache_queries_in_cache";
09647:   Variable_name	Value
09648:   Qcache_queries_in_cache	2
09649:   show status like "Qcache_inserts";
09650:   Variable_name	Value
09651: ! Qcache_inserts	3
09652:   show status like "Qcache_hits";
09653:   Variable_name	Value
09654: ! Qcache_hits	0
09655:   drop table t1, t2;
09656:   set GLOBAL query_cache_size=0;
09657:   set GLOBAL ndb_cache_check_time=0;
09658: --- 61,76 ----
09659:   Qcache_hits	0
09660:   select * from t1;
09661:   a
09662: ! 2
09663:   show status like "Qcache_queries_in_cache";
09664:   Variable_name	Value
09665:   Qcache_queries_in_cache	2
09666:   show status like "Qcache_inserts";
09667:   Variable_name	Value
09668: ! Qcache_inserts	2
09669:   show status like "Qcache_hits";
09670:   Variable_name	Value
09671: ! Qcache_hits	1
09672:   drop table t1, t2;
09673:   set GLOBAL query_cache_size=0;
09674:   set GLOBAL ndb_cache_check_time=0;
09675: -------------------------------------------------------

How to repeat:
Run the test suite on MacOSX. Not sure if it is repeatable or sporadic, it only failed on this particular platform during a test release build.
[16 Jan 2006 16:19] Jonas Oreland
I've run the ndb testcases 5-6 times in loop wo/ any problems
  (5.0.18)