Table "scheduled_job_log_record" is marked as crashed and should be repaired

[Vincent]

There were some notification email not sent and the following error was found in the log

Table "scheduled_job_log_record" is marked as crashed and should be repaired

What should i do to solve this? Thanks!!!

[item]

Hi,

https://www.a2hosting.com/kb/cpanel/cpanel-database-features/optimizing-and-repairing-mysql-databases-with-phpmyadmin

You can too "truncate" this table.. the table scheduled_job_log_record contents can be deleted.

Try too delete in Admin->Schedule Job then button JOB.. you can delete all record

Regards

[yuri]

You can run repair table in phpmyadmin.

I recommend to migrate job, scheduled_job_log_record tables (and other tables) to InnoDB.

[Vincent]

Thank you. The scheduled_job_log_record table seems no problem after repaired.

However, there is another problem. I have a process with a pending "Send Message task", after repairing the mentioned table, this task is still in pending status and no notification email was sent.

In log file:
"exception":"[object] (PDOException(code: HY000): SQLSTATE[HY000]: General error: 126 Incorrect key file for table './ipms01/job.MYI'; try to repair it at /var/www/html/ipms/application/Espo/ORM/DB/Mapper.php:729)"

how to solve it? Thank you.

[Vincent]

The 2nd problem was solved by repairing the job table

[bruce185]

I had the same problem... I ran this to check the db

`mysqlcheck -c [mydatabase] -u root -p`

And this to repair it

`mysqlcheck -r [mydatabase] -u root -p`

After that the upgrade worked fine on both instances I run...

[yuri]

If you have MyISAP tables I recommend to convert them to InnoDB. Less likely to be crashed.

[bruce185]

If you have MyISAP tables I recommend to convert them to InnoDB. Less likely to be crashed.

I just followed the installer... did you guys set MyISAM as the default at one point?

[yuri]

It was MyISAM initially years ago.

[bruce185]

ok, that probably explains it...