[09 14:58:04,090 ERROR] [catalina-exec-15] impl.LangTaiCoreConsumerServiceImpl - 案件【S00000920200000008726】将查勘定损任务调度给指定人员操作失败：

1. 1. 1. Error updating database. Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
      2. The error may involve com.liveneo.dispatch.dao.mapper.SurveyMapper.updateByPrimaryKeySelective-Inline
      3. The error occurred while setting parameters
      4. SQL: update sd_survey SET USERNAME = ?, USER_CODE = ?, PASS_WORD = ?, NAME = ?, IS_VIDEO = ?, LONGITUDE = ?, LATITUDE = ?, SIGN_STATUS = ?, SURVEY_TYPE = ?, TEL = ?, ORG_ID = ?, ADDRESS = ?, ORG_CODE = ?, TASKUPPERLIMIT = ?, CREATE_BY = ?, CREATE_DATE = ?, UPDATE_DATE = ?, UPDATE_BY = ?, IS_ENABLE = ?, SURVEY_ROLL = ?, UPLOAD_TIME = ?, tasknum = ?, AUTH_SURVEY = ?, AUTH_PEOPLE_SURVEY = ?, AUTH_PEOPLE_ESTIMATE = ?, AUTH_VEHICLE_ESTIMATE = ?, AUTH_PROP_ESTIMATE = ?, IS_TRANSPARENT = ?, TASK_ITEM_NUM = ?, ORGCODE_ORIG = ?, branchOffSite = ?, midRange = ?, leaderName = ?, leaderPhone = ? where ID = ?
      5. Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
         ; SQL []; Lock wait timeout exceeded; try restarting transaction; nested exception is java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
         org.springframework.dao.CannotAcquireLockException:
      6. Error updating database. Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
      7. The error may involve com.liveneo.dispatch.dao.mapper.SurveyMapper.updateByPrimaryKeySelective-Inline
      8. The error occurred while setting parameters
      9. SQL: update sd_survey SET USERNAME = ?, USER_CODE = ?, PASS_WORD = ?, NAME = ?, IS_VIDEO = ?, LONGITUDE = ?, LATITUDE = ?, SIGN_STATUS = ?, SURVEY_TYPE = ?, TEL = ?, ORG_ID = ?, ADDRESS = ?, ORG_CODE = ?, TASKUPPERLIMIT = ?, CREATE_BY = ?, CREATE_DATE = ?, UPDATE_DATE = ?, UPDATE_BY = ?, IS_ENABLE = ?, SURVEY_ROLL = ?, UPLOAD_TIME = ?, tasknum = ?, AUTH_SURVEY = ?, AUTH_PEOPLE_SURVEY = ?, AUTH_PEOPLE_ESTIMATE = ?, AUTH_VEHICLE_ESTIMATE = ?, AUTH_PROP_ESTIMATE = ?, IS_TRANSPARENT = ?, TASK_ITEM_NUM = ?, ORGCODE_ORIG = ?, branchOffSite = ?, midRange = ?, leaderName = ?, leaderPhone = ? where ID = ?
      10. Cause: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
          ; SQL []; Lock wait timeout exceeded; try restarting transaction; nested exception is java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
          at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:261)
          at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
          at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
          at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:371)
          at com.sun.proxy.$Proxy16.update(Unknown Source)
          at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:254)
          at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:54)
          at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:52)
          at com.sun.proxy.$Proxy56.updateByPrimaryKeySelective(Unknown Source)
          at com.liveneo.dispatch.dao.impl.SurveyDaoImpl.updateByKeySelective(SurveyDaoImpl.java:334)
          at com.liveneo.dispatch.service.impl.InvokedPInterfaceServiceImpl.saveTaskItemHistory(InvokedPInterfaceServiceImpl.java:1043)
          at com.liveneo.dispatch.service.impl.InvokedPInterfaceServiceImpl.createTaskItem(InvokedPInterfaceServiceImpl.java:802)
          at com.liveneo.dispatch.service.impl.InvokedPInterfaceServiceImpl.saveTaskItem(InvokedPInterfaceServiceImpl.java:668)
          at com.liveneo.dispatch.service.impl.InvokedPInterfaceServiceImpl$$FastClassByCGLIB$$9a55cd0.invoke(<generated>)
          at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
          at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:689)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)