Dialer stop dialing - problem with table vicidial_auto_calls

[ZibiX]

Hi.

Once every few weeks my clients call me with this strange situation.

1. Vicidial stop calling leads or calling very slowly (even with high ratio setting).
2. I need to restart whole server to get this fixed.
3. I have started to investigated this problem and i found that table vicidial_auto_calls is populated with many leads with queue_priority = 0 and call_time even few hours behind actual time.

Print screens:




4. When I delete this leads from vicidial_auto_calls (using query: DELETE FROM asterisk.vicidial_auto_calls where queue_priority = 0;) system start to work properly.

Do you know why is this happening? System isn't overloaded. Tables are not corrupted.
Vicibox 6.0.4
SVN 3611

Thank you for your help.
Zbigniew

[bbakirtas]

There may be a problem with the tables. try to repair

[carpenox]

are these leads being brought in thru an integration or thru the api?

hit me up on skype ill help you debug it then we can report back here what the issue was

[ZibiX]

There may be a problem with the tables. try to repair

That was my first thought but table is OK (no errors).

are these leads being brought in thru an integration or thru the api?

This is plain vicidial. No integration. No API. Leads uploaded using build in listloader.

At the time when it is happening server is not overloaded. there are no warnings in logs. There are no logs in slow query log.