Bug #23196 MySQL server does not exit / shutdown when storage engine returns errno 12
Submitted: 12 Oct 2006 8:25 Modified: 7 Feb 2007 13:19
Reporter: Valeriy Kravchuk
Status: Closed
Category:Server: MyISAM Severity:S3 (Non-critical)
Version:5.0.18, 4.1 OS:Linux (Linux)
Assigned to: Sergey Vojtovich Target Version:
Tags: bfsm_2007_02_01, bfsm_2006_11_02

[12 Oct 2006 8:25] Valeriy Kravchuk 
Description:
MySQL server does not exit/shutdown when storage engine returns errno 12, and it should.
This bug leads to replication and MyISAM corruption.

How to repeat:
Run MySQL server with not enough space for data (and/or memory available)?

Suggested fix:
Shutdown properly when there is no way to continue without corruptions?
[1 Dec 2006 16:11] 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/16313

ChangeSet@1.2537, 2006-12-01 19:11:43+04:00, svoj@mysql.com +3 -0
  BUG#23196 - MySQL server does not exit / shutdown when
              storage engine returns errno 12
  
  If there is not enough memory to store or update blob record
  (while allocating record buffer), myisam marks table as crashed.
  
  With this fix myisam attempts to roll an index back and return
  an error, not marking a table as crashed.
  
  Affects myisam tables with blobs only. No test case for this fix.
[25 Jan 2007 10:28] Sergey Vojtovich 
Pushed to trees currently marked as 5.0.36 and 5.1.15.
[5 Feb 2007 12:41] Sergey Vojtovich 
Pushed to tree currently marked as 4.1.23.
[7 Feb 2007 13:19] MC Brown 
A note has been added to the 4.1.23, 5.0.36 and 5.1.15 changelogs.