Subject Re: [firebird-python] Classic Server
Author Robert Dollinger
Am 12.03.2009 um 16:10 schrieb Pavel Cisar:

> Robert Dollinger napsal(a):
> > Hi,
> >
> > I have encountered the following error with kinterbasdb 3.3 and the
> > classic server:
> >
> > Traceback (most recent call last):
> > File "<interactive input>", line 2, in <module>
> > File
> > "C:\Programme\Python25\lib\site-packages\kinterbasdb\__init__.py",
> line
> > 478, in connect
> > return Connection(*args, **keywords_args)
> > File
> > "C:\Programme\Python25\lib\site-packages\kinterbasdb\__init__.py",
> line
> > 641, in __init__
> > b.dsn, b.dpb, b.dialect, timeout
> > OperationalError: (-923, 'isc_attach_database: \n connection
> rejected
> > by remote interface')
> >
> > I think the error is reproduceable also with older versions of
> > kinterbasdb. It happens on my computer after opening more than 44
> > connection to the DB with Classic Server. Probably it depends on the
> > hardware resources even tough I have still 1 GB of Ram free. With
> the
> > SuperServer there are no problems opening more then 450 connections.
>
> Very likely if you have configured large db cache for your
> database(s),
> as each connection/instance has it's own cache. It would eat up your
> RAM
> pretty quickly.
>
> best regards
> Pavel Cisar
> IBPhoenix
>
>

Hi Pavel,

this is clear to me. In the example above even tough I have still 1 GB
of RAM free after 44 connections,
kinterbasdb blocks new connections to the classic server.
With 44 connection via python active I can still access the DB via
IBExpert, that is the crazy thing.

bye
Robert