I used XtraBackup to do a partial backup, a single database from MariaDB 5.5 to MariaDB 10.1. I performed “alter table db.table discard tablespace;” moved .ibd file in place and “alter table db.table import tablespace;” I then start MariaDB and it starts fine. I am able to connect, perform queries etc. When I look at TOP I see the MySQLd process pegged at 100%. I go look at SHOW FULL PROCESSLIST and there no queries. In fact I don’t even have the firewall ports open to allow incoming traffic to the database from the application over port 3306. If I stop mysql and then start it back to 100% CPU. No DISK IO, NO memory delta, just straight 100% CPU.
I have performed these steps in the past and been both successful and have seen this error before. I do not know I how fixed the issue. I could be wrong about this but I seem to remember it having to do with a TIME sync or TIME ZONE issue. Where the innodb position was in the future from the original database source. I am trying jog anyone’s memory.