Loading Video...
Database locks in Odoo
Developer Community Talk
Địa điểm: Hall 7.C - 11:00, 08/11/2023 - 11:30, 08/11/2023 (Europe/Brussels) (30 phút)
Database locks in Odoo
Fayolle Alexandre
Odoo Solution Architect tại Camptocamp France SAS
Fayolle Alexandre
Odoo Solution Architect tại Camptocamp France SAS

Alexandre has been working with Odoo at Camptocamp since 2012 and OpenERP 6.1. He is a long time Odoo community contributor, and he is passionate about sharing knowledge.


Odoo is using the Repeatable Read isolation level of PostgreSQL, and this has some implications on how the server behaves and how you should write the code of your custom addons to avoid costly retries or completely blocking interactive usage of the Odoo instance because a of a long running scheduled action.

This talk targets experienced Odoo developers. We will start by explaining the differences between the PostgreSQL transaction isolation level used by Odoo (Repeatable Read) and the default isolation level used by PostgreSQL (Read Committed). We will then see how concurrent access errors are reported and dealt with by Odoo server. Finally we will dig into the topic of correctly locking in custom modules, using both implicit locks and explicit locking, and how to properly wait for a lock to be released or check for the existence of a lock on some rows. We will also see some SQL tricks enabling to skip locked rows in a transaction.

