问题详情

    • 类型: 缺陷 缺陷
    • 状态: 关闭 (查看工作流)
    • 优先级: 重要 重要
    • 解决结果: 解决
    • 影响版本: SIT
    • 解决版本: SIT
    • 模块: 调度后台
    • 标签:
    • 项目环境:
      PRD

      描述

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

          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)

        活动

        李小龙 创建问题 -
        李小龙 进行了改变 -
        字段 原值 新值
        issue.field.resolutiondate 2021-05-27 14:51:53.0 2021-05-27 14:51:52.859
        预估剩余时间 0 minutes [ 0 ]
        已耗费时间 6 seconds [ 6 ]
        工作日志 Id 12152 [ 12152 ]
        李小龙 进行了改变 -
        状态 Open [ 1 ] Closed [ 6 ]
        解决结果 Fixed [ 1 ]

          用户

          • 经办人:
            李小龙
            报告人:
            李小龙
          • 投票:
            0 为这个问题投票
            关注人:
            1 关注这个问题

            日期

            • 创建:
              更新:
              解决:

              时间追踪

              预估时间:
              原预估时间 - 尚未登记
              尚未登记
              剩余时间:
              剩余时间 - 0 分
              0m
              实际工作时间:
              耗费时间 - 6 秒