Agents automatically goes on disposition

All installation and configuration problems and questions

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

Agents automatically goes on disposition

Postby javad-afzal » Thu Jan 28, 2021 1:59 pm

Hi

We have been facing an issue with the vicibox cluster setup. Agents frequently goes on disposition in realtime screen, some times gets paused automatically Plus calls in queue does not land to agents also and in agent screen there Pause/Resume button greys out as well on that specific time. I have checked the load on the DB and Dialer server at that time which is below 1%. Please see the image for better clarification.

https://ibb.co/tb9VP7H

my.cnf
Code: Select all
[client]
# password   = your_password
# port       = 3306
# socket     = /run/mysql/mysql.sock


# The MariaDB server
[mysqld]
#bind-address = 127.0.0.1 # Uncomment for local/socket access only, will brick network access
#port = 3306 # Do not uncomment unless you know what you are doing, can brick your database connectivity
#socket = /run/mysql/mysql.sock # Same note as above

# Stuff to tune for your hardware
max_connections=6000 # If you have a dedicated database that meets the above HW reqs, change this to 2000
key_buffer_size = 8G # Increase to be approximately 60% of system RAM when you have more then 8GB in the system


# In general most of the below settings don't need tuning
log-error = /var/log/mysql/mysqld.log
long_query_time=3
slow_query_log = 1
slow_query_log_file = /var/log/mysql/mysqld-slow.log
log-slow-verbosity = query_plan,explain
secure_file_priv = /var/lib/mysql-files # Only allow LOAD DATA INFILE from this directory as a security feature
log_bin = /var/lib/mysql/mysql-bin
binlog_format = mixed
binlog_direct_non_transactional_updates=1 # By default, all slave replications are treated as transactions, even though MyISAM doesn't support it, so disable that behavior cause it makes slave replicationg REALLLLLLLLLY slow
relay_log = /var/lib/mysql/mysql-relay-bin
datadir   = /srv/mysql/data
server-id = 1 # Master should be 1, and all slaves should have a unique ID number
slave-skip-errors = 1032,1690,1062 # ViciDial doesn't always do clean inserts, so prevent duplicate inserts from bombing the replication basically
slave_parallel_threads = 4 # Might need to increase this if slave replicating is slow, up to 40 or even 60 threads is not unheard of
slave-parallel-mode = optimistic
slave-parallel-max-queued = 2M
skip-external-locking
skip-name-resolve
connect_timeout = 60
max_allowed_packet = 1M
table_open_cache = 512
table_definition_cache = 16384
sort_buffer_size = 2M
net_buffer_length = 8K
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
query_cache_size = 0 # Yes, this will bottleneck your system if you have more then a few thousand QPS, so leave disabled! You've been warned :)
expire_logs_days = 3 # Disabling or setting this to 0 will fill up your hard-drive eventually, 3 days is a good compromise for slaves with connectivity issues
concurrent_insert = 2
thread_concurrency = 72
myisam_repair_threads = 4
myisam_recover_option = DEFAULT
tmpdir = /tmp/
thread_cache_size = 8
join_buffer_size = 1M
myisam_use_mmap = 1
open_files_limit = 24576
max_heap_table_size=8G
tmp_table_size=8G
key_cache_segments=64
sql_mode=NO_ENGINE_SUBSTITUTION


### By default only replicate the 'asterisk' database for ViciDial, comment out to replicate everything
### Make sure you do a full database dump if not just replicating asterisk database
#replicate_do_db=asterisk

### Comment out the tables below here if you really need them replicated to the slave, these are PERFORMANCE HOGS!
### Most of these tables are MEMORY tables which aren't persistent or used solely as tables for tracking the progress
### of things temporarily before doing real things like log inserts or lead updates
#replicate-ignore-table=asterisk.vicidial_live_agents
#replicate-ignore-table=asterisk.live_sip_channels
#replicate-ignore-table=asterisk.live_channels
#replicate-ignore-table=asterisk.vicidial_auto_calls
#replicate-ignore-table=asterisk.server_updater
#replicate-ignore-table=asterisk.web_client_sessions
#replicate-ignore-table=asterisk.vicidial_hopper
#replicate-ignore-table=asterisk.vicidial_campaign_server_status
#replicate-ignore-table=asterisk.parked_channels
#replicate-ignore-table=asterisk.vicidial_manager
#replicate-ignore-table=asterisk.cid_channels_recent
#replicate-wild-ignore-table=asterisk.cid_channels_recent_%


### Yes, we need this for system tables, so no need to tune anything here for ViciDial settings, these are just for the mysql tables and internal stuff
innodb_buffer_pool_size = 128M
innodb_file_format = Barracuda # Deprecated in future releases as this is the only supported format, eventually
innodb_file_per_table = ON
innodb_flush_method=O_DIRECT
innodb_flush_log_at_trx_commit=2
innodb_log_buffer_size=8M


### Configure the MariaDB server to use SSL, for the experts among us, nothing in ViciDial uses this natively, and might brick your DB
#ssl-ca=/etc/mysql/ssl/ca-cert.pem
#ssl-cert=/etc/mysql/ssl/server-cert.pem
#ssl-key=/etc/mysql/ssl/server-key.pem




[mysqld_multi]
mysqld     = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
log        = /var/log/mysqld_multi.log

# If you want to use mysqld_multi uncomment 1 or more mysqld sections
# below or add your own ones.

# WARNING
# --------
# If you uncomment mysqld1 than make absolutely sure, that database mysql,
# configured above, is not started.  This may result in corrupted data!
#
# [mysqld1]
# port       = 3306
# datadir    = /var/lib/mysql
# pid-file   = /var/lib/mysql/mysqld.pid
# socket     = /var/lib/mysql/mysql.sock
# user       = mysql

# [mysqld2]
# port       = 3307
# datadir    = /var/lib/mysql-databases/mysqld2
# pid-file   = /var/lib/mysql-databases/mysqld2/mysql.pid
# socket     = /var/lib/mysql-databases/mysqld2/mysql.sock
# user       = mysql

# [mysqld3]
# port       = 3308
# datadir    = /var/lib/mysql-databases/mysqld3
# pid-file   = /var/lib/mysql-databases/mysqld3/mysql.pid
# socket     = /var/lib/mysql-databases/mysqld3/mysql.sock
# user       = mysql

# [mysqld6]
# port       = 3309
# datadir    = /var/lib/mysql-databases/mysqld6
# pid-file   = /var/lib/mysql-databases/mysqld6/mysql.pid
# socket     = /var/lib/mysql-databases/mysqld6/mysql.sock
# user       = mysql

!includedir /etc/my.cnf.d


I am stuck here. any help would be much appreciated.
Thanks

192.168.2.X (asterisk)
ViciBox_v9.x86_64-9.0.2.ISO | Vicidial 2.14-751a Build 200425-0949 | Asterisk 13.29.2-vici | Asterisk Server | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel(R) Xeon(R) CPU X5675 | 32 GB RAM |
VARactive_keepalives = 123456789E

192.168.2.X (DB+Web)
ViciBox_v9.x86_64-9.0.2.ISO | Vicidial 2.14-751a Build 200425-0949 | Asterisk 13.29.2-vici | DB + Web Server | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel(R) Xeon(R) CPU E5-2670 v2 | 128 GB RAM | RAID 1 over SAS SSD | Load average below 1%
javad-afzal
 
Posts: 63
Joined: Sat Jun 11, 2011 6:11 pm

Re: Agents automatically goes on disposition

Postby javad-afzal » Thu Jan 28, 2021 2:45 pm

Mysql process list when it occurs.

Code: Select all
MariaDB [(none)]> show processlist;
+---------+------+---------------------+----------+---------+-------+------------------------------+------------------------------------------------------------------------------------------------------+----------+
| Id      | User | Host                | db       | Command | Time  | State                        | Info                                                                                                 | Progress |
+---------+------+---------------------+----------+---------+-------+------------------------------+------------------------------------------------------------------------------------------------------+----------+
|     644 | cron | localhost           | asterisk | Sleep   |     0 |                              | NULL                                                                                                 |    0.000 |
|     645 | cron | localhost           | asterisk | Sleep   | 19516 |                              | NULL                                                                                                 |    0.000 |
|     647 | cron | localhost           | asterisk | Sleep   |     0 |                              | NULL                                                                                                 |    0.000 |
|    1532 | cron | 192.168.2.250:20354 | asterisk | Sleep   |     0 |                              | NULL                                                                                                 |    0.000 |
|    1533 | cron | 192.168.2.250:20356 | asterisk | Sleep   |     0 |                              | NULL                                                                                                 |    0.000 |
|    1536 | cron | 192.168.2.250:20362 | asterisk | Sleep   |     0 |                              | NULL                                                                                                 |    0.000 |
|    1538 | cron | 192.168.2.250:20370 | asterisk | Sleep   |     0 |                              | NULL                                                                                                 |    0.000 |
|    1539 | cron | 192.168.2.250:20372 | asterisk | Query   |     4 | Waiting for table level lock | SELECT list_id,called_count from vicidial_list where lead_id='41925143' limit 1                      |    0.000 |
| 2511593 | cron | localhost           | asterisk | Sleep   |     0 |                              | NULL                                                                                                 |    0.000 |
| 3097768 | cron | localhost           | NULL     | Query   |     0 | init                         | show processlist                                                                                     |    0.000 |
| 3185063 | cron | localhost           | asterisk | Query   |    16 | Waiting for table level lock | SELECT count(*) FROM vicidial_list FORCE INDEX(list_id) where called_since_last_reset='N' and status |    0.000 |
| 3189177 | cron | 192.168.2.250:25374 | asterisk | Query   |    17 | Waiting for table level lock | SELECT vendor_lead_code FROM vicidial_list where lead_id='41925143'                                  |    0.000 |
| 3190168 | cron | 192.168.2.250:25856 | asterisk | Sleep   |     0 |                              | NULL                                                                                                 |    0.000 |
| 3191515 | cron | 192.168.2.250:26536 | asterisk | Sleep   |     0 |                              | NULL                                                                                                 |    0.000 |
| 3191794 | cron | 192.168.2.250:26694 | asterisk | Query   |    17 | Waiting for table level lock | UPDATE vicidial_list set status='SALE',title='',first_name='KAREN NASKI ',middle_initial='',last_nam |    0.000 |
| 3191894 | cron | 192.168.2.250:26766 | asterisk | Sleep   |     0 |                              | NULL                                                                                                 |    0.000 |
| 3192061 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT lead_id,entry_date,modify_date,status,user,vendor_lead_code,source_id,list_id,gmt_offset_now, |    0.000 |
| 3192477 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT lead_id,entry_date,modify_date,status,user,vendor_lead_code,source_id,list_id,gmt_offset_now, |    0.000 |
| 3192802 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT lead_id,entry_date,modify_date,status,user,vendor_lead_code,source_id,list_id,gmt_offset_now, |    0.000 |
| 3193458 | cron | 192.168.2.250:27614 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='41925143'                |    0.000 |
| 3193475 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='39970366'                |    0.000 |
| 3193481 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='39970366'                |    0.000 |
| 3193486 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | UPDATE vicidial_list set status='INCALL', user='701' ,owner='701' where lead_id='62832804'           |    0.000 |
| 3193506 | cron | 192.168.2.250:27646 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193514 | cron | 192.168.2.250:27660 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193523 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193527 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193534 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193540 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193563 | cron | 192.168.2.250:27676 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193564 | cron | 192.168.2.250:27678 | asterisk | Query   |    17 | Waiting for table level lock | UPDATE vicidial_list set status='INCALL', user='738' ,owner='738' where lead_id='5031012'            |    0.000 |
| 3193584 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193587 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193592 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193604 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193615 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193625 | cron | 192.168.2.250:27704 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193631 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193638 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193644 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193650 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193655 | cron | 192.168.2.250:27718 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193662 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193667 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193689 | cron | 192.168.2.250:27750 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193695 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193706 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193715 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193724 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193727 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | UPDATE vicidial_list set status='INCALL', user='756' ,owner='756' where lead_id='33997673'           |    0.000 |
| 3193728 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193735 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193744 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193750 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193760 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193767 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193773 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193778 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193784 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193796 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193803 | cron | 192.168.2.250:27786 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193811 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193817 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193842 | cron | 192.168.2.250:27810 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193849 | cron | 192.168.2.250:27820 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193857 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193864 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193870 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193889 | cron | 192.168.2.250:27840 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193898 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193904 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193906 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT count(*) from vicidial_list where lead_id='4579203'                                           |    0.000 |
| 3193911 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193945 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193953 | cron | 192.168.2.250:27860 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193956 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193964 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193973 | cron | 192.168.2.250:27878 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193983 | cron | 192.168.2.250:27894 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3193996 | cron | 192.168.2.250:27918 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194010 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194023 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194034 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194047 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194049 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194056 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194067 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194073 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194088 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194094 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194100 | cron | 192.168.2.250:27952 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194106 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194111 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194122 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194139 | cron | 192.168.2.250:27974 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194147 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194156 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194157 | cron | 192.168.2.250:27990 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194166 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194173 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194179 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194197 | cron | 192.168.2.250:28018 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194230 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT count(*) FROM vicidial_list FORCE INDEX(list_id) where called_since_last_reset='N' and status |    0.000 |
| 3194234 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194248 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194256 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194268 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194274 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194279 | cron | 192.168.2.250:28042 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194286 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194294 | cron | 192.168.2.250:28060 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194298 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194330 | cron | 192.168.2.250:28102 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194336 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194344 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194350 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194358 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194368 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194378 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194384 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194396 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194400 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194409 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194423 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194432 | cron | 192.168.2.250:28134 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194438 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194446 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194466 | cron | 192.168.2.250:28158 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194475 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194481 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194489 | cron | 192.168.2.250:28178 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194499 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194501 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194519 | cron | 192.168.2.250:28190 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194532 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194538 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194544 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194581 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194582 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194588 | cron | 192.168.2.250:28214 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194595 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194603 | cron | 192.168.2.250:28232 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194611 | cron | 192.168.2.250:28242 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194624 | cron | 192.168.2.250:28264 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194914 | cron | 192.168.2.250:28384 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194922 | cron | 192.168.2.250:28400 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194928 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3194951 | cron | 192.168.2.250:28430 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195113 | cron | 192.168.2.250:28498 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195133 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195143 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195145 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195163 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195171 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195183 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195191 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195199 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195202 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195205 | cron | 192.168.2.250:28514 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195211 | cron | 192.168.2.250:28526 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195219 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195225 | cron | 192.168.2.250:28538 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195230 | cron | 192.168.2.250:28548 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195243 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195255 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195261 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195267 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195273 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195279 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195285 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195295 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195303 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195311 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195315 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195320 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195330 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195335 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195346 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195354 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195364 | cron | 192.168.2.250:28590 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195374 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195381 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195390 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195417 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195424 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195430 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195436 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195444 | cron | 192.168.2.250:28618 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195449 | cron | 192.168.2.250:28628 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195475 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195483 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195491 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195497 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195507 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195513 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195524 | cron | 192.168.2.250:28670 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195530 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195538 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195544 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195566 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195575 | cron | 192.168.2.250:28702 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195596 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195607 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195615 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195617 | cron | 192.168.2.250:28730 | asterisk | Sleep   |     0 |                              | NULL                                                                                                 |    0.000 |
| 3195627 | cron | 192.168.2.250:28752 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195633 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195642 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195661 | cron | 192.168.2.250:28786 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='5031012'                 |    0.000 |
| 3195725 | cron | 192.168.2.250:28848 | asterisk | Sleep   |     0 |                              | NULL                                                                                                 |    0.000 |
| 3195881 | cron | 192.168.2.250:29066 | asterisk | Sleep   |     0 |                              | NULL                                                                                                 |    0.000 |
| 3195889 | cron | 192.168.2.250:29074 | asterisk | Sleep   |     0 |                              | NULL                                                                                                 |    0.000 |
| 3195904 | cron | 192.168.2.250:29092 | asterisk | Sleep   |     0 |                              | NULL                                                                                                 |    0.000 |
| 3195907 | cron | 192.168.2.250:29094 | asterisk | Sleep   |     0 |                              | NULL                                                                                                 |    0.000 |
| 3195969 | cron | 192.168.2.250:29138 | asterisk | Query   |    27 | Creating sort index          | SELECT lead_id,entry_date,modify_date,status,user,vendor_lead_code,source_id,list_id,gmt_offset_now, |    0.000 |
| 3196029 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT count(*) from vicidial_list where lead_id='51506361'                                          |    0.000 |
| 3196077 | cron | 192.168.2.250:29202 | asterisk | Sleep   |     0 |                              | NULL                                                                                                 |    0.000 |
| 3196107 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT count(*) FROM vicidial_list FORCE INDEX(list_id) where called_since_last_reset='N' and status |    0.000 |
| 3196109 | cron | 192.168.2.250:29220 | asterisk | Sleep   |     4 |                              | NULL                                                                                                 |    0.000 |
| 3196126 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='41925143'                |    0.000 |
| 3196128 | cron | 192.168.2.250:29242 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='41925143'                |    0.000 |
| 3196132 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT count(*) from vicidial_list where lead_id='5327056'                                           |    0.000 |
| 3196133 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT count(*) from vicidial_list where lead_id='55315285'                                          |    0.000 |
| 3196142 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='41925143'                |    0.000 |
| 3196144 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='41925143'                |    0.000 |
| 3196148 | cron | 192.168.2.250:29258 | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='41925143'                |    0.000 |
| 3196157 | cron | localhost           | asterisk | Query   |    17 | Waiting for table level lock | SELECT comments,user,first_name,last_name from vicidial_list where lead_id='41925143'                |    0.000 |
| 3196186 | cron | 192.168.2.250:29294 | asterisk | Query   |    16 | Waiting for table level lock | UPDATE vicidial_list set status='DROP' where lead_id = '3018763'                                     |    0.000 |
| 3196203 | cron | 192.168.2.250:29296 | asterisk | Query   |    15 | Waiting for table level lock | SELECT lead_id,called_count from vicidial_list where phone_number='3096964110'  order by last_local_ |    0.000 |
| 3196243 | cron | localhost           | asterisk | Query   |    12 | Waiting for table level lock | SELECT count(*) from vicidial_list where lead_id='35542151'                                          |    0.000 |
| 3196306 | cron | 192.168.2.250:29394 | asterisk | Query   |     2 | Waiting for table level lock | UPDATE vicidial_list set status='DROP' where lead_id = '43496023'                                    |    0.000 |
| 3196325 | cron | 192.168.2.250:29410 | asterisk | Sleep   |     0 |                              | NULL                                                                                                 |    0.000 |
+---------+------+---------------------+----------+---------+-------+------------------------------+------------------------------------------------------------------------------------------------------+----------+
285 rows in set (0.00 sec)
javad-afzal
 
