CA Workload Automation DSeries is experiencing intermittent connection problems with our database. The trace log shows the following:
20221112 13:18:43.653 [relationaldatabase] [ERROR] DM: [2022-11-12_13:18:43.653] Exception: IO Error: Got minus one from a read call
java.sql.SQLRecoverableException: IO Error: Got minus one from a read call
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:854) ~[ojdbc8.jar:22.214.171.124.0]
Release : 12.3
The "Got minus one from a read call" message points to the problem being related to max-sessions/session settings on the app and database servers.
Restarting the application and database servers may resolve this problem. However, it is recommended to review the suggestions below to ensure this does not occur at a later point in time.
From the application server perspective, these are the relevant configuration settings:
You can find the current value of these settings in the beginning lines of the tracelog. If you need to adjust either of these settings you can do so using:
Please review the Idle Connections section in Database Requirements page. It offers a database.connection.idle.flush.threshold recommendation/consideration.
From a database perspective, please work with your DBA to determine max-session settings, current session connections, interruptions, errors and whether or not there are any other influencing factors like (such as Process limits, operating system configuration/limits, etc..).