On 29 May 2012 10:21, 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


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