Hi guys…
Have your guys ever experience the reconnection issue with AWS RDS Postgresql database ?
My camunda app servers (2 servers) are running under ALB load balancer (i used sticky connection).
Both servers are running under same DNS… (for high availability purpose)… and both connecting to same database (AWS RDS , Postgresql)… the problem found when AWS RDS got maintenanced and the RDS got restarted… and after that my camunda got hung … we need to restart the service on both servers to make it run again…
Question : how can we make it auto reconnect without restart service ?
-- error log ---
Mar 3 15:52:15 prod-camunda-1b-0 start-camunda-live.sh: #033[0m#033[31m15:52:15,650 ERROR [org.camunda.bpm.engine.context] (default task-30) ENGINE-16004 Exception while closing command context:
Mar 3 15:52:15 prod-camunda-1b-0 start-camunda-live.sh: ### Error querying database. Cause: org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command
Mar 3 15:52:15 prod-camunda-1b-0 start-camunda-live.sh: ### The error may exist in org/camunda/bpm/engine/impl/mapping/entity/ProcessDefinition.xml
Mar 3 15:52:15 prod-camunda-1b-0 start-camunda-live.sh: ### The error may involve org.camunda.bpm.engine.impl.persistence.entity.ProcessDefinitionEntity.selectProcessDefinitionsByQueryCriteria-Inline
Mar 3 15:52:15 prod-camunda-1b-0 start-camunda-live.sh: ### The error occurred while setting parameters
Mar 3 15:52:15 prod-camunda-1b-0 start-camunda-live.sh: ### SQL: select distinct RES.* from ACT_RE_PROCDEF RES order by RES.ID_ asc LIMIT ? OFFSET ?
Mar 3 15:52:15 prod-camunda-1b-0 start-camunda-live.sh: ### Cause: org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command: org.apache.ibatis.exceptions.PersistenceException:
Mar 3 15:52:15 prod-camunda-1b-0 start-camunda-live.sh: ### Error querying database. Cause: org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command
Mar 3 15:52:15 prod-camunda-1b-0 start-camunda-live.sh: ### The error may exist in org/camunda/bpm/engine/impl/mapping/entity/ProcessDefinition.xml
Mar 3 15:52:15 prod-camunda-1b-0 start-camunda-live.sh: ### The error may involve org.camunda.bpm.engine.impl.persistence.entity.ProcessDefinitionEntity.selectProcessDefinitionsByQueryCriteria-Inline
Mar 3 15:52:15 prod-camunda-1b-0 start-camunda-live.sh: ### The error occurred while setting parameters
Mar 3 15:52:15 prod-camunda-1b-0 start-camunda-live.sh: ### SQL: select distinct RES.* from ACT_RE_PROCDEF RES order by RES.ID_ asc LIMIT ? OFFSET ?
Mar 3 15:52:15 prod-camunda-1b-0 start-camunda-live.sh: ### Cause: org.postgresql.util.PSQLException: FATAL: terminating connection due to administrator command
Mar 3 15:52:15 prod-camunda-1b-0 start-camunda-live.sh: at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
Mar 3 15:52:15 prod-camunda-1b-0 start-camunda-live.sh: at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:150)
Mar 3 15:52:15 prod-camunda-1b-0 start-camunda-live.sh: at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
-----------------