MySQL patches by Codership

resource leak with MyISAM

Bug #715055 reported by Teemu Ollakka on 2011-02-08

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	MySQL patches by Codership	Triaged	Undecided	Unassigned

Bug Description

Running Drupal with MyISAM tables produces "out of resources errors" like:

# user warning: Out of resources when opening file './site/cache_menu.MYD' (Errcode: 24) query: SELECT data, created, headers, expire, serialized FROM cache_menu WHERE cid = 'links:menu-main-menu-he:tree-data:5d6d3aaaaef5fba302ce62698fa37bbe' in /site/includes/cache.inc on line 26.

mysqldump: Got error: 1016: Can't open file: './site/content_field_description.frm' (errno: 24) when using LOCK TABLES

Error code 24 is "Too many open files".

Inspecting file system reveals bunch of stale files like:

mysqld 20134 mysql 132u REG 9,1 32768
320070 /tmp/MLXZjoIv (deleted)

Mailing list thread: http://groups.google.com/group/codership-team/browse_thread/thread/461fb250ee30383f