Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-5000

ALTER TABLE ADD COLUMN breaks on Columnstore Replica

    XMLWordPrintable

    Details

      Description

      Tested on Columnstore cluster version 6.2.3, the following command:

      alter table test add column (col2 varchar(100));
      

      breaks replication on replica nodes:

      2022-02-23 20:25:42 7 [ERROR] Slave SQL: Error 'Got error 1815 "Unknown error 1815" from storage engine ColumnStore' on query. Default database: 'yy'. Query: 'alter table test add column (col2 varchar(100))', Gtid 0-10-39, Internal MariaDB error code: 1030
      2022-02-23 20:25:42 7 [Warning] Slave: Got error 1815 "Unknown error 1815" from storage engine ColumnStore Error_code: 1030
      2022-02-23 20:25:42 7 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mariadb-bin.000002' position 806132326; GTID position '0-10-38'
      

      Problem discovered in Columnstore training.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            edward Edward Stoever
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration

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