Magento 1.7 Payment Deadlock Issue – Troubleshooting Guide

There is quite big probability that your payment method is processing payment wrongly.

Magento Order Save Process is quite simple:

• Prepares all data that should be transfered from quote item to order item, including prices and product information, afterwards it doesn't invoke price retrieval.
• Invoke before order submit events checkout_type_onepage_save_order and sales_model_service_quote_submit_before
  • Mage_CatalogInventory_Model_Stock::registerProductsSale() is invoked at this event observer
• Start DB transaction
• Invoke $order->place() method that processes the payment by calling $paymentMethod->authorize(), $paymentMethod->capture() or $paymentMethod->initialize() depends on its logic.
• Invoke $order->save() method that saves processed order to DB tables sales_flat_order_*.
• Commit DB transaction (At this step DB releases lock on inventory table)

So as you see, it couldn't be possible, that payment method charges money before the inventory lock and read of product prices or product info.

It is only possible in case if payment method is implemented in such a way, that it performs loading of products itself with prices, after the API call for charging operation is performed.

Hope this will help you in debugging your issue.

As for reindexing, it should be safe, if you don't have this issue with payment method. Since read operation that depend on locks are performed before money gets charged.

I was unable to save/update payment gateway transaction id in my order while coming back from payment gateway after successful payment but was getting in return url controller action..

I have solved my problem by adding another method in payment model and save transaction id with respect to order id in db and get that in capture method of payment model....

As I was unable to create/get object manger and session data variable in my controller and was unable to get transaction id in capture function of payment module which is already extending \Magento\Payment\Model\Method\Cc because of use of curl.

Transaction id is coming on redirect url controller action and then we are coming after curl excution line of code where i was needed to save transaction id in the order and payment.

As I am using CURL method in my payment capture function for call payment gateway and passing order id and order detail to payment gateway with a return url. Payment gateway successfully coming back on the return url controller action. So I call my payment model new function captureNew and pass transaction detail as a argument. Then go in payment module captureNew function and save transaction id with order id in a database custom table and after the execution of captureNew function...

Then it return back in capture method under the curl execution line and there I get the transaction id by the order id from db and save in the order and payment object by below code

$payment->setParentTransactionId(null);
$payment->setTransactionId($order_transactionId)->setIsTransactionClosed(0);
$order->save();