View Single Post
  #2  
Old 18th August 2005, 11:47
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,651 Times in 4,461 Posts
Default

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.
Reply With Quote