Database query Timeout in JIRA

Devu Heda
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 3, 2012

Hi

Where do we set the Database Query tiemeout in JIRA?

Thanks

2 answers

1 accepted

0 votes
Answer accepted
Devu Heda
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 12, 2012

Thanks Radu, as suggested by u we did not set any timeouts. Our issue was with the http threads we found out using the java melody plugin and we were finally able to solve it

https://answers.atlassian.com/questions/49675/jira-freezes-with-db-deadlock

Thanks again

2 votes
Radu Dumitriu
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 3, 2012

Why would you do that ?

You can set query time-outs on DB via properties set on your driver environment or at the database level (max cpu for a query on Oracle) Check your database settings (these are specific) and check your driver release notes.

Anyway, I advice you not to set any query timeout.

For instance, setting this validation query for your pool will do it on postgres (fails after 1 sec):

SET statement_timeout TO 1000

Suggest an answer

Log in or Sign up to answer