Re: Database server restarting - Mailing list pgsql-general

Our server reboots at 1 aM in the morning and the job I mentioned starts
at 4 aM in the morning and the job ended at 4.13 AM. This process is
database extensive around 10000 records are updated / inserted.Can it be
the cause of this problem.  After this thing happened my server just
hangs.

Last night I faced the same problem again on another server and it was
after yet another DB extensive process.
The  system has 1 GB RAM, 1 GHZ processor and RAID 1 installed on it and
Red Hat linux 7.3.
We are about to install 70 such servers.

Please help.

regards
Shoaib

-----Original Message-----
From: Dennis Gearon [mailto:gearond@cvc.net]
Sent: Monday, May 05, 2003 11:13 PM
To: shoaib
Cc: 'Nigel J. Andrews'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Database server restarting

Modern OS's shouldn' need rebooting, unless something else is wrong.
What's the quality of your hardware? Any applications compiled on bad
hardware?

sigh, is it a windows environment?

shoaib wrote:
> 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
>>
>>
>
>