I am having an issue with CF2021 standard where the application is experiencing performance issue

New Here ,
Mar 21, 2021 Mar 21, 2021

Copy link to clipboard

Copied

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?

Views

44

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Mar 26, 2021 Mar 26, 2021

Copy link to clipboard

Copied

LATEST

Are connections to local as well as remote databases timing out?

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines