Details
-
New Feature
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
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?