又是一天不平凡,总是遇见不简单。
大早上,上游业务又开始一秒一个异常了,啪我就点进去了,很快昂,点开日志查询,首先映入眼帘的就是管道破裂!!!
org.apache.catalina.connector.ClientAbortException: java.io.IOException: Broken pipe
at org.apache.catalina.connector.OutputBuffer.doFlush(OutputBuffer.java:298) ~[tomcat-embed-core-9.0.14.jar!/:9.0.14]
at org.apache.catalina.connector.OutputBuffer.flush(OutputBuffer.java:261) ~[tomcat-embed-core-9.0.14.jar!/:9.0.14]
at org.apache.catalina.connector.CoyoteOutputStream.flush(CoyoteOutputStream.java:118) ~[tomcat-embed-core-9.0.14.jar!/:9.0.14]
at com.fasterxml.jackson.core.json.UTF8JsonGenerator.flush(UTF8JsonGenerator.java:1100) ~[jackson-core-2.9.8.jar!/:2.9.8]
at com.fasterxml.jackson.databind.ObjectWriter.writeValue(ObjectWriter.java:915) ~[jackson-databind-2.9.8.jar!/:2.9.8]
at org.springframework.http.converter.json.AbstractJackson2HttpMessageConverter.writeInternal(AbstractJackson2HttpMessageConverter.java:287) ~[spring-web-5.1.4.RELEASE.jar!/:5.1.4.RELEASE]
at org.springframework.http.converter.AbstractGenericHttpMessageConverter.write(AbstractGenericHttpMessageConverter.java:103) ~[spring-web-5.1.4.RELEASE.jar!/:5.1.4.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.AbstractMessageConverterMethodProcessor.writeWithMessageConverters(AbstractMessageConverterMethodProcessor.java:290) ~[spring-webmvc-5.1.4.RELEASE.jar!/:5.1.4.RELEASE]
看下是什么引起的下面就看到个500,我就点进去了,嗖嗖嗖,哗啦啦,直接滑到最底下首先是报错
Error querying database. Cause: com.alibaba.druid.pool.GetConnectionTimeoutException:
wait millis 60000, active 20, maxActive 20, creating 0, runningSqlCount 1
获取数据库链接都超时了
接下来就是1514行的未格式化的SQL
我就想问问这个SQL如何维护?如何优化?这TM是人写的?
经过执行器格式化都是755行,现在导致数据库链接耗时耗死来了,他们上游又挂了!!!具体优化方案待查