Hello John, You have hit transaction limit of Firebird. To prevent it, make backup/restore more often.
Regards, Alexey Kovyazin IBSurgeon > 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 > > [Non-text portions of this message have been removed]