[MDEV-18406] ALTER TABLE stage 2 reaches 131%, and never finishes from client side perspective Created: 2019-01-28 Updated: 2023-04-27 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Data Definition - Alter Table, Storage Engine - Aria |
| Affects Version/s: | 10.3.12 |
| Fix Version/s: | 10.4 |
| Type: | Bug | Priority: | Major |
| Reporter: | Thomas Graungaard | Assignee: | Michael Widenius |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | Aria | ||
| Environment: |
Windows 10 Pro x64 |
||
| Attachments: |
|
| Description |
|
Running
on a table created with ENGINE=Aria to rebuild index, will sometimes (I estimate 1 in 4 times) quickly run past 100% on second stage when seeing it from the client perspective. Server side the query will finish just fine, but client-side it appears to be stuck.
To better illustrate what happens a timeline: Never experienced the issue on 10.3.11 Edit:
CREATE TABLE `table_2` (
Happens on both of these tables |
| Comments |
| Comment by Elena Stepanova [ 2019-01-28 ] | ||
|
Could you please paste the output of
and attach your cnf file(s)? | ||
| Comment by Thomas Graungaard [ 2019-01-29 ] | ||
|
Updated description and attached my.ini | ||
| Comment by Thomas Graungaard [ 2019-02-08 ] | ||
|
Work-around for this issue is to change number of repair threads in my.ini to the standard 1
|