Openbravo Issue Tracking System - Retail Modules | ||||||||||||
| View Issue Details | ||||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |||||||
| 0032872 | Retail Modules | Web POS | public | 2016-05-05 11:51 | 2016-07-05 10:10 | |||||||
| Reporter | malsasua | |||||||||||
| Assigned To | jorge-garcia | |||||||||||
| Priority | high | Severity | major | Reproducibility | sometimes | |||||||
| Status | closed | Resolution | fixed | |||||||||
| Platform | OS | 5 | OS Version | |||||||||
| Product Version | ||||||||||||
| Target Version | Fixed in Version | |||||||||||
| Merge Request Status | ||||||||||||
| Review Assigned To | migueldejuana | |||||||||||
| OBNetwork customer | ||||||||||||
| Support ticket | ||||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0032872: [OFFLINE] cash management: error in data import entry window by dead lock | |||||||||||
| Description | In 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 Reproduce | it 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 Solution | all cash management should be processed before to process the receipts (similar to cashup) | |||||||||||
| Additional Information | ||||||||||||
| Tags | No tags attached. | |||||||||||
| Relationships |
| |||||||||||
| Attached Files | ||||||||||||
| 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 | |||||||||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||