MySQL server has gone away/CentOS Linux/OTRS 3.0.8

[kissg]

Hi,

We have been using OTRS 3.0.8 for a couple of months. Everything seems to work fine except sometimes the ticket status does not change when answering an email. I found errors in the OTRS log that shows something is not working properly (in about every 5 minutes but rather randomly so it is not due to a cron job or so).

There are two types of error messages. Both errors are cases when some similar error messages appear in the log.
Case 1:
error: MySQL server has gone away, SQL: 'SELECT id, name FROM ticket_state WHERE valid_id IN ( 1 )'
notice: Permission denied on TicketID: 215550 / StateID: 2!
error: MySQL server has gone away, SQL: 'UPDATE ticket SET ticket_lock_id = ?, change_time = current_timestamp, change_by = ? WHERE id = ?'
error: MySQL server has gone away, SQL: 'INSERT INTO ticket_history (name, history_type_id, ticket_id, article_id, queue_id, owner_id, priority_id, state_id, type_id, valid_id, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, current_timestamp, ?, current_timestamp, ?)'
error: MySQL server has gone away, SQL: 'DELETE FROM web_upload_cache WHERE form_id = ?'
error: MySQL server has gone away, SQL: 'SELECT DISTINCT count(*) FROM ticket st, queue sq WHERE sq.id = st.queue_id AND st.ticket_lock_id IN (2) AND st.user_id IN (24) AND archive_flag = 0 LIMIT 10000'
error: MySQL server has gone away, SQL: 'SELECT DISTINCT count(*) FROM ticket st, queue sq , ticket_flag tf1 WHERE sq.id = st.queue_id AND st.id = tf1.ticket_id AND st.ticket_lock_id IN (2) AND st.user_id IN (24) AND tf1.ticket_key = 'Seen' AND tf1.ticket_value = '1' AND tf1.create_by = 24 AND archive_flag = 0 LIMIT 10000'
error: MySQL server has gone away, SQL: 'SELECT DISTINCT count(*) FROM ticket st, queue sq WHERE sq.id = st.queue_id AND st.ticket_state_id IN ( 6 ) AND st.ticket_lock_id IN (2) AND st.user_id IN (24) AND st.ticket_state_id IN (6, 7) AND st.until_time <= 1326384642 AND archive_flag = 0 LIMIT 10000'
error: MySQL server has gone away, SQL: 'SELECT tn FROM ticket WHERE id = ? LIMIT 1' (7 times)


Case 2:
error: MySQL server has gone away, SQL: 'DELETE FROM web_upload_cache WHERE form_id = ?'
error: MySQL server has gone away, SQL: 'SELECT st.user_id, su.login FROM ticket st, users su WHERE st.id = ? AND st.user_id = su.id'
error: MySQL server has gone away, SQL: 'UPDATE ticket SET user_id = ?, change_time = current_timestamp, change_by = ? WHERE id = ?'
error: MySQL server has gone away, SQL: 'SELECT tn FROM ticket WHERE id = ? LIMIT 1' (15 times)

I set the value of max_allowed_packet to 64M and max_connections to 500. During the usual load (6-7 admins working with emails) there are no waiting MySQL connections if I am having a look with "SHOW PROCESSLIST" with root.

Any idea, what goes wrong or how to continue debugging whar is really going on? I also had a look at newer version of OTRS but they did not seem to have any changes related to those issues.

Thanks a lot in advance!
BR,
KLG

[Wolfgangf]

did you check against tables marked as crashed?

[kissg]

did you check against tables marked as crashed?

Most cases those function work so the tables work in general. They must not be crashed.