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

UPSERT during ALTER-TABLE results in 'Duplicate entry' error for alter

Details

    Description

      I have a master that very frequently executes INSERT ON DUPLICATE KEY UPDATE. On a slave I executed ALTER TABLE xx row_format=COMPRESSED;, however this resulted in an error (the specific key is a UNIQUE) from the ALTER statement, which did not succeed:

      ERROR 1062 (23000): Duplicate entry 'xxx-xxx' for key 'xxx'

      I assume this is because it received an UPSERT while it was altering the table. I think this shouldn't happen as the alter-table should have a lock on the table.

      Attachments

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26294 Duplicate entries in unique index not detected when changing collation with INPLACE / NOCOPY algoritm

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27747 Assertion `log->blobs' failed in row_log_table_apply_update upon ALTER TABLE

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29519 InnoDB: Failing assertion: rec in storage/innobase/lock/lock0lock.cc line 5052

          • Major - Major loss of function.
          • Closed
          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28443 MDEV-15250 causes latch order violation

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28449 Assertion `index->lock.have_x() == has_index_lock' failed in row_log_apply_op

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28806 Server crash in row_log_online_op or Assertion `flag == 1' failure in row_build_index_entry_low upon concurrent ALTER and UPDATE

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30346 Avoid block device required error in innodb_fts.misc_debug

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30802 Assertion `index->is_btree() || index->is_ibuf()' failed in btr_search_guess_on_hash

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-16282 ALTER TABLE t ADD COLUMN c INT, ADD INDEX(c), ALGORITHM=NOCOPY fails

          • Major - Major loss of function.
          • Stalled

          Bug - A problem which impairs or prevents the functions of the product. MDEV-36281 DML aborts during online virtual index

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14535 Duplicate entry on ALTER TABLE ADD COLUMN

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-16329 Engine-independent online ALTER TABLE

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-23197 Assertion `(index)->is_clust() || !dict_index_is_online_ddl(index)' failed. in lock_rec_create_low

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. MDEV-26096 Constraints: support deferred constraints [WAS: Make the Unique index ONLY evaluate immediately before the commit (NOT after each UPDATE)]

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33462 Server aborts while altering an InnoDB statistics table

          • Major - Major loss of function.
          • Closed

          Activity

            Transition Time In Source Status Execution Times
            Elena Stepanova made transition -
            Open Closed
            		57d 9h 10m 1
            Marko Mäkelä made transition -
            Closed Stalled
            		1315d 16h 50m 1
            Thirunarayanan Balathandayuthapani made transition -
            Stalled In Progress
            		13d 3h 34m 2
            Thirunarayanan Balathandayuthapani made transition -
            In Progress In Review
            		142d 15h 17m 2
            Marko Mäkelä made transition -
            In Review Stalled
            		5d 5h 8m 2
            Thirunarayanan Balathandayuthapani made transition -
            Stalled Closed
            		3d 2h 47m 1

            People

              thiru Thirunarayanan Balathandayuthapani
              sjon sjon
              Votes:
              1 Vote for this issue
              Watchers:
              8 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.