Subject | Classic Server on Win2003 Standard (dead client connections |
---|---|
Author | nilsboedeker |
Post date | 2006-01-20T07:29:50Z |
Hi,
we use
1.5.2.4731 Classic
on an smp hyperthreading system with 2GB Ram and 4 (2 nativ)
processors
do drive our websystem (ISAPI/Delphi
).
We have a lot of traffice the database ist in the main time in heavy
use.
We attache 12 Databases, the biggest is 5 GB (with a lot of blob
space).
2 Month ago we change from superserver to classicserver and notice 2
strange
things.
---
a) After some time of working (1-2 Days) we notice that some
If we stop all connections there are allready some fb_inet_server.exe
processes (more then the main process). Also if I stop the main
service
there are still some fb_inet_server.exe processes there who never
disappear.
What are this processes?
Are this processes dead clients connections?
Is there any server or function das kills this dead clients
connections
automatically?
---
b) I make a database stat I saw in our main database a growing
distance
between the "Oldest active" and the "Next transaction". Same behave as
if there are some transactions are lost or never closed. Gfix -l or -s
don't remove this transactions. Only gfix -m (mend) remove them.
The strange thing is that I don't have any problems like that if I use
the superserver. Can this caused by the don't disappearing
b_inet_server.exe processes (see a)?
---
I use the default configuration in firebird.conf. I only change the
following values because in main time we have a lot of database
connections.
LockMemSize = 10485760
LockSemCount = 256
---
Any Ideas?
with best regards from bremen
Nils Bödeker
_________________________________
Verlag Eugen Ulmer
Datenbanken und IT-Entwicklung
Nils Bödeker
Bürgerwohlsweg 7
D-28215 Bremen
Germany
Tel: +49 (0)421 - 3795020
Fax: +49 (0)421 - 3795021
Mobil: +49 (0) 172 - 7468066
nboedeker@...
www.ulmer.de / www.nbsoft.de
yahoo ID: nilsboedeker
Skype ID: nilsboedeker
ICQ ID: 206474523
we use
1.5.2.4731 Classic
on an smp hyperthreading system with 2GB Ram and 4 (2 nativ)
processors
do drive our websystem (ISAPI/Delphi
).
We have a lot of traffice the database ist in the main time in heavy
use.
We attache 12 Databases, the biggest is 5 GB (with a lot of blob
space).
2 Month ago we change from superserver to classicserver and notice 2
strange
things.
---
a) After some time of working (1-2 Days) we notice that some
If we stop all connections there are allready some fb_inet_server.exe
processes (more then the main process). Also if I stop the main
service
there are still some fb_inet_server.exe processes there who never
disappear.
What are this processes?
Are this processes dead clients connections?
Is there any server or function das kills this dead clients
connections
automatically?
---
b) I make a database stat I saw in our main database a growing
distance
between the "Oldest active" and the "Next transaction". Same behave as
if there are some transactions are lost or never closed. Gfix -l or -s
don't remove this transactions. Only gfix -m (mend) remove them.
The strange thing is that I don't have any problems like that if I use
the superserver. Can this caused by the don't disappearing
b_inet_server.exe processes (see a)?
---
I use the default configuration in firebird.conf. I only change the
following values because in main time we have a lot of database
connections.
LockMemSize = 10485760
LockSemCount = 256
---
Any Ideas?
with best regards from bremen
Nils Bödeker
_________________________________
Verlag Eugen Ulmer
Datenbanken und IT-Entwicklung
Nils Bödeker
Bürgerwohlsweg 7
D-28215 Bremen
Germany
Tel: +49 (0)421 - 3795020
Fax: +49 (0)421 - 3795021
Mobil: +49 (0) 172 - 7468066
nboedeker@...
www.ulmer.de / www.nbsoft.de
yahoo ID: nilsboedeker
Skype ID: nilsboedeker
ICQ ID: 206474523