NutzCN Logo
问答 update时被锁库了
发布于 1770天前 作者 qq_5245a4a9 1204 次浏览 复制 上一个帖子 下一个帖子
标签:

2019-05-24 17:37:53 DEBUG NutDaoExecutor:388 - UPDATE jc_salary_wageschemetemp SET idNumber=?,userActualName=?,userName=?,field_170=?,field_171=?,field_1=?,field_3=?,field_4=?,field_5=?,field_6=?,field_7=?,field_8=?,field_30=?,field_31=?,field_17=?,field_18=?,field_19=?,field_20=?,field_22=?,field_23=?,field_38=?,field_39=?,field_40=?,field_43=?,field_204=?,field_205=?,field_54=?,field_55=?,field_56=?,field_57=?,field_186=?,field_197=?,field_200=?,field_9=?,field_10=?,field_11=?,field_12=?,field_13=?,field_14=?,field_21=?,field_24=?,field_25=?,field_26=?,field_27=?,field_28=?,field_29=?,field_33=?,field_34=?,field_35=?,field_36=?,field_58=?,field_59=?,field_60=?,field_61=?,field_187=?,field_214=?,field_15=?,field_16=?,field_32=?,field_189=?,field_191=?,field_193=?,field_194=?,field_195=?,field_196=? WHERE audit_id=?
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 |
|--------------------|-----|----------|--------|--------|--|--------|--------|--------|-------|-----|-----|-----|-----|----|-------|----|-------|----|------|---|--|--------|--------|--------|--------|--|--------|-------|-----|-----|-----|------|-----|-----|-----|-----|--|-----|------|------|------|------|------|------|-------|------|------|------|------|-----|------|--------|------|------|--------|------|------|------|----|----|--|------|--|------|----|
| 513822199310258249 | 白芝兰 | 01632324 | 201750 | 劳动合同人员 | | 合同初期工资 | 1250.0 | 技术薪级5级 | 311.0 | 0.0 | 0.0 | 1.0 | 2.0 | 正高 | 130.0 | 正高 | 110.0 | 在岗 | 56.0 | 4 | | 6000.0 | 7000.0 | 1000.0 | 2000.0 | | 5000.0 | 250.0 | 3.0 | 4.0 | 5.0 | 10.0 | 6.0 | 7.0 | 8.0 | 9.0 | | 0.0 | 10.0 | 11.0 | 12.0 | 13.0 | 14.0 | 15.0 | 150.0 | 16.0 | 17.0 | 18.0 | 19.0 | 0.0 | 6.25 | 1250.0 | 25.0 | 20.0 | 583.33 | 21.0 | 22.0 | 23.0 | 本科 | 学士 | | NULL | | NULL | 16 |
For example:> "UPDATE jc_salary_wageschemetemp SET idNumber='513822199310258249',userActualName='白芝兰',userName='01632324',field_170='201750',field_171='劳动合同人员',field_1='',field_3='合同初期工资',field_4=1250.0,field_5='技术薪级5级',field_6=311.0,field_7=0.0,field_8=0.0,field_30=1.0,field_31=2.0,field_17='正高',field_18=130.0,field_19='正高',field_20=110.0,field_22='在岗',field_23=56.0,field_38=4,field_39='',field_40=6000.0,field_43=7000.0,field_204=1000.0,field_205=2000.0,field_54='',field_55=5000.0,field_56=250.0,field_57=3.0,field_186=4.0,field_197=5.0,field_200=10.0,field_9=6.0,field_10=7.0,field_11=8.0,field_12=9.0,field_13='',field_14=0.0,field_21=10.0,field_24=11.0,field_25=12.0,field_26=13.0,field_27=14.0,field_28=15.0,field_29=150.0,field_33=16.0,field_34=17.0,field_35=18.0,field_36=19.0,field_58=0.0,field_59=6.25,field_60=1250.0,field_61=25.0,field_187=20.0,field_214=583.33,field_15=21.0,field_16=22.0,field_32=23.0,field_189='本科',field_191='学士',field_193='',field_194=NULL,field_195='',field_196=NULL WHERE audit_id=16"
2019-05-24 17:38:03 DEBUG QuartzSchedulerThread:291 - batch acquisition of 0 triggers
2019-05-24 17:38:30 DEBUG QuartzSchedulerThread:291 - batch acquisition of 0 triggers
2019-05-24 17:38:36 DEBUG SimpleCookie:366 - Found 'JSESSIONID' cookie value [r9ac3bchl4gciohnrqm34u3ron]
2019-05-24 17:38:36 DEBUG UrlMappingImpl:101 - Found mapping for [POST] path=/common/heart : CommonHert.heart(CommonHert.java:33)
2019-05-24 17:38:36 DEBUG AuthorizingRealm:234 - No authorizationCache instance set. Checking for a cacheManager...
2019-05-24 17:38:36 INFO AuthorizingRealm:248 - No cache or cacheManager properties have been set. Authorization cache cannot be obtained.
2019-05-24 17:38:36 DEBUG NutDaoExecutor:388 - SELECT * FROM SysUpdateInfo WHERE code=? LIMIT 0, 1
| 1 |
|----------------------------------|
| f74bc6e0f52d44c3a5755dc47a79464b |
For example:> "SELECT * FROM SysUpdateInfo WHERE code='f74bc6e0f52d44c3a5755dc47a79464b' LIMIT 0, 1 "
2019-05-24 17:38:39 DEBUG SimpleCookie:366 - Found 'JSESSIONID' cookie value [r9ac3bchl4gciohnrqm34u3ron]
2019-05-24 17:38:39 DEBUG UrlMappingImpl:101 - Found mapping for [POST] path=/common/heart : CommonHert.heart(CommonHert.java:33)
2019-05-24 17:38:39 DEBUG AuthorizingRealm:234 - No authorizationCache instance set. Checking for a cacheManager...
2019-05-24 17:38:39 INFO AuthorizingRealm:248 - No cache or cacheManager properties have been set. Authorization cache cannot be obtained.
2019-05-24 17:38:39 DEBUG NutDaoExecutor:388 - SELECT * FROM SysUpdateInfo WHERE code=? LIMIT 0, 1
| 1 |
|----------------------------------|
| f74bc6e0f52d44c3a5755dc47a79464b |
For example:> "SELECT * FROM SysUpdateInfo WHERE code='f74bc6e0f52d44c3a5755dc47a79464b' LIMIT 0, 1 "
2019-05-24 17:38:44 DEBUG NutDaoExecutor:97 - SQLException
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.execute(PreparedStatement.java:1193)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3051)
at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:440)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3049)
at com.alibaba.druid.wall.WallFilter.preparedStatement_execute(WallFilter.java:601)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3049)
at com.alibaba.druid.filter.FilterAdapter.preparedStatement_execute(FilterAdapter.java:1080)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3049)
at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:168)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:494)
at org.nutz.dao.impl.sql.run.NutDaoExecutor._runPreparedStatement(NutDaoExecutor.java:308)
at org.nutz.dao.impl.sql.run.NutDaoExecutor.exec(NutDaoExecutor.java:90)
at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:66)
at org.nutz.dao.impl.interceptor.DaoLogInterceptor.filter(DaoLogInterceptor.java:22)
at org.nutz.dao.DaoInterceptorChain.doChain(DaoInterceptorChain.java:64)
at org.nutz.dao.DaoInterceptorChain.invoke(DaoInterceptorChain.java:139)
at org.nutz.dao.impl.sql.run.NutDaoRunner.runCallback(NutDaoRunner.java:159)
at org.nutz.dao.impl.sql.run.NutDaoRunner._runWithTransaction(NutDaoRunner.java:105)
at org.nutz.dao.impl.sql.run.NutDaoRunner._run(NutDaoRunner.java:89)
at org.nutz.dao.impl.sql.run.NutDaoRunner$1.run(NutDaoRunner.java:75)
at org.nutz.trans.Trans.exec(Trans.java:174)
at org.nutz.dao.impl.sql.run.NutDaoRunner.run(NutDaoRunner.java:73)
at org.nutz.dao.impl.DaoSupport.run(DaoSupport.java:240)
at org.nutz.dao.impl.DaoSupport._exec(DaoSupport.java:252)
at org.nutz.dao.impl.EntityOperator.exec(EntityOperator.java:56)
at org.nutz.dao.impl.NutDao.update(NutDao.java:343)
at com.yh.app.webser.module.manage.personsalaryquery.SalaryChangeMudole$2.run(SalaryChangeMudole.java:8576)
at org.nutz.trans.Trans.exec(Trans.java:174)
at com.yh.app.webser.module.manage.personsalaryquery.SalaryChangeMudole.saveExcelData(SalaryChangeMudole.java:8573)
at com.yh.app.webser.module.manage.personsalaryquery.SalaryChangeMudole.exportData(SalaryChangeMudole.java:8564)
at com.yh.app.webser.module.manage.personsalaryquery.SalaryChangeMudole.importData(SalaryChangeMudole.java:8402)
at com.yh.app.webser.module.manage.personsalaryquery.SalaryChangeMudole$FM$importData$50167eb73dc90a741bf875d1fd06ea65.invoke(SalaryChangeMudole.java)
at org.nutz.mvc.impl.processor.MethodInvokeProcessor.process(MethodInvokeProcessor.java:31)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.plugins.validation.ValidationProcessor.process(ValidationProcessor.java:56)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at com.yh.app.webser.common.mvc.UsbKeyCheckProcessor.process(UsbKeyCheckProcessor.java:35)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at com.yh.app.webser.common.mvc.FristLoginProcessor.process(FristLoginProcessor.java:57)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.AdaptorProcessor.process(AdaptorProcessor.java:38)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.integration.shiro.NutShiroProcessor.process(NutShiroProcessor.java:60)
at org.nutz.mvc.impl.processor.ActionFiltersProcessor.process(ActionFiltersProcessor.java:62)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.integration.shiro.NutShiroProcessor.process(NutShiroProcessor.java:60)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.ModuleProcessor.process(ModuleProcessor.java:123)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.EncodingProcessor.process(EncodingProcessor.java:27)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at org.nutz.mvc.impl.processor.UpdateRequestAttributesProcessor.process(UpdateRequestAttributesProcessor.java:15)
at org.nutz.mvc.impl.processor.AbstractProcessor.doNext(AbstractProcessor.java:44)
at com.yh.app.webser.common.mvc.ActionExecuteTimeProcessor.process(ActionExecuteTimeProcessor.java:31)
at org.nutz.mvc.impl.NutActionChain.doChain(NutActionChain.java:44)
at org.nutz.mvc.impl.ActionInvoker.invoke(ActionInvoker.java:67)
at org.nutz.mvc.ActionHandler.handle(ActionHandler.java:31)
at org.nutz.mvc.NutFilter.doFilter(NutFilter.java:202)
at com.yh.app.webser.common.mvc.YHwebFilter.doFilter(YHwebFilter.java:41)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)
at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365)
at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)
at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)
at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383)
at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:217)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:673)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2503)
at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2492)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)

