[teiid-issues] [JBoss JIRA] (TEIID-2172) Load balancing configuration can result in extraneous "invalid session" messages

[Marc Shirley (JIRA)]

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

Marc Shirley updated TEIID-2172:
--------------------------------

    Steps to Reproduce:   (was: To reproduce:
1) Install to the production profile
2) Create two profiles/nodes from the enabled profile (for example, copy the 'production' profile to 'prod1' and 'prod2')
3) Place the contents of the included deploy directory into the deploy directory of the two nodes created in step 2
4) Edit the Teiid-ds.xml to point the datasource to the connection details for the two nodes, 'prod1' and 'prod2'
5) Start both nodes
      run.sh -c prod1 -Djboss.messaging.ServerPeerID=1 -Djboss.service.binding.set=ports-default
      run.sh -c prod2 -Djboss.messaging.ServerPeerID=2 -Djboss.service.binding.set=ports-01
6) Run the attached client in 'JMSClusterClient.jar', substituting the appropriate addresses for nodes 'prod1' and 'prod2'
      java -jar JMSClusterClient.jar 127.0.0.1:1100 127.0.0.1:1200
7) Observe the server.log entries to view the recorded invalid session messages with mixed session ids. In some brief testing it appears to be occurring at a frequency of 2-5% (5-10 occurrences in the test's 200 connections).
bq.      2012-08-24 10:39:58,818 WARN  [org.teiid.SECURITY] (New I/O server worker #1-3) Processing exception 'The specified session ID "5Wt/6zzmsLy2" is invalid. It cannot be found in the userbase.' for session R8ZxYqjZzf/S.  Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:315). Enable more detailed logging to see the entire stacktrace.)

    
> Load balancing configuration can result in extraneous "invalid session" messages
> --------------------------------------------------------------------------------
>
>                 Key: TEIID-2172
>                 URL: https://issues.jboss.org/browse/TEIID-2172
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Driver
>    Affects Versions: 7.4.4
>         Environment: Clustered environment with load balancing enabled for the Teiid data source
>            Reporter: Marc Shirley
>            Assignee: Steven Hawkins
>
> When set up in a load balancing configuration with "SET NEW INSTANCE" as the check valid connection SQL in the datasource definition, repeated messages indicating an invalid session are created, similar to:
>       2012-08-24 10:39:58,818 WARN  [org.teiid.SECURITY] (New I/O server worker #1-3) Processing exception 'The specified session ID "5Wt/6zzmsLy2" is invalid. It cannot be found in the userbase.' for session R8ZxYqjZzf/S.  Exception type org.teiid.client.security.InvalidSessionException thrown from org.teiid.services.SessionServiceImpl.getSessionInfo(SessionServiceImpl.java:315). Enable more detailed logging to see the entire stacktrace.
> Not sure if this would be a defect in regards to the conditions that are resulting in the messages to be generated (ie, the old session id shouldn't be being reused), or an enhancement to clarify or adjust the log message or priority to indicate whether this will actually affect the query being submitted.  

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira