vicidial.org

by **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

by **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)

by **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.

by **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

by **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.

by **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.

by **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

by **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;

by **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.

by **carpenox** » Thu Feb 04, 2021 6:39 am

Damn this is some great information here Matt, good shit

by **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.

by **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.

by **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.

by **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.

vicidial.org

Agents automatically goes on disposition

Agents automatically goes on disposition

Re: Agents automatically goes on disposition

Re: Agents automatically goes on disposition

Re: Agents automatically goes on disposition

Re: Agents automatically goes on disposition

Re: Agents automatically goes on disposition

Re: Agents automatically goes on disposition

Re: Agents automatically goes on disposition

Re: Agents automatically goes on disposition

Re: Agents automatically goes on disposition

Re: Agents automatically goes on disposition

Re: Agents automatically goes on disposition

Re: Agents automatically goes on disposition

Re: Agents automatically goes on disposition

Who is online