Hi John,

Something to look at is any heavy use of blobs and long-running transactions within the application as these may point to your problem.

HTH,
Tom

--- In firebird-support@yahoogroups.com, "dr_john_mp" <dr.john@...> wrote:
>
> Our main database is Firebird 2.1 running on a windows 2k8 server
>
> In the middle of the night with no real users, a single program was running updating data from a file into the database. This runs every night, there were no changes to the programs and automatic server updates are turned off. Part way through the program failed and then repeatedly gave the following errors each time it tried to write to the database.
>
> Exception class = TDBXError; message = invalid request handle
> Exception class = TDBXError; message = unable to allocate memory from operating system
>
> Any attempt to access from other programs (inc IBExpert) also gave the memory error as sis GFIX and GBAK. System memory did spike to near 100% before they failed.
>
> Copying the database to a WinXP machine and trying to open/test using a local IBExpert the memory again gradually increases to the XP address limit.
>
> Have successfully restored service from a backup but would like to understand the errors and what might have caused them
>
> Firebird 2.1 WI-V2.1.1.17910
>
> thanks in advance for any info
>
> John
>