[MDEV-15250] UPSERT during ALTER-TABLE results in 'Duplicate entry' error for alter - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.0, 10.1, 10.1.30, 10.2, 10.3, 10.4, 10.5, 10.6, 10.7, 10.8
Fix Version/s: 10.6.8, 10.7.4, 10.8.3, 10.9.1
Component/s: Data Definition - Alter Table, Locking, Replication, Storage Engine - InnoDB
Labels:
None

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

MDEV-26294 Duplicate entries in unique index not detected when changing collation with INPLACE / NOCOPY algoritm

Closed

MDEV-27747 Assertion `log->blobs' failed in row_log_table_apply_update upon ALTER TABLE

Closed

MDEV-29519 InnoDB: Failing assertion: rec in storage/innobase/lock/lock0lock.cc line 5052

Closed

causes

MDEV-28443 MDEV-15250 causes latch order violation

Closed

MDEV-28449 Assertion `index->lock.have_x() == has_index_lock' failed in row_log_apply_op

Closed

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

Closed

MDEV-30346 Avoid block device required error in innodb_fts.misc_debug

Closed

MDEV-30802 Assertion `index->is_btree() || index->is_ibuf()' failed in btr_search_guess_on_hash

Closed

relates to

MDEV-16282 ALTER TABLE t ADD COLUMN c INT, ADD INDEX(c), ALGORITHM=NOCOPY fails

Stalled

MDEV-14535 Duplicate entry on ALTER TABLE ADD COLUMN

Closed

MDEV-16329 Engine-independent online ALTER TABLE

Closed

MDEV-23197 Assertion `(index)->is_clust() || !dict_index_is_online_ddl(index)' failed. in lock_rec_create_low

Closed

MDEV-26096 Make the Unique index ONLY evaluate immediately before the commit (NOT after each UPDATE)

Stalled

(3 causes, 5 relates to)

Activity

People

Assignee:: Thirunarayanan Balathandayuthapani

Reporter:: sjon

Votes:: 1 Vote for this issue

Watchers:: 8 Start watching this issue

Dates

Created:: 2018-02-08 10:43

Updated:: 4 days ago 13:34

Resolved:: 2022-04-25 15:33

Git Integration

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