[Solved] Mysql can't write file

[crons]

Hello I am see these logs and agentticketqueue is not working

Code: Select all

Mon Aug 25 16:19:09 2014] -e: DBD::mysql::st execute failed: Can't create/write to file '/tmp/#sql_7cd6_0.MYI' (Errcode: 5) at /opt/otrs//Kernel/System/DB.pm line 615.
ERROR: OTRS-CGI-10 Perl: 5.10.1 OS: linux Time: Mon Aug 25 16:19:09 2014
Message: Can't create/write to file '/tmp/#sql_7cd6_0.MYI' (Errcode: 5), SQL: '
            SELECT st.queue_id, sq.name, min(st.create_time_unix), count(*)
            FROM ticket st, queue sq
            WHERE st.ticket_state_id IN ( 1, 4, 6 )
                AND st.ticket_lock_id IN ( 1, 3 )
                AND st.queue_id = sq.id
                AND st.archive_flag = 0
                AND sq.group_id IN ( 58, 61, 57, 1, 10, 12, 13, 14, 15, 16, 17, 18, 19, 2, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 3, 30, 31, 32, 33, 34, 35, 39, 4, 40, 46, 47, 48, 49, 5, 50, 51, 52, 54, 55, 6, 7, 8, 9, 56, 59 )
            GROUP BY st.queue_id,sq.name
            ORDER BY sq.name'

Any idea on this?

[crons]

Have also free memory of /tmp/. Now its shows usage as 86%.

Code: Select all

dev/xvda7            368M  299M   51M  86% /tmp

[seberget2]

Code: Select all

$ perror 5
OS error code   5:  Input/output error

So does the user running have write access the directory in quesiton? It could also mean that you have a network error. From I can see from Google...

[jojo]

It is a mysql error. THis might have different causes like wrong permissions or insufficient disk space.

Please consult mysql support

[crons]

Proper permission was needed to the directory /tmp. http://nixcraft.com/showthread.php/1426 ... code-13%29.