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.
Recent comments
2 days 23 hours ago
3 days 8 hours ago
3 days 11 hours ago
3 days 12 hours ago
3 days 14 hours ago
3 days 15 hours ago
3 days 17 hours ago
3 days 18 hours ago
4 days 10 hours ago
4 days 11 hours ago