Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 17th August 2005, 23:05
m u r m u r is offline
Senior Member
 
Join Date: Jul 2005
Posts: 152
Thanks: 13
Thanked 1 Time in 1 Post
Send a message via AIM to m u r Send a message via MSN to m u r
Default 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
Reply With Quote
Sponsored Links
  #2  
Old 18th August 2005, 10:47
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,430
Thanks: 813
Thanked 5,208 Times in 4,084 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
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


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


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