We just encountered the same condition sited in the following post snipped
from Goggle groups:
>fredrik chabot <fredrik@f6.nl> writes:
>> so I migrated the database to a non-smp machine running RH 7.2 and the
postgres
>> 7.2.1-5 rpm's<br>
>> <br>
>> Kernel 2.4.7-10<br>
>> <br>
>> and I still get
>> <blockquote type="cite" cite="mid25853.1032724594@sss.pgh.pa.us">
>> <pre wrap="">FATAL 1: LWLockAcquire: can't wait without a PROC
structure</pre>
>> </blockquote>
>> The code tells me this should never heppen :-<<br>
>
>I don't think it should happen either ;-) When do you see it exactly
>--- is it during startup of a fresh connection, or while executing
>queries in an existing backend, or ...?
>
> regards, tom lane
I could not find any info that said the cause or cure had been identified.
Can anyone fill me in?
For the record:
ccc=# select version();
version
-------------------------------------------------------------
PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)
Also a snip from our postmaster log:
2002-10-15 16:00:02 [2067] DEBUG: connection: host=10.1.2.100
user=BSPEIRS database=template1
2002-10-15 16:00:03 [2085] DEBUG: connection: host=10.1.2.100
user=BSPEIRS database=ccc
2002-10-15 16:00:03 [2086] DEBUG: connection: host=10.1.2.100
user=BSPEIRS database=template0
2002-10-15 16:00:03 [2086] FATAL 1: Database "template0" is not
currently accepting connections
2002-10-15 16:00:04 [2087] DEBUG: connection: host=10.1.2.100
user=BSPEIRS database=template0
2002-10-15 16:00:04 [2087] FATAL 1: Database "template0" is not
currently accepting connections
2002-10-15 16:00:04 [2087] FATAL 1: LWLockAcquire: can't wait without a
PROC structure
2002-10-15 16:00:04 [23427] DEBUG: server process (pid 2087) exited with
exit code 1
2002-10-15 16:00:04 [23427] DEBUG: terminating any other active server
processes
.... followed by a slew of "Postmaster has informed me..." messages.
The process attempting to connect was pgAdminII v1.2.0 .
Postgres had been up for 15 straight days prior to encountering this and
this is the first occurrence in 3 months of otherwise trouble-free up-time.
Any help in responding to this would be appreciated and we're open to
helping further diagnose if the cause is still undetermined.
Thanks,
Marc Mitchell - Senior Application Architect
Enterprise Information Solutions, Inc.
Downers Grove, IL 60515
marcm@eisolution.com