| Subject | Re: Query never return |
|---|---|
| Author | svanderclock |
| Post date | 2009-06-21T11:18:11Z |
--- In firebird-support@yahoogroups.com, "Alan McDonald" <alan@...> wrote:
the number of client is average about 200 (so i see 200 process in task manager), in firebird conf i customize only this params :
DefaultDbCachePages = 512 (instead of 74)
so it's mean 200 * 512 * 4kb = 409600 kb = 400 Mb only ? so how can i use all the memory ??
the other params (# mean default, i don't touch):
TempDirectories = d:\firebirddata\temp
#MaxFileSystemCache = 65536
#TempBlockSize = 1048576
#TempCacheLimit = 67108864
#DeadlockTimeout = 10
#MaxUnflushedWrites = 100
#MaxUnflushedWriteTime = 5
#BugcheckAbort = 0
#ConnectionTimeout = 180
#DummyPacketInterval = 0
#TcpRemoteBufferSize = 8192
#TcpNoNagle = 1
#LockMemSize = 1048576
#LockSemCount = 32
#LockGrantOrder = 1
#LockAcquireSpins = 0
#LockHashSlots = 1009
#ProcessPriorityLevel = 0
even if i have some max 1000 client connected it's must be ok ? but everytime, when the number of client grow, i have some error that look like memory problem on the server ...
i also notice that the .lck file grow to 80 MB ! is it normal ? (average 30 Mo)
in the log file, the data differ everytime
sometime it's :
* Insufficient memory to allocate page buffer cache
* INET/inet_error: read errno = 10054
* Fatal lock manager error: inconsistent lock table version number; found 34, expected 144, errno: 183
* Database: C:\PROGRAM FILES\FIREBIRD_2_1\SECURITY2.FDB
lock manager error
inconsistent lock table version number; found 34, expected 144
* lock manager error
etc..
i thing the probleme is in the lock manager...
thanks by advance for our advice !
stephane
>Last version of firebird (classic server), windows server 2008 with 8 GO of memory (i just bought another quad core processor and 32 GO of memory and wait them... but i don't thing it's will resolve the problem).
> > hello,
> >
> > when i have memory error on the firebird server (like : unable to
> > allocate memory from operating system) then some running query never
> > return (they don't gave any error, they never finish, resulting that
> > the application is freezing)
> >
> > do you thing it's a normal behavior ? the runing query must not stop
> > giving an error ?
> >
> > thanks for your advice
> > stephane
>
> gosh - never seen this error, and been managing IB/FB and applciations for
> about 150 server years.
> What's the spec on server? Is its RAM OK? What was the query?
> Alan
>
the number of client is average about 200 (so i see 200 process in task manager), in firebird conf i customize only this params :
DefaultDbCachePages = 512 (instead of 74)
so it's mean 200 * 512 * 4kb = 409600 kb = 400 Mb only ? so how can i use all the memory ??
the other params (# mean default, i don't touch):
TempDirectories = d:\firebirddata\temp
#MaxFileSystemCache = 65536
#TempBlockSize = 1048576
#TempCacheLimit = 67108864
#DeadlockTimeout = 10
#MaxUnflushedWrites = 100
#MaxUnflushedWriteTime = 5
#BugcheckAbort = 0
#ConnectionTimeout = 180
#DummyPacketInterval = 0
#TcpRemoteBufferSize = 8192
#TcpNoNagle = 1
#LockMemSize = 1048576
#LockSemCount = 32
#LockGrantOrder = 1
#LockAcquireSpins = 0
#LockHashSlots = 1009
#ProcessPriorityLevel = 0
even if i have some max 1000 client connected it's must be ok ? but everytime, when the number of client grow, i have some error that look like memory problem on the server ...
i also notice that the .lck file grow to 80 MB ! is it normal ? (average 30 Mo)
in the log file, the data differ everytime
sometime it's :
* Insufficient memory to allocate page buffer cache
* INET/inet_error: read errno = 10054
* Fatal lock manager error: inconsistent lock table version number; found 34, expected 144, errno: 183
* Database: C:\PROGRAM FILES\FIREBIRD_2_1\SECURITY2.FDB
lock manager error
inconsistent lock table version number; found 34, expected 144
* lock manager error
etc..
i thing the probleme is in the lock manager...
thanks by advance for our advice !
stephane