odd system freeze up

All installation and configuration problems and questions

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

odd system freeze up

Postby TwistedFister » Mon Aug 20, 2018 3:03 pm

Vicibox 7.0.3 from .iso | Vicidial 2.14-579a Build 161128-1746 | Asterisk 11.22.0-vici | CLuster setup: 1 web 1 DB 1 Slave DB 8 telephony | No Digium/Sangoma Hardware | No Extra Software After Installation

Outbound ratio dialing and all of the agent screens and the realtime report completely freeze for 3-4 minutes however all 110 of the agents remain on the calls they are on but cant hang up or dispo the calls. After the 3-4 minutes the realtime report refreshes and everyone is either paused (which the agents didnt do on their own) or waiting for a call and it resumes dialing just as it has been for the last 2 years... Anyone seen this before? First time for me
TwistedFister
 
Posts: 78
Joined: Tue Jul 26, 2016 11:50 am

Re: odd system freeze up

Postby williamconley » Mon Aug 20, 2018 3:25 pm

Given the odds: Your server has matured. You now have so many records in one or more tables that running a large report or any fresh configuration changes such as a new sql filter on a campaign can hammer the DB server and lock tables for quite a while and regularly.

Test which mysql query has been running the longest (ie: the problem) with:
Code: Select all
watch -n1  "mysql asterisk -pROOTMYSQLPASSHERE -e \"select * from information_schema.processlist where command not in ('Sleep') and info not like '%processlist%' and info is not null \""


If you have multiple millions of Vicidial Leads in the system, consider deleting as many as possible. Try to get below 5M if you can. Note that this should happen before the nightly DB optimization routine runs (shows in the crontab, probably 1AM-ish).

You can also activate the log archiving system (also in crontab) which can dramatically improve performance on mature systems that have been collecting logs forever.

If this is a reporting triggered event, consider a reporting mysql/replication server.

Happy Hunting 8-)
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to Support

Who is online

Users browsing this forum: Google [Bot], Majestic-12 [Bot] and 97 guests