Database table errors

Duane Webber shared this question 25 days ago
Answered

I'm receiving the following errors:


db_1 | 2018-11-19 19:31:12 139839375640320 [ERROR] mysqld: Table './lb_customer/ur_sessions' is marked as crashed and should be repaired

db_1 | 2018-11-19 19:31:12 139839375640320 [ERROR] mysqld: Table 'ur_sessions' is marked as crashed and should be repaired

db_1 | 2018-11-19 19:31:12 139839375640320 [Warning] Checking table: './lb_customer/ur_sessions'

db_1 | 2018-11-19 19:31:12 139839375640320 [ERROR] mysqld: Table './lb_customer/ur_users' is marked as crashed and should be repaired

db_1 | 2018-11-19 19:31:12 139839375640320 [ERROR] mysqld: Table 'ur_users' is marked as crashed and should be repaired

db_1 | 2018-11-19 19:31:12 139839375640320 [Warning] Checking table: './lb_customer/ur_users'


I ran 'repair table' (https://mariadb.com/kb/en/library/repair-table/) and received the following response, for example, for each table:


MariaDB [lb_customer]> repair table ur_users;

+----------------------+--------+----------+----------+

| Table | Op | Msg_type | Msg_text |

+----------------------+--------+----------+----------+

| lb_customer.ur_users | repair | status | OK |

+----------------------+--------+----------+----------+

1 row in set (0.02 sec)


However, when I restart the database, the same errors appear in the log. What is the best way to repair these tables?

Comments (2)

photo
1

Hello Duane,

The best way is to repair it using console or any db manager tool.

We can try to resolve it if you would provide access to db or server privately.

photo
1

I reinitialized the database from a backup and for now, everything seems to be working as expected. I appreciate the offer and the great support.