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

Zabbix eats up MySQL server connections

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Major Major
    • 1.8.7, 1.9.6 (beta)
    • 1.8.2
    • Server (S)
    • None
    • Hardware: Centos 5.3 (x86_64)
      Zabbix: 1.8.2
      MySQL: 5.0.45, innodb engine
      Apache: 2.2.3

      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.

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

              Created:
              Updated:
              Resolved: