[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