嵌套事务报Lock wait timeout exceeded; try restarting transaction

Question

请问事务Propagation.REQUIRED里面嵌套一个Propagation.REQUIRES_NEW,Propagation.REQUIRED是不是会被挂起,我现在是外面和嵌套都有修改同一个表,同一条数据.导致报java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction,请问大神们这个怎么破

    @Transactional(propagation = Propagation.REQUIRED, rollbackFor = Exception.class)
    public void test1()
    {
        Boolean flag = updateOrder();
        if (flag)
        {
            test2();
        }
    }

    // 这个是在另外一个类
    @Transactional(propagation = Propagation.REQUIRES_NEW, rollbackFor = Exception.class)
    public void test2()
    {
        updateOrder();
    }

Answer 1

谢邀。

典型死锁。