[MDEV-30984] Online ALTER table is denied with non-informative error messages Created: 2023-04-01 Updated: 2023-08-16 Resolved: 2023-08-16 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Data Definition - Alter Table |
| Affects Version/s: | N/A |
| Fix Version/s: | 11.2.1 |
| Type: | Bug | Priority: | Critical |
| Reporter: | Elena Stepanova | Assignee: | Nikita Malyavin |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||||||||||
| Description |
|
serg wrote elsewhere:
So far this extra diagnostics has not been implemented, error messages still look the way they did before:
|
| Comments |
| Comment by Elena Stepanova [ 2023-04-01 ] | ||||||
|
It turns out that ALTER ONLINE TABLE is not the same online alter as online alter in | ||||||
| Comment by Elena Stepanova [ 2023-04-10 ] | ||||||
|
I think we do need better diagnostics. The error message for 1845 ER_ALTER_OPERATION_NOT_SUPPORTED, as in the description, is at least still correct, even if not very informative ("LOCK=NONE is not supported for this operation. Try ..."), but the more generic 1846 ER_ALTER_OPERATION_NOT_SUPPORTED_REASON is now plain wrong: "LOCK=NONE is not supported. Reason: COPY algorithm requires a lock. Try ...". That is, instead of referring to a specific operation, as 1845 does, this one claims that LOCK=NONE is not supported for the COPY algorithm at all, which is of course not true anymore. Besides, it can be very confusing, e.g. when you can do ALTER, but cannot do the same ALTER with IGNORE:
| ||||||
| Comment by Sergei Golubchik [ 2023-07-12 ] | ||||||
|
dc7136481bf5 looks ok |