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

Oracle: Upgrade patch from 4.4 to 5.0.0alpha3 failure

    XMLWordPrintable

    Details

    • Team:
      Team C
    • Sprint:
      Sprint 62 (Mar 2020)
    • Story Points:
      0.5

      Description

      Problem description: When attempting to upgrade an Oracle database from 4.4 to 5.0.0alpha3 (by running zabbix_server), the upgrade patch fails with the following error:

      23115:20200325:190059.976 query [txnlev:1] [alter table auditlog modify resourceid drop default]
23115:20200325:190100.062 [Z3005] query failed: [-1] ORA-00902: invalid datatype [alter table auditlog modify resourceid drop default]
23115:20200325:190100.062 query [alter table auditlog modify resourceid drop default] failed, setting transaction as failed
23115:20200325:190100.099 database upgrade failed

        Attachments

          Activity

            People

            Assignee:
            asestakovs Aleksejs Sestakovs
            Reporter:
            solonkins Sergejs Olonkins
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: