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

1212 Deadlock found when trying to get lock; trends and trends_uint tables

    XMLWordPrintable

Details

    • Incident report
    • Status: Need info
    • Trivial
    • Resolution: Unresolved
    • 4.4.9
    • None
    • None
    • None
    • Centos 7, MariaDB 10.3.16

    Description

      Something as in https://support.zabbix.com/browse/ZBX-17851 I faced yesterday

      Steps to reproduce:

      Dont know because faced in first time.

      Only logs:

      [Z3005] query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [update trends set num=xx,value_min=xxxx.xxxxxx,value_avg=xxxx.xxxxxx,value_max=xxxx.xxxxxx where itemid=xxxxx and clock=1593475200;

      [...]~80 of them

      Unde xxxxx values are different only time was the same.

      And after that [Z3005] query failed: [1213] Deadlock found when trying to get lock; try restarting transaction [update trends_uint set num=xx,value_min=xx,value_avg=xx,value_max=xx where itemid=xxxxx and clock=1593475200;

      [...]~80 of them

      Attachments

        Activity

          People

            zabbix.support Zabbix Support Team
            Rostislav Gutsycat
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated: