Update auditlog queries prevent user login

XMLWordPrintable

    • Type: Incident report
    • Resolution: Cannot Reproduce
    • Priority: Major
    • None
    • Affects Version/s: 1.8.2
    • Component/s: Frontend (F)
    • Environment:
      CentOS 5.4, PHP 5.2.6, lighttpd 1.4.24 using fastcgi.

      Upon submission of the login form for user login. Frontend begins spamming two queries over and over to the DB. I have seen the queries go on for close to 3 hours before I forcibly killed the PHP threads.

      They deny a user from logging in.

      nelsonab has also experienced similar issues.

      This is on 3/24/2010 nightly.

      Two queries causing issues:

      67381 <USERNAME> <IP>:52440 zabbix182 Query 0 Updating UPDATE ids SET nextid=nextid+1 WHERE nodeid=0 AND table_name='items' AND field_name='itemid'
      67564 <USERNAME> <IP>:45818 zabbix182 Query 0 statistics SELECT nextid FROM ids WHERE nodeid=0 AND table_name='auditlog' AND field_name='auditid'

            Assignee:
            Unassigned
            Reporter:
            John Cesario
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: