- We are experiencing problems in fetching emails from gmail.
- Early this morning I received an error from otrs:
Date: Mon, 8 Jul 2013 09:00:02 +0800 (PHT)
DBD::mysql::db do failed: Table './otrs/process_id' is marked as crashed and should be repaired at /opt/otrs/Kernel/System/DB.pm line 478.
ERROR: OTRS-otrs.PostMasterMailbox.pl-10 Perl: 5.10.1 OS: linux Time: Mon Jul 8 09:00:02 2013
Message: Table './otrs/process_id' is marked as crashed and should be repaired, SQL: 'DELETE FROM process_id WHERE process_name = ? AND process_host = ?'
Traceback (13673):
Module: Kernel::System::PID::PIDDelete (v1.28) Line: 226
Module: Kernel::System::PID::PIDCreate (v1.28) Line: 150
Module: /opt/otrs//bin/otrs.PostMasterMailbox.pl (v1.4) Line: 83
DBD::mysql::db do failed: Table './otrs/process_id' is marked as crashed and should be repaired at /opt/otrs/Kernel/System/DB.pm line 478.
ERROR: OTRS-otrs.PostMasterMailbox.pl-10 Perl: 5.10.1 OS: linux Time: Mon Jul 8 09:00:02 2013
Message: Table './otrs/process_id' is marked as crashed and should be repaired, SQL: 'INSERT INTO process_id (process_name, process_id, process_host, process_create, process_change) VALUES (?, ?, ?, ?, ?)'
Traceback (13673):
Module: Kernel::System::PID::PIDCreate (v1.28) Line: 154
Module: /opt/otrs//bin/otrs.PostMasterMailbox.pl (v1.4) Line: 83
- after recieving this error I have repaired the said ./otrs/process_id table via phpmyadmin.
- it was successful.
- I tried running the ./otrs.PostMaster.pl script after repairing the table and I received:
POP3S: No messages (helpdesk@domain.com/pop.gmail.com)
POP3S: Connection to pop.gmail.com closed.
- but still we did not receive any emails from our clients. Which they claim they have sent it already.
Any help regarding this issue?
Thanks in Advance.
