Re: The database system is in recovery mode - Mailing list pgsql-hackers

From Iavor Raytchev
Subject Re: The database system is in recovery mode
Date
Msg-id 006301c288c3$738fa830$7b2bb23e@iavor
Whole thread Raw
In response to Re: missing const it PQexscapeBytea/PQunescapeBytea in 7.3b3  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: The database system is in recovery mode
List pgsql-hackers
Tom,

Before the crash is this one -

FATAL 1: Sorry, too many clients already

Then there is a mixture of three messages -

IpcSemaphoreLock: semop(id=-1) failed: Invalid argument

DEBUG: pq_flush: send() failed: Bad file descriptor

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.

Shall we simply restart? Are there anywhere advices how to handle if too
many clients try to connect?

Iavor

----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Iavor Raytchev" <pobox@verysmall.org>
Cc: <pgsql-hackers@postgresql.org>
Sent: Sunday, November 10, 2002 2:54 PM
Subject: Re: [HACKERS] The database system is in recovery mode


> "Iavor Raytchev" <pobox@verysmall.org> writes:
> > -bash-2.05b$ psql
> > psql: FATAL 1:  The database system is in recovery mode
>
> What do you find in the postmaster's log?
>
> regards, tom lane




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: The database system is in recovery mode
Next
From: snpe
Date:
Subject: SQL syntax (column alias)