Posts: 63
Joined: Sat Jun 11, 2011 6:11 pm

Re: Agents automatically goes on disposition

Postby javad-afzal » Tue Feb 02, 2021 12:41 pm

Any One ? I am stuck for now here. Any help would be much appreciated.
Thanks in advance.
javad-afzal
 
Posts: 63
Joined: Sat Jun 11, 2011 6:11 pm

Re: Agents automatically goes on disposition

Postby carpenox » Tue Feb 02, 2021 1:28 pm

Waiting for table level lock seems off to me but I am unsure. Perhaps Bill or Matt could chime in on this one
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: Agents automatically goes on disposition

Postby mflorell » Tue Feb 02, 2021 6:29 pm

It's a database issue, either too many records in the vicidial_list table, or a badly written Filter or insufficient hardware.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Agents automatically goes on disposition

Postby javad-afzal » Wed Feb 03, 2021 10:43 am

Thanks for the updates.
Yes there are too many records in the vicidial_list table.
Code: Select all
MariaDB [asterisk]> SELECT COUNT(*) FROM vicidial_list;
+----------+
| COUNT(*) |
+----------+
| 41933691 |
+----------+
1 row in set (0.00 sec)


Our database server specifications are mentioned below.

| Xeon(R) CPU E5-2670 v2 on two sockets which makes it 20 cores and 40 total threads. | 128 GB RAM | RAID 1 over SAS SSD | Load average below 1%

