Tomcat setting testonborrow
We are currently running 7.2.1 on Tomcat7 and Java8. When our oracle RAC environment has maintenance we are seeing issues/errors in our logs (see below). A suggestion has been made that the Tomcat configuration "testOnBorrow" would help in this situation. I do not see any reference to this in the 7.2.1 Tomcat/Oracle installation guide. However, it is mentioned in the 7.4 installation guide as something that needs to be in place when using Tomcat7.
Is it Pega's recommendation to use this setting in all versions of Pega on Tomcat7?
Accepted Solution
Pegasystems Inc.
IN
Hi Mark,
testOnBorrow ensures that before the connection is provided to appliation from the connection pool, a basic sanity test is made to ensure that the connection is not stale.
Although it doesn't provide a cent percent gaurantee(say connection going down after sanity check and before being used by application), it still gives good amount of assurance.
In my opinion, it should be fine using this setting.
Having said that, I would still recommend you to check the DB logs to see what is actually cauing this issue.
Refer this article: http://www.dba-oracle.com/t_sqlexception_17410_no_more_data.htm
Regards,
Ashish
Ameriprise Financial
US
Sorry, forgot the error message:
PegaRULES.log-2018-07-23-1532315284:DatabaseException caused by prior exception: java.sql.SQLRecoverableException: No more data to read from socket
PegaRULES.log-2018-07-23-1532315284:Problem #1, SQLState 08000, Error code 17410: java.sql.SQLRecoverableException: No more data to read from socket
PegaRULES.log-2018-07-23-1532315284:Caused by: java.sql.SQLRecoverableException: No more data to read from socket
Pegasystems Inc.
US
What is the oracle version you are using? Can you please check the below article.
https://stackoverflow.com/questions/7839907/no-more-data-to-read-from-socket-error
http://www.oracleracexpert.com/2013/02/java-sql-exception-no-more-data-to-read.html
Ameriprise Financial
US
Thanks for the information. We are using: Database version: Oracle Database 12c Enterprise Edition Release Proprietary information hidden.0 - 64bit Production
As an fyi, the issue only occurs when there is some type of patching on the Oracle farm; during those patching efforts one server in the RAC will go offline and the others continue to handle traffic. It appears that prpc is maintaining connections to the server that goes offline.
Pegasystems Inc.
AU
Hi Mark,
It all depends on the connection pool settings(sizing) at your database end. The settings can be added on the context.xml file, enclosed is an example for postgres db for your reference;
Accepted Solution
Pegasystems Inc.
IN
Hi Mark,
testOnBorrow ensures that before the connection is provided to appliation from the connection pool, a basic sanity test is made to ensure that the connection is not stale.
Although it doesn't provide a cent percent gaurantee(say connection going down after sanity check and before being used by application), it still gives good amount of assurance.
In my opinion, it should be fine using this setting.
Having said that, I would still recommend you to check the DB logs to see what is actually cauing this issue.
Refer this article: http://www.dba-oracle.com/t_sqlexception_17410_no_more_data.htm
Regards,
Ashish