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

Allow suppression of InnoDB log messages about reserving extents

Details

    Description

      A user is constantly seeing messages like the following:

      2017-04-23 23:47:44 139336886889216 [Note] InnoDB: Space id 1131 trying to reserve 3 extents actually reserved 256 reserve 7010 free 201 size 44857344 rounds 51 total_reserved 13056
      		 
      2017-04-23 23:47:44 139336886889216 [Note] InnoDB: Space id 1131 trying to reserve 3 extents actually reserved 256 reserve 7011 free 205 size 44857600 rounds 52 total_reserved 13312

      It looks like these messages were added as part of the fix for MDEV-8386.

      These messages are causing the user's error log to grow very large.

      Would it be possible to make some way to suppress these log messages? Maybe they can be changed to warnings, and then suppressed by decreasing log_warnings? Or maybe it can be controlled by some other variable?

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-8386 MARIADB creates very big tmp file > 351Gb. Started happening after Version 10.0.16-15

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            marko Marko Mäkelä added a comment -

            I would suggest to remove this output, or make it conditional on global_system_variables.log_warnings > 2, like MDEV-10509 did to the output that MDEV-6812 introduced for ALTER TABLE…ALGORITHM=INPLACE.

            marko Marko Mäkelä added a comment - I would suggest to remove this output, or make it conditional on global_system_variables.log_warnings > 2, like MDEV-10509 did to the output that MDEV-6812 introduced for ALTER TABLE…ALGORITHM=INPLACE.
            jplindst Jan Lindström (Inactive) added a comment -

            commit d03abc71a490f4ee6d173d07c95a2adb9c60457c
            Author: Jan Lindström <jan.lindstrom@mariadb.com>
            Date: Thu Jun 8 10:34:10 2017 +0300

            MDEV-12609: Allow suppression of InnoDB log messages about reserving extents

            Removed this output.

            jplindst Jan Lindström (Inactive) added a comment - commit d03abc71a490f4ee6d173d07c95a2adb9c60457c Author: Jan Lindström <jan.lindstrom@mariadb.com> Date: Thu Jun 8 10:34:10 2017 +0300 MDEV-12609 : Allow suppression of InnoDB log messages about reserving extents Removed this output.

            People

              jplindst Jan Lindström (Inactive)
              GeoffMontee Geoff Montee (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.