Improved active session management for open prepared statements
Details
| Detail name | Value |
|---|---|
| Changelog Number | 12190 |
| Type | Improvement |
| Status | Resolved |
| Fix Versions | Exasol 7.1.0 |
| Resolution Date | 2021-08-03 |
Background
Prepared statements exist in two different states
- prepare statement
- execute prepared statement
Improvement
Exasols Session Management has been improved as sessions are not counted as active sessions in the following circumstances:
- the session only contains prepared statements
- the prepared statements are only in the prepare statement state (not in execute prepared statement)
As a result, these sessions are not consuming an active session slot, preventing sessions to be queued.
Changed behavior
Sessions with open prepared statements only are not counted as active sessions any more.
