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 <wod...@gmail.com> 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
--------------------------------------------------------------------- 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
