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
• Status: Closed
• 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

Description:
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;

 --disable_result_log

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

http://lists.mysql.com/maria/434

 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:[e-mail]-20090217113558-vpsqsyjule7nz0gk) (version source revid:[e-mail]-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.