Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-40170

Table creation failed after OOM in duckdb

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 11.4, 11.8, 12.3
    • None
    • None
    • ubuntun 24 LTS

    Description

      set duck memory =122GB out of 125 GB total memory and start mariadb
      2. create tpch schema tables with engine=duckdb
      3. ingest data using udf
      4. Run many times load until you hit OOM
      5. shutdown server
      6, set set duck memory = default (1 GB) and start mariadb
      7. drop schema tpch
      8. create tpch schema and tables with engine=duckdb, you will hit issue below:
      ERROR 4211 (HY000) at line 70 in file: 'create-tables-duckdb.sql': [DuckDB] DuckDB commit transaction error. TransactionContext Error: Failed to commit: Could not commit creation of dependency, subject "lineitem" has been deleted
      MariaDB [tpch]> show tables;
      ----------------

      Tables_in_tpch

      ----------------

      customer
      lineitem
      nation
      orders
      part
      partsupp
      region
      supplier

      ----------------
      8 rows in set (0.000 sec)

      MariaDB [tpch]>

      Attachments

        Activity

          People

            drrtuy Roman
            amroo76 Amrendra Kumar
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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