[ic] mysql Errcode 28 writing /tmp

Gert van der Spoel gert at 3edge.com
Thu Apr 7 11:42:51 UTC 2011


> -----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?

CU,

Gert




More information about the interchange-users mailing list