1514行SQL，你TM给我维护一下

疯狂的KK

发布于 2021-11-02 16:12:28

3830

发布于 2021-11-02 16:12:28

又是一天不平凡，总是遇见不简单。

大早上，上游业务又开始一秒一个异常了，啪我就点进去了，很快昂，点开日志查询，首先映入眼帘的就是管道破裂！！！

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