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

Typo in PK migration guide

XMLWordPrintable

    • Sprint 85 (Feb 2022)
    • 0.1

      Steps to reproduce:
      https://www.zabbix.com/documentation/6.0/en/manual/appendix/install/db_primary_keys

      Result:
      PostgreSQL section:

      \copy history_old TO '/tmp/history.csv' DELIMITER ',' CSV
             CREATE TEMP TABLE temp_history (
                 itemid                   bigint                                    NOT NULL,
                 clock                    integer         DEFAULT '0'               NOT NULL,
                 value                    DOUBLE PRECISION DEFAULT '0.0000'          NOT NULL,
                 ns                       integer         DEFAULT '0'               NOT NULL
             );
             \copy temp_history FROM '/tmp/history.csv' DELIMITER ',' CSV
             INSERT INTO history_uint SELECT * FROM temp_history ON CONFLICT (itemid,clock,ns) DO NOTHING;
      

      Expected:

             INSERT INTO history SELECT * FROM temp_history ON CONFLICT 
      

            martins-v Martins Valkovskis
            edgar.akhmetshin Edgar Akhmetshin
            Team A
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: