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

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

0032872: [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 ]
depends on backport 0033344RR16Q2.1 closedjorge-garcia [OFFLINE] cash management: error in data import entry window by dead lock 

-  Notes
(0086436)
hgbot (developer)
2016-05-13 08:48

 Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 1c8ec90a699006758e75c8361082d753f7df7583
Author: Jorge Garcia <jorge.garcia <at> openbravo.com>
Date: Thu May 12 16:37:54 2016 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/1c8ec90a699006758e75c8361082d753f7df7583 [^]

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
---
(0086501)
migueldejuana (developer)
2016-05-17 15:44

 Reviewed
(0088193)
hgbot (developer)
2016-07-05 10:09

 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-05-05 11:51 malsasua New Issue
2016-05-05 11:51 malsasua Assigned To => Retail
2016-05-05 11:51 malsasua Resolution time => 1465509600
2016-05-05 11:51 malsasua Triggers an Emergency Pack => No
2016-05-10 10:11 Orekaria Status new => acknowledged
2016-05-12 09:04 jorge-garcia Status acknowledged => scheduled
2016-05-12 09:04 jorge-garcia Assigned To Retail => jorge-garcia
2016-05-12 16:04 jorge-garcia Summary cash management: error in data import entry window by dead lock => [OFFLINE] cash management: error in data import entry window by dead lock
2016-05-13 08:48 hgbot Checkin
2016-05-13 08:48 hgbot Note Added: 0086436
2016-05-13 08:48 hgbot Status scheduled => resolved
2016-05-13 08:48 hgbot Resolution open => fixed
2016-05-13 08:48 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/1c8ec90a699006758e75c8361082d753f7df7583 [^]
2016-05-17 15:44 migueldejuana Review Assigned To => migueldejuana
2016-05-17 15:44 migueldejuana Note Added: 0086501
2016-05-17 15:44 migueldejuana Status resolved => closed
2016-06-23 17:37 marvintm Status closed => new
2016-06-23 17:37 marvintm Resolution fixed => open
2016-06-23 17:37 marvintm Status new => scheduled
2016-06-23 17:38 marvintm Status scheduled => resolved
2016-06-23 17:38 marvintm Resolution open => fixed
2016-06-23 17:38 marvintm Status resolved => closed
2016-07-05 10:09 hgbot Checkin
2016-07-05 10:09 hgbot Note Added: 0088193
2016-07-05 10:09 hgbot Status closed => resolved
2016-07-05 10:09 hgbot Fixed in SCM revision http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/1c8ec90a699006758e75c8361082d753f7df7583 [^] => http://code.openbravo.com/retail/backports/3.0RR16Q2.1/org.openbravo.retail.posterminal/rev/dd442a8ef009f204e60d19ac916b0e86e31864b8 [^]
2016-07-05 10:10 migueldejuana Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker