Re: MySQL error 28, can't write temp files - how to debug? [SOLVED]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



On Thu, Nov 5, 2009 at 11:47 PM, Alan Hodgson <ahodgson@xxxxxxxxx> wrote:
> On Thursday 05 November 2009, Rudi Ahlers <Rudi@xxxxxxxxxxx> wrote:
>> According to google search, errorcode 28 means the HDD is full. But it
>> isn't:
>>
>>
>> root@vps:[~]$ df -h
>> Filesystem            Size  Used Avail Use% Mounted on
>> /dev/sda1              84G   18G   62G  23% /
>> none                  640M     0  640M   0% /dev/shm
>> /usr/tmpDSK           485M   11M  449M   3% /tmp
>>
>>
>> What else could cause this kind of problem?
>
> You only have 449MB free on /tmp. It could easily fill that up during the
> query, and then delete the file before you run df again. Run it while the
> query is executing, I bet you see /tmp filling up.
>
> --
> "No animals were harmed in the recording of this episode. We tried but that
> damn monkey was just too fast."
> _______________________________________________


Thanx, that seems to have solved the problem. I didn't think of
checking to see if the tmp folder got full during the SQL statement
execution. So, by increasing it to 1GB, the problem is solved

-- 
Kind Regards
Rudi Ahlers
CEO, SoftDux Hosting
Web: http://www.SoftDux.com
Office: 087 805 9573
Cell: 082 554 7532
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos


[Index of Archives]     [CentOS]     [CentOS Announce]     [CentOS Development]     [CentOS ARM Devel]     [CentOS Docs]     [CentOS Virtualization]     [Carrier Grade Linux]     [Linux Media]     [Asterisk]     [DCCP]     [Netdev]     [Xorg]     [Linux USB]
  Powered by Linux