[MDEV-25292] Atomic CREATE OR REPLACE TABLE - Jira

XML

Word

Printable

Details

Type: New Feature
Status: In Testing (View Workflow)
Priority: Critical
Resolution: Unresolved
Fix Version/s: 13.1
Component/s: Data Definition - Create Table
Labels:

Sprint:
Q1/2026 Server Maintenance
PM Planning:

Description

Atomic drop table (~~MDEV-23844~~) does not recover the replaced table if CREATE OR REPLACE TABLE fails.

This is because current, as before, CREATE OR REPLACE TABLE foo ... is implemented as:

DROP TABLE IF EXISTS foo;
CREATE TABLE foo ..

Because of that failed CREATE OR REPLACE TABLE or a crash during the create will lead to lost table, if the original table existed.

This task equips table drop with backing up the old table until the new table was successfully created.

In other words, this task ensures that if one executes CREATE OR REPLACE TABLE foo on an existing table, the table foo will either be the new or old table after the statement has executed, including in the cases the CREATE fails or the server crashes.

NOTE: this change was in a preview release for MariaDB Community Server 10.10.0, but could not be added to 10.10 RC

Attachments

Issue Links

blocks

MDEV-4259 Transactional DDL

Open

MDEV-19191 Partitioning in child tables with foreign keys

In Review

MDEV-31138 Enable the test spider/bugfix.mdev_29676 once MDEV-25292 is pushed

Open

MDEV-36069 Remove dict_table_t::n_ref_count; implement event based table eviction

Open

causes

MDEV-28952 Assertion `t->s->tmp_table || thd->mdl_context.is_lock_owner(MDL_key::TABLE, t->s->db.str, t->s->table_name.str, t->reginfo.lock_type >= TL_WRITE_ALLOW_WRITE ? MDL_SHARED_WRITE : MDL_SHARED_READ)' failed

Closed

MDEV-28956 Locking is broken if CREATE OR REPLACE fails under LOCK TABLES

Closed

MDEV-29544 SIGSEGV in HA_CREATE_INFO::finalize_locked_tables

Closed

MDEV-29620 Assertion `next_insert_id == 0' failed in handler::ha_external_lock

Closed

MDEV-29628 Memory leak after CREATE OR REPLACE with foreign key

Closed

MDEV-29664 Assertion `!n_mysql_tables_in_use' failed in innobase_close_connection

Closed

MDEV-29676 Dual thread hang in 'closing tables' and 'Waiting for table metadata lock' on Spider CREATE OR REPLACE TABLE

Closed

MDEV-29680 ASAN heap-use-after-free in myrocks::Rdb_transaction::on_commit upon CREATE OR REPLACE .. SELECT

Closed

MDEV-29698 Server crash or assertion failure upon CREATE OR REPLACE with a MERGE table

Closed

MDEV-29699 Assertion `!table_list->table || frm.str || !atomic_replace' failed upon CREATE OR REPLACE with ARCHIVE

Closed

MDEV-29701 Inconsistencies and eventual failure upon CREATE OR REPLACE with foreign keys

Closed

MDEV-29709 Unexpected ER_NO_SUCH_TABLE on CREATE OR REPLACE with further assertion failures

Closed

MDEV-29758 CREATE OR REPLACE .. SELECT of Federated table doesn't store selected values

Closed

MDEV-29767 CREATE OR REPLACE bypasses S3 restriction for table creation

Closed

MDEV-29770 Broken table cannot be CREATE OR REPLACE -ed anymore

Closed

MDEV-29772 CREATE OR REPLACE not atomic for sequences (a.k.a tables with SEQUENCE=1)

Closed

MDEV-29779 Unexpected ER_ERROR_ON_RENAME upon CREATE OR REPLACE

Closed

MDEV-29781 Server crashes in ha_myisammrg::add_children_list upon CREATE OR REPLACE with MERGE

Closed

MDEV-29783 ER_NO_SUCH_TABLE_IN_ENGINE after failed CREATE OR REPLACE with FK violation

Closed

MDEV-29787 CREATE OR REPLACE does not work with custom DATA/INDEX DIRECTORY

Closed

MDEV-29791 ER_NO_SUCH_TABLE_IN_ENGINE or "File not found" upon concurrent DDL with CREATE OR REPLACE

Closed

MDEV-29793 Assertion failure in translog_write_record upon CREATE OR REPLACE

Closed

