tracker issue : CF-3991616

select a category, or use search below
(searches all categories and all time range)
Title:

removeOnExceptions is true for <datasource_name>. Closed the physical connection.

| View in Tracker

Status/Resolution/Reason: Closed/Won't Fix/Workaround

Reporter/Name(from Bugbase): David Wright / David Wright (David Wright)

Created: 05/20/2015

Components: Database

Versions: 11.0

Failure Type: Performance Issue

Found In Build/Fixed In Build: CF11_Final /

Priority/Frequency: Major / All users will encounter

Locale/System: English / Linux

Vote Count: 0

Problem Description:
Any query including a join to a database link table produces this error in the coldfusion-out.log.  Using the standard Oracle driver.

Steps to Reproduce:
Run a query that joins at least 2 tables, one of which is from a database link.

Actual Result:
Query runs fine but the error:
removeOnExceptions is true for <datasource_name>.  Closed the physical connection.

shows up in the coldfusion-out.log and database connections are closed.

Expected Result:
No error.  Database connections remain open.

Any Workarounds:

Clearing Maintain Connections - https://helpx.adobe.com/coldfusion/kb/coldfusion-mx-removeonexception-errors-serverlog.html


Wrapping a query in a <cftransaction> tag.

This is also happening on our CF9 servers.  We are trying to upgrade to CF11 and have noticed that the performance of CF11 running the same code as our CF9 servers is very poor.  Queries are reasonably fast at one time and then slow down to a crawl or timeout altogether.  Trying to determine if this error is causing issues with CF11.

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3991616

External Customer Info:
External Company:  
External Customer Name: David
External Customer Email:  
External Test Config: Ubuntu linux 14.04, 16GB memory, 8CPUs

Apache 2.4

Oracle 11g database

Standard CF install

Attachments:

  1. July 07, 2015 00:00:00: 1_serversettings.doc

Comments:

David, Please provide below mentioned information: 1. Settings summary 2. Oracle Database version 3. Database driver being used 4. Exception log Is this issue intermittent or you are able to replicate this issue consistently?
Comment by Nimit S.
7369 | July 07, 2015 12:32:57 AM GMT
1. Server Settings have been attached 2. Oracle Database Version - 11.2.0.4 3. Database Driver - CF11 Oracle Driver 4. No exceptions in exception log coldfusion-out.log example Jul 7, 2015 07:36:40 AM Information [scheduler-3] - Run Client Storage Purge removeOnExceptions is true for live_hire. Closed the physical connection. removeOnExceptions is true for live_hire. Closed the physical connection. removeOnExceptions is true for live_hire. Closed the physical connection.
Comment by External U.
7370 | July 07, 2015 08:31:45 AM GMT
I can replicate this issue consistently. Every time I run the following query I get the removeOnExceptions is true error. select u.name from IQ_INTERVIEWERS i, users@perms u where i.userid = u.userid
Comment by External U.
7371 | July 07, 2015 08:36:01 AM GMT
Hi David, It looks like this issue only occurs with database links in oracle Please try the suggestion given the article mentioned below: https://helpx.adobe.com/coldfusion/kb/coldfusion-mx-removeonexception-errors-serverlog.html I am also trying to replicate this issue. I will investigate it further and get it fixed.
Comment by Nimit S.
7372 | August 20, 2015 08:49:23 AM GMT
Hi David, Have you tried the suggestion mentioned below? Regards, Nimit
Comment by Nimit S.
7373 | September 29, 2015 04:48:48 AM GMT
Clearing Maintain Connections on the datasource does the trick but I think this effectively kills connection pooling. Also, we found out that this problem was not the cause of poor performance so I think this can be closed with the "Clearing Maintain Connections" workaround. Thanks
Comment by External U.
7374 | September 29, 2015 07:42:25 AM GMT
Thanks David for your confirmation. I will be closing this issue.
Comment by Nimit S.
7375 | September 29, 2015 08:46:45 AM GMT
As per David, the work-around works.
Comment by HariKrishna K.
7376 | July 13, 2017 07:53:30 AM GMT