[ic] mysql Errcode 28 writing /tmp
ic at tvcables.co.uk
Thu Apr 7 12:28:07 UTC 2011
> >> When trying to run one of the admin reports (Orders by Affiliate) I get
> >> 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
> >> 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
> > run the report?
> Just had this yesterday. Disk space.
> $ /usr/local/mysql/bin/perror 28
> OS error code 28: No space left on device
Thanks for all the quick replies, I had concluded earlier that it was disk
space having googled it but the webhost persuaded me otherwise, I really
shouldn't listen to the hosting company they are just incompetent.
df shows me that /tmp is on a separate volume:-
/usr/tmpDSK 495844 11836 458408 3% /tmp
I'll up the size and report back, the transactions table is large.
I have another issue but I'll start a new thread for that.
Regards to all,
More information about the interchange-users