MDEV-29800 ERROR 1062 (23000): Duplicate entry 'test-t-0' for key 'PRIMARY' on CoR for Spider table, DDL_LOG: Got error 1032 or 12524 when trying to execute action for entry 1/2/3/4/5/6/7 of type 'rename table'

Closed

MDEV-29802 #sql-backup tables are visible upon CREATE OR REPLACE and get stuck in S3 storage

Closed

MDEV-29824 Galera crashes when running CoR for a locked table

Closed

MDEV-29831 Galera crashes when running CoR for a locked table after setting the minimum memory for a user session

Closed

MDEV-36435 Assertion failure in Table_specification_st::finalize_locked_tables upon attempt to create an already existing table under lock

Closed

MDEV-36439 Assertion `thd_arg->lex->sql_command != SQLCOM_CREATE_SEQUENCE || (flags2 & FL_DDL) || thd_arg->in_mult i_stmt_transaction_mode()' failed

Closed

MDEV-36475 ASAN errors in ha_innobase::can_be_renamed_to_backup

Closed

MDEV-36493 Atomic CREATE OR REPLACE ... SELECT blocks InnoDB purge

Stalled

MDEV-36497 Assertion failure after atomic CoR with Aria under lock in transactional context

Closed

MDEV-36498 Failed CoR in non-atomic mode no longer generates DROP in RBR, replica diverges

Closed

MDEV-36501 EITS data is lost after failed attempt to CREATE OR REPLACE table

Closed

MDEV-36508 Temporary files #sql-create-....frm occasionally stay after crash recovery

Closed

MDEV-36524 Temporary file is left behind upon CREATE OR REPLACE-ing on Blackhole table

Closed

MDEV-36540 Assertion `!tdc_share_is_cached(thd, db->str, table->str)' fails in execute_drop_table

Closed

MDEV-38479 Crash in CREATE OR REPLACE SEQUENCE when new sequence cannot be created

Closed

MDEV-38559 Atomic CoR: Variable DROP_BEFORE_CREATE_OR_REPLACE should be a flag in OLD_MODE

Closed

MDEV-39367 MSAN/valgrind errors in temp_file_size_cb_func, main.tmp_space_usage fails

Closed

MDEV-39446 Atomic CREATE OR REPLACE fails if a table cannot be decrypted

Closed

MDEV-40157 Atomic CoR: Server crash in drop_open_table upon CREATE OR REPLACE with table name containing non-alpha-num

Open

MDEV-40172 Assertion `!mysql_bin_log.is_open() || is_binlog_format_row()' in THD::mark_tmp_table_as_free_for_reuse

Open

is blocked by

MDEV-28753 Review InnoDB changes for MDEV-25292

Stalled

MDEV-28933 Per-table unique FOREIGN KEY constraint names

Closed

MDEV-29824 Galera crashes when running CoR for a locked table

Closed

MDEV-29831 Galera crashes when running CoR for a locked table after setting the minimum memory for a user session

Closed

MDEV-35854 Clean up some DDL code around FOREIGN KEY constraints

Closed

is part of

MDEV-25921 Implement CREATE TABLE...SELECT in one transaction

Open

relates to

MDEV-26931 Deadlock between ALTER on parent and CREATE OR REPLACE on child

Open

MDEV-33432 Erroneous CREATE OR REPLACE can cause replication abort

Open

MDEV-35895 purge_sys_t::close_and_reopen() can busy loop for a long time

Open

MDEV-36099 Ensure that creation and usage of temporary tables in replication is predictable

Closed

MDEV-36555 mariabackup fails with Error 2 on file ... open during ... table copy: No such file or directory

Stalled

MDEV-39260 RBR: AUTOCOMMIT value affects DDL replication

Open

MDEV-24576 Atomic CREATE TABLE

Closed

MDEV-25595 DROP part of failed CREATE OR REPLACE is not written into binary log

Closed

MDEV-27180 Fully atomic partitioning DDL operations

In Review

has action item: DOCS-5943 Loading...

(41 causes, 5 is blocked by, 1 is part of, 9 relates to, 1 has action item)

Sub-Tasks

Review InnoDB changes for MDEV-25292

Stalled

Sergei Golubchik

Activity

People

Assignee:: Elena Stepanova

Reporter:: Aleksey Midenkov

Assigned for Implementation:: Aleksey Midenkov

Votes:: 3 Vote for this issue

Watchers:: 15 Start watching this issue

Dates

Created:: 2021-03-29 22:46

Updated:: 2 days ago 20:33

Time Tracking

Estimated:

10d

Remaining:

Logged:

105d 3h 31m

Include sub-tasks

Git Integration

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