Bug #27913 Exit error message correct, but followed by "unknown..."
Submitted: 18 Apr 2007 4:45 Modified: 18 Jun 2007 8:02
Reporter: LR Mack McBride Email Updates:
Status: In progress Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S2 (Serious)
Version:mysql-5.1 OS:Linux (CentOS 4.4)
Assigned to: CPU Architecture:Any
Tags: 5.1.17, disk data, open files, redo files

[18 Apr 2007 4:45] LR Mack McBride 
Description:
Documentation advises to report the following error as a bug.

Node 4: Forced node shutdown completed. Caused by error 2806: 'Max number of open files exceeded, please increase MaxNoOfOpenFiles(Resource configuration error). Permanent error, external action needed'. - Unknown error code: Unknown result: Unknown error code

The problem seems to be related to a large number of redo files being open at once.  As well as using 4 disk tables and 2 undo tables.

How to repeat:
basic 3 node cluster (1 mgm, 2 shared mysql/ndbd)
error while load a large vbulletin database.

[NDBD DEFAULT]
NoOfReplicas= 2
DataDir= /var/lib/mysql-cluster
DataMemory= 1024M
IndexMemory= 80M
MaxNoofTables=400
MaxNoofAttributes= 4000
MaxNoOfConcurrentOperations= 166000
MaxNoOfOrderedIndexes=1000
MaxNoOfUniqueHashIndexes=1000
MemReportFrequency= 120
SharedGlobalMemory= 96M
NoOfFragmentLogFiles=32
RedoBuffer= 32M

Suggested fix:
This seems to be a special case where the max no of open files will really need to be increased.
[19 Apr 2007 21:37] LR Mack McBride 
Should be serious rather than critical
[13 Jun 2007 6:24] 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/28625

ChangeSet@1.2510, 2007-06-13 14:13:55+00:00, lzhou@dev3-63.(none) +1 -0
  BUG#27913 Remove extra 'Unknown' error message when node shutdown
[15 Jun 2007 6: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/28837

ChangeSet@1.2510, 2007-06-15 14:35:27+00:00, lzhou@dev3-63.(none) +1 -0
  BUG#27913 Remove extra 'Unknown' error message when node shutdown
[18 Jun 2007 8:02] Tomas Ulin 
what are you trying to do?

BR,

T