Subject | Deadlock and wait |
---|---|
Author | Marcos Vinicius Dufloth |
Post date | 2001-07-26T14:41:48Z |
Please, could somebody help me with this?
I start an transaction this way (script running at isql):
set transaction wait isolation level read committed no record_version;
insert ...
insert ...
commit;
When running two process or more, I get some few errors:
Statement failed, SQLCODE = -913
deadlock
-update conflicts with concurrent update
Of course that these inserts are (via triggers) updating same records sometimes, but, if I using WAIT, why this error still generates? Lock manager don't would keep waiting? I missing something?
TIA.
Dufloth.
[Non-text portions of this message have been removed]
I start an transaction this way (script running at isql):
set transaction wait isolation level read committed no record_version;
insert ...
insert ...
commit;
When running two process or more, I get some few errors:
Statement failed, SQLCODE = -913
deadlock
-update conflicts with concurrent update
Of course that these inserts are (via triggers) updating same records sometimes, but, if I using WAIT, why this error still generates? Lock manager don't would keep waiting? I missing something?
TIA.
Dufloth.
[Non-text portions of this message have been removed]