LWLockAcquire

From: "Matt Lynch" <matt(at)terraEngine(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: LWLockAcquire
Date: 2003-11-28 22:05:41
Message-ID: 000001c3b5fb$c3b1bd10$d701a8c0@matt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2003-11-28 22:51:15 Re: LWLockAcquire
Previous Message Paul Makepeace 2003-11-28 18:08:26 Constraints that check other tables