[MCOL-5198] Part2 -Disk-based aggregation fails with ERROR 1815 (HY000): Internal error: TupleAggregateStep::threadedAggregateRowGroups()[24] MCS-2054: Unknown error while aggregation. Created: 2022-08-17  Updated: 2022-10-26  Resolved: 2022-08-24

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr
Affects Version/s: 6.2.3, 6.3.1, 6.4.1
Fix Version/s: 6.4.5-dompe

Type: Bug Priority: Major
Reporter: Roman Assignee: Roman
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2021-17
Assigned for Testing: Daniel Lee Daniel Lee (Inactive)

 Description   

The aggregation on VARCHAR(128) column(number of distinct values is aproximately 31 bln) fails with an obscure error.

ERROR 1815 (HY000): Internal error: TupleAggregateStep::threadedAggregateRowGroups()[24] MCS-2054: Unknown error while aggregation.  

The current implementation of RowAggStorage::increaseSize() can raise RowAggStorage::Data::fMask 4 times before rehashing happens. The guarding check in increaseSize() is too restrictive and fails easily with big numbers in fCurData->fMask and fCurData->fSize(see RowAggStorage::increaseSize() for details).

The suggested solution is to increase the multiplier in the expression:

if (fCurData->fSize * 2 < calcMaxSize(fCurData->fMask + 1))


Generated at Thu Feb 08 02:56:05 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.