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

Query causes TupleUnion::readInput() MCS-2035: An internal error occurred.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Done
    • 22.08.7
    • 23.02.4
    • N/A

    Description

      tested on CS 6.3.1 WITHOUT ERROR
      tested on 22.08.8 where I see the error.
      Customer reported this occurs in Columnstore version 22.08.7

      create schema CS0617891; 
      use CS0617891;
       
      drop table if exists `test1`;
      CREATE TABLE `test1` (`col1` decimal(12,2) DEFAULT NULL, `col2` smallint(5) unsigned DEFAULT NULL)
      ENGINE=Columnstore DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
      insert into test1 (col1,col2) values (99.99,2);
       
      drop table if exists `test2`;
      CREATE TABLE `test2` (`col1` decimal(12,2) DEFAULT NULL, `col2` int(10) unsigned DEFAULT NULL) 
      ENGINE=Columnstore DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
      insert into test2 (col1,col2) values (99.99,2);
       
      --- RUN THIS UNION QUERY:
      SELECT 'test1' AS table_name, count(*) as 'rows', SUM(col1*col2) AS losses FROM test1 UNION 
      SELECT 'test2' AS table_name, count(*) as 'rows', SUM(col1*col2) AS losses FROM test2;
       
      --- NOW, TRY THIS QUERY:
      select * FROM (
      SELECT 'test1' AS table_name, count(*) as 'rows', SUM(col1*col2) AS losses FROM test1 UNION 
      SELECT 'test2' AS table_name, count(*) as 'rows', SUM(col1*col2) AS losses FROM test2) 
      AS TABLES ORDER BY losses DESC, 'rows' DESC;
      ERROR 1815 (HY000): Internal error: An unexpected condition within the query caused an internal processing error within Columnstore. Please check the log files for more details. Additional Information: error in UnionStep.
      

      In err.log:

      Jul 26 20:27:43 logs Calpont[216316]: 43.949355 |0|0|0| E 00 CAL0000: ./storage/columnstore/columnstore/utils/rowgroup/rowgroup.h@847: assertion '0' failed         %%10%%
      Jul 26 20:27:43 logs joblist[216316]: 43.949490 |77|0|0| C 05 CAL0000: TupleUnion::readInput() MCS-2035: An internal error occurred.  Check the error log file & contact support.         %%10%%
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            edward Edward Stoever
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.