Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

congestion on series-14 lock (LCK_backup_alloc) when fdb file is locked by nbackup [CORE3496] #3855

Open
firebird-automations opened this issue May 26, 2011 · 0 comments

Comments

@firebird-automations
Copy link
Collaborator

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant