Currently, a lot of reports are getting errors saying the timeout is not enough.
These are our current settings:
queryTimeout = 180
maxQueryThreads = 20
This is the error message in the system events we get :
“root_cause_message”: “OutOfMemory used=3831832984, max=4194304000 for connection: Jdbc=jdbc:postgresql://atl-prd-jiradb.cruktnvc46lz.us-west-2.rds.amazonaws.com/eazybi_jira?tcpKeepAlive=true; JdbcDrivers=org.postgresql.Driver; UseContentChecksum=true; *** XML schema dump removed ***”,
My question is what is the maxium value we can put here for timeout without imapcting perforamce in both eazybi and Jira?
It was mention in this thread here to not remove timeout, but I would like to ask what is the timeout recommend to solve timeout errors when running complex reports