Re: Schema inconsistency after inplace alter table in MySQL 5.6.6-m9
Dmitry Lenev <[email protected]> Wed, 12 Sep 2012 20:10:48 +0400
| Newsgroups | gmane.comp.db.mysql.devel |
|---|---|
| Message-ID | <20120912161048.GA29234@jubjub> |
Hello Rich! * Rich Prohaska <[email protected]> [12/09/12 18:55]: > Hello > > How does one recover from crashes that occur when altering a partitioned table, > especially if the operation is committed on the storage engine but the frm is old? The only way that comes to my mind is to finish .frm renaming manually (i.e. by manually renaming .frm files on disk). But, indeed, this is not a satisfactory solution for normal users and a better solution is necessary (e.g. automatic recovery/redo in some form). -- Dmitry Lenev, Software Developer Oracle Development SPB/MySQL, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification -- MySQL Internals Mailing List For list archives: http://lists.mysql.com/internals To unsubscribe: http://lists.mysql.com/internals