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

SET GLOBAL innodb_log_file_size is not crash safe

Details

    Description

      MDEV-33894 included an inadvertent change that causes SET GLOBAL innodb_log_file_size to write incorrect data to the being-resized log file (ib_logfile101). This does not affect the memory mapped log implementation on 64-bit Linux systems (when the log is stored in a mount -o dax file system or in /dev/shm). As far as I can tell, the fix should be this simple:

      diff --git a/storage/innobase/log/log0log.cc b/storage/innobase/log/log0log.cc
      		 
      index 93f8db6bfc0..84219dbc830 100644
      		 
      --- a/storage/innobase/log/log0log.cc
      		 
      +++ b/storage/innobase/log/log0log.cc
      		 
      @@ -804,7 +804,7 @@ void log_t::resize_write_buf(size_t length) noexcept
      		 
         }
      		 
       
         ut_a(os_file_write_func(IORequestWrite, "ib_logfile101", resize_log.m_file,
      		 
      -                          buf, offset, length) == DB_SUCCESS);
      		 
      +                          resize_flush_buf, offset, length) == DB_SUCCESS);
      		 
       }
      		 
       
       /** Write buf to ib_logfile0.

      Attachments

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34062 mariadb-backup --backup is extremely slow at copying ib_logfile0

          • Major - Major loss of function.
          • Closed
          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35411 innodb.log_file_size_online occasionally fails

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-33894 MariaDB does unexpected storage read IO for the redo log

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-34802 Recovery fails to note some log corruption

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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-34875 provide mechanism to monitor the status of dynamic redo log resize operation

          • Major - Major loss of function.
          • Open

          Activity

            Transition Time In Source Status Execution Times
            Marko Mäkelä made transition -
            Open In Progress
            		8s 1
            Marko Mäkelä made transition -
            In Progress In Testing
            		12m 57s 1
            Marko Mäkelä made transition -
            In Testing Stalled
            		5d 21h 38m 1
            Marko Mäkelä made transition -
            Stalled In Progress
            		2s 1
            Marko Mäkelä made transition -
            In Progress In Review
            		3d 20h 58m 1
            Marko Mäkelä made transition -
            Stalled In Review
            		1d 20h 54m 1
            Debarun Banerjee made transition -
            In Review Stalled
            		4d 9h 49m 2
            Marko Mäkelä made transition -
            Stalled Closed
            		52m 15s 1

            People

              marko Marko Mäkelä
              marko Marko Mäkelä
              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.