[SR-Users] No private memory left

[Vuk Radovanovic]

Hello,


I am having trouble with userblacklist module. I am using mysql db, when 
globalblacklist table is empty or has couple of records kamailio loads fine.

When I populate the table with cca 50k entries I get an error no private 
memory error as pasted below. I have edited both the init.d script and 
/etc/default cfg file to to have 1GB pkg and 2 GB SHM memory with no change.

Init script change:

SHM_MEMORY=2048
PKG_MEMORY=1024

Init script output.

Jun 07 01:03:45 km systemd[1]: Starting Kamailio SIP Server...
Jun 07 01:03:45 km kamctl[1377]: ** INFO: Starting Kamailio :
Jun 07 01:03:46 km /usr/local/sbin/kamailio[1405]: ERROR: <core> 
[db_row.c:114]: db_allocate_row(): no private memory left
Jun 07 01:03:46 km /usr/local/sbin/kamailio[1405]: ERROR: db_mysql 
[km_row.c:57]: db_mysql_convert_row(): could not allocate row
Jun 07 01:03:46 km /usr/local/sbin/kamailio[1405]: ERROR: db_mysql 
[km_res.c:188]: db_mysql_convert_rows(): error while converting row #41249
Jun 07 01:03:46 km /usr/local/sbin/kamailio[1405]: ERROR: db_mysql 
[km_res.c:217]: db_mysql_convert_result(): error while converting rows
Jun 07 01:03:46 km /usr/local/sbin/kamailio[1405]: ERROR: db_mysql 
[km_dbase.c:261]: db_mysql_store_result(): error while converting result
Jun 07 01:03:46 km /usr/local/sbin/kamailio[1405]: ERROR: <core> 
[db_query.c:139]: db_do_query_internal(): error while storing result
Jun 07 01:03:46 km /usr/local/sbin/kamailio[1405]: ERROR: userblacklist 
[db.c:129]: db_reload_source(): error while executing query on db table 
'globalblacklist'
Jun 07 01:03:46 km /usr/local/sbin/kamailio[1405]: ERROR: userblacklist 
[userblacklist.c:610]: reload_sources(): cannot reload source from 
'globalblacklist'
Jun 07 01:03:46 km /usr/local/sbin/kamailio[1405]: ERROR: <core> 
[core/sr_module.c:923]: init_mod_child(): Error while initializing 
module userblacklist (/usr/local/lib64/kamailio/modules/userblacklist.so)
Jun 07 01:03:46 km /usr/local/sbin/kamailio[1405]: ERROR: <core> 
[core/pt.c:330]: fork_process(): init_child failed for process 1, pid 
1405, "udp receiver child=0 sock=127.0.0.1:5060"
Jun 07 01:03:46 km /usr/local/sbin/kamailio[1405]: CRITICAL: <core> 
[main.c:1606]: main_loop(): Cannot fork
Jun 07 01:03:46 km /usr/local/sbin/kamailio[1403]: ALERT: <core> 
[main.c:741]: handle_sigs(): child process 1405 exited normally, status=255
Jun 07 01:03:48 km kamctl[1377]: ** ERROR: PID file 
/var/run/kamailio.pid does not exist -- Kamailio start failed
Jun 07 01:03:48 km systemd[1]: kamailio.service: control process exited, 
code=exited status=1
Jun 07 01:03:48 km systemd[1]: Failed to start Kamailio SIP Server.
Jun 07 01:03:48 km systemd[1]: Unit kamailio.service entered failed state.


Regards,

Vuk