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
--------------