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

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: BUG #13970: Vacuum hangs on particular table; cannot be terminated - requires `kill -QUIT pid`
Дата
Msg-id 20160219214555.GA150237@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: BUG #13970: Vacuum hangs on particular table; cannot be terminated - requires `kill -QUIT pid`  (Brian Ghidinelli <brian@vfive.com>)
Ответы Re: BUG #13970: Vacuum hangs on particular table; cannot be terminated - requires `kill -QUIT pid`
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #13974: temp_file_limit effects vacuum
Следующее
От: Brian Ghidinelli
Дата:
Сообщение: Re: BUG #13970: Vacuum hangs on particular table; cannot be terminated - requires `kill -QUIT pid`