I have face so many times serialize access error. And I have also seen that it is due to query like SELECT .... FOR SHARE. we can also see into log.
TransactionRollbackError: could not serialize access due to concurrent update CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."res_users" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR SHARE OF x"
Why Odoo / OpenERP use SELECT .... FOR SHARE query to retrieve data ?
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 8/23/14, 2:37 AM|
|Seen: 4686 times|
|Last updated: 2/18/16, 7:22 PM|