Fix for Incorrect Weight Calculation in SQL Process Prioritizer During Consumer Group Modifications
Details
| Detail name | Value |
|---|---|
| Changelog Number | 27520 |
| Type | Bug |
| Status | Resolved |
| Affected Versions | Exasol 8.7.0 |
| Fix Versions | Exasol 2025.1.5, Exasol 2025.2.0 |
| Resolution Date | 2025-12-05 |
Description
The bug occurs when a session is queued for SQL process allocation and its prioritization weight is calculated based on the consumer group. During the queue lifecycle, if the consumer group weight is modified, reassigned, or removed, the prioritizer updates the weights dynamically for all queued sessions. However, when the session is allocated the SQL process and later re-queued, it retains initial weight values rather than reflecting the updated consumer group data. This leads to:
- Incorrect prioritization weights for queued sessions.
- Invalid priority values affecting resource allocation.
- Suboptimal performance due to miscalculations in SQL process distribution.
Workaround
No workaround
Fix
Fixed in the latest release.
