Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Duplicate
-
10.2.16, 10.2.17
-
None
Description
It seems mariabackup, even with --lock-ddl-per-table option, can not create consistent backup when RENAME TABLE happens many times during the backup stage.
There is a simple test case for this. Start with new instance and add the following two tables:
openxs@ao756:~/dbs/maria10.2$ bin/mysql -uroot --socket=/tmp/mysql.sock test
|
Welcome to the MariaDB monitor. Commands end with ; or \g.
|
Your MariaDB connection id is 8
|
Server version: 10.2.17-MariaDB Source distribution
|
|
|
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
|
|
|
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
|
|
|
MariaDB [test]> show tables;
|
Empty set (0.00 sec)
|
|
|
MariaDB [test]> create table tbig(id int auto_increment, c1 char(200), c2 char(200), primary key(id)) engine=InnoDB;
|
Query OK, 0 rows affected (0.23 sec)
|
|
|
MariaDB [test]> insert into tbig(c1,c2) values ('a','b');
|
Query OK, 1 row affected (0.04 sec)
|
|
|
MariaDB [test]> insert into tbig(c1, c2) select repeat('a',200), repeat('b',200) from tbig, tbig t2, tbig t3, tbig t4;
|
Query OK, 1 row affected (0.05 sec)
|
Records: 1 Duplicates: 0 Warnings: 0
|
|
|
MariaDB [test]> insert into tbig(c1, c2) select repeat('a',200), repeat('b',200) from tbig, tbig t2, tbig t3, tbig t4;
|
Query OK, 16 rows affected (0.05 sec)
|
Records: 16 Duplicates: 0 Warnings: 0
|
|
|
MariaDB [test]> insert into tbig(c1, c2) select repeat('a',200), repeat('b',200) from tbig, tbig t2, tbig t3, tbig t4;
|
Query OK, 104976 rows affected (5.80 sec)
|
Records: 104976 Duplicates: 0 Warnings: 0
|
|
|
MariaDB [test]> insert into tbig(c1, c2) select repeat('a',200), repeat('b',200) from tbig;
|
Query OK, 104994 rows affected (5.94 sec)
|
Records: 104994 Duplicates: 0 Warnings: 0
|
|
|
MariaDB [test]> insert into tbig(c1, c2) select repeat('a',200), repeat('b',200) from tbig;
|
Query OK, 209988 rows affected (12.74 sec)
|
Records: 209988 Duplicates: 0 Warnings: 0
|
|
|
MariaDB [test]> insert into tbig(c1, c2) select repeat('a',200), repeat('b',200) from tbig;
|
Query OK, 419976 rows affected (28.18 sec)
|
Records: 419976 Duplicates: 0 Warnings: 0
|
|
|
MariaDB [test]> insert into tbig(c1, c2) select repeat('a',200), repeat('b',200) from tbig;
|
Query OK, 839952 rows affected (1 min 5.06 sec)
|
Records: 839952 Duplicates: 0 Warnings: 0
|
|
|
MariaDB [test]> show table status like 'tbig'\G
|
*************************** 1. row ***************************
|
Name: tbig
|
Engine: InnoDB
|
Version: 10
|
Row_format: Dynamic
|
Rows: 1594309
|
Avg_row_length: 464
|
Data_length: 740294656
|
Max_data_length: 0
|
Index_length: 0
|
Data_free: 4194304
|
Auto_increment: 1835014
|
Create_time: 2018-07-15 18:14:26
|
Update_time: 2018-07-15 18:32:40
|
Check_time: NULL
|
Collation: latin1_swedish_ci
|
Checksum: NULL
|
Create_options:
|
Comment:
|
1 row in set (0.00 sec)
|
|
|
MariaDB [test]> create table t(id int primary key, c1 int);
|
Query OK, 0 rows affected (0.21 sec)
|
|
|
MariaDB [test]> insert into t values(1,1),(2,2);
|
Query OK, 2 rows affected (0.04 sec)
|
Records: 2 Duplicates: 0 Warnings: 0
|
|
|
MariaDB [test]> show tables;
|
+----------------+
|
| Tables_in_test |
|
+----------------+
|
| t |
|
| tbig |
|
+----------------+
|
2 rows in set (0.00 sec)
|
|
|
MariaDB [test]> exit
|
Then in one shell window start the following loop of renaming tables:
openxs@ao756:~/dbs/maria10.2$ for i in {0..999}; do bin/mysql -e "use test; drop table if exists tmp_t${i}; create table tmp_t${i} like t; rename table t to zem_t${i}, tmp_t${i} to t; drop table zem_t${i};"; echo "${i}"; sleep 5; done;
|
While this loop runs (I let it execute at least once, but you can try whatever timing you prefer) try to run mariabackup with --lock-ddl-per-table option:
openxs@ao756: ~/dbs/maria10.2openxs@ao756:~/dbs/maria10.2$ bin/mariabackup -uroot --no-version-check --verbosee --backup --lock-ddl-per-table --target-dir=/home/openxs/backup --tmpdir=/home/openxs/backup
|
Backup completes with OK message. You may get concurrent statement killed if it's DDL involving t table. Let me share the log:
180715 19:28:10 Connecting to MySQL server host: localhost, user: root, password: not set, port: not set, socket: not set
|
Using server version 10.2.17-MariaDB
|
bin/mariabackup based on MariaDB server 10.2.17-MariaDB Linux (x86_64)
|
mariabackup: uses posix_fadvise().
|
mariabackup: cd to /home/openxs/dbs/maria10.2/data/
|
mariabackup: open files limit requested 0, set to 1024
|
mariabackup: using the following InnoDB configuration:
|
mariabackup: innodb_data_home_dir =
|
mariabackup: innodb_data_file_path = ibdata1:12M:autoextend
|
mariabackup: innodb_log_group_home_dir = ./
|
mariabackup: using O_DIRECT
|
2018-07-15 19:28:10 139901451954048 [Note] InnoDB: Number of pools: 1
|
mariabackup: Generating a list of tablespaces
|
2018-07-15 19:28:10 139901451954048 [Warning] InnoDB: Allocated tablespace ID 1 for mysql/innodb_table_stats, old maximum was 0
|
MLOG_CHECKPOINT(6455019076) ignored at 6455019085
|
180715 19:28:10 >> log scanned up to (6455019085)
|
180715 19:28:10 Connecting to MySQL server host: localhost, user: root, password: not set, port: not set, socket: not set
|
180715 19:28:10 Locking MDL for `mysql`.`innodb_table_stats`
|
180715 19:28:10 Locking MDL for `mysql`.`innodb_index_stats`
|
180715 19:28:10 Locking MDL for `mysql`.`gtid_slave_pos`
|
180715 19:28:10 Locking MDL for `test`.`t`
|
180715 19:28:10 Locking MDL for `test`.`tbig`
|
180715 19:28:10 [01] Copying ibdata1 to /home/openxs/backup/ibdata1
|
180715 19:28:11 >> log scanned up to (6455019085)
|
180715 19:28:12 >> log scanned up to (6455019085)
|
180715 19:28:13 [01] ...done
|
180715 19:28:13 [01] Copying ./mysql/innodb_table_stats.ibd to /home/openxs/backup/mysql/innodb_table_stats.ibd
|
180715 19:28:13 [01] ...done
|
180715 19:28:13 [01] Copying ./mysql/innodb_index_stats.ibd to /home/openxs/backup/mysql/innodb_index_stats.ibd
|
180715 19:28:13 [01] ...done
|
180715 19:28:13 [01] Copying ./mysql/gtid_slave_pos.ibd to /home/openxs/backup/mysql/gtid_slave_pos.ibd
|
180715 19:28:13 [01] ...done
|
180715 19:28:13 [01] Copying ./test/t.ibd to /home/openxs/backup/test/t.ibd
|
180715 19:28:13 [01] ...done
|
180715 19:28:13 [01] Copying ./test/tbig.ibd to /home/openxs/backup/test/tbig.ibd
|
180715 19:28:13 >> log scanned up to (6455019102)
|
180715 19:28:14 >> log scanned up to (6455022545)
|
180715 19:28:15 >> log scanned up to (6455023319)
|
180715 19:28:16 >> log scanned up to (6455023325)
|
180715 19:28:17 >> log scanned up to (6455023364)
|
MLOG_CHECKPOINT(6455023325) ignored at 6455023826
|
180715 19:28:18 >> log scanned up to (6455023826)
|
180715 19:28:19 >> log scanned up to (6455024194)
|
MLOG_CHECKPOINT(6455023364) ignored at 6455024423
|
180715 19:28:21 >> log scanned up to (6455024423)
|
180715 19:28:22 >> log scanned up to (6455024599)
|
MLOG_CHECKPOINT(6455024599) ignored at 6455025108
|
180715 19:28:23 >> log scanned up to (6455025108)
|
180715 19:28:24 >> log scanned up to (6455025298)
|
2018-07-15 19:28:25 139901381166848 [Note] InnoDB: Read redo log up to LSN=6455026688
|
MLOG_CHECKPOINT(6455025298) ignored at 6455026511
|
180715 19:28:25 >> log scanned up to (6455026511)
|
180715 19:28:26 >> log scanned up to (6455026511)
|
MLOG_CHECKPOINT(6455026511) ignored at 6455026520
|
180715 19:28:27 >> log scanned up to (6455026520)
|
180715 19:28:28 >> log scanned up to (6455026520)
|
180715 19:28:29 >> log scanned up to (6455026520)
|
180715 19:28:30 >> log scanned up to (6455026520)
|
180715 19:28:31 >> log scanned up to (6455026520)
|
180715 19:28:32 >> log scanned up to (6455026520)
|
180715 19:28:33 >> log scanned up to (6455026520)
|
180715 19:28:34 >> log scanned up to (6455026520)
|
180715 19:28:35 >> log scanned up to (6455026520)
|
180715 19:28:36 >> log scanned up to (6455026520)
|
180715 19:28:37 >> log scanned up to (6455026520)
|
180715 19:28:38 >> log scanned up to (6455026520)
|
180715 19:28:39 >> log scanned up to (6455026520)
|
180715 19:28:39 [01] ...done
|
180715 19:28:39 Executing FLUSH NO_WRITE_TO_BINLOG TABLES...
|
180715 19:28:39 Connecting to MySQL server host: localhost, user: root, password: not set, port: not set, socket: not set
|
180715 19:28:39 Killing MDL waiting Query ('rename table t to zem_t1, tmp_t1 to t') on connection 13
|
2018-07-15 19:28:40 139901381166848 [Note] InnoDB: Read redo log up to LSN=6455026688
|
180715 19:28:40 >> log scanned up to (6455026520)
|
180715 19:28:40 Executing FLUSH TABLES WITH READ LOCK...
|
180715 19:28:40 Kill mdl waiters thread stopped
|
180715 19:28:40 Starting to backup non-InnoDB tables and files
|
180715 19:28:40 [01] Copying ./mysql/time_zone.MYI to /home/openxs/backup/mysql/time_zone.MYI
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/func.MYI to /home/openxs/backup/mysql/func.MYI
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/procs_priv.frm to /home/openxs/backup/mysql/procs_priv.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/user.frm to /home/openxs/backup/mysql/user.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/host.frm to /home/openxs/backup/mysql/host.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/tables_priv.MYI to /home/openxs/backup/mysql/tables_priv.MYI
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/time_zone_transition.MYI to /home/openxs/backup/mysql/time_zone_transition.MYI
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/help_keyword.frm to /home/openxs/backup/mysql/help_keyword.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/innodb_table_stats.frm to /home/openxs/backup/mysql/innodb_table_stats.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/help_keyword.MYI to /home/openxs/backup/mysql/help_keyword.MYI
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/plugin.MYI to /home/openxs/backup/mysql/plugin.MYI
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/columns_priv.MYI to /home/openxs/backup/mysql/columns_priv.MYI
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/db.frm to /home/openxs/backup/mysql/db.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/help_relation.frm to /home/openxs/backup/mysql/help_relation.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/tables_priv.MYD to /home/openxs/backup/mysql/tables_priv.MYD
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/event.frm to /home/openxs/backup/mysql/event.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/columns_priv.frm to /home/openxs/backup/mysql/columns_priv.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/proc.MYI to /home/openxs/backup/mysql/proc.MYI
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/time_zone_transition.MYD to /home/openxs/backup/mysql/time_zone_transition.MYD
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/innodb_index_stats.frm to /home/openxs/backup/mysql/innodb_index_stats.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/columns_priv.MYD to /home/openxs/backup/mysql/columns_priv.MYD
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/time_zone_transition.frm to /home/openxs/backup/mysql/time_zone_transition.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/servers.MYI to /home/openxs/backup/mysql/servers.MYI
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/column_stats.MYI to /home/openxs/backup/mysql/column_stats.MYI
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/table_stats.frm to /home/openxs/backup/mysql/table_stats.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/proxies_priv.frm to /home/openxs/backup/mysql/proxies_priv.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/gtid_slave_pos.frm to /home/openxs/backup/mysql/gtid_slave_pos.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/time_zone_leap_second.frm to /home/openxs/backup/mysql/time_zone_leap_second.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/roles_mapping.MYD to /home/openxs/backup/mysql/roles_mapping.MYD
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/func.frm to /home/openxs/backup/mysql/func.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/host.MYD to /home/openxs/backup/mysql/host.MYD
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/general_log.CSM to /home/openxs/backup/mysql/general_log.CSM
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/slow_log.CSM to /home/openxs/backup/mysql/slow_log.CSM
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/time_zone_leap_second.MYD to /home/openxs/backup/mysql/time_zone_leap_second.MYD
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/slow_log.frm to /home/openxs/backup/mysql/slow_log.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/host.MYI to /home/openxs/backup/mysql/host.MYI
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/help_topic.frm to /home/openxs/backup/mysql/help_topic.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/help_topic.MYI to /home/openxs/backup/mysql/help_topic.MYI
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/time_zone_name.frm to /home/openxs/backup/mysql/time_zone_name.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/servers.MYD to /home/openxs/backup/mysql/servers.MYD
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/roles_mapping.frm to /home/openxs/backup/mysql/roles_mapping.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/user.MYI to /home/openxs/backup/mysql/user.MYI
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/plugin.MYD to /home/openxs/backup/mysql/plugin.MYD
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/general_log.frm to /home/openxs/backup/mysql/general_log.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/event.MYD to /home/openxs/backup/mysql/event.MYD
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/db.MYD to /home/openxs/backup/mysql/db.MYD
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/time_zone_name.MYD to /home/openxs/backup/mysql/time_zone_name.MYD
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/slow_log.CSV to /home/openxs/backup/mysql/slow_log.CSV
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/help_category.MYD to /home/openxs/backup/mysql/help_category.MYD
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/column_stats.MYD to /home/openxs/backup/mysql/column_stats.MYD
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/help_keyword.MYD to /home/openxs/backup/mysql/help_keyword.MYD
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/procs_priv.MYI to /home/openxs/backup/mysql/procs_priv.MYI
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/help_relation.MYI to /home/openxs/backup/mysql/help_relation.MYI
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/tables_priv.frm to /home/openxs/backup/mysql/tables_priv.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/proc.MYD to /home/openxs/backup/mysql/proc.MYD
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/index_stats.MYD to /home/openxs/backup/mysql/index_stats.MYD
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/table_stats.MYI to /home/openxs/backup/mysql/table_stats.MYI
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/time_zone_name.MYI to /home/openxs/backup/mysql/time_zone_name.MYI
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/general_log.CSV to /home/openxs/backup/mysql/general_log.CSV
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/index_stats.frm to /home/openxs/backup/mysql/index_stats.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/time_zone_transition_type.MYI to /home/openxs/backup/mysql/time_zone_transition_type.MYI
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/column_stats.frm to /home/openxs/backup/mysql/column_stats.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/plugin.frm to /home/openxs/backup/mysql/plugin.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/index_stats.MYI to /home/openxs/backup/mysql/index_stats.MYI
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/time_zone_leap_second.MYI to /home/openxs/backup/mysql/time_zone_leap_second.MYI
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/help_topic.MYD to /home/openxs/backup/mysql/help_topic.MYD
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/help_category.MYI to /home/openxs/backup/mysql/help_category.MYI
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/servers.frm to /home/openxs/backup/mysql/servers.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/event.MYI to /home/openxs/backup/mysql/event.MYI
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/proc.frm to /home/openxs/backup/mysql/proc.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/time_zone_transition_type.MYD to /home/openxs/backup/mysql/time_zone_transition_type.MYD
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/time_zone.frm to /home/openxs/backup/mysql/time_zone.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/help_category.frm to /home/openxs/backup/mysql/help_category.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/func.MYD to /home/openxs/backup/mysql/func.MYD
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/proxies_priv.MYD to /home/openxs/backup/mysql/proxies_priv.MYD
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/time_zone.MYD to /home/openxs/backup/mysql/time_zone.MYD
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/help_relation.MYD to /home/openxs/backup/mysql/help_relation.MYD
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/roles_mapping.MYI to /home/openxs/backup/mysql/roles_mapping.MYI
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/proxies_priv.MYI to /home/openxs/backup/mysql/proxies_priv.MYI
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/user.MYD to /home/openxs/backup/mysql/user.MYD
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/table_stats.MYD to /home/openxs/backup/mysql/table_stats.MYD
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/time_zone_transition_type.frm to /home/openxs/backup/mysql/time_zone_transition_type.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/procs_priv.MYD to /home/openxs/backup/mysql/procs_priv.MYD
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./mysql/db.MYI to /home/openxs/backup/mysql/db.MYI
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./test/tmp_t1.frm to /home/openxs/backup/test/tmp_t1.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./test/t.frm to /home/openxs/backup/test/t.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./test/tbig.frm to /home/openxs/backup/test/tbig.frm
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./test/db.opt to /home/openxs/backup/test/db.opt
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying ./performance_schema/db.opt to /home/openxs/backup/performance_schema/db.opt
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 Finished backing up non-InnoDB tables and files
|
180715 19:28:40 [01] Copying aria_log.00000001 to /home/openxs/backup/aria_log.00000001
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 [01] Copying aria_log_control to /home/openxs/backup/aria_log_control
|
180715 19:28:40 [01] ...done
|
180715 19:28:40 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
|
mariabackup: The latest check point (for incremental): '6455026511'
|
mariabackup: Stopping log copying thread.180715 19:28:40 >> log scanned up to (6455026520)
|
|
|
180715 19:28:40 >> log scanned up to (6455026520)
|
180715 19:28:40 Executing UNLOCK TABLES
|
180715 19:28:40 All tables unlocked
|
180715 19:28:40 Unlocking MDL for all tables
|
180715 19:28:40 [00] Copying ib_buffer_pool to /home/openxs/backup/ib_buffer_pool
|
180715 19:28:40 [00] ...done
|
180715 19:28:40 Backup created in directory '/home/openxs/backup/'
|
180715 19:28:40 [00] Writing backup-my.cnf
|
180715 19:28:40 [00] ...done
|
180715 19:28:40 [00] Writing xtrabackup_info
|
180715 19:28:40 [00] ...done
|
mariabackup: Redo log (from LSN 6455019076 to 6455026520) was copied.
|
180715 19:28:40 completed OK!
|
Stop rename loop as soon as backup completed:
openxs@ao756:~/dbs/maria10.2$ for i in {0..999}; do bin/mysql -e "use test; drop table if exists tmp_t${i}; create table tmp_t${i} like t; rename table t to zem_t${i}, tmp_t${i} to t; drop table zem_t${i};"; echo "${i}"; sleep 5; done;
|
0
|
1
|
^C
|
Note that you may get error for one of RENAME statements.
Then prepare the backup. Again, in all cases we get "completed OK!":
openxs@ao756: ~/dbs/maria10.2$ bin/mariabackup -uroot --verbose --no-version-check --prepare --target-dir=/home/openxs/backup
|
bin/mariabackup based on MariaDB server 10.2.17-MariaDB Linux (x86_64)
|
mariabackup: cd to /home/openxs/backup/
|
mariabackup: This target seems to be not prepared yet.
|
mariabackup: using the following InnoDB configuration for recovery:
|
mariabackup: innodb_data_home_dir = .
|
mariabackup: innodb_data_file_path = ibdata1:12M:autoextend
|
mariabackup: innodb_log_group_home_dir = .
|
mariabackup: Starting InnoDB instance for recovery.
|
mariabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
|
2018-07-15 19:29:21 139736077338496 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2018-07-15 19:29:21 139736077338496 [Note] InnoDB: Uses event mutexes
|
2018-07-15 19:29:21 139736077338496 [Note] InnoDB: Compressed tables use zlib 1.2.3
|
2018-07-15 19:29:21 139736077338496 [Note] InnoDB: Number of pools: 1
|
2018-07-15 19:29:21 139736077338496 [Note] InnoDB: Using SSE2 crc32 instructions
|
2018-07-15 19:29:21 139736077338496 [Note] InnoDB: Initializing buffer pool, total size = 100M, instances = 1, chunk size = 100M
|
2018-07-15 19:29:21 139736077338496 [Note] InnoDB: Completed initialization of buffer pool
|
2018-07-15 19:29:21 139735745947392 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
|
2018-07-15 19:29:21 139736077338496 [Note] InnoDB: Highest supported file format is Barracuda.
|
2018-07-15 19:29:21 139736077338496 [Note] InnoDB: Starting crash recovery from checkpoint LSN=6455019076
|
MLOG_CHECKPOINT(6455019076) read at 6455019085
|
MLOG_CHECKPOINT(6455019076) reread at 6455019085
|
MLOG_CHECKPOINT(6455023325) ignored at 6455023826
|
MLOG_CHECKPOINT(6455023364) ignored at 6455024423
|
MLOG_CHECKPOINT(6455024599) ignored at 6455025108
|
MLOG_CHECKPOINT(6455025298) ignored at 6455026511
|
MLOG_CHECKPOINT(6455026511) ignored at 6455026520
|
2018-07-15 19:29:21 139736077338496 [Warning] InnoDB: Tablespace 430 was not found at ./test/tmp_t1.ibd when restoring a (partial?) backup. All redo log for this file will be ignored!
|
2018-07-15 19:29:21 139736077338496 [Note] InnoDB: Starting final batch to recover 87 pages from redo log.
|
Applying log to page 0:0
|
apply 6455023576: 1 len 4 page 0:0
|
apply 6455023583: 1 len 4 page 0:0
|
apply 6455023590: 4 len 4 page 0:0
|
Applying log to page 2:3
|
apply 6455022823: 38 len 106 page 2:3
|
apply 6455023011: 38 len 129 page 2:3
|
apply 6455023193: 38 len 116 page 2:3
|
Applying log to page 1:3
|
apply 6455022616: 38 len 84 page 1:3
|
Applying log to page 0:7
|
apply 6455019085: 8 len 7 page 0:7
|
apply 6455019095: 4 len 4 page 0:7
|
apply 6455020125: 8 len 7 page 0:7
|
Applying log to page 0:8
|
apply 6455019719: 9 len 79 page 0:8
|
Applying log to page 0:9
|
apply 6455019801: 8 len 7 page 0:9
|
apply 6455019811: 9 len 33 page 0:9
|
Applying log to page 0:10
|
apply 6455019871: 9 len 39 page 0:10
|
apply 6455019936: 9 len 35 page 0:10
|
Applying log to page 0:11
|
apply 6455020162: 9 len 52 page 0:11
|
apply 6455022531: 4 len 3 page 0:11
|
apply 6455023319: 4 len 3 page 0:11
|
Applying log to page 0:12
|
apply 6455020240: 9 len 23 page 0:12
|
Applying log to page 0:1771
|
apply 6455022545: 24 len 5 page 0:1771
|
apply 6455022554: 2 len 4 page 0:1771
|
apply 6455022562: 2 len 4 page 0:1771
|
apply 6455022570: 2 len 4 page 0:1771
|
apply 6455022579: 20 len 17 page 0:1771
|
apply 6455022740: 2 len 3 page 0:1771
|
Applying log to page 0:420
|
apply 6455025384: 4 len 7 page 0:420
|
apply 6455025395: 2 len 3 page 0:420
|
Applying log to page 0:422
|
apply 6455023520: 2 len 3 page 0:422
|
Applying log to page 0:442
|
apply 6455019646: 24 len 5 page 0:442
|
apply 6455019655: 2 len 4 page 0:442
|
apply 6455019663: 2 len 4 page 0:442
|
apply 6455019671: 2 len 4 page 0:442
|
apply 6455019679: 1 len 3 page 0:442
|
apply 6455019686: 8 len 7 page 0:442
|
apply 6455019698: 20 len 17 page 0:442
|
apply 6455019848: 20 len 19 page 0:442
|
apply 6455019913: 20 len 19 page 0:442
|
apply 6455019974: 20 len 10 page 0:442
|
apply 6455020057: 20 len 10 page 0:442
|
apply 6455020135: 20 len 23 page 0:442
|
apply 6455020217: 20 len 19 page 0:442
|
apply 6455022538: 2 len 3 page 0:442
|
Applying log to page 0:443
|
apply 6455022747: 24 len 5 page 0:443
|
apply 6455022756: 2 len 4 page 0:443
|
apply 6455022764: 2 len 4 page 0:443
|
apply 6455022772: 2 len 4 page 0:443
|
apply 6455022781: 20 len 38 page 0:443
|
apply 6455022969: 20 len 38 page 0:443
|
apply 6455023159: 20 len 30 page 0:443
|
apply 6455023312: 2 len 3 page 0:443
|
Applying log to page 0:48
|
apply 6455023325: 4 len 7 page 0:48
|
apply 6455023335: 2 len 3 page 0:48
|
apply 6455023341: 4 len 7 page 0:48
|
apply 6455023351: 2 len 3 page 0:48
|
apply 6455023357: 4 len 3 page 0:48
|
Applying log to page 0:49
|
apply 6455023364: 4 len 7 page 0:49
|
apply 6455023374: 2 len 3 page 0:49
|
apply 6455023380: 4 len 7 page 0:49
|
apply 6455023390: 2 len 3 page 0:49
|
apply 6455023396: 4 len 3 page 0:49
|
Applying log to page 0:50
|
apply 6455023403: 4 len 7 page 0:50
|
apply 6455023413: 2 len 3 page 0:50
|
apply 6455023419: 4 len 7 page 0:50
|
apply 6455023429: 2 len 3 page 0:50
|
apply 6455023435: 4 len 3 page 0:50
|
Applying log to page 0:51
|
apply 6455023442: 4 len 7 page 0:51
|
apply 6455023452: 2 len 3 page 0:51
|
apply 6455023458: 4 len 7 page 0:51
|
apply 6455023468: 2 len 3 page 0:51
|
apply 6455023474: 4 len 3 page 0:51
|
Applying log to page 0:52
|
apply 6455023481: 4 len 7 page 0:52
|
apply 6455023491: 2 len 3 page 0:52
|
apply 6455023497: 4 len 7 page 0:52
|
apply 6455023507: 2 len 3 page 0:52
|
apply 6455023513: 4 len 3 page 0:52
|
Applying log to page 0:53
|
apply 6455023527: 4 len 7 page 0:53
|
apply 6455023537: 2 len 3 page 0:53
|
apply 6455023543: 4 len 7 page 0:53
|
apply 6455023553: 2 len 3 page 0:53
|
apply 6455023559: 4 len 3 page 0:53
|
apply 6455023635: 4 len 3 page 0:53
|
Applying log to page 0:62
|
apply 6455023642: 4 len 7 page 0:62
|
apply 6455023652: 2 len 3 page 0:62
|
apply 6455023658: 4 len 7 page 0:62
|
apply 6455023668: 2 len 3 page 0:62
|
apply 6455023674: 4 len 3 page 0:62
|
Applying log to page 0:63
|
apply 6455023681: 4 len 7 page 0:63
|
apply 6455023691: 2 len 3 page 0:63
|
apply 6455023697: 4 len 7 page 0:63
|
apply 6455023707: 2 len 3 page 0:63
|
apply 6455023713: 4 len 3 page 0:63
|
Applying log to page 0:193
|
apply 6455023826: 4 len 7 page 0:193
|
apply 6455023837: 2 len 3 page 0:193
|
apply 6455023844: 4 len 7 page 0:193
|
apply 6455023855: 2 len 3 page 0:193
|
apply 6455023862: 4 len 3 page 0:193
|
Applying log to page 0:194
|
apply 6455023870: 4 len 7 page 0:194
|
apply 6455023881: 2 len 3 page 0:194
|
apply 6455023888: 4 len 7 page 0:194
|
apply 6455023899: 2 len 3 page 0:194
|
apply 6455023906: 4 len 3 page 0:194
|
Applying log to page 0:256
|
apply 6455026370: 4 len 7 page 0:256
|
apply 6455026381: 2 len 3 page 0:256
|
apply 6455026388: 4 len 7 page 0:256
|
apply 6455026399: 2 len 3 page 0:256
|
apply 6455026406: 4 len 3 page 0:256
|
Applying log to page 0:257
|
apply 6455026414: 4 len 7 page 0:257
|
apply 6455026425: 2 len 3 page 0:257
|
apply 6455026432: 4 len 7 page 0:257
|
apply 6455026443: 2 len 3 page 0:257
|
apply 6455026450: 4 len 3 page 0:257
|
Applying log to page 0:258
|
apply 6455026458: 4 len 7 page 0:258
|
apply 6455026469: 2 len 3 page 0:258
|
apply 6455026476: 4 len 7 page 0:258
|
apply 6455026487: 2 len 3 page 0:258
|
apply 6455026494: 4 len 3 page 0:258
|
Applying log to page 0:196
|
apply 6455023914: 4 len 7 page 0:196
|
apply 6455023925: 2 len 3 page 0:196
|
apply 6455023932: 4 len 7 page 0:196
|
apply 6455023943: 2 len 3 page 0:196
|
apply 6455023950: 4 len 3 page 0:196
|
Applying log to page 0:197
|
apply 6455023958: 4 len 7 page 0:197
|
apply 6455023969: 2 len 3 page 0:197
|
apply 6455023976: 4 len 7 page 0:197
|
apply 6455023987: 2 len 3 page 0:197
|
apply 6455023994: 4 len 3 page 0:197
|
Applying log to page 0:198
|
apply 6455024002: 4 len 7 page 0:198
|
apply 6455024013: 2 len 3 page 0:198
|
apply 6455024020: 4 len 7 page 0:198
|
apply 6455024031: 2 len 3 page 0:198
|
apply 6455024038: 4 len 3 page 0:198
|
Applying log to page 0:199
|
apply 6455024046: 4 len 7 page 0:199
|
apply 6455024057: 2 len 3 page 0:199
|
apply 6455024064: 4 len 7 page 0:199
|
apply 6455024075: 2 len 3 page 0:199
|
apply 6455024082: 4 len 3 page 0:199
|
Applying log to page 0:200
|
apply 6455024090: 4 len 7 page 0:200
|
apply 6455024101: 2 len 3 page 0:200
|
apply 6455024108: 4 len 7 page 0:200
|
apply 6455024119: 2 len 3 page 0:200
|
apply 6455024142: 4 len 3 page 0:200
|
Applying log to page 0:201
|
apply 6455024150: 4 len 7 page 0:201
|
apply 6455024161: 2 len 3 page 0:201
|
apply 6455024168: 4 len 7 page 0:201
|
apply 6455024179: 2 len 3 page 0:201
|
apply 6455024186: 4 len 3 page 0:201
|
Applying log to page 0:202
|
apply 6455024194: 4 len 7 page 0:202
|
apply 6455024205: 2 len 3 page 0:202
|
apply 6455024212: 4 len 7 page 0:202
|
apply 6455024223: 2 len 3 page 0:202
|
apply 6455024230: 4 len 3 page 0:202
|
Applying log to page 0:209
|
apply 6455024238: 4 len 7 page 0:209
|
apply 6455024249: 2 len 3 page 0:209
|
apply 6455024256: 4 len 7 page 0:209
|
apply 6455024267: 2 len 3 page 0:209
|
apply 6455024274: 4 len 3 page 0:209
|
Applying log to page 0:210
|
apply 6455024282: 4 len 7 page 0:210
|
apply 6455024293: 2 len 3 page 0:210
|
apply 6455024300: 4 len 7 page 0:210
|
apply 6455024311: 2 len 3 page 0:210
|
apply 6455024318: 4 len 3 page 0:210
|
Applying log to page 0:213
|
apply 6455024326: 4 len 7 page 0:213
|
apply 6455024337: 2 len 3 page 0:213
|
apply 6455024344: 4 len 7 page 0:213
|
apply 6455024355: 2 len 3 page 0:213
|
apply 6455024362: 4 len 3 page 0:213
|
Applying log to page 0:214
|
apply 6455024370: 4 len 7 page 0:214
|
apply 6455024381: 2 len 3 page 0:214
|
apply 6455024388: 4 len 7 page 0:214
|
apply 6455024399: 2 len 3 page 0:214
|
apply 6455024406: 4 len 3 page 0:214
|
Applying log to page 0:307
|
apply 6455019988: 9 len 49 page 0:307
|
Applying log to page 0:308
|
apply 6455020071: 9 len 50 page 0:308
|
Applying log to page 0:216
|
apply 6455024423: 4 len 7 page 0:216
|
apply 6455024434: 2 len 3 page 0:216
|
apply 6455024441: 4 len 7 page 0:216
|
apply 6455024452: 2 len 3 page 0:216
|
apply 6455024459: 4 len 3 page 0:216
|
Applying log to page 0:217
|
apply 6455024467: 4 len 7 page 0:217
|
apply 6455024478: 2 len 3 page 0:217
|
apply 6455024485: 4 len 7 page 0:217
|
apply 6455024496: 2 len 3 page 0:217
|
apply 6455024503: 4 len 3 page 0:217
|
Applying log to page 0:218
|
apply 6455024511: 4 len 7 page 0:218
|
apply 6455024522: 2 len 3 page 0:218
|
apply 6455024529: 4 len 7 page 0:218
|
apply 6455024540: 2 len 3 page 0:218
|
apply 6455024547: 4 len 3 page 0:218
|
Applying log to page 0:219
|
apply 6455024555: 4 len 7 page 0:219
|
apply 6455024566: 2 len 3 page 0:219
|
apply 6455024573: 4 len 7 page 0:219
|
apply 6455024584: 2 len 3 page 0:219
|
apply 6455024591: 4 len 3 page 0:219
|
Applying log to page 0:221
|
apply 6455024599: 4 len 7 page 0:221
|
apply 6455024610: 2 len 3 page 0:221
|
apply 6455024617: 4 len 7 page 0:221
|
apply 6455024628: 2 len 3 page 0:221
|
apply 6455024635: 4 len 3 page 0:221
|
Applying log to page 0:224
|
apply 6455024747: 4 len 7 page 0:224
|
apply 6455024758: 2 len 3 page 0:224
|
apply 6455024765: 4 len 7 page 0:224
|
apply 6455024776: 2 len 3 page 0:224
|
apply 6455024783: 4 len 3 page 0:224
|
Applying log to page 0:222
|
apply 6455024659: 4 len 7 page 0:222
|
apply 6455024670: 2 len 3 page 0:222
|
apply 6455024677: 4 len 7 page 0:222
|
apply 6455024688: 2 len 3 page 0:222
|
apply 6455024695: 4 len 3 page 0:222
|
Applying log to page 0:223
|
apply 6455024703: 4 len 7 page 0:223
|
apply 6455024714: 2 len 3 page 0:223
|
apply 6455024721: 4 len 7 page 0:223
|
apply 6455024732: 2 len 3 page 0:223
|
apply 6455024739: 4 len 3 page 0:223
|
Applying log to page 0:226
|
apply 6455024791: 4 len 7 page 0:226
|
apply 6455024802: 2 len 3 page 0:226
|
apply 6455024809: 4 len 7 page 0:226
|
apply 6455024820: 2 len 3 page 0:226
|
apply 6455024827: 4 len 3 page 0:226
|
Applying log to page 0:227
|
apply 6455024835: 4 len 7 page 0:227
|
apply 6455024846: 2 len 3 page 0:227
|
apply 6455024853: 4 len 7 page 0:227
|
apply 6455024864: 2 len 3 page 0:227
|
apply 6455024871: 4 len 3 page 0:227
|
Applying log to page 0:316
|
apply 6455023565: 4 len 7 page 0:316
|
apply 6455023597: 8 len 7 page 0:316
|
apply 6455023608: 4 len 7 page 0:316
|
Applying log to page 0:228
|
apply 6455024879: 4 len 7 page 0:228
|
apply 6455024890: 2 len 3 page 0:228
|
apply 6455024897: 4 len 7 page 0:228
|
apply 6455024908: 2 len 3 page 0:228
|
apply 6455024915: 4 len 3 page 0:228
|
Applying log to page 0:229
|
apply 6455024923: 4 len 7 page 0:229
|
apply 6455024934: 2 len 3 page 0:229
|
apply 6455024941: 4 len 7 page 0:229
|
apply 6455024952: 2 len 3 page 0:229
|
apply 6455024959: 4 len 3 page 0:229
|
Applying log to page 0:231
|
apply 6455024967: 4 len 7 page 0:231
|
apply 6455024978: 2 len 3 page 0:231
|
apply 6455024985: 4 len 7 page 0:231
|
apply 6455024996: 2 len 3 page 0:231
|
apply 6455025003: 4 len 3 page 0:231
|
Applying log to page 0:232
|
apply 6455025011: 4 len 7 page 0:232
|
apply 6455025022: 2 len 3 page 0:232
|
apply 6455025029: 4 len 7 page 0:232
|
apply 6455025040: 2 len 3 page 0:232
|
apply 6455025047: 4 len 3 page 0:232
|
Applying log to page 0:233
|
apply 6455025055: 4 len 7 page 0:233
|
apply 6455025066: 2 len 3 page 0:233
|
apply 6455025073: 4 len 7 page 0:233
|
apply 6455025084: 2 len 3 page 0:233
|
apply 6455025091: 4 len 3 page 0:233
|
Applying log to page 0:234
|
apply 6455025108: 4 len 7 page 0:234
|
apply 6455025119: 2 len 3 page 0:234
|
apply 6455025126: 4 len 7 page 0:234
|
apply 6455025137: 2 len 3 page 0:234
|
apply 6455025144: 4 len 3 page 0:234
|
Applying log to page 0:235
|
apply 6455025168: 4 len 7 page 0:235
|
apply 6455025179: 2 len 3 page 0:235
|
apply 6455025186: 4 len 7 page 0:235
|
apply 6455025197: 2 len 3 page 0:235
|
apply 6455025204: 4 len 3 page 0:235
|
Applying log to page 0:236
|
apply 6455025230: 4 len 4 page 0:236
|
apply 6455025238: 2 len 4 page 0:236
|
apply 6455025246: 4 len 3 page 0:236
|
apply 6455025254: 4 len 7 page 0:236
|
apply 6455025265: 2 len 3 page 0:236
|
apply 6455025272: 4 len 7 page 0:236
|
apply 6455025283: 2 len 3 page 0:236
|
apply 6455025290: 4 len 3 page 0:236
|
Applying log to page 0:237
|
apply 6455025316: 4 len 4 page 0:237
|
apply 6455025324: 2 len 4 page 0:237
|
apply 6455025332: 4 len 3 page 0:237
|
apply 6455025340: 4 len 7 page 0:237
|
apply 6455025351: 2 len 3 page 0:237
|
apply 6455025358: 4 len 7 page 0:237
|
apply 6455025369: 2 len 3 page 0:237
|
apply 6455025376: 4 len 3 page 0:237
|
Applying log to page 0:238
|
apply 6455025402: 4 len 4 page 0:238
|
apply 6455025410: 2 len 4 page 0:238
|
apply 6455025418: 4 len 3 page 0:238
|
apply 6455025426: 4 len 7 page 0:238
|
apply 6455025437: 2 len 3 page 0:238
|
apply 6455025444: 4 len 7 page 0:238
|
apply 6455025455: 2 len 3 page 0:238
|
apply 6455025462: 4 len 3 page 0:238
|
Applying log to page 0:239
|
apply 6455025470: 4 len 7 page 0:239
|
apply 6455025481: 2 len 3 page 0:239
|
apply 6455025488: 4 len 7 page 0:239
|
apply 6455025499: 2 len 3 page 0:239
|
apply 6455025506: 4 len 3 page 0:239
|
Applying log to page 0:240
|
apply 6455025514: 4 len 7 page 0:240
|
apply 6455025525: 2 len 3 page 0:240
|
apply 6455025532: 4 len 7 page 0:240
|
apply 6455025543: 2 len 3 page 0:240
|
apply 6455025550: 4 len 3 page 0:240
|
Applying log to page 0:241
|
apply 6455025558: 4 len 7 page 0:241
|
apply 6455025569: 2 len 3 page 0:241
|
apply 6455025576: 4 len 7 page 0:241
|
apply 6455025587: 2 len 3 page 0:241
|
apply 6455025594: 4 len 3 page 0:241
|
Applying log to page 0:245
|
apply 6455025602: 4 len 7 page 0:245
|
apply 6455025613: 2 len 3 page 0:245
|
apply 6455025620: 4 len 7 page 0:245
|
apply 6455025631: 2 len 3 page 0:245
|
apply 6455025638: 4 len 3 page 0:245
|
Applying log to page 0:246
|
apply 6455025646: 4 len 7 page 0:246
|
apply 6455025657: 2 len 3 page 0:246
|
apply 6455025680: 4 len 7 page 0:246
|
apply 6455025691: 2 len 3 page 0:246
|
apply 6455025698: 4 len 3 page 0:246
|
Applying log to page 0:247
|
apply 6455025706: 4 len 7 page 0:247
|
apply 6455025717: 2 len 3 page 0:247
|
apply 6455025724: 4 len 7 page 0:247
|
apply 6455025735: 2 len 3 page 0:247
|
apply 6455025742: 4 len 3 page 0:247
|
Applying log to page 0:248
|
apply 6455025750: 4 len 7 page 0:248
|
apply 6455025761: 2 len 3 page 0:248
|
apply 6455025768: 4 len 7 page 0:248
|
apply 6455025779: 2 len 3 page 0:248
|
apply 6455025786: 4 len 3 page 0:248
|
Applying log to page 0:249
|
apply 6455025794: 4 len 7 page 0:249
|
apply 6455025805: 2 len 3 page 0:249
|
apply 6455025812: 4 len 7 page 0:249
|
apply 6455025823: 2 len 3 page 0:249
|
apply 6455025830: 4 len 3 page 0:249
|
Applying log to page 0:250
|
apply 6455025856: 4 len 4 page 0:250
|
apply 6455025864: 2 len 4 page 0:250
|
apply 6455025872: 4 len 3 page 0:250
|
apply 6455025880: 4 len 7 page 0:250
|
apply 6455025891: 2 len 3 page 0:250
|
apply 6455025898: 4 len 7 page 0:250
|
apply 6455025909: 2 len 3 page 0:250
|
apply 6455025916: 4 len 3 page 0:250
|
Applying log to page 0:251
|
apply 6455025942: 4 len 4 page 0:251
|
apply 6455025950: 2 len 4 page 0:251
|
apply 6455025958: 4 len 3 page 0:251
|
apply 6455025966: 4 len 7 page 0:251
|
apply 6455025977: 2 len 3 page 0:251
|
apply 6455025984: 4 len 7 page 0:251
|
apply 6455025995: 2 len 3 page 0:251
|
apply 6455026002: 4 len 3 page 0:251
|
Applying log to page 0:252
|
apply 6455026028: 4 len 4 page 0:252
|
apply 6455026036: 2 len 4 page 0:252
|
apply 6455026044: 4 len 3 page 0:252
|
apply 6455026052: 4 len 7 page 0:252
|
apply 6455026063: 2 len 3 page 0:252
|
apply 6455026070: 4 len 7 page 0:252
|
apply 6455026081: 2 len 3 page 0:252
|
apply 6455026088: 4 len 3 page 0:252
|
Applying log to page 0:253
|
apply 6455026114: 4 len 4 page 0:253
|
apply 6455026122: 2 len 4 page 0:253
|
apply 6455026130: 4 len 3 page 0:253
|
apply 6455026138: 4 len 7 page 0:253
|
apply 6455026149: 2 len 3 page 0:253
|
apply 6455026156: 4 len 7 page 0:253
|
apply 6455026167: 2 len 3 page 0:253
|
apply 6455026190: 4 len 3 page 0:253
|
Applying log to page 0:254
|
apply 6455026216: 4 len 4 page 0:254
|
apply 6455026224: 2 len 4 page 0:254
|
apply 6455026232: 4 len 3 page 0:254
|
apply 6455026240: 4 len 7 page 0:254
|
apply 6455026251: 2 len 3 page 0:254
|
apply 6455026258: 4 len 7 page 0:254
|
apply 6455026269: 2 len 3 page 0:254
|
apply 6455026276: 4 len 3 page 0:254
|
Applying log to page 0:255
|
apply 6455026302: 4 len 4 page 0:255
|
apply 6455026310: 2 len 4 page 0:255
|
apply 6455026318: 4 len 3 page 0:255
|
apply 6455026326: 4 len 7 page 0:255
|
apply 6455026337: 2 len 3 page 0:255
|
apply 6455026344: 4 len 7 page 0:255
|
apply 6455026355: 2 len 3 page 0:255
|
apply 6455026362: 4 len 3 page 0:255
|
Applying log to page 0:518
|
apply 6455026096: 4 len 7 page 0:518
|
apply 6455026107: 2 len 3 page 0:518
|
Applying log to page 0:553
|
apply 6455025298: 4 len 7 page 0:553
|
apply 6455025309: 2 len 3 page 0:553
|
Applying log to page 0:555
|
apply 6455026198: 4 len 7 page 0:555
|
apply 6455026209: 2 len 3 page 0:555
|
Applying log to page 0:465
|
apply 6455026284: 4 len 7 page 0:465
|
apply 6455026295: 2 len 3 page 0:465
|
Applying log to page 0:774
|
apply 6455025212: 4 len 7 page 0:774
|
apply 6455025223: 2 len 3 page 0:774
|
Applying log to page 0:487
|
apply 6455025924: 4 len 7 page 0:487
|
apply 6455025935: 2 len 3 page 0:487
|
Applying log to page 0:1784
|
apply 6455025838: 4 len 7 page 0:1784
|
apply 6455025849: 2 len 3 page 0:1784
|
Applying log to page 0:1785
|
apply 6455026010: 4 len 7 page 0:1785
|
apply 6455026021: 2 len 3 page 0:1785
|
180715 19:29:22 completed OK!
|
Then stop MariaDB server, remove the content of the datadir and apply --move-back:
openxs@ao756: ~/dbs/maria10.2$ rm -rf ~/backup
|
openxs@ao756: bin/mariabackup --no-defaults -uroot --no-version-ccheck --verbose --datadir=/home/openxs/dbs/maria10.2/data --target-dir=/home/opennxs/backup --move-back
|
bin/mariabackup based on MariaDB server 10.2.17-MariaDB Linux (x86_64)
|
180715 19:29:47 [01] Moving ibdata1 to /home/openxs/dbs/maria10.2/data/ibdata1
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/time_zone.MYI to /home/openxs/dbs/maria10.2/data/mysql/time_zone.MYI
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/func.MYI to /home/openxs/dbs/maria10.2/data/mysql/func.MYI
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/procs_priv.frm to /home/openxs/dbs/maria10.2/data/mysql/procs_priv.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/user.frm to /home/openxs/dbs/maria10.2/data/mysql/user.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/host.frm to /home/openxs/dbs/maria10.2/data/mysql/host.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/tables_priv.MYI to /home/openxs/dbs/maria10.2/data/mysql/tables_priv.MYI
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/innodb_table_stats.ibd to /home/openxs/dbs/maria10.2/data/mysql/innodb_table_stats.ibd
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/time_zone_transition.MYI to /home/openxs/dbs/maria10.2/data/mysql/time_zone_transition.MYI
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/help_keyword.frm to /home/openxs/dbs/maria10.2/data/mysql/help_keyword.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/innodb_table_stats.frm to /home/openxs/dbs/maria10.2/data/mysql/innodb_table_stats.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/help_keyword.MYI to /home/openxs/dbs/maria10.2/data/mysql/help_keyword.MYI
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/plugin.MYI to /home/openxs/dbs/maria10.2/data/mysql/plugin.MYI
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/columns_priv.MYI to /home/openxs/dbs/maria10.2/data/mysql/columns_priv.MYI
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/db.frm to /home/openxs/dbs/maria10.2/data/mysql/db.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/help_relation.frm to /home/openxs/dbs/maria10.2/data/mysql/help_relation.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/tables_priv.MYD to /home/openxs/dbs/maria10.2/data/mysql/tables_priv.MYD
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/event.frm to /home/openxs/dbs/maria10.2/data/mysql/event.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/columns_priv.frm to /home/openxs/dbs/maria10.2/data/mysql/columns_priv.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/proc.MYI to /home/openxs/dbs/maria10.2/data/mysql/proc.MYI
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/time_zone_transition.MYD to /home/openxs/dbs/maria10.2/data/mysql/time_zone_transition.MYD
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/innodb_index_stats.frm to /home/openxs/dbs/maria10.2/data/mysql/innodb_index_stats.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/columns_priv.MYD to /home/openxs/dbs/maria10.2/data/mysql/columns_priv.MYD
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/time_zone_transition.frm to /home/openxs/dbs/maria10.2/data/mysql/time_zone_transition.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/servers.MYI to /home/openxs/dbs/maria10.2/data/mysql/servers.MYI
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/column_stats.MYI to /home/openxs/dbs/maria10.2/data/mysql/column_stats.MYI
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/table_stats.frm to /home/openxs/dbs/maria10.2/data/mysql/table_stats.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/proxies_priv.frm to /home/openxs/dbs/maria10.2/data/mysql/proxies_priv.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/gtid_slave_pos.frm to /home/openxs/dbs/maria10.2/data/mysql/gtid_slave_pos.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/time_zone_leap_second.frm to /home/openxs/dbs/maria10.2/data/mysql/time_zone_leap_second.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/roles_mapping.MYD to /home/openxs/dbs/maria10.2/data/mysql/roles_mapping.MYD
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/func.frm to /home/openxs/dbs/maria10.2/data/mysql/func.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/host.MYD to /home/openxs/dbs/maria10.2/data/mysql/host.MYD
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/general_log.CSM to /home/openxs/dbs/maria10.2/data/mysql/general_log.CSM
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/slow_log.CSM to /home/openxs/dbs/maria10.2/data/mysql/slow_log.CSM
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/time_zone_leap_second.MYD to /home/openxs/dbs/maria10.2/data/mysql/time_zone_leap_second.MYD
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/slow_log.frm to /home/openxs/dbs/maria10.2/data/mysql/slow_log.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/host.MYI to /home/openxs/dbs/maria10.2/data/mysql/host.MYI
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/help_topic.frm to /home/openxs/dbs/maria10.2/data/mysql/help_topic.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/innodb_index_stats.ibd to /home/openxs/dbs/maria10.2/data/mysql/innodb_index_stats.ibd
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/help_topic.MYI to /home/openxs/dbs/maria10.2/data/mysql/help_topic.MYI
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/time_zone_name.frm to /home/openxs/dbs/maria10.2/data/mysql/time_zone_name.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/servers.MYD to /home/openxs/dbs/maria10.2/data/mysql/servers.MYD
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/roles_mapping.frm to /home/openxs/dbs/maria10.2/data/mysql/roles_mapping.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/user.MYI to /home/openxs/dbs/maria10.2/data/mysql/user.MYI
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/plugin.MYD to /home/openxs/dbs/maria10.2/data/mysql/plugin.MYD
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/general_log.frm to /home/openxs/dbs/maria10.2/data/mysql/general_log.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/event.MYD to /home/openxs/dbs/maria10.2/data/mysql/event.MYD
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/db.MYD to /home/openxs/dbs/maria10.2/data/mysql/db.MYD
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/time_zone_name.MYD to /home/openxs/dbs/maria10.2/data/mysql/time_zone_name.MYD
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/slow_log.CSV to /home/openxs/dbs/maria10.2/data/mysql/slow_log.CSV
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/help_category.MYD to /home/openxs/dbs/maria10.2/data/mysql/help_category.MYD
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/column_stats.MYD to /home/openxs/dbs/maria10.2/data/mysql/column_stats.MYD
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/help_keyword.MYD to /home/openxs/dbs/maria10.2/data/mysql/help_keyword.MYD
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/procs_priv.MYI to /home/openxs/dbs/maria10.2/data/mysql/procs_priv.MYI
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/help_relation.MYI to /home/openxs/dbs/maria10.2/data/mysql/help_relation.MYI
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/gtid_slave_pos.ibd to /home/openxs/dbs/maria10.2/data/mysql/gtid_slave_pos.ibd
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/tables_priv.frm to /home/openxs/dbs/maria10.2/data/mysql/tables_priv.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/proc.MYD to /home/openxs/dbs/maria10.2/data/mysql/proc.MYD
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/index_stats.MYD to /home/openxs/dbs/maria10.2/data/mysql/index_stats.MYD
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/table_stats.MYI to /home/openxs/dbs/maria10.2/data/mysql/table_stats.MYI
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/time_zone_name.MYI to /home/openxs/dbs/maria10.2/data/mysql/time_zone_name.MYI
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/general_log.CSV to /home/openxs/dbs/maria10.2/data/mysql/general_log.CSV
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/index_stats.frm to /home/openxs/dbs/maria10.2/data/mysql/index_stats.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/time_zone_transition_type.MYI to /home/openxs/dbs/maria10.2/data/mysql/time_zone_transition_type.MYI
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/column_stats.frm to /home/openxs/dbs/maria10.2/data/mysql/column_stats.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/plugin.frm to /home/openxs/dbs/maria10.2/data/mysql/plugin.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/index_stats.MYI to /home/openxs/dbs/maria10.2/data/mysql/index_stats.MYI
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/time_zone_leap_second.MYI to /home/openxs/dbs/maria10.2/data/mysql/time_zone_leap_second.MYI
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/help_topic.MYD to /home/openxs/dbs/maria10.2/data/mysql/help_topic.MYD
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/help_category.MYI to /home/openxs/dbs/maria10.2/data/mysql/help_category.MYI
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/servers.frm to /home/openxs/dbs/maria10.2/data/mysql/servers.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/event.MYI to /home/openxs/dbs/maria10.2/data/mysql/event.MYI
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/proc.frm to /home/openxs/dbs/maria10.2/data/mysql/proc.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/time_zone_transition_type.MYD to /home/openxs/dbs/maria10.2/data/mysql/time_zone_transition_type.MYD
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/time_zone.frm to /home/openxs/dbs/maria10.2/data/mysql/time_zone.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/help_category.frm to /home/openxs/dbs/maria10.2/data/mysql/help_category.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/func.MYD to /home/openxs/dbs/maria10.2/data/mysql/func.MYD
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/proxies_priv.MYD to /home/openxs/dbs/maria10.2/data/mysql/proxies_priv.MYD
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/time_zone.MYD to /home/openxs/dbs/maria10.2/data/mysql/time_zone.MYD
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/help_relation.MYD to /home/openxs/dbs/maria10.2/data/mysql/help_relation.MYD
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/roles_mapping.MYI to /home/openxs/dbs/maria10.2/data/mysql/roles_mapping.MYI
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/proxies_priv.MYI to /home/openxs/dbs/maria10.2/data/mysql/proxies_priv.MYI
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/user.MYD to /home/openxs/dbs/maria10.2/data/mysql/user.MYD
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/table_stats.MYD to /home/openxs/dbs/maria10.2/data/mysql/table_stats.MYD
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/time_zone_transition_type.frm to /home/openxs/dbs/maria10.2/data/mysql/time_zone_transition_type.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/procs_priv.MYD to /home/openxs/dbs/maria10.2/data/mysql/procs_priv.MYD
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./mysql/db.MYI to /home/openxs/dbs/maria10.2/data/mysql/db.MYI
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./aria_log.00000001 to /home/openxs/dbs/maria10.2/data/aria_log.00000001
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./test/tmp_t1.frm to /home/openxs/dbs/maria10.2/data/test/tmp_t1.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./test/t.frm to /home/openxs/dbs/maria10.2/data/test/t.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./test/tbig.frm to /home/openxs/dbs/maria10.2/data/test/tbig.frm
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./test/t.ibd to /home/openxs/dbs/maria10.2/data/test/t.ibd
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./test/tbig.ibd to /home/openxs/dbs/maria10.2/data/test/tbig.ibd
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./test/db.opt to /home/openxs/dbs/maria10.2/data/test/db.opt
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./aria_log_control to /home/openxs/dbs/maria10.2/data/aria_log_control
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./xtrabackup_info to /home/openxs/dbs/maria10.2/data/xtrabackup_info
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./performance_schema/db.opt to /home/openxs/dbs/maria10.2/data/performance_schema/db.opt
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 [01] Moving ./ib_buffer_pool to /home/openxs/dbs/maria10.2/data/ib_buffer_pool
|
180715 19:29:47 [01] ...done
|
180715 19:29:47 completed OK!
|
Now, if you start server with the datadir content restored from the backup, maybe depending on time to start the loop vs backup process, you can get the following outcome:
Some table tmp_t{$i} exists and can not be accessed.
openxs@ao756:~/dbs/maria10.2$ bin/mysql -uroot --socket=/tmp/mysql.sock test
|
Reading table information for completion of table and column names
|
You can turn off this feature to get a quicker startup with -A
|
|
|
Welcome to the MariaDB monitor. Commands end with ; or \g.
|
Your MariaDB connection id is 9
|
Server version: 10.2.17-MariaDB Source distribution
|
|
|
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
|
|
|
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
|
|
|
MariaDB [test]> show tables;
|
+----------------+
|
| Tables_in_test |
|
+----------------+
|
| t |
|
| tbig |
|
| tmp_t1 |
|
+----------------+
|
3 rows in set (0.00 sec)
|
|
|
MariaDB [test]> select count(*) from tmp_t1;
|
ERROR 1932 (42S02): Table 'test.tmp_t1' doesn't exist in engine
|
In this case in the error log we see the following:
Version: '10.2.17-MariaDB' socket: '/tmp/mysql.sock' port: 3306 Source distribution
|
2018-07-15 19:30:01 139688247625472 [ERROR] InnoDB: Failed to find tablespace for table `test`.`tmp_t1` in the cache. Attempting to load the tablespace with space id 430
|
2018-07-15 19:30:01 139688247625472 [ERROR] InnoDB: Operating system error number 2 in a file operation.
|
2018-07-15 19:30:01 139688247625472 [ERROR] InnoDB: The error means the system cannot find the path specified.
|
2018-07-15 19:30:01 139688247625472 [ERROR] InnoDB: Cannot open datafile for read-only: './test/tmp_t1.ibd' OS error: 71
|
2018-07-15 19:30:01 139688247625472 [ERROR] InnoDB: Operating system error number 2 in a file operation.
|
2018-07-15 19:30:01 139688247625472 [ERROR] InnoDB: The error means the system cannot find the path specified.
|
2018-07-15 19:30:01 139688247625472 [ERROR] InnoDB: Could not find a valid tablespace file for `test/tmp_t1`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
|
MDL lock can not protect the table that had not existed at the moment when MDL locks were set.
The original instance we do not have these problems after we stop rename loop at any stage.
I've used MariaDB 10.2.17 built from current source for my tests (this way I get som,e xtra diagnostic outputs for --prepare stage, for example):
openxs@ao756:~/git/server$ git branch
|
10.0
|
10.1
|
* 10.2
|
10.3
|
openxs@ao756:~/git/server$ git log -1
|
commit 1cc1d0429da14a041a6240c6fce17e0d31cad8e2
|
Author: Marko Mцєkelцє <marko.makela@mariadb.com>
|
Date: Sat Jul 7 11:34:26 2018 +0300
|
|
|
MDEV-16664: Change the default to innodb_lock_schedule_algorithm=fcfs
|
|
|
The parameter innodb_lock_schedule_algorithm was introduced in
|
MariaDB Server 10.1.19, 10.2.13, 10.3.4 as part of MDEV-11039.
|
In MariaDB 10.1, the default value of the parameter is 'fcfs',
|
that is, the existing algorithm is used by default. But in
|
later versions of MariaDB Server, the parameter was 'vats',
|
enabling the new algorithm.
|
|
|
Because the new algorithm is triggering a debug assertion failure
|
that suggests corruption of the transactional lock data structures,
|
we will revert to the old algorithm by default until we have
|
resolved the problem.
|
openxs@ao756:~/git/server$ git pull
|
Already up-to-date.
|
But the problem happens with 10.2.16 as well.
Attachments
Issue Links
- is part of
-
MDEV-16791 mariabackup : allow consistent backup, in presence of concurrent DDL, also without --lock-ddl-per-table
-
- Closed
-