Subject Re: [ib-support] lock on table
Author Ann W. Harrison
At 09:13 AM 8/29/2002 -0700, Rand Monroe wrote:

>Yesterday we were posting some records from one table to another and one
>record had incorrect data in a primary field and it created a table dead
>lock on dataset. How do you clear this lock. This database is accessed by 50
>users, so we waited until after hours to delete the .lck file in the
>firebird directory, but we couldn't delete it. We had to reboot the server
>in order to clear it out. Any suggestions on another way to do this.

I saw your message yesterday and did not answer because it confused me.
It still does. Firebird/InterBase automatically detect and report deadlocks,
so it's unlikely that the deadlock is at the database level. What exactly
do you mean by "a table deadlock on dataset"? What error - or failure - are
you getting?


We have answers.