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

progress on OPTIMIZE table resets itself 3 times during run (and finishes on 0)

    XMLWordPrintable

Details

    Description

      From: https://dba.stackexchange.com/questions/322862/mariadb-optimize-table-progress-jumps-from-99-to-0

      10.11

      From: while true; do mysql -S /tmp/build-mariadb-server-10.11.sock -e 'show processlist'; sleep 0.1; done
       
      +-----+------+-----------+------+---------+------+----------+------------------+----------+
      | Id  | User | Host      | db   | Command | Time | State    | Info             | Progress |
      +-----+------+-----------+------+---------+------+----------+------------------+----------+
      |   6 | dan  | localhost | test | Query   |    0 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    0 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    0 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    0 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    0 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    0 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    0 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    0 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    0 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    0 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    1 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    1 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    1 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    1 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    1 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    1 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    1 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    1 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    1 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    2 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    2 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    2 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    2 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    2 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    2 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    2 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    2 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    2 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    2 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    3 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    3 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    3 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    3 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    3 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    3 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    3 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    3 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    3 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    4 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    4 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    4 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    4 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    4 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    4 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    4 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    4 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    4 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    4 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    5 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    5 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    5 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    5 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    5 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    5 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    5 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    5 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    5 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    6 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    6 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    6 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    6 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    6 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    6 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    6 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    6 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    6 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    6 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    7 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    7 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    7 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    7 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    7 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    7 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    7 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    7 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    7 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    7 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    8 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    8 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    8 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    8 | altering table | optimize table test_opened_ticket |   49.153 |
      |   6 | dan  | localhost | test | Query   |    8 | altering table | optimize table test_opened_ticket |   49.153 |
      |   6 | dan  | localhost | test | Query   |    8 | altering table | optimize table test_opened_ticket |   74.576 |
      |   6 | dan  | localhost | test | Query   |    8 | altering table | optimize table test_opened_ticket |   74.576 |
      |   6 | dan  | localhost | test | Query   |    8 | altering table | optimize table test_opened_ticket |   74.576 |
      |   6 | dan  | localhost | test | Query   |    8 | altering table | optimize table test_opened_ticket |   86.441 |
      |   6 | dan  | localhost | test | Query   |    9 | altering table | optimize table test_opened_ticket |   86.441 |
      |   6 | dan  | localhost | test | Query   |    9 | altering table | optimize table test_opened_ticket |   93.220 |
      |   6 | dan  | localhost | test | Query   |    9 | altering table | optimize table test_opened_ticket |   93.220 |
      |   6 | dan  | localhost | test | Query   |    9 | altering table | optimize table test_opened_ticket |   96.610 |
      |   6 | dan  | localhost | test | Query   |    9 | altering table | optimize table test_opened_ticket |   96.610 |
      |   6 | dan  | localhost | test | Query   |    9 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    9 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    9 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    9 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |    9 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |   10 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |   10 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |   10 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |   10 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |   10 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |   10 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |   10 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |   10 | altering table | optimize table test_opened_ticket |   49.153 |
      |   6 | dan  | localhost | test | Query   |   10 | altering table | optimize table test_opened_ticket |   49.153 |
      |   6 | dan  | localhost | test | Query   |   11 | altering table | optimize table test_opened_ticket |   74.576 |
      |   6 | dan  | localhost | test | Query   |   11 | altering table | optimize table test_opened_ticket |   74.576 |
      |   6 | dan  | localhost | test | Query   |   11 | altering table | optimize table test_opened_ticket |   86.441 |
      |   6 | dan  | localhost | test | Query   |   11 | altering table | optimize table test_opened_ticket |   86.441 |
      |   6 | dan  | localhost | test | Query   |   11 | altering table | optimize table test_opened_ticket |   93.220 |
      |   6 | dan  | localhost | test | Query   |   11 | altering table | optimize table test_opened_ticket |   93.220 |
      |   6 | dan  | localhost | test | Query   |   11 | altering table | optimize table test_opened_ticket |   96.610 |
      |   6 | dan  | localhost | test | Query   |   11 | altering table | optimize table test_opened_ticket |   96.610 |
      |   6 | dan  | localhost | test | Query   |   11 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |   11 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |   12 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |   12 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |   12 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |   12 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |   12 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |   12 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |   12 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |   12 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |   12 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |   13 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |   13 | altering table | optimize table test_opened_ticket |   49.398 |
      |   6 | dan  | localhost | test | Query   |   13 | altering table | optimize table test_opened_ticket |   49.398 |
      |   6 | dan  | localhost | test | Query   |   13 | altering table | optimize table test_opened_ticket |   49.398 |
      |   6 | dan  | localhost | test | Query   |   13 | altering table | optimize table test_opened_ticket |   74.699 |
      |   6 | dan  | localhost | test | Query   |   13 | altering table | optimize table test_opened_ticket |   74.699 |
      |   6 | dan  | localhost | test | Query   |   13 | altering table | optimize table test_opened_ticket |   86.747 |
      |   6 | dan  | localhost | test | Query   |   13 | altering table | optimize table test_opened_ticket |   86.747 |
      |   6 | dan  | localhost | test | Query   |   13 | altering table | optimize table test_opened_ticket |   86.747 |
      |   6 | dan  | localhost | test | Query   |   13 | altering table | optimize table test_opened_ticket |   92.771 |
      |   6 | dan  | localhost | test | Query   |   14 | altering table | optimize table test_opened_ticket |   92.771 |
      |   6 | dan  | localhost | test | Query   |   14 | altering table | optimize table test_opened_ticket |   96.386 |
      |   6 | dan  | localhost | test | Query   |   14 | altering table | optimize table test_opened_ticket |   96.386 |
      |   6 | dan  | localhost | test | Query   |   14 | altering table | optimize table test_opened_ticket |   96.386 |
      |   6 | dan  | localhost | test | Query   |   14 | altering table | optimize table test_opened_ticket |   97.590 |
      |   6 | dan  | localhost | test | Query   |   14 | altering table | optimize table test_opened_ticket |   97.590 |
      |   6 | dan  | localhost | test | Query   |   14 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |   14 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |   14 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |   15 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |   15 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |   15 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |   15 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |   15 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |   15 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |   15 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |   15 | altering table | optimize table test_opened_ticket |    0.000 |
      |   6 | dan  | localhost | test | Query   |   15 | altering table | optimize table test_opened_ticket |    0.000 |
      

      Same observed on 10.3.38-MariaDB source revision c45630327c3477c24aea25692021bb7732e4a64a

      Attachments

        Activity

          People

            Unassigned Unassigned
            danblack Daniel Black
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.