Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||||
| ID | ||||||||||||
| 0029740 | ||||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||||||
| defect | [Retail Modules] Web POS | minor | have not tried | 2015-04-29 18:45 | 2015-04-29 18:45 | |||||||
| Reporter | plujan | View Status | public | |||||||||
| Assigned To | Retail | |||||||||||
| Priority | normal | Resolution | open | Fixed in Version | ||||||||
| Status | new | Fix in branch | Fixed in SCM revision | |||||||||
| Projection | none | ETA | none | Target Version | ||||||||
| OS | Any | Database | Any | Java version | ||||||||
| OS Version | Database version | Ant version | ||||||||||
| Product Version | main | SCM revision | ||||||||||
| Review Assigned To | ||||||||||||
| 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. | |||||||||||
| Tags | No tags attached. | |||||||||||
| Attached Files | ||||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |