Hello We are using stored procedures and it's executed by auto processe

prasadhk over 11 years ago

Hello
We are using stored procedures and it's executed by auto processes that executes every few minutes. Sometimes the DB node throws the error "com.appiancorp.kougar.driver.exceptions.SafeRetryException: Unable to acquire a Write connection. Safe to retry. ". If we manually reexecute the node, it works just fine. Do anybody come across this issue? Currently the pool size is set to 5000 in our appian ds xml. If we increase the pool size, that would help to resolve this? any thoughts? Is there a way we retry the DB node if this error occurs?...

Discussion posts and replies are publicly visible

Parents

0 Matt Luo
Appian Employee
over 11 years ago

Unfortunately, the pool size for the relational databases does not affect the Appian engines connection timeout time. So, I do not think increasing the pool size will affect the problem at hand.

Can you please expound on “the error is coming out of specific nodes of the process?” Are there some DB nodes that never throw this error, and some DB nodes that are likely to throw this error? If so, is there anything different in the configurations between these two groups of DB nodes?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Matt Luo
Appian Employee
over 11 years ago

Unfortunately, the pool size for the relational databases does not affect the Appian engines connection timeout time. So, I do not think increasing the pool size will affect the problem at hand.

Can you please expound on “the error is coming out of specific nodes of the process?” Are there some DB nodes that never throw this error, and some DB nodes that are likely to throw this error? If so, is there anything different in the configurations between these two groups of DB nodes?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data