|
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?
|
|
Unfortunately it's a production server BUT it was run on testing domain with testing database and there were no other access to the web at that time (so no other queries were running for 99%).
|
|
According to syslog that you provided, there were 16 open connections to the database server at the moment of the crash, so if it wasn't web access, maybe there were some maintenance works going on (backup, statistics, monitoring, anything).
|
|
Yes, there were other cnnections and queries but to the other databases (i thought you were asking about that one database, not the whole server - you said 'related to the table').
|
|
Yes, I meant those related to the table. I see, thank you.
|
|
I had another crash with ALTER command, attaching logs. MariaDB version 5.5.37 (Debian Wheezy, 64bit). Command:
ALTER TABLE `orders2`
ADD `used_code` varchar(50) NOT NULL,
COMMENT='';
|
|
Looks like a different one, but both are InnoDB assertion failures. Passing to Jan to his collection of InnoDB sporadic problems, maybe he'll be able to make sense out of it.
|
|
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
|
#sql-6493_f2aac.frm
global_variables.txt