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

No progress indication for "Reading tablespace information from the .ibd files"

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.12
    • 10.1.1
    • None
    • None

    Description

      The "Reading tablespace information from the .ibd files" step during InnoDB recovery can take a long time but provides no information.

      We should make it indicate progress being made, .e.g every 15 seconds.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-11027 InnoDB log recovery is too noisy

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            psergei Sergei Petrunia added a comment -

            Made a patch that prints messages like this:

            140718  2:30:33 [Note] InnoDB: Starting crash recovery.
            		 
            140718  2:30:33 [Note] InnoDB: Reading tablespace information from the .ibd files...
            		 
            140718  2:30:49 [Note] InnoDB: Processed 429 .ibd/.isl files
            		 
            140718  2:31:05 [Note] InnoDB: Processed 1045 .ibd/.isl files
            		 
            140718  2:31:21 [Note] InnoDB: Processed 1562 .ibd/.isl files
            		 
            140718  2:31:37 [Note] InnoDB: Processed 2299 .ibd/.isl files
            		 
            140718  2:31:53 [Note] InnoDB: Processed 3234 .ibd/.isl files
            		 
            140718  2:31:56 [Note] InnoDB: Restoring possible half-written data pages 
            140718  2:31:56 [Note] InnoDB: from the doublewrite buffer...

            messages are printed every 15 seconds.

            psergei Sergei Petrunia added a comment - Made a patch that prints messages like this: 140718 2:30:33 [Note] InnoDB: Starting crash recovery. 140718 2:30:33 [Note] InnoDB: Reading tablespace information from the .ibd files... 140718 2:30:49 [Note] InnoDB: Processed 429 .ibd/.isl files 140718 2:31:05 [Note] InnoDB: Processed 1045 .ibd/.isl files 140718 2:31:21 [Note] InnoDB: Processed 1562 .ibd/.isl files 140718 2:31:37 [Note] InnoDB: Processed 2299 .ibd/.isl files 140718 2:31:53 [Note] InnoDB: Processed 3234 .ibd/.isl files 140718 2:31:56 [Note] InnoDB: Restoring possible half-written data pages 140718 2:31:56 [Note] InnoDB: from the doublewrite buffer... messages are printed every 15 seconds.
            psergei Sergei Petrunia added a comment -

            Patch: http://lists.askmonty.org/pipermail/commits/2014-July/006354.html

            psergei Sergei Petrunia added a comment - Patch: http://lists.askmonty.org/pipermail/commits/2014-July/006354.html
            psergei Sergei Petrunia added a comment -

            Jan, could you please review?

            psergei Sergei Petrunia added a comment - Jan, could you please review?
            jplindst Jan Lindström (Inactive) added a comment -

            Sergei,

            Ok to push.

            jplindst Jan Lindström (Inactive) added a comment - Sergei, Ok to push.

            People

              psergei Sergei Petrunia
              psergei Sergei Petrunia
              Votes:
              1 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.