Lock problem with MariaDB

All installation and configuration problems and questions

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

Lock problem with MariaDB

Postby PJ111288 » Fri Dec 17, 2021 1:07 pm

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 |
PJ111288
 
Posts: 71
Joined: Tue Nov 13, 2018 7:41 am

Re: Lock problem with MariaDB

Postby GenXOutsourcing » Mon Dec 20, 2021 6:37 pm

What scratch install directions did you use?
Built too many to count, Centos7 Scratch install, Opensuse Scratch install, Centos8 Scratch install, etc.
Dual 8 core/32gb RAM/500gb SSDs
SVN Version:3440
VERSION: 2.14-812a
genxoutsourcing.com
GenXOutsourcing
 
Posts: 109
Joined: Sun Sep 22, 2019 12:53 am

Re: Lock problem with MariaDB

Postby PJ111288 » Mon Jan 17, 2022 11:07 am

PJ111288
 
Posts: 71
Joined: Tue Nov 13, 2018 7:41 am

Re: Lock problem with MariaDB

Postby carpenox » Thu Jan 20, 2022 3:07 pm

Alma Linux 8.5 | Version: 2.14-858a | BUILD: 220513-0819 | SVN Version: 3602 | DB Schema Version: 1661 | Asterisk 16.17.0-vici
www.CyburDial.net -:- 725-22-CYBUR -:- My Blog: http://vicidial.blog -:- Whatsapp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 1816
Joined: Wed Apr 08, 2020 2:02 am
Location: Coral Springs, FL


Return to Support

Who is online

Users browsing this forum: Google [Bot] and 33 guests