Subject | Re: Limited concurrent database access |
---|---|
Author | m2data |
Post date | 2005-10-17T17:26:46Z |
--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@i...> wrote:
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
------------------------------
<aharrison@i...> wrote:
>_beginthreadx is
> It's not in the database server exactly. The call to
> failing, probably in the attempt to start a garbage collectthread, and
> probably because there are no threads available. I'm trying tofigure
> out why. Possibly there's a memory problem - not enough swapspace to
> backup the 4GB of ram?I have create 25 folders (C:\dbt\db1 .. c:\dbt\db25) containing 25
>
> Regards,
>
>
> Ann
>
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
------------------------------