Skip to content

why ExceptionWhileProcessing didn't return err #1468

@btyABC

Description

@btyABC

Company or project name

No response

Question

i am using go client "github.com/ClickHouse/clickhouse-go/v2",

this is the go code:

	deadlineCtx, cancel := context.WithDeadline(context.Background(), time.Now().Add(queryTimeout))
	defer cancel()
	rows, err := ch.Query(deadlineCtx, sql)
	if err != nil {
		return 0, err
	}
	defer rows.Close()

ch.Query didn't return err, but there are 0 rows in return.
I am sure query result of sql is not null.

this is the records in system.query_log

query_id initial_query_id event_time type query_duration_ms read_rows result_rows exception exception_code
298875b2-2a44-4425-b55d-a962168b5845 1d8f7afa-aaa6-4adf-934c-3185fb0e8026 2025-01-09T16:48:49+08:00 ExceptionWhileProcessing 177267 9173345491 0 Code: 210. DB::NetException: Connection reset by peer, while writing to socket (10.25.20.240:13289). (NETWORK_ERROR) (version 22.8.5.29 (official build)) 210
861c532c-08f7-4bce-a100-4b4cf3ee5bb0 1d8f7afa-aaa6-4adf-934c-3185fb0e8026 2025-01-09T16:48:49+08:00 ExceptionWhileProcessing 177177 9061079725 0 Code: 210. DB::NetException: Connection reset by peer, while writing to socket (10.25.20.240:52361). (NETWORK_ERROR) (version 22.8.5.29 (official build)) 210
8deca7f4-21f9-4d08-9b95-eb351f21ab0e 1d8f7afa-aaa6-4adf-934c-3185fb0e8026 2025-01-09T16:48:49+08:00 QueryFinish 177362 8087920455 0   0
8deca7f4-21f9-4d08-9b95-eb351f21ab0e 1d8f7afa-aaa6-4adf-934c-3185fb0e8026 2025-01-09T16:48:49+08:00 ExceptionWhileProcessing 177426 8087920455 0 Code: 210. DB::NetException: I/O error: Broken pipe, while writing to socket (10.25.20.240:24120). (NETWORK_ERROR) (version 22.8.5.29 (official build)) 210
331421bc-de76-4fd4-bab5-ffaa2045333f 1d8f7afa-aaa6-4adf-934c-3185fb0e8026 2025-01-09T16:48:49+08:00 QueryFinish 177272 9734829182 0   0
331421bc-de76-4fd4-bab5-ffaa2045333f 1d8f7afa-aaa6-4adf-934c-3185fb0e8026 2025-01-09T16:48:49+08:00 ExceptionWhileProcessing 177286 9734829182 0 Code: 210. DB::NetException: I/O error: Broken pipe, while writing to socket (10.25.20.240:3304). (NETWORK_ERROR) (version 22.8.5.29 (official build)) 210
5a3a40b7-a91b-4b2d-9039-fb4c38a8ea09 1d8f7afa-aaa6-4adf-934c-3185fb0e8026 2025-01-09T16:48:48+08:00 QueryFinish 176926 9066719102 0   0
1d8f7afa-aaa6-4adf-934c-3185fb0e8026 1d8f7afa-aaa6-4adf-934c-3185fb0e8026 2025-01-09T16:48:48+08:00 ExceptionWhileProcessing 177129 31762417821 0 Code: 210. DB::NetException: Connection reset by peer, while writing to socket (10.201.6.105:48232). (NETWORK_ERROR) (version 22.8.5.29 (official build)) 210
298875b2-2a44-4425-b55d-a962168b5845 1d8f7afa-aaa6-4adf-934c-3185fb0e8026 2025-01-09T16:45:51+08:00 QueryStart 0 0 0   0
861c532c-08f7-4bce-a100-4b4cf3ee5bb0 1d8f7afa-aaa6-4adf-934c-3185fb0e8026 2025-01-09T16:45:51+08:00 QueryStart 0 0 0   0
8deca7f4-21f9-4d08-9b95-eb351f21ab0e 1d8f7afa-aaa6-4adf-934c-3185fb0e8026 2025-01-09T16:45:51+08:00 QueryStart 0 0 0   0
331421bc-de76-4fd4-bab5-ffaa2045333f 1d8f7afa-aaa6-4adf-934c-3185fb0e8026 2025-01-09T16:45:51+08:00 QueryStart 0 0 0   0
5a3a40b7-a91b-4b2d-9039-fb4c38a8ea09 1d8f7afa-aaa6-4adf-934c-3185fb0e8026 2025-01-09T16:45:51+08:00 QueryStart 0 0 0   0
1d8f7afa-aaa6-4adf-934c-3185fb0e8026 1d8f7afa-aaa6-4adf-934c-3185fb0e8026 2025-01-09T16:45:51+08:00 QueryStart 0 0 0   0

Metadata

Metadata

Assignees

Labels

Type

No fields configured for Task.

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions