Is it safe to terminate stuck DB transactions of Confluence?

Oleksiy Brushkovskyy December 29, 2013

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.

1 answer

1 accepted

0 votes
Answer accepted
jing_hwa_cheok
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
December 31, 2013

Hi Oleksiy,

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events