Re: BUG #13970: Vacuum hangs on particular table; cannot be terminated - requires `kill -QUIT pid` - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #13970: Vacuum hangs on particular table; cannot be terminated - requires `kill -QUIT pid`
Date
Msg-id 20160219214555.GA150237@alvherre.pgsql
Whole thread Raw
In response to Re: BUG #13970: Vacuum hangs on particular table; cannot be terminated - requires `kill -QUIT pid`  (Brian Ghidinelli <brian@vfive.com>)
Responses Re: BUG #13970: Vacuum hangs on particular table; cannot be terminated - requires `kill -QUIT pid`  (Brian Ghidinelli <brian@vfive.com>)
List pgsql-bugs
Here's another idea: just try SELECT FOR UPDATE on the offending tuple.
As I recall, that code path has enough protections that we wouldn't try
to read the members of the multixact even if we don't see it as below
the horizon, simply by checking the infomask bits as I mentioned before.

You could try SELECT FOR UPDATE the complete table.  If you had debug
symbols you could grab the specific TID that's giving you trouble from
the backtrace ... but then the table is not *that* large.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #13974: temp_file_limit effects vacuum
Next
From: Brian Ghidinelli
Date:
Subject: Re: BUG #13970: Vacuum hangs on particular table; cannot be terminated - requires `kill -QUIT pid`