系统性能优化问题

engle_wang

Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
        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.executeUpdate(PreparedStatement.java:2113)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2049)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2034)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        ... 47 more

如下图，由于资源和网络等问题，导致连接超时或者资源未释放，如果不重启服务，这个就一直不能用，能否从系统性能等方面优化系统，减少数据库访问，长连接等。

jishuang

平台的API连接的数据库都会关闭，减少数据库访问是自己项目控制的

可以到网上查找数据库是否有设置

engle_wang

jishuang 发表于 2017-2-28 14:19
平台的API连接的数据库都会关闭，减少数据库访问是自己项目控制的

可以到网上查找数据库是否有设置 ...

Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: update SA_ProcessControl c set c.sContent='<process-control><notice/><to><process-control-item><process>/comtomoa/leave/process/leave/leaveProcess</process><template></template><unit>businessActivity1</unit><executors><org-unit><fid>/5jlqT6dPDVWurXtd1vO.ogn/6I1G11ekcYifMpLP4H1.dpt/veCCnfz1Uspx3dfEgjv.dpt/ioXG6faJA7UfCqcN6hS.pos/HSx1qZF6GiZwpqpXHSZ@ioXG6faJA7UfCqcN6hS.psm</fid><fname>/支撑平台/技术中心/专家组/嵌入式专家/郭小平</fname><responsible>false</responsible></org-unit></executors></process-control-item></to></process-control>' where c.sProcess='/comtomoa/leave/process/leave/leaveProcess' and c.sActivity='businessActivity0' and c.sAction='advanceProcessAction' and c.sOperatorID='0KZPHf2dqZ2A7Qjef1Q'  and (c.sProcessTemplateID2 IS NULL or c.sProcessTemplateID2 = '')
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlUpdate(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unknown Source)
        at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
        at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
        at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
        at com.justep.system.process.ProcessControl.doSave(Unknown Source)
        at com.justep.system.process.ProcessControl.save(Unknown Source)
        at com.justep.system.process.ProcessControl.save(Unknown Source)
        at ProcessProcedure.saveProcessControl(ProcessProcedure.java:369)
        at ProcessProcedure.advanceProcess(ProcessProcedure.java:352)
        ... 36 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: UPDATE SA_ProcessControl SET SA_ProcessControl.SCONTENT = ?  WHERE  (SA_ProcessControl.SPROCESS = ?) AND (SA_ProcessControl.SACTIVITY = ?) AND (SA_ProcessControl.SACTION = ?) AND (SA_ProcessControl.SOPERATORID = ?) AND ( (SA_ProcessControl.SPROCESSTEMPLATEID2 IS NULL) OR (SA_ProcessControl.SPROCESSTEMPLATEID2 = ?) ) , binds: [<process-control><notice/><to><process-control-item><process>/comtomoa/leave/process/leave/leaveProcess</process><template></template><unit>businessActivity1</unit><executors><org-unit><fid>/5jlqT6dPDVWurXtd1vO.ogn/6I1G11ekcYifMpLP4H1.dpt/veCCnfz1Uspx3dfEgjv.dpt/ioXG6faJA7UfCqcN6hS.pos/HSx1qZF6GiZwpqpXHSZ@ioXG6faJA7UfCqcN6hS.psm</fid><fname>/支撑平台/技术中心/专家组/嵌入式专家/郭小平</fname><responsible>false</responsible></org-unit></executors></process-control-item></to></process-control>, /comtomoa/leave/process/leave/leaveProcess, businessActivity0, advanceProcessAction, 0KZPHf2dqZ2A7Qjef1Q, ]出错
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
        ... 46 more
Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:998)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3847)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3783)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2447)
        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.executeUpdate(PreparedStatement.java:2113)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2049)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2034)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
        ... 47 more

看你的具体错误信息，是由于平台内部的执行更新操作，引起的报错。。。

jishuang

流程流转的时候所有的操作都在一个事务中，而且必须要去数据库操作，不能控制不操作数据