Subject | dead lock |
---|---|
Author | Rand Monroe |
Post date | 2002-08-28T16:52:18Z |
Hi,
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.
Thank you,
Randy
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.
Thank you,
Randy