MySQL Error

Discussion in 'ISPConfig 3 Priority Support' started by yupthatguy, Jul 7, 2021.

  1. yupthatguy

    yupthatguy Member HowtoForge Supporter

    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]
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  3. yupthatguy

    yupthatguy Member HowtoForge Supporter

    Worked like charm... thanks
     

Share This Page