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

CREATE OR REPLACE TABLE ... ENGINE =ColumnStore on InnoDB table can fail with: table already exists (your schema is probably out-of-sync)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 1.5.3
    • N/A
    • N/A
    • None

    Description

      Using MariaDB Enterprise Server 10.5.4-2 with ColumnStore 1.5.3, I started with the following tables:

      MariaDB [innodb_db]> SHOW TABLES
          ->    FROM columnstore_db;
      +--------------------------+
      | Tables_in_columnstore_db |
      +--------------------------+
      | analytics_test           |
      | htap_test1               |
      | htap_test2               |
      +--------------------------+
      3 rows in set (0.001 sec)
      

      Initially, htap_test1 used the InnoDB storage engine. I tried to convert it to ColumnStore with the following query:

      CREATE OR REPLACE TABLE columnstore_db.htap_test1
        ENGINE=COLUMNSTORE
        SELECT * FROM innodb_db.htap_test1;
      

      This failed with the following error:

      ERROR 1815 (HY000): Internal error: CAL0009: Internal create table error for columnstore_db.htap_test1 : table already exists (your schema is probably out-of-sync)
      

      And now the table also disappeared completely:

      MariaDB [innodb_db]> SHOW TABLES
          ->    FROM columnstore_db;
      +--------------------------+
      | Tables_in_columnstore_db |
      +--------------------------+
      | analytics_test           |
      | htap_test2               |
      +--------------------------+
      2 rows in set (0.001 sec)
      

      The definition of the table is very basic:

      CREATE TABLE htap_test1 (id INT) ENGINE = InnoDB;
      

      Attachments

        Activity

          People

            toddstoffel Todd Stoffel (Inactive)
            GeoffMontee Geoff Montee (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.