Openbravo Issue Tracking System - Retail Modules | ||||||||||||
View Issue Details | ||||||||||||
ID | Project | Category | View Status | Date Submitted | Last Update | |||||||
0038759 | Retail Modules | Sessions | public | 2018-06-14 13:33 | 2019-06-18 15:41 | |||||||
Reporter | malsasua | |||||||||||
Assigned To | rqueralta | |||||||||||
Priority | high | Severity | major | Reproducibility | random | |||||||
Status | closed | Resolution | fixed | |||||||||
Platform | OS | 5 | OS Version | |||||||||
Product Version | ||||||||||||
Target Version | Fixed in Version | RR18Q3 | ||||||||||
Merge Request Status | ||||||||||||
Review Assigned To | marvintm | |||||||||||
OBNetwork customer | ||||||||||||
Support ticket | ||||||||||||
Regression level | ||||||||||||
Regression date | ||||||||||||
Regression introduced in release | ||||||||||||
Regression introduced by commit | ||||||||||||
Triggers an Emergency Pack | No | |||||||||||
Summary | 0038759: No Terminal is set in the session record in Data Import Entry window: It can generate DeadLock database error | |||||||||||
Description | When the till is opened, the record created in Data Import Entry with type of data Open till, is generated without terminal, and it can generate database locks | |||||||||||
Steps To Reproduce | [offline] . open till in POS with differences go online in Errors While Importing: ERROR: deadlock detected Detail: Process 5961 waits for ShareLock on transaction 298218968; blocked by process 347. Process 347 waits for ShareLock on transaction 298218967; blocked by process 5961. Hint: See server log for query details. Where: while locking tuple (11039,29) in relation "obpos_app_cashup" SQL statement "SELECT 1 FROM ONLY "public"."obpos_app_cashup" x WHERE "obpos_app_cashup_id"::pg_catalog.text OPERATOR(pg_catalog.=) $1::pg_catalog.text FOR KEY SHARE OF x" at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:338) at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:2534) at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216) at org.openbravo.dal.service.OBDal.flush(OBDal.java:260) at org.openbravo.retail.posterminal.UpdateCashup.getAndUpdateCashUp(UpdateCashup.java:165) at org.openbravo.retail.posterminal.ProcessCashMgmt.saveRecord(ProcessCashMgmt.java:58) at org.openbravo.mobile.core.process.DataSynchronizationProcess.saveRecord(DataSynchronizationProcess.java:196) at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:153) at org.openbravo.mobile.core.process.DataSynchronizationProcess.exec(DataSynchronizationProcess.java:85) at org.openbravo.mobile.core.process.MobileImportEntryProcessorRunnable.processEntry(MobileImportEntryProcessorRunnable.java:53) at org.openbravo.retail.posterminal.importprocess.CashManagementImportEntryProcessor$CashManagementRunnable.processEntry(CashManagementImportEntryProcessor.java:68) at org.openbravo.service.importprocess.ImportEntryProcessor$ImportEntryProcessRunnable.doRunCycle(ImportEntryProcessor.java:363) at org.openbravo.service.importprocess.ImportEntryProcessor$ImportEntryProcessRunnable.run(ImportEntryProcessor.java:285) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) | |||||||||||
Proposed Solution | ||||||||||||
Additional Information | ||||||||||||
Tags | No tags attached. | |||||||||||
Relationships |
| |||||||||||
Attached Files | ||||||||||||
Issue History | ||||||||||||
Date Modified | Username | Field | Change | |||||||||
2018-06-14 13:33 | malsasua | New Issue | ||||||||||
2018-06-14 13:33 | malsasua | Assigned To | => Retail | |||||||||
2018-06-14 13:33 | malsasua | Resolution time | => 1530914400 | |||||||||
2018-06-14 13:33 | malsasua | Triggers an Emergency Pack | => No | |||||||||
2018-06-15 20:40 | rqueralta | Assigned To | Retail => rqueralta | |||||||||
2018-06-15 20:40 | rqueralta | Status | new => scheduled | |||||||||
2018-06-21 15:12 | hgbot | Checkin | ||||||||||
2018-06-21 15:12 | hgbot | Note Added: 0105306 | ||||||||||
2018-06-21 15:12 | hgbot | Status | scheduled => resolved | |||||||||
2018-06-21 15:12 | hgbot | Resolution | open => fixed | |||||||||
2018-06-21 15:12 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/pmods/org.openbravo.retail.sessions/rev/889587a15d74f0ec4261ceec5a474e6375b51eb0 [^] | |||||||||
2018-06-22 00:34 | hgbot | Checkin | ||||||||||
2018-06-22 00:34 | hgbot | Note Added: 0105323 | ||||||||||
2018-06-22 11:02 | marvintm | Review Assigned To | => marvintm | |||||||||
2018-06-22 11:02 | marvintm | Status | resolved => closed | |||||||||
2018-06-22 11:02 | marvintm | Fixed in Version | => RR18Q3 | |||||||||
2018-07-02 16:11 | hgbot | Checkin | ||||||||||
2018-07-02 16:11 | hgbot | Note Added: 0105529 | ||||||||||
2019-06-18 12:29 | gorka_gil | Relationship added | related to 0041118 | |||||||||
2019-06-18 15:41 | hgbot | Checkin | ||||||||||
2019-06-18 15:41 | hgbot | Note Added: 0112864 |
Notes | |||||
|
|||||
|
|
||||
|
|||||
|
|
||||
|
|||||
|
|
||||
|
|||||
|
|