Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
N/A
-
None
Description
--source include/have_binlog_format_mixed.inc
|
--source include/master-slave.inc
|
|
CREATE TABLE t (f INT); |
INSERT INTO t VALUES (NULL),(NULL); |
ALTER TABLE t MODIFY COLUMN f INT AUTO_INCREMENT UNIQUE, ALGORITHM=COPY, LOCK=NONE; |
|
--sync_slave_with_master
|
|
# Cleanup
|
--connection master
|
DROP TABLE t; |
--source include/rpl_end.inc |
Error on the slave:
bb-11.0-oalter b840a7810 |
2023-04-27 2:26:22 8 [ERROR] Slave SQL: Error 'LOCK=NONE is not supported. Reason: COPY algorithm requires a lock. Try LOCK=SHARED' on query. Default database: 'test'. Query: 'ALTER TABLE t MODIFY COLUMN f INT AUTO_INCREMENT UNIQUE, ALGORITHM=COPY, LOCK=NONE', Gtid 0-1-3, Internal MariaDB error code: 1846
|
Attachments
Issue Links
- is caused by
-
MDEV-16329 Engine-independent online ALTER TABLE
- Closed
- is part of
-
MDEV-31058 ER_KEY_NOT_FOUND upon concurrent CHANGE column to autoinc and DML
- Closed
- relates to
-
MDEV-28808 Test MDEV-16329 (ALTER ONLINE TABLE) - Core server part
- Closed