From: Adarsh Sharma <adarsh.sharma@orkash.com>
To: Iñigo Martinez Lasala <imartinez@vectorsf.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Urgent! Log full with inexistent PID processes
Date: Mon, 27 Jun 2011 17:55:44 +0530
Message-ID: <4E0876C8.7050200@orkash.com> (raw)
In-Reply-To: <1309174277.5158.30.camel@deimos>
References: <1309174277.5158.30.camel@deimos>
Iñigo Martinez Lasala wrote:
> 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
>
>
First check the space occupied by pg_log directory.
Just delete the previous logs that are 1 month older.
rm -rf pg_log******
> 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: adarsh.sharma@orkash.com, imartinez@vectorsf.com
Subject: Re: Urgent! Log full with inexistent PID processes
In-Reply-To: <4E0876C8.7050200@orkash.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox