Details
Major
Description
MariaDB server is randomly crashing when ALTERing a table (adding a column), cannot always reproduce. Table is not useble after the crash and data is lost. Command used before the last crash:
ALTER TABLE `invoices`
ADD `proforma_invoice_amount_used` FLOAT NOT NULL,
COMMENT='';
Attaching these files:
syslog.log - crash log from syslog
global_variables.txt - output from 'show global variables'
table.txt - altered table original definition
my.cnf - server config file
invoices.ibd - idb file from table which was altered
#sql-6493_f2aac.frm - temporary frm file from table which was altered (the original one was missing)
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Both crashed look like there is a corruption on InnoDB data dictionary that could be caused by HD failure. Can you still repeat this issue with more recent version of MariaDB ?
The last crash was with 5.5.37, we are now running 5.5.38. Crashes are very rare and random so i can't tell if it's still reproducable. Crashes occured on different databases/tables (also on new, which were created after first few crashes) and we are using 'innodb_file_per_table = 1'. Also, server is running on RAID1 array and there is no single error logged in smart of all HDDs.
I see. Is it possible to test with following change:
revno: 4224
committer: Jan Lindström <jplindst@mariadb.org>
branch nick: 5.5
timestamp: Fri 2014-07-04 12:25:32 +0300
message:
MDEV-5621: Server random crash on ALTER TABLE
This is not a real fix, instead try to gather additional information
at the point when dictionary content is not what we expect it to be.
Where am i supposed to download that patch? thnx
bzr branch lp:maria/5.5 and build from sources at the moment
Hi,
Thanks for reporting this.
Is it a production server? If not, would it maybe be possible to turn on general_log for a while, to see if there is another parallel activity related to the table at the time of the crash?