Bug #57057 | MRR scan + delete causes leak in NDB stored procedure pool | ||
---|---|---|---|
Submitted: | 28 Sep 2010 9:38 | Modified: | 25 Jan 2011 10:16 |
Reporter: | yuan chaohua | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Cluster: Cluster (NDB) storage engine | Severity: | S2 (Serious) |
Version: | any | OS: | Linux |
Assigned to: | Pekka Nousiainen | CPU Architecture: | Any |
Tags: | cluster, dbtup, ndbd |
[28 Sep 2010 9:38]
yuan chaohua
[28 Sep 2010 9:59]
Hartmut Holzgraefe
To simplify our investigation please make sure to run ndb_error_reporter and attach the resulting collection of configuration, trace and log files to this bug report or upload the file to ftp://ftp.mysql.com/pub/mysql/upload and let us know the file name. For more information about the error reporter please refer to http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-programs-ndb-error-reporter.html If you have problems running ndb_error_reporter you can also collect your cluster configuration file (config.ini) and ndb_*_cluster.log, ndb_*_out.log, ndb_*_error.log and ndb_*_trace.* files manually.
[28 Sep 2010 10:00]
Magnus Blåudd
Please submit reproducable test case and ndb_error_reporter tar file.
[28 Sep 2010 10:07]
yuan chaohua
Hi, I can not give the reproduce steps. The test tool is for real production. And i can not attach file because i have no permission to transfer file to internet. I looked into the source code and could not find the reason. The error seems related to SP(Stored procedure), But our test case do not use any sp... Hope someone can help....
[29 Sep 2010 12:16]
Jørgen Austvik
Can you please say what the tests you have is doing?
[11 Oct 2010 7:13]
yuan chaohua
After change 1. MaxNoOfLocalScans from 64 to 512 2. ndb_use_transactions from 0 to 1 The error disappear.
[1 Jan 2011 15:38]
Pekka Nousiainen
This is a real bug. It came up now while testing bug#58277. There is a pool of "stored procs" in NDB (not related to MySQL SPs) associated with scans. The crash is a memory leak in this pool when MRR (multi-range) scans are mixed with deletes. >After change 1. MaxNoOfLocalScans from 64 to 512 > 2. ndb_use_transactions from 0 to 1 1. increases the pool, does not fix the crash. 2. makes the memory leak less likely if main cause was doing scan deletes from mysql with multiple ranges like "delete from .. where x < 10 or x > 20".
[1 Jan 2011 15:50]
Pekka Nousiainen
Assigned to self, fix under bug#58277.
[3 Jan 2011 10:58]
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/127769 3373 Pekka Nousiainen 2011-01-03 bug#58277,bug#57057 a06_fix3.diff MRR scan and drop or delete fail to release stored proc
[3 Jan 2011 11:03]
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/127770 3374 Pekka Nousiainen 2011-01-03 bug#58277,bug#57057 a07_fix4.diff ifdef on ERROR_INSERT, add to daily-basic-tests
[3 Jan 2011 16:01]
Bugs System
Pushed into mysql-5.1-telco-7.0 5.1.51-ndb-7.0.21 (revid:pekka@mysql.com-20110103150841-7tgh4tfp10wsvz9k) (version source revid:pekka@mysql.com-20110103150841-7tgh4tfp10wsvz9k) (merge vers: 5.1.51-ndb-7.0.21) (pib:24)
[3 Jan 2011 16:02]
Bugs System
Pushed into mysql-5.1-telco-6.3 5.1.51-ndb-6.3.40 (revid:pekka@mysql.com-20110103110242-3wsx0gxnnnoa0ue0) (version source revid:pekka@mysql.com-20110103110242-3wsx0gxnnnoa0ue0) (merge vers: 5.1.51-ndb-6.3.40) (pib:24)
[5 Jan 2011 17:01]
Pekka Nousiainen
update Synopsis
[25 Jan 2011 10:16]
Jon Stephens
See BUG#58277 for docs info/changelog entry. Closed.