What are our options here further? Also Database is growing day to day.
javad-afzal
 
Posts: 63
Joined: Sat Jun 11, 2011 6:11 pm

Re: Agents automatically goes on disposition

Postby carpenox » Wed Feb 03, 2021 1:52 pm

41 million leads is a lot. Perhaps you can share the load to a slave db for that table in particular? just an idea, not sure if thats feasible or not
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: Agents automatically goes on disposition

Postby mflorell » Wed Feb 03, 2021 2:41 pm

41 million leads is WAY TOO MANY in the vicidial_list table. I would recommend you either delete or archive most of them to keep the total below 10 million.

Here's an example of how to create a vicidial_list_archive table, and how to populate it:

CREATE TABLE vicidial_list_archive LIKE vicidial_list;
ALTER TABLE vicidial_list_archive MODIFY lead_id INT(9) UNSIGNED NOT NULL;

select count(*) from vicidial_list where list_id IN('8881106');

INSERT INTO vicidial_list_archive SELECT * from vicidial_list where list_id IN('8881106');
select count(*) from vicidial_list_archive where list_id IN('8881106');
DELETE from vicidial_list where list_id IN('8881106');
optimize table vicidial_list;
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Agents automatically goes on disposition

Postby javad-afzal » Wed Feb 03, 2021 5:58 pm