数据库是mysql,MariaDB5.5.5

4 回复

private boolean saveExcelData(Map<String, Object> valueMap, SalaryAudit audit) {
final Object[] objArr = new Object[3];
Trans.exec(Connection.TRANSACTION_SERIALIZABLE,new Atom() {
public void run() {
saveRelationData(valueMap, audit.getUserId(), audit.getType());
objArr[0] = dao.update(SalaryConfigurationMudole.WAGE_SCHEME_TABLE_TEMP, Chain.from(valueMap), Cnd.where("audit_id", "=", audit.getId()));
audit.setDispose(true);
audit.setFlowLine(1);
audit.setStatus(SalaryAudit.COMMIT);
audit.setSubmitDate(DateUtil.getInetDate());
objArr[1] = dao.update(audit);
ChangeAuditInfo info = new ChangeAuditInfo(audit.getId(), getSessionUser().getUserid(), audit.getUserId(), "", "工资管理员", true);
objArr[2] = dao.insert(info);
}
});
for (Object obj : objArr) {
if (obj == null) {
return false;
}
}
return true;
}
执行的代码

是先查后update了吧

这个方法的外面有一些sql的查询,进到这个方法里面执行第一个update的时候被锁住了

去mysql查查锁了什么记录吧

添加回复
请先登陆
回到顶部