[MDEV-30533] progress on OPTIMIZE table resets itself 3 times during run (and finishes on 0) Created: 2023-02-01  Updated: 2023-09-19

Status: Open
Project: MariaDB Server
Component/s: Admin statements
Affects Version/s: 10.3.37, 10.11.2
Fix Version/s: 10.3

Type: Bug Priority: Major
Reporter: Daniel Black Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: Papercut


 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
Generated at Thu Feb 08 10:16:58 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.