bug记录事务死锁

迷南。 2022-11-03 04:26 156阅读 0赞

@Override

**@Transactional(rollbackFor = Exception.class)**  
    public void returnOrder(ReturnOrderDTO returnOrderDTO) throws IOException \{

DsUser dsUser = dsUserService.getLoginUser();

DhOrder oldOrder = this.getById(returnOrderDTO.getId());  
        oldOrder.setStatus(returnOrderDTO.getStatus());  
        oldOrder.setRemark(returnOrderDTO.getRemark());  
        this.saveOrUpdate(oldOrder);

DhDelivery delivery = dhDeliveryService.lambdaQuery().eq(DhDelivery::getOrderId, returnOrderDTO.getId()).one();

DsOrderLog dsOrderLog = new DsOrderLog();  
        dsOrderLog.setDhOrderId(returnOrderDTO.getId());  
        dsOrderLog.setProccessTime(new Date());  
        dsOrderLog.setProccessType(0);  
        dsOrderLog.setProcessBy(dsUser.getId());  
        dsOrderLogService.save(dsOrderLog);

DhSupplier supplier = dhSupplierService.lambdaQuery().eq(DhSupplier::getId, oldOrder.getSupplierId()).one();

smsExecutor.execute(() -> \{  
            String msg = MessageFormat.format("【良医汇】您好，您向\{0\}申请的\{1\}，因\{2\}，已被退单，订单\{3\}我们将全额退款，感谢您的理解。",  
                    supplier.getSupplierName(), "处方药品", returnOrderDTO.getRemark(),  oldOrder.getOrderNo() );  
            notifySmsSender.send(NotifyConfig.SIGN, msg, dsUser.getMobile());  
        \});

//通知小程序端

CancelBO cancelBO = new CancelBO();  
        cancelBO.setId(returnOrderDTO.getId());  
        cancelBO.setReason(returnOrderDTO.getRemark());  
        cancelBO.setType(1);

JSONObject jsonObject = restTemplate.postForObject(wechatUrl + "/lyhcc/dhOrder/cancelOrder", cancelBO, JSONObject.class);    **//实际这个接口也是update  order的**

所以呢，这个事务提交没有结束，api的接口也是更新这个表，所以出现了死锁，除非结束事务才能调用api接口，就此记录一下