Re: missing InnoDB (partitioned) tables(s) ?
Posted by:
Rick James
Date: December 12, 2014 10:47PM
> no clue why these .par and .frm files have been deleted
> With no space available on a disk these activities might fail (that is the only explanation that comes to my mind).
Maybe... Maybe the sequence and timing of creating files and rm'ing files, etc, is such that the .par and .frm fail to get created. I would consider this to be a bug ( bugs.mysql.com ) in that it can "lose" data rather than gracefully aborting. For many actions, such as an ALTER that copies a table over, the sequence is such that a machine crash or out-of-disk will leave the original table intact -- better than losing stuff.
> 3rd party
Grrr... So many problems are caused by sloppy work by "3rd party" vendors. You should be bugging them, too.
Subject
Views
Written By
Posted
2577
December 10, 2014 02:46AM
1227
December 10, 2014 07:11PM
1282
December 12, 2014 01:50AM
Re: missing InnoDB (partitioned) tables(s) ?
1186
December 12, 2014 10:47PM
1171
December 14, 2014 04:59PM
2087
December 15, 2014 06:31PM
1165
December 16, 2014 04:39PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.