[Serusers] "No memory left" error!

[Federico Giannici]

Federico Giannici wrote:
> I need to load in memory a large table (currently about 10.000 entry).
> 
> During the sql query (MySQL) the following error happens and SER quit!
> The error is due to the failure of a pkg_malloc().
> 
> I tried to increase the PKG_MEM_POOL_SIZE and SHM_MEM_SIZE but nothing 
> changed.

After some other tentatives, I found that increasing PKG_MEM_POOL_SIZE 
actually changed something! The reported amount of allocated memory was 
the same, but the problem disappeared, probably because more mem_pool's 
"slots" were available.

This solved the problem.

Bye.


> What I have to do to succed the large query?
> 
> SER is 0.9.3 under OpenBSD 3.7 amd64.
> 
> Thanks.
> 
> 
> Aug 19 17:56:09 eowyn ./ser[27075]: convert_row(): No memory left
> Aug 19 17:56:09 eowyn ./ser[27075]: convert_rows(): Error while 
> converting row #7014
> Aug 19 17:56:09 eowyn ./ser[27075]: convert_result(): Error while 
> converting rows
> Aug 19 17:56:09 eowyn ./ser[27075]: store_result(): Error while 
> converting result


-- 
___________________________________________________
     __
    |-                      giannici at neomedia.it
    |ederico Giannici      http://www.neomedia.it
___________________________________________________