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

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

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)

Notes
(0041342) marvintm (viewer) 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	OBNetwork customer	=> No
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