Is it safe to terminate stuck DB transactions of Confluence?

[Oleksiy Brushkovskyy]

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.

[jing_hwa_cheok · Accepted solution]

Hi Oleksiy,

You could specify database query timeout that will automatically terminate database queries which took longer than the specified timeout.