Lock wait timeout exceeded; try restarting transaction

XMLWordPrintable

    • Type: Incident report
    • Resolution: Won't fix
    • Priority: Critical
    • None
    • Affects Version/s: None
    • Component/s: Server (S)
    • None

      Hello,

      This error has been logged in zabbix server v2.4 that locked the resources and the service get stuck. I restarted the service and the service resumed to operate properly.
      I checked the performance metrics and everything seemed fine.
      Here is the log entry that triggered the issue:
      ยป 21 Dec 2016 12:32:55.456 21312:20161221:063255.200 [Z3005] query failed: [1205] Lock wait timeout exceeded; try restarting transaction [update hosts set disable_until=1482319984,error='Get value from agent failed: cannot connect to [[ip-address]:10050]: [4] Interrupted system call' where hostid=15115] Context

      Note that an RDS instance is being used as database backend for Zabbix server. The RDS instance engine is MySQL 5.5.40.

      Thanks

            Assignee:
            Unassigned
            Reporter:
            Alex Mahone
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: