Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0033344
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Retail Modules] Web POSmajorsometimes2016-05-05 11:512016-07-05 19:10
ReportermalsasuaView Statuspublic 
Assigned Tojorge-garcia 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision1c8ec90a6990
ProjectionnoneETAnoneTarget VersionRR16Q2.1
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomarvintm
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0033344: [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)
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
blocks defect 0032872 closedjorge-garcia [OFFLINE] cash management: error in data import entry window by dead lock 

-  Notes
(0088194)
migueldejuana (developer)
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

- Issue History
Date Modified Username Field Change
2016-06-23 17:37 marvintm Type defect => backport
2016-06-23 17:37 marvintm Target Version => RR16Q2.1
2016-07-05 10:10 migueldejuana Note Added: 0088194
2016-07-05 10:10 migueldejuana Status scheduled => resolved
2016-07-05 10:10 migueldejuana Resolution open => fixed
2016-07-05 19:10 marvintm Review Assigned To migueldejuana => marvintm
2016-07-05 19:10 marvintm Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker