| Subject | Re: [firebird-support] hello, can someone translate the follow error messages? ref/eDN8022297953 |
|---|---|
| Author | Helen Borrie |
| Post date | 2008-01-06T06:24:50Z |
At 08:36 PM 4/01/2008, you wrote:
So - about all we can tell from this is that client applications are losing their connections with the server. The fault seems to be on the server side. You said you have other sites that have never seen this problem. Find out what's different at *this* one: someone is rebooting the machine, perhaps, or there is a bad cable or network card; or some other application is installed on the server that is aggressively stealing or blocking Firebird's service port, or......
For your own peace of mind, you might like to do a gstat -h on their database and look at their transaction stats and creation date. If you find that it has been a long time since the database has been restored, do a safe backup and restore and see whether the problem goes away when the database is clean.
./heLen
>Hello to all. Can somebody explain with other words the follow error"One or more clients are left connected to a server that is no longer responding to network requests."
>messages?
>
> REMOTE INTERFACE/gds__detach: Unsuccesful detach from database.
>Uncommitted work may have been lost"Updates, inserts or deletes that were not committed before the server crashed might have disappeared".
>INET/inet_error: connect errno = 10060That's a network error "Connection timed out". It means the established connection failed because the connected host has stopped responding, i.e., it is the error that prompted the one from the remote interface module.
>INET/inet_error: connect errno = 10061Also a network error "Connection refused". Some attempts were made to reconnect to the server computer but the server computer actively refused them. It usually means that the Firebird server is not running.
>INET/inet_error: connect errno = 10065Another network error "No route to host". A socket operation tried to find the server at the address specified but with no luck.
>INET/inet_error: read errno = 10054Yet another network error, the first in the bunch, "Connection reset by peer". That only tells you that the network connection was broken in the middle of a network operation.
So - about all we can tell from this is that client applications are losing their connections with the server. The fault seems to be on the server side. You said you have other sites that have never seen this problem. Find out what's different at *this* one: someone is rebooting the machine, perhaps, or there is a bad cable or network card; or some other application is installed on the server that is aggressively stealing or blocking Firebird's service port, or......
For your own peace of mind, you might like to do a gstat -h on their database and look at their transaction stats and creation date. If you find that it has been a long time since the database has been restored, do a safe backup and restore and see whether the problem goes away when the database is clean.
./heLen