ExportXMLWordPrintable

    • Type: Problem report
    • Resolution: Unresolved
    • Priority: Trivial
    • None
    • Affects Version/s: 8.0.0
    • Component/s: Server (S)
    • None
    • Environment:
      Zabbix 8.0.0
      Rocky Linux release 9.9 (Blue Onyx)
      curl 7.76.1 (x86_64-redhat-linux-gnu)

      Steps to reproduce:

      1. Fresh upgrade from 7.4.x to 8.0.0
      2. Install and configure Clickhouse database
      3. Export old history from PostgreSQL
      4. Import to clickhouse

       

      The import will fail due to missing training / in history_import.sh at $CH_URL?query.

      current:

      curl "${CH_CURL_OPTS[@]}" -X POST "$CH_URL?query=INSERT%20INTO%20$CH_DB.history%20FORMAT%20CSV" -T "$CH_IMPORT_DIR/history_clockns.csv"

      Fixed:

      curl "${CH_CURL_OPTS[@]}" -X POST "$CH_URL/?query=INSERT%20INTO%20$CH_DB.history%20FORMAT%20CSV" -T "$CH_IMPORT_DIR/history_clockns.csv"

       

       

      Result:

      [root@rocky-hel1-1 clickhouse_migration]# psql -U zabbix -d zabbix -W -h 127.0.0.1 -f /usr/share/zabbix/sql-scripts/clickhouse/history_export_pgsql.sql

      Password:

      COPY 101080715

      [root@rocky-hel1-1 clickhouse_migration]# /usr/share/zabbix/sql-scripts/clickhouse/history_import.sh -s http://localhost:8123 -d zabbix -u zabbix

      Code: 27. DB::Exception: Cannot parse input: expected ',' before: '/history_clockns.csv\n10073,1787270453.209957763,13.350105035888152\n10073,1787270513.287194648,13.649096438467136\n10073,1787270573.363622088,13.333016527988136\n1': (at row 1)

      :

      Row 1:

      Column 0,   name: itemid,   type: UInt64,        ERROR: text "/history_c" is not like UInt64

       

      : While executing ParallelParsingBlockInputFormat. (CANNOT_PARSE_INPUT_ASSERTION_FAILED) (version 26.10.6.18 (official build))

      [root@rocky-hel1-1 clickhouse_migration]#

       

      Expected:

      Successful import

            Assignee:
            Zabbix Support Team
            Reporter:
            Antti Hurme
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: