Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0008607Openbravo ERPA. Platformpublic2009-04-16 19:012011-09-28 12:46
lowminorhave not tried
0008607: Delete client process does use and modify a table at the same time leading to error message in postgres logfile
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
- Use delete client in 2.50 (i.e. in the community appliance)
- Check postgres logfile afterwards for errors

No tags attached.
related to defect 00176413.0MP4 closed marvintm Delete Client process does not work (this issue also groups other tickets related to the Delete Client process) 
Issue History
2009-04-16 19:01shuehnerNew Issue
2009-04-16 19:01shuehnerAssigned To => rafaroda
2009-04-16 19:01shuehnerRegression testing => No
2009-04-23 12:41psarobeAssigned Torafaroda => alostale
2009-04-23 12:41psarobePrioritynormal => low
2009-04-23 12:41psarobeStatusnew => scheduled
2011-06-14 16:56dmitry_mezentsevRelationship addedrelated to 0017641
2011-09-28 12:46marvintmNote Added: 0041342
2011-09-28 12:46marvintmStatusscheduled => resolved
2011-09-28 12:46marvintmFixed in SCM revision => a18a9f23fc35
2011-09-28 12:46marvintmResolutionopen => fixed
2011-09-28 12:46marvintmStatusresolved => closed

2011-09-28 12:46   
Fixed by the recent Delete client refactor.