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

    • Sprint 14, Sprint 15
    • 0.5 

       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

        1. sysmap_shapes_upgrade.patch
          0.8 kB
          Vjaceslavs Bogdanovs

            Unassigned Unassigned
            vso Vladislavs Sokurenko
            Team C
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: