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

Table creation failed after 10 times load and restart of mdb

    XMLWordPrintable

Details

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

    Description

      1. on 48 core 128 GB machine, I have set memory_limit=90GB
      2. drop tpch schema, if exists. create tpch schema and tables with engine=duckdb
      3. ingest data using udf
      4. Run load
      5. Repeat step 2-4 10 times
      6. shutdown server
      7. Repeat step 2 ( drop and create schema and create tables) and you will hit error

      + mariadb -e 'source create-tables-duckdb.sql;use tpch; show tables;'
      --------------
      CREATE TABLE nation ( N_NATIONKEY INTEGER primary key,
      N_NAME CHAR(25) NOT NULL,
      N_REGIONKEY INTEGER NOT NULL,
      N_COMMENT VARCHAR(152))engine=duckdb
      --------------

      ERROR 1296 (HY000) at line 18 in file: 'create-tables-duckdb.sql': Got error 168 'TransactionContext Error: Failed to commit: Could not commit creation of dependency, subject "nation" has been deleted' from DuckDB
      --------------
      CREATE TABLE region ( R_REGIONKEY INTEGER primary key,
      R_NAME CHAR(25) NOT NULL,
      R_COMMENT VARCHAR(152))engine=duckdb
      --------------

      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.