Hi
Where do we set the Database Query tiemeout in JIRA?
Thanks
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.