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

Zabbix cannot store alert message on Oracle : query failed:[-1] ORA-01704: string literal too long

    XMLWordPrintable

Details

    Description

      Zabbix cannot store alert message on Oracle if the alert mesage is long. Escalator process retry inserting the alert every 3 seconds.
      This happenes if alert setting has

      {ITEM.VALUE}

      macro for log item.

      Error message on zabbix_server.log:

      query failed:[-1] ORA-01704: string literal too long [insert into alerts (alertid, actionid, ...

      message column in alerts table is nvarchar2(2048) on Oracle.

      Attachments

        Issue Links

          is duplicated by

          Incident report - Incident report 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

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Unassigned Unassigned
              kodai Kodai Terashima
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: