Subject Re: [firebird-support] Lock Manager out of Room
Author Ann W. Harrison
Vinicius wrote:
>
> It happened the following problem trying to connect me and
> to execute any command SQL Manager Lock Out Of room

Did you increase the lock table size parameter in the
configuration file?

Regards,

Ann


> the fb_lock_print -h returned result
>
> LOCK_HEADER BLOCK
> Version: 116, Active owner: 0, Length: 1048576, Used: 323464
> Semmask: 0x0, Flags: 0x0001
> Enqs: 0, Converts: 0, *Rejects: 66000*, Blocks: 164316
> Deadlock scans: 0, Deadlocks: 0, Scan interval: 0
> Acquires: 1, Acquire blocks: 10, Spin count: 6152
> Mutex wait: 1000.0%
> Hash slots: 101, Hash lengths (min/avg/max): 0/ 25/ 39
> Remove node: 0, Insert queue: 0, Insert prior: 0
> Owners (38): forward: 11660, backward: 18544
> Free owners (7): forward: 65568, backward: 116756
> Free locks (91): forward: 257824, backward: 317960
> Free requests (94): forward: 121920, backward: 181844
> Lock Ordering: Enabled
>
> firebird.log appears in several lines:
>
> (Server)
> INET/inet_error = errno = 104
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>