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

Alter table rename column fails on IBM DB2 when upgrading 3.0 to 3.4

    XMLWordPrintable

    Details

    • Team:
      Team C
    • Sprint:
      Sprint 14, Sprint 15
    • Story Points:
      0.5

      Description

       11460:20170817:163205.023 completed 53% of database upgrade
       11460:20170817:163205.069 [Z3005] query failed: [-478] 42893 [IBM][CLI Driver][DB2/LINUXX8664] SQL0478N  DROP, ALTER, TRANSFER OWNERSHIP or REVOKE on object type "COLUMN" cannot be processed because there is an object "SQL170817163422740", of type "PRIMARY KEY", which depends on it.  SQLSTATE=42893 [alter table sysmap_shape rename column shapeid to sysmap_shapeid]
       11460:20170817:163205.071 database upgrade failed
      

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            vso Vladislavs Sokurenko
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: