Re: BUG #13657: Some kind of undetected deadlock between query and "startup process" on replica.

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: BUG #13657: Some kind of undetected deadlock between query and "startup process" on replica.
Дата
Msg-id CAMkU=1yykrRo71Ldf5sKg2eQUJ+m_+WHGnvn_8i5oRO1V9X9mg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #13657: Some kind of undetected deadlock between query and "startup process" on replica.  (Michael Paquier <michael.paquier@gmail.com>)
Ответы Re: BUG #13657: Some kind of undetected deadlock between query and "startup process" on replica.  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-bugs
On Sat, Oct 24, 2015 at 4:08 AM, Michael Paquier
<michael.paquier@gmail.com> wrote:
> On Sat, Oct 24, 2015 at 4:16 PM, Maxim Boguk wrote:

>> I suppose deadlock had been happened when replay process replaying
>> truncation to zero pages after vacuum on the master db (but it's mostly
>> theory with no good evidence).
>
> By what was AccessExclusiveLock created on master? Did you run
> TRUNCATE on those two relations from time to time?

AccessExclusiveLock is automatically taken by vacuum when it thinks it
can truncate pages off the end of the relation.

Cheers,

Jeff

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: BUG #13708: strange behaviour instead of syntax error
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: BUG #13708: strange behaviour instead of syntax error