Clear old records from vicidial_auto_calls

[aster1]

I really get lot of problem on auto dial because old calls arent being removed from vicidial_auto_calls table . I made a thread on this before and as per matt's suggestion cleaning vicidial_auto_calls always gets problem solved . Suppose i have 4 agent and dial level 7 and if 12 old records are struck in dialer then i get only 28-12=16 calls made until i clear table myself . This may not be vicidial problem really ( maybe due to lag in my asterisk server and voip provider ) .
What i want to know is that is it safe to put a cron script to remove records older than 15 minutes and stage = START from that table .
What would be mysql query to delete records older than 15 minutes ?

[mflorell]

What VDAD extension do you use?

Do you have call_log entries on the h, 8365, 91NXXNXXXXXX extensions?

Do you see each of them running for every call?

[aster1]

i am using 8369 with am detection .

exten => 8369,1,AGI(agi://127.0.0.1:4577/call_log)
exten => 8369,2,AMD(2500|1500|300|5000|120|50|5|256)
exten => 8369,3,AGI(VD_amd.agi,${EXTEN})
exten => 8369,4,AGI(agi-VDAD_LB_transfer.agi,${EXTEN})
exten => 8369,5,AGI(agi-VDAD_LB_transfer.agi,${EXTEN})
exten => 8369,6,AGI(agi-VDAD_LB_transfer.agi,${EXTEN})
exten => 8369,7,Hangup

exten => h,1,DeadAGI(agi://127.0.0.1:4577/call_log)
exten =>h,2,DeadAGI(agi://127.0.0.1:4577/VD_hangup--HVcause ... EBUG-----${HANGUPCAUSE}-----${DIALSTATUS}-----${DIALEDTIME}-----${ANSWEREDTIME}))

problem is not with vicidial i think . Also in cdr logs i am getting disposition for some calls as FAILED so i think this is some voip problem at my side .

[gerski]

make sure the AGI in your dialplan is in the proper order, especially the outbound calls.

[devafree]

Hello

I am facing the same prob, have to clear vicidial_auto_calls manually every couple hours. I checked the h, 8369 and 94XXXXXXXXXX extensions, and they are all running in the * CLI.

How to resolve?

Thanks

regards
devafree

[mflorell]

What are the first 4 digits of the phone numbers that are stuck in the vicidial_auto_calls table?

Are all of the numbers 10 digits in length?

[aster1]

yes matt i have confirmed that calls that were struck in vicidial_auto_calls are all dialable numbers and even did manual dial to them . All of them has status Xfer and uniqueid is also there . Currently i am running a cron script that clears calls whose last_update_time is greater than 15 mins , its not really good solution but works little bit . I was thinking that it is my bandwith issue (55 calls ringing at a time but only 6-7 picked up one's on a 2 mbps line ) . I am using iax trunk for now maybe thats having problem .. i will try a sip trunk and see if it helps ( i get many disposition as 'failed; in asterisk logs ) .. even though it sounds stupid but weird solutions work sometimes