Article ID: 118828, created on Nov 23, 2013, last review on May 4, 2014

  • Applies to:
  • Odin Business Automation Standard 4.x

Symptoms

Payment transaction related to a completed order has status "Error". The following error is shown in DEBUG PBA-S log (/var/log/hspc/hspc.log):

Error-TEXT: 21:58] [FATAL] [11546] [HSPC::Exc::Mysql::new] DBD::mysql::st execute failed: Deadlock found when trying to get lock; try restarting transaction at /usr/lib/perl5/site_perl/5.8.8/HSPC/WebDB.pm line 235.
INSERT INTO ar_doc_det (rate,count,period,tran_type,ar_doc_id,ref_id,gross_amount,ext_info,amount,taxfree_amount,discount,subscr_id,comment_storable,taxfree_gross_amount,quantity,comment,taxfree_rate,multiplier) VALUES (...skipping...)

Resolution

The problem will be fixed in future PBA-S update that will be released after 5.0. Here is bug id:

PBAS-22540 - bill_accounts failed: Deadlock found when trying to get lock

Search Words

INSERT INTO ar_doc_det

Deadlock found when trying to get lock

caea8340e2d186a540518d08602aa065 400e18f6ede9f8be5575a475d2d6b0a6 70a5401e8b9354cd1d64d0346f2c4a3e

Email subscription for changes to this article
Save as PDF