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

Server fails to start because of aria_log_control-file

    XMLWordPrintable

    Details

      Description

      Like in MDEV-7218 the server fails to start with "File size bigger than expected":

      2018-01-08  9:45:33 140239529691264 [ERROR] mysqld: Got error 'File size bigger than expected' when trying to use aria control file '/var/lib/mysql/aria_log_control'
      2018-01-08  9:45:33 140239529691264 [ERROR] Plugin 'Aria' init function returned error.
      2018-01-08  9:45:33 140239529691264 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
      ...
      2018-01-08  9:45:36 140239529691264 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables
      2018-01-08  9:45:36 140239529691264 [ERROR] Aborting
      

      However, the filesize of aria_log_control is only 3241 Bytes (not 2.5 GB as in MDEV-7218):

      -rw-rw---- 1 mysql mysql      40960 Jan  8 09:40 aria_log.00000001
      -rw-rw---- 1 mysql mysql       3241 Jan  8 09:40 aria_log_control
      

      Attached is the aria_log_control-file. Problem occured in 10.2.11 as well as 10.2.12.

      Workaround:

      cd /var/lib/mysql/
      mv aria_log_control aria_log_control.old
      systemctl start mysql
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              serg Sergei Golubchik
              Reporter:
              alex2 Alex
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: