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

Typo in PK migration guide

    XMLWordPrintable

Details

    • Team A
    • Sprint 85 (Feb 2022)
    • 0.1

    Description

      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 
      

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: