[Kamailio-Devel] presence module runs out of memory during init

[Juha Heinanen]

this happened during init of presence module:

May  6 18:39:48 sipproxy2 /usr/sbin/kamailio[6138]: ERROR:db_mysql:db_mysql_convert_row: no private memory left
May  6 18:39:48 sipproxy2 /usr/sbin/kamailio[6138]: ERROR:db_mysql:db_mysql_convert_rows: error while converting row #3662
May  6 18:39:48 sipproxy2 /usr/sbin/kamailio[6138]: ERROR:db_mysql:db_mysql_convert_result: error while converting rows
May  6 18:39:48 sipproxy2 /usr/sbin/kamailio[6138]: ERROR:db_mysql:db_mysql_store_result: error while converting result
May  6 18:39:48 sipproxy2 /usr/sbin/kamailio[6138]: ERROR:core:db_do_query: error while storing result
May  6 18:39:48 sipproxy2 /usr/sbin/kamailio[6138]: ERROR:presence:restore_db_subs: while querrying table
May  6 18:39:48 sipproxy2 /usr/sbin/kamailio[6138]: ERROR:presence:mod_init: restoring subscribe info from database
May  6 18:39:48 sipproxy2 /usr/sbin/kamailio[6138]: ERROR:core:init_mod: failed to initialize module presence

after studying the problem, i came to the conclusion that memory runs
out, because k subscribe/restore_db_subs function is not using
DB_CAP_FETCH capability, but tries to get the result from
active_watchers table at one shot.  fix is highly desirable.

-- juha