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

MySQL insert into "alerts" table fails with "[Z3005] query failed: [1406] Data too long for column 'message'" in case of very long alert messages

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • 2.0.9
    • Server (S)
    • None
    • Zabbix Server 2.0.9 using MySQL 5.6.12-56 Percona Server

      in this case, I have a trigger that sends out an email including the item.lastvalue, the problem is that the item is set as "text", so it's limited to 65535 chars, no problem here, the problem arises when that item generates and event and a trigger fires, making an action take place, the action is to send an email with some informative text, the alert is then stored by Zabbix into the alerts table, along with the full message sent by the action, and here's the problem, the "item.lastvalue" + the action text is bigger than 65535 chars, thus generating a MySQL error while zabbix tries to insert the alert entry, since that column is also defined as "text".

      Attacched a txt with the full error from zabbix_server.log

        1. alert.log
          99 kB
          Gabriele Armao
        2. alerts_message_too_long.txt
          65 kB
          Gabriele Armao

            Unassigned Unassigned
            gabriele.armao Gabriele Armao
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: