[MDEV-592] LP:657295 - MariaDB loop with MyISAM tables marked as crashed Created: 2010-10-09  Updated: 2012-11-02  Resolved: 2012-11-02

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug
Reporter: Sergei Golubchik Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug657295.xml    

 Description   

On several servers (3) MariaDB 5.1 crashed after an upgrade from from MySQL 5.0.
Log shows:
===
Version: '5.1.50-MariaDB-mariadb84-log' socket: '/var/run/mysqld/mysqld.sock'
port: 3306 (MariaDB - http://mariadb.com/)
101008 14:35:17 [ERROR] mysqld: Table './database123/table123' is marked as
crashed and should be repaired
101008 14:35:17 [Warning] Checking table: './database123/table123'
101008 14:35:17 mysqld_safe Number of processes running now: 0
101008 14:35:17 mysqld_safe mysqld restarted
===

This is looping, so things only get worse every time with more crashed tables.
Using myisamchk to repair all MYI tables actually "fixes" the issue, but I guess
it can come back after an unclean shutdown. This appears to be a major bug. I have
a copy of such corrupt database available on request. (see WL#155)

 Comments   
Comment by Dreas van Donselaar (Inactive) [ 2010-10-09 ]

Re: MariaDB loop with MyISAM tables marked as crashed
Monty found that this occurred because thread_stack was set to 128K instead of 256K which is required for MariaDB 5.1. Still seems that should be fixed though (or at least MariaDB should refuse to start with a clear error message).

Comment by Rasmus Johansson (Inactive) [ 2010-10-09 ]

Launchpad bug id: 657295

Comment by Elena Stepanova [ 2012-11-02 ]

Could not reproduce the problem by upgrading from 5.0.96 to 5.1.50, and there is no problematic datadir to experiment with. Also, the comment about thread_stack is not quite clear since MariaDB 5.1.50 (where the problem is reported) automatically adjusts thread_stack=128K to 245760.
Closing as incomplete. Anyway, probably nowadays not so many people will upgrade from MySQL 5.0 to MariaDB 5.1.

Comment by Elena Stepanova [ 2012-11-02 ]

Reopening to remove 'fix version's

Generated at Thu Feb 08 06:29:54 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.