Re: Urgent! Log full with inexistent PID processes

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.