Subject Re: Question to entry in log file
Author Michael Vilhelmsen
> That can't be good.

Agreed ;-)

> 2GB is the maximum addressable memory of a single 32 bit process. The
> amount of memory required by Firebird is a surprisingly complex
> calculation, including the page sizes of the different databases as
> well as the cache sizes (measured in pages) etc.
> If hitting 2GB is not just a 'one off', then you need to do something
> about reducing your cache or something like that.

Its happening some 1 - 3 times a week.

> Another option (and the path we went down) is to use Classic Server.
> Classic server allocates a process to each connection which has two
> benefits for you.
> 1. The 2GB limit is now 2GB per connection (which would require a
> massive cache setting to worry about).
> 2. If the engine does encounter an unexpected condition which causes a
> crash, it is only the single connection that is impacted.

I have looked into the CS model.
It can be used, but require some changes in our program.
It can be done, but we really dont have the time/money to do this.

Basically I was just asking if this error indeed is a result of
running out of memory.
And if it is I have some solutions.

Live with

Wait until FB will be fixed.
Sinse I cant reproduce it, I cant give a "working error" senario.

Switch to CS.

Or - Switch to FB 2.1 64 Bit.
This is the action we have taken.
We are about to convert them all to FB 2.1.
But its not done in a day.