JAVA 程序使用 OceanBase JDBC 驱动连接 OceanBase 数据库时,出现如下错误:unexpected end of stream, read 0 bytes from 4 (socket was closed by server)。 问题原因 当客户端在等待 SQL 执行在数据库中返回的过程中,发现链接被远端断开,程序则会抛出该错误。可能的原因有: ...
Error:(conn=25216) unexpected end of stream, read0bytesfrom4(socket was closed by server) 与业务沟通后,分析配置文件并观察后台报错信息,发现如下报错,设置全局弱读报错 业务之前的设置的变量为全局修改弱读 直接设置全局变量,在备库上是报错的 建议业务将set @@ob_read_consistency='weak'修改为set session ...
Java 程序使用 OceanBase Connector/J 驱动连接 OceanBase 数据库时,发生报错:unexpected end of stream, read 0 bytes from 4 (socket was closed by server). 问题原因 当客户端程序执行完 SQL 语句,在等待数据库服务器返回数据的过程中,如果连接突然被远端断开,Java 程序就会抛出该错误。
【问题描述】 执行SQL 失败,错误详情:Could not connect to address=(host=10.186.17.104)(port=22881)(type=master) : Could not connect to 10.186.17.104:22881 : unexpected end of stream, read 0 bytes from 4 (socket was closed by server) 2150×1512 298 KB 客户端可以直接连接 1876×690 83.8 ...
Caused by: java.io.EOFException: unexpected end of stream, read 0 bytes from 4 (socket was closed by server) at com.oceanbase.jdbc.internal.io.input.StandardPacketInputStream.getPacketArray(StandardPacketInputStream.java:249) ~[oceanbase-client-2.2.7.jar!/:na] ...
SERVER_ADDR:出错或者断连接时对应的OBServer节点的地址 CLUSTER_NAME:集群名 TENANT_NAME:租户名 USER_NAME:用户名 ERROR_CODE:错误码 ERROR_MSG:错误信息,诊断断连接的关键内容 REQUEST_CMD:obproxy当前正在执行的sql语句的类型,可能为内部请求的sql语句类型 ...
and a.begin_interval_time< time_to_usec('$TIME1') and a.ob_tenant_id=xxx and a.cluster_name='oxxx'and ob_server_idin(3,4) and retry_cnt=0group by a.sql_id order by3desc limit100)wheretoday_avg_elapsed-last_avg_elapsed>500and last_avg_elapsed<1000;!echo sleep120done...
The following error messages may be returned: Connection reset by peer: socket write error unexpeted end of steam, read 0 bytes from 4(socket was closed by server) Possible causes If the ODP is configured with a persistent connection anduser_timeoutis set to a smaller value, when packet ...
Q: What do I do if the errorsocket was closed by serveris reported on OBLOADER and an OOM error is returned for OceanBase Database Proxy (ODP) when I import data of a KEY-partitioned table to OceanBase Database in MySQL mode by using ODP (Sharding)?
连接OBProxy 时,ODC 频繁出现连接已断开提示,但是直连 OBServer 则无此问题。 报错信息可能包括: Connection reset by peer: socket write error unexpeted end of steam, read 0 bytes from 4(socket was closed by server) 报错信息示例: 弹窗形式