Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4.18, 10.5.9, 10.6
-
None
Description
Some transactional backup can failed with Error 1412:Table definition has changed, thanks to the introduction of BACKUP STAGE MDEV-17309 this can be fix by introducing a new option
--lock-for-backup
that would for --single-transaction inject
BACKUP STAGE START;
BACKUP STAGE BLOCK_DDL;
START TRANSACTION WITH CONSISTENT SNAPSHOT;
Attachments
Issue Links
- includes
-
MDEV-25572 Improve compatibility of BACKUP STAGE with external tools
-
- Open
-
- is blocked by
-
MDEV-28367 BACKUP LOCKS on table to be accessible to those with database LOCK TABLES privileges
-
- Closed
-
- relates to
-
MDEV-28074 mysqldump --order-by-size
-
- Closed
-
As mentioned in https://github.com/MariaDB/server/pull/2054, when doing a limited backup maybe BACKUP LOCK tbl is sufficient.
monty is there a reason BACKUP LOCK tbls requires RELOAD privs? Would a table level privilege be sufficient? A SELECT statement in a transaction is sufficient to hold a metadata lock so couldn't that apply to {{BACKUP LOCK}}s too?