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

[26 Jan 2006 2:51] Brian Aker
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
[8 Feb 2006 10:37] Magnus Blåudd
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.
[15 Feb 2006 21:46] Bugs System
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
[24 Feb 2006 8:21] Magnus Blåudd
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.
[26 Feb 2006 19:17] Magnus Blåudd
ndb_cache_multi2 failes in pushbuild on
"RHAS3 EM64T"
and 
"powermacg5 -max"
[27 Feb 2006 9:30] Bugs System
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
[6 Mar 2006 10:41] Magnus Blåudd
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.
[8 Mar 2006 13:44] Jon Stephens
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.