Re: ERROR: could not serialize access due to concurrent update - Mailing list pgsql-admin

From Scott Ribe
Subject Re: ERROR: could not serialize access due to concurrent update
Date
Msg-id 474BDC88-BFEA-4D62-9D43-E0E7ABA1A13A@elevated-dev.com
Whole thread Raw
In response to Re: ERROR: could not serialize access due to concurrent update  (ROHIT SACHDEVA <sachdeva.rohit648@gmail.com>)
List pgsql-admin
> On May 16, 2023, at 11:24 AM, ROHIT SACHDEVA <sachdeva.rohit648@gmail.com> wrote:
>
> But due to this error our transaction is aborted and application team are getting these errors in their logs.
>
> How can I figure this out?
> Can there be work around for not getting this error.

As suggested previously, repeat the query.

It would be good, of course, to reduce the frequency of the errors by figuring out what is conflicting--are the queries
generallytaking too long compared to their frequency? But repeating a query when a lock conflict blocks it would still
bethe ultimate fallback, and is pretty standard practice. 




pgsql-admin by date:

Previous
From: ROHIT SACHDEVA
Date:
Subject: Re: ERROR: could not serialize access due to concurrent update
Next
From: Wolfgang Wilhelm
Date:
Subject: Re: Options for more aggressive space reclamation in vacuuming?