> Whole story here :
> 
> https://plus.google.com/105626236962310493174/posts/3UZB71NjUhA
> 
> Copy of message
> - - - - - - - -  - - - - - - -  -
> Is there a tool (or way) to debug database step by step.
> 
> Now we have weird situation where delete from one database fails, on
> foreign key error, which sounds like it would be trivial thing, but seems
> so far it is not.
> 
> I was just thinking that if it would be our application code I would be
> able to debug through all of the related code and see if there is the
> culprit or not.
> 
> We suspect it has somethign to do with specific data on the rows. because
> some of them delete perfectly fine. This happens in this one database only.
> I've done backup restore for it, I ran gfix stuff on it. I even pumped the
> data in empty DB.
> 
> it should be problem of database structure (trickers and such), data or the
> Firebird. and most likely it problem of first two.
> 
> I was just thinking that is there an tool I could see step by step all the
> operations in the DB before the foreigh key error is raised. So I could
> step by step see the order the trickers and so fires and what they do.
> 
> Or if someone at Firebird project could check if it is indeed the Firebird
> bug. I think we could send the DB, if it he/she keeps it safe and keeps it
> secret :) 

If you re-create the FK constraint - which re-creates an index behind the scene 
- solves the problem, then some sort of data/index corruption might be an 
explanation.


Thomas

------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to