mysql锁与broken pipe_「broken」服务器遇到Broken Pipe崩溃之异常分析报告 - seo实验室...

最新推荐文章于 2023-12-18 15:11:33 发布

XU美伢

最新推荐文章于 2023-12-18 15:11:33 发布

阅读量398

点赞数

文章标签： mysql锁与broken pipe

本文链接：https://blog.csdn.net/weixin_35811662/article/details/113467245

版权

broken

问题描述：linux+jdk1.7+Tomcat7+mysql部署的WEB项目，线上时常抛出该异常(文章底部有解决方案)。

org.apache.catalina.connector.ClientAbortException: java.net.socketException: broken pipeat org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:410)

at org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:480)

at org.apache.tomcat.util.buf.ByteChunk.APPend(ByteChunk.java:366)

at org.apache.catalina.connector.OutputBuffer.writeBytes(OutputBuffer.java:435)

at org.apache.catalina.connector.OutputBuffer.write(OutputBuffer.java:423)

at org.apache.catalina.connector.Coyoteoutputstream.write(CoyoteOutputStream.java:91)

at com.fasterxml.jackson.core.json.UTF8JsonGenerator._flushBuffer(UTF8JsonGenerator.java:2033)

at com.fasterxml.jackson.core.json.UTF8JsonGenerator._writeNull(UTF8JsonGenerator.java:1997)

at com.fasterxml.jackson.core.json.UTF8JsonGenerator.writeNull(UTF8JsonGenerator.java:989)

at com.fasterxml.jackson.databind.ser.std.Nullserializer.serialize(NullSerializer.java:30)

at com.fasterxml.jackson.databind.ser.BeanPropertyWriter.serializeAsfield(BeanPropertyWriter.java:660)

at com.fasterxml.jackson.databind.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:690)

at com.fasterxml.jackson.databind.ser.BeanSerializer.serialize(BeanSerializer.java:155)

at com.fasterxml.jackson.databind.ser.impl.IndexedListSerializer.serializecontents(IndexedListSerializer.java:119)

at com.fasterxml.jackson.databind.ser.impl.IndexedListSerializer.serialize(IndexedListSerializer.java:79)

at com.fasterxml.jackson.databind.ser.impl.IndexedListSerializer.serialize(IndexedListSerializer.java:18)

at com.fasterxml.jackson.databind.ser.BeanPropertyWriter.serializeAsField(BeanPropertyWriter.java:693)

at com.fasterxml.jackson.databind.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:690)

at com.fasterxml.jackson.databind.ser.BeanSerializer.serialize(BeanSerializer.java:155)

at com.fasterxml.jackson.databind.ser.BeanPropertyWriter.serializeAsField(BeanPropertyWriter.java:693)

at com.fasterxml.jackson.databind.ser.std.BeanSerializerBase.serializeFields(BeanSerializerBase.java:690)

at com.fasterxml.jackson.databind.ser.BeanSerializer.serialize(BeanSerializer.java:155)

at com.fasterxml.jackson.databind.ser.DefaultSerializerProvider.serializeValue(DefaultSerializerProvider.java:292)

at com.fasterxml.jackson.databind.ObjectWriter$prefetch.serialize(ObjectWriter.java:1419)

at com.fasterxml.jackson.databind.ObjectWriter.writeValue(ObjectWriter.java:940)

at org.Springframework.HTTP.converter.json.AbstractJackson2HttpmessageConverter.writeInternal(AbstractJackson2HttpMessageConverter.java:286)

at org.springframework.http.converter.AbstractGenericHttpMessageConverter.write(AbstractGenericHttpMessageConverter.java:106)

at org.springframework.web.servlet.mvc.method.annotation.AbstractMessageConverterMethodProcessor.writeWithMessageConverters(AbstractMessageConverterMethodProcessor.java:231)

at org.springframework.web.servlet.mvc.method.annotation.requestresponseBodyMethodProcessor.handlereturnValue(RequestResponseBodyMethodProcessor.java:174)

at org.springframework.web.method.support.HandlerMethodReturnValueHandlerComposite.handleReturnValue(HandlerMethodReturnValueHandlerComposite.java:81)

at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlermethod.invokeAndHandle(ServletInvocableHandlerMethod.java:113)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)

at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)

at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)

at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)

at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.catalina.core.StandardwrapperValve.invoke(StandardWrapperValve.java:218)

at org.apache.catalina.core.StandardcontextValve.invoke(StandardContextValve.java:110)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)

at org.apache.catalina.valves.ERRORReportValve.invoke(ErrorReportValve.java:103)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:745)

Caused by: java.net.SocketException: Broken pipe

at java.net.SocketOutputStream.socketWrite0(Native Method)

at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)

at java.net.SocketOutputStream.write(SocketOutputStream.java:159)

at org.apache.coyote.http11.InternalOutputBuffer.realWriteBytes(InternalOutputBuffer.java:216)

at org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:480)

at org.apache.tomcat.util.buf.ByteChunk.append(ByteChunk.java:366)

at org.apache.coyote.http11.InternalOutputBuffer$OutputStreamOutputBuffer.doWrite(InternalOutputBuffer.java:239)

at org.apache.coyote.http11.filters.IdentityOutputFilter.doWrite(IdentityOutputFilter.java:93)

at org.apache.coyote.http11.AbstractOutputBuffer.doWrite(AbstractOutputBuffer.java:192)

at org.apache.coyote.Response.doWrite(Response.java:499)

at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:405)

... 67 more

问题分析：

1、报文过大：处理的报文过大，导致客户的端无法解析报文。

2、文件过大：处理时间过长，由于执行时间较长或频率较高，程序或服务器出发超时直接结束进程。

3、重复提交：处理时间过长导致当客户端重复发送请求，而上次请求尚未完成，下次请求会close上次请求。

4、数据库配置问题：mysql配置文件忘记配置wait_timeout参数，导致数据库连接顺序关闭(RS、PS、CONN)。

5、另外就是：java虚拟机内存太小或者使用低版本的JVM，出发垃圾回收。

以上，我一个个过了下代码和配置，最终发现是第四点的问题，配置了mysql后就解决了。