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

ORA-03113 on Trigger update

    XMLWordPrintable

Details

    • Problem report
    • Status: Confirmed
    • Critical
    • Resolution: Unresolved
    • 5.0.26, 6.0.7
    • None
    • Frontend (F)
    • None

    Description

      Changes to trigger of template, linked to couple thousand of hosts results in:

      SQL error ORA-03113: end-of-file on communication channel
      

      Trigger has >=9 functions within the expression.
      Different trigger updates with 1-2 functions succeeds.

      Error and query attached as file: error

      Oracle support suggests fragmenting monolith query and feeding it with smaller chunks.
      And explains that extensive size queries will be dropped by backend DB.

      Issue found on zabbix v 5.4, but probably all current LTS versions are affected also.

      Attachments

        Issue Links

          Activity

            People

              zabbix.dev Zabbix Development Team
              atocko Andrey Tocko
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: