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