it seems that when the second problem occure i have something like this is CLI :
2007-03-06 17:18:27|agi-VDADtransfer.agi|Perl Environment Dump:
2007-03-06 17:18:27|agi-VDADtransfer.agi|0|8365
2007-03-06 17:18:27|agi-VDADtransfer.agi|AGI Environment Dump:
2007-03-06 17:18:27|agi-VDADtransfer.agi| -- accountcode =
2007-03-06 17:18:27|agi-VDADtransfer.agi| -- callerid = 00347275551213
2007-03-06 17:18:27|agi-VDADtransfer.agi| -- calleridname = unknown
2007-03-06 17:18:27|agi-VDADtransfer.agi| -- callingani2 = 0
2007-03-06 17:18:27|agi-VDADtransfer.agi| -- callingpres = 0
2007-03-06 17:18:27|agi-VDADtransfer.agi| -- callingtns = 0
2007-03-06 17:18:27|agi-VDADtransfer.agi| -- callington = 0
2007-03-06 17:18:27|agi-VDADtransfer.agi| -- channel = SIP/asip-081cd5a0
2007-03-06 17:18:27|agi-VDADtransfer.agi| -- context = default
2007-03-06 17:18:27|agi-VDADtransfer.agi| -- dnid = unknown
2007-03-06 17:18:27|agi-VDADtransfer.agi| -- enhanced = 0.0
2007-03-06 17:18:27|agi-VDADtransfer.agi| -- extension = 8365
2007-03-06 17:18:27|agi-VDADtransfer.agi| -- language = en
2007-03-06 17:18:27|agi-VDADtransfer.agi| -- priority = 2
2007-03-06 17:18:27|agi-VDADtransfer.agi| -- rdnis = unknown
2007-03-06 17:18:27|agi-VDADtransfer.agi| -- request = agi-VDADtransfer.agi
2007-03-06 17:18:27|agi-VDADtransfer.agi| -- type = SIP
2007-03-06 17:18:27|agi-VDADtransfer.agi| -- uniqueid = 1173194306.53
2007-03-06 17:18:27|agi-VDADtransfer.agi|AGI Variables: |1173194306.53|SIP/asip-081cd5a0|8365|SIP|00347275551213|unknown|2|
2007-03-06 17:18:27|agi-VDADtransfer.agi|+++++ VDAD START : |213|2007-03-06 17:18:27|1.2.14|2|
2007-03-06 17:18:27|agi-VDADtransfer.agi|-- VDAD : |0E0|update of vac table: 00347275551213
|UPDATE vicidial_auto_calls set uniqueid='1173194306.53', channel='SIP/asip-081cd5a0',status='LIVE',stage='LIVE-0' where callerid='00347275551213' order by call_time desc limit 1;|
2007-03-06 17:18:27|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='194.113.165.28' and campaign_id = '' and call_time < "" and lead_id != '';|
2007-03-06 17:18:27|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: |194.113.165.28
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='213',uniqueid='1173194306.53', channel='SIP/asip-081cd5a0', callerid='00347275551213' where status = 'READY' and server_ip='194.113.165.28' and campaign_id='' and last_update_time > '19700101015955' limit 1;|
2007-03-06 17:18:27|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-06 17:18:27|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='194.113.165.28' and campaign_id = '' and call_time < "" and lead_id != '';|
2007-03-06 17:18:27|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: |194.113.165.28
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='213',uniqueid='1173194306.53', channel='SIP/asip-081cd5a0', callerid='00347275551213' where status = 'READY' and server_ip='194.113.165.28' and campaign_id='' and last_update_time > '19700101015955' limit 1;|
2007-03-06 17:18:27|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-06 17:18:27|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='194.113.165.28' and campaign_id = '' and call_time < "" and lead_id != '';|
2007-03-06 17:18:27|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: |194.113.165.28
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='213',uniqueid='1173194306.53', channel='SIP/asip-081cd5a0', callerid='00347275551213' where status = 'READY' and server_ip='194.113.165.28' and campaign_id='' and last_update_time > '19700101015955' limit 1;|
2007-03-06 17:18:27|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-06 17:18:27|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='194.113.165.28' and campaign_id = '' and call_time < "" and lead_id != '';|
2007-03-06 17:18:27|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: |194.113.165.28
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='213',uniqueid='1173194306.53', channel='SIP/asip-081cd5a0', callerid='00347275551213' where status = 'READY' and server_ip='194.113.165.28' and campaign_id='' and last_update_time > '19700101015955' limit 1;|
2007-03-06 17:18:27|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-06 17:18:27|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='194.113.165.28' and campaign_id = '' and call_time < "" and lead_id != '';|
2007-03-06 17:18:27|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: |194.113.165.28
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='213',uniqueid='1173194306.53', channel='SIP/asip-081cd5a0', callerid='00347275551213' where status = 'READY' and server_ip='194.113.165.28' and campaign_id='' and last_update_time > '19700101015955' limit 1;|
2007-03-06 17:18:27|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-06 17:18:27|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='194.113.165.28' and campaign_id = '' and call_time < "" and lead_id != '';|
2007-03-06 17:18:27|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: |194.113.165.28
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='213',uniqueid='1173194306.53', channel='SIP/asip-081cd5a0', callerid='00347275551213' where status = 'READY' and server_ip='194.113.165.28' and campaign_id='' and last_update_time > '19700101015955' limit 1;|
2007-03-06 17:18:27|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-06 17:18:27|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='194.113.165.28' and campaign_id = '' and call_time < "" and lead_id != '';|
2007-03-06 17:18:27|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: |194.113.165.28
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='213',uniqueid='1173194306.53', channel='SIP/asip-081cd5a0', callerid='00347275551213' where status = 'READY' and server_ip='194.113.165.28' and campaign_id='' and last_update_time > '19700101015955' limit 1;|
2007-03-06 17:18:27|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-06 17:18:27|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='194.113.165.28' and campaign_id = '' and call_time < "" and lead_id != '';|
2007-03-06 17:18:27|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: |194.113.165.28
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='213',uniqueid='1173194306.53', channel='SIP/asip-081cd5a0', callerid='00347275551213' where status = 'READY' and server_ip='194.113.165.28' and campaign_id='' and last_update_time > '19700101015955' limit 1;|
2007-03-06 17:18:27|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
== Manager 'sendcron' logged off from 127.0.0.1
2007-03-06 17:18:27|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='194.113.165.28' and campaign_id = '' and call_time < "" and lead_id != '';|
2007-03-06 17:18:27|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: |194.113.165.28
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='213',uniqueid='1173194306.53', channel='SIP/asip-081cd5a0', callerid='00347275551213' where status = 'READY' and server_ip='194.113.165.28' and campaign_id='' and last_update_time > '19700101015955' limit 1;|
2007-03-06 17:18:27|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-06 17:18:27|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='194.113.165.28' and campaign_id = '' and call_time < "" and lead_id != '';|
2007-03-06 17:18:27|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: |194.113.165.28
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='213',uniqueid='1173194306.53', channel='SIP/asip-081cd5a0', callerid='00347275551213' where status = 'READY' and server_ip='194.113.165.28' and campaign_id='' and last_update_time > '19700101015955' limit 1;|
2007-03-06 17:18:27|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-06 17:18:27|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='194.113.165.28' and campaign_id = '' and call_time < "" and lead_id != '';|
2007-03-06 17:18:27|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: |194.113.165.28
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='213',uniqueid='1173194306.53', channel='SIP/asip-081cd5a0', callerid='00347275551213' where status = 'READY' and server_ip='194.113.165.28' and campaign_id='' and last_update_time > '19700101015955' limit 1;|
2007-03-06 17:18:27|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-06 17:18:27|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='194.113.165.28' and campaign_id = '' and call_time < "" and lead_id != '';|
2007-03-06 17:18:27|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: |194.113.165.28
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='213',uniqueid='1173194306.53', channel='SIP/asip-081cd5a0', callerid='00347275551213' where status = 'READY' and server_ip='194.113.165.28' and campaign_id='' and last_update_time > '19700101015955' limit 1;|
2007-03-06 17:18:27|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-06 17:18:27|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='194.113.165.28' and campaign_id = '' and call_time < "" and lead_id != '';|
2007-03-06 17:18:27|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: |194.113.165.28
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='213',uniqueid='1173194306.53', channel='SIP/asip-081cd5a0', callerid='00347275551213' where status = 'READY' and server_ip='194.113.165.28' and campaign_id='' and last_update_time > '19700101015955' limit 1;|
2007-03-06 17:18:27|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-06 17:18:27|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='194.113.165.28' and campaign_id = '' and call_time < "" and lead_id != '';|
2007-03-06 17:18:27|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: |194.113.165.28
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='213',uniqueid='1173194306.53', channel='SIP/asip-081cd5a0', callerid='00347275551213' where status = 'READY' and server_ip='194.113.165.28' and campaign_id='' and last_update_time > '19700101015955' limit 1;|
2007-03-06 17:18:27|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-06 17:18:27|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='194.113.165.28' and campaign_id = '' and call_time < "" and lead_id != '';|
2007-03-06 17:18:27|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: |194.113.165.28
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='213',uniqueid='1173194306.53', channel='SIP/asip-081cd5a0', callerid='00347275551213' where status = 'READY' and server_ip='194.113.165.28' and campaign_id='' and last_update_time > '19700101015955' limit 1;|
2007-03-06 17:18:27|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-06 17:18:27|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='194.113.165.28' and campaign_id = '' and call_time < "" and lead_id != '';|
2007-03-06 17:18:27|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: |194.113.165.28
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='213',uniqueid='1173194306.53', channel='SIP/asip-081cd5a0', callerid='00347275551213' where status = 'READY' and server_ip='194.113.165.28' and campaign_id='' and last_update_time > '19700101015955' limit 1;|
2007-03-06 17:18:27|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-06 17:18:27|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='194.113.165.28' and campaign_id = '' and call_time < "" and lead_id != '';|
2007-03-06 17:18:27|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: |194.113.165.28
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='213',uniqueid='1173194306.53', channel='SIP/asip-081cd5a0', callerid='00347275551213' where status = 'READY' and server_ip='194.113.165.28' and campaign_id='' and last_update_time > '19700101015955' limit 1;|
2007-03-06 17:18:27|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-06 17:18:27|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='194.113.165.28' and campaign_id = '' and call_time < "" and lead_id != '';|
2007-03-06 17:18:27|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: |194.113.165.28
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='213',uniqueid='1173194306.53', channel='SIP/asip-081cd5a0', callerid='00347275551213' where status = 'READY' and server_ip='194.113.165.28' and campaign_id='' and last_update_time > '19700101015955' limit 1;|
2007-03-06 17:18:27|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-06 17:18:27|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='194.113.165.28' and campaign_id = '' and call_time < "" and lead_id != '';|
2007-03-06 17:18:27|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: |194.113.165.28
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='213',uniqueid='1173194306.53', channel='SIP/asip-081cd5a0', callerid='00347275551213' where status = 'READY' and server_ip='194.113.165.28' and campaign_id='' and last_update_time > '19700101015955' limit 1;|
2007-03-06 17:18:27|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-06 17:18:27|agi-VDADtransfer.agi||SELECT count(*) FROM vicidial_auto_calls where status = 'LIVE' and server_ip='194.113.165.28' and campaign_id = '' and call_time < "" and lead_id != '';|
2007-03-06 17:18:27|agi-VDADtransfer.agi|-- VDAD get agent: |0E0|update of vla table: |194.113.165.28
|UPDATE vicidial_live_agents set status='QUEUE',lead_id='213',uniqueid='1173194306.53', channel='SIP/asip-081cd5a0', callerid='00347275551213' where status = 'READY' and server_ip='194.113.165.28' and campaign_id='' and last_update_time > '19700101015955' limit 1;|
2007-03-06 17:18:27|agi-VDADtransfer.agi|NNNNNNNNNN No agent record found!!!
2007-03-06 17:18:38|agi-VDADtransfer.agi||SELECT voicemail_ext FROM vicidial_campaigns where campaign_id = '' limit 1;|
2007-03-06 17:18:38|agi-VDADtransfer.agi|-- VDAD call_hungup timout: |VH0306171838||SIP/asip-081cd5a0|insert to vicidial_manager
2007-03-06 17:18:38|agi-VDADtransfer.agi|-- VDAD vac record deleted: |0E0||
2007-03-06 17:18:38|agi-VDADtransfer.agi||UPDATE vicidial_log set status='DROP',end_epoch='1173194318',length_in_sec='10' where uniqueid = '1173194306.53';|
2007-03-06 17:18:38|agi-VDADtransfer.agi|-- VDAD vicidial_log update: |0E0|1173194306.53
2007-03-06 17:18:38|agi-VDADtransfer.agi||UPDATE vicidial_list set status='DROP' where lead_id = '213';|
2007-03-06 17:18:38|agi-VDADtransfer.agi|-- VDAD vicidial_list update: |1|213
-- AGI Script agi-VDADtransfer.agi completed, returning 0
-- Executing AGI("SIP/asip-081cd5a0", "agi-VDADtransfer.agi|8365") in new stack
-- Launched AGI Script /var/lib/asterisk/agi-bin/agi-VDADtransfer.agi
== Parsing '/etc/asterisk/manager.conf': Found
== Manager 'sendcron' logged on from 127.0.0.1
== Spawn extension (default, 8365, 3) exited non-zero on 'SIP/asip-081cd5a0'
-- Executing DeadAGI("SIP/asip-081cd5a0", "agi://127.0.0.1:4577/call_log") in new stack
-- AGI Script
agi://127.0.0.1:4577/call_log completed, returning 0
-- Executing DeadAGI("SIP/asip-081cd5a0", "agi://127.0.0.1:4577/VD_hangup--HVcauses--PRI-----NODEBUG-----0---------------)") in new stack
-- AGI Script
agi://127.0.0.1:4577/VD_hangup--HVcause ... ----------) completed, returning 0