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

ORDER BY RAND() ERROR 1815 (HY000): Internal error: IDB-2045: At least one PrimProc closed the connection unexpectedly.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 5.5.1
    • Fix Version/s: 6.2.1, 6.2.2
    • Component/s: None
    • Labels:
      None
    • Environment:
      MariaDB 10.5.8-5 ES running on CentOS 7.9 on AWS t2.xlarge instance
    • Sprint:
      2021-10, 2021-11, 2021-12, 2021-13, 2021-14

      Description

      Create Schema

      CREATE DATABASE test;
      USE test;
       
      CREATE TABLE `innodbt` (
        `C_` varchar(100) DEFAULT NULL,
        `A_` varchar(100) DEFAULT NULL,
        `B_` varchar(100) DEFAULT NULL,
        `D_` varchar(100) DEFAULT NULL,
        `E_` varchar(100) DEFAULT NULL
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
       
      CREATE TABLE `colstore` (
        `C_` varchar(100) DEFAULT NULL,
        `A_` varchar(100) DEFAULT NULL,
        `B_` varchar(100) DEFAULT NULL,
        `D_` varchar(100) DEFAULT NULL,
        `E_` varchar(100) DEFAULT NULL
      ) ENGINE=Columnstore DEFAULT CHARSET=utf8;
       
      DELIMITER $$
      CREATE PROCEDURE gendemo()
      BEGIN
      DECLARE i INT DEFAULT 0;
      WHILE i < 50000 DO
      INSERT INTO `innodbt` (C_,A_,B_,D_,E_) VALUES (
      ROUND((RAND() * 100000),0), ROUND((RAND() * 100000),0), ROUND((RAND() * 100000),0), ROUND((RAND() * 100000),0),
      1
      );
      SET i = i + 1;
      END WHILE;
      insert into colstore select * from innodbt;
      END$$
      DELIMITER ;
       
      CALL gendemo();
       
      insert into innodbt( C_, A_, B_, D_, E_) select C_, A_, B_, D_ , E_
      FROM (select 'text' as C_, A_, B_, D_ , E_ FROM colstore
      )derived;
      

      Populate Schema

      Run CALL gendemo(); then insert into innodbt snippet from above until SELECT COUNT FROM `colstore`; returns 2300000.

      Run Test

      USE test;
      select * from `colstore`order by rand();
      

      Expected Output

      ERROR 1815 (HY000): Internal error: IDB-2045: At least one PrimProc closed the connection unexpectedly.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              dleeyh Daniel Lee
              Reporter:
              rob.schwyzer@mariadb.com Rob Schwyzer
              Votes:
              1 Vote for this issue
              Watchers:
              6 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.