Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

confirm报异常出现数据库锁表 #4

Open
liudaohonglk opened this issue Dec 6, 2018 · 2 comments
Open

confirm报异常出现数据库锁表 #4

liudaohonglk opened this issue Dec 6, 2018 · 2 comments

Comments

@liudaohonglk
Copy link

我在confirm操作的时候执行了一个update操作，然后手动抛出一个异常，让confirm里的事务进行回滚，但是此时数据库回滚操作一直处于running状态，然后confirm会定时的调用，但是由于我手动抛的异常一直无法成功，数据库就会出现一条等待的数据，然后running那条数据一直通过不了，锁住的请求一直超时，导致这张表就被锁了，只有将程序关停，等之前那条running状态的数据通过后，才能正常操作，这种情况正常吗
@liudaohonglk
Copy link
Author

@lijiawei199
Copy link

能否把详细代码贴一下

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@liudaohonglk @lijiawei199