Error when insert data from large file

67 views
Skip to first unread message

Tuấn Kha Lưu

unread,
Jul 18, 2023, 9:33:50 PM7/18/23
to ClickHouse
Can you please suggest some reasons for why I'm encountering a "Code: 210. DB::NetException: Connection reset by peer, while writing to socket (::1:9000): data for INSERT was parsed from stdin: (in query: INSERT INTO msrecords FORMAT Parquet). (NETWORKERROR)" error when trying to insert data into a Clickhouse table from a 500 Mb Parquet file? This issue doesn't occur when I insert from a file smaller than 100 Mb.

Pavel Kruglov

unread,
Jul 19, 2023, 8:28:04 AM7/19/23
to ClickHouse

For better diagnostics you can collect server logs for the insert query. For example, you can use setting `send_logs_level='trace'` in client for the insert query, it will print all server logs in client for the query

среда, 19 июля 2023 г. в 03:33:50 UTC+2, mr.cur...@gmail.com:
Reply all
Reply to author
Forward
0 new messages