We faced multiple exceptions during work with Flowable engine in spring boot application
- we have some locking queries
SELECT * FROM pg_stat_activity WHERE state != ‘idle’;
we have about 6 queries is not idle and locked
sample locked queries text
- select * from ACT_RU_VARIABLE
where EXECUTION_ID_ = $1
and TASK_ID_ is null
- update ACT_RU_EXECUTION
LOCK_TIME_ = null
where ID_ = $1
We have other POSTGRESS issues happened:
org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLTransientConnectionException: HikariPool-1 - Connection is not available, request timed out after 30000ms.
could not receive data from client: Connection reset by peer
Cause: org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.
please if i need support for all these issues why this happened