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

[Jorge Herrera (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4139?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13191995#comment-13191995 ] 

Jorge Herrera commented on TEIID-4139:
--------------------------------------

Ok. As you mentioned the load balancer might be the problem, I will work on that side and re-test, then I will update this ticket. Thank you so much!

> 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)