Error Messages

From: Ludwig Lim <lud_nowhere_man(at)yahoo(dot)com>
To: PostgreSQL Mailing List <pgsql-admin(at)postgresql(dot)org>
Subject: Error Messages
Date: 2003-07-05 05:42:04
Message-ID: 20030705054204.65772.qmail@web80510.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi:

I found the following snippets of error messages in
the log file of a computer that is running
Postgresql-7.2:

NOTICE: Message from PostgreSQL backend:
The Postmaster has informed me that some other
backend died abnormally and possibly corrupted shared
memory.I have rolled back the current transaction and
am going to terminate your database system connection
and exit. Please reconnect to the database system and
repeat your query.

Is the error message above related to the following
error messages below :
DEBUG: pq_recvbuf: recv() failed: Connection timed
out
DEBUG: pq_flush: send() failed: Connection reset by
peer
DEBUG: pq_recvbuf: unexpected EOF on client
connection
DEBUG: pq_flush: send() failed: Broken pipe

By the way, I didn't issue a kill to the
postgreSQL processes so I'm surpise by the "unexpected
EOF on client connection".

Do I need to upgrade Postgresql? By the way there
are some errors if backup a 7.2 db and restore in 7.3
db. In 7.2 you can do something like "SELECT
CURRENT_TIMESTAMP()" in a plpgsql function, while this
will cause in an error in 7.3.

Do I need to change the hardware?

ludwig lim

__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com

Browse pgsql-admin by date

  From Date Subject
Next Message Daniel Seichter 2003-07-05 07:46:08 Re: No such file or directory: ./configure
Previous Message Rajesh Kumar Mallah 2003-07-05 05:34:48 vacuum warnings with pgsql 7.3.3