DB server high load when many agents PAUSED long time

[Ggarcia]

Hi, i really need your help, we have a problem with vicidial, the problem is this:
We have 200 agents calling when more than 30% of then change their status to PAUSED for more than 60 minutos the server load increase about 900% or more
the solution to this is emergency logout PAUSED AGENTS, or logout all the campaigns with a lot of PAUSED agents.

We have the next configuration:

ViciBox Redux v.4.0.3 released on all servers
Data Base
12 cores Intel(R) Xeon(R) CPU E5-2620 0 @ 2.00GHz
40 GB RAM
1 TB HD
----------------------
Dialer Server 1
4 core Intel(R)Xeon(R)CPU E5502@ 1.87GHz
20 GB RAM
140 GB HD
----------------------
Dialer Server 2
4 core Intel(R) Xeon(R) CPU E5503@ 2.00GHz
16 GB RAM
140 GB HD
----------------------
Dialer Server 3
8 core Intel(R) Xeon(R) CPU X3440@ 2.53GHz
8 GB RAM
500 GB HD
----------------------
Dialer Server 4
8 core Intel(R) Xeon(R) CPU E5506@ 2.13GHz
16 GB RAM
500 GB HD
----------------------
Dialer Server 5
4 core Intel(R) Xeon(R) CPU E5502@ 1.87GHz
24 GB RAM
300 GB HD
----------------------
Dialer Server 6
4 core Intel(R) Xeon(R) CPU E5-24030@ 1.80GHz
14 GB RAM
500 GB HD
----------------------
1 Web Server
12 core Intel(R) Xeon(R) CPU E5-24200@ 1.90GHz
14 GB RAM
1 TB HD

[williamconley]

1) Welcome to the Party!

2) As you are obviously new here, I have some suggestions to help us all help you:

When you post, please post your entire configuration including (but not limited to) your installation method and vicidial version with build.

This IS a requirement for posting along with reading the stickies (at the top of each forum) and the manager's manual (available on EFLO.net, both free and paid versions)

You should also post: Asterisk version, telephony hardware (model number is helpful here), cluster information if you have one, and whether any other software is installed in the box. If your installation method is "from scratch" you must post your operating system and should also post the .iso version from which you installed your original operating system. If your installation is "Hosted" list the site name of the host.

If this is a "Cloud" or "Virtual" server, please note the technology involved along with the version of that techology (ie: VMware Server Version 2.0.2). If it is not, merely stating the Motherboard model # and CPU would be helpful.

Similar to This:

Vicibox X.X from .iso | Vicidial X.X.X-XXX Build XXXXXX-XXXX | Asterisk X.X.X | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel DG35EC | Core2Quad Q6600

3) I've never had this happen before, but you've given no actual information that could be used to troubleshoot it. Note that it is (definitely) useful to know the hardware and number of servers, certainly, but the most important information has been left out (ie: the above newbie request). I realize it's an unusual situation and hard to tell what may be needed, but always start with the basics (above) and we'll all do our best to help. But without those basics it's often difficult to even venture a guess. Note also that the 'Vicibox' version is in no way related to the 'Vicidial' version. Vicibox is just the installation media.

4) Since we've nothing to go by ... my only serious advice would be to see what you can do to limit paused agents. The good news is that an upgrade may resolve your issue for multiple reasons. Obviously the first reason is that this may be due to a bug that has already been squished. The second reason is that the latest version of Vicidial has an option to force-log-out agents who have been paused for a certain amount of time.

Campaign Setting:
Agent Pause Max Seconds - If this is set to greater than 0, and the agent has not gone out of PAUSED status in this number of seconds, the agent will automatically be logged out of the agent screen. Default is 0 for disabled.

[Ggarcia]

Campaign Setting:
Agent Pause Max Seconds - If this is set to greater than 0, and the agent has not gone out of PAUSED status in this number of seconds, the agent will automatically be logged out of the agent screen. Default is 0 for disabled.

Vicidial version:
VERSION: 2.6-393a
BUILD: 130124-1721

Where is this option, i cant find it on Campaign settings.

[DomeDan]

you need to update because that option was added in build 131208-1626

[Ggarcia]

is possible upgrade without reinstall the OS?

[DomeDan]

Yes, you can upgrade using svn: viewtopic.php?f=8&t=16326