On 08/13/2010 12:45 AM, Ludwig, Michael wrote: >> -----Original Message----- >> From: Peter J. Holzer [mailto:h...@wsr.ac.at] >> 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