Re: "Out of memory! Out of memory! Callback called exit at ..."

On 08/13/2010 12:45 AM, Ludwig, Michael wrote:
>> -----Original Message-----
>> From: Peter J. Holzer [mailto:[email protected]]
>> Subject: Re: "Out of memory! Out of memory! Callback called exit at ..."
> 
>> On 2010-08-12 10:19:37 -0700, Bob McGowan wrote:
>>> In point of fact, which I failed to mention (mia culpa), I've 
>>> debugged down to the point where the call is made to 
>>> 'selectall_arrayref()'.
>>
>> How many rows does this return? (Or rather: How many rows would it 
>> return if it didn't run out of memory?) If each row contains a 20 MB 
>> blob you don't need many rows to run out of memory.
> 
> Indeed, I forgot: You're fetching blobs with LongReadLen set to a high value. Combining that with selectall_* might not be a good idea, after all.
> 
> --
> Michael Ludwig

As it happens, I'm processing one row at a time.  Additionally, the out
of memory error happened originally without having LongReadLen set at all.

I've been doing some tracing for this, and found that the issue is with
a third party module that I was using, that creates a db handle as a
derived object (terminology?? I'm not an OO programmer).

Turns out the reason I was using the module no longer exists and I can
do the connect directly, which eliminates the problem.

Thanks for the suggestions and observations.

-- 
Bob McGowan