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'sfredrik chabot <[EMAIL PROTECTED]> writes:What version of Postgres? What platform (Linux, etc)?psql (PostgreSQL) 7.2.1
SMP Linux 2.2.18pre22I 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.
Kernel 2.4.7-10
and I still get
The code tells me this should never heppen :-<FATAL 1: LWLockAcquire: can't wait without a PROC structure
It is less frequent than on the smp machine.
regards fredrik chabot