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 [email protected], "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 >
