| Subject | UPDATE or INSERT and Crash without Commit,and WAIT TRNX |
|---|---|
| Author | zaherdirkey |
| Post date | 2003-07-03T00:07:06Z |
this a serious problem with transaction
Example
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
Example
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