Openbravo Issue Tracking System - Retail Modules | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0029740 | Retail Modules | Web POS | public | 2015-04-29 18:45 | 2015-04-29 18:45 |
| Reporter | plujan | ||||
| Assigned To | Retail | ||||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | new | Resolution | open | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | main | ||||
| Target Version | Fixed in Version | ||||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | |||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0029740: Open connections may cause a deadlock while updating webPOS | ||||
| Description | I tried to update Q2 from RC2 to RC3. I did not realise about some terminal windows opened because of recent tasks. The update via GUI did not finish since the recreation of OBPOS_ERRORS table could not get an exclusive lock. The problem is that no information has been shown during the process. Not even the process failed, it just kept trying to recreate the table. | ||||
| Steps To Reproduce | Preconditions: The precondition is not quite clear but it is related to some recent work being done in a terminal window. Get a new version of the webPOS module and update it using the Module Management Console. Note that the process never ends. Check the log and you will find something like: 2015-04-29 14:57:40 UTC LOG: process 17968 still waiting for AccessExclusiveLock on relation 41153 of database 40921 after 1000.257 ms 2015-04-29 14:57:40 UTC STATEMENT: -- END ALTER TABLE OBPOS_ERRORS DROP CONSTRAINT OBPOS_ERRORS_CLIENT | ||||
| Proposed Solution | If an existing session can create such a conflict, some previous validation should exist. The user should get some feedback about the problem and be able to fix it without causing any harm in the system. | ||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2015-04-29 18:45 | plujan | New Issue | |||
| 2015-04-29 18:45 | plujan | Assigned To | => Retail | ||
| 2015-04-29 18:45 | plujan | Triggers an Emergency Pack | => No | ||
| There are no notes attached to this issue. |