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

mariadb-upgrade prints confusing statement

Details

    Description

      When running mariadb-upgrade it provides confusing statements:

      schema1.table1
      error : Table rebuild required. Please do "ALTER TABLE `table1` FORCE" or dump/reload to fix it!
      schema1.table2 OK
      schema1.table3
      error : Table rebuild required. Please do "ALTER TABLE `table3` FORCE" or dump/reload to fix it!
      schema1.table4 OK
      ...
      `schema1`.`table1` FIXED
      `schema1`.`table4` FIXED

      At the end of the upgrade mariadb-upgrade does the ALTER TABLE FORCE itself. So user does not need to do it.
      So it would be more meaningful to print a message like "Table rebuild required. I do it further down..."

      Customer was confused (an I was as well when reading the first time).

      Would be a good task for a simple community contribution if it will be decided to be implemented...

      Attachments

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28822 Table from older version requires table rebuild when adding column to table with multi-column index

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is blocked by

          Task - A task that needs to be done. MDEV-29672 Add MTR tests covering key and key segment flags and types

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          is caused by

          Bug - A problem which impairs or prevents the functions of the product. MDEV-20704 An index on a double column erroneously uses prefix compression

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28727 ALTER TABLE ALGORITHM=NOCOPY does not work after upgrade

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-28822 Table from older version requires table rebuild when adding column to table with multi-column index

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Task - A task that needs to be done. MDEV-29495 Generalize can_convert_xxx() hook engine API to cover any arbitrary data type

          • Major - Major loss of function.
          • Closed
          mentioned in

          Page Loading...

          Page Loading...

          Page Loading...

          Page Loading...

          Page Loading...

          Page Loading...

          Page Loading...

          Activity

            Transition Time In Source Status Execution Times
            Marko Mäkelä made transition -
            Open In Progress
            		2d 4h 9m 1
            Alexander Barkov made transition -
            In Progress In Review
            		23d 20h 32m 1
            Alexander Barkov made transition -
            Stalled In Review
            		15d 22h 42m 1
            Sergei Golubchik made transition -
            In Review Stalled
            		2d 7h 17m 2
            Alexander Barkov made transition -
            Stalled Closed
            		1d 12m 1

            People

              bar Alexander Barkov
              oli Oli Sennhauser
              Votes:
              1 Vote for this issue
              Watchers:
              9 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.