Re: [firebird-support] unable to allocate memory from operating system

2012-05-21 Thread Alexey Kovyazin
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

Re: [firebird-support] unable to allocate memory from operating system

2012-05-21 Thread Thomas Steinmaurer
Hi John, 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

Re: [firebird-support] unable to allocate memory from operating system

2012-05-21 Thread Michael Ludwig
Alexey Kovyazin schrieb am 21.05.2012 um 15:04 (+0400): You have hit transaction limit of Firebird. To prevent it, make backup/restore more often. What makes you think so? And why would that make the memory usage rise to nearly 100% ? Also, the limit is 2**64, that's pretty high. Re: