Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-564

Aggregation overflow error

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 1.0.7, 1.1.5
    • Fix Version/s: 1.2.3
    • Component/s: ExeMgr
    • Labels:
      None

      Description

      Build 1.0.7-1

      This is a known issue.

      MariaDB [mytest]> create table t1 (c1 bigint) engine=columnstore;
      Query OK, 0 rows affected (0.34 sec)

      MariaDB [mytest]> insert into t1 values (9223372036854775807), (9223372036854775807);
      Query OK, 2 rows affected (0.18 sec)
      Records: 2 Duplicates: 0 Warnings: 0

      MariaDB [mytest]> select sum(c1) from t1;
      ERROR 1815 (HY000): Internal error: An unexpected condition within the query caused an internal processing error within InfiniDB. Please check the log files for more details. Additional Information: aggregation data overflow.

      in err.log

      Feb 10 15:45:18 ip-172-30-0-236 joblist[18843]: 18.318893 |26|0|0| C 05 CAL0000: Aggregation overflow.: 9223283296451814817+152123350462331 > 9223372036854775807

      I discuss with the InfiniDB engineers on this issue before. I believe the issue is that the datatype of the variable used to hold intermediate and final aggregation result is 64 bit. Summing two hugh 64 bit values would trigger this error. I believe this issue is system wide, rather than one specific area so we need to look at it from a system design point of view.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              dleeyh Daniel Lee
              Votes:
              2 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: