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

pg 9.6 事务锁问题 #30

Open

jianxink opened this issue Jun 11, 2018 · 0 comments

jianxink commented Jun 11, 2018

德哥你好：
pg9.6 生产环境遇到大量 wait_event_type = Lock wait_event_name = transactionid的锁信息。

一般出现这种锁是因为同一张表执行一个事务后未提交(例：update操作)，此时另一个事务开始执行update操作。此时会出现wait_event_type = Lock wait_event_name = transactionid 这么一条记录。

反复查阅代码后，并未发现有开启事务后未提交的 bad code。
请问下德哥，还有其他原因会导致上述现象吗？

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment