Tom Lane wrote:
>fredrik chabot <fredrik(at)f6(dot)nl> writes:
>>so I migrated the database to a non-smp machine running RH 7.2 and the postgres
>>and I still get
>>FATAL 1: LWLockAcquire: can't wait without a PROC structure
>>The code tells me this should never heppen :->
>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 ...?
Ok, short answer I don't know; long answer:
Most connections are "long-lived" connections staying up for hours on
end. There are somewhere form 6 upto ~75 connections open at a time
about 6 at night > 50 during "office hours". Both failures today where
in office hours and It happend about every hour in office hours on the
smp system and only once in the off hours.
I got it BTW twice while loading the data in the database. Simple stuff
begin; -thousands of inserts; commit; and then the next table.
I did not once fail during the test fase of the system. (one or two
users at a time)
So my hunch is that it happens when there has been a lot of operations
in one connection and a lot of other connections at the same time.
> regards, tom lane
>PS: please don't send HTML mail to the lists, it's a pain to quote ...
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
In response to
pgsql-bugs by date
|Next:||From: pgsql-bugs||Date: 2002-09-26 14:43:31|
|Subject: Bug #780: Timestamp shifted by one minute|
|Previous:||From: Tom Lane||Date: 2002-09-24 16:23:22|
|Subject: Re: some other backend died abnormally |