Subject | Re: FireBird Connect Error |
---|---|
Author | Adam |
Post date | 2006-07-04T06:32:05Z |
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:
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.
firebird service it starts working fine again for about 2.5 Hours and
same problem reoccured.
What happens before 8:37:01
Adam
--- In firebird-support@yahoogroups.com, Ghazanfar Ali
<ghazanfarali17@...> wrote:
>using the firebird database at the back end to store the client
> Hello,
>
> This weekend i have run my server application that is a service and
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.
>\bin\fbserver.exe
> LK_NEW (Client) Sat July 1 8:37:01 2006
> Guardian starting: C:\Program Files\Firebird\Firebird_1_5
>firebird service it was running fine. And when i restarted the
> 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 starts working fine again for about 2.5 Hours and
same problem reoccured.
> Thanking in advance.after
>
> 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
> some interval when i try to connect to the database it gives me andoesnt
> 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
> look like this is a very common error.to
> >
> > Things i have tried so far:
> >
> > 1. checked the service is running
> > 2. checked the localhost is working (by pinging it) and checked
> make sure the %windir%\system32\drivers\etc\hosts file is validprotocol
>
> 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
> in Firebird is just quiet when nothing is occurring.a
>
> 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
> 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]
>