INCALL on vicidial_hopper table

[lmoreira]

Hi Guys,

This system has about 160 agents (1 DB, 1 WEB, 5 dialers) makes 500k calls/day.
By the end of the day, I see on realtime report thousands leads in hopper.
On MySQL, I found a lot of 'INCALL status' rows in vicidial_hopper table, but no agent logged or call out-bounding.

Today, after one hour operating, I see this, but there were about ~100 calls alive:

Code: Select all

MariaDB [asterisk]> select status,count(*) from vicidial_hopper group by status;
+--------+----------+
| status | count(*) |
+--------+----------+
| READY  |     4066 |
| INCALL |      472 |
| HOLD   |       15 |
+--------+----------+
3 rows in set (0.00 sec)


Is this normal or a issue?

[mflorell]

That doesn't look normal, usually the hopper record will not stay in INCALL status, it'll be deleted.

Have you noticed any database errors in any of the logs?

[lmoreira]

No erros on mysql, but we started clearing list and load new leads on same list often lately.
Could it be caused by clearing list while some leads stills INCALL?

[mflorell]

I suppose that's possible, I can't say that I've managed a system where that's been done. You would have to analyze the entries in the hopper to figure out if that is what's happening.