www.ProSuite.eu </a> </div> ">
ProSuite.eu
https://7d.com.kw/ </div> ">
Seventh Dimension
https://www.bsiedi.com/Odoo.htm </div> ">
BUSINESS SYSTEMS INTEGRATORS, INC.
https://www.ksolves.com/ </div> ">
Ksolves India
http://acsone.eu </div> ">
ACSONE
http://advicts.com/ </div> ">
Advicts
https://braintec.com/ </div> ">
braintec
https://www.camptocamp.com/odoo </div> ">
Camptocamp
Digisoolut
https://www.dynapps.eu/en </div> ">
DynApps
https://metrum.lu/ </div> ">
METRUM
http://www.nalios.be </div> ">
Nalios
https://www.odoo-bs.com/ </div> ">
OBS Solutions GmbH
https://perfect-tech.co/ </div> ">
Perfect-Tech
https://plementus.com/ </div> ">
Plementus
https://www.plennix.com/ </div> ">
Plennix Technologies
https://rapsodoo.com </div> ">
Rapsodoo
https://www.silverfin.com/ </div> ">
Silverfin
http://smart-ltd.co.uk/ </div> ">
Smart Information Technologies Ltd
https://www.sudokeys.com/ </div> ">
Sudokeys
https://oxp2023.tritomit.de/ </div> ">
Tritomit UG
https://www.twio.tech/ </div> ">
twio.tech AG
http://www.tds-int.com </div> ">
Talents Digital Services
https://www.bloopark.de/ </div> ">
bloopark systems GmbH & Co. KG
https://hibou.io/ </div> ">
Hibou Corp.
http://www.int-path.com </div> ">
INTEGRATED PATH المسار المتكامل
https://azka.tech </div> ">
Azkatech
https://www.accomodata.be/en_US </div> ">
Accomodata
https://www.doo.finance </div> ">
Doo Finance
https://wesolved.com/ </div> ">
WeSolved B.V.
http://www.dootix.com </div> ">
Dootix SA
https://www.biztechcs.com/ </div> ">
Biztech Consulting & Solution
https://agicap.com/ </div> ">
Agicap
http://www.baymain.com/ </div> ">
Baystream Corporation
https://binhex.es/ </div> ">
Binhex Systems Solutions S.L.
https://www.iwesabe.com </div> ">
GLOBAL CREATIVE CONCEPTS TECH CO LTD [ iWesabe ]
https://codestorm.it/ </div> ">
Codestorm Srl
https://www.codecpq.com</a> </div> ">
CodeCPQ
https://www.astasys.com </div> ">
Asta Systems Limited
http://www.zeusit.eu </div> ">
Zeus IT
https://www.droggol.com/ </div> ">
Droggol
http://www.synconics.com </div> ">
Synconics Technologies Pvt. Ltd.
Isabel Group
https://www.epson.eu/Colorworks </div> ">
Epson Deutschland GmbH
http://3rdwave.be </div> ">
3rdWave bv
https://www.serpentcs.com/ </div> ">
Serpent Consulting Services Pvt Ltd
https://www.centiloc.com/ </div> ">
Centiloc
https://cube48.de/ </div> ">
Cube 48
https://www.dstny.be </div> ">
Destiny NV
http://www.aktivsoftware.com </div> ">
Aktiv Software
https://www.arkeup.com/ </div> ">
ArkeUp
https://www.dphi.be/ </div> ">
DPHI
FALAK Turnkey Solutions
https://asasatas.com.sa/en/ </div> ">
ASASAT Advanced Systems
https://www.odoodevs.com/ </div> ">
Lytics
https://www.atharvasystem.com/ </div> ">
Atharva System
http://onlyoffice.com/ </div> ">
ONLYOFFICE
http://www.axxelia.com </div> ">
Axxelia
Ringover
https://www.bhc.be/ </div> ">
BHC
https://webkul.com/ </div> ">
WEBKUL SOFTWARE PVT LTD
https://www.bistasolutions.com/ </div> ">
Bista Solutions
https://bluezebra.io/ </div> ">
BlueZebra
https://zerynth.com/ </div> ">
Zerynth Spa
http://www.bop-alliance.com/ </div> ">
BOP Alliance
https://www.brainvire.com/ </div> ">
Brainvire Infotech Inc
https://www.cybrosys.com </div> ">
Cybrosys Techno Solution Pvt. Ltd.
https://www.dfakto.com/ </div> ">
Deployments Factory (dFakto)
https://www.ecoservice.de </div> ">
Ecoservice
http://www.eezee-it.com/ </div> ">
Eezee-it SA
https://www.emasphere.com/en/?utm_source=Odoo&amp;utm_medium=referral_paid&amp;utm_campaign=All_Leads_all-all_Limited_Odoo%20Experience_2309 </div> ">
EMAsphere
http://www.emiprotechnologies.com </div> ">
Emipro Technologies Pvt. Ltd.
https://www.eoris.fr/ </div> ">
EORIS
https://www.erpgap.com/ </div> ">
ERPGAP
https://www.forgeflow.com/ </div> ">
FORGEFLOW, S.L.
http://globalsolutions.sa </div> ">
Global Solutions
http://www.gravitai.com </div> ">
Gravitai Ltd
https://www.gumbys.be/ </div> ">
Gumbys
https://idealisconsulting.com/academy </div> ">
Idealis Academy
http://idealisconsulting.com/ </div> ">
Idealis Consulting
http://idealisconsulting.com/solutions </div> ">
Idealis Solutions
http://www.ife.de/ </div> ">
IFE GmbH
http://www.intero-technologies.de/ </div> ">
Intero Technologies GmbH
https://www.isabelgroup.eu/en/ </div> ">
Isabel Group
https://koleos.odoo.com/ </div> ">
KOLEOS
KPMG Tax, Legal and Accountancy
http://www.logicasoft.eu </div> ">
Logicasoft
https://muchconsulting.com/en/ </div> ">
much. Consulting
https://nanobytes.es/ </div> ">
Nanobytes
http://www.niboo.com </div> ">
Niboo
https://www.noviat.com/ </div> ">
Noviat
https://odoo-community.org/ </div> ">
Odoo Community Association (OCA)
http://www.odootec.com </div> ">
OdooTec
http://www.odootec.com </div> ">
OdooTec
https://www.open-net.ch/ </div> ">
Open Net Sàrl
https://www.o2btechnologies.com/ </div> ">
A Perfect Solution – O2b Technologies
https://www.ps-sa.net/en/ </div> ">
Pioneer Solutions
https://portcities.net/ </div> ">
Port Cities
https://www.qocinnovations.com/ </div> ">
QOC Innovations
Quick Services LTC
http://smac-solution.com </div> ">
Intelligent Experts Technology
https://sodexis.com/ </div> ">
Sodexis
http://squareflow.be/ </div> ">
Squareflow SA
https://www.surekhatech.com/ </div> ">
Surekha Technologies
https://targetintegration.com/ </div> ">
Target Integration
http://www.telenoc.org/ </div> ">
TeleNoc (هلكون لتقنية المعلومات)
guillaume.hoang@corock.be </div> ">
Corock
http://www.upward.sa/ </div> ">
Upward Technologies
https://ventor.tech/ </div> ">
VentorTech
https://www.zero.com.al/ </div> ">
Zero
https://www.zillopay.com </div> ">
Bluemax Pay
https://www.26house.com/ </div> ">
26HOUSE