This is a somewhat uncommon error, so I wanted to take a moment
and post the error and an explanation in order to make it easier
for those who run into this in the future.
The main error is this (full pasted below):
InnoDB: Assertion failure in thread 139838283589376 in file log/log0recv.c line 1094
InnoDB: Failing assertion: !page || (ibool)!!page_is_comp(page) == dict_table_is_comp(index->table)
Basically, this is what it can look like after a power outage. In
fact, this is the only time I have seen it, but I won’t say that
it is the only way you could encounter it.
How do I deal with this, you ask?
Well, the above error shows that the internal InnoDB dictionary
Unfortunately, in this situation, you must recreate the
tablespace. And if you don’t have a current backup + binlogs,
then that means you will also need to …[Read more]