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

ALTER TABLE progress report > 100%

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Minor
        • Resolution: Fixed
        • Affects Version/s: 5.5.34, 10.0.7
        • Fix Version/s: 5.5.35, 10.0.8
        • Component/s: None
        • Labels:
          None

          Description

          Server reports the progress for "copy to tmp table" step of the ALTER TABLE as "number of records copied" / "total number of records as reported by the engine".

          In some engines this second number (total number of records) is only an estimation and may be less than the actual number of records. In this case the progress report will go over 100%. This is confusing for users and might break tools that don't expect that.

          As we cannot fix the estimation in engines, the server should limit the reported progress value never to be larger than 100%.

            Gliffy Diagrams

              Attachments

                Activity

                Hide
                Permalink
                dbart Daniel Bartholomew added a comment -

                http://bazaar.launchpad.net/~maria-captains/maria/5.5/revision/4049

                Show
                dbart Daniel Bartholomew added a comment - http://bazaar.launchpad.net/~maria-captains/maria/5.5/revision/4049

                  People

                  • Assignee:
                    serg Sergei Golubchik
                    Reporter:
                    serg Sergei Golubchik
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved:

                      Time Tracking

                      Estimated:
                      Original Estimate - 15 minutes
                      15m
                      Remaining:
                      Remaining Estimate - 0 minutes
                      0m
                      Logged:
                      Time Spent - 10 minutes Time Not Required
                      10m