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

Frequent "Lock wait timeout exceeded; try restarting transaction" on zabbix_server. LLD related ?

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 2.0.0, 2.0.1
    • Fix Version/s: 2.0.6rc1, 2.1.0
    • Component/s: Server (S)
    • Environment:
      MySQL 5.5.25 on Suse Enterprise linux, zabbix_server on OpenSUSE 12.1 (both 64Bit)

      Description

      On a fresh 2.0.0 installation using only builtin templates (SNMP devices), I frequently get messages like these in /tmp/zabbix_server.log :
      11858:20120621:173328.785 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update items set lastclock=1340292671,lastns=654346890,prevvalue=lastvalue,lastvalue='ET-WLB01' where itemid=23471;
      11859:20120621:173457.775 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update items set lastclock=1340290488,lastns=545936090,prevvalue=lastvalue,lastvalue='30.000000' where itemid=23328;

      Even more often: 11787:20120621:173328.800 slow query: 104.092488 sec, "update items set name='Free inodes on $1 (percentage)',key_='vfs.fs.inode[/,pfree]',type=0,value_type=0,data_type=0,delay=60,delay_flex='',history=7,trends=365,trapper_hosts='',units='%',multiplier=0,delta=0,formula='1',logtimefmt='',valuemapid=null,params='',ipmi_sensor='',snmp_community='',snmp_oid='',port='',snmpv3_securityname='',snmpv3_securitylevel=0,snmpv3_authpassphrase='',snmpv3_privpassphrase='',authtype=0,username='',password='',publickey='',privatekey='',description='',interfaceid=7,flags=4 where itemid=23696;
      update item_discovery set key_='vfs.fs.inode[

      {#FSNAME}

      ,pfree]',lastcheck=1340292704,ts_delete=0 where itemid=23696 and parent_itemid=23507;

      All devices were added using Discovery on a few subnets, adding and linking to SNMP Device template anything that responds. Currently 271 devices are added.
      (Note: I also disabled everything except IfAlias, which is updated only once pr. day to lower traffic )

      Zabbix server runs on a VM, with 6 2,5Ghz Xeon cores and 2GB memory.
      MySQL runs on dedicated iron with 8 2,5Ghz Xeon cores and 8GB memory, with /varrlib/mysql mounted on a 4-disk RAID5 volume consisting of 10k RPM SAS disks.
      That should be able to do some damage, but I'm seeing close to 2k QPS on MySQL on average.

      Attaching slow query log, zabbix_server.conf and my.cnf.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              alfsolli Alf Solli
              Votes:
              11 Vote for this issue
              Watchers:
              21 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: