[SR-Users] load 2 500 000 rows from dialplan

[Javi Gallart]

Hello


On 24/09/15 11:06, Никитенко Виталий wrote:
> Hi!
> I have kamailio-4.2.3. And in table dialplan there is 2 500 000 rows. When i started kamailio i see error
>
> ERROR: dialplan [dp_repl.c:74]: repl_exp_parse(): out of shm memory
> ERROR: dialplan [dp_db.c:393]: build_rule(): failed to compile replacing expression
> ERROR: dialplan [dp_db.c:111]: init_db_data(): failed to load database data
> ERROR: dialplan [dialplan.c:188]: mod_init(): could not initialize data
> ERROR: <core> [sr_module.c:968]: init_mod(): Error while initializing module dialplan (/usr/local/lib64/kamailio/modules/dialplan.so)
>
> then i set modparam("dialplan", "fetch_rows", 2500000) and started kamailio i see
>
> ERROR: db_mysql [km_dbase.c:422]: db_mysql_fetch_result(): no memory left
> ERROR: dialplan [dp_db.c:231]: dp_load_db(): failed to fetch
> ERROR: dialplan [dp_db.c:111]: init_db_data(): failed to load database data
> ERROR: dialplan [dialplan.c:188]: mod_init(): could not initialize data
> ERROR: <core> [sr_module.c:968]: init_mod(): Error while initializing module dialplan (/usr/local/lib64/kamailio/modules/dialplan.so)
>
> Please say me how i can load to memory 2500000 rows dialplan?
/usr/local/kamailio/sbin/kamailio -h | grep '\-[mM]'
     -m nr        Size of shared memory allocated in Megabytes
     -M nr        Size of private memory allocated, in Megabytes

In you particular case, you need more shared memory (-M).

Regards

Javi
> _______________________________________________
> SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
> sr-users at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users