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

Server fails to start because of aria_log_control-file

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

            It is caused by MDEV-14488, fixed in 10.2.12.

            See, your aria_log_control is corrupted, it contains error log messages inside. It happened in 10.2.11, and upgrading to 10.2.12 didn't help, because the file already was corrupted by 10.2.11.

            serg Sergei Golubchik added a comment - It is caused by MDEV-14488 , fixed in 10.2.12. See, your aria_log_control is corrupted, it contains error log messages inside. It happened in 10.2.11, and upgrading to 10.2.12 didn't help, because the file already was corrupted by 10.2.11.
            alex2 Alex added a comment -

            I was already wondering why the log-messages are stored in this file. Thanks!

            I can confirm that there are no log-messages in aria_log_control after removal and starting 10.2.12.

            alex2 Alex added a comment - I was already wondering why the log-messages are stored in this file. Thanks! I can confirm that there are no log-messages in aria_log_control after removal and starting 10.2.12.

            People

              serg Sergei Golubchik
              alex2 Alex
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.