Tom Lane wrote:

fredrik chabot <fredrik@f6.nl> writes:

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

psql (PostgreSQL) 7.2.1
SMP Linux 2.2.18pre22

I seem to recall that SMP support was very flaky in the 2.2 series
kernels, and even in 2.4 up to 2.4.10 or something like that.
Perhaps a kernel 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