Page 1 of 1

Lock problem with MariaDB

PostPosted: Fri Dec 17, 2021 1:07 pm
by PJ111288
Hi,

Need help on it.

Scartch install on centos 7
AST 13.29.2
SVN Version: 3514
DB Schema Version: 1643



| 14895514 | cron | localhost | asterisk | Query | 1 | Waiting for table level lock | INSERT INTO vicidial_agent_log SET user='sckimran',server_ip='10.10.10.10',event_time='2021-12-16 | 0.000 |
| 14895532 | cron | localhost | asterisk | Query | 1 | Waiting for table level lock | INSERT INTO vicidial_agent_log SET user='sckprerna',server_ip='10.10.10.10',event_time='2021-12-16 | 0.000 |
| 14895570 | cron | localhost | asterisk | Query | 0 | Sending data | select vl.user,vu.full_name,sum(pause_sec) from vicidial_agent_log vl,vicidial_users vu where vl.use | 0.000 |
| 14895592 | cron | localhost | asterisk | Query | 1 | Waiting for table level lock | INSERT INTO vicidial_agent_log SET user='N1137',server_ip='10.10.10.10',event_time='2021-12-16 13: | 0.000 |
| 14895676 | cron | localhost | asterisk | Query | 1 | Waiting for table level lock | UPDATE vicidial_agent_log set dead_epoch='1639680645' where agent_log_id='740577' | 0.000 |
| 14895687 | cron | localhost | asterisk | Query | 1 | Waiting for table level lock | UPDATE vicidial_agent_log set wait_sec='57',talk_epoch='1639680645',lead_id='478201' where agent_lo | 0.000 |
| 14895693 | cron | localhost | asterisk | Query | 1 | Waiting for table level lock | UPDATE vicidial_agent_log set wait_sec='506',talk_epoch='1639680645',lead_id='478189' where agent_l | 0.000 |
| 14895696 | cron | localhost | asterisk | Query | 1 | Waiting for table level lock | UPDATE vicidial_agent_log set wait_sec='506',talk_epoch='1639680645',lead_id='478189' where agent_l | 0.000 |
| 14895702 | cron | localhost | asterisk | Query | 1 | Waiting for table level lock | UPDATE vicidial_agent_log set wait_sec='103',talk_epoch='1639680645',lead_id='349471' where agent_l | 0.000 |
| 14895704 | cron | localhost | asterisk | Query | 1 | Waiting for table level lock | UPDATE vicidial_agent_log set wait_sec='506',talk_epoch='1639680645',lead_id='478189' where agent_l | 0.000 |
| 14895728 | cron | localhost | asterisk | Query | 0 | Sending data | select count(status) as sales,full_name,vicidial_users.user,status from vicidial_users,vicidial_agen | 0.000 |
| 14895738 | cron | localhost | asterisk | Query | 1 | Waiting for table level lock | UPDATE vicidial_agent_log set wait_sec='115',talk_epoch='1639680645',lead_id='349469' where agent_l | 0.000 |
| 14895742 | cron | localhost | asterisk | Query | 1 | Waiting for table level lock | UPDATE vicidial_agent_log set wait_sec='103',talk_epoch='1639680645',lead_id='349471' where agent_l | 0.000 |
| 14895746 | cron | localhost | asterisk | Query | 1 | Waiting for table level lock | UPDATE vicidial_agent_log set wait_sec='103',talk_epoch='1639680645',lead_id='349471' where agent_l | 0.000 |
| 14895747 | cron | localhost | asterisk | Query | 1 | Waiting for table level lock | UPDATE vicidial_agent_log set wait_sec='115',talk_epoch='1639680645',lead_id='349469' where agent_l | 0.000 |
| 14895754 | cron | localhost | asterisk | Query | 1 | Waiting for table level lock | UPDATE vicidial_agent_log set wait_sec='115',talk_epoch='1639680645',lead_id='349469' where agent_l | 0.000 |
| 14895753 | cron | localhost | asterisk | Query | 1 | Waiting for table level lock | UPDATE vicidial_agent_log set wait_sec='115',talk_epoch='1639680645',lead_id='349469' where agent_l | 0.000 |
| 14895756 | cron | localhost | asterisk | Query | 1 | Waiting for table level lock | UPDATE vicidial_agent_log set wait_sec='103',talk_epoch='1639680645',lead_id='349471' where agent_l | 0.000 |
| 14895808 | cron | localhost | asterisk | Query | 1 | Waiting for table level lock | UPDATE vicidial_agent_log set wait_sec='103',talk_epoch='1639680645',lead_id='349471' where agent_l | 0.000 |
| 14895809 | cron | localhost | asterisk | Query | 1 | Waiting for table level lock | UPDATE vicidial_agent_log set wait_sec='103',talk_epoch='1639680645',lead_id='349471' where agent_l | 0.000 |
| 14895812 | cron | localhost | asterisk | Query | 1 | Waiting for table level lock | UPDATE vicidial_agent_log set wait_sec='115',talk_epoch='1639680645',lead_id='349469' where agent_l | 0.000 |
| 14895844 | cron | localhost | asterisk | Query | 0 | Waiting for table level lock | UPDATE vicidial_agent_log set wait_sec='116',talk_epoch='1639680646',lead_id='349469' where agent_l | 0.000 |
| 14895847 | cron | localhost | asterisk | Query | 0 | Waiting for table level lock | UPDATE vicidial_agent_log set wait_sec='64',talk_epoch='1639680646',lead_id='586927' where agent_lo | 0.000 |
| 14895867 | cron | localhost | asterisk | Query | 0 | Waiting for table level lock | UPDATE vicidial_agent_log set wait_sec='58',talk_epoch='1639680646',lead_id='478201' where agent_lo | 0.000 |
| 14895895 | cron | localhost | asterisk | Query | 0 | Waiting for query cache lock | SELECT count(*) FROM vicidial_live_agents where user='sclanshul' and manager_ingroup_set='SET' | 0.000 |
| 14895899 | cron | localhost | asterisk | Query | 0 | query end | DELETE from vicidial_auto_calls where lead_id='349463' and campaign_id='SCCRNG12' and callerid LIKE | 0.000 |

Re: Lock problem with MariaDB

PostPosted: Mon Dec 20, 2021 6:37 pm
by GenXOutsourcing
What scratch install directions did you use?

Re: Lock problem with MariaDB

PostPosted: Mon Jan 17, 2022 11:07 am
by PJ111288

Re: Lock problem with MariaDB

PostPosted: Thu Jan 20, 2022 3:07 pm
by carpenox