Hopper exceeding maximum limit

[enjay]

I have a hopper set to 200 and for some reason the hopper level is increasing to well over 1000. I have lowered the hopper to 100 and then I run out of leads.

Any ideas?

[mflorell]

if you do a "SELECT * from vicidial_hopper;" do you see a lot of leads that have been reserved?

Do you have more than one server with AST_VDauto_dial.pl running on it?

[enjay]

I just cleared out the hopper manually (before I read this) I will check next time it gets up there.. I will tell you the vicidial_hopper table had -

Code: Select all

mysql> delete from vicidial_hopper;
Query OK, 4734 rows affected (0.01 sec)


Yes I have 2 servers running AST_VDauto_dial.pl

[mflorell]

what did the records look like before you deleted them?

Sometimes when Asterisk is not running or has just crashed, the auto_dial process will try to lace calls ad reserver leads in the hopper that don't get cleared out properly. That's the only time I've had problems with this.

[enjay]

the table looks like:

Code: Select all

|   2370149 | 2594787 | 1000        | QUEUE  | VDAD_192.168.0.5 |    1227 |           0.00 | AZ    |
|   2370150 | 2576969 | 1000        | QUEUE  | VDAD_192.168.0.5 |    1227 |           0.00 | AZ    |
|   2370191 | 2561050 | 1000        | QUEUE  | VDAD_192.168.0.5 |    1227 |           0.00 | AZ    |
|   2370167 | 2622348 | 1000        | QUEUE  | VDAD_192.168.0.5 |    1227 |           0.00 | AZ    |
|   2370292 | 2508415 | 1000        | QUEUE  | VDAD_192.168.0.5 |    1227 |           0.00 | AZ    |
|   2370295 | 2539541 | 1000        | QUEUE  | VDAD_192.168.0.5 |    1227 |           0.00 | AZ    |
|   2370296 | 2550489 | 1000        | QUEUE  | VDAD_192.168.0.5 |    1227 |           0.00 | AZ    |
|   2370366 | 2601539 | 1000        | QUEUE  | VDAD_192.168.0.5 |    1227 |           0.00 | AZ    |
|   2370412 | 2565725 | 1000        | QUEUE  | VDAD_192.168.0.5 |    1227 |           0.00 | AZ    |
|   2370317 | 2523223 | 1000        | QUEUE  | VDAD_192.168.0.5 |    1227 |           0.00 | AZ    |
|   2370318 | 2534207 | 1000        | QUEUE  | VDAD_192.168.0.5 |    1227 |           0.00 | AZ    |
|   2370560 | 2530054 | 1000        | QUEUE  | VDAD_192.168.0.5 |    1227 |           0.00 | AZ    |
+-----------+---------+-------------+--------+------------------+---------+----------------+-------+


obviously alot more but thats it..

834 entries in the hopper with campaign 1000 id - hopper level of 200.

asterisk has not recently crashed or anything.

[mflorell]

For some reason it looks like 192.168.0.5 is reserving a lot of leads and not dialing them. I have not seen this happen this bad before, but the most recent release will now clear the reserved leads as well as all other leads in the hopper for a campaign when you clear the hopper from the campaign screen.

[enjay]

Yea rather abnormal this would happen just "all of a sudden" oh well I will update this evening and see if that resolves the issue..

-Art