Re: [HACKERS] Tom Lane's fixes in v6.4.3

> Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> writes:
> > One thing I noticed: when the backend runs out the
> > semaphores, postmatser dies with following messages:
>
> > IpcSemaphoreCreate: semget failed (No space left on device) key=5432017, num=16, permission=600
> > 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 this normal?
>
> Yes, that's the behavior that we decided we'd better fix for 6.5.

Glad to hear that.

> I think retrofitting the various MaxBackends-related changes into 6.4.x
> would be risky --- the changes are fairly widespread and have not gotten
> all that much testing so far.

Ok. I will keep your patches for the case of having trouble with many
backends. I think it should be noted somewhere that 6.4.3 is not very
stable with many backends (known bugs section?).
--
Tatsuo Ishii