LWLockAcquire - Mailing list pgsql-novice

From Matt Lynch
Subject LWLockAcquire
Date
Msg-id 000001c3b5fb$c3b1bd10$d701a8c0@matt
Whole thread Raw
Responses Re: LWLockAcquire
List pgsql-novice
Hi,

I have a web application with which I use Postgres 7.2.  Every once and
a while I get the following error message:

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

I have run logs to help me narrow the problem down, but haven't been
able to decipher the problem from them.
The command I used was:

pg_ctl start -l c:\psql.log -o "-d16 -D C:\postgis\data -c
MAX_CONNECTIONS=yes -c DEBUG_PRINT_PARSE=yes -c LOG_PID=yes -c
LOG_TIMESTAMP=yes -c LOG_CONNECTIONS=yes -c SHOW_PARSER_STATS=yes -c
STATS_COMMAND_STRING=yes"

Any suggestions on what to look for, or how to narrow the problem down
would be appreciated.

Thanks,

Matt

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.543 / Virus Database: 337 - Release Date: 11/21/2003




pgsql-novice by date:

Previous
From: "Vellinga, Fred"
Date:
Subject: RST.Addnew in combination with Limit 1.
Next
From: Tom Lane
Date:
Subject: Re: LWLockAcquire