[asterisk-bugs] [JIRA] (ASTERISK-27544) have 6 asterisk servers, working perfectly, suddenly all stop responding or delaying the responses for a few minutes causing havoc

[Joshua Colp (JIRA)]

     [ https://issues.asterisk.org/jira/browse/ASTERISK-27544?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Joshua Colp updated ASTERISK-27544:
-----------------------------------

    Status: Waiting for Feedback  (was: Triage)

Your trace disagrees that the database is only used for queues:

{noformat}
[Dec 31 11:22:50] DEBUG[21533][C-00114013] res_config_mysql.c: MySQL RealTime: Connection okay.
[Dec 31 11:22:50] DEBUG[21533][C-00114013] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM asterisk_sip WHERE name = 'freeswitch' AND host = 'dynamic'
[Dec 31 11:22:50] DEBUG[21533][C-00114013] res_config_mysql.c: MySQL RealTime: Connection okay.
[Dec 31 11:22:50] DEBUG[21533][C-00114013] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM asterisk_sip WHERE name = 'freeswitch'
[Dec 31 11:22:50] DEBUG[21533][C-00114013] res_config_mysql.c: MySQL RealTime: Connection okay.
[Dec 31 11:22:50] DEBUG[21533][C-00114013] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM asterisk_sip WHERE host = '10.12.77.39' AND callbackextension = 'trunk-+22222000000' AND port = '5060'
[Dec 31 11:22:50] DEBUG[21533][C-00114013] res_config_mysql.c: MySQL RealTime: Connection okay.
[Dec 31 11:22:50] DEBUG[21533][C-00114013] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM asterisk_sip WHERE host = '10.12.77.39' AND port = '5060'
[Dec 31 11:22:50] DEBUG[21533][C-00114013] res_config_mysql.c: MySQL RealTime: Connection okay.
[Dec 31 11:22:50] DEBUG[21533][C-00114013] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM asterisk_sip WHERE ipaddr = '10.12.77.39' AND port = '5060'
[Dec 31 11:22:50] DEBUG[21533][C-00114013] res_config_mysql.c: MySQL RealTime: Connection okay.
[Dec 31 11:22:50] DEBUG[21533][C-00114013] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM asterisk_sip WHERE host = '10.12.77.39' AND insecure LIKE '%port%' ORDER BY host
[Dec 31 11:22:50] DEBUG[21533][C-00114013] res_config_mysql.c: MySQL RealTime: Connection okay.
[Dec 31 11:22:50] DEBUG[21533][C-00114013] res_config_mysql.c: MySQL RealTime: Retrieve SQL: SELECT * FROM asterisk_sip WHERE ipaddr = '10.12.77.39' AND insecure LIKE '%port%' ORDER BY ipaddr
{noformat}

Those queries are in regards to chan_sip.

> have 6 asterisk servers, working perfectly, suddenly all stop responding or delaying the responses for a few minutes causing havoc
> ----------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: ASTERISK-27544
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-27544
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Channels/chan_sip/General
>    Affects Versions: 13.12.0
>         Environment: Description:    Debian GNU/Linux 8.7 (jessie)
> Release:        8.7
> Codename:       jessie
> Asterisk 13.12.1
>            Reporter: Andres Collazos
>            Assignee: Andres Collazos
>         Attachments: Capture.JPG, trace.txt
>
>
> we have 6 Freeswitches and 6 asterisk processing calls perfectly for weeks but randomly all servers stop responding for several minutes.
> Asterisk does not crash it looks like it is slowed down.
> we are using chansip.
> there is no sign of over load since asterisk is only using 10% load.
> no high memory utilization.
> we still puzzling about this issue since it happens in all asterisk servers at the same time.



--
This message was sent by Atlassian JIRA
(v6.2#6252)