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

Update auditlog queries prevent user login

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Cannot Reproduce
    • Icon: Major Major
    • None
    • 1.8.2
    • Frontend (F)
    • 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'

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

              Created:
              Updated:
              Resolved: