From: pavan95 <pavan.postgresdba@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Too many serialization errors in production
Date: Tue, 16 Apr 2019 23:09:57 -0700 (MST)
Message-ID: <1555481397393-0.post@n3.nabble.com> (raw)
Hi Community,
We are facing the error "*could not serialize due to concurrent update*" too
many times in our production server.
The errors are occurring due to the "Repeatable Read" isolation level. I
know that the database default_transaction_isolation is "Read Committed"
where we don't get these errors.
But when I monitored the queries the application(ODOO) user is issuing "SET
default_transaction_isolation to Repeatable Read". So is the cause of these
errors. I have explored on the ODOO application side where in which I lost
somewhere but found to know that these errors are common for ODOO.
In one of the ODOO application files named "sql_db.py" the below code I have
found where I understood the isolation level was set to "Repeatable Read".
My concern here is if I change this isolation level to "Read Committed" will
this suffice to stop this error occurrence?
Else my another approach is how to stop the application user from executing
session level command "SET default_transaction_isolation to Repeatable Read"
?
Could you please suggest me how to stop any user from changing the
default_transaction_isolation in PostgreSQL?
Looking forward to hear from you.
Regards,
Pavan,
9841380956
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: pavan.postgresdba@gmail.com
Subject: Re: Too many serialization errors in production
In-Reply-To: <1555481397393-0.post@n3.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox