Subject | Big Problem: unavailable database |
---|---|
Author | Carsten Schäfer |
Post date | 2001-09-20T07:51:16Z |
Hi,
I'm using Firebird-Beta2 with Interclient2 on a WinNT4 Workstation.
There are up to 15 simultanious users with 2 Connections for each user
working with the database. The connections (via DataSource) are never
closed from my application (so I don't have to open a new Connection
for each access to the db).
After some time (1 to 7 days) new users that want to connect to the
database get the following exception:
interbase.interclient.UnavailableInterBaseServerException:
[interclient][interbase] unavailable database
See API reference for exception
interbase.interclient.UnavailableInterBaseServerException
at interbase.interclient.RecvMessage.createSQLException(Unknown
Source)
at interbase.interclient.RecvMessage.makeSQLException(Unknown Source)
at interbase.interclient.RecvMessage.get_EXCEPTIONS(Unknown Source)
at interbase.interclient.Connection.remote_ATTACH_DATABASE(Unknown
Source)
at interbase.interclient.Connection.connect(Unknown Source)
at interbase.interclient.Connection.<init>(Unknown Source)
at interbase.interclient.DataSource.getConnection(Unknown Source)
at interbase.interclient.DataSource.getConnection(Unknown Source)
All other users can work normal with the db. If one of the users that
can work disconnects
from the database the other user (that got the exception) can connect
to the db again.
When the exception happens i neither can connect to the database via
ibconsole.
I get the following error:
'Error logging into the requested server. Detail:Cannot attach to
services manager'
I have to reboot the machine so that the users can work again for some
days.
Does someone know how to avoid this problem ?
gruse
Carsten
I'm using Firebird-Beta2 with Interclient2 on a WinNT4 Workstation.
There are up to 15 simultanious users with 2 Connections for each user
working with the database. The connections (via DataSource) are never
closed from my application (so I don't have to open a new Connection
for each access to the db).
After some time (1 to 7 days) new users that want to connect to the
database get the following exception:
interbase.interclient.UnavailableInterBaseServerException:
[interclient][interbase] unavailable database
See API reference for exception
interbase.interclient.UnavailableInterBaseServerException
at interbase.interclient.RecvMessage.createSQLException(Unknown
Source)
at interbase.interclient.RecvMessage.makeSQLException(Unknown Source)
at interbase.interclient.RecvMessage.get_EXCEPTIONS(Unknown Source)
at interbase.interclient.Connection.remote_ATTACH_DATABASE(Unknown
Source)
at interbase.interclient.Connection.connect(Unknown Source)
at interbase.interclient.Connection.<init>(Unknown Source)
at interbase.interclient.DataSource.getConnection(Unknown Source)
at interbase.interclient.DataSource.getConnection(Unknown Source)
All other users can work normal with the db. If one of the users that
can work disconnects
from the database the other user (that got the exception) can connect
to the db again.
When the exception happens i neither can connect to the database via
ibconsole.
I get the following error:
'Error logging into the requested server. Detail:Cannot attach to
services manager'
I have to reboot the machine so that the users can work again for some
days.
Does someone know how to avoid this problem ?
gruse
Carsten