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'