[MDEV-674] LP:486462 - Disk full causes incorrect error message(s) Created: 2009-11-21  Updated: 2015-04-04

Status: Open
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: 5.1.67, 5.2.14, 5.3.12, 5.5, 10.0, 10.1
Fix Version/s: 10.1

Type: Bug Priority: Minor
Reporter: Cafuego (Inactive) Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: Launchpad, upstream, verified

Attachments: XML File LPexportBug486462.xml    

 Description   

When running out of disk space during a database import, Maria incorrectly tells me the table is full, as opposed to 'the disk is full'. It seems it's not correctly parsing E_NOSPC and so not returning the correct error string.

cafuego@cachaca:~
; mysql database < data_dump.sql

ERROR 1114 (HY000) at line 676: The table 'cache_menu' is full
cafuego@cachaca:~
; df -h /
Filesystem Size Used Avail Use% Mounted on
/dev/sda6 12G 12G 0 100% /

After making some space available, the import completes fine. I recall reporting this to Sun as well, but I can't find the bug number.

 Comments   
Comment by Cafuego (Inactive) [ 2009-11-21 ]

Re: Disk full causes incorrect error message(s)
Ah, found 'im: http://bugs.mysql.com/bug.php?id=44781

The associated syslog entry from the current error was:

Nov 22 10:12:16 cachaca mysqld: 091122 10:12:16 InnoDB: Error: Write to file ./database/cache_menu.ibd f→
Nov 22 10:12:16 cachaca mysqld: InnoDB: 1048576 bytes should have been written, only -1 were written.
Nov 22 10:12:16 cachaca mysqld: InnoDB: Operating system error number 28.
Nov 22 10:12:16 cachaca mysqld: InnoDB: Check that your OS and file system support files of this size.
Nov 22 10:12:16 cachaca mysqld: InnoDB: Check also that the disk is not full or a disk quota exceeded.
Nov 22 10:12:16 cachaca mysqld: InnoDB: Error number 28 means 'No space left on device'.
Nov 22 10:12:16 cachaca mysqld: InnoDB: Some operating system error numbers are described at
Nov 22 10:12:16 cachaca mysqld: InnoDB: http://dev.mysql.com/doc/refman/5.1/en/operating-system-error-codes.html
Nov 22 10:12:16 cachaca mysqld: 091122 10:12:16 [ERROR] mysqld: The table 'cache_menu' is full

... so probably the same bug.

Comment by Hakan Küçükyılmaz (Inactive) [ 2009-12-02 ]

Re: Disk full causes incorrect error message(s)
Confirmed by http://bugs.mysql.com/bug.php?id=44781

Comment by Rasmus Johansson (Inactive) [ 2012-06-13 ]

Launchpad bug id: 486462

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