Btw, the sort_mem_error is with 1.0.3. It was a database with a
million records and the user was sorting on a column with very low
selectivity.

The main thing that I found strange was that the server only grew to
~64 megs in memory before giving this exception. Is there a limit here
I need to increase?

R.

--- In firebird-support@yahoogroups.com, "Robert DiFalco"
<rdifalco@t...> wrote:

> I'm getting a 335544676 GDS exception. This is with 1.0.3 running on
> Windows. Oddly enough, the ibserver process was only using 64 megs of
> memory. Any ideas on how to increase this value? The only property I
> have set in ibconfig is this:
>
> DATABASE_CACHE_PAGES 9000
>
> From JayBird, the exception looks like this:
>
> Caused by: org.firebirdsql.jdbc.FBSQLException: GDS Exception.
> 335544676. sort error: not enough memory
> at
> org.firebirdsql.jdbc.AbstractPreparedStatement.internalExecute(AbstractP
> reparedStatement.java:503)
> at
> org.firebirdsql.jdbc.AbstractPreparedStatement.executeQuery(AbstractPrep
> aredStatement.java:109)
> at
> com.space.core.persistence.db.CachedPreparedStatement.executeQuery(Conne
> ctionPool.java:1278)
> at
> com.space.core.persistence.db.StatementStream.executeQuery(StatementStre
> am.java:51)
> at
> com.space.core.persistence.db.QueryContext.search(QueryContext.java:261)
> ... 55 more
>
> Doesn't seem like this should ever happen.
>
> R.