Bug #42201 Maria: after a deadlock, table is marked as corrupted
Submitted: 19 Jan 2009 14:22 Modified: 7 May 2009 8:30
Reporter: Guilhem Bichot Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Maria storage engine Severity:S3 (Non-critical)
Version:5.1-maria OS:Any
Assigned to: Sergei Golubchik CPU Architecture:Any

[19 Jan 2009 14:22] Guilhem Bichot
patch test like this:
=== modified file 'mysql-test/suite/maria/t/maria_notembedded.test'
--- mysql-test/suite/maria/t/maria_notembedded.test     2009-01-15 21:27:36 +0000
+++ mysql-test/suite/maria/t/maria_notembedded.test     2009-01-19 14:19:07 +0000
@@ -89,6 +89,7 @@
 disconnect con_d;

 connection default;
+check table t1;
 drop table t1;


The result is:
+test.t1        check   warning Table is marked as crashed

How to repeat:
see above

Suggested fix:
See the setting of "fatal_error" in maria_write(), that's the cause.
[6 Feb 2009 21:48] Sergei Golubchik

 2728 Sergei Golubchik  2009-02-06
      Bug#42201 Maria: after a deadlock, table is marked as corrupted

      don't treat deadlock or timeout as a sign of corruption
[17 Feb 2009 11:47] Bugs System
Pushed into 6.0.10-alpha (revid:serg@mysql.com-20090217113558-vpsqsyjule7nz0gk) (version source revid:guilhem@mysql.com-20090213163054-rsg204z5qzcekbfe) (merge vers: 6.0.10-alpha) (pib:6)
[7 May 2009 8:30] MC Brown
A note has been added to the 6.0.10 changelog: 

A deadlocked Maria table would incorrectly be marked as crashed.