Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminorhave not tried2009-04-16 19:012011-09-28 12:46
ReportershuehnerView Statuspublic 
Assigned Toalostale 
PrioritylowResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisiona18a9f23fc35
ProjectionnoneETAnoneTarget Version
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase version8.3Ant version
Product Version2.50SCM revision 
Review Assigned To
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0008607: Delete client process does use and modify a table at the same time leading to error message in postgres logfile

DescriptionThe 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

TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00176413.0MP4 closedmarvintm Delete Client process does not work (this issue also groups other tickets related to the Delete Client process) 

-  Notes
marvintm (developer)
2011-09-28 12:46

Fixed by the recent Delete client refactor.

- 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

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker