MySQL Bugs: #16795: ndb_cache

Bug #16795	ndb_cache_multi2
Submitted:	26 Jan 2006 2:51	Modified:	8 Mar 2006 13:44
Reporter:	Brian Aker	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S3 (Non-critical)
Version:	5.0,5.1	OS:	Linux (FC4 AMD64)
Assigned to:	Magnus Blåudd	CPU Architecture:	Any

Description:
Hi!

I am seeing this error in tests every 3rd or 4th build:

*** r/ndb_cache_multi2.result   2006-01-02 04:07:58.000000000 +0300
--- r/ndb_cache_multi2.reject   2006-01-26 05:36:02.000000000 +0300
***************
*** 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;
-------------------------------------------------------
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.

Ending Tests
Shutting-down MySQL daemon

How to repeat:
./build/compile-amd64-debug-max
cd mysql-test
./mysql-test-run --force

Tried to reproduce. No luck yet.

It can bee seen failures of "ndb_cache_multi2" on some build hosts, guess I have to try on one of those.

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/2689

Pushed a fix to 5.0.19 and 5.1.8 that makes the ndb_cache_multi2 test case more stable by making it select from  the table until the expected data is there instead of sleeping a fixed amount of time.

ndb_cache_multi2 failes in pushbuild on
"RHAS3 EM64T"
and 
"powermacg5 -max"

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/3173

Pushed a fix to mysql-5.0.20 and 5.1.8 that properly call ndb->init() in the "ndb_utilt_hread" thu making it possible for the thread to connect to NDB and check the commit count of the open tables in the query cache.

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

Documented bugfix in 5.0.20 and 5.1.8 changelogs. Closed.