Yes, using startup route in my routing script and running DB query. This
kind of warning I didn't face using 1.6 and 1.8 opensips versions but 2.2.2.

Will you recommend async statement for my current routing (see below) for
the startup?

startup_route
{
    $var(res) = 1;
    $avp(tmp) = "1";
   # $var(x) = 0;
    while($var(res) > 0)
    {
        $var(res) = avp_db_query("SELECT Distinct One800, dnis FROM
DNIS_Mapping where One800 > $avp(tmp) order by One800;", "$avp(One800),
$avp(dnis)");
        if($var(res) >= 0)
        {
                $var(i) = 0;
                while($(avp(One800)[$var(i)]) != "NULL")
                {
                        cache_store("local", "DNIS_$(avp(dnis)[$var(i)])",
"$(avp(One800)[$var(i)])");
                        $avp(tmp) = $(avp(One800)[$var(i)]);
                 #       $var(x) = $var(x) + 1;
                        $(avp(One800)[$var(i)]) = "NULL";
                        $var(i) = $var(i) + 1;
                #       xlog("$var(x) : $(avp(s:dnis)[$var(i)])");
                }
        }
    }
}


On Tue, Jan 24, 2017 at 6:38 AM, Bogdan-Andrei Iancu <bog...@opensips.org>
wrote:

> Hi Ahmed,
>
> So, the warnings pop up ONLY during startup sequence.  Do you use startup
> route or any module performing mem caching of some DB table (drouting,
> permission, etc) ? Usually, the first UDP child is doing some heavy lifting
> during startup.
>
> Regards,
>
> Bogdan-Andrei Iancu
> OpenSIPS Founder and Developerhttp://www.opensips-solutions.com
>
> On 01/19/2017 06:01 PM, Ahmed Munir wrote:
>
> Hi Razvan,
>
> During starting up the opensips service, I see the first opensips child
> process (pid"11172) consumes CPU process to 70-80% and later drop downs to
> 0.3 - 0.0 % CPU per core. See below;
>
> [root@qorblpsisprxyd1 ~]# top -c -u opensips
> top - 10:49:54 up 76 days, 23:31,  5 users,  load average: 0.00, 0.00, 0.00
> Tasks: 229 total,   1 running, 228 sleeping,   0 stopped,   0 zombie
> Cpu(s):  0.0%us,  0.1%sy,  0.0%ni, 99.9%id,  0.0%wa,  0.0%hi,  0.0%si,
> 0.0%st
> Mem:  65964364k total,  2568124k used, 63396240k free,   180220k buffers
> Swap:  1023996k total,        0k used,  1023996k free,  1226104k cached
>
>   PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
> 11177 opensips  20   0  165m 5696 4528 S  0.3  0.0   0:00.23
> /usr/sbin/opensips -P /var/run/opensips.pid -m 64 -u opensips -g opensips
> 11187 opensips  20   0  165m 5628 4460 S  0.3  0.0   0:00.41
> /usr/sbin/opensips -P /var/run/opensips.pid -m 64 -u opensips -g opensips
> 11166 opensips  20   0  165m 6892 5752 S  0.0  0.0   0:00.23
> /usr/sbin/opensips -P /var/run/opensips.pid -m 64 -u opensips -g opensips
> 11168 opensips  20   0  165m 1980  840 S  0.0  0.0   0:00.00
> /usr/sbin/opensips -P /var/run/opensips.pid -m 64 -u opensips -g opensips
> 11169 opensips  20   0  165m 1464  328 S  0.0  0.0   0:00.53
> /usr/sbin/opensips -P /var/run/opensips.pid -m 64 -u opensips -g opensips
> 11171 opensips  20   0  165m 1640  504 S  0.0  0.0   0:00.15
> /usr/sbin/opensips -P /var/run/opensips.pid -m 64 -u opensips -g opensips
> 11172 opensips  20   0  166m  40m  38m S  0.0  0.1   0:02.61
> /usr/sbin/opensips -P /var/run/opensips.pid -m 64 -u opensips -g opensips
> 11174 opensips  20   0  165m 6304 5136 S  0.0  0.0   0:00.24
> /usr/sbin/opensips -P /var/run/opensips.pid -m 64 -u opensips -g opensips
> 11175 opensips  20   0  165m 5884 4716 S  0.0  0.0   0:00.22
> /usr/sbin/opensips -P /var/run/opensips.pid -m 64 -u opensips -g opensips
> 11179 opensips  20   0  165m 7660 6492 S  0.0  0.0   0:00.27
> /usr/sbin/opensips -P /var/run/opensips.pid -m 64 -u opensips -g opensips
> 11181 opensips  20   0  165m 7756 6588 S  0.0  0.0   0:00.33
> /usr/sbin/opensips -P /var/run/opensips.pid -m 64 -u opensips -g opensips
> 11183 opensips  20   0  165m 5520 4352 S  0.0  0.0   0:00.34
> /usr/sbin/opensips -P /var/run/opensips.pid -m 64 -u opensips -g opensips
> 11185 opensips  20   0  165m 7336 6168 S  0.0  0.0   0:00.36
> /usr/sbin/opensips -P /var/run/opensips.pid -m 64 -u opensips -g opensips
> 11189 opensips  20   0  165m 7320 6152 S  0.0  0.0   0:00.36
> /usr/sbin/opensips -P /var/run/opensips.pid -m 64 -u opensips -g opensips
> 11190 opensips  20   0  165m 4688 3528 S  0.0  0.0   0:00.30
> /usr/sbin/opensips -P /var/run/opensips.pid -m 64 -u opensips -g opensips
>
> [root@qorblpsisprxyd1 ~]# opensipsctl fifo ps
> Process::  ID=0 PID=11166 Type=attendant
> Process::  ID=1 PID=11168 Type=MI FIFO
> Process::  ID=2 PID=11169 Type=time_keeper
> Process::  ID=3 PID=11171 Type=timer
> Process::  ID=4 PID=11172 Type=SIP receiver udp:10.3.120.94:5060
> Process::  ID=5 PID=11174 Type=SIP receiver udp:10.3.120.94:5060
> Process::  ID=6 PID=11175 Type=SIP receiver udp:10.3.120.94:5060
> Process::  ID=7 PID=11177 Type=SIP receiver udp:10.3.120.94:5060
> Process::  ID=8 PID=11179 Type=SIP receiver udp:10.3.120.94:5060
> Process::  ID=9 PID=11181 Type=SIP receiver udp:10.3.120.94:5060
> Process::  ID=10 PID=11183 Type=SIP receiver udp:10.3.120.94:5060
> Process::  ID=11 PID=11185 Type=SIP receiver udp:10.3.120.94:5060
> Process::  ID=12 PID=11187 Type=SIP receiver udp:10.3.120.94:5060
> Process::  ID=13 PID=11189 Type=SIP receiver udp:10.3.120.94:5060
> Process::  ID=14 PID=11190 Type=Timer handler
>
> OpenSIPs used by each CPU processor;
>
> [root@qorblpsisprxyd1 ~]# ps -o pid,psr,comm -C opensips
>   PID PSR COMMAND
> 11166   0 opensips
> 11168   2 opensips
> 11169   6 opensips
> 11171   5 opensips
> 11172   5 opensips
> 11174   5 opensips
> 11175   5 opensips
> 11177   5 opensips
> 11179   7 opensips
> 11181   1 opensips
> 11183   0 opensips
> 11185   2 opensips
> 11187   5 opensips
> 11189   5 opensips
> 11190   4 opensips
>
>
>


-- 
Regards,

Ahmed Munir Chohan
_______________________________________________
Users mailing list
Users@lists.opensips.org
http://lists.opensips.org/cgi-bin/mailman/listinfo/users

Reply via email to