Skip to Content.
Sympa Menu

postfilter - Re: [Postfilter] db error

postfilter AT lists.kfki.hu

Subject: Postfilter mailing list

List archive

Re: [Postfilter] db error


Chronological Thread 
  • From: Kadlecsik Jozsi <kadlec AT sunserv.kfki.hu>
  • To: Balázs Tibor <covek AT covek.hu>
  • Cc: postfilter <postfilter AT sunserv.kfki.hu>
  • Subject: Re: [Postfilter] db error
  • Date: Tue, 2 May 2006 10:02:32 +0200 (MEST)
  • List-archive: <http://sunserv.kfki.hu/pipermail/postfilter>
  • List-id: Postfilter mailing list <postfilter.lists.kfki.hu>

On Sat, 29 Apr 2006, [ISO-8859-1] Balázs Tibor wrote:

Az alábbi üzenetet kaptam ma:

mysql.db
warning : 1 client is using or hasn't closed the table properly
mysql.user
warning : 1 client is using or hasn't closed the table properly
postfilter.captcha
warning : 1 client is using or hasn't closed the table properly
postfilter.config
warning : 1 client is using or hasn't closed the table properly
postfilter.cookie
warning : 1 client is using or hasn't closed the table properly
postfilter.greylist
warning : 1 client is using or hasn't closed the table properly
postfilter.greylist_white
warning : 1 client is using or hasn't closed the table properly
postfilter.helo
warning : 1 client is using or hasn't closed the table properly
postfilter.report
warning : 1 client is using or hasn't closed the table properly
postfilter.user
warning : 1 client is using or hasn't closed the table properly
postfilter.user_whitelist
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: 46 Slow queries: 0 Opens: 38 Flush
tables: 1 Open tables: 32 Queries per second avg: 23.000

Mi okozhatta?

Meghalt egy script (es nem volt ideje lezarni a kapcsolatot)?

Nem adok ki explicit DB close utasitasokat a script-ekben, mert a Perl ugyis elvegzi a vegen: hozzaadom ezeket a 2.3-as valtozathoz, just in case.

Udvozlettel,
Jozsi
--
E-mail :
kadlec AT sunserv.kfki.hu,

kadlec AT blackhole.kfki.hu
PGP key: http://www.kfki.hu/~kadlec/pgp_public_key.txt
Address: KFKI Research Institute for Particle and Nuclear Physics
H-1525 Budapest 114, POB. 49, Hungary


Archive powered by MHonArc 2.6.19+.

Top of Page