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

When MySQL 5.6 default option "sql_mode = STRICT_TRANS_TABLES", Zabbix can not save alert messages.

XMLWordPrintable

    • Team A
    • Sprint 1

      An error occurs if you register over than 65535 characters in the messages column of the action message.
      Also, when an error occurs, the action status of the escalations table remains active, and the query is written exclusively to zabbix_server.log.
      I updated the status of the escalation to COMPLETED.and now not logging error message.

      zabbix_server.log
      8704:20161226:174258.442 [Z3005] query failed: [1406] Data too long for column 'message' at row 1 [insert into alerts (alertid,actionid,eventid,userid,clock,mediatypeid,sendto,subject,message,status,error,esc_step,alerttype) values (15207076,39,18266071,30,1482741778,1,'root@localhost','[zabbix error message] .....................
      

      When sql_mode is invalidated, no error occurs.

      #sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
      sql_mode='NO_ENGINE_SUBSTITUTION'
      

            Unassigned Unassigned
            hayato.watanabe Hayato Watanabe
            Team A
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: