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' [email protected] [firebird-support]" <[email protected]>: 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
