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

    • Type: New Feature
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.1.2
    • Component/s: MariaDB Server
    • Labels:
      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

            Assignee:
            Unassigned
            Reporter:
            dtheodor Dimitris Theodorou
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration