We constantly see this error in our logs.
And we are always having to cancel off double bills and making sure eveything is really on there.
I'm not too familiar with code, but is it saying that its the Odoo POS addon thats causing a problem - isn't that made by Odoo itself?
What can we do here? We have just started using Odoo, but this is causing us some major headaches!
2024-06-14 13:13:19,751 10 ERROR hooverdevelopments-triplebrew-live-13467950 odoo.sql_db: bad query: DELETE FROM "pos_order_line" WHERE id IN (54868, 54869, 54870, 54871, 54872, 54873)
ERROR: could not serialize access due to concurrent delete
2024-06-14 13:13:19,752 10 ERROR hooverdevelopments-triplebrew-live-13467950 odoo.sql_db: bad query: DELETE FROM "pos_order_line" WHERE id IN (54868, 54869, 54870, 54871, 54872, 54873)
ERROR: could not serialize access due to concurrent delete
2024-06-14 13:13:19,752 10 ERROR hooverdevelopments-triplebrew-live-13467950 odoo.addons.point_of_sale.models.pos_order: An error occurred when processing the PoS order Order 00057-001-0003
Traceback (most recent call last):
File "/home/odoo/src/odoo/addons/point_of_sale/models/pos_order.py", line 971, in create_from_ui
order_ids.append(self._process_order(order, draft, existing_draft_order))
File "/home/odoo/src/odoo/addons/point_of_sale/models/pos_order.py", line 149, in _process_order
pos_order.lines.unlink()
File "/home/odoo/src/odoo/odoo/models.py", line 4225, in unlink
cr.execute(SQL(
File "/home/odoo/src/odoo/odoo/sql_db.py", line 332, in execute
res = self._obj.execute(query, params)
psycopg2.errors.SerializationFailure: could not serialize access due to concurrent delete
2024-06-14 13:13:19,752 10 ERROR hooverdevelopments-triplebrew-live-13467950 odoo.addons.point_of_sale.models.pos_order: An error occurred when processing the PoS order Order 00057-001-0003
Traceback (most recent call last):
File "/home/odoo/src/odoo/addons/point_of_sale/models/pos_order.py", line 971, in create_from_ui
order_ids.append(self._process_order(order, draft, existing_draft_order))
File "/home/odoo/src/odoo/addons/point_of_sale/models/pos_order.py", line 149, in _process_order
pos_order.lines.unlink()
File "/home/odoo/src/odoo/odoo/models.py", line 4225, in unlink
cr.execute(SQL(
File "/home/odoo/src/odoo/odoo/sql_db.py", line 332, in execute
res = self._obj.execute(query, params)
psycopg2.errors.SerializationFailure: could not serialize access due to concurrent delete
