Subject | Kill a transaction |
---|---|
Author | W O |
Post date | 2013-01-07T05:13:05Z |
Hello everybody
Sometimes a transaction updates a row and hangs up before commit, avoiding
another transactions update that row. So the questions are:
1. How to know if a transaction is lasting too much? (by example: more than
a minute)
2. How to kill the offending transaction?
Thank you in advance.
Greetings.
Walter.
[Non-text portions of this message have been removed]
Sometimes a transaction updates a row and hangs up before commit, avoiding
another transactions update that row. So the questions are:
1. How to know if a transaction is lasting too much? (by example: more than
a minute)
2. How to kill the offending transaction?
Thank you in advance.
Greetings.
Walter.
[Non-text portions of this message have been removed]