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 MDEV-28808
        Test MDEV-16329 (ALTER ONLINE TABLE) - Core server part-         
- Closed
 
-