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

B I tried running it on a dual cpu smp machine running 2.2.18* and there I got this msg far more frequently about once an hour. usaly 30-50 connections during the daytime. :-) help! regards fredrik chabot ---(end of broadcast)--- TIP 6: Have y

Re: [BUGS] some other backend died abnormally

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

Re: [BUGS] some other backend died abnormally

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

Re: [BUGS] some other backend died abnormally

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 (P

[BUGS] some other backend died abnormally

. what to do? regards fredrik chabot

Re: [BUGS] inconsistend performance

= ('fb',13,'2002080719163600' ) ORDER BY "afd" DESC , "dss" DESC , "dat" DESC LIMIT 2; NOTICE:  QUERY PLAN: Limit  (cost=0.00..6.35 rows=2 width=344)   ->  Index Scan Backward using dsrgl_primary on dsrgl  (cost=0.00..12580.87 rows=3960 width=34

[BUGS] inconsistend performance

quot; = '20020712143411' ) ; takes approx 0.000939 seconds SELECT "afd", "dss", "dat", "srt", "akt", "oms", "anc", "vkk", "vkka", "vkkt", "vkkv", "vkkr", "fav"