Subject | Re: [firebird-support] Problems with FB 1.5.3 Classic - DeadClient Connections |
---|---|
Author | nils.boedeker.support@t-online.de |
Post date | 2006-03-09T10:21:55Z |
Hallo
a) From a Webserver (different machine) to the Database Server. Normal
FB Client connection by Port 3050. The connection between the both
computers are a 1 GB Ethernet.
b) From Outside (Internet, anywhere on the world) to the Database
Server. Normal FB Client connection by Port 3050. The Connection is
(like a modem connection) instable and it it possible (and normal) that
this connections are broken.
If a connection are broken by the client (for example Internet Access
are canceled) the Server (Databaseserver) hold this connection
nevertheless. I can see this by Netstat that list open connections.
This "dead" connections are never disappears and also hold transactions
open. This is the problem that needs a solution.
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
>There are 2 Client connections:
> ich bin nicht so der Firebird Experte , aber so wie ich Ihre EMail
> gelesen habe suchen sie den Client der Datenbank am falschen Ende der
> Leitung
>
> Der Client der auf die Datenbank zugreift ist sitzt auch bei Web
> Anwendungen bei Ihnen auf dem Server , ins Internet gehen nur die HTTP
> verbidnungen , Die Dead Connection Detection *kann* also nicht auf der
> Datenbank-Server-Seite funktionieren da diese Verbindung ja lokal
> funktioniert und weiter besteht.
>
a) From a Webserver (different machine) to the Database Server. Normal
FB Client connection by Port 3050. The connection between the both
computers are a 1 GB Ethernet.
b) From Outside (Internet, anywhere on the world) to the Database
Server. Normal FB Client connection by Port 3050. The Connection is
(like a modem connection) instable and it it possible (and normal) that
this connections are broken.
If a connection are broken by the client (for example Internet Access
are canceled) the Server (Databaseserver) hold this connection
nevertheless. I can see this by Netstat that list open connections.
This "dead" connections are never disappears and also hold transactions
open. This is the problem that needs a solution.
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