>> **
>>
>>
>>>> This morning I got the following message on one of our systems in the
>>>> firebird logfile.
>>>>
>>>> page 52620, page type 5 lock conversion denied (215)
>>>>
>>>> (firebird 2.1.4, centos)
>>>>
>>>> The only reference I found is
>>>> http://tracker.firebirdsql.org/browse/CORE-1970 which indicates this
>> was
>>>> fixed in 2.1.2
>>>>
>>>> it seems to relate to having multiple isql connections (which we did at
>> the
>>>> right time but also have many other times as well)
>>>
>>> Or:
>>> http://tracker.firebirdsql.org/browse/CORE-3464
>>>
>>> Which is marked as fixed in the forthcoming 2.1.5 release (RC is already
>>> available as download!).
>>
>> Ah, and I would also check some lock manager/table information with
>> fb_lock_print to see the lock table size, possibly too high hash slot
>> values etc.
>>
>
> all such values are default
>
> LOCK_HEADER BLOCK
> Version: 16, Active owner: 0, Length: 1048576, Used: 277328
> Lock manager pid: 3647
> Semmask: 0x4948, Flags: 0x0001
> Enqs: 6734541938, Converts: 49020909, Rejects: 6676277, Blocks:
> 8296620
> Deadlock scans: 1, Deadlocks: 1, Scan interval: 10
> Acquires: 7176561824, Acquire blocks: 6714981, Spin count: 0
> Mutex wait: 0.1%
> Hash slots: 1009, Hash lengths (min/avg/max): 0/ 0/ 5
> Remove node: 0, Insert queue: 0, Insert prior: 0
> Owners (5): forward: 19596, backward: 151960
> Free owners (6): forward: 19412, backward: 195892
> Free locks (1316): forward: 19240, backward: 273608
> Free requests (1397): forward: 82716, backward: 231092
> Lock Ordering: Enabled

I don't know your workload, but these figures only make sense when
generating under load. Was this under load? Just keep an eye on that, if
you have a (high) loaded system with Classic or SuperClassic (2.5).


--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/

Do you care about the future of Firebird? Join the Firebird Foundation:
http://www.firebirdsql.org/en/firebird-foundation/