Re: Too many serialization errors in production

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Too many serialization errors in production
Дата
Msg-id 20190425174738.GA31344@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: Too many serialization errors in production  (pavan95 <pavan.postgresdba@gmail.com>)
Ответы Re: Too many serialization errors in production  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-admin
Hello

On 2019-Apr-22, pavan95 wrote:

> Do you mean this to be a bug?  

A bug fixed two years ago, yeah.

> My question is in my error log I'm getting query text for that corresponding
> "could not serialize access due to concurrent update" error failures. But
> can I get the other transaction which committed and which is responsible for
> this above serialization update? 

You probably *can*, by ensuring that all transactions have sufficient
details in the log; you may be able to link the entries by PID or XID.
Not sure how easy that is.

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



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

Предыдущее
От: Alvaro Aguayo Garcia-Rada
Дата:
Сообщение: Re: BDR
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Too many serialization errors in production