Dear Adam,







Miel Hostens



PhD. Student

Department Obstetrics, Reproduction and Herd Health

Faculty of Veterinary Medicine

Ghent University

Salisburylaan 133

B-9820 Merelbeke (Belgium)

Mobile: ++ 32 478 593703

Phone: ++ 32 9 264 7528

Fax: ++ 32 9 264 7557



E-mail: Miel.Hostens@...

Website: www.ROHH.UGent.be
<http://www.rohh.ugent.be/oblocked::http:/www.rohh.ugent.be/>



Van: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Namens Adam
Verzonden: zondag 8 februari 2009 23:35
Aan: firebird-support@yahoogroups.com
Onderwerp: [firebird-support] Re: Error while looping through databases



--- In firebird-support@yahoogroups.com
<mailto:firebird-support%40yahoogroups.com> , "mielhostens"
<mielhostens@...> wrote:

>
> Hi there,
>
> I recently made a dotnet application which has to query all firebird
> datasets in a folder for a specific query and store the results in a
> datatable. What i basically do is open and close each database at a
> time and loop through the folder with datafiles.

OK, you have used a bunch of .NET jargon here (datasets, datatable,
datafiles). I am going out on a limb here.

I think you mean that you have a bunch of Firebird databases stored in
FDB files in a particular folder. You establish a connection to the
first database and run a particular query against it. You then store
the results of that query in another table (in the same or another
database???, not clear!).

Indeed, it is stored in another datatable which can be exported to excel
(works fine)

You then disconnect and repeat the process
with the next file in that folder.
Totally right

>
> When i did it with 100 datafiles no problem,
> now i have access to 1000 datafiles and that's when i got the next
> error after a certain database:
>
> Internal gds software consistency check

I am sure there would have been more to that message. Try also
firebird.log.
I got error code 335544333, I checked the error code files and that's how I
found out about the "Internal gds software consistency check"

>
> I first had the idea of a corrupt datafile but when i query the
> datafile alone, it works,... and the funny thing is, it happens to a
> random database as i also checked this
>
> Anyone who has suggestions?

More information please:

Database server OS: Windows (educated guess) J totally right

Superserver or Classic? superserver
1.5, 2.0, 2.1? 2.1
32bit / 64bit (Firebird, not your OS) 32bit I guess as my os is 32b and I
probably will have chosen the 32b option when installing
Anything you have changed in Firebird.conf? no
Have you defined page buffers for the databases using gfix? No idea about
that

--
If I had to guess, you are using a 32 bit Superserver build, and the
combined page cache is pushing your process beyond the 2GB memory
limit for a 32bit process. A way to check this?





[Non-text portions of this message have been removed]