Re: some other backend died abnormally

Tom Lane wrote:

  fredrik chabot <fredrik@f6.nl> writes:


      What version of Postgres? What platform (Linux, etc)?



    psql (PostgreSQL) 7.2.1SMP Linux 2.2.18pre22

  I seem to recall that SMP support was very flaky in the 2.2 serieskernels, and even in 2.4 up to 2.4.10 or something
likethat.Perhaps a ker<pre 
 wrap="">nel update would make life better.

I turned on loggin and it appeard to be a shared memory locking problem,
so I migrated the database to a non-smp machine running RH 7.2 and the postgres
7.2.1-5 rpm's

Kernel 2.4.7-10

and I still get

  FATAL 1:  LWLockAcquire: can't wait without a PROC structure

The code tells me this should never heppen :-<

It is less frequent than on the smp machine.

regards fredrik chabot