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 created issue -
            psergei Sergei Petrunia made changes -
            Field Original Value New Value
            Assignee Sergei Petrunia [ psergey ]
            psergei Sergei Petrunia made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            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?
            psergei Sergei Petrunia made changes -
            Assignee Sergei Petrunia [ psergey ] Jan Lindström [ jplindst ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            jplindst Jan Lindström (Inactive) added a comment -

            Sergei,

            Ok to push.

            jplindst Jan Lindström (Inactive) added a comment - Sergei, Ok to push.
            jplindst Jan Lindström (Inactive) made changes -
            Assignee Jan Lindström [ jplindst ] Sergei Petrunia [ psergey ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            serg Sergei Golubchik made changes -
            Affects Version/s 10.0.12 [ 15201 ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.0 [ 16000 ]
            psergei Sergei Petrunia made changes -
            Fix Version/s 10.1 [ 16100 ]
            Fix Version/s 10.0 [ 16000 ]
            psergei Sergei Petrunia made changes -
            Fix Version/s 10.1.1 [ 16801 ]
            Fix Version/s 10.1 [ 16100 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            ratzpo Rasmus Johansson (Inactive) made changes -
            Workflow MariaDB v2 [ 50414 ] MariaDB v3 [ 64624 ]
            marko Marko Mäkelä made changes -
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 64624 ] MariaDB v4 [ 148042 ]

            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.