[SR-Users] Intermittent start up issue

Mon Jan 2 12:31:34 CET 2012

Hello,

On 1/2/12 12:24 PM, Ali Jawad wrote:
> Hi Daniel
> Running on a LAN with no firewalls enabled,

limits can be from kernel, selinix, mysql server  a.s.o. not only from 
firewalls.

>   will try you suggestion
> though first thing tomorrow morning, what are the implications of
> running children=1 ?

This will create only one worker process (not advisable for production 
in long term, just for testing) -- in this way there should be very few 
mysql connections opened, revealing if there is a problem or not with 
the number of connections and the short period to create them.

Cheers,
Daniel
> Thanks
>
> On Mon, Jan 2, 2012 at 2:03 PM, Daniel-Constantin Mierla
> <miconda at gmail.com>  wrote:
>> Hello,
>>
>> check also for limits in the system/firewall, maybe there are limits on new
>> connections per second. Try with children=1 and see if it happens again, if
>> not, then it is something that blocks many new connections in short time.
>>
>> Cheers,
>> Daniel
>>
>>
>> On 1/2/12 5:31 AM, Sammy Govind wrote:
>>
>> Hi,
>> Its all upto you then, that's an intermittent issue and information is not
>> complete to trace the issue. Did you see the same Errors every time it fails
>> !?
>>
>> --
>> Regards
>> Sammy
>>
>> On Sun, Jan 1, 2012 at 10:06 PM, Ali Jawad<ali.jawad at splendor.net>  wrote:
>>> Hi
>>> Thanks for your input, but as said this works at times yes and times
>>> now so I am not sure it is a definite DB issue, the servers are in the
>>> same LAN, and there are other modules that use the DB string that work
>>> when launched before this one while this one does not work.
>>> Regards
>>>
>>> On Sun, Jan 1, 2012 at 4:13 PM, Sammy Govind<govoiper at gmail.com>  wrote:
>>>> Hi,
>>>> forget the whole list of errors and just resolve the DB connectivity
>>>> between
>>>> the Kamailio server and DB server first .
>>>>
>>>>> 27(24762) ERROR: db_mysql [km_my_con.c:109]: driver error: Can't
>>>>> connect to MySQL server on 'xxxxxxxxx' (4)
>>>>
>>>> try connecting to the remote DB server 'xxxxxxxxx' from linux shell i.e
>>>>
>>>> # mysql -u<user>  -p<passwd>  -h 'xxxxxxxxx'
>>>>
>>>> Regards,
>>>> Sammy
>>>>
>>>>
>>>> On Fri, Dec 30, 2011 at 3:33 PM, Ali Jawad<ali.jawad at splendor.net>
>>>> wrote:
>>>>> Hi All
>>>>> I have tried the below with Kamailio 3.1.0 and 3.2.1. the problem is
>>>>> that Kamailio at times fails to start up for no obvious reasons, I.e.
>>>>> in 10 restarts Kamailio might fail to start 3,0 or 5 times. Te debug
>>>>> log "level 2 " shows the following :
>>>>>
>>>>> 27(24762) ERROR: db_mysql [km_my_con.c:109]: driver error: Can't
>>>>> connect to MySQL server on 'xxxxxxxxx' (4)
>>>>> 27(24762) ERROR:<core>  [db.c:303]: could not add connection to the
>>>>> pool27(24762) ERROR: group [group.c:211]: unable to connect to the
>>>>> database
>>>>> 27(24762) ERROR:<core>  [sr_module.c:889]: init_mod_child(): Error
>>>>> while initializing module group
>>>>> (/usr/local/kamailio/lib/kamailio/modules_k/group.so)
>>>>> 27(24762) ERROR:<core>  [pt.c:481]: ERROR: fork_tcp_process():
>>>>> init_child failed for process 27, pid 24762, "tcp receiver child=1"
>>>>>
>>>>> and then
>>>>>
>>>>>
>>>>> 30(24765) :<core>  [pass_fd.c:293]: ERROR: receive_fd: EOF on 45
>>>>>   0(24735) ALERT:<core>  [main.c:748]: child process 24762 exited
>>>>> normally, status=255
>>>>>   0(24735) INFO:<core>  [main.c:766]: INFO: terminating due to SIGCHLD
>>>>>
>>>>> The problem happens on 4 different servers, I did try to compile more
>>>>> than once, the servers are 32 Bit CentOS 5.6. The connection to the
>>>>> database is monitored and there are no issues with connecting to the
>>>>> DB "it works at times and times not for Kamailio so a user/pwd issue
>>>>> is not likely to cause this, manual cnnect worked", config file errors
>>>>> are not found.
>>>>>
>>>>> I did also check max no of connections on MySQL server which is set to
>>>>> 500 on the server and only 100 cons are used. The group module uses
>>>>> the same connection string as other modules  which is predefined  and
>>>>> there are other modules that access the db before the group module and
>>>>> those do not have a problem.
>>>>>
>>>>> Please advice.
>>>>>
>>>>> Regards
>>>>>
>>>>> _______________________________________________
>>>>> 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
>>>>
>>>>
>>>> _______________________________________________
>>>> 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
>>>>
>>>
>>>
>>> --
>>> Ali Jawad
>>> Information Systems Manager
>>> Splendor Telecom (www.splendor.net)
>>> Beirut, Lebanon
>>> Phone: +9611373725/ext 116
>>> FAX: +9611375554
>>>
>>> _______________________________________________
>>> 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
>>
>>
>>
>> _______________________________________________
>> 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
>>
>>
>> --
>> Daniel-Constantin Mierla -- http://www.asipto.com
>> http://linkedin.com/in/miconda -- http://twitter.com/miconda
>>
>>
>> _______________________________________________
>> 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
>>
>
>

-- 
Daniel-Constantin Mierla -- http://www.asipto.com
http://linkedin.com/in/miconda -- http://twitter.com/miconda