Computer Webmaster Gaming Console Graphics Forum

Welcome to the Computer Webmaster Gaming Console Graphics Forum forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact contact us.

MK PitStop Main Earn $25 Earn Money Posting Extras Members Blogs Image Hosting User Pages
Go Back   Computer Webmaster Gaming Console Graphics Forum > Webmaster Forum > Website Coding > Database
Register FAQ/Rules Become A V.I.P. Member Search Today's Posts Mark Forums Read

Database Database problems or need to ask a question? maybe something to do with sql injections or a database software question. Database topics cover MySQL, PostgreSQL, Oracle, SQL Server or anything else related to databases.

Google
Reply
 
LinkBack Thread Tools Display Modes
Old 05-31-2007, 7:41 PM   #1
Brett
 
Brett's Avatar
 
Posts: n/a
My Photos: (0)

Banked:
MK Cash: $

I am Worth:
MK Cash: $
Donate

Recent Blog: None

Default "Improperly closed tables" error

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
 
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit!
Reply With Quote
Featured Websites
Free Space
Free Space
Free Space Free Space
Reply
Tags: , , ,




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
some shortcut keys not working anymore-----help"""""""" Kadaitcha Man Windows 1 05-28-2007 10:28 PM
I receive "General HTTP error: Domain name not found", although my site works normally msk2go@gmail.com Google questions 0 05-28-2007 12:46 AM
PEAR DB ERROR: db_error: message="DB Error: insufficient data supplied" code=-20 Kevin McCarthy Pear 0 05-20-2007 5:34 PM
MDB2 - how to catch "MDB2 Error: constraint violation" error? l Burnerheimerton Pear 1 05-20-2007 5:34 PM
"Windows Recovered from a Serious Error" FilleFolle Windows 1 06-26-2006 1:04 PM


Featured Websites




All times are GMT +1. The time now is 4:01 AM.


Powered by: vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO 3.0.0
Cheap Computers
MK PitStop Copyright 2005 - 2008

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98