Hi All,
OTRS suddenly stopped auto fetching of mails from pop3 account. I need to manually click over "Fetch mail" from Admin panel. Previously it was fetching the mails by its own but few days back after a reboot, OTRS is unable to perform the default functionality. Mails sent to the associated mail account are getting delivered properly to the mailbox. Any guidance?
OTRS version : 3.0.4
OS : Ubuntu 10.04
Modules : http://pastebin.com/BEbWHfkB
otrs not fetching the mails
Moderator: crythias
-
- Znuny newbie
- Posts: 2
- Joined: 22 Feb 2012, 08:23
- Znuny Version: otrs3
otrs not fetching the mails
Last edited by virtuaposta on 22 Feb 2012, 09:04, edited 2 times in total.
Re: otrs not fetching the mails
please fill your signature with OTRS Version, OS and installed modules
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- Znuny newbie
- Posts: 2
- Joined: 22 Feb 2012, 08:23
- Znuny Version: otrs3
Re: otrs not fetching the mails
Ok I resolved the issue.
I manually tried to run otrs/bin/otrs.PostMasterMailbox.pl as otrs user and found following issue :
DBD::mysql::st execute failed: Table './otrs/process_id' is marked as crashed and last (automatic?) repair failed at /opt/otrs-3.0.4/Kernel/System/DB.pm line 553.
ERROR: OTRS-PostMasterMailbox.pl-10 Perl: 5.10.1 OS: linux Time: Wed Feb 22 13:06:57 2012
So that was database issue. Table process_id been crashed somehow. So I repaired that using myisamchk and its working. For the peoples in case having same issue, here is how I repaied process_id table.
cd /var/lib/otrs
myisamchk process_id
Thanks!

DBD::mysql::st execute failed: Table './otrs/process_id' is marked as crashed and last (automatic?) repair failed at /opt/otrs-3.0.4/Kernel/System/DB.pm line 553.
ERROR: OTRS-PostMasterMailbox.pl-10 Perl: 5.10.1 OS: linux Time: Wed Feb 22 13:06:57 2012
So that was database issue. Table process_id been crashed somehow. So I repaired that using myisamchk and its working. For the peoples in case having same issue, here is how I repaied process_id table.
cd /var/lib/otrs
myisamchk process_id
Thanks!