[Serusers] "No memory left" error!
giannici at neomedia.it
Fri Aug 19 19:42:01 CEST 2005
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
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.
> What I have to do to succed the large query?
> SER is 0.9.3 under OpenBSD 3.7 amd64.
> Aug 19 17:56:09 eowyn ./ser: convert_row(): No memory left
> Aug 19 17:56:09 eowyn ./ser: convert_rows(): Error while
> converting row #7014
> Aug 19 17:56:09 eowyn ./ser: convert_result(): Error while
> converting rows
> Aug 19 17:56:09 eowyn ./ser: store_result(): Error while
> converting result
|- giannici at neomedia.it
|ederico Giannici http://www.neomedia.it
More information about the sr-users