Ann,

512K was started when the error, but I did for 1048576, trying to solve.

I noticed that rejects the fb_lock_print this increasing very rapidly.

even restoring the backup me he returns this error of lock manager out
of room.

as I do to make the locks used for this error does not occur, or
realemente I need time to time increase the parameter lockmemsize?


Vinicius.

Ann W. Harrison escreveu:

>
> 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 <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
> <http://www.ibphoenix.com>
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > Yahoo! Groups Links
> >
> >
> >
>
>
> ------------------------------------------------------------------------
>
>
>
> Checked by AVG.
> Version: 8.0.100 / Virus Database: 269.24.1/1470 - Release Date: 28/5/2008 07:20
>