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

Online ALTER is allowed on master but fails on slave with ER_ALTER_OPERATION_NOT_SUPPORTED_REASON

    XMLWordPrintable

Details

    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

          Activity

            People

              nikitamalyavin Nikita Malyavin
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.