[
https://issues.jboss.org/browse/TEIID-4013?page=com.atlassian.jira.plugin...
]
Steve Tran commented on TEIID-4013:
-----------------------------------
I think I side-tracked the conversation by mentioning TEIID-3879. I was just trying to
say that I am working in a clustered environment, and I do run into the same errors as
TEIID-3879.
When TEIID-3879 happens, it halts all ODBC connections. The original problem is these
ODBC sessions keep getting created and never closed. They can, and will be established
for days. Performing a "netstat -natp | grep 35432 | wc" can show up to dozens
and hundreds of open connections, all coming from the same client machine. The client
machine is running SQL Server, with ODBC DSN and do have SQL Server Linked Servers objects
created.
ODBC sessions never release
---------------------------
Key: TEIID-4013
URL:
https://issues.jboss.org/browse/TEIID-4013
Project: Teiid
Issue Type: Bug
Affects Versions: 8.7.1.6_2
Environment: Red Hat JBoss Data Virtualization 6.2.2 on EAP6.4.0 patched to
version 6.4.5,
JBoss Developer Studio 8.1.0GA with Teiid Designer plugin
9.0.3.Final.v20150810-1438-B1157
64-bit Windows 7 environment
Reporter: Steve Tran
Assignee: Steven Hawkins
Attachments: Capture.PNG, Capture2.PNG, Capture3.PNG
I have 3 ODBC System DSNs on a Windows server. When I'm viewing the Deployed VDBs
and looking at the Sessions tab, the ODBC connections never seem to time out or release.
Not really sure if/when they should release, but they continue to multiply. See
screenshots.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)