Subject Re: [firebird-support] RE: Firebird SuperClassic hangs
Author Freddy Ertl
Post date 2017-05-04T20:23:33Z
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' Sean@... [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