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.

    Details

    • Team:
      Team A
    • Sprint:
      Sprint 1

      Description

      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'
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                hayato.watanabe Hayato Watanabe
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: