Skip to content

[client-v2] DB::Exception: <Unreadable error message> while error returned from Cloud instance #2440

@chernser

Description

@chernser

Description

Exception doesn't contain message from a server:
Code: 164. DB::Exception: <Unreadable error message> (transport error: 500)

Log

2025-06-10 19:16:01.278 - com.clickhouse.client.internal.apache.hc.client5.http.impl.classic.MainClientExec: ex-0000000007 connection can be kept alive for 10 SECONDS
2025-06-10 19:16:01.279 - com.clickhouse.client.api.Client: Trying to read error message: bytes available 0 
2025-06-10 19:16:01.279 - com.clickhouse.client.internal.apache.hc.client5.http.impl.classic.InternalHttpClient: InternalConnectionEndpoint-3c6022b releasing valid endpoint
2025-06-10 19:16:01.279 - com.clickhouse.client.internal.apache.hc.client5.http.impl.io.BasicHttpClientConnectionManager: ep-0000000002 Connection can be kept alive for 10 SECONDS
2025-06-10 19:16:01.279 - com.clickhouse.client.api.Client: read nothing
2025-06-10 19:16:01.279 - com.clickhouse.client.api.Client: message is empty
2025-06-10 19:16:01.281 - com.clickhouse.jdbc.internal.ExceptionUtils: Exception Message: null, Debug message: null
2025-06-10 19:16:01.372 - SQL Error [22000]: Code: 164. DB::Exception: <Unreadable error message> (transport error: 500)
org.jkiss.dbeaver.model.sql.DBSQLException: SQL Error [22000]: Code: 164. DB::Exception: <Unreadable error message> (transport error: 500)

Pay attention to the

2025-06-10 19:16:01.279 - com.clickhouse.client.internal.apache.hc.client5.http.impl.classic.InternalHttpClient: InternalConnectionEndpoint-3c6022b releasing valid endpoint

It means that response doesn't contain any body. This handled in org.apache.hc.client5.http.impl.classic.MainClientExec#execute :

// check for entity, release connection if possible
final HttpEntity entity = response.getEntity();
if (entity == null || !entity.isStreaming()) {
    // connection not needed and (assumed to be) in re-usable state
    execRuntime.releaseEndpoint();
    return new CloseableHttpResponse(response, null);
}
return new CloseableHttpResponse(response, execRuntime);

Environment

  • Client version: 0.8.6
  • Cloud

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions