Jump to content

MySQL Deadlock


Recommended Posts

Hey,

We are having some issues with a third party vendor's rest call that is causing a deadlock on prestashop.

 

 Deadlock found when trying to get lock; try restarting transaction. From OrderCore->setDeliveryNumber() Query was : UPDATE `ps_order_invoice` SET delivery_number =(SELECT new_number FROM (SELECT (MAX(`delivery_number`) + 1) AS new_number FROM `ps_order_invoice`) AS result) WHERE `id_order_invoice` =

 

Hoping someone could help us out on this one.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...