[ic] mysql Errcode 28 writing /tmp

[Bill Carr]

On Apr 7, 2011, at 7:42 AM, Gert van der Spoel wrote:

>> -----Original Message-----
>> From: interchange-users-bounces at icdevgroup.org [mailto:interchange-users-
>> bounces at icdevgroup.org] On Behalf Of IC
>> Sent: donderdag 7 april 2011 13:46
>> To: interchange-users at icdevgroup.org
>> Subject: [ic] mysql Errcode 28 writing /tmp
>> 
>> Hi Folks,
>> 
>> When trying to run one of the admin reports (Orders by Affiliate) I get an
>> error that would seem to indicate mysql cannot write to /tmp
>> 
>> I have tried to find out why but haven't got very far, any advice please?
>> 
>> Here is the exact error as shown in IC admin, version is 5.6.0
>> 
>> table transactions: Query on table transactions failed: DBD::mysql::st
>> execute failed: Error writing file '/tmp/MYopm6dj' (Errcode: 28) at
>> /usr/local/interchange/lib/Vend/Table/DBI.pm line 2000.
>> 
> 
> I believe that error occurs when the disk is full ... Do you have a huge
> transaction file?  You might be able to see the diskspace go down while you
> run the report?
Just had this yesterday. Disk space.

$ /usr/local/mysql/bin/perror 28
OS error code  28:  No space left on device

Bill Carr 
Bottlenose - Wine & Spirits eBusiness Specialists 
(413) 584-0400