Subject UPDATE or INSERT and Crash without Commit,and WAIT TRNX
Author zaherdirkey
this a serious problem with transaction

UPDATE "Table1"
SET "Field1"=5
WHERE "Field2"=1
then my app crashed without commit or rollback :-(
when another user do this with Wait transaction and NoRecordVersion
UPDATE "Table1"
SET "Field1"=6
WHERE "Field2"=1
it wait forever :-O
i know i can use nowait but i has deadlock, how to fix it without
restarting server
i try use gfix "mydb.fdb" -user sysdba -password ***** -commit all
but nothing happen

i use firebird 1.5rc3 delphi ibx