congestion on series-14 lock (LCK_backup_alloc) when fdb file is locked by
nbackup
----------------------------------------------------------------------------------
Key: CORE-3496
URL: http://tracker.firebirdsql.org/browse/CORE-3496
Project: Firebird Core
Issue Type: Improvement
Affects Versions: 2.5.1
Environment: classic firebird build 26275 on sles 11 (two quad-core
cpus)
Reporter: Paulius Pazera
Priority: Minor
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
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
vRanger cuts backup time in half-while increasing security.
With the market-leading solution for virtual backup and recovery,
you get blazing-fast, flexible, and affordable data protection.
Download your free trial now.
http://p.sf.net/sfu/quest-d2dcopy1
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
