Error frequently appearing on the dashboard after fresh installation : Error in query [...][Deadlock found when trying to get lock; try restarting transaction]

XMLWordPrintable

    • Type: Incident report
    • Resolution: Unresolved
    • Priority: Trivial
    • None
    • Affects Version/s: 2.2.3
    • Component/s: Frontend (F)
    • Environment:
      Zabbix 2.2.3
      Red Hat Enterprise Linux Server release 5.9 (Tikanga)
      MySQL 5

      There is a frequently (once or more in one minute) error message on the zabbix frontend:

      Error in query [UPDATE sessions SET lastaccess=1404993865 WHERE userid=1801800000000001 AND sessionid='ed1f87051e2755c248385dbbc5e904e3'] [Deadlock found when trying to get lock; try restarting transaction]

      Screenshots of the frontend are attached.

      I appreciate your help

        1. Capture1.PNG
          104 kB
          Kev Hr
        2. Capture2.PNG
          105 kB
          Kev Hr
        3. log.txt
          3 kB
          Kev Hr

            Assignee:
            Unassigned
            Reporter:
            Kev Hr
            Votes:
            3 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated: