Re: Too many serialization errors in production

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: pavan95 <pavan(dot)postgresdba(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Too many serialization errors in production
Date: 2019-04-25 17:47:38
Message-ID: 20190425174738.GA31344@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2019-04-25 19:23:19 Re: Too many serialization errors in production
Previous Message Alvaro Aguayo Garcia-Rada 2019-04-25 15:16:35 Re: BDR