Subject RE: Firebird SuperClassic hangs
Author Leyne, Sean

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