New answers tagged innodb
Table alteration involves /tmp partition as intermediate storage for explicitly and implicitly created temporary tables. You have to use the tmpdir on a partition that big enough. Add the next line to the my.cnf tmpdir = /path/to/the/mysqltmp
It's a corruption. See the failed assertion - page_is_comp(next_page) == page_is_comp(page). It checks if a next page is in the same format (COMPACT or REDUNDANT) as the current one. InnoDB index can be in either format, but the mix is impossible. So, go ahead with innodb_force_recovery=1,2,3,4,5,6 (try each value until MySQL starts), dump databases and ...
You have a (really badly) corrupt database, which is crashing mysql. As a sidenote, this should only happed in rare cases like kernel freeze or power loss coupled with forcing innodb_flush_log_at_trx_commit to 2 or using a raid controller with write cache forced on but no backup battery. If you have to recover the data, you can try starting mysql with ...
Top 50 recent answers are included