[OpenSIPS-Users] drouting MNP Lookup - extreme fragmentation

[spce at lard.at]

Hi guys,

is it possible to use the opensips drouting module as an MNP lookup tool?

I'm currently trying to use the dr_rules table for a combination of 
traditional longest match + single number MNP matching. Therefore the 
prefixes are up to 15 digits long. In my table every prefix is unique. 
shmem fragments going up extremely high after 20 minutes of loading time 
(do_routing "L"-Flag doesn't change loading time). During this time 
is_from_gw always fails. Am I doing something wrong or is the module 
just not supposed to handle so many unique routes?

8.4mio unique prefixes like this in dr_rules table:

+---------+---------+----------------+---------+----------+---------+--------+----------+--------------+-----------+-------------+
| ruleid  | groupid | prefix         | timerec | priority | routeid | 
gwlist | sort_alg | sort_profile | attrs     | description |
+---------+---------+----------------+---------+----------+---------+--------+----------+--------------+-----------+-------------+
| 8322958 | 10      | 43650          | NULL    |        0 | NULL    | 
#1551   | N        |         NULL |  MOBILE | NULL        |
| 8322959 | 10      | 43660          | NULL    |        0 | NULL    | 
#1524   | N        |         NULL |  MOBILE | NULL        |
| 8322960 | 10      | 4366100        | NULL    |        0 | NULL    | 
#1551   | N        |         NULL |  MOBILE | NULL        |
| 8322961 | 10      | 4366110        | NULL    |        0 | NULL    | 
#1551   | N        |         NULL |  MOBILE | NULL        |
| 8322962 | 10      | 4366303        | NULL    |        0 | NULL    | 
#1522   | N        |         NULL |  MOBILE | NULL        |
| 8322963 | 10      | 4366305        | NULL    |        0 | NULL    | 
#5729   | N        |         NULL |  MOBILE | NULL        |
| 8322964 | 10      | 4366306        | NULL    |        0 | NULL    | 
#1522   | N        |         NULL |  MOBILE | NULL        |
| 8322965 | 10      | 4366363        | NULL    |        0 | NULL    | 
#1522   | N        |         NULL |  MOBILE | NULL        |
| 8322966 | 10      | 43664          | NULL    |        0 | NULL    | 
#1522   | N        |         NULL |  MOBILE | NULL        |
| 8322967 | 10      | 4366565        | NULL    |        0 | NULL    | 
#1524   | N        |         NULL |  MOBILE | NULL        |
| 8322968 | 10      | 4366566        | NULL    |        0 | NULL    | 
#1524   | N        |         NULL |  MOBILE | NULL        |
| 8322969 | 10      | 4366567        | NULL    |        0 | NULL    | 
#1524   | N        |         NULL |  MOBILE | NULL        |
| 8322970 | 10      | 4366599        | NULL    |        0 | NULL    | 
#1524   | N        |         NULL |  MOBILE | NULL        |
| 8322971 | 10      | 4366600        | NULL    |        0 | NULL    | 
#1074   | N        |         NULL |  MOBILE | NULL        |
| 8322972 | 10      | 4366719        | NULL    |        0 | NULL    | 
#3555   | N        |         NULL |  MOBILE | NULL        |
| 8322973 | 10      | 4366733        | NULL    |        0 | NULL    | 
#3555   | N        |         NULL |  MOBILE | NULL        |
| 8322974 | 10      | 4366744        | NULL    |        0 | NULL    | 
#3555   | N        |         NULL |  MOBILE | NULL        |
| 8322975 | 10      | 4366766        | NULL    |        0 | NULL    | 
#3555   | N        |         NULL |  MOBILE | NULL        |
| 8322976 | 10      | 4366776        | NULL    |        0 | NULL    | 
#3555   | N        |         NULL |  MOBILE | NULL        |
| 8322977 | 10      | 4366777        | NULL    |        0 | NULL    | 
#3555   | N        |         NULL |  MOBILE | NULL        |
| 8322978 | 10      | 4366778        | NULL    |        0 | NULL    | 
#3555   | N        |         NULL |  MOBILE | NULL        |
| 8322979 | 10      | 4366779        | NULL    |        0 | NULL    | 
#3555   | N        |         NULL |  MOBILE | NULL        |
| 8322980 | 10      | 4366788        | NULL    |        0 | NULL    | 
#3555   | N        |         NULL |  MOBILE | NULL        |
| 8322981 | 10      | 436688001xxx   | NULL    |        0 | NULL    | 
#1524   | N        |         NULL |  MOBILE | NULL        |
| 8322982 | 10      | 436688064xxx   | NULL    |        0 | NULL    | 
#1746   | N        |         NULL |  MOBILE | NULL        |
| 8322983 | 10      | 436688183xxx   | NULL    |        0 | NULL    | 
#1746   | N        |         NULL |  MOBILE | NULL        |
| 8322984 | 10      | 436688269xxx   | NULL    |        0 | NULL    | 
#1746   | N        |         NULL |  MOBILE | NULL        |
| 8322985 | 10      | 436688269xxx   | NULL    |        0 | NULL    | 
#1524   | N        |         NULL |  MOBILE | NULL        |

Memory stats:

root at vie-ix-voip-sbc:/etc/opensips# opensips-cli -x mi get_statistics all
{
    "shmem:total_size": 10737418240,
    "shmem:max_used_size": 4885538240,
    "shmem:free_size": 5851889480,
    "shmem:used_size": 2771791520,
    "shmem:real_used_size": 4885528760,
    "shmem:fragments": 37744704,
    "rpmem:rpm_total_size": 0,
    "rpmem:rpm_used_size": 0,
    "rpmem:rpm_real_used_size": 0,
    "rpmem:rpm_fragments": 0,
    "rpmem:rpm_max_used_size": 0,
    "rpmem:rpm_free_size": 0,

Thanks,

Malte
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20260130/f25b4e39/attachment.html>