Dialer stop dialing - problem with table vicidial_auto_calls

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Dialer stop dialing - problem with table vicidial_auto_calls

Postby ZibiX » Fri Jul 29, 2022 5:35 am

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:
Image

Image

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
ZibiX
 
Posts: 107
Joined: Wed Jul 03, 2013 5:36 am
Location: Poland

Re: Dialer stop dialing - problem with table vicidial_auto_c

Postby bbakirtas » Thu Aug 11, 2022 9:48 am

There may be a problem with the tables. try to repair
Vicibox 9.0.1
VERSION: 2.14-738a
BUILD: 200210-1628
Intel Xeon X5650 12 Core HT 24 Core 2.90 Ghz
64 GB ECC Registered Memory
bbakirtas
 
Posts: 92
Joined: Thu Dec 06, 2012 3:35 am
Location: Turkey

Re: Dialer stop dialing - problem with table vicidial_auto_c

Postby carpenox » Thu Aug 11, 2022 5:16 pm

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
Alma Linux 9.3 | Version: 2.14-911a | SVN Version: 3815 | DB Schema Version: 1710 | Asterisk 18.18.1
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WhatsApp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 2230
Joined: Wed Apr 08, 2020 2:02 am
Location: Coral Springs, FL

Re: Dialer stop dialing - problem with table vicidial_auto_c

Postby ZibiX » Thu Sep 01, 2022 5:29 am

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

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

carpenox wrote: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.
ZibiX
 
Posts: 107
Joined: Wed Jul 03, 2013 5:36 am
Location: Poland


Return to Support

Who is online

Users browsing this forum: Google [Bot], njr and 87 guests