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

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14337 mysqld_safe may suppress error messages with --log-output=file

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Technical task - A technical task. MDEV-14488 logging not happening on spider branch builds

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14644 MariaDB 10.2.11 breaks binary logging after nightly log cycle

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-14714 mysqld writes status information on HUP signal into innodb data file, breaking it

          • Major - Major loss of function.
          • Closed

          Activity

            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.