tx1: update table t ... where id = 1
tx2: update table t ... where id = 1
If tx2's is in WAIT mode, it will wait for end of tx1 forever and this wait can't be breaked nor using DELETE FROM MON$xxx, nor using fb_cancel_operation.
The improvement is to make lock manager able to break such endless waitings.
Description
Consider following example :
tx1: update table t ... where id = 1
tx2: update table t ... where id = 1
If tx2's is in WAIT mode, it will wait for end of tx1 forever and this wait can't be breaked nor using DELETE FROM MON$xxx, nor using fb_cancel_operation.
The improvement is to make lock manager able to break such endless waitings.
Improvement
Closed
Major
Ability to cancel waiting in lock manager
Open
