HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=16)
-   -   mysqlcheck has found corrupt tables (http://www.howtoforge.com/forums/showthread.php?t=312)

m u r 17th August 2005 23:05

mysqlcheck has found corrupt tables
 
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

till 18th August 2005 10:47

Quote:

Originally Posted by m u r
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


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.


All times are GMT +2. The time now is 01:01.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.