8 Replies Latest reply on May 27, 2014 11:07 AM by Ramesh Reddy

    session-max-limit

    Rakesh Balguri Expert

      Hi all,

       

      We are using Teiid 8.7 and one of our servers hit  the following exception.

       

      TEIID40043 The server has reached the maximum number of sessions of 5,000 as defined by the property "session-max-limit".  If more sessions are required, modify this property value in the "standalone-teiid.xml" file


      From the error I understand that the maximum number of sessions have been reached and to modify the property in the standalone-teiid.xml.

      I did not find this property in the standalone-teiid.xml nor I did not find the documentation for this property.


      Can you point me to the documentation for this property?


      Thanks

      Rakesh

        • 1. Re: session-max-limit
          Steven Hawkins Master

          > I did not find this property in the standalone-teiid.xml


          Since the server will remove properties with default values from the xml, this is not treated as a self-documented file.

           

          > Can you point me to the documentation for this property?


          I don't believe all properties are covered in the documentation per se, but you can interrogate via the CLI to see all of the available properties to set.  In this case the error message is not correct.  It should read max-session-allowed instead.  So that will need corrected.

          • 2. Re: session-max-limit
            Rakesh Balguri Expert

            Thanks Steve.

             

            Is there a way by which we can monitor the number of sessions consumed? We can perform some operations and track the number of sessions consumed.

            We think that there might be a connection leak and all the sessions are being consumed and not released.

             

            Thanks

            Rakesh.

            • 3. Re: session-max-limit
              Steven Hawkins Master

              See Monitoring - Teiid 8.8 (draft) - Project Documentation Editor

               

              Also I have corrected the above to actually be: max-session-allowed

              • 4. Re: session-max-limit
                Ramesh Reddy Master

                You can use Admin Web Console, see request tab under a VDB, or use the Admin API getSessions() or use CLI based call like

                 

                /subsystem=teiid:list-sessions(vdb-name, vdb-version)

                 

                to see current list of session to the system

                 

                Ramesh..

                • 5. Re: session-max-limit
                  Rakesh Balguri Expert

                  Thanks Steve and Ramesh.

                   

                  What is the default value of sessions-expiration-timelimit? Is the value in seconds or minutes?

                  How do we make sure that the session is closed after the work is complete. Closing the connection?

                  • 6. Re: Re: session-max-limit
                    Ramesh Reddy Master

                    you can do

                     

                    /subsystem=teiid:read-resource
                    

                     

                    to see all the values defined in subsystem

                     

                    /subsystem=teiid:read-resource-description
                    

                     

                    to see the descriptions of the each attribute

                     

                    Ramesh..

                    • 7. Re: session-max-limit
                      Rakesh Balguri Expert

                      Thanks.. I was able to set the value.

                       

                      How do we make sure that the session is closed after the work is complete. Closing the connection?

                       

                      Is there a way to terminate a session which is not in use or not active? Currently if I set sessions-expiration-timelimit all the active sessions are being terminated

                       

                      Thanks

                      Rakesh

                      • 8. Re: session-max-limit
                        Ramesh Reddy Master

                        Rakesh,

                        How do we make sure that the session is closed after the work is complete. Closing the connection?

                        Yes, a connection co-relates to session on server side

                         

                        Is there a way to terminate a session which is not in use or not active?

                        You can check if there are any active queries running based on session id, then you can issue a terminate if you need to. Admin API "getRequestsForSession" or CLI "list-requests" will give you the representative list

                         

                        Currently if I set sessions-expiration-timelimit all the active sessions are being terminated

                        Have you checked the descriptions of the attributes as I explained above? the description for it says "Max allowed time before the session is terminated by the system, 0 indicates unlimited (default 0)"

                         

                        Ramesh..