Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0033344Retail ModulesWeb POSpublic2016-05-05 11:512016-07-05 19:10
Reportermalsasua 
Assigned Tojorge-garcia 
PriorityhighSeveritymajorReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionRR16Q2.1Fixed in Version 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customerOBPS
Support ticket41577
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0033344: [OFFLINE] cash management: error in data import entry window by dead lock
DescriptionIn some cases, when a cash management is being synced at the simultaneously that a receipt (OrderLoader), the cash management is not processed, and it is stored in "data import entry" with the error:
ERROR org.openbravo.retail.posterminal.importprocess.CashManagementImportEntryProcessor$CashManagementRunnable - id to load is required for loading
java.lang.IllegalArgumentException: id to load is required for loading

In database log, deadlock error is displayed:2016-05-04 16:49:22 CDT LOG: duration: 5252.992 ms execute S_166: COMMIT
ERROR: deadlock detected
DETAIL: Process 15228 waits for ShareLock on transaction 154569791; blocked by process 16429.
        Process 16429 waits for ExclusiveLock on tuple (40,4) of relation 208150 of database 202823; blocked by process 15228.
        Process 15228: update FIN_Financial_Account set Updated=$1, Currentbalance=$2 where Fin_Financial_Account_ID=$3
        Process 16429: update FIN_Financial_Account set Updated=$1, Currentbalance=$2 where Fin_Financial_Account_ID=$3
Steps To Reproduceit is reproducible sometimes.

in WEBPOS:
. do login
. go offline
. create receipt1, pay it with cash
. create receipt2, pay it with cash
. create receipt3, pay it with cash
. create receipt4, pay it with cash
. create cashmgm1
. create cashmgm2
. create cashmgm3
. create cashmgm4
. go online

in backoffice
. go to data import entry window
Proposed Solutionall cash management should be processed before to process the receipts (similar to cashup)
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0032872 closed jorge-garcia [OFFLINE] cash management: error in data import entry window by dead lock 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2016-06-23 17:37marvintmTypedefect => backport
2016-06-23 17:37marvintmTarget Version => RR16Q2.1
2016-07-05 10:10migueldejuanaNote Added: 0088194
2016-07-05 10:10migueldejuanaStatusscheduled => resolved
2016-07-05 10:10migueldejuanaResolutionopen => fixed
2016-07-05 19:10marvintmReview Assigned Tomigueldejuana => marvintm
2016-07-05 19:10marvintmStatusresolved => closed

Notes
(0088194)
migueldejuana   
2016-07-05 10:10   
Repository: retail/backports/3.0RR16Q2.1/org.openbravo.retail.posterminal
Changeset: dd442a8ef009f204e60d19ac916b0e86e31864b8
Author: Jorge Garcia <jorge.garcia <at> openbravo.com>
Date: Thu May 12 16:37:54 2016 +0200
URL: http://code.openbravo.com/retail/backports/3.0RR16Q2.1/org.openbravo.retail.posterminal/rev/dd442a8ef009f204e60d19ac916b0e86e31864b8 [^] [^]

Fixed issue 32872: cash management: error in data import entry window by
dead lock

The solution here is to check if there is an order or a transaction beeing
processed in the Import Entry Processor to avoid transaction colitions in the
database.

---
M src/org/openbravo/retail/posterminal/importprocess/CashManagementImportEntryProcessor.java