Problem with Mysqld on odk_prod

Development
1

Hi ODK Developer

I have some problem wtih login into server aggregate, it always time out
when entering,

when I chek on the mysqld.log this error shown

161130 8:00:02 [ERROR] /usr/libexec/mysqld: Table
'./odk_prod/_backend_actions' is marked as crashed and should be repaired
161130 8:02:06 [ERROR] /usr/libexec/mysqld: Table
'./odk_prod/_backend_actions' is marked as crashed and should be repaired
161130 8:02:07 [ERROR] /usr/libexec/mysqld: Table
'./odk_prod/_backend_actions' is marked as crashed and should be repaired
161130 8:02:35 [ERROR] /usr/libexec/mysqld: Table
'./odk_prod/_backend_actions' is marked as crashed and should be repaired
161130 8:02:35 [ERROR] /usr/libexec/mysqld: Table
'./odk_prod/_backend_actions' is marked as crashed and should be repaired
161130 8:03:32 [ERROR] /usr/libexec/mysqld: Table
'./odk_prod/_backend_actions' is marked as crashed and should be repaired
161130 8:03:32 [ERROR] /usr/libexec/mysqld: Table
'./odk_prod/_backend_actions' is marked as crashed and should be repaired
161130 8:04:20 [ERROR] /usr/libexec/mysqld: Table
'./odk_prod/_backend_actions' is marked as crashed and should be repaired
161130 8:04:39 [ERROR] /usr/libexec/mysqld: Table
'./odk_prod/_backend_actions' is marked as crashed and should be repaired
161130 8:05:17 [ERROR] /usr/libexec/mysqld: Table
'./odk_prod/_backend_actions' is marked as crashed and should be repaired

Mybe any one in this group can help

thanks very much before

Sukarno

2

Sukarno,

This is a MySQL specific issue.

_backend_actions seems to be corrupt. How that happened, I don't
know. Maybe file system errors?

The solution is to back up your database and try to repair it.
https://dev.mysql.com/doc/refman/5.7/en/repair-table.html has more
information.

Yaw

ยทยทยท On Wed, Nov 30, 2016 at 1:11 AM, Rashida Lara wrote: > Hi ODK Developer > > I have some problem wtih login into server aggregate, it always time out > when entering, > > when I chek on the mysqld.log this error shown > > 161130 8:00:02 [ERROR] /usr/libexec/mysqld: Table > './odk_prod/_backend_actions' is marked as crashed and should be repaired > 161130 8:02:06 [ERROR] /usr/libexec/mysqld: Table > './odk_prod/_backend_actions' is marked as crashed and should be repaired > 161130 8:02:07 [ERROR] /usr/libexec/mysqld: Table > './odk_prod/_backend_actions' is marked as crashed and should be repaired > 161130 8:02:35 [ERROR] /usr/libexec/mysqld: Table > './odk_prod/_backend_actions' is marked as crashed and should be repaired > 161130 8:02:35 [ERROR] /usr/libexec/mysqld: Table > './odk_prod/_backend_actions' is marked as crashed and should be repaired > 161130 8:03:32 [ERROR] /usr/libexec/mysqld: Table > './odk_prod/_backend_actions' is marked as crashed and should be repaired > 161130 8:03:32 [ERROR] /usr/libexec/mysqld: Table > './odk_prod/_backend_actions' is marked as crashed and should be repaired > 161130 8:04:20 [ERROR] /usr/libexec/mysqld: Table > './odk_prod/_backend_actions' is marked as crashed and should be repaired > 161130 8:04:39 [ERROR] /usr/libexec/mysqld: Table > './odk_prod/_backend_actions' is marked as crashed and should be repaired > 161130 8:05:17 [ERROR] /usr/libexec/mysqld: Table > './odk_prod/_backend_actions' is marked as crashed and should be repaired > > Mybe any one in this group can help > > thanks very much before > > Sukarno > > -- > You received this message because you are subscribed to the Google Groups > "ODK Developers" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to opendatakit-developers+unsubscribe@googlegroups.com. > For more options, visit https://groups.google.com/d/optout.