Description:
The ndb_cache2 and ndb_cache_multi2 tests fail for me on Linux x86_64. Apparently they're missing one cache hit.
How to repeat:
TEST RESULT
-------------------------------------------------------
ndb_cache2 [ fail ]
Errors are (from /home/jimw/my/mysql-5.1-clean/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/ndb_cache2.result 2005-11-08 02:03:39.000000000 +0300
--- r/ndb_cache2.reject 2005-11-17 03:44:58.000000000 +0300
***************
*** 561,570 ****
Qcache_queries_in_cache 5
show status like "Qcache_inserts";
Variable_name Value
! Qcache_inserts 10
show status like "Qcache_hits";
Variable_name Value
! Qcache_hits 5
select * from t1 order by pk desc;
pk a1 b1 c1
5 6 3 New row
--- 561,570 ----
Qcache_queries_in_cache 5
show status like "Qcache_inserts";
Variable_name Value
! Qcache_inserts 11
show status like "Qcache_hits";
Variable_name Value
! Qcache_hits 4
select * from t1 order by pk desc;
pk a1 b1 c1
5 6 3 New row
***************
*** 586,595 ****
Qcache_queries_in_cache 5
show status like "Qcache_inserts";
Variable_name Value
! Qcache_inserts 10
show status like "Qcache_hits";
Variable_name Value
! Qcache_hits 10
select * from t1 order by pk desc;
pk a1 b1 c1
5 6 3 New row
--- 586,595 ----
Qcache_queries_in_cache 5
show status like "Qcache_inserts";
Variable_name Value
! Qcache_inserts 11
show status like "Qcache_hits";
Variable_name Value
! Qcache_hits 9
select * from t1 order by pk desc;
pk a1 b1 c1
5 6 3 New row
***************
*** 611,620 ****
Qcache_queries_in_cache 5
show status like "Qcache_inserts";
Variable_name Value
! Qcache_inserts 10
show status like "Qcache_hits";
Variable_name Value
! Qcache_hits 15
drop table t1, t2, t3, t4, t5;
show status like "Qcache_queries_in_cache";
Variable_name Value
--- 611,620 ----
Qcache_queries_in_cache 5
show status like "Qcache_inserts";
Variable_name Value
! Qcache_inserts 11
show status like "Qcache_hits";
Variable_name Value
! Qcache_hits 14
drop table t1, t2, t3, t4, t5;
show status like "Qcache_queries_in_cache";
Variable_name Value
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.
