Hello Adam,

Before 8:37 The log only contains that Guardian Stating the FireBird Server at some specific time, I am attaching the firebird log file from another machine on which i have encountered the same issue. Please have a look at it and if you find something please let me know.

Thanking in advance.
Ghazanfar.


----- Original Message ----
From: Adam <s3057043@...>
To: firebird-support@yahoogroups.com
Sent: Tuesday, July 4, 2006 11:32:05 AM
Subject: [firebird-support] Re: FireBird Connect Error


You keep cutting out the important information from your logs.

What happens before 8:37:01

Adam

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

>
> 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]
>

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

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]