603 call declined

I have 2 asterisk server and it use realtime mysql database.
and sometimes call successfull but some time declined…

when decline happen??

    -- Executing [01045659799@from-sip:1] Dial("SIP/01048596288-000008a3", "SIP/,60")
[2014-08-07 15:24:25] WARNING[5254][C-00000572]: app_dial.c:2330 dial_exec_full: Dial argument takes format (technology/resource)
  == Spawn extension (from-sip, 01045659799, 1) exited non-zero on 'SIP/01048596288-000008a3'
    -- Executing [h@from-sip:1] Dial("SIP/01048596288-000008a3", "SIP/,60")
[2014-08-07 15:24:25] WARNING[5254][C-00000572]: app_dial.c:2330 dial_exec_full: Dial argument takes format (technology/resource)
  == Spawn extension (from-sip, h, 1) exited non-zero on 'SIP/01048596288-000008a3'
    -- Registered SIP '01045630699' at 223.62.172.1:38385
    -- Registered SIP '01073980274' at 59.86.236.191:55516
       > 0x7f0a33e726e0 -- Probation passed - setting RTP source address to 117.111.2.19:6576
[2014-08-07 15:24:25] WARNING[5247][C-00000570]: app_voicemail.c:6321 leave_voicemail: No entry in voicemail config file for '01035807641'
       > 0x7f0a33e726e0 -- Probation passed - setting RTP source address to 117.111.2.19:6576
    -- Executing [01035807641@from-sip:3] hangup("SIP/01091326384-0000089f", "")
  == Spawn extension (from-sip, 01035807641, 3) exited non-zero on 'SIP/01091326384-0000089f'
    -- Executing [h@from-sip:1] Dial("SIP/01091326384-0000089f", "SIP/,60")
[2014-08-07 15:24:25] WARNING[5247][C-00000570]: app_dial.c:2330 dial_exec_full: Dial argument takes format (technology/resource)
  == Spawn extension (from-sip, h, 1) exited non-zero on 'SIP/01091326384-0000089f'
    -- Registered SIP '01022044407' at 223.62.163.18:45353
    -- Registered SIP '01087251868' at 223.62.179.60:7981
    -- Registered SIP '01085885417' at 14.40.52.54:38914
    -- Registered SIP '01033425179' at 115.90.161.2:44274
       > Saved useragent "LinphoneAndroid/1.0.20 (belle-sip/1.3.1)" for peer 01033425179

succeful call leave
– Executing [01072230919@from-sip:1] Dial(“SIP/01086237908-00000b39”, “SIP/01072230919,60”)

and declined make this log
– Executing [h@from-sip:1] Dial(“SIP/01086237908-00000b39”, “SIP/,60”)

how I can fix it??


SIP/,60

There is no resource.

SIP/,60

There is no resource.

no resource? it means not user in asterisk or lack of server resource like cpu ?

one time i can call and one time i can’t call…

-------this log is warnning but I can call -------------
WARNING[16704][C-0000003b]: chan_sip.c:11217 process_sdp_a_audio: Got Opus useinbandfec=1
– Executing [5000@from-sip:1] Dial(“SIP/5001-0000006e”, “SIP/5000,60”)
== Using SIP RTP CoS mark 5
– Called SIP/5000
– SIP/5000-0000006f is ringing
== Spawn extension (from-sip, 5000, 1) exited non-zero on ‘SIP/5001-0000006e’
– Executing [h@from-sip:1] Dial(“SIP/5001-0000006e”, “SIP/,60”)

-------this log is warnning and I can’t call -------------
– Executing [01029434257@from-sip:1] Dial(“SIP/01096089623-00001ad3”, “SIP/,60”)
[Aug 7 21:51:03] WARNING[15141][C-0000118e]: app_dial.c:2330 dial_exec_full: Dial argument takes format (technology/resource)
== Spawn extension (from-sip, 01029434257, 1) exited non-zero on ‘SIP/01096089623-00001ad3’
– Executing [h@from-sip:1] Dial(“SIP/01096089623-00001ad3”, “SIP/,60”)
[Aug 7 21:51:03] WARNING[15141][C-0000118e]: app_dial.c:2330 dial_exec_full: Dial argument takes format (technology/resource)
== Spawn extension (from-sip, h, 1) exited non-zero on ‘SIP/01096089623-00001ad3’

