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

LDI returned "no space for a dictionary insert" error

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 23.02
    • 22.08.8
    • writeengine
    • None

    Description

      Build tested
      engine: 678bd6c91e22c72f57462f05a16dd8fea68a0db4
      server: 34ad833c6a39f169c4a42f52338258ea563bc263
      buildNo: 6098

      MTR test case: columnstore/extended.mcs7002_ldi_rollback.test

      create table lineitem (
      l_orderkey int,
      l_partkey int,
      l_suppkey int,
      l_linenumber bigint,
      l_quantity decimal(12,2),
      l_extendedprice decimal(12,2),
      l_discount decimal(12,2),
      l_tax decimal(12,2),
      l_returnflag char (1),
      l_linestatus char (1),
      l_shipdate date,
      l_commitdate date,
      l_receiptdate date,
      l_shipinstruct char (25),
      l_shipmode char (10),
      l_comment varchar (44)
      ) engine=columnstore DEFAULT CHARSET=utf8mb3;
      # -------------------------------------------------------------- #
      # LDI 1m datasets for the lineitem table
      # -------------------------------------------------------------- #
      set columnstore_use_import_for_batchinsert=on;
      SET AUTOCOMMIT=0;
      LOAD DATA INFILE '/data/qa/source/dbt3/1m/lineitem.tbl' INTO TABLE lineitem FIELDS TERMINATED BY '|';
      LOAD DATA INFILE '/data/qa/source/dbt3/1m/lineitem.tbl' INTO TABLE lineitem FIELDS TERMINATED BY '|';
      LOAD DATA INFILE '/data/qa/source/dbt3/1m/lineitem.tbl' INTO TABLE lineitem FIELDS TERMINATED BY '|';
      LOAD DATA INFILE '/data/qa/source/dbt3/1m/lineitem.tbl' INTO TABLE lineitem FIELDS TERMINATED BY '|';
      ROLLBACK;
      LOAD DATA INFILE '/data/qa/source/dbt3/1m/lineitem.tbl' INTO TABLE lineitem FIELDS TERMINATED BY '|';
      LOAD DATA INFILE '/data/qa/source/dbt3/1m/lineitem.tbl' INTO TABLE lineitem FIELDS TERMINATED BY '|';
      LOAD DATA INFILE '/data/qa/source/dbt3/1m/lineitem.tbl' INTO TABLE lineitem FIELDS TERMINATED BY '|';
      LOAD DATA INFILE '/data/qa/source/dbt3/1m/lineitem.tbl' INTO TABLE lineitem FIELDS TERMINATED BY '|';
      ROLLBACK;
      LOAD DATA INFILE '/data/qa/source/dbt3/1m/lineitem.tbl' INTO TABLE lineitem FIELDS TERMINATED BY '|';
      LOAD DATA INFILE '/data/qa/source/dbt3/1m/lineitem.tbl' INTO TABLE lineitem FIELDS TERMINATED BY '|';
      LOAD DATA INFILE '/data/qa/source/dbt3/1m/lineitem.tbl' INTO TABLE lineitem FIELDS TERMINATED BY '|';
      LOAD DATA INFILE '/data/qa/source/dbt3/1m/lineitem.tbl' INTO TABLE lineitem FIELDS TERMINATED BY '|';
      ROLLBACK;
      LOAD DATA INFILE '/data/qa/source/dbt3/1m/lineitem.tbl' INTO TABLE lineitem FIELDS TERMINATED BY '|';
      LOAD DATA INFILE '/data/qa/source/dbt3/1m/lineitem.tbl' INTO TABLE lineitem FIELDS TERMINATED BY '|';
      LOAD DATA INFILE '/data/qa/source/dbt3/1m/lineitem.tbl' INTO TABLE lineitem FIELDS TERMINATED BY '|';
      LOAD DATA INFILE '/data/qa/source/dbt3/1m/lineitem.tbl' INTO TABLE lineitem FIELDS TERMINATED BY '|';
      ROLLBACK;
      LOAD DATA INFILE '/data/qa/source/dbt3/1m/lineitem.tbl' INTO TABLE lineitem FIELDS TERMINATED BY '|';
      LOAD DATA INFILE '/data/qa/source/dbt3/1m/lineitem.tbl' INTO TABLE lineitem FIELDS TERMINATED BY '|';
      LOAD DATA INFILE '/data/qa/source/dbt3/1m/lineitem.tbl' INTO TABLE lineitem FIELDS TERMINATED BY '|';
      LOAD DATA INFILE '/data/qa/source/dbt3/1m/lineitem.tbl' INTO TABLE lineitem FIELDS TERMINATED BY '|';
      ROLLBACK;
      LOAD DATA INFILE '/data/qa/source/dbt3/1m/lineitem.tbl' INTO TABLE lineitem FIELDS TERMINATED BY '|';
      LOAD DATA INFILE '/data/qa/source/dbt3/1m/lineitem.tbl' INTO TABLE lineitem FIELDS TERMINATED BY '|';
      LOAD DATA INFILE '/data/qa/source/dbt3/1m/lineitem.tbl' INTO TABLE lineitem FIELDS TERMINATED BY '|';
      LOAD DATA INFILE '/data/qa/source/dbt3/1m/lineitem.tbl' INTO TABLE lineitem FIELDS TERMINATED BY '|';
      ROLLBACK;
      SELECT COUNT(*) FROM lineitem;
      

      After the 3rd ROLLBACK, LDI in the 4th set returned an error:
      MariaDB [mytest]> LOAD DATA INFILE '/data/qa/source/dbt3/1m/lineitem.tbl' INTO TABLE lineitem FIELDS TERMINATED BY '|';
      ERROR 1815 (HY000): Internal error: CAL0001: Insert Failed: no space for a dictionary insert
      MariaDB [mytest]> LOAD DATA INFILE '/data/qa/source/dbt3/1m/lineitem.tbl' INTO TABLE lineitem FIELDS TERMINATED BY '|';
      ERROR 1815 (HY000): Internal error: CAL0001: Insert Failed: no space for a dictionary insert
      MariaDB [mytest]> LOAD DATA INFILE '/data/qa/source/dbt3/1m/lineitem.tbl' INTO TABLE lineitem FIELDS TERMINATED BY '|';
      ERROR 1815 (HY000): Internal error: CAL0001: Insert Failed: no space for a dictionary insert
      MariaDB [mytest]> ROLLBACK;
      Query OK, 0 rows affected (0.015 sec)

      Attachments

        Activity

          People

            tntnatbry Gagan Goel (Inactive)
            dleeyh Daniel Lee (Inactive)
            Daniel Lee Daniel Lee (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.