Intermittent of Calls

Asterisk Asterisk Support
1

Hello,

We have intermittent issue, when we call it disconnect and if try again it goes.

so I logged into asterisk box and found when this below error comes then calls drops otherwise goes well.
can someone tell me what could be the issue ?

[Jun 12 12:04:19] WARNING[3862]: res_odbc.c:658 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to mysql [mysql]…
[Jun 12 12:04:19] WARNING[3862]: res_odbc.c:762 ast_odbc_sanity_check: Connection is down attempting to reconnect…
[Jun 12 12:04:19] NOTICE[3862]: res_odbc.c:1531 odbc_obj_connect: Connecting mysql
[Jun 12 12:04:19] NOTICE[3862]: res_odbc.c:1563 odbc_obj_connect: res_odbc: Connected to mysql [mysql]
[Jun 12 12:04:19] WARNING[3862]: res_odbc.c:646 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 42S22: [MySQL][ODBC 5.1 Driver][mysqld-5.0.95]Unknown column ‘dialNumber’ in ‘where clause’ (84)
[Jun 12 12:04:19] WARNING[3862]: res_odbc.c:658 ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to mysql [mysql]…
[Jun 12 12:04:19] WARNING[3862]: res_odbc.c:762 ast_odbc_sanity_check: Connection is down attempting to reconnect…
[Jun 12 12:04:19] NOTICE[3862]: res_odbc.c:1531 odbc_obj_connect: Connecting mysql
[Jun 12 12:04:19] NOTICE[3862]: res_odbc.c:1563 odbc_obj_connect: res_odbc: Connected to mysql [mysql]
[Jun 12 12:04:19] WARNING[3862]: cel_odbc.c:727 odbc_log: Insert failed on ‘mysql:cel’. CEL failed: INSERT INTO cel (eventtype,eventtime,userdeftype,cid_name,cid_num,cid_ani,cid_rdnis,cid_dnid,exten,context,channame,appname,appdata,amaflags,accountcode,peeraccount,uniqueid,linkedid,userfield,peer) VALUES (‘HANGUP’,{ ts ‘2018-06-12 12:04:19’ },’’,’’,’’,’’,’’,‘0501481420’,‘0501481420’,‘Outgoing-manual’,‘Console/dsp’,’’,’’,3,’’,’’,‘1528805029.1467’,‘1528805029.1467’,’’,’’)
== Manager ‘lite’ logged off from 127.0.0.1

2

Do you want to use both modules CDR as well as CEL?

3

Your logs do not show any call information, post a SIP of a call that is disconnected

1 Like
4

Thanks for your reply Ambiorixg.

Please i am new into it please let me knw how can i fetch sip logs?

5

https://www.google.com/search?q=asterisk+debugging

6

https://wiki.asterisk.org/wiki/display/AST/Collecting+Debug+Information

Trace your iINVITE until the BYE request

7

please download the sip logs from this below link. as i could not upload the text file on this plat form.

8

I see a normal hangup

SIP read from UDP:172.16.10.119:35094 —>
BYE sip:0208549632@172.16.10.1:5060 SIP/2.0
Via: SIP/2.0/UDP 172.16.10.119:35094;branch=z9hG4bK-d87543-2509380a3b21b314-1–d87543-;rport
Max-Forwards: 70
Contact: sip:119@172.16.10.119:35094;rinstance=becda42ac404ef0a
To: "0208549632"sip:0208549632@172.16.10.1;tag=as54c9ee29
From: sip:119@172.16.10.119:35094;rinstance=becda42ac404ef0a;tag=811a6f7e
Call-ID: 62d97eab6b86e16c5323065c4c761860@172.16.10.1:5060
CSeq: 2 BYE
User-Agent: X-Lite release 1011s stamp 41150
Reason: SIP;description=“User Hung Up”
Content-Length: 0

9

i uploaded another logs file kindly check pls. open it into notepad.
thanks in advance.

10

Hello Experts,

Just to inform you that we found the issue, I would like to share here it may help others too.

the issue was in consistence CPU usage in Linux box, there is XORG which is consuming it. whenever CPU hits to 100% then call disconnects.

11

Generally running a GUI on a real time server is not considered a good idea.

I assume Asterisk was not being scheduled and something timed out.