Article ID: 123444, created on Nov 6, 2014, last review on Nov 6, 2014

  • Applies to:
  • Business Automation 5.5

Symptoms

While executing SetDefaultPaymentMethod_API xmlrpc call, the error comes:

ODBC code #40P01: ERROR: deadlock detected
Process 4319 waits for ShareLock on transaction 16805763; blocked by process 4502.
Process 4502 waits for ShareLock on transaction 16805759; blocked by process 4319.;
Error while executing the query

Cause

  1. Order is placed with PlaceOrderAndAuthorize_API.
  2. Payment is created for order using Payment Method mentioned in API.
  3. OrderStatusChange starts for Payment order.
  4. SetDefaultPaymentMethod_API is executed to make the same payment method default for customer.

APIs are sent with several seconds interval and OrderStatusChange is executed simultaneously with SetDefaultPaymentMethod_API. As a result deadlock occurs.

Resolution

The issue is fixed in PBA-E 5.5.6. Please upgrade to the latest vesion of PBA-E.

198398b282069eaf2d94a6af87dcb3ff caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 801221f8cd76fba7300d1e6817c8e08b 92711db0799e8aefe8e51f12dace0496

Email subscription for changes to this article
Save as PDF