You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
load firebird sufficiently, e.g. 16 simultaneous long running statements (select, inserts, updates, events, SP creation and dropping in our case)
then lock fdb file using 'nbackup -L'
then do several lock prints (I used -c -a -w switches) and search for locks having many pending requests, or simply for series-14 lock
with 16 working threads I saw congestion in 2 out of 3 lock prints with13 & 14 pending requests:
Submitted by: Paulius Pazera (ppazera)
load firebird sufficiently, e.g. 16 simultaneous long running statements (select, inserts, updates, events, SP creation and dropping in our case)
then lock fdb file using 'nbackup -L'
then do several lock prints (I used -c -a -w switches) and search for locks having many pending requests, or simply for series-14 lock
with 16 working threads I saw congestion in 2 out of 3 lock prints with13 & 14 pending requests:
LOCK BLOCK 5059432
Series: 14, Parent: 537248, State: 3, size: 8 length: 0 data: 0
Key: , Flags: 0x00, Pending request count: 14
Hash que (5): forward: 813368, backward: 537760
Requests (15): forward: 2166136, backward: 1026072
Request 2166136, Owner: 951992, State: 3 (3), Flags: 0x01
Request 3244440, Owner: 540096, State: 0 (6), Flags: 0x02
Request 894264, Owner: 1019872, State: 0 (3), Flags: 0x02
Request 3636600, Owner: 974512, State: 0 (3), Flags: 0x02
Request 1230608, Owner: 1156912, State: 0 (3), Flags: 0x02
Request 2486776, Owner: 1088264, State: 0 (3), Flags: 0x02
Request 1242960, Owner: 1224024, State: 0 (3), Flags: 0x02
Request 2591544, Owner: 1111360, State: 0 (3), Flags: 0x02
Request 3879560, Owner: 884544, State: 0 (3), Flags: 0x02
Request 1132024, Owner: 997288, State: 0 (3), Flags: 0x02
Request 3407576, Owner: 1043032, State: 0 (3), Flags: 0x02
Request 2506872, Owner: 1133944, State: 0 (3), Flags: 0x02
Request 2896384, Owner: 1065488, State: 0 (3), Flags: 0x02
Request 2508280, Owner: 1203104, State: 0 (3), Flags: 0x02
Request 1026072, Owner: 1247056, State: 0 (3), Flags: 0x02
LOCK BLOCK 538392
Series: 14, Parent: 537248, State: 3, size: 0 length: 0 data: 0
Key: , Flags: 0x00, Pending request count: 13
Hash que (4): forward: 372, backward: 537880
Requests (14): forward: 2101640, backward: 1309136
Request 2101640, Owner: 950640, State: 3 (3), Flags: 0x01
Request 2201104, Owner: 1175072, State: 0 (6), Flags: 0x02
Request 2451936, Owner: 1085568, State: 0 (3), Flags: 0x02
Request 1826976, Owner: 1063432, State: 0 (3), Flags: 0x02
Request 2714720, Owner: 1018264, State: 0 (3), Flags: 0x02
Request 3315896, Owner: 1197528, State: 0 (3), Flags: 0x02
Request 2376464, Owner: 1040912, State: 0 (3), Flags: 0x02
Request 1461896, Owner: 995744, State: 0 (3), Flags: 0x02
Request 1809952, Owner: 871544, State: 0 (3), Flags: 0x02
Request 4692480, Owner: 1107832, State: 0 (3), Flags: 0x02
Request 3589880, Owner: 1152936, State: 0 (3), Flags: 0x02
Request 1585368, Owner: 1130416, State: 0 (3), Flags: 0x02
Request 1971680, Owner: 973224, State: 0 (3), Flags: 0x02
Request 1309136, Owner: 1242184, State: 0 (3), Flags: 0x02
The text was updated successfully, but these errors were encountered: