note
westy032001
Thanks for the reply.
<p>If I understand you correctly, isnt there still a potential for a race condition ? </p>
If the database goes down and all 300 procs get a db error.
<p>process 123 open file and places a shared lock</p>
<p>process 321 opens file and places a shared lock</p>
<p>process 123 decides it is going to modify the file and so waits for 123 to unlock then places an exclusive lock modifies file and closes</p>
<p>process 321 decides it is going to modify the file and so places an exclusive lock modifies file and closes.</p>
<p>If both are changing the file as a result of the same error (i.e database is down) you will get 2 of the same error codes recorded. and 2 emails sent to admins . </p>
thanks.
862415
862427