Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Richard Ridley — — source: Informix-list mailing list archive (1991-1998)
Ben Kelley writes:
|I have been having problems with a memory leakage bug in Informix 4.1 (For
|SunOS 4.1.3, but the bug could be in other versions) where your sqlturbo
|process gradually grows, until it gets to the point where you get a
|"-208 Memory allocation failed during query processing" error message.
|
|You can demonstrate the bug by running the following pseudo program (with the
|appropriate databases set up):
|
|while true do
| open database 1
| select some data from table 1
| close database 1
|
| open database 2
| select some data from table 2
| close database 2
|od
We have experienced a similar problem when simply accessing data
through a view in a different tbconfig(using ISTAR) on the same
machine. Our version is 5.02.UC1, but it also happens on 5.01.UD3.
This is on an HP-UX 9.0 machine.
Our test program does the following :
declare cur cursor for select * from db2@star2:v2
while true
foreach cur into rec.*
message num
let num = num + 1
end foreach
end while
and the virtual memory space keeps growing till the program falls
over with the same error as yours
I would be very interested if you get any sort of reply from
Informix on this one.
Regards,
Richard Ridley
DHL Asia Pacific
(rridley@sin-pss.dhl.com)
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.