Thomas Steinmaurer wrote:

>
> I was working on a database today. Firebird 2.1.2 Classic 64-bit
> (Windows 2003 Server). After a while, I wasn't able to connect to the
> database anymore. Either remote or on the local server via isql.

Did you try other than TCP protocols, namely named pipes and local?

> Connecting to other databases on the same server is working just fine.

The same question for the other databases.

> It is just this one particular database on that server, where I get an:
>
> Statement failed, SQLCODE = -902
> Unable to complete network request to host "localhost".
> -Error writing data to the connection.
> -An existing connection was forcibly closed by the remote host.
>
> when I'm trying to connect.

Looks like a server crash. Do you have any ON CONNECT triggers? If so,
have you tried to backup the problematic database with and without the
-no_db_triggers (sorry, I don't remember the exact syntax :-) switch?

> I have a few entries firebird.log:
>
>
> DUBLIN Mon Aug 17 15:32:43 2009
> INET/inet_error: bind errno = 10048
>
>
> DUBLIN Mon Aug 17 15:32:43 2009
> Database:
> Unable to complete network request to host "dublin".
> Error while listening for an incoming connection.
> Only one usage of each socket address (protocol/network address/port)
> is normally permitted.
>
>
> DUBLIN Mon Aug 17 15:32:59 2009
> XNET error: Server initialization failed

The second listener had started and failed to initialize due to the
already used protocol endpoints.

> DUBLIN (Client) Mon Aug 17 15:37:12 2009
> INET/inet_error: read errno = 10054

The server unexpectedly crashed.


Dmitry