1

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

alex.eremenko
  • 11
  • 2

1 Answers1

0

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.

Community
  • 1
  • 1
David
  • 9,288
  • 1
  • 20
  • 52