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.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.057 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.