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

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?...

OriginalPostID-72757

OriginalPostID-72757

  Discussion posts and replies are publicly visible

Parents
  • Hello Prasadh,
    You are welcome to create a support case, in which an engineer can analyze your db_*.log files for transactions at these busy 30-minute intervals. Given what you have described, support can confirm that the automated process is causing the engines to be busy, thus the "Unable to acquire a Write connection" error. To my knowledge, it is outside the custom properties settings to lengthen the write connections time. It may be useful to consult professional services on how to design for an automated process that runs on a regular interval.
Reply
  • Hello Prasadh,
    You are welcome to create a support case, in which an engineer can analyze your db_*.log files for transactions at these busy 30-minute intervals. Given what you have described, support can confirm that the automated process is causing the engines to be busy, thus the "Unable to acquire a Write connection" error. To my knowledge, it is outside the custom properties settings to lengthen the write connections time. It may be useful to consult professional services on how to design for an automated process that runs on a regular interval.
Children
No Data