How to fix the No more room in record file error when restoring a database from a dump?

D

Daniil Muidinov2017-01-19 20:31:28

linux

Daniil Muidinov, 2017-01-19 20:31:28

Distrib 10.1.21-MariaDB Error ERROR 1005 (HY000) at line 25: Can't create table (errno: 135 "No more room in record file")
Restoring database from sql dump All InnoDB tables but the database was deleted and created empty, and the dump is restored to it. Where to dig?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

N

Nokim, 2017-02-06
@Nokim

Enabled the innodb_strict_mode option and disabled innodb_use_fallocate with innodb_use_trim - it worked. I didn’t need the last two options, in general, I added innodb_file_format=barracuda when enabled for some reason ... On fallocate, the MariaDB server cursed in the logs.
innodb_strict_mode - the dock strongly recommends enabling it when working with new file formats.