session-max-limit

[rakeshsagar]

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

[shawkins]

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

[rakeshsagar]

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.

[shawkins]

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

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

[rareddy]

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

[rakeshsagar]

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?

[rareddy]

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

[rakeshsagar]

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

[rareddy]

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