Patch Available: SLOWDOWN OF VICIDIAL

[chander.prakash]

Dear Friends

For those who face this problem can use this link to get to the patch.

It will work with any version as it is handling only the DB.

http://www.eflo.net/VICIDIALmantis/view.php?id=92

# Put this file in folder named /usr/share/astguiclient
# You need to put this as a CRONTAB entry
* * * * * /usr/share/astguiclient/AST_CLEAR_VICIDIAL_BLOCK.pl
#
# !!! RUN THIS WHILE THERE ARE ACTIVE CALLS ON THE ASTERISK SERVER !!!

[ramindia]

Good work chander

Is this only need to put on cron
when the process doing autodialing mode
is this right ?

just correct me if iam wrong.


how about manual dialing mode ?

ram

[chander.prakash]

Hi Ram,

Thanx for appreciating my efforts.

This works fine in both auto as well as manual modes.

You need to put this file in the said folder and the crontab entry and just forget, it will do the rest.

[aster1]

DELETE from vicidial_auto_calls where channel is null and (now() - last_update_time)>=100;

I was doing exactly same thing before by deleting calls not updated since 6 mins or so . I want to make sure that it does not delete unnecessary entries ( even though channel is null many of entries are deleted by vicidial properly ) . Your script is deleting all null channels not updated from 100 secomds , right ?
Have you thoroughly tested it ? Even though it will definitely work, i just want to make sure it doesn't result in lead wastage by unnecessarily deleting entries . Let me know how well your testing went with it .

[hmohang]

Dear chander

Thanks

[chander.prakash]

Dear Aster1,

Six minutes was a long time during which many channels were getting blocked and were released simultaneously on clearing the table; thereby causing abnormal behaviour of Vicidial.

We have tested this for the last six weeks and our installations are working without any issues. The dial ratios are always maintained as set by admin.

Yes my script deletes the entry which blocks the channel for 100 secs uselessly, which is considered a huge time period in predictive dialing.

The entire process of creating this patch was preceded by observing the behaviour of Vicidial_Auto_calls table for 2 weeks.

Be rest assured that no good leads are dropped.

We understand the importance of retaining good leads since we have been in the IT industry for about 15 years.

[aster1]

I just added it to my setup and its working good . Good work chander.prakash .

[chander.prakash]

Thanks Aster1.

If you face any kind of a problem please feel free to contact us as in all probability you will get a quick and a correct solution which will cater to all environments.