Hi Sean,
Thank you for your suggestion. I know that our configuration is not optimal and
I will change this. But my understanding was, that this is only a performance
problem and not something that can cause Firebird to hang. Or is this a known
behavior?
Cheers
Freddy
Am 04.05.2017 10:07 nachm. schrieb "'Leyne, Sean' s...@broadviewsoftware.com
[firebird-support]" <firebird-support@yahoogroups.com>:
Freddie,
LOCK_HEADER BLOCK
Version: 145, Active owner: 0, Length: 25165824, Used:
24798216
Flags: 0x0001
Enqs: 17157097538, Converts: 22693011, Rejects: 12135777,
Blocks: 93039760
Deadlock scans: 289, Deadlocks: 1, Scan interval: 10
Acquires: 18346589405, Acquire blocks: 1203176111, Spin count:
0
Mutex wait: 6.6%
Hash slots: 1009, Hash lengths (min/avg/max): 47/ 67/ 93
Remove node: 0, Insert queue: 0, Insert prior: 0
Owners (151): forward: 30704, backward: 21097392
Free owners (4): forward: 750216, backward: 24346456
Free locks (10120): forward: 28728, backward: 693760
Free requests (7877): forward: 8570432, backward: 1678000
Lock Ordering: Enabled
Increase the number of hash slots (at least x10) and increase the lock manager
memory (x4 to x6) in your fbconfig. File
Sean
