I found the problem - one of the methods in 300 000 lines of code
did not close the Statement, only the ResultSet was closed which was
not sufficient. This eventually exhausted all available resources.

Regards
Daniel Putra

--- In firebird-support@yahoogroups.com, "Daniel Putra" <dp@...>
wrote:

>
> Hi
>
> Since weeks I try to overcome the exception below ("unable to
> allocate memory from operating system") without success. I tried
> various different settings (also the default one) in firebird.conf
> without much success. The core settings used are:
>
> DefaultDbCachePages = 2048
> MaxFileSystemCache = 524288
> RemoteAuxPort = 8992
> RemoteServicePort = 9002
> LockMemSize = 524288
> SortMemUpperLimit = 134217728
> ConnectionTimeout = 720
> Authentication = Native
> TempDirectories =

temp;temp\email;c:\WINDOWS\Temp;c:\WINNT\Temp;

>
> I am using Firebird superserver 2.1.1.17910. All operations are

done

> on one single machine P4 2.8 GHz with 1.5 GB RAM
>
> The exception occures during a commission calculation routine

where

> 10 000+ queries are executed (mostly select (65%) but also insert
> (15%) and update (10%)). The exception occures always between 30

to

> 60 minutes after start of the routine. We are using beteen 7 and

13

> connections.
>
> Although I am using Jaybird to connect I do not belive this is a
> Java related issue.
>
> Any help is greatly appreciated.
> Thanks
> Daniel Putra
> -------------------------------------------------------------------
> org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544430.
> unable to allocate memory from operating system
> at org.firebirdsql.jdbc.FBCachedFetcher.<init>
> (FBCachedFetcher.java:125)
> at org.firebirdsql.jdbc.AbstractResultSet.<init>
> (AbstractResultSet.java:137)
> at org.firebirdsql.jdbc.FBResultSet.<init>
> (FBResultSet.java:19)
> at org.firebirdsql.jdbc.AbstractStatement.getResultSet
> (AbstractStatement.java:622)
> at org.firebirdsql.jdbc.AbstractStatement.getResultSet
> (AbstractStatement.java:603)
> at org.firebirdsql.jdbc.AbstractStatement.executeQuery
> (AbstractStatement.java:217)
> at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown
> Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
> Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at org.firebirdsql.pool.StatementHandler.invoke
> (StatementHandler.java:105)
> at $Proxy1.executeQuery(Unknown Source)
>