Scheduler4win.pl error starting mysql crashed

Moderator: crythias

Locked
afarrugia
Znuny newbie
Posts: 2
Joined: 27 Feb 2014, 11:18
Znuny Version: 3.2.11

Scheduler4win.pl error starting mysql crashed

Post by afarrugia »

Hi

My server lost power due to a power cut and when resumed again OTRS started normal but wasn't automatically fetching emails, after trying to run Scheduler4win.pl i get the following:

C:\>C:\Perl\bin\perl.exe "C:\otrs\OTRS\bin\otrs.Scheduler4win.pl" -a start
DBD::mysql::st execute failed: Table '.\otrs\process_id' is marked as crashed an
d should be repaired at C:/otrs/OTRS/Kernel/System/DB.pm line 616.
ERROR: OTRS-otrs.Scheduler-63 Perl: 5.16.3 OS: MSWin32 Time: Mon Aug 18 19:48:56
2014

Message: Table '.\otrs\process_id' is marked as crashed and should be repaired,
SQL: 'SELECT process_name, process_id, process_host, process_create, process_ch
ange FROM process_id WHERE process_name = ? LIMIT 1'

Traceback (728):
Module: Kernel::System::PID::PIDGet (OTRS 3.2.11) Line: 181
Module: C:\otrs\OTRS\bin\otrs.Scheduler4win.pl (unknown version) Line: 195

ANY HELP Please ?

Thanks in advance
Anthony
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Scheduler4win.pl error starting mysql crashed

Post by jojo »

afarrugia wrote: Message: Table '.\otrs\process_id' is marked as crashed and should be repaired,
SQL: 'SELECT process_name, process_id, process_host, process_create, process_ch
ange FROM process_id WHERE process_name = ? LIMIT 1'
Repair the database table
"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
afarrugia
Znuny newbie
Posts: 2
Joined: 27 Feb 2014, 11:18
Znuny Version: 3.2.11

Re: Scheduler4win.pl error starting mysql crashed

Post by afarrugia »

Thanks repaired and working

Regards
Locked