… help me…

you mean i need more memory or something?

You need paid consultancy (Biz and Jobs forum), or you need to complete your basic learning on how Asterisk dialplans work.

the-asterisk-book.com/1.6/applik … -dial.html
the-asterisk-book.com/1.6/einleitung-regex.html

oh thanks but I asked the resource means no user…

I think the log says no receiver on dialplan. is it right?..

but my situation is…

  1. caller(5000) to receiver(5001) when no other calls.
    it works well no decline

  2. caller(5000) to receiver(5001) when many other calls or registration.
    2 works well but 1 make decline…

but i don’t think lack of memory or cpu because my server htop is this…

I use asterisk realtime mysql
is it possible the delay time of asterisk searching receiver on mysql make this situation?

I found something…

there is so many account about 1000000 user on my asteriskrealtime database
and I made another asterisk server and there are 3000 user.

and first server have decline problem and another server don’t.

So I guess big databases make this problem.

and I moved database to 3000 server per table.

so I found extension database make this problem… it is like this…

mysql> select * from extensions limit 20;
±----±---------±------------±---------±--------------±--------------------------+
| id | context | exten | priority | app | appdata |
±----±---------±------------±---------±--------------±--------------------------+
| 257 | from-sip | 12121111111 | 1 | Dial | SIP/1000,300 |
| 258 | from-sip | 12122222222 | 1 | Dial | SIP/2000,60 |
| 259 | from-sip | _X. | 1 | Dial | SIP/${EXTEN},30 |
| 260 | from-sip | _9X. | 1 | Dial | SIP/${EXTEN:1}@deltathree |
| 261 | from-sip | _X. | 2 | VoiceMail | ${EXTEN}@from-sip |
| 262 | from-sip | _X. | 3 | hangup | |
| 263 | from-sip | _*0 | 1 | VoiceMailMain | ${CALLERID(num)}@from-sip |
| 264 | from-sip | 12127777777 | 1 | Queue | my_queue |
| 265 | from-sip | 12129999999 | 1 | MeetMe | my_conf |
| 271 | from-sip | exten | 1 | Dial | SIP/60 |
| 277 | from-sip | 01060006000 | 1 | Dial | SIP/01060006000,60 |
| 276 | from-sip | 01036505000 | 1 | Dial | SIP/01036505000,60 |
| 278 | from-sip | 01060006001 | 1 | Dial | SIP/01060006001,60 |
| 279 | from-sip | 3000 | 1 | Dial | SIP/3000,60 |
| 280 | from-sip | 5000 | 1 | Dial | SIP/5000,60 |
| 281 | from-sip | 01070007000 | 1 | Dial | SIP/01070007000,60 |
| 282 | from-sip | 01060006003 | 1 | Dial | SIP/01060006003,60 |
| 283 | from-sip | 01060006005 | 1 | Dial | SIP/01060006005,60 |
| 284 | from-sip | 5001 | 1 | Dial | SIP/5001,60 |
| 285 | from-sip | 5002 | 1 | Dial | SIP/5002,60 |
±----±---------±------------±---------±--------------±--------------------------+

but I can’t fix this problem…

I think if I will make my database like this i can fix this problem… is it right?
±----±---------±------±---------±--------------±--------------------------+
| id | context | exten | priority | app | appdata |
±----±---------±------±---------±--------------±--------------------------+
| 263 | from-sip | _*0 | 1 | VoiceMailMain | ${CALLERID(num)}@from-sip |
| 260 | from-sip | _9X. | 1 | Dial | SIP/${EXTEN:1}@deltathree |
| 259 | from-sip | _X. | 1 | Dial | SIP/${EXTEN},30 |
±----±---------±------±---------±--------------±--------------------------+