Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.5, 10.6, 10.1.30, 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.7(EOL), 10.8(EOL)
-
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 Constraints: support deferred constraints [WAS: Make the Unique index ONLY evaluate immediately before the commit (NOT after each UPDATE)]
- Open
-
MDEV-33462 Server aborts while altering an InnoDB statistics table
- Closed