On 29 May 2012 10:31, Thomas Steinmaurer <ts@...> wrote:

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


[Non-text portions of this message have been removed]