Re: [BUGS] some other backend died abnormally

2002-09-24 Thread fredrik chabot
Tom Lane wrote: >fredrik chabot <[EMAIL PROTECTED]> writes: > >>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 s

Re: [BUGS] some other backend died abnormally

2002-09-24 Thread Tom Lane
fredrik chabot <[EMAIL PROTECTED]> writes: > 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

Re: [BUGS] some other backend died abnormally

2002-09-24 Thread fredrik chabot
Tom Lane wrote: fredrik chabot <[EMAIL PROTECTED]> 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.

Re: [BUGS] some other backend died abnormally

2002-09-22 Thread Tom Lane
fredrik chabot <[EMAIL PROTECTED]> 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

Re: [BUGS] some other backend died abnormally

2002-09-22 Thread fredrik chabot
Joe Conway wrote: > fredrik chabot wrote: > >> connection to server was lost >> >> I get more or less frequently. >> >> what to do? > > > Start by giving us more information. > > What version of Postgres? What platform (Linux, etc)? psql (PostgreSQL) 7.2.1 SMP Linux 2.2.18pre22 > What does the

Re: [BUGS] some other backend died abnormally

2002-09-22 Thread Tom Lane
Joe Conway <[EMAIL PROTECTED]> writes: >> what to do? > Start by giving us more information. > What version of Postgres? What platform (Linux, etc)? > What does the relevant portion of your database schema look like? > What repeatable series of actions causes the problem? > Is there a core file

Re: [BUGS] some other backend died abnormally

2002-09-22 Thread Joe Conway
fredrik chabot wrote: > connection to server was lost > > I get more or less frequently. > > what to do? Start by giving us more information. What version of Postgres? What platform (Linux, etc)? What does the relevant portion of your database schema look like? What repeatable series of action