vicidial_auto_calls

[gmcust3]

Any permanent solution to call stuck ? Every 2 mins I haveto run below command and then after 24 hrs, I haveto Re-install dialer :

DELETE FROM vicidial_auto_calls where channel IS NULL;"

[williamconley]

probably have a corrupted table or calls that have impossible phone numbers. check your list (or check some of the records you are deleting ...). If your dialplan does not have an entry that matches the numbers being dialed, they will get "trapped" in the auto-calls table because there is no dial pattern to run that will delete them when the call terminates (since the call never even starts ...).

if there is a corrupted table in the db:

Ask which table is corrupted: (This is not always useful, as the table may not yet be marked as crashed)

Code: Select all

mysql asterisk -e "show table status where comment like '%crashed%'" --user=cron -p1234

Just repair all (don't do this while using it, and it's not a bad idea to reboot after):

Code: Select all

mysqlcheck --auto-repair --all-databases --user=cron -p1234

IF you actually know the name of the table in need of repair):

Code: Select all

mysqlcheck --auto-repair asterisk call_log --user=cron -p1234

[gmcust3]

Tried Repair but No Use.

Now, I use

DELETE FROM vicidial_auto_calls where channel IS NULL;

What happens is for 10 secs I see NO LIVE CALLS and then Again call starts.

No Bad number are getting uploaded.Checked that.

[williamconley]

You'll have to debug a single instance. Find out why it gets lost instead of being cleaned out. I'm still willing to bet it's one of those two reasons though.

Start with a record you are about to delete, and search the logs to find the path of that call.

And be sure all your screens are running!

Unless you are merely experiencing a huge quantity of NA calls on an old system that does not properly detect them. In that case it is often helpful to set the drop call seconds to Zero to cause the system to NOT wait 30 seconds after an NA call before generating a new one (also helpful to stop re-calling NA numbers ...). And then, of course, Upgrade

[gmcust3]

I am using

GoAutoDial CE
VERSION: 2.4-309a
BUILD: 110430-1642

I guess that's the Updated One !!

[williamconley]

Nope. No GoAutos have this code yet. GoAuto is ... behind in that regard (due to the "nobody has paid to update it" agent interface). It's pretty, but always behind by a bit. 2.6 SVN just got this code added a couple months ago.

also: Goauto has more than one "CE". Are you using 2.0 or 2.1? (version is important with installer just as it is with Vicidial).

We did a backport of this code for a client who has had too many customizations to be interested in a full upgrade, though.

[williamconley]

backport diff file link:

viewtopic.php?f=7&t=27370#p96504