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(a)neomedia.it
|ederico Giannici
http://www.neomedia.it
___________________________________________________