Hi Forum,

I want to use carrierroute to terminate 50,000 preffixes to a PSTN gw and block 100,000.
So I created 50,000 records with gw ip as rewrite_host. However I only was able to start kamailio with no more than about 2,200 records in carrierroute mysql table.

Is it possible to use carrierroute in such a way?

Find below log with error:

Sep 29 13:36:22 sip-proxy /usr/local/sbin/kamailio[2569]: INFO:carrierroute:bind_data_loader: use database as configuration source
Sep 29 13:36:22 sip-proxy /usr/local/sbin/kamailio[2569]: INFO:carrierroute:load_route_data: name default, id 0, trees: 1
Sep 29 13:36:22 sip-proxy /usr/local/sbin/kamailio[2569]: INFO:carrierroute:add_carrier_tree: add carrier default
Sep 29 13:36:22 sip-proxy /usr/local/sbin/kamailio[2569]: INFO:carrierroute:add_carrier_tree: carrier default not found, add it
Sep 29 13:36:22 sip-proxy /usr/local/sbin/kamailio[2569]: INFO:carrierroute:add_tree: tree default has internal id 0
Sep 29 13:36:22 sip-proxy /usr/local/sbin/kamailio[2569]: INFO:carrierroute:add_carrier_tree: created carrier tree: default, with id
 0 and 1 trees
Sep 29 13:36:22 sip-proxy /usr/local/sbin/kamailio[2569]: ERROR:db_mysql:db_mysql_convert_row: no private memory left
Sep 29 13:36:22 sip-proxy /usr/local/sbin/kamailio[2569]: ERROR:db_mysql:db_mysql_convert_rows: error while converting row #2282
Sep 29 13:36:22 sip-proxy /usr/local/sbin/kamailio[2569]: ERROR:db_mysql:db_mysql_convert_result: error while converting rows
Sep 29 13:36:22 sip-proxy /usr/local/sbin/kamailio[2569]: ERROR:db_mysql:db_mysql_store_result: error while converting result
Sep 29 13:36:22 sip-proxy /usr/local/sbin/kamailio[2569]: ERROR:core:db_do_query: error while storing result
Sep 29 13:36:22 sip-proxy /usr/local/sbin/kamailio[2569]: ERROR:carrierroute:load_route_data: Failed to query database.
Sep 29 13:36:22 sip-proxy /usr/local/sbin/kamailio[2569]: ERROR:carrierroute:prepare_route_tree: could not load routing data
Sep 29 13:36:22 sip-proxy /usr/local/sbin/kamailio[2569]: ERROR:carrierroute:mod_init: could not prepare route tree
Sep 29 13:36:22 sip-proxy /usr/local/sbin/kamailio[2569]: ERROR:core:init_mod: failed to initialize module carrierroute
Sep 29 13:36:22 sip-proxy /usr/local/sbin/kamailio[2569]: ERROR:core:main: error while initializing modules