Hey Fellas, I got a strange warning today... perhaps you guys can shed some light on the situation: ERROR 144 (HY000) at line 1: Table './dbispconfig/monitor_data' is marked as crashed and last (automatic?) repair failed Improperly closed tables are also reported if clients are accessing the tables *now*. A list of current connections is below. +-----+-------------+-----------+-------------+---------+------+--------------------------+------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +-----+-------------+-----------+-------------+---------+------+--------------------------+------------------+----------+ | 2 | system user | | | Daemon | | InnoDB purge worker | | 0.000 | | 1 | system user | | | Daemon | | InnoDB purge coordinator | | 0.000 | | 3 | system user | | | Daemon | | InnoDB purge worker | | 0.000 | | 4 | system user | | | Daemon | | InnoDB purge worker | | 0.000 | | 5 | system user | | | Daemon | | InnoDB shutdown handler | | 0.000 | | 12 | ispconfig | localhost | dbispconfig | Sleep | 3 | | | 0.000 | | 13 | root | localhost | dbispconfig | Sleep | 3 | | | 0.000 | | 120 | root | localhost | | Query | 0 | Init | show processlist | 0.000 | +-----+-------------+-----------+-------------+---------+------+--------------------------+------------------+----------+ Uptime: 18446744073709522856 Threads: 9 Questions: 301 Slow queries: 1 Opens: 284 Flush tables: 1 Open tables: 273 Queries per second avg: 0.000 From root <[email protected]> Subject WARNING: mysqlcheck has found corrupt tables To [email protected]
The error message explains what the problem is: Table './dbispconfig/monitor_data' is marked as crashed To fix that, login to phpmyadmin as root user, go to the dbispconfig database, choose the monitor_data table and choose to optimize and repair the table in phpmyadmin.