Vicidial vicidial_auto_calls not updating properly

[thirdhatch]

Hello,

Vicibox 6.0.2
VERSION: 2.12-538a
BUILD: 160122-1401
2X Dual Core 2.8 Ghz
4GB Memory
120GB mirrored hard Drive

We started experiencing a problem this morning where the vicidial_auto_calls table is filling up and not clearing itself out when calls are stale. This is causing issues with ratio and auto dialing because there are no more channels available to dial. I have cleared the table out manually of the stale records, but this is only a temp fix. Because the table fills up again shortly after.

Any ideas? Is a cron script not running properly?

[thirdhatch]

It appears that the uniqueid column is not being populated on the calls that are getting stuck. Any ideas on how to fix?

[thirdhatch]

Ok, it appears that performing the steps Matt outlines in this ticket have resolved the issue for us.
viewtopic.php?t=3694

give changing it to VARCHAR a try and post if it resolves the problem or not.

As for performance hit, I believe DOUBLEs are stored as specially formatted VARCHARs anyway.

ALTER TABLE live_inbound MODIFY uniqueid VARCHAR(40) NOT NULL;
ALTER TABLE live_inbound_log MODIFY uniqueid VARCHAR(40) NOT NULL;
ALTER TABLE live_inbound_log MODIFY uniqueid VARCHAR(40) NOT NULL;
ALTER TABLE vicidial_manager MODIFY uniqueid VARCHAR(40) NOT NULL;
ALTER TABLE vicidial_live_agents MODIFY uniqueid VARCHAR(40) NOT NULL;
ALTER TABLE vicidial_auto_calls MODIFY uniqueid VARCHAR(40) NOT NULL;
ALTER TABLE call_log DROP PRIMARY KEY;
ALTER TABLE call_log DROP INDEX uniqueid;
ALTER TABLE call_log MODIFY uniqueid VARCHAR(40) PRIMARY KEY UNIQUE NOT NULL;
ALTER TABLE park_log DROP PRIMARY KEY;
ALTER TABLE park_log DROP INDEX uniqueid;
ALTER TABLE park_log MODIFY uniqueid VARCHAR(40) PRIMARY KEY UNIQUE NOT NULL;
ALTER TABLE vicidial_log DROP PRIMARY KEY;
ALTER TABLE vicidial_log DROP INDEX uniqueid;
ALTER TABLE vicidial_log MODIFY uniqueid VARCHAR(40) PRIMARY KEY UNIQUE NOT NULL;

Thanks!

[williamconley]

Excellent postback!