-
Type:
Problem report
-
Resolution: Unresolved
-
Priority:
Minor
-
None
-
Affects Version/s: 8.0.0rc2
-
Component/s: Installation (I), Server (S)
Steps to reproduce:
- Prepare import file: PGPASSWORD=zabbix psql -U postgres -d zbxnext-10837-7.5 -h 127.0.0.1 -f history_json_export_pgsql.sql
- Example of my data: 72013,1792410163.000000000,"{""test"": 123}",""
- Send data to ClickHouse: /database/clickhouse $ ./history_json_import.sh -u zabbix -p zabbix
Note: observed with all import scripts.
Result: Error appears:
+ curl -u zabbix:zabbix -X POST 'http://localhost:8123?query=INSERT%20INTO%20zabbix.history_json%20FORMAT%20CSV' -T /tmp/history_json_clockns.csv Code: 27. DB::Exception: Cannot parse input: expected ',' before: '/history_json_clockns.csv\n72013,1792471417.000000000,"{""test"": 5551}",""\n': (at row 1) : Row 1: Column 0, name: itemid, type: UInt64, ERROR: text "/history_j" is not like UInt64: While executing WaitForAsyncInsert. (CANNOT_PARSE_INPUT_ASSERTION_FAILED) (version 26.4.5.143 (official build))
Expected: No errors. Historical data successfully sent to ClickHouse.
Workaround: I was able to move my history data when I changed history_json_import.sh file to:
curl $CH_CURL_AUTH -X POST "$CH_URL?query=INSERT%20INTO%20$CH_DB.history_json%20FORMAT%20CSV" --data-binary "@/tmp/history_json_clockns.csv"
- caused by
-
ZBXNEXT-10347 Add clickhouse history backend
-
- Done
-
- related to
-
-
- Closed
-