[ic] mysql Errcode 28 writing /tmp

Steve Graham icdev at mrlock.com
Thu Apr 7 12:51:39 UTC 2011


> 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.
>
> Thanks,
> Andy
>

I run this cron job nightly....
# remove old mysql query logs
30 4 * * *  find /home/mysql/mysqld-bin.* -mtime +7 -type f | xargs rm -fv

gets rid of old and sometimes very large log files...

-Steve 




More information about the interchange-users mailing list