Subject Re: Limited concurrent database access
Author m2data
--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@i...> wrote:

>
> It's not in the database server exactly. The call to
_beginthreadx is
> failing, probably in the attempt to start a garbage collect
thread, and
> probably because there are no threads available. I'm trying to
figure
> out why. Possibly there's a memory problem - not enough swap
space to
> backup the 4GB of ram?
>
> Regards,
>
>
> Ann
>

I have create 25 folders (C:\dbt\db1 .. c:\dbt\db25) containing 25
small databases (20MB).

Then I created a batfile containing 25 isql connections:

start isql -user sysdba -password testpass localhost:c:\dbt\db1
\dsbase01.fdb
pause
....
....
....
start isql -user sysdba -password testpass localhost:c:\dbt\db25
\dsbase01.fdb
pause

The test is run on XP-SP2 with 512MB Ram. On the Win2003 server I do
not get "Allocated x page bufferes of x requested". It could be
something related to memory!? I still get "internal gds software
consistency check (cannot start thread)"


Here is what I get from firebird.log:

--------------------------
BH-MOBILE (Server) Mon Oct 17 19:12:12 2005
Database: C:\DBT\DB20\DSBASE01.FDB
Allocated 8050 page buffers of 10000 requested

BH-MOBILE (Server) Mon Oct 17 19:13:50 2005
Database: C:\DBT\DB21\DSBASE01.FDB
Allocated 8002 page buffers of 10000 requested

BH-MOBILE (Server) Mon Oct 17 19:13:51 2005
Database: C:\DBT\DB22\DSBASE01.FDB
Allocated 7905 page buffers of 10000 requested

BH-MOBILE (Server) Mon Oct 17 19:13:52 2005
Database: C:\DBT\DB22\DSBASE01.FDB
internal gds software consistency check (cannot start thread)

BH-MOBILE (Server) Mon Oct 17 19:14:44 2005
Database: C:\DBT\DB23\DSBASE01.FDB
Allocated 7584 page buffers of 10000 requested
------------------------------