What is the best way to deal with too long database transactions in Confluence?
Periodically we have situations when some page/attachment updates fail and DB locks stay for an hours held by additional background threads. Is 15 minutes enough for average Confluence query to its own DB? Is it good practice to terminate longer transactions forcibly?
This way we release DB locks and close waste threads that sometimes overconsume CPU resources.
