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

Bug in PostgreSQL Upgrade patch (1.6.x->1.8)

    XMLWordPrintable

Details

    • Incident report
    • Resolution: Fixed
    • Major
    • 1.8.1
    • 1.8
    • Server (S)
    • None

    Description

      In the PostgreSQL 1.6->1.8 Upgrade SQL, this statement is incorrect:

      CREATE TABLE sysmaps_tmp
      (
      sysmapid bigint NOT NULL DEFAULT 0,
      name varchar(128) NOT NULL DEFAULT '',
      width integer NOT NULL DEFAULT 0,
      height integer NOT NULL DEFAULT 0,
      backgroundid bigint NOT NULL DEFAULT 0,
      label_type integer NOT NULL DEFAULT 0,
      label_location integer NOT NULL DEFAULT 0,
      highlight integer NOT NULL DEFAULT 1
      )
      WITH (
      OIDS=TRUE
      );

      Here's the correct statement:

      CREATE TABLE sysmaps_tmp
      (
      sysmapid bigint NOT NULL DEFAULT 0,
      name varchar(128) NOT NULL DEFAULT '',
      width integer NOT NULL DEFAULT 0,
      height integer NOT NULL DEFAULT 0,
      backgroundid bigint NOT NULL DEFAULT 0,
      label_type integer NOT NULL DEFAULT 0,
      label_location integer NOT NULL DEFAULT 0,
      highlight integer NOT NULL DEFAULT 1
      )
      WITH OIDS=TRUE;

      Strangely, all other statements are written correctly. The bug leaves you with a complete loss of all system maps (because the sysmaps table is dropped after this statement).

      Attachments

        Activity

          People

            sasha Alexander Vladishev
            ploeger Dennis Ploeger
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: