*DB Master - vicidial_live_agents stuck

All installation and configuration problems and questions

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

*DB Master - vicidial_live_agents stuck

Postby ramizuabhalim » Tue May 25, 2021 1:29 pm

Hi All,

Recently, I have issue with the database for vicidial_live_agents table where agent stuck on db but very less. By right agents already logout from the system.
I have seen the cronjob for this script /usr/share/astguiclient/AST_cleanup_agent_log.pl running every 33 minutes by default.

Can i run that script every 15 minutes without the system issue?
Any advise on this? or got other way?

Thank you in advance.

Vicibox9
Version: 2.14b0.5
SVN Version: 3302
DB Schema Version: 1608
ramizuabhalim
 
Posts: 97
Joined: Sat Dec 07, 2019 11:14 am

Re: *DB Master - vicidial_live_agents stuck

Postby mflorell » Tue May 25, 2021 2:23 pm

Running that script more often isn't going to fix your problem. This is probably a database load issue of some kind.

What is your database hardware?(CPU/RAM/drives/RAID/etc...)

Is this an all-in-one server?

How many records in your call_log table?

How many agents total are on your system?
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: *DB Master - vicidial_live_agents stuck

Postby ramizuabhalim » Wed May 26, 2021 3:29 am

Hi Matt,

Thank you for your respond.

This is the server spec for DB server.

Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
Address sizes: 43 bits physical, 48 bits virtual
CPU(s): 16
On-line CPU(s) list: 0-15
Thread(s) per core: 1
Core(s) per socket: 1
Socket(s): 16
NUMA node(s): 2
Vendor ID: GenuineIntel
CPU family: 6
Model: 63
Model name: Intel(R) Xeon(R) Silver 4214R CPU @ 2.40GHz
Stepping: 0
CPU MHz: 2394.375
BogoMIPS: 4788.75
RAM : 16GB

How many records in your call_log table?
- around 3000-10000 per day


How many agents total are on your system?
- so far 50-90 agents
- it can can be up until 100-170 agents.


I have setup as a server cluster.

1 Master
1 Slave
1 Web
Multiple Dialler

DO you have idea to fix this?
But this issue very less happen but still got. :D
ramizuabhalim
 
Posts: 97
Joined: Sat Dec 07, 2019 11:14 am

Re: *DB Master - vicidial_live_agents stuck

Postby ramizuabhalim » Wed May 26, 2021 3:37 am

or we just control or always archive the call_log table inside the database ?
ramizuabhalim
 
Posts: 97
Joined: Sat Dec 07, 2019 11:14 am

Re: *DB Master - vicidial_live_agents stuck

Postby mflorell » Wed May 26, 2021 6:18 am

You didn't answer what the DB hard drives were that you were using, or what kind of RAID those drives were configured in.

I asked how many records were in the call_log table, not how many were added each day.

Do you have slow query logging enabled on your database?
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida


Return to Support

Who is online

Users browsing this forum: No registered users and 92 guests