-
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:
- Fresh upgrade from 7.4.x to 8.0.0
- Install and configure Clickhouse database
- Export old history from PostgreSQL
- 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