community.borland.com

Article #25341: Getting gds_free & gds_alloc errors

Problem:
Getting gds_free & gds_alloc errors and Dr. Watson access violation 

error on IBserver.exe.

Solution:
This may be related to bug 8349.  Bug 8349 has to do with running large  
queries with order by on non-index field(s).  One way to confirm 
whether you are hitting this bug is to check and see if there are lots 
of (sometimes large) InterBase sort files in the temp directory.  
InterBase sort file starts with ib and follows by hex numbers something 
like this ib34c57.  Temp directory defaults to c:temp if you don't 
have the system variable temp setup to point to somewhere other than 
c:temp.  Another check is to turn the query plan on and run the query.  
View the plan and see if the plan uses the index or not.  When the plan 
is natural, it means there is no index used.

For InterBase version WI-V4.2.1 the workaround for this bug is to create 
indices on the order by fields.

In InterBase v5.0 (all platforms), this problem is fixed.

Last Modified: 17-OCT-00