escalatelock.out

derby database source code.good for you.

APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(28,6)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(28,7)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(3,6)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(3,7)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(3,8)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(31,6)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(31,7)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(31,8)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(34,7)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(34,8)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(35,6)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(4,6)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(4,7)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(4,8)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(5,6)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(7,8)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(8,6)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(8,7)     |GRANT|ACTIVE  
ij> delete from aborttest where keycol >= 3 ;
70 rows inserted/updated/deleted
ij> -- check to make sure we escalated;
select * from lock_table order by tabname, type desc, mode, cnt, lockname;
USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
---------------------------------------------------------------------------
APP     |UserTran|TABLE   |2   |IX  |ABORTTEST   |Tablelock |GRANT|ACTIVE  
APP     |UserTran|TABLE   |3   |X   |ABORTTEST   |Tablelock |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |ABORTTEST   |(1,3)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(1,7)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(1,8)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(1,9)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(11,6)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(11,7)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(11,8)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(14,7)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(14,8)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(15,6)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(17,8)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(18,6)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(18,7)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(2,6)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(2,7)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(2,8)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(21,6)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(21,7)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(21,8)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(24,7)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(24,8)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(25,6)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(27,8)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(28,6)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(28,7)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(3,6)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(3,7)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(3,8)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(31,6)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(31,7)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(31,8)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(34,7)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(34,8)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(35,6)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(4,6)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(4,7)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(4,8)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(5,6)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(7,8)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(8,6)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(8,7)     |GRANT|ACTIVE  
ij> -- now cause space reclamation on the leftmost leaf
insert into aborttest values (-1, '-1'), (-1, '-1');
2 rows inserted/updated/deleted
ij> -- check to make sure we escalated;
select * from lock_table order by tabname, type desc, mode, cnt, lockname;
USERNAME|TRANTYPE|TYPE    |CNT |MODE|TABNAME     |LOCKNAME  |STATE|STATUS  
---------------------------------------------------------------------------
APP     |UserTran|TABLE   |4   |IX  |ABORTTEST   |Tablelock |GRANT|ACTIVE  
APP     |UserTran|TABLE   |3   |X   |ABORTTEST   |Tablelock |GRANT|ACTIVE  
APP     |UserTran|ROW     |1   |X   |ABORTTEST   |(1,3)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(1,7)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(1,8)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(1,9)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(11,6)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(11,7)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(11,8)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(14,7)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(14,8)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(15,6)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(17,8)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(18,6)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(18,7)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(2,6)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(2,7)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(2,8)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(21,6)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(21,7)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(21,8)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(24,7)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(24,8)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(25,6)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(27,8)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(28,6)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(28,7)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(3,6)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(3,7)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(3,8)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(31,6)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(31,7)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(31,8)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(34,7)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(34,8)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(35,6)    |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(4,6)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(4,7)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(4,8)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(5,6)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(7,8)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(8,6)     |GRANT|ACTIVE  
APP     |UserTran|ROW     |2   |X   |ABORTTEST   |(8,7)     |GRANT|ACTIVE  
ij> -- Before fix to bug 4328/4330 the following rollback would cause a recovery
-- error which would shut down the server, and cause recovery to always fail.
-- The problem was that the lock escalation bug would remove locks on 
-- uncommitted deleted rows, and then the above insert would try and succeed
-- at purging rows that it should not have been able.  When undo comes along to
-- undo the delete it can't find the row because it has been purged by a
-- committed nested internal transaction.
rollback;
ij> select count(*) from aborttest;
1          
-----------
110        
ij> select keycol from aborttest;
KEYCOL     
-----------
0          
0          
0          
0          
0          
0          
0          
0          
0          
0          
0          
1          
2          
3          
4          
5          
6          
7          
8          
9          
0          
1          
2          
3          
4          
5          
6          
7          
8          
9          
0          
1          
2          
3          
4          
5          
6          
7          
8          
9          
0          
1          
2          
3          
4          
5          
6          
7          
8          
9          
0          
1          
2          
3          
4          
5          
6          
7          
8          
9          
0          
1          
2          
3          
4          
5          
6          
7          
8          
9          
0          
1          
2          
3          
4          
5          
6          
7          
8          
9          
0          
1          
2          
3          
4          
5          
6          
7          
8          
9          
0          
1          
2          
3          
4          
5          
6          
7          
8          
9          
0          
1          
2          
3          
4          
5          
6          
7          
8          
9          
ij> commit;
ij> -- TEST 4 - (beetle 4764) make sure no lock timeout if escalate is blocked by 
-- another user.
-- 
connect 'wombat' as block_escalate_connection;
ij(BLOCK_ESCALATE_CONNECTION)> set connection block_escalate_connection;
ij(BLOCK_ESCALATE_CONNECTION)> autocommit off;
ij(BLOCK_ESCALATE_CONNECTION)> drop table foo;
0 rows inserted/updated/deleted
ij(BLOCK_ESCALATE_CONNECTION)> create table foo (a int, data char(10));
0 rows inserted/updated/deleted
ij(BLOCK_ESCALATE_CONNECTION)> commit;
ij(BLOCK_ESCALATE_CONNECTION)> insert into foo values (1, 'blocker');
1 row inserted/updated/deleted
ij(BLOCK_ESCALATE_CONNECTION)> connect 'wombat' as escalate_connection;
ij(ESCALATE_CONNECTION)> set connection escalate_connection;
ij(ESCALATE_CONNECTION)> autocommit off;
ij(ESCALATE_CONNECTION)> commit;
ij(ESCALATE_CONNECTION)> -- insert 100 rows which should try to escalate the lock but then fail, because