Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
9 replies
Subscribers
8 subscribers
Views
3761 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
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?...
OriginalPostID-72757
OriginalPostID-72757
Discussion posts and replies are publicly visible
Parents
0
Matt Luo
Appian Employee
over 11 years ago
Hello Prasadh,
I am continuing to research this topic.
In the meantime, allow me to explain that the error in your post, "com.appiancorp.kougar.driver.exceptions.SafeRetryException: Unable to acquire a Write connection. Safe to retry." refers to a write connection failure to the Appian engine k database files, as opposed to the relational database configured by appian-ds.xml. So, I think we will need to look beyond increasing the pool size in appian-ds.xml as a solution for this particular error message.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Matt Luo
Appian Employee
over 11 years ago
Hello Prasadh,
I am continuing to research this topic.
In the meantime, allow me to explain that the error in your post, "com.appiancorp.kougar.driver.exceptions.SafeRetryException: Unable to acquire a Write connection. Safe to retry." refers to a write connection failure to the Appian engine k database files, as opposed to the relational database configured by appian-ds.xml. So, I think we will need to look beyond increasing the pool size in appian-ds.xml as a solution for this particular error message.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data