Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 19D16B5DBC4 for ; Mon, 27 Jun 2011 08:41:06 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 87292-09 for ; Mon, 27 Jun 2011 11:41:00 +0000 (UTC) X-Greylist: delayed 00:09:39.47381 by SQLgrey-1.7.6 Received: from hermes.vectorsf.com (firewall.vectorsf.com [62.82.80.62]) by mail.postgresql.org (Postfix) with ESMTP id 8F644B5D94C for ; Mon, 27 Jun 2011 08:40:59 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by hermes.vectorsf.com (Postfix) with ESMTP id 8E4E411C0149 for ; Mon, 27 Jun 2011 13:31:17 +0200 (CEST) X-Virus-Scanned: amavisd-new at hermes.vectorsf.com Received: from hermes.vectorsf.com ([127.0.0.1]) by localhost (hermes.vectorsf.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id tNXUj5dVZxuU for ; Mon, 27 Jun 2011 13:31:16 +0200 (CEST) Received: from [10.70.4.200] (unknown [10.70.4.200]) (Authenticated sender: imartinez) by hermes.vectorsf.com (Postfix) with ESMTPSA id 95E5711C0144 for ; Mon, 27 Jun 2011 13:31:16 +0200 (CEST) Subject: Urgent! Log full with inexistent PID processes From: =?ISO-8859-1?Q?I=F1igo?= Martinez Lasala To: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary="=-h4IOjlLN81xzdfqIOMje" Date: Mon, 27 Jun 2011 13:31:17 +0200 Message-ID: <1309174277.5158.30.camel@deimos> Mime-Version: 1.0 X-Mailer: Evolution 2.32.2 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.909 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201106/142 X-Sequence-Number: 37768 --=-h4IOjlLN81xzdfqIOMje Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 7bit Hi everybody. We have a postgres 8.4.5-2 database under Debian Lenny 64bit. This database has been working without any problem, but this afternoon server has got out of space due to a log dump. Log file gets full with this entry until it reaches several gigabytes: 2011-06-27 13:25:07 CEST LOG: PID 21822 in cancel request did not match any process 2011-06-27 13:25:07 CEST LOG: PID 21821 in cancel request did not match any process 2011-06-27 13:25:07 CEST LOG: PID 21820 in cancel request did not match any process 2011-06-27 13:25:07 CEST LOG: PID 21816 in cancel request did not match any process 2011-06-27 13:25:07 CEST LOG: PID 21802 in cancel request did not match any process Of course, we have restarted postmaster and rebooted machine but problem remains. Any clue about this? pg_hba only allows connection from localhost and, of course, there are no processes with these PIDs in the server... Thanks in advance. --=-h4IOjlLN81xzdfqIOMje Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: 7bit Hi everybody.

We have a postgres 8.4.5-2 database under Debian Lenny 64bit.
This database has been working without any problem, but this afternoon server has got out of space due to a log dump.

Log file gets full with this entry until it reaches several gigabytes:

2011-06-27 13:25:07 CEST LOG:  PID 21822 in cancel request did not match any process
2011-06-27 13:25:07 CEST LOG:  PID 21821 in cancel request did not match any process
2011-06-27 13:25:07 CEST LOG:  PID 21820 in cancel request did not match any process
2011-06-27 13:25:07 CEST LOG:  PID 21816 in cancel request did not match any process
2011-06-27 13:25:07 CEST LOG:  PID 21802 in cancel request did not match any process


Of course, we have restarted postmaster and rebooted machine but problem remains.

Any clue about this?

pg_hba only allows connection from localhost and, of course, there are no processes with these PIDs in the server...

Thanks in advance.  --=-h4IOjlLN81xzdfqIOMje--