Thread: Emergency case: Postgres problems

Emergency case: Postgres problems

From
"Jaruwan Laongmal"
Date:
Dear Sir,
 
I  will highly appreciated if anyone could inform me how to solve the following problems in Postgres.
Specifically, sometimes there  are the following messages informed by postgres.
 
------------------------------------------------
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.
pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally
        before or while processing the request.
------------------------------------------------
 
Thank you  so much for your concern
 
Jaruwan
 
 
PS.  The Postgres version is 7.0.0 run on  Red Hat Linux 7.1
 
 

Re: Emergency case: Postgres problems

From
Jan Wieck
Date:
Jaruwan Laongmal wrote:
[Charset windows-874 unsupported, skipping...]
> Dear Sir,
>
> I  will highly appreciated if anyone could inform me how to solve the following problems in Postgres.
> Specifically, sometimes there  are the following messages informed by postgres.
>
> ------------------------------------------------
> 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.
> pqReadData() -- backend closed the channel unexpectedly.
>         This probably means the backend terminated abnormally
>         before or while processing the request.
> ------------------------------------------------
>
> Thank you  so much for your concern
>
> Jaruwan
>
>
> PS.  The Postgres version is 7.0.0 run on  Red Hat Linux 7.1
   Upgrade  to  7.0.3, which is the latest bugfix release of the   7.0 version. There is a good chance that  the  error
causing   your database process to dump core is fixed in it.
 
   If  the  problem persists after, you should look for the core   file in your database directory,  use  gdb  to  get
a stack   backtrace and post that information to the list again.
 


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com