Hi all,
I hope someone can help with this one.
On one of our VPS's we have a fairly large MySQL database, which gives
me the following error when running some queries against it:
An error occured!Can't execute statement: Error writing file
'/tmp/MYL4qeT5' (Errcode: 28)
SQL: , , select * from
On Thursday 05 November 2009, Rudi Ahlers r...@softdux.com wrote:
According to google search, errorcode 28 means the HDD is full. But it
isn't:
r...@vps:[~]$ df -h
FilesystemSize Used Avail Use% Mounted on
/dev/sda1 84G 18G 62G 23% /
none
On Thu, Nov 5, 2009 at 11:47 PM, Alan Hodgson ahodg...@simkin.ca wrote:
On Thursday 05 November 2009, Rudi Ahlers r...@softdux.com wrote:
According to google search, errorcode 28 means the HDD is full. But it
isn't:
r...@vps:[~]$ df -h
Filesystem Size Used Avail Use% Mounted on
Rudi Ahlers wrote:
On Thu, Nov 5, 2009 at 11:47 PM, Alan Hodgson ahodg...@simkin.ca wrote:
On Thursday 05 November 2009, Rudi Ahlers r...@softdux.com wrote:
According to google search, errorcode 28 means the HDD is full. But it
isn't:
r...@vps:[~]$ df -h
FilesystemSize Used
On Fri, Nov 6, 2009 at 12:44 AM, Les Mikesell lesmikes...@gmail.com wrote:
Rudi Ahlers wrote:
On Thu, Nov 5, 2009 at 11:47 PM, Alan Hodgson ahodg...@simkin.ca wrote:
On Thursday 05 November 2009, Rudi Ahlers r...@softdux.com wrote:
According to google search, errorcode 28 means the HDD is
Rudi Ahlers wrote:
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.
Thanx, that seems to have
On Fri, Nov 6, 2009 at 1:02 AM, Les Mikesell lesmikes...@gmail.com wrote:
Rudi Ahlers wrote:
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
On Thu, Nov 5, 2009 at 11:44 PM, Rudi Ahlers r...@softdux.com wrote:
Hi all,
An error occured!Can't execute statement: Error writing file
'/tmp/MYL4qeT5' (Errcode: 28)
SQL: , , select * from tips order by rand() limit 0, 1 ,
check if you have enough free inodes with df -i
8 matches
Mail list logo