I am having an issue with CF2021 standard where the application is experiencing performance issue. This is possibly due to the timeouts happening on one of the datasources in rds. Our App server is running on Adobe Std 2021, with httpd and tomcat on RHEL8 64bit. The app server also has a mariadb running on it, the application has the datasources on referencing to the local ones as well as the AWS RDS hosted ones.
We are stuggling to find out what caused the issue. The users often experience performance issues at various times and in the coldfusion-error.log, and exception.log we only see DB connection time outs.
Exceptions:
=========
Mar 22, 2021 1:14:31 PM org.apache.coyote.ajp.AjpProcessor logError
SEVERE: null
java.io.IOException: Broken pipe
at java.base/sun.nio.ch.FileDispatcherImpl.write0(Native Method)
at java.base/sun.nio.ch.SocketDispatcher.write(SocketDispatcher.java:47)
at java.base/sun.nio.ch.IOUtil.writeFromNativeBuffer(IOUtil.java:113)
at java.base/sun.nio.ch.IOUtil.write(IOUtil.java:79)
at java.base/sun.nio.ch.IOUtil.write(IOUtil.java:50)
A non-SQL error occurred while requesting a connection from xxxxx-localdatabase.
Timed out trying to establish connection
A non-SQL error occurred while requesting a connection from xxxxx-remote-rds-db.
Timed out trying to establish connection
This is what was caught in exception log; Connection timeout to the DB {cannot confirm it it was local or remote since error log report both local mariab and remote rds db's at the same time}
=========
Exception.log:
============
"Error","ajp-nio-127.0.0.1-8120-exec-3348","03/22/21","15:17:56","ourappname","Error Executing Database Query.Timed out trying to establish connection The specific sequence of files included or processed is: /var/www/coldfusion-xxxx.l
ive/view_item/index.cfm, line: 58 "
coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:929)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821)
.....
....
Caused by: java.sql.SQLException: Timed out trying to establish connection
at coldfusion.server.j2ee.sql.pool.JDBCPool.requestConnection(JDBCPool.java:946)
at coldfusion.server.j2ee.sql.pool.JDBCManager.requestConnection(JDBCManager.java:125)
at coldfusion.server.j2ee.sql.JRunDataSource.getConnection(JRunDataSource.java:137)
at coldfusion.sql.CFDataSource.getConnection(CFDataSource.java:56)
at coldfusion.sql.DataSrcImpl.getCachedConnection(DataSrcImpl.java:156)
at coldfusion.sql.DataSrcImpl.getConnection(DataSrcImpl.java:110)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:377)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247)
Application.log:
============
"Error","ajp-nio-127.0.0.1-8120-exec-3417","03/22/21","15:17:56","ourappname","Error Executing Database Query.Timed out trying to establish connection The specific sequence of files included or processed is: /var/www/coldfusion-ourappname.live/view_item/index.cfm, line: 64 "
Would someone be able to assist us here?
1
Reply
AdChoices