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 C
    • Sprint 62 (Mar 2020)
    • 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

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

            Dates

              Created:
              Updated:
              Resolved: