[MDEV-7881] InnoDB Logfile size - misleading error message Created: 2015-03-30  Updated: 2015-06-14  Resolved: 2015-06-14

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB, Storage Engine - XtraDB
Affects Version/s: 10.0
Fix Version/s: 10.0.20

Type: Bug Priority: Minor
Reporter: Kai Schlachter Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: 10.0.20

 Description   

It may happen, that an insert statement fails, because of an insufficient size of the InnoDB logfile, eg. described here:
http://stackoverflow.com/questions/25299370/mysql-error-1118-row-size-too-large-when-restoring-django-mailer-database

The problem is, that the logfile is to small to handle the insert bundled insert statment used by the created dumpfile (one insert, multiple rows). This may lead to an undesired case where you may create a dump, but you are not able to restore the dump on the same sever.

The error message given ist Error 1118 (Row size too large) - which is misleading at best, in case of an overrun in the logfile, the error should reflect this and give a correct hint to the user.


Generated at Thu Feb 08 07:22:58 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.