mysqlcheck has found corrupt tables

Discussion in 'Installation/Configuration' started by m u r, Aug 17, 2005.

  1. m u r

    m u r Member

    I had the following errors emailed to me, can anyone translate?

    ERROR EMAIL 1:

    ispconfigdb.session
    warning : 1 client is using or hasn't closed the table properly

    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 |
    +----+------------------+-----------+----+---------+------+-------+------------------+
    | 5 | debian-sys-maint | localhost | | Query | 0 | | show processlist |
    +----+------------------+-----------+----+---------+------+-------+------------------+
    Uptime: 2 Threads: 1 Questions: 65 Slow queries: 0 Opens: 57 Flush tables: 1 Open tables: 51 Queries per second avg: 32.500

    ERROR EMAIL 2:

    ispconfigdb.dns_nodes
    warning : 1 client is using or hasn't closed the table properly
    ispconfigdb.groups
    warning : 1 client is using or hasn't closed the table properly
    ispconfigdb.isp_dep
    warning : 1 client is using or hasn't closed the table properly
    ispconfigdb.isp_isp_domain
    warning : 1 client is using or hasn't closed the table properly
    ispconfigdb.isp_isp_kunde
    warning : 1 client is using or hasn't closed the table properly
    ispconfigdb.isp_isp_reseller
    warning : 1 client is using or hasn't closed the table properly
    ispconfigdb.isp_isp_user
    warning : 1 client is using or hasn't closed the table properly
    ispconfigdb.isp_isp_web
    warning : 1 client is using or hasn't closed the table properly
    ispconfigdb.isp_nodes
    warning : 1 client is using or hasn't closed the table properly
    ispconfigdb.isp_server
    warning : 1 client is using or hasn't closed the table properly
    ispconfigdb.isp_server_ip
    warning : 1 client is using or hasn't closed the table properly
    ispconfigdb.isp_traffic
    warning : 1 client is using or hasn't closed the table properly
    ispconfigdb.session
    warning : 1 client is using or hasn't closed the table properly
    ispconfigdb.sys_nodes
    warning : 1 client is using or hasn't closed the table properly
    ispconfigdb.sys_user
    warning : 1 client is using or hasn't closed the table properly
    ispconfigdb.user_groups
    warning : 1 client is using or hasn't closed the table properly

    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 |
    +----+------------------+-----------+----+---------+------+-------+------------------+
    | 5 | debian-sys-maint | localhost | | Query | 0 | | show processlist |
    +----+------------------+-----------+----+---------+------+-------+------------------+
    Uptime: 2 Threads: 1 Questions: 65 Slow queries: 0 Opens: 57 Flush tables: 1 Open tables: 51 Queries per second avg: 32.500
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer


    This means that a database session to the ISPConfig database has not been closed properly.

    In the ISPConfig Controlpanel go to Management > ISPConfig Database, click firdt on check database, then on repair database.
     

Share This Page