[MDEV-25274] OPTIMIZE TABLE does not ignore read_only Created: 2021-03-26 Updated: 2023-04-27 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Data Definition - Alter Table |
| Affects Version/s: | 10.2.37, 10.3.28, 10.4.18, 10.5.9 |
| Fix Version/s: | 10.4, 10.5 |
| Type: | Bug | Priority: | Major |
| Reporter: | Geoff Montee (Inactive) | Assignee: | Nikita Malyavin |
| Resolution: | Unresolved | Votes: | 1 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Description |
|
If you try to run the OPTIMIZE TABLE statement while the read_only system variable is set, you see an error:
This contradicts the KB, which says that OPTIMIZE TABLE should ignore the read_only system variable:
https://mariadb.com/kb/en/read-only-replicas/ And this also contradicts the MySQL 5.6 documentation, which also says that OPTIMIZE TABLE should ignore the read_only system variable:
https://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_read_only |