@TOC
Error querying database. Cause: java.sql.SQLException: org.apache.thrift.transport.TTransportException: java.net.SocketException: Broken pipe (Write failed)
The error may exist in URL
The error occurred while setting parameters
Cause: java.sql.SQLException: org.apache.thrift.transport.TTransportException: java.net.SocketException: Broken pipe (Write failed)
; SQL []; org.apache.thrift.transport.TTransportException: java.net.SocketException: Broken pipe (Write failed); nested exception is java.sql.SQLException: org.apache.thrift.transport.TTransportException: java.net.SocketException: Broken pipe (Write failed)
org.springframework.dao.DataAccessResourceFailureException:
Error querying database. Cause: java.sql.SQLException: org.apache.thrift.transport.TTransportException: java.net.SocketException: Broken pipe (Write failed)
The error may exist in URL
The error may involve defaultParameterMap
The error occurred while setting parameters
Cause: java.sql.SQLException: org.apache.thrift.transport.TTransportException: java.net.SocketException: Broken pipe (Write failed)
; SQL []; org.apache.thrift.transport.TTransportException: java.net.SocketException: Broken pipe (Write failed); nested exception is java.sql.SQLException: org.apache.thrift.transport.TTransportException: java.net.SocketException: Broken pipe (Write failed)
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:105)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
at org.mybatis.spring.SqlSessionTemplate S q l S e s s i o n I n t e r c e p t o r . i n v o k e ( S q l S e s s i o n T e m p l a t e . j a v a : 446 ) a t c o m . s u n . p r o x y . SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446) at com.sun.proxy.SqlS ess i o n I n t erce pt or .in v o k e (SqlS ess i o n T e m pl a t e .ja v a :446 )a t co m .s u n .p ro x y .Proxy100.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:230)
at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:137)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:75)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
at com.sun.proxy.$Proxy107.findCityCensorCategories(Unknown Source)
at sun.reflect.GeneratedMethodAccessor408.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
总体来说是因为对端socket已经关闭，导致broken pipe (断开的管道（非正常关闭socket引发的错误）)
HIVE socket异常导致内核主动关闭连接或者心跳检测异常关闭连接，重启jar服务异常消失。
Original: https://blog.csdn.net/WSSWWWSSW/article/details/126959289
Author: WSSWWWSSW
Title: 【TTransportException: java.net.SocketException: Broken pipe (Write failed))】
原创文章受到原创版权保护。转载请注明出处：https://www.johngo689.com/818045/
转载文章受原作者版权保护。转载请注明原作者出处！