-
1. Re: session-max-limit
shawkins May 26, 2014 10:48 AM (in response to rakeshsagar)> 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
rakeshsagar May 26, 2014 10:45 AM (in response to shawkins)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
shawkins May 26, 2014 10:48 AM (in response to rakeshsagar)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
rareddy May 26, 2014 11:12 AM (in response to rakeshsagar)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
rakeshsagar May 27, 2014 6:11 AM (in response to rareddy)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
rareddy May 27, 2014 8:16 AM (in response to rakeshsagar)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
rakeshsagar May 27, 2014 10:43 AM (in response to rareddy)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
rareddy May 27, 2014 11:07 AM (in response to rakeshsagar)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..