Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-7881

InnoDB Logfile size - misleading error message

Details

    • 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.

      Attachments

        Activity

          mc-murphy Kai Schlachter created issue -
          serg Sergei Golubchik made changes -
          Field Original Value New Value
          Issue Type Task [ 3 ] Bug [ 1 ]
          serg Sergei Golubchik made changes -
          Affects Version/s 10.0 [ 16000 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.0 [ 16000 ]
          serg Sergei Golubchik made changes -
          Assignee Jan Lindström [ jplindst ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 60300 ] MariaDB v3 [ 63825 ]
          serg Sergei Golubchik made changes -
          Sprint 10.0.20 [ 5 ]
          jplindst Jan Lindström (Inactive) made changes -
          Component/s Storage Engine - XtraDB [ 10135 ]
          Fix Version/s 10.0.20 [ 19201 ]
          Fix Version/s 10.0 [ 16000 ]
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 63825 ] MariaDB v4 [ 148975 ]

          People

            jplindst Jan Lindström (Inactive)
            mc-murphy Kai Schlachter
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.