Clarence Gardner <[EMAIL PROTECTED]> writes:
> I'm still creeping up on the problem. I configured postgres to resolve
> a deadlock only after a month, and now I seem to have a complete
> snapshot of one of them.
If you don't mind rebuilding Postgres from source, here's the patch
as applied to 8.1
On 11/17/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Gurjeet Singh" <[EMAIL PROTECTED]> writes:
> Small implementation detail: Also keep a count of how many times the
same
> session requested the same lock, and do not release the lock until he
> requests same number of releases.
No need for that,
"Gurjeet Singh" <[EMAIL PROTECTED]> writes:
> On 11/17/06, Tom Lane <[EMAIL PROTECTED]> wrote:
>> we need a special case when we are already a member of the MultiXact:
>> fall through without trying to reacquire the tuple lock.
> Small implementation detail: Also keep a count of how many times the
On 11/17/06, Tom Lane <[EMAIL PROTECTED]> wrote:
we need a special case when we are already a member of the MultiXact:
fall through without trying to reacquire the tuple lock.
Small implementation detail: Also keep a count of how many times the same
session requested the same lock, and do not
Clarence Gardner <[EMAIL PROTECTED]> writes:
> That scenario seems quite simple, but I can't reproduce the deadlock with
> this seemingly-identical sequence.
This is a bug in 8.1 and up. The reason you couldn't reproduce it is
that it requires a minimum of three transactions involved, two of whic
Once upon a time, I put a question regarding deadlocks to the group,
and Tom Lane immediately answered with this:
>The guy waiting on the tuple-specific lock is second in
>line to actually mung the tuple. Whoever is first in line behind the
>current tenant will be blocked trying to acquire Share
Once upon a time, I put a question regarding deadlocks to the group,
and Tom Lane immediately answered with this:
>The guy waiting on the tuple-specific lock is second in
>line to actually mung the tuple. Whoever is first in line behind the
>current tenant will be blocked trying to acquire ShareL
