tracker issue : CF-4170895

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

Update 9: ODBC Access Connection Timing Out

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/NotABug

Reporter/Name(from Bugbase): Matt Reid / Matt Reid (Matt Reid)

Created: 07/06/2016

Components: Database

Versions: 11.0

Failure Type: Non Functioning

Found In Build/Fixed In Build: CF11_Final /

Priority/Frequency: Major / Some users will encounter

Locale/System: English / Win 2012 Server x64

Vote Count: 0

Problem Description: A non-SQL error occurred while requesting a connection from DATASOURCENAME. Timed out trying to establish connection. swagent.exe runs high on CPU and cannot be stopped with the service -- must manually kill.

Steps to Reproduce: Application is running normally. The problem frequency is about a week and happens on a different DB query each time.

Actual Result: Application produces error stating DB query timed out out.

Expected Result: Query should complete as it has not been changed between updates.

Any Workarounds: Kill swagent.exe and restart Service

Logs state:

A non-SQL error occurred while requesting a connection from DATASOURCENAME.
Timed out trying to establish connection

Jul 6, 2016 12:50:04 PM Error [ajp-bio-8014-exec-7] - Error Executing Database Query.Timed out trying to establish connection

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

Watson Bug ID:	4170895

External Customer Info:
External Company:  
External Customer Name: Matt Reid
External Customer Email:  
External Test Config: My Hardware and Environment details: 



   Operating System: Windows Server 2012 R2 Standard 64-bit (6.3, Build 9600) (9600.winblue_ltsb.160513-1153)

           Language: English (Regional Setting: English)

System Manufacturer: VMware, Inc.

       System Model: VMware Virtual Platform

               BIOS: PhoenixBIOS 4.0 Release 6.0     

          Processor: Intel(R) Xeon(R) CPU E5-2690 v3 @ 2.60GHz (2 CPUs), ~2.6GHz

             Memory: 3072MB RAM

Available OS Memory: 3072MB RAM

          Page File: 2681MB used, 1541MB available

        Windows Dir: C:\Windows

    DirectX Version: DirectX 11

Attachments:

Comments:

This did not happen when we were on Update 7.
Comment by External U.
2218 | July 06, 2016 12:19:21 PM GMT
Correction, it looks like it is swsoc.exe that runs high on CPU and needs to be killed. Sorry for the mistake.
Comment by External U.
2219 | July 07, 2016 01:57:29 PM GMT
Matt, Thanks for reporting this issue. Please provide the information mentioned below: 1. Does this issue occur when ColdFusion server is under high load? 2. What is the database server which you are using with ODBC connection? 3. Have you tried reverting the update to the previous version? If yes, does it restore the behavior? Please share the settings summary of ColdFusion server. In order to get settings summary, follow below mentioned steps: 1. Login into CF administrator 2. Navigate to Server Settings > Settings summary 3. Click on "Save As PDF" on top right corner.
Comment by Nimit S.
2220 | July 10, 2016 11:54:37 PM GMT
Matt, Please provide me an update on this issue. -Nimit
Comment by Nimit S.
2221 | July 14, 2016 02:26:05 AM GMT
Matt, Please provide me an update on it if you are still facing this issue.
Comment by Nimit S.
2222 | July 28, 2016 12:03:31 AM GMT
Turned out to be a bug in a SQL Query. This can be closed -- thanks!
Comment by External U.
2223 | July 29, 2016 02:23:14 PM GMT
Thanks Matt for confirming this.
Comment by Nimit S.
2224 | July 29, 2016 10:40:21 PM GMT