Subject | Deadlock errors (FirebirdSS-1.0.3.972) |
---|---|
Author | diwidwierenga |
Post date | 2005-09-08T11:38:51Z |
Hello
Every once in a while, I get an "deadlock deadlock Error Code: 16"
error on updating in the database. I have been fiddling around with
transaction options, but have not been able to eliminate this.
Unfortunately, we cannot move to FB1.5 since we are using Redhat 7.
OS: Redhat 7.3
Firebird: FirebirdSS-1.0.3.972
Compiler: Kylix 3
Components: JvUIB 2.0
Transaction options:
coptReadOnly : TTransParams = [tpWait,tpRead,tpReadCommitted,
tpRecVersion];
coptReadWrite : TTransParams = [tpWait,tpWrite,tpReadCommitted,
tpRecVersion];
Can anybody give me a clue where to start looking?
Thanks in advance.
Regards,
Diederik
Every once in a while, I get an "deadlock deadlock Error Code: 16"
error on updating in the database. I have been fiddling around with
transaction options, but have not been able to eliminate this.
Unfortunately, we cannot move to FB1.5 since we are using Redhat 7.
OS: Redhat 7.3
Firebird: FirebirdSS-1.0.3.972
Compiler: Kylix 3
Components: JvUIB 2.0
Transaction options:
coptReadOnly : TTransParams = [tpWait,tpRead,tpReadCommitted,
tpRecVersion];
coptReadWrite : TTransParams = [tpWait,tpWrite,tpReadCommitted,
tpRecVersion];
Can anybody give me a clue where to start looking?
Thanks in advance.
Regards,
Diederik