Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0008607 | Openbravo ERP | A. Platform | public | 2009-04-16 19:01 | 2011-09-28 12:46 |
|
| Reporter | shuehner | |
| Assigned To | alostale | |
| Priority | low | Severity | minor | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | 2.50 | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | |
| OBNetwork customer | |
| Web browser | |
| Modules | Core |
| Support ticket | |
| Regression level | |
| Regression date | |
| Regression introduced in release | |
| Regression introduced by commit | |
| Triggers an Emergency Pack | No |
|
| Summary | 0008607: Delete client process does use and modify a table at the same time leading to error message in postgres logfile |
| Description | The delete client process does disable triggers/constraint before deleting the clients' data and enable triggers/constraints afterwards.
The sql-command needed to execute this are recorded in a table called ad_script_sql and this table needs to be excluded from the disable/enable code as this leads to at least the following error logged:
Script errors: cannot ALTER TABLE "ad_script_sql" because it is being used by active queries in this session |
| Steps To Reproduce | - Use delete client in 2.50 (i.e. in the community appliance)
- Check postgres logfile afterwards for errors
|
| Proposed Solution | |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | | related to | defect | 0017641 | 3.0MP4 | closed | marvintm | Delete Client process does not work (this issue also groups other tickets related to the Delete Client process) |
|
| Attached Files | |
|
| Issue History |
| Date Modified | Username | Field | Change |
| 2009-04-16 19:01 | shuehner | New Issue | |
| 2009-04-16 19:01 | shuehner | Assigned To | => rafaroda |
| 2009-04-16 19:01 | shuehner | Regression testing | => No |
| 2009-04-23 12:41 | psarobe | Assigned To | rafaroda => alostale |
| 2009-04-23 12:41 | psarobe | Priority | normal => low |
| 2009-04-23 12:41 | psarobe | Status | new => scheduled |
| 2011-06-14 16:56 | dmitry_mezentsev | Relationship added | related to 0017641 |
| 2011-09-28 12:46 | marvintm | Note Added: 0041342 | |
| 2011-09-28 12:46 | marvintm | Status | scheduled => resolved |
| 2011-09-28 12:46 | marvintm | Fixed in SCM revision | => a18a9f23fc35 |
| 2011-09-28 12:46 | marvintm | Resolution | open => fixed |
| 2011-09-28 12:46 | marvintm | Status | resolved => closed |