Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

why ExceptionWhileProcessing didn't return err #1468

Open
btyABC opened this issue Jan 9, 2025 · 0 comments
Open

why ExceptionWhileProcessing didn't return err #1468

btyABC opened this issue Jan 9, 2025 · 0 comments
Labels

Comments

@btyABC
Copy link

btyABC commented Jan 9, 2025

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

<style> </style>
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
@btyABC btyABC added the question label Jan 9, 2025
@Algunenano Algunenano transferred this issue from ClickHouse/ClickHouse Jan 9, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant