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

Recovering from error "Cannot create table: table already exists (your schema is probably out-of-sync)"

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 1.1.2
    • MariaDB Server
    • None

    Description

      I've lost (data loss) the MariaDB data directory, but I still have the MariaDB Columnstore data directory. All the corresponding information schema and calpontsys queries show that while MariaDB Columnstore recognizes the tables correctly, MariaDB itself doesn't know anything about them.

      Trying to run the create query "CREATE TABLE IF NOT EXISTS tablename ..." for a table that already exists returns the error "Internal create table error for tablename: table already exists (your schema is probably out-of-sync)". Running select queries is not possible, I get a "table does not exist" error.

      Is there a way to recover from this? Can I recreate the tables in the MariaDB "side" so that I can resume operations normally?

      Attachments

        Activity

          People

            Unassigned Unassigned
            dtheodor Dimitris Theodorou
            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.