Erroneous 'No space left on device' errors
Yesterday, mysql was unable to execute queries and failed with the error:
Code:
Can't create/write to file '/tmp/#sql_15b4_0.MYI' (Errcode: 28)] Code:
open: No space left on device Strangely, upon start mysqld still gives the "no space" error, but operates normally. We are also receiving a "No space left on device" error from arkeia: Code:
********* 2008/06/30 10:51:16 START OF APPLICATION "arktrans Arkeia Network Backup 7.0.4", LOGLEVEL="20" At this point I am thoroughly perplexed. As I have noted, permissions are correct on /tmp, /var/lib/mysql, and in /opt/arkeia. There is plenty of space on all devices. Anyone ever seen anything like this? We are running Debian Etch. |
I suspect that you're running out of inodes. What is the result of "df -i" ?
|
It looks like you're right:
Code:
Filesystem Inodes IUsed IFree IUse% Mounted on |
Quote:
|
Unfortunately /tmp is virtually empty. I believe the culprit is arkeia in /opt. Turns out the server was powered down this weekend in the middle of a backup due to a loss of AC in the server room. Either that or a legitimate buildup of an immensely large number of arkeia pointer files.
fsck claims that the disk is clean and the inodes are legit. |
Quote:
Have you done just a simple "find /opt" to see where all the files are? I do remember having a script once that was stuck in recursion due to a subdirectory linked to itself. :o The find revealed it right away. |
All times are GMT -5. The time now is 04:53 PM. |