Hi Nick,

>>>>>> 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).
>>
>>
> well the system is running, so there is some load, but there are times of
> much higher load every day
> this is 2.1.4 at present, are you suggesting changes to the firebird config
> parameters

The actual lock print output doesn't show any need for changing
something in firebird.conf lock manager/table related.


--
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/