dbeaver的Connection reset by peer: socket write error报错

最新推荐文章于 2025-03-31 17:49:09 发布

空气城堡

最新推荐文章于 2025-03-31 17:49:09 发布

阅读量5.9k

点赞数 3

分类专栏： dbeaver hive

本文链接：https://blog.csdn.net/qq_44833146/article/details/109022458

版权

hive 同时被 2 个专栏收录

4 篇文章

订阅专栏

dbeaver

2 篇文章

订阅专栏

项目场景：

hive2
dbeaver

问题描述：

使用dbeaver,长时间没有操作,或者电脑关盖后,dbeaver与虚拟机断开连接,后再连接虚拟机的hive仓库报错

org.jkiss.dbeaver.model.sql.DBSQLException: SQL 错误 [08S01]: org.apache.thrift.transport.TTransportException: java.net.SocketException: Connection reset by peer: socket write error
	at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:135)
	at org.jkiss.dbeaver.model.impl.jdbc.struct.JDBCTable.readData(JDBCTable.java:188)
	at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRead.java:121)
	at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:168)
	at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:119)
	at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$ResultSetDataPumpJob.run(ResultSetViewer.java:4425)
	at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:105)
	at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63)
Caused by: java.sql.SQLException: org.apache.thrift.transport.TTransportException: java.net.SocketException: Connection reset by peer: socket write error
	at org.apache.hive.jdbc.HiveStatement.runAsyncOnServer(HiveStatement.java:311)
	at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:244)
	at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.execute(JDBCStatementImpl.java:342)
	at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:132)
	... 7 more
Caused by: org.apache.thrift.transport.TTransportException: java.net.SocketException: Connection reset by peer: socket write error
	at org.apache.thrift.transport.TIOStreamTransport.flush(TIOStreamTransport.java:161)
	at org.apache.thrift.transport.TSaslTransport.flush(TSaslTransport.java:501)
	at org.apache.thrift.transport.TSaslClientTransport.flush(TSaslClientTransport.java:37)
	at org.apache.thrift.TServiceClient.sendBase(TServiceClient.java:73)
	at org.apache.thrift.TServiceClient.sendBase(TServiceClient.java:62)
	at org.apache.hive.service.cli.thrift.TCLIService$Client.send_ExecuteStatement(TCLIService.java:227)
	at org.apache.hive.service.cli.thrift.TCLIService$Client.ExecuteStatement(TCLIService.java:219)
	at jdk.internal.reflect.GeneratedMethodAccessor75.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.base/java.lang.reflect.Method.invoke(Unknown Source)
	at org.apache.hive.jdbc.HiveConnection$SynchronizedHandler.invoke(HiveConnection.java:1443)
	at com.sun.proxy.$Proxy24.ExecuteStatement(Unknown Source)
	at org.apache.hive.jdbc.HiveStatement.runAsyncOnServer(HiveStatement.java:302)
	... 10 more
Caused by: java.net.SocketException: Connection reset by peer: socket write error
	at java.base/java.net.SocketOutputStream.socketWrite0(Native Method)
	at java.base/java.net.SocketOutputStream.socketWrite(Unknown Source)
	at java.base/java.net.SocketOutputStream.write(Unknown Source)
	at java.base/java.io.BufferedOutputStream.flushBuffer(Unknown Source)
	at java.base/java.io.BufferedOutputStream.flush(Unknown Source)
	at org.apache.thrift.transport.TIOStreamTransport.flush(TIOStreamTransport.java:159)
	... 22 more

在这里插入图片描述

原因分析：

网上搜了一下,发现这篇文章有帮助
重新分析connection reset by peer, socket write error错误原因
猜测大致问题出在网络连接中,(可能是dbeaver断开连接后,再去连接时,"验证码"不对之类的问题)

解决方案：

![在这里插入图片描述](https://img-blog.csdnimg.cn/20201012102230883.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQ0ODMzMTQ2,size_16,color_FFFFFF,t_70#pic_center