[ic] mysql Errcode 28 writing /tmp

[Stefan Hornburg (Racke)]

On 04/07/2011 02:51 PM, Steve Graham wrote:
>
>> 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...
>

The standard installation of Debian has the following settings in my.cnf
to prevent binary log files piling up:

expire_logs_days        = 10
max_binlog_size         = 100M

Regards
         Racke

-- 
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team