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

Zabbix eats up MySQL server connections

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.8.2
    • Fix Version/s: 1.8.7, 1.9.6 (beta)
    • Component/s: Server (S)
    • Labels:
      None
    • Environment:
      Hardware: Centos 5.3 (x86_64)
      Zabbix: 1.8.2
      MySQL: 5.0.45, innodb engine
      Apache: 2.2.3

      Description

      Almost once a day, the MySQL database stops accepting connections, which causes zabbix-server to stop. A 'show processlist' indicates most connection threads are attempting to update:

      UPDATE ids SET nextid=nextid+1 WHERE nodeid=0 AND table_name='auditlog' AND field_name='auditid'

      Doubling max_connections on MySQL doesn't help. The problem seems to occur more frequently when more users are viewing the webUI dashboard.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              troy troy dias
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: