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

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

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 10.0.12
        • Fix Version/s: 10.1.1
        • Component/s: None
        • Labels:
          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.

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                psergey 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.

                Show
                psergey 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.
                Hide
                Permalink
                psergey Sergei Petrunia added a comment -

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

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

                Jan, could you please review?

                Show
                psergey Sergei Petrunia added a comment - Jan, could you please review?
                Hide
                Permalink
                jplindst Jan Lindström added a comment -

                Sergei,

                Ok to push.

                Show
                jplindst Jan Lindström added a comment - Sergei, Ok to push.

                  People

                  • Assignee:
                    psergey Sergei Petrunia
                    Reporter:
                    psergey Sergei Petrunia
                  • Votes:
                    1 Vote for this issue
                    Watchers:
                    4 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: