Hello,

This weekend i have run my server application that is a service and using the firebird database at the back end to store the client information, i have developed a test application that is sending the requests to the server continously, what i have analysed is that after successfuly fulfilling the requests for about 3 hours, whenever my server application try to connect with the firebird database i was unable to connect with the database. When i see the log file it is filled with the following text.

LK_NEW (Client) Sat July 1 8:37:01 2006
Guardian starting: C:\Program Files\Firebird\Firebird_1_5\bin\fbserver.exe

LK_NEW (Client) Sat July 1 10:49:32 2006
INET/inet_error: read errno = 10053

LK_NEW (Client) Sat July 1 10:49:32 2006
INET/inet_error: receive in try_connect errno = 203

LK_NEW (Server) Sat July 1 10:49:32 2006
INET/inet_error: accept errno = 10022

LK_NEW (Server) Sat July 1 10:49:33 2006
INET/inet_error: accept errno = 10022

LK_NEW (Client) Sat July 1 10:49:33 2006
INET/inet_error: read errno = 10053

LK_NEW (Client) Sat July 1 10:49:33 2006
INET/inet_error: receive in try_connect errno = 203

Please anyone help me to fix this problem, because when i check the firebird service it was running fine. And when i restarted the firebird service it starts working fine again for about 2.5 Hours and same problem reoccured.
Thanking in advance.

With Regards,
Ghazanfar

----- Original Message ----
From: Ghazanfar Ali <ghazanfarali17@...>
To: firebird-support@yahoogroups.com
Sent: Wednesday, June 28, 2006 9:47:31 AM
Subject: Re: [firebird-support] Re: FireBird Connect Error


Hi Adam,

Thanks a lot for your reply.




----- Original Message ----
From: Adam <s3057043@...>
To: firebird-support@yahoogroups.com
Sent: Tuesday, June 27, 2006 11:22:37 AM
Subject: [firebird-support] Re: FireBird Connect Error


--- In firebird-support@yahoogroups.com, Ghazanfar Ali
<ghazanfarali17@...> wrote:

>
> Hi Everyone,
>
> I am running Firebird 1.5.2 my machine and it works fine. But after

some interval when i try to connect to the database it gives me an
error message "Unable to complete network request to
host "localhost". And when i check the firebird logs it contains:

>
> LK_NEW (Client) Sat Jun 17 10:37:01 2006
> Guardian starting: C:\Program Files\Firebird\Firebird_1_5

\bin\fbserver.exe

>
> LK_NEW (Client) Sat Jun 17 10:49:32 2006
> INET/inet_error: read errno = 10053
>
> LK_NEW (Client) Sat Jun 17 10:49:32 2006
> INET/inet_error: receive in try_connect errno = 203
>
> LK_NEW (Server) Sat Jun 17 10:49:32 2006
> INET/inet_error: accept errno = 10022
>
> LK_NEW (Server) Sat Jun 17 10:49:33 2006
> INET/inet_error: accept errno = 10022
>
> LK_NEW (Client) Sat Jun 17 10:49:33 2006
> INET/inet_error: read errno = 10053
>
> LK_NEW (Client) Sat Jun 17 10:49:33 2006
> INET/inet_error: receive in try_connect errno = 203
>
> I have searched the internet to find the solution ot this issue

but i just cannot seem to find the solution to this one and it doesnt
look like this is a very common error.

>
> Things i have tried so far:
>
> 1. checked the service is running
> 2. checked the localhost is working (by pinging it) and checked to

make sure the %windir%\system32\drivers\etc\hosts file is valid

A TCP/IP connection has no state (by definition). When you ping it,
all that says is that at the moment in time you issue the ping, it
receives a response from the server within an acceptable timeframe.

Each packet is routed separately, so it is possible that there are
intermittent 'connections' being dropped. The server will drop a
connection if it has not been able to send some data to it.
Underlying layers will drop the connection after an inactivity
timeout (usually 2hrs). Some firewalls etc also assume that no
traffic = connection dead, when in reality the over the wire protocol
in Firebird is just quiet when nothing is occurring.

Anyway, those 5 digit codes (eg 10053) are winsock error codes. You
can google to get the meaning of each.

I notice at 10:37 the guardian restarted the service. It would only
do this if the engine was not running, so you may need to look back a
bit more in the log to see the details of the crash. If the engine
restarts, all connections to that engine are lost (obviously).

Adam









++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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




[Non-text portions of this message have been removed]