Don't have much expertise in databases. let me discuss it with some database expert for this.
Just to make sure i got your point the query
Code: Select all
 select count(*) from vicidial_list where list_id IN('8881106');

The list id mentioned here is the list id which we need to archive, correct?
and we need to do these steps for every list id we need to archive until vicidial_list becomes under 10 Million.
Our setup is only inbound and CallerID is looked up by CIDlookup method. will this CIDlookup method work as before if we archive all other lists above 10 Million.
javad-afzal
 
Posts: 63
Joined: Sat Jun 11, 2011 6:11 pm

Re: Agents automatically goes on disposition

Postby carpenox » Thu Feb 04, 2021 6:39 am

Damn this is some great information here Matt, good shit
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: Agents automatically goes on disposition

Postby striker » Thu Feb 04, 2021 6:56 am

are those 41 million leads or unique id's ?
if not better to check a way to filter the duplicates and delete the duplicates.
www.striker24x7.com www.youtube.com/c/striker24x7 Telegram/skype id : striker24x7
striker
 
Posts: 962
Joined: Sun Jun 06, 2010 10:25 am

Re: Agents automatically goes on disposition

Postby mflorell » Thu Feb 04, 2021 8:52 am

You should probably get a bit more familiar with SQL before altering or running these queries. The list_id segment is just an example, we have done similar queries for clients based upon entry_date, status, source_id, etc... depending on how the client wants to archive the leads. You should pick the method that works best for your data. If you are most inbound, you might want to do a combination of entry_date and status if most of your leads go into a few of the same lists throughout each day.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Agents automatically goes on disposition

Postby javad-afzal » Mon Feb 08, 2021 2:15 pm

I am a bit confused here. Will the CIDlookup method on our Inbound calls still work if we archive most of our leads with list_id's in the vicidial_archive_table. CIDlookups are configured to search from the Entire system.
javad-afzal
 
Posts: 63
Joined: Sat Jun 11, 2011 6:11 pm

Re: Agents automatically goes on disposition

Postby mflorell » Mon Feb 08, 2021 10:28 pm

The CIDLOOKUP method will not search archived leads. But I have yet to find a client with this issue where we were not able to find a significant number of leads that could be archived. From duplicates with the same phone number to leads that are years old without a contact, there are always leads that can be archived.
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 56 guests