Posted by Brett on 09/28/04 11:21

Hi,

I've received the following emails and it looks like i have a DB
problem. Is anybody able to help me?
This is causing problems with both request tracker and bugzilla.

Thanks,
Brett.


db1.db1
warning : 2 clients are using or haven't closed the table properly
db1.groups
warning : 1 client is using or hasn't closed the table properly
db1.logincookies
warning : 2 clients are using or haven't closed the table properly
db1.longdescs
warning : 2 clients are using or haven't closed the table properly
db1.profiles
warning : 1 client is using or hasn't closed the table properly
db1.user_group_map
warning : 1 client is using or hasn't closed the table properly
db2.Attachments
warning : 2 clients are using or haven't closed the table properly
db2.Tickets
warning : 1 client is using or hasn't closed the table properly
db2.Transactions
warning : 2 clients are using or haven'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: 12 Threads: 1 Questions: 117 Slow queries: 0 Opens: 103
Flush tables: 1 Open tables: 64 Queries per second avg: 9.750

• Next in forum: Re: Getting started with MySQL
• Prev in forum: Dumping MySQl Database
• Thread view: "Improperly closed tables" error

[Reply to this message]