Re: [otrs] Need help - disk full crash and damaged database

Hi Andy, this is a standard MySQL error message which can be easily repaired in most instances. A Google search for 'repair crashed mysql tables' leads to results : http://dev.mysql.com/doc/refman/5.0/en/repair-table.html Obviously clear out some disk space first and when everything is up and running again implement some basic system monitoring. Regards, Arnold.

On 5 feb. 2015, at 08:44, Andy Wodfer wrote:

This morning I woke up to a full disk and a helpdesk that wasn't working.

I'm not so experienced with sql, but I hope someone here can help me solve the problems.

System is FreeBSD, mysql and phpmyadmin. Otrs 3.0.12.

Here is the messages from system log:

Thu Feb 5 08:30:01 2015 error OTRS-PostMasterMailbox.pl-10 Table './helpdesk/article' is marked as crashed and should be repaired, SQL: 'SELECT id FROM article WHERE ticket_id = ? ORDER BY id' Thu Feb 5 08:30:01 2015 error OTRS-PostMasterMailbox.pl-10 Table './helpdesk/article' is marked as crashed and should be repaired, SQL: 'SELECT id FROM article WHERE ticket_id = ? ORDER BY id' Thu Feb 5 08:30:01 2015 error OTRS-PostMasterMailbox.pl-10 Table './helpdesk/article' is marked as crashed and should be repaired, SQL: 'INSERT INTO article (ticket_id, article_type_id, article_sender_type_id, a_from, a_reply_to, a_to, a_cc, a_subject, a_message_id, a_in_reply_to, a_references, a_body, a_content_type, content_path, valid_id, incoming_time, create_time, create_by, change_time, change_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, current_timestamp, ?, current_timestamp, ?)'

Thu Feb 5 07:45:13 2015 error OTRS-CGI-10 Table './helpdesk/article' is marked as crashed and should be repaired, SQL: 'SELECT sa.ticket_id, sa.a_from, sa.a_to, sa.a_cc, sa.a_subject, sa.a_reply_to, sa.a_message_id, sa.a_in_reply_to, sa.a_references, sa.a_body, st.create_time_unix, st.ticket_state_id, st.queue_id, sa.create_time, sa.a_content_type, sa.create_by, st.tn http://st.tn/, article_sender_type_id, st.customer_id, st.until_time, st.ticket_priority_id, st.customer_user_id, st.user_id, st.responsible_user_id, sa.article_type_id, sa.a_freekey1, sa.a_freetext1, sa.a_freekey2, sa.a_freetext2, sa.a_freekey3, sa.a_freetext3, st.ticket_answered, sa.incoming_time, sa.id http://sa.id/, st.freekey1, st.freetext1, st.freekey2, st.freetext2, st.freekey3, st.freetext3, st.freekey4, st.freetext4, st.freekey5, st.freetext5, st.freekey6, st.freetext6, st.freekey7, st.freetext7, st.freekey8, st.freetext8, st.freekey9, st.freetext9, st.freekey10, st.freetext10, st.freekey11, st.freetext11, st.freekey12, st.freetext12, st.freekey13, st.freetext13, st.freekey14, st.freetext14, st.freekey15, st.freetext15, st.freekey16, st.freetext16, st.ticket_lock_id, st.title, st.escalation_update_time, st.freetime1 , st.freetime2, st.freetime3, st.freetime4, st.freetime5, st.freetime6, st.type_id, st.service_id, st.sla_id, st.escalation_response_time, st.escalation_solution_time, st.escalation_time, st.change_time FROM article sa, ticket st WHERE sa.ticket_id = ? AND sa.ticket_id = st.id http://st.id/ ORDER BY sa.create_time, sa.id http://sa.id/ ASC' --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs