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

Oracle database error during 2.0 upgrade: ORA-01451

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Minor
    • Resolution: Cannot Reproduce
    • Affects Version/s: 2.0.0, 2.0.3
    • Fix Version/s: None
    • Component/s: Installation (I)
    • Environment:
      Zabbix 1.8.15, Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

      Description

      2.0 DB upgrade script for Oracle contains:

      ALTER TABLE triggers MODIFY templateid DEFAULT NULL;
      ALTER TABLE triggers MODIFY templateid NULL;

      It generates an error during upgrade:

      ALTER TABLE triggers MODIFY templateid NULL
      *
      ERROR at line 1:
      ORA-01451: column to be modified to NULL cannot be modified to NULL

      Looks like second line is redundant and should be removed.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              zalex_ua Oleksiy Zagorskyi
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: