Reason for change

Several ingest scripts have been running in parallel when large deliveries have been received.
When this happens the average time of execution goes from a few minutes to over one/two hours.
The other side effect seems to be that the whole database grinds to a halt, slowing down everything else.

A fix was added to lock the tables preventing ingestions to run in parallel.

They will be now serialized and, given that they run only a few minutes, the impact on data processing should be minimal.

A better fix could be added in the future if needed.

Test Procedure

This version has been tested on the DEV server.

Rollback procedure

Version 1.0.1 can be easily put back in place.

CCB Jira

SSC-86@JIRA

Details

Stanford Linear Accelerator Center (3 issues)
T	Key	Summary	Assignee	Reporter	Pr	Status	Res	Created	Updated	Due
	GDM-111	Add Table locking to prevent ingest scripts to run in parallel.	Massimiliano Turri	Massimiliano Turri		Resolved	FIXED	Jul 03, 2008	Jul 03, 2008
	GDM-110	LiveTimeFraction quantity is added rather than averaged	Massimiliano Turri	Massimiliano Turri		Resolved	FIXED	Jun 30, 2008	Jun 30, 2008
	GDM-108	"save" button for multi-plots pages	Massimiliano Turri	Maria Elena Monzani		Resolved	WON'T FIX	Jun 29, 2008	Jun 30, 2008