Re: Database server restarting - Mailing list pgsql-general

Thanks a lot for your prompt reply.
We are rebooting the server for cleaning up the buffers of the
system.Before rebooting I will shutdown database server.Can you provide
any futher clue why suddenly at 4.17 aM it restarted.Our preventive
maintenance run at 1 AM.
And another process of Reading data from some flat files and updating it
to database ended at 4.13 AM on the same day.
Your help is really appreciated.

Regards
Shoaib

-----Original Message-----
From: Nigel J. Andrews [mailto:nandrews@investsystems.co.uk]
Sent: Monday, May 05, 2003 7:08 PM
To: shoaib
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Database server restarting

On Mon, 5 May 2003, shoaib wrote:

> Hello Everybody,
>
> We are using postgressql 7.2.2 . our system running is 24 hours day it
a
> preventive reboot once a day.

Odd concept. What is this reboot preventing?


> some time I am getting this error and after
> it the sytem hang .Can any body help in this.
>
> DEBUG:  pq_recvbuf: unexpected EOF on client connection
> DEBUG:  pq_recvbuf: unexpected EOF on client connection
> DEBUG:  pq_recvbuf: unexpected EOF on client connection
> DEBUG:  pq_recvbuf: unexpected EOF on client connection
> DEBUG:  database system was interrupted at 2003-05-03 04:17:19 SGT
> DEBUG:  checkpoint record is at 3/85EA18B0
> DEBUG:  redo record is at 3/85EA18B0; undo record is at 0/0; shutdown
> FALSE
> DEBUG:  next transaction id: 4111285; next oid: 7557242
> DEBUG:  database system was not properly shut down; automatic recovery
> in progress

It looks like your preventative daily reboot is not preventing the
problems it
is causing. It is possible that the postmaster is not being shutdown
properly
because, for example, there is a client still connected and the shutdown
script
isn't forcing a fast shutdown. See pg_ctl manpage for infomation on the
switches.

As for worrying about the messages, there's no real error message in
there,
aside from the 'EOF on client connection', just the normal messages on
start up
from a bad shutdown. If you're worried, I would look at solving whatever
the
answer to the daily reboot question shows is the problem.


> DEBUG:  ReadRecord: record with zero length at 3/85EA18F0
> DEBUG:  redo is not required
> DEBUG:  recycled transaction log file 0000000300000083
> DEBUG:  recycled transaction log file 0000000300000084
> DEBUG:  database system is ready
> DEBUG:  pq_recvbuf: unexpected EOF on client connection
>
>
> Regards
>
> Shoaib
>
>

--
Nigel J. Andrews