Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-18382

modifications on template linked to many hosts doesn't work

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Unresolved
    • Icon: Trivial Trivial
    • None
    • None
    • None
    • None
    • Zabbix server 4.4.10

      Steps to reproduce:

      On a template linked to a lot of hosts (around 15k in our case), on a trigger click 'disable'.

      Result:
      It runs for a while and ends, the webpage loads no errors. The page loads with the header content, that two-level menu bar at the top of the page, but the main content is blank, and source shows <main></main> where actual content should be as seen in the screenshot
      Expected result:

      For the trigger to disable.

      Details: 

      When the trigger disable fails, the webpage goes blank and we see correlating database deadlocks on the ids table and its specifically on auditlog table each time. We're able to reproduce this behavior consistently.

       

      Corresponding source code:

      <!DOCTYPE html><!DOCTYPE html><html> <head> <meta http-equiv="X-UA-Compatible" content="IE=Edge"/> <meta charset="utf-8" /> <meta name="viewport" content="width=device-width, initial-scale=1"> <meta name="Author" content="Zabbix SIA" /> <title>servername_redacted: Configuration of triggers</title> <link rel="icon" href="favicon.ico"> <link rel="apple-touch-icon-precomposed" sizes="76x76" href="assets/img/apple-touch-icon-76x76-precomposed.png"> <link rel="apple-touch-icon-precomposed" sizes="120x120" href="assets/img/apple-touch-icon-120x120-precomposed.png"> <link rel="apple-touch-icon-precomposed" sizes="152x152" href="assets/img/apple-touch-icon-152x152-precomposed.png"> <link rel="apple-touch-icon-precomposed" sizes="180x180" href="assets/img/apple-touch-icon-180x180-precomposed.png"> <link rel="icon" sizes="192x192" href="assets/img/touch-icon-192x192.png"> <meta name="csrf-token" content="8b5c025592c5cb1d"/> <meta name="msapplication-TileImage" content="assets/img/ms-tile-144x144.png"> <meta name="msapplication-TileColor" content="#d40000"> <meta name="msapplication-config" content="none"/><link rel="stylesheet" type="text/css" href="assets/styles/hc-dark.css?1596159042" /><style type="text/css">.na-bg, .na-bg input[type="radio"]:checked + label, .na-bg:before, .flh-na-bg, .status-na-bg { background-color: #97AAB3 }.info-bg, .info-bg input[type="radio"]:checked + label, .info-bg:before, .flh-info-bg, .status-info-bg { background-color: #7499FF }.warning-bg, .warning-bg input[type="radio"]:checked + label, .warning-bg:before, .flh-warning-bg, .status-warning-bg { background-color: #FFC859 }.average-bg, .average-bg input[type="radio"]:checked + label, .average-bg:before, .flh-average-bg, .status-average-bg { background-color: #FFA059 }.high-bg, .high-bg input[type="radio"]:checked + label, .high-bg:before, .flh-high-bg, .status-high-bg { background-color: #E97659 }.disaster-bg, .disaster-bg input[type="radio"]:checked + label, .disaster-bg:before, .flh-disaster-bg, .status-disaster-bg { background-color: #E45959 }​</style><script>var PHP_TZ_OFFSET = 0,PHP_ZBX_FULL_DATE_TIME = "Y-m-d H:i:s";</script><script src="js/browsers.js"></script><script src="jsLoader.php?ver=4.4.10&lang=en_GB&showGuiMessaging=1"></script><script src="jsLoader.php?ver=4.4.10&lang=en_GB&files%5B0%5D=multiselect.js&files%5B1%5D=textareaflexible.js&files%5B2%5D=servercheck.js"></script></head><body lang="en"><output class="msg-global-footer msg-warning" id="msg-global-footer"></output><script type="text/javascript">MMenu.def_label = 'config'</script><header><div><div class="top-nav-container" id="mmenu"><a class="header-logo" href="zabbix.php?action=dashboard.view"><div class="logo"></div></a><nav aria-label="Main navigation"><ul class="top-nav"><li id="view"><a onclick="javascript: MMenu.mouseOver('view');" onkeyup="javascript: MMenu.keyUp('view', event);" tabindex="0" role="button" href="javascript:void(0)">Monitoring</a></li><li id="cm"><a onclick="javascript: MMenu.mouseOver('cm');" onkeyup="javascript: MMenu.keyUp('cm', event);" tabindex="0" role="button" href="javascript:void(0)">Inventory</a></li><li id="reports"><a onclick="javascript: MMenu.mouseOver('reports');" onkeyup="javascript: MMenu.keyUp('reports', event);" tabindex="0" role="button" href="javascript:void(0)">Reports</a></li><li class="selected" id="config"><a onclick="javascript: MMenu.mouseOver('config');" onkeyup="javascript: MMenu.keyUp('config', event);" tabindex="0" role="button" href="javascript:void(0)">Configuration</a></li><li id="admin"><a onclick="javascript: MMenu.mouseOver('admin');" onkeyup="javascript: MMenu.keyUp('admin', event);" tabindex="0" role="button" href="javascript:void(0)">Administration</a></li></ul></nav><ul class="top-nav-icons"><li><form method="get" action="zabbix.php" accept-charset="utf-8" role="search"><input type="hidden" name="action" value="search"><input type="text" id="search" name="search" value="" maxlength="255" autocomplete="off" class="search" aria-label="type here to search"><button type="submit" class="btn-search" title="Search">&nbsp;</button></form></li><li><ul role="navigation" aria-label="User menu"><li style="padding-left:0"><a class="top-nav-support" target="_blank" title="Zabbix Technical Support" href="https://www.zabbix.com/support">Support</a></li><li><a class="top-nav-zbbshare" target="_blank" title="Zabbix Share" href="https://share.zabbix.com/">Share</a></li><li><a class="top-nav-help" target="_blank" title="Help" href="https://www.zabbix.com/documentation/4.4/">&nbsp;</a></li><li><a class="top-nav-profile" title="uid_redacted (name_redacted)" href="zabbix.php?action=userprofile.edit"></a></li><li><a class="top-nav-signout" title="Sign out" onclick="ZABBIX.logout()" href="javascript:;">&nbsp;</a></li></ul></li></ul></div><nav aria-label="Sub navigation" class="top-subnav-container" onmouseover="javascript: MMenu.submenu_mouseOver();" onmouseout="javascript: MMenu.mouseOut();"><ul class="top-subnav" id="sub_view" style="display: none;"><li><a tabindex="0" href="zabbix.php?action=dashboard.view&ddreset=1">Dashboard</a></li><li><a tabindex="0" href="zabbix.php?action=problem.view&ddreset=1">Problems</a></li><li><a tabindex="0" href="overview.php?ddreset=1">Overview</a></li><li><a tabindex="0" href="zabbix.php?action=web.view&ddreset=1">Web</a></li><li><a tabindex="0" href="latest.php?ddreset=1">Latest data</a></li><li><a tabindex="0" href="charts.php?ddreset=1">Graphs</a></li><li><a tabindex="0" href="screens.php?ddreset=1">Screens</a></li><li><a tabindex="0" href="zabbix.php?action=map.view&ddreset=1">Maps</a></li><li><a tabindex="0" href="zabbix.php?action=discovery.view&ddreset=1">Discovery</a></li><li><a tabindex="0" href="srv_status.php?ddreset=1">Services</a></li></ul><ul class="top-subnav" id="sub_cm" style="display: none;"><li><a tabindex="0" href="hostinventoriesoverview.php?ddreset=1">Overview</a></li><li><a tabindex="0" href="hostinventories.php?ddreset=1">Hosts</a></li></ul><ul class="top-subnav" id="sub_reports" style="display: none;"><li><a tabindex="0" href="zabbix.php?action=report.status&ddreset=1">System information</a></li><li><a tabindex="0" href="report2.php?ddreset=1">Availability report</a></li><li><a tabindex="0" href="toptriggers.php?ddreset=1">Triggers top 100</a></li><li><a tabindex="0" href="auditlogs.php?ddreset=1">Audit</a></li><li><a tabindex="0" href="auditacts.php?ddreset=1">Action log</a></li><li><a tabindex="0" href="report4.php?ddreset=1">Notifications</a></li></ul><ul class="top-subnav" id="sub_config" style="display: block;"><li><a tabindex="0" href="hostgroups.php?ddreset=1">Host groups</a></li><li><a tabindex="0" href="templates.php?ddreset=1">Templates</a></li><li><a tabindex="0" class="selected" href="hosts.php?ddreset=1">Hosts</a></li><li><a tabindex="0" href="maintenance.php?ddreset=1">Maintenance</a></li><li><a tabindex="0" href="actionconf.php?ddreset=1">Actions</a></li><li><a tabindex="0" href="correlation.php?ddreset=1">Event correlation</a></li><li><a tabindex="0" href="discoveryconf.php?ddreset=1">Discovery</a></li><li><a tabindex="0" href="services.php?ddreset=1">Services</a></li></ul><ul class="top-subnav" id="sub_admin" style="display: none;"><li><a tabindex="0" href="adm.gui.php?ddreset=1">General</a></li><li><a tabindex="0" href="zabbix.php?action=proxy.list&ddreset=1">Proxies</a></li><li><a tabindex="0" href="zabbix.php?action=authentication.edit&ddreset=1">Authentication</a></li><li><a tabindex="0" href="usergrps.php?ddreset=1">User groups</a></li><li><a tabindex="0" href="zabbix.php?action=user.list&ddreset=1">Users</a></li><li><a tabindex="0" href="zabbix.php?action=mediatype.list&ddreset=1">Media types</a></li><li><a tabindex="0" href="zabbix.php?action=script.list&ddreset=1">Scripts</a></li><li><a tabindex="0" href="queue.php?ddreset=1">Queue</a></li></ul><div class="server-name">servername_redacted</div></nav></div></header><main>

      Deadlocks from the database:

      2020-09-16T10:44:09.090817-08:00 357779 [Note] InnoDB: Transactions deadlock detected, dumping detailed information.
2020-09-16T10:44:09.090890-08:00 357779 [Note] InnoDB:
*** (1) TRANSACTION:TRANSACTION 4527128451, ACTIVE 99 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 5 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 1
MySQL thread id 357672, OS thread handle 139711911487232, query id 510782586 <ip1_redacted> <db_user_redacted> statistics
SELECT nextid FROM ids WHERE table_name='auditlog' AND field_name='auditid' FOR UPDATE
2020-09-16T10:44:09.091258-08:00 357779 [Note] InnoDB: *** (1) WAITING FOR THIS LOCK TO BE GRANTED:RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527128451 lock_mode X locks rec but not gap waiting
2020-09-16T10:44:09.091437-08:00 357779 [Note] InnoDB: *** (2) TRANSACTION:TRANSACTION 4527136559, ACTIVE 55 sec inserting
mysql tables in use 1, locked 1
6 lock struct(s), heap size 1136, 4 row lock(s), undo log entries 2
MySQL thread id 357779, OS thread handle 139711891212032, query id 510783090 <ip1_redacted> <db_user_redacted> update
INSERT INTO ids (table_name,field_name,nextid) VALUES ('auditlog','auditid',5274681)
2020-09-16T10:44:09.091618-08:00 357779 [Note] InnoDB: *** (2) HOLDS THE LOCK(S):RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527136559 lock_mode X locks rec but not gap
2020-09-16T10:44:09.091727-08:00 357779 [Note] InnoDB: *** (2) WAITING FOR THIS LOCK TO BE GRANTED:RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527136559 lock mode S waiting
2020-09-16T10:44:09.091836-08:00 357779 [Note] InnoDB: *** WE ROLL BACK TRANSACTION (1)2020-09-16T10:44:09.092082-08:00 357779 [Note] InnoDB: Transactions deadlock detected, dumping detailed information.
2020-09-16T10:44:09.092107-08:00 357779 [Note] InnoDB:
*** (1) TRANSACTION:TRANSACTION 4527129369, ACTIVE 97 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 5 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 1
MySQL thread id 357682, OS thread handle 139711917164288, query id 510782588 <ip2_redacted> <db_user_redacted> statistics
SELECT nextid FROM ids WHERE table_name='auditlog' AND field_name='auditid' FOR UPDATE
2020-09-16T10:44:09.092289-08:00 357779 [Note] InnoDB: *** (1) WAITING FOR THIS LOCK TO BE GRANTED:RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527129369 lock_mode X locks rec but not gap waiting
2020-09-16T10:44:09.092407-08:00 357779 [Note] InnoDB: *** (2) TRANSACTION:TRANSACTION 4527136559, ACTIVE 55 sec inserting
mysql tables in use 1, locked 1
6 lock struct(s), heap size 1136, 4 row lock(s), undo log entries 2
MySQL thread id 357779, OS thread handle 139711891212032, query id 510783090 <ip1_redacted> <db_user_redacted> update
INSERT INTO ids (table_name,field_name,nextid) VALUES ('auditlog','auditid',5274681)
2020-09-16T10:44:09.092558-08:00 357779 [Note] InnoDB: *** (2) HOLDS THE LOCK(S):RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527136559 lock_mode X locks rec but not gap
2020-09-16T10:44:09.092665-08:00 357779 [Note] InnoDB: *** (2) WAITING FOR THIS LOCK TO BE GRANTED:RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527136559 lock mode S waiting
2020-09-16T10:44:09.092754-08:00 357779 [Note] InnoDB: *** WE ROLL BACK TRANSACTION (1)2020-09-16T10:44:09.092814-08:00 357779 [Note] InnoDB: Transactions deadlock detected, dumping detailed information.
2020-09-16T10:44:09.092830-08:00 357779 [Note] InnoDB:
*** (1) TRANSACTION:TRANSACTION 4527141933, ACTIVE 42 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 5 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 1
MySQL thread id 357692, OS thread handle 139711892293376, query id 510782995 <ip3_redacted> <db_user_redacted> statistics
SELECT nextid FROM ids WHERE table_name='auditlog' AND field_name='auditid' FOR UPDATE
2020-09-16T10:44:09.093001-08:00 357779 [Note] InnoDB: *** (1) WAITING FOR THIS LOCK TO BE GRANTED:RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527141933 lock_mode X locks rec but not gap waiting
2020-09-16T10:44:09.093125-08:00 357779 [Note] InnoDB: *** (2) TRANSACTION:TRANSACTION 4527136559, ACTIVE 55 sec inserting
mysql tables in use 1, locked 1
6 lock struct(s), heap size 1136, 4 row lock(s), undo log entries 2
MySQL thread id 357779, OS thread handle 139711891212032, query id 510783090 <ip1_redacted> <db_user_redacted> update
INSERT INTO ids (table_name,field_name,nextid) VALUES ('auditlog','auditid',5274681)
2020-09-16T10:44:09.093260-08:00 357779 [Note] InnoDB: *** (2) HOLDS THE LOCK(S):RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527136559 lock_mode X locks rec but not gap
2020-09-16T10:44:09.093370-08:00 357779 [Note] InnoDB: *** (2) WAITING FOR THIS LOCK TO BE GRANTED:RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527136559 lock mode S waiting
2020-09-16T10:44:09.093474-08:00 357779 [Note] InnoDB: *** WE ROLL BACK TRANSACTION (1)2020-09-16T10:44:09.093522-08:00 357779 [Note] InnoDB: Transactions deadlock detected, dumping detailed information.
2020-09-16T10:44:09.093535-08:00 357779 [Note] InnoDB:
*** (1) TRANSACTION:TRANSACTION 4527143812, ACTIVE 37 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 5 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 1
MySQL thread id 357704, OS thread handle 139711891752704, query id 510782996 <ip3_redacted> <db_user_redacted> statistics
SELECT nextid FROM ids WHERE table_name='auditlog' AND field_name='auditid' FOR UPDATE
2020-09-16T10:44:09.093642-08:00 357779 [Note] InnoDB: *** (1) WAITING FOR THIS LOCK TO BE GRANTED:RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527143812 lock_mode X locks rec but not gap waiting
2020-09-16T10:44:09.093693-08:00 357779 [Note] InnoDB: *** (2) TRANSACTION:TRANSACTION 4527136559, ACTIVE 55 sec inserting
mysql tables in use 1, locked 1
6 lock struct(s), heap size 1136, 4 row lock(s), undo log entries 2
MySQL thread id 357779, OS thread handle 139711891212032, query id 510783090 <ip1_redacted> <db_user_redacted> update
INSERT INTO ids (table_name,field_name,nextid) VALUES ('auditlog','auditid',5274681)
2020-09-16T10:44:09.093771-08:00 357779 [Note] InnoDB: *** (2) HOLDS THE LOCK(S):RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527136559 lock_mode X locks rec but not gap
2020-09-16T10:44:09.093816-08:00 357779 [Note] InnoDB: *** (2) WAITING FOR THIS LOCK TO BE GRANTED:RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527136559 lock mode S waiting
2020-09-16T10:44:09.093869-08:00 357779 [Note] InnoDB: *** WE ROLL BACK TRANSACTION (1)2020-09-16T10:44:09.093905-08:00 357779 [Note] InnoDB: Transactions deadlock detected, dumping detailed information.
2020-09-16T10:44:09.093918-08:00 357779 [Note] InnoDB:
*** (1) TRANSACTION:TRANSACTION 4527142772, ACTIVE 39 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 6 lock struct(s), heap size 1136, 3 row lock(s), undo log entries 1
MySQL thread id 357812, OS thread handle 139712400992000, query id 510782997 <ip1_redacted> <db_user_redacted> statistics
SELECT nextid FROM ids WHERE table_name='auditlog' AND field_name='auditid' FOR UPDATE
2020-09-16T10:44:09.094009-08:00 357779 [Note] InnoDB: *** (1) WAITING FOR THIS LOCK TO BE GRANTED:RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527142772 lock_mode X locks rec but not gap waiting
2020-09-16T10:44:09.094110-08:00 357779 [Note] InnoDB: *** (2) TRANSACTION:TRANSACTION 4527136559, ACTIVE 55 sec inserting
mysql tables in use 1, locked 1
6 lock struct(s), heap size 1136, 4 row lock(s), undo log entries 2
MySQL thread id 357779, OS thread handle 139711891212032, query id 510783090 <ip1_redacted> <db_user_redacted> update
INSERT INTO ids (table_name,field_name,nextid) VALUES ('auditlog','auditid',5274681)
2020-09-16T10:44:09.094210-08:00 357779 [Note] InnoDB: *** (2) HOLDS THE LOCK(S):RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527136559 lock_mode X locks rec but not gap
2020-09-16T10:44:09.094255-08:00 357779 [Note] InnoDB: *** (2) WAITING FOR THIS LOCK TO BE GRANTED:RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527136559 lock mode S waiting
2020-09-16T10:44:09.094315-08:00 357779 [Note] InnoDB: *** WE ROLL BACK TRANSACTION (1)2020-09-16T10:44:09.094352-08:00 357779 [Note] InnoDB: Transactions deadlock detected, dumping detailed information.
2020-09-16T10:44:09.094365-08:00 357779 [Note] InnoDB:
*** (1) TRANSACTION:TRANSACTION 4527149629, ACTIVE 22 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 5 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 1
MySQL thread id 357853, OS thread handle 139712404236032, query id 510782998 <ip2_redacted> <db_user_redacted> statistics
SELECT nextid FROM ids WHERE table_name='auditlog' AND field_name='auditid' FOR UPDATE
2020-09-16T10:44:09.094455-08:00 357779 [Note] InnoDB: *** (1) WAITING FOR THIS LOCK TO BE GRANTED:RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527149629 lock_mode X locks rec but not gap waiting
2020-09-16T10:44:09.094505-08:00 357779 [Note] InnoDB: *** (2) TRANSACTION:TRANSACTION 4527136559, ACTIVE 55 sec inserting
mysql tables in use 1, locked 1
6 lock struct(s), heap size 1136, 4 row lock(s), undo log entries 2
MySQL thread id 357779, OS thread handle 139711891212032, query id 510783090 <ip1_redacted> <db_user_redacted> update
INSERT INTO ids (table_name,field_name,nextid) VALUES ('auditlog','auditid',5274681)
2020-09-16T10:44:09.094601-08:00 357779 [Note] InnoDB: *** (2) HOLDS THE LOCK(S):RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527136559 lock_mode X locks rec but not gap
2020-09-16T10:44:09.094646-08:00 357779 [Note] InnoDB: *** (2) WAITING FOR THIS LOCK TO BE GRANTED:RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527136559 lock mode S waiting
2020-09-16T10:44:09.094690-08:00 357779 [Note] InnoDB: *** WE ROLL BACK TRANSACTION (1)2020-09-16T10:44:09.094727-08:00 357779 [Note] InnoDB: Transactions deadlock detected, dumping detailed information.
2020-09-16T10:44:09.094740-08:00 357779 [Note] InnoDB:
*** (1) TRANSACTION:TRANSACTION 4527144254, ACTIVE 36 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 5 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 1
MySQL thread id 357709, OS thread handle 139711914460928, query id 510783000 <ip3_redacted> <db_user_redacted> statistics
SELECT nextid FROM ids WHERE table_name='auditlog' AND field_name='auditid' FOR UPDATE
2020-09-16T10:44:09.094837-08:00 357779 [Note] InnoDB: *** (1) WAITING FOR THIS LOCK TO BE GRANTED:RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527144254 lock_mode X locks rec but not gap waiting
2020-09-16T10:44:09.094886-08:00 357779 [Note] InnoDB: *** (2) TRANSACTION:TRANSACTION 4527136559, ACTIVE 55 sec inserting
mysql tables in use 1, locked 1
6 lock struct(s), heap size 1136, 4 row lock(s), undo log entries 2
MySQL thread id 357779, OS thread handle 139711891212032, query id 510783090 <ip1_redacted> <db_user_redacted> update
INSERT INTO ids (table_name,field_name,nextid) VALUES ('auditlog','auditid',5274681)
2020-09-16T10:44:09.094972-08:00 357779 [Note] InnoDB: *** (2) HOLDS THE LOCK(S):RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527136559 lock_mode X locks rec but not gap
2020-09-16T10:44:09.095026-08:00 357779 [Note] InnoDB: *** (2) WAITING FOR THIS LOCK TO BE GRANTED:RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527136559 lock mode S waiting
2020-09-16T10:44:09.095071-08:00 357779 [Note] InnoDB: *** WE ROLL BACK TRANSACTION (1)2020-09-16T10:44:09.095101-08:00 357779 [Note] InnoDB: Transactions deadlock detected, dumping detailed information.
2020-09-16T10:44:09.095113-08:00 357779 [Note] InnoDB:
*** (1) TRANSACTION:TRANSACTION 4527140835, ACTIVE 45 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 5 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 1
MySQL thread id 357683, OS thread handle 139711906350848, query id 510783001 <ip3_redacted> <db_user_redacted> statistics
SELECT nextid FROM ids WHERE table_name='auditlog' AND field_name='auditid' FOR UPDATE
2020-09-16T10:44:09.095216-08:00 357779 [Note] InnoDB: *** (1) WAITING FOR THIS LOCK TO BE GRANTED:RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527140835 lock_mode X locks rec but not gap waiting
2020-09-16T10:44:09.095269-08:00 357779 [Note] InnoDB: *** (2) TRANSACTION:TRANSACTION 4527136559, ACTIVE 55 sec inserting
mysql tables in use 1, locked 1
6 lock struct(s), heap size 1136, 4 row lock(s), undo log entries 2
MySQL thread id 357779, OS thread handle 139711891212032, query id 510783090 <ip1_redacted> <db_user_redacted> update
INSERT INTO ids (table_name,field_name,nextid) VALUES ('auditlog','auditid',5274681)
2020-09-16T10:44:09.095346-08:00 357779 [Note] InnoDB: *** (2) HOLDS THE LOCK(S):RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527136559 lock_mode X locks rec but not gap
2020-09-16T10:44:09.095405-08:00 357779 [Note] InnoDB: *** (2) WAITING FOR THIS LOCK TO BE GRANTED:RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527136559 lock mode S waiting
2020-09-16T10:44:09.095449-08:00 357779 [Note] InnoDB: *** WE ROLL BACK TRANSACTION (1)2020-09-16T10:44:09.095477-08:00 357779 [Note] InnoDB: Transactions deadlock detected, dumping detailed information.
2020-09-16T10:44:09.095488-08:00 357779 [Note] InnoDB:
*** (1) TRANSACTION:TRANSACTION 4527142603, ACTIVE 40 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 5 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 1
MySQL thread id 357697, OS thread handle 139712274327296, query id 510783002 <ip3_redacted> <db_user_redacted> statistics
SELECT nextid FROM ids WHERE table_name='auditlog' AND field_name='auditid' FOR UPDATE
2020-09-16T10:44:09.095559-08:00 357779 [Note] InnoDB: *** (1) WAITING FOR THIS LOCK TO BE GRANTED:RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527142603 lock_mode X locks rec but not gap waiting
2020-09-16T10:44:09.095617-08:00 357779 [Note] InnoDB: *** (2) TRANSACTION:TRANSACTION 4527136559, ACTIVE 55 sec inserting
mysql tables in use 1, locked 1
6 lock struct(s), heap size 1136, 4 row lock(s), undo log entries 2
MySQL thread id 357779, OS thread handle 139711891212032, query id 510783090 <ip1_redacted> <db_user_redacted> update
INSERT INTO ids (table_name,field_name,nextid) VALUES ('auditlog','auditid',5274681)
2020-09-16T10:44:09.095683-08:00 357779 [Note] InnoDB: *** (2) HOLDS THE LOCK(S):RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527136559 lock_mode X locks rec but not gap
2020-09-16T10:44:09.095740-08:00 357779 [Note] InnoDB: *** (2) WAITING FOR THIS LOCK TO BE GRANTED:RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527136559 lock mode S waiting
2020-09-16T10:44:09.095785-08:00 357779 [Note] InnoDB: *** WE ROLL BACK TRANSACTION (1)2020-09-16T10:44:09.095830-08:00 357779 [Note] InnoDB: Transactions deadlock detected, dumping detailed information.
2020-09-16T10:44:09.095843-08:00 357779 [Note] InnoDB:
*** (1) TRANSACTION:TRANSACTION 4527139709, ACTIVE 48 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 5 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 1
MySQL thread id 357676, OS thread handle 139711916353280, query id 510783003 <ip3_redacted> <db_user_redacted> statistics
SELECT nextid FROM ids WHERE table_name='auditlog' AND field_name='auditid' FOR UPDATE
2020-09-16T10:44:09.095921-08:00 357779 [Note] InnoDB: *** (1) WAITING FOR THIS LOCK TO BE GRANTED:RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527139709 lock_mode X locks rec but not gap waiting
2020-09-16T10:44:09.095980-08:00 357779 [Note] InnoDB: *** (2) TRANSACTION:TRANSACTION 4527136559, ACTIVE 55 sec inserting
mysql tables in use 1, locked 1
6 lock struct(s), heap size 1136, 4 row lock(s), undo log entries 2
MySQL thread id 357779, OS thread handle 139711891212032, query id 510783090 <ip1_redacted> <db_user_redacted> update
INSERT INTO ids (table_name,field_name,nextid) VALUES ('auditlog','auditid',5274681)
2020-09-16T10:44:09.096063-08:00 357779 [Note] InnoDB: *** (2) HOLDS THE LOCK(S):RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527136559 lock_mode X locks rec but not gap
2020-09-16T10:44:09.096116-08:00 357779 [Note] InnoDB: *** (2) WAITING FOR THIS LOCK TO BE GRANTED:RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527136559 lock mode S waiting
2020-09-16T10:44:09.096175-08:00 357779 [Note] InnoDB: *** WE ROLL BACK TRANSACTION (1)2020-09-16T10:44:09.096206-08:00 357779 [Note] InnoDB: Transactions deadlock detected, dumping detailed information.
2020-09-16T10:44:09.096219-08:00 357779 [Note] InnoDB:
*** (1) TRANSACTION:TRANSACTION 4527140450, ACTIVE 46 sec starting index read
mysql tables in use 1, locked 1
LOCK WAIT 5 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 1
MySQL thread id 357681, OS thread handle 139711891482368, query id 510783004 <ip3_redacted> <db_user_redacted> statistics
SELECT nextid FROM ids WHERE table_name='auditlog' AND field_name='auditid' FOR UPDATE
2020-09-16T10:44:09.096322-08:00 357779 [Note] InnoDB: *** (1) WAITING FOR THIS LOCK TO BE GRANTED:RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527140450 lock_mode X locks rec but not gap waiting
2020-09-16T10:44:09.096375-08:00 357779 [Note] InnoDB: *** (2) TRANSACTION:TRANSACTION 4527136559, ACTIVE 55 sec inserting
mysql tables in use 1, locked 1
6 lock struct(s), heap size 1136, 4 row lock(s), undo log entries 2
MySQL thread id 357779, OS thread handle 139711891212032, query id 510783090 <ip1_redacted> <db_user_redacted> update
INSERT INTO ids (table_name,field_name,nextid) VALUES ('auditlog','auditid',5274681)
2020-09-16T10:44:09.096454-08:00 357779 [Note] InnoDB: *** (2) HOLDS THE LOCK(S):RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527136559 lock_mode X locks rec but not gap
2020-09-16T10:44:09.096498-08:00 357779 [Note] InnoDB: *** (2) WAITING FOR THIS LOCK TO BE GRANTED:RECORD LOCKS space id 3952 page no 3 n bits 152 index PRIMARY of table `zabbix`.`ids` trx id 4527136559 lock mode S waiting
2020-09-16T10:44:09.096541-08:00 357779 [Note] InnoDB: *** WE ROLL BACK TRANSACTION (1)

      Let us know if we can provide further information to troubleshoot this.

        1. image-2020-09-16-15-11-03-821.png
          image-2020-09-16-15-11-03-821.png
          65 kB

            zabbix.support Zabbix Support Team
            skan Soumya
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated: