socket write error

jy2013

客户反映经常每天开机第一次打开菜单会报错，之后再打开又好了，这是什么情况，以下是报错信息。
2023-01-12 08:47:07 [http-8443-2] [com.justep.business.server.BusinessServer] ERROR: excute stream action, params:{"accept":"application/json","action":"queryJY_SettlementAction","actionFlag":"__action_0__","activity":"querySettlement_YS","contentType":"json","executeContext":"","executor":"","parameters":{"columns":"JY_Settlement,fBHSJ,fCash,fCashAmt,fDJLX,fDate,fFKRQ,fFYLB,fGYS,fGYSID,fHSJ,fHSZE,fIsSH,fJF,fJFCode,fJHKKBID,fJL,fJSMonth,fKBX,fKCYFK,fKCYFYK,fKCYYYK,fKDK,fKKJE,fKSP,fKYSBZJ,fNo,fOilCard,fOilCardAmt,fOilCardYJ,fOther,fSAIC_No,fSFJE,fSHF,fSKR,fSQSY,fStatus,fStatusName,fTHF,fTotalCost,fYHKHH,fYHZH,version","filter":"(JY_Settlement.fDJLX='运输')","limit":20,"offset":0,"variables":{}},"process":"/JYJS/Settlement/process/Settlement_YS/settlement_YSProcess","translateParameter":{"cellnameByRelation":false,"dataType":"row-list","includeState":true,"rowsConfig":{"concept":"JY_Settlement","sequence":"JY_Settlement,fBHSJ,fCash,fCashAmt,fDJLX,fDate,fFKRQ,fFYLB,fGYS,fGYSID,fHSJ,fHSZE,fIsSH,fJF,fJFCode,fJHKKBID,fJL,fJSMonth,fKBX,fKCYFK,fKCYFYK,fKCYYYK,fKDK,fKKJE,fKSP,fKYSBZJ,fNo,fOilCard,fOilCardAmt,fOilCardYJ,fOther,fSAIC_No,fSFJE,fSHF,fSKR,fSQSY,fStatus,fStatusName,fTHF,fTotalCost,fYHKHH,fYHZH,version"},"transformIdcolumn":true,"useNamespace":true}}
java.lang.reflect.InvocationTargetException
        at sun.reflect.GeneratedMethodAccessor176.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at com.justep.system.action.Engine.invokeActions(Native Method)
        at com.justep.system.action.Engine.invokeActions(Unknown Source)
        at com.justep.business.server.BusinessServer.doAction(Unknown Source)
        at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServer.excute(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
        at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.justep.micro.service.MicroServiceFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT JY_Settlement.*  FROM JY_Settlement JY_Settlement WHERE ((JY_Settlement.fDJLX='运输')) LIMIT 0, 20
--> sql: SELECT  JY_Settlement.fID AS JY_Settlement, JY_Settlement.FBHSJ AS fBHSJ, JY_Settlement.FCASH AS fCash, JY_Settlement.FCASHAMT AS fCashAmt, JY_Settlement.FDJLX AS fDJLX, JY_Settlement.FDATE AS fDate, JY_Settlement.FFKRQ AS fFKRQ, JY_Settlement.FFYLB AS fFYLB, JY_Settlement.FGYS AS fGYS, JY_Settlement.FGYSID AS fGYSID, JY_Settlement.FHSJ AS fHSJ, JY_Settlement.FHSZE AS fHSZE, JY_Settlement.FISSH AS fIsSH, JY_Settlement.FJF AS fJF, JY_Settlement.FJFCODE AS fJFCode, JY_Settlement.FJHKKBID AS fJHKKBID, JY_Settlement.FJL AS fJL, JY_Settlement.FJSMONTH AS fJSMonth, JY_Settlement.FKBX AS fKBX, JY_Settlement.FKCYFK AS fKCYFK, JY_Settlement.FKCYFYK AS fKCYFYK, JY_Settlement.FKCYYYK AS fKCYYYK, JY_Settlement.FKDK AS fKDK, JY_Settlement.FKKJE AS fKKJE, JY_Settlement.FKSP AS fKSP, JY_Settlement.FKYSBZJ AS fKYSBZJ, JY_Settlement.FNO AS fNo, JY_Settlement.FOILCARD AS fOilCard, JY_Settlement.FOILCARDAMT AS fOilCardAmt, JY_Settlement.FOILCARDYJ AS fOilCardYJ, JY_Settlement.FOTHER AS fOther, JY_Settlement.FSAIC_NO AS fSAIC_No, JY_Settlement.FSFJE AS fSFJE, JY_Settlement.FSHF AS fSHF, JY_Settlement.FSKR AS fSKR, JY_Settlement.FSQSY AS fSQSY, JY_Settlement.FSTATUS AS fStatus, JY_Settlement.FSTATUSNAME AS fStatusName, JY_Settlement.FTHF AS fTHF, JY_Settlement.FTOTALCOST AS fTotalCost, JY_Settlement.FYHKHH AS fYHKHH, JY_Settlement.FYHZH AS fYHZH, JY_Settlement.VERSION AS version FROM JY_SETTLEMENT JY_Settlement  WHERE JY_Settlement.FDJLX = ?
--> binds: [运输]
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.BizData.query(Unknown Source)
        at BizProcedure.query(BizProcedure.java:12)
        ... 29 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: SELECT  JY_Settlement.fID AS JY_Settlement, JY_Settlement.FBHSJ AS fBHSJ, JY_Settlement.FCASH AS fCash, JY_Settlement.FCASHAMT AS fCashAmt, JY_Settlement.FDJLX AS fDJLX, JY_Settlement.FDATE AS fDate, JY_Settlement.FFKRQ AS fFKRQ, JY_Settlement.FFYLB AS fFYLB, JY_Settlement.FGYS AS fGYS, JY_Settlement.FGYSID AS fGYSID, JY_Settlement.FHSJ AS fHSJ, JY_Settlement.FHSZE AS fHSZE, JY_Settlement.FISSH AS fIsSH, JY_Settlement.FJF AS fJF, JY_Settlement.FJFCODE AS fJFCode, JY_Settlement.FJHKKBID AS fJHKKBID, JY_Settlement.FJL AS fJL, JY_Settlement.FJSMONTH AS fJSMonth, JY_Settlement.FKBX AS fKBX, JY_Settlement.FKCYFK AS fKCYFK, JY_Settlement.FKCYFYK AS fKCYFYK, JY_Settlement.FKCYYYK AS fKCYYYK, JY_Settlement.FKDK AS fKDK, JY_Settlement.FKKJE AS fKKJE, JY_Settlement.FKSP AS fKSP, JY_Settlement.FKYSBZJ AS fKYSBZJ, JY_Settlement.FNO AS fNo, JY_Settlement.FOILCARD AS fOilCard, JY_Settlement.FOILCARDAMT AS fOilCardAmt, JY_Settlement.FOILCARDYJ AS fOilCardYJ, JY_Settlement.FOTHER AS fOther, JY_Settlement.FSAIC_NO AS fSAIC_No, JY_Settlement.FSFJE AS fSFJE, JY_Settlement.FSHF AS fSHF, JY_Settlement.FSKR AS fSKR, JY_Settlement.FSQSY AS fSQSY, JY_Settlement.FSTATUS AS fStatus, JY_Settlement.FSTATUSNAME AS fStatusName, JY_Settlement.FTHF AS fTHF, JY_Settlement.FTOTALCOST AS fTotalCost, JY_Settlement.FYHKHH AS fYHKHH, JY_Settlement.FYHZH AS fYHZH, JY_Settlement.VERSION AS version FROM JY_SETTLEMENT JY_Settlement  WHERE JY_Settlement.FDJLX = ?, binds: [运输]出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
        ... 34 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 69,488,964 milliseconds ago.  The last packet sent successfully to the server was 69,488,964 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
        at sun.reflect.GeneratedConstructorAccessor97.newInstance(Unknown Source)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:400)
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1038)
        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3621)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2429)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2594)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1901)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2002)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        ... 35 more
Caused by: java.net.SocketException: Software caused connection abort: socket write error
        at java.net.SocketOutputStream.socketWrite0(Native Method)
        at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:109)
        at java.net.SocketOutputStream.write(SocketOutputStream.java:153)
        at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
        at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
        at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3603)
        ... 42 more

jishuang

http://docs.wex5.com/bex5-deploy-question-list-4011/