[teiid-issues] [JBoss JIRA] (TEIID-4139) Session/Connection to VDB gets closed after 2 minutes of innactivity

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4139?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins updated TEIID-4139:
----------------------------------
    Priority: Major  (was: Blocker)


The log does not show any org.teiid.SECURITY context messages indicating that the server is terminating the session.  Ensure that you are logging at a debug level on that context as well.

We do see several instances each of:

2016-04-08 11:11:57,313 [New I/O worker #94] WARN  [org.teiid.TRANSPORT] TEIID40114 Unhandled exception, closing client instance: not an SSL/TLS record: 000000800003000075736572006a65636f6c656d61006461746162617365006d61726b6574696e675f76646d00636c69656e745f656e636f64696e67005554463800446174655374796c650049534f0054696d655a6f6e6500416d65726963612f4e65775f596f726b0065787472615f666c6f61745f64696769747300320000

2016-04-08 12:48:45,448 [New I/O worker #68] WARN  [org.teiid.TRANSPORT] TEIID40114 Unhandled exception, closing client instance: Received fatal alert: certificate_unknown

This is not expected from the Teiid client.  More than likely a load balancer is sending unexpected traffic.

Since there are a number of sessions being created and queries after that point in the log it's unclear how that correlates to the exception you've shown in the description.  If this could be repeated for just a single session with a correlated client log, that could help narrow in.

> Session/Connection to VDB gets closed after 2 minutes of innactivity
> --------------------------------------------------------------------
>
>                 Key: TEIID-4139
>                 URL: https://issues.jboss.org/browse/TEIID-4139
>             Project: Teiid
>          Issue Type: Bug
>          Components: Server
>    Affects Versions: 8.7.1
>         Environment: RHEL 6, AWS VM, JBoss EAP (standalone)	6.3.2.GA	
> JBoss Data Virtualization	6.1.0.ER4
>            Reporter: Jorge Herrera
>            Assignee: Steven Hawkins
>         Attachments: jdv-jdbc-config.txt, server.log
>
>
> When setting up a VDB connecting (using jdbc over ssl) to either another VDB in the same server or directly to a RDBMS (Amazon Redshift in this case), if you execute queries one after the other the server works as expected. But if you let the session idle, or just looking at the result set for more than 2 minutes, session gets disconnected with the following message:
> _______________________________________________
> DBCException: SQL Error [08S01]: org.teiid.net.socket.SingleInstanceCommunicationException
> SQL Error [08S01]: org.teiid.net.socket.SingleInstanceCommunicationException
>   TeiidSQLException: org.teiid.net.socket.SingleInstanceCommunicationException
>   org.teiid.net.socket.SingleInstanceCommunicationException
>     SingleInstanceCommunicationException
>     org.teiid.net.socket.SingleInstanceCommunicationException
>       EOFException
>       java.io.EOFException
> _______________________________________________



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)