Thread: LWLockAcquire

LWLockAcquire

From
"Matt Lynch"
Date:
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




Re: LWLockAcquire

From
Tom Lane
Date:
"Matt Lynch" <matt@terraEngine.com> writes:
> 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

This bug was fixed ages ago.  Use something more recent than 7.2.

            regards, tom lane