mysqli_query Table './dbispconfig/monitor_data' is marked as crashed

Discussion in 'Installation/Configuration' started by Taleman, Mar 11, 2015.

  1. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    I get oodles of this or similar errors in e-mail:
    Code:
    11.03.2015-16:40 - WARNING - DB::query(DELETE FROM monitor_data WHERE
    type ='sys_log' AND created < UNIX_TIMESTAMP() - 240 AND server_id
    = 1) -> mysqli_query Table './dbispconfig/monitor_data' is marked as
    crashed and last (automatic?) repair failed
    Disk was full, I suppose this made database broken. Is the above condition repairable?
    I did find advice to run the update db script from ISPConfig installer, would it work in this case?
     
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    ISPConfig shows this in top of browser window:
    Code:
    0 db->query(SELECT DISTINCT type, data FROM monitor_data WHERE server_id = 2)
    called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:211]
    #1 db->queryAllRecords(SELECT DISTINCT type, data FROM monitor_data
    WHERE server_id = 2) called at [/usr/local/ispconfig/interface/web/monitor/show_sys_state.php:194] 
    #2 _getServerState(2, aweb4.domainname.country, ) called at [/usr/local/ispconfig/interface/web/monitor/show_sys_state.php:115] #3 _getSysState() called at [/usr/local/ispconfig/interface/web/monitor/show_sys_state.php:63]
    #0 db->query(SELECT DISTINCT type, data FROM monitor_data WHERE server_id = 1) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:211]
    #1 db->queryAllRecords(SELECT DISTINCT type, data FROM monitor_data WHERE server_id = 1) called at [/usr/local/ispconfig/interface/web/monitor/show_sys_state.php:194]
    #2 _getServerState(1, ispc3.domainname.country, ) called at [/usr/local/ispconfig/interface/web/monitor/show_sys_state.php:115]
    #3 _getSysState() called at [/usr/local/ispconfig/interface/web/monitor/show_sys_state.php:63]
    
     
  3. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    I managed to repair database table monitor_data.MYI following this manual:
    Code:
    http://dev.mysql.com/doc/refman/5.0/en/myisam-repair.html
    Now I get oodles of different errors. I'll try to undestand what they are about.
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Login to phpmyamin as root user, go to the dbispconfig database, select all tables and choose repair as action.
     

Share This Page