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

ALTER TABLE ADD COLUMN breaks on Columnstore Replica

    XMLWordPrintable

Details

    • 2021-17

    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

            tntnatbry Gagan Goel (Inactive)
            edward Edward Stoever
            Roman Roman
            Daniel Lee Daniel Lee (Inactive)
            Votes:
            2 Vote for this issue
            Watchers:
            10 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.