Re: The database system is in recovery mode

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(at)sss(dot)pgh(dot)pa(dot)us>
To: "Iavor Raytchev" <pobox(at)verysmall(dot)org>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Sent: Sunday, November 10, 2002 2:54 PM
Subject: Re: [HACKERS] The database system is in recovery mode

> "Iavor Raytchev" <pobox(at)verysmall(dot)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