Bug #53944 Out of table-records could be reported too early
Submitted: 24 May 2010 13:17 Modified: 25 May 2010 12:49
Reporter: Jonas Oreland Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:mysql-5.1-telco-7.0 OS:Any
Assigned to: Jonas Oreland CPU Architecture:Any

[24 May 2010 13:17] Jonas Oreland
Description:
Testing testcase for http://bugs.mysql.com/bug.php?id=52055...
I found that using config.ini from that,
create tables in I get out of attribute records,
increasing it and restarting cluster again,
I got "Out of table-records" too early.

---

How to repeat:
1) start cluster with following config
[cluster_config.geert]
NoOfReplicas = 1
DataMemory = 200M
IndexMemory = 70M
ndb_mgmd = localhost
ndbd = localhost
mysqld =
ndbapi=,,,,,

2) create tables until you get "out of attribute records"

for i in `seq 3200`
do
        mysql -uroot test -e "drop table if exists t$i;"
        mysql -uroot test --show-warnings -e "CREATE TABLE t$i (id INT UNSIGNED NOT NULL AUTO_INCREMENT,c1 INT, c2 INT, c3 VARCHAR(400), c4 VA
RCHAR(200), c5 INT, c6 BIT, PRIMARY KEY (id)) ENGINE=ndb;"
done

3) insert "MaxNoOfAttributes=10000" into config.ini
4) restart ndb_mgmd and ndbd
5) rerun script,
6) notice that you get "Out of table-records"

Suggested fix:
Make sure to keep "OLD_SCHEMA_FILE" up-2-date.
This by using this (instead of object on op_ptr) as before-image.

This is a regression introduced by fix for bug#44294
[24 May 2010 15:10] 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/109074

3549 Jonas Oreland	2010-05-24
      ndb - bug#53944 - fix problem where OLD_SCHEMA_FILE was not kept up to date, causing out too early "out of table records"
[24 May 2010 15:11] Jonas Oreland
pushed to 7.0.15 and 7.1.4
[25 May 2010 12:15] 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/109158

3550 Jonas Oreland	2010-05-25
      ndb - bug#53944 - fix regression introduced shown by "testDict -n Bug24631 T1", don't update OLD_SCHEMA_FILE during restart
[25 May 2010 12:49] Jon Stephens
Documented bugfix in the NDB-7.0.15 and 7.1.4 changelogs as follows:

      After creating NDB tables until creation of a table fails due to 
      NDB error 905 -Out of attribute records (increase 
      MaxNoOfAttributes)-, then increasing MaxNoOfAttributes and 
      restarting all management node and data node processes, attempting 
      to drop and re-create any of the tables failed with the error -Out 
      of table records- even when sufficient table records were 
      available.

Closed.