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

[Никитенко Виталий]

>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

Thanks, it works!