Re: Phantom deletes

I would check the constraints. Probably the table you are talking about is a child table and the parent row may be getting deleted. If you have a 'DELETE CASCADE' set in the reference constraint, this will happen.

HTH,
CM

In article <6jq83h$971$1_at_nnrp1.dejanews.com>,   nbindal_at_my-dejanews.com wrote:
>
> Hi,
>
> This is another mysterious problem that we are facing in our application.
> There is a table which contains 300 rows (loaded up while setting the
> application). No one is supposed to delete or insert from this table.
(select
> and updates are done on it continously from multiple processes).
>
> However what we have observed is that, daily 1-4 rows get deleted. I want to
> know if there are other conditions in which the rows can get deleted - like
> locking, deadlocking etc (There are no user defined db trigger defined in
this
> application)
>
> To debug this problem we added a trigger (BEFORE DELETE) on this table, to
log
> into another dummy table the row that is getting deleted. Is there any way
to
> put in this trigger the processid of the client program which is deleting -
> that way we identify the source of problem. Also if anyone has other ideas
of
> finding the culprit, it would be very helpful.
>
> Thanks
> Nitin
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed May 20 1998 - 10:18:28 CDT