Bug #77497 | InnoDB Online Ater Table ends in crash on disk full | ||
---|---|---|---|
Submitted: | 26 Jun 2015 6:27 | Modified: | 29 Oct 2015 17:24 |
Reporter: | Daniël van Eeden (OCA) | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: InnoDB storage engine | Severity: | S2 (Serious) |
Version: | 5.6.25, 5.6.26 | OS: | Any |
Assigned to: | CPU Architecture: | Any | |
Tags: | crash |
[26 Jun 2015 6:27]
Daniël van Eeden
[26 Jun 2015 6:58]
Daniël van Eeden
This left two files in the data/test directory: #sql-26b9_1cef4.frm #sql-ib25-1897058496.ibd This is in addition to the expected t1.frm and t1.ibd
[26 Jun 2015 9:17]
MySQL Verification Team
Hello Daniël, Thank you for the report. Observed this with 5.6.26 build with disk filled. Thanks, Umesh
[26 Jun 2015 9:17]
MySQL Verification Team
// 5.6.26 2015-06-26 10:42:57 20316 [Note] bin/mysqld: ready for connections. Version: '5.6.26-enterprise-commercial-advanced' socket: '/tmp/mysql_ushastry.sock' port: 15000 MySQL Enterprise Server - Advanced Edition (Commercial) 2015-06-26 11:05:32 20316 [ERROR] bin/mysqld: The table 't5' is full 2015-06-26 11:10:47 7f40d48af700 InnoDB: Error: Write to file ./bug77497/#sql-ib22-24111827.ibd failed at offset 2320498688. InnoDB: 1048576 bytes should have been written, only 675840 were written. InnoDB: Operating system error number 0. InnoDB: Check that your OS and file system support files of this size. InnoDB: Check also that the disk is not full or a disk quota exceeded. InnoDB: Error number 0 means 'Success'. InnoDB: Some operating system error numbers are described at InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html 09:10:47 UTC - mysqld got signal 11 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=8388608 read_buffer_size=131072 max_used_connections=2 max_threads=151 --More--(94%)
[26 Jun 2015 13:46]
Daniël van Eeden
> InnoDB: 1048576 bytes should have been written, only 356352 were written. > InnoDB: Operating system error number 0. It looks like this is the code where this happens: https://github.com/mysql/mysql-server/blob/5.6/storage/innobase/os/os0file.cc#L2991 I wonder why it enters this function: if (!os_has_said_disk_full) { On disk full I expect os_has_said_disk_full() to return true. And I also expect an non-zero error number. Could this be filesystem dependend? I used XFS.
[6 Jul 2015 10:35]
Andrii Nikitin
may be part of bug #68895
[29 Oct 2015 17:23]
Daniel Price
Posted by developer: Bug #21326304 : INNODB ONLINE ALTER TABLE ENDS IN CRASH ON DISK FULL Issue ===== Alter table crashes when disk is full. Reason for crash is that there is no check for NULL after btr_page_alloc(). Fix === If disk is full after btr_page_alloc() then return the error DB_OUT_OF_FILE_SPACE.
[29 Oct 2015 17:24]
Daniel Price
Posted by developer: Fixed as of the upcoming 5.6.28, 5.7.10, 5.8.0 release, and here's the changelog entry: An ALTER TABLE operation caused the server to exit on disk full. Thank you for the bug report.