Re: deadlock with vacuum full on 7.4.5 - Mailing list pgsql-general

From Joseph Shraibman
Subject Re: deadlock with vacuum full on 7.4.5
Date
Msg-id 416C64C3.6060605@selectacast.net
Whole thread Raw
In response to Re: deadlock with vacuum full on 7.4.5  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: deadlock with vacuum full on 7.4.5  (Gaetano Mendola <mendola@bigfoot.com>)
List pgsql-general
That is what I wanted to know, how to get the evidence for next time.

Tom Lane wrote:
> Joseph Shraibman <jks@selectacast.net> writes:
>
>>Why then when I did a kill -INT on the vacuuming backends did everything
>>unfreeze?
>
>
> You could have had other stuff backed up behind the VACUUM FULL lock
> requests.
>
> It's not impossible that you had a deadlock *outside* the database,
> that is some wait loop that is partially within and partially outside
> the DB.  But if you want me to believe there's a bug in our deadlock
> detector, you're going to have to offer some actual evidence...
>
>             regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: deadlock with vacuum full on 7.4.5
Next
From: Gaetano Mendola
Date:
Subject: Re: deadlock with vacuum full on 7.4.5