Alerter cannot update 'alert' table

XMLWordPrintable

    • Type: Incident report
    • Resolution: Fixed
    • Priority: Minor
    • None
    • Affects Version/s: 3.2.1
    • Component/s: Server (S)
    • None
    • Environment:
      Red Hat Enterprise Linux Server release 6.4 (Santiago)
      mysql-community-server.x86_64 5.7.15-1.el6

      When auto commit is ON, 'alerter' cannot update 'alerts' table.
      When I changed MySQL setting by adding 'autocommit=1' to /etc/my.cnf,
      Zabbix could not send alert mails. When Zabbix is restarted, the alert mails are sent but 'status' column of 'alerts' table dose not change.

      After auto commit is OFF, 'alerter' can update 'alerts' table.

        1. zabbix_server.zip
          291 kB

            Assignee:
            Unassigned
            Reporter:
            Hideto Tange
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: