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

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

    XMLWordPrintable

    Details

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

      Description

      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

        Attachments

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

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated: