CODEWITHSUNDEEP
ddlgoogle-cloud-sql
alex.eremenko
alex.eremenko

Reputation: 11

Failing DDL and locked database

Instance: skilled-tiger-296:db

One table became inaccessible with selects failing error 'Table doesn't exist'. Attempts to drop table caused the same error. Attempts to create table caused error 'Table exists already'. Attempts to drop schema fail with internal error and disconnect from instance.

Forward-engineering schema with a new name helped for a couple days and now its failing again on the same table.

Problem 1: Lost table Problem 2: cannot drop database (dbname: flow)

Please advice

Upvotes: 1

Views: 80

Answers (1)

David
David

Reputation: 9731

It sounds like you may have a corruption problem. Try running DROP TABLE IF EXISTS and REPAIR TABLE like in this question. Also make sure in future you use InnoDB tables as these are much more robust.

Upvotes: 0

Related Questions