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.
Hi Oleksiy,
You could specify database query timeout that will automatically terminate database queries which took longer than the specified timeout.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.