tracker issue : CF-4188864

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

"Closed the physical connection" for some queries since Coldfusion 10 update 20

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/Duplicate

Reporter/Name(from Bugbase): Stéphane Chauvin / Stéphane Chauvin (Stéphane Chauvin)

Created: 09/13/2016

Components: Database

Versions: 10.0

Failure Type: Non Functioning

Found In Build/Fixed In Build: Final / 303100

Priority/Frequency: Critical / All users will encounter

Locale/System: English / Win 2008 Server R2 64 bit

Vote Count: 0

Problem Description:
Since the update 20 of Coldfusion 10, we encounter a query problem that leads to closing the physical connection :

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

The select query actually runs well but after that, any other query fail with the following message : 
"[Macromedia][Oracle JDBC Driver]Object has been closed"

The JDBC driver is the Oracle built-in driver.

The select query contains :
- one inner join
- 6 left outer joins, one of which is with a select subquery that contains itself 3 left joins
- string concats with '||' operators
- use of decode() function


Any Workarounds:
Uninstall "update 20" and go back to "update 19" : solves the issue.

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

Watson Bug ID:	4188864

Reason:	PRHaveInfo

External Customer Info:
External Company:  
External Customer Name: St├ęphane Chauvin
External Customer Email:  
External Test Config: Coldfusion 10.0

Apache 2.2

Windows server 2008 / Windows 7

Attachments:

Comments:

Stephane, Are you able to repro this issue consistently? If yes, please share repro case along with Database schema.
Comment by Nimit S.
1833 | September 21, 2016 09:41:05 AM GMT
Yes I reproduce it consistenly, on different platfoms (dev / integ / prod). Can I send you the informations directly (as it is private) ?
Comment by External U.
1834 | September 21, 2016 09:46:12 AM GMT
Yes, please send it to nimsharm@adobe.com
Comment by Nimit S.
1835 | September 22, 2016 01:15:26 AM GMT
Stephane, Please send the required information at below mentioned email address so that we can start investigating this issue.
Comment by Nimit S.
1836 | September 28, 2016 11:06:10 PM GMT
Nimit, I sent it to you by email 6 days ago. The mail contains two rar files (75Ko and 15Ko). Could you check again ? thanks
Comment by External U.
1837 | September 30, 2016 04:10:37 AM GMT
The mail was send the 22th at 03h40 PM (Paris Time) The subject is "Bug #CF-4188864 (Coldfusion 10.0.21)"
Comment by External U.
1838 | September 30, 2016 04:11:37 AM GMT
I can replicate this issue as well and believe it can be narrowed to tables that contain CLOB/CLOB fields. The query itself can be very simple - it's the CLOB/BLOB that is the identifying feature.
Comment by Craig M.
1839 | February 07, 2017 12:43:54 AM GMT
Hello, This is a duplicate of another bug #CF-4165262. So, closing this bug and we will track it with the original bug. We are in the process of validating the fix. Please subscribe to the original bug for an update.
Comment by Nimit S.
1840 | July 07, 2017 12:22:48 PM GMT