Bug #49782 ndb_mgm client does not report data memory decreased

Submitted: 17 Dec 2009 20:22 Modified: 3 Mar 2010 12:34
Reporter: Andrew Hutchings 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: Magnus Blåudd CPU Architecture:Any

[17 Dec 2009 20:22] Andrew Hutchings
Description:
When data memory is full and then decreased and the ndb_mgm client is running there should be the following message:

2009-12-17 19:35:07 [MgmSrvr] INFO     -- Node 2: Data usage decreased to 15%(5 32K pages of total 32)

This works in 6.3 but not in 7.0 (tested 7.0.6 and 7.0.9)

How to repeat:
1. Run ndb_mgm
2. Fill data memory
3. TRUNCATE TABLE t1;
[21 Dec 2009 8:40] Bernd Ocklin
This is a regression.
[2 Mar 2010 13:11] Magnus Blåudd
Fixed by the patch for BUG#31542, see below test protocol.

mysql> use test
Database changed
mysql> create table t1(a int primary key, b int, c varchar(256)) ENGINE = NDB;
Query OK, 0 rows affected (0.45 sec)

$> test/tools/hugoFill  -d test t1
batch = 512 rowsize = 292 -> rows/commit = 448
ERROR: 827 Out of memory in Ndb Kernel, table data (increase DataMemory)
           Status: Permanent error, Classification: Insufficient space
           File: HugoTransactions.cpp (Line: 828)

ndb_mgm> Node 2: Data usage increased to 82%(530 32K pages of total 640)
Node 1: Data usage increased to 85%(550 32K pages of total 640)
Node 2: Data usage increased to 95%(608 32K pages of total 640)
Node 1: Data usage increased to 96%(617 32K pages of total 640)
Node 2: Data usage increased to 99%(636 32K pages of total 640)
Node 1: Data usage increased to 99%(636 32K pages of total 640)

mysql> TRUNCATE TABLE t1;
Query OK, 0 rows affected (0.39 sec)

ndb_mgm> Node 2: Data usage decreased to 3%(24 32K pages of total 640)
Node 1: Data usage decreased to 3%(24 32K pages of total 640)
[3 Mar 2010 10:28] Magnus Blåudd
Fixed by patch for bug#31542

Pushed to 6.3.33, 7.0.14 and 7.1.2-beta
[3 Mar 2010 12:34] Jon Stephens
Documented in the NDB-6.3.33, 7.0.14, and 7.1.2 changelogs.

See BUG#31542 for changelog entry.

Closed.

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

Page generated in 0.046 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.