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

When upgrading to 5.0.12 'subject' can become too long via {TRIGGER.NAME} is converted to {EVENT.RECOVERY.NAME}

    XMLWordPrintable

Details

    • Team A
    • Sprint 77 (Jun 2021), Sprint 78 (Jul 2021)
    • 0.25

    Description

      Hi,
      Create notification message subject ~250 characters
      Upgrade from 5.0.x to 5.0.12 and the Zabbix upgrade fails:

      1108:20210531:182005.428 starting automatic database upgrade
      1108:20210531:182005.441 [Z3005] query failed: [1406] Data too long for column 'subject' at row 1 [update opmessage set subject='......',message='........']
      

      {EVENT.NAME} -> {EVENT.RECOVERY.NAME} (ZBX-19102)
      and it's more then `subject` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ''

      Regards, Elina

      Attachments

        Issue Links

          Activity

            People

              dgoloscapov Dmitrijs Goloscapovs
              elina.kuzyutkina Elina Kuzyutkina
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: