Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
10.2.9
Description
Concurrent DDL can cause xtrabackup to see the following error in MariaDB 10.2:
[FATAL] InnoDB: An optimized(without redo logging) DDLoperation has been performed. All modified pages may not have been flushed to the disk yet.
|
This problem is described here:
This also seems to effect xtrabackup-v2 SSTs. Should the SST script use the --lock-ddl-per-table option in 10.2 to avoid this?
Attachments
Issue Links
- relates to
-
MDEV-12116 Tables created during backup may be missed after restore
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Assignee | Andrii Nikitin [ anikitin ] |
| Link |
This issue relates to |
| Description |
Concurrent DDL can cause xtrabackup to see the following error in MariaDB 10.2:
{noformat} [FATAL] InnoDB: An optimized(without redo logging) DDLoperation has been performed. All modified pages may not have been flushed to the disk yet. {noformat} This problem is described here: https://www.percona.com/blog/2017/08/08/avoiding-the-an-optimized-without-redo-logging-ddloperation-has-been-performed-error-with-percona-xtrabackup/ This also seems to effect xtrabackup-v2 SSTs. Should the SST script use the --lock-ddl option in 10.2 to avoid this? |
Concurrent DDL can cause xtrabackup to see the following error in MariaDB 10.2:
{noformat} [FATAL] InnoDB: An optimized(without redo logging) DDLoperation has been performed. All modified pages may not have been flushed to the disk yet. {noformat} This problem is described here: https://www.percona.com/blog/2017/08/08/avoiding-the-an-optimized-without-redo-logging-ddloperation-has-been-performed-error-with-percona-xtrabackup/ This also seems to effect xtrabackup-v2 SSTs. Should the SST script use the --lock-ddl-per-table option in 10.2 to avoid this? |
| Fix Version/s | N/A [ 14700 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Resolution | Won't Do [ 10201 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 83087 ] | MariaDB v4 [ 153007 ] |
| Zendesk Related Tickets | 113927 |