Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.2.12
-
None
-
CentOS 7.4
Description
mariabackup gets corrupted data without issuing errors
how to repeat
1.corrupt any table X
2.get mariabackup --backup – it's not seen any Error
3.issue mariabackup --prepare
4.stop mysql service and remove datadir
5.restore data mariabackup --copy-back
6.stat mysql service
7.Select from table X – fails and table cannot be recovered
1.corrupt any table X
MariaDB [(none)]> ALTER TABLE boxoffice_mdb.fact_tickets discard TABLESPACE;
|
|
2.perform mariabackup --backup
[root@t4w3 mariadb]# mariabackup -u root -p1 --backup --target-dir /var/mariadb/bafoo2
|
180207 13:26:48 Connecting to MySQL server host: localhost, user: root, password: set, port: not set, socket: not set
|
Using server version 10.2.12-MariaDB
|
mariabackup based on MariaDB server 10.2.12-MariaDB Linux (x86_64)
|
mariabackup: uses posix_fadvise().
|
mariabackup: cd to /var/lib/mysql/
|
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 = ./
|
2018-02-07 13:26:48 139743235680384 [Note] InnoDB: Number of pools: 1
|
180207 13:26:48 >> log scanned up to (92943198)
|
mariabackup: Generating a list of tablespaces
|
2018-02-07 13:26:48 139743235680384 [Warning] InnoDB: Allocated tablespace ID 1 for mysql/innodb_table_stats, old maximum was 0
|
180207 13:26:48 [01] Copying ./ibdata1 to /var/mariadb/bafoo2/ibdata1
|
180207 13:26:49 [01] ...done
|
180207 13:26:49 >> log scanned up to (92943198)
|
180207 13:26:50 [01] Copying ./mysql/innodb_table_stats.ibd to /var/mariadb/bafoo2/mysql/innodb_table_stats.ibd
|
180207 13:26:50 [01] ...done
|
180207 13:26:50 [01] Copying ./mysql/innodb_index_stats.ibd to /var/mariadb/bafoo2/mysql/innodb_index_stats.ibd
|
180207 13:26:50 [01] ...done
|
180207 13:26:50 [01] Copying ./mysql/gtid_slave_pos.ibd to /var/mariadb/bafoo2/mysql/gtid_slave_pos.ibd
|
180207 13:26:50 [01] ...done
|
180207 13:26:50 [01] Copying ./boxoffice_mdb/dim_date.ibd to /var/mariadb/bafoo2/boxoffice_mdb/dim_date.ibd
|
180207 13:26:50 [01] ...done
|
180207 13:26:50 [01] Copying ./boxoffice_mdb/dim_person.ibd to /var/mariadb/bafoo2/boxoffice_mdb/dim_person.ibd
|
180207 13:26:50 [01] ...done
|
180207 13:26:50 [01] Copying ./boxoffice_mdb/dim_showtime.ibd to /var/mariadb/bafoo2/boxoffice_mdb/dim_showtime.ibd
|
180207 13:26:51 [01] ...done
|
180207 13:26:52 [01] Copying ./boxoffice_mdb/dim_theater_mdc.ibd to /var/mariadb/bafoo2/boxoffice_mdb/dim_theater_mdc.ibd
|
180207 13:26:52 [01] ...done
|
180207 13:26:52 [01] Copying ./boxoffice_mdb/dim_theater.ibd to /var/mariadb/bafoo2/boxoffice_mdb/dim_theater.ibd
|
180207 13:26:52 [01] ...done
|
180207 13:26:52 [01] Copying ./boxoffice_mdb/dim_ticket_type.ibd to /var/mariadb/bafoo2/boxoffice_mdb/dim_ticket_type.ibd
|
180207 13:26:52 [01] ...done
|
180207 13:26:52 [01] Copying ./boxoffice_mdb/dim_title.ibd to /var/mariadb/bafoo2/boxoffice_mdb/dim_title.ibd
|
180207 13:26:52 [01] ...done
|
180207 13:26:52 [01] Copying ./boxoffice_mdb/fact_crew.ibd to /var/mariadb/bafoo2/boxoffice_mdb/fact_crew.ibd
|
180207 13:26:52 [01] ...done
|
180207 13:26:52 Executing FLUSH NO_WRITE_TO_BINLOG TABLES...
|
180207 13:26:52 Executing FLUSH TABLES WITH READ LOCK...
|
180207 13:26:52 Starting to backup non-InnoDB tables and files
|
180207 13:26:52 [01] Copying ./mysql/event.frm to /var/mariadb/bafoo2/mysql/event.frm
|
180207 13:26:52 [01] ...done
|
180207 13:26:52 [01] Copying ./mysql/user.frm to /var/mariadb/bafoo2/mysql/user.frm
|
180207 13:26:52 [01] ...done
|
180207 13:26:52 [01] Copying ./mysql/proc.MYD to /var/mariadb/bafoo2/mysql/proc.MYD
|
180207 13:26:52 [01] ...done
|
180207 13:26:52 [01] Copying ./mysql/func.frm to /var/mariadb/bafoo2/mysql/func.frm
|
180207 13:26:52 [01] ...done
|
180207 13:26:52 [01] Copying ./mysql/roles_mapping.frm to /var/mariadb/bafoo2/mysql/roles_mapping.frm
|
180207 13:26:52 [01] ...done
|
180207 13:26:52 [01] Copying ./mysql/roles_mapping.MYI to /var/mariadb/bafoo2/mysql/roles_mapping.MYI
|
180207 13:26:52 [01] ...done
|
180207 13:26:52 [01] Copying ./mysql/roles_mapping.MYD to /var/mariadb/bafoo2/mysql/roles_mapping.MYD
|
180207 13:26:52 [01] ...done
|
180207 13:26:52 [01] Copying ./mysql/proc.MYI to /var/mariadb/bafoo2/mysql/proc.MYI
|
180207 13:26:52 [01] ...done
|
180207 13:26:52 [01] Copying ./mysql/proc.frm to /var/mariadb/bafoo2/mysql/proc.frm
|
180207 13:26:52 [01] ...done
|
180207 13:26:53 [01] Copying ./mysql/user.MYI to /var/mariadb/bafoo2/mysql/user.MYI
|
180207 13:26:53 [01] ...done
|
180207 13:26:53 [01] Copying ./mysql/procs_priv.MYI to /var/mariadb/bafoo2/mysql/procs_priv.MYI
|
180207 13:26:53 [01] ...done
|
180207 13:26:53 [01] Copying ./mysql/servers.frm to /var/mariadb/bafoo2/mysql/servers.frm
|
180207 13:26:53 [01] ...done
|
180207 13:26:53 [01] Copying ./mysql/servers.MYI to /var/mariadb/bafoo2/mysql/servers.MYI
|
180207 13:26:53 [01] ...done
|
180207 13:26:53 [01] Copying ./mysql/servers.MYD to /var/mariadb/bafoo2/mysql/servers.MYD
|
180207 13:26:53 [01] ...done
|
180207 13:26:53 [01] Copying ./mysql/plugin.MYD to /var/mariadb/bafoo2/mysql/plugin.MYD
|
180207 13:26:53 [01] ...done
|
180207 13:26:53 [01] Copying ./mysql/columns_priv.MYI to /var/mariadb/bafoo2/mysql/columns_priv.MYI
|
180207 13:26:53 [01] ...done
|
180207 13:26:53 [01] Copying ./mysql/columns_priv.frm to /var/mariadb/bafoo2/mysql/columns_priv.frm
|
180207 13:26:53 [01] ...done
|
180207 13:26:53 [01] Copying ./mysql/host.MYI to /var/mariadb/bafoo2/mysql/host.MYI
|
180207 13:26:53 [01] ...done
|
180207 13:26:53 [01] Copying ./mysql/help_topic.frm to /var/mariadb/bafoo2/mysql/help_topic.frm
|
180207 13:26:53 [01] ...done
|
180207 13:26:53 [01] Copying ./mysql/help_topic.MYI to /var/mariadb/bafoo2/mysql/help_topic.MYI
|
180207 13:26:53 [01] ...done
|
180207 13:26:53 [01] Copying ./mysql/help_topic.MYD to /var/mariadb/bafoo2/mysql/help_topic.MYD
|
180207 13:26:53 [01] ...done
|
180207 13:26:53 [01] Copying ./mysql/help_category.frm to /var/mariadb/bafoo2/mysql/help_category.frm
|
180207 13:26:53 [01] ...done
|
180207 13:26:53 [01] Copying ./mysql/help_category.MYI to /var/mariadb/bafoo2/mysql/help_category.MYI
|
180207 13:26:53 [01] ...done
|
180207 13:26:53 [01] Copying ./mysql/help_category.MYD to /var/mariadb/bafoo2/mysql/help_category.MYD
|
180207 13:26:53 [01] ...done
|
180207 13:26:53 [01] Copying ./mysql/help_relation.frm to /var/mariadb/bafoo2/mysql/help_relation.frm
|
180207 13:26:53 [01] ...done
|
180207 13:26:53 [01] Copying ./mysql/help_relation.MYI to /var/mariadb/bafoo2/mysql/help_relation.MYI
|
180207 13:26:53 [01] ...done
|
180207 13:26:53 [01] Copying ./mysql/help_relation.MYD to /var/mariadb/bafoo2/mysql/help_relation.MYD
|
180207 13:26:53 [01] ...done
|
180207 13:26:53 [01] Copying ./mysql/help_keyword.frm to /var/mariadb/bafoo2/mysql/help_keyword.frm
|
180207 13:26:53 [01] ...done
|
180207 13:26:53 [01] Copying ./mysql/help_keyword.MYI to /var/mariadb/bafoo2/mysql/help_keyword.MYI
|
180207 13:26:53 [01] ...done
|
180207 13:26:54 [01] Copying ./mysql/help_keyword.MYD to /var/mariadb/bafoo2/mysql/help_keyword.MYD
|
180207 13:26:54 [01] ...done
|
180207 13:26:54 [01] Copying ./mysql/time_zone_name.frm to /var/mariadb/bafoo2/mysql/time_zone_name.frm
|
180207 13:26:54 [01] ...done
|
180207 13:26:54 [01] Copying ./mysql/time_zone_name.MYI to /var/mariadb/bafoo2/mysql/time_zone_name.MYI
|
180207 13:26:54 [01] ...done
|
180207 13:26:54 [01] Copying ./mysql/time_zone_name.MYD to /var/mariadb/bafoo2/mysql/time_zone_name.MYD
|
180207 13:26:54 [01] ...done
|
180207 13:26:54 [01] Copying ./mysql/time_zone.frm to /var/mariadb/bafoo2/mysql/time_zone.frm
|
180207 13:26:54 [01] ...done
|
180207 13:26:54 [01] Copying ./mysql/time_zone.MYI to /var/mariadb/bafoo2/mysql/time_zone.MYI
|
180207 13:26:54 [01] ...done
|
180207 13:26:54 [01] Copying ./mysql/time_zone.MYD to /var/mariadb/bafoo2/mysql/time_zone.MYD
|
180207 13:26:54 [01] ...done
|
180207 13:26:54 [01] Copying ./mysql/time_zone_transition.frm to /var/mariadb/bafoo2/mysql/time_zone_transition.frm
|
180207 13:26:54 [01] ...done
|
180207 13:26:54 [01] Copying ./mysql/time_zone_transition.MYI to /var/mariadb/bafoo2/mysql/time_zone_transition.MYI
|
180207 13:26:54 [01] ...done
|
180207 13:26:54 [01] Copying ./mysql/time_zone_transition.MYD to /var/mariadb/bafoo2/mysql/time_zone_transition.MYD
|
180207 13:26:54 [01] ...done
|
180207 13:26:54 [01] Copying ./mysql/time_zone_transition_type.frm to /var/mariadb/bafoo2/mysql/time_zone_transition_type.frm
|
180207 13:26:54 [01] ...done
|
180207 13:26:54 [01] Copying ./mysql/time_zone_transition_type.MYI to /var/mariadb/bafoo2/mysql/time_zone_transition_type.MYI
|
180207 13:26:54 [01] ...done
|
180207 13:26:54 [01] Copying ./mysql/time_zone_transition_type.MYD to /var/mariadb/bafoo2/mysql/time_zone_transition_type.MYD
|
180207 13:26:54 [01] ...done
|
180207 13:26:54 [01] Copying ./mysql/time_zone_leap_second.frm to /var/mariadb/bafoo2/mysql/time_zone_leap_second.frm
|
180207 13:26:54 [01] ...done
|
180207 13:26:54 [01] Copying ./mysql/time_zone_leap_second.MYI to /var/mariadb/bafoo2/mysql/time_zone_leap_second.MYI
|
180207 13:26:54 [01] ...done
|
180207 13:26:54 [01] Copying ./mysql/time_zone_leap_second.MYD to /var/mariadb/bafoo2/mysql/time_zone_leap_second.MYD
|
180207 13:26:54 [01] ...done
|
180207 13:26:54 [01] Copying ./mysql/procs_priv.MYD to /var/mariadb/bafoo2/mysql/procs_priv.MYD
|
180207 13:26:54 [01] ...done
|
180207 13:26:54 [01] Copying ./mysql/host.MYD to /var/mariadb/bafoo2/mysql/host.MYD
|
180207 13:26:54 [01] ...done
|
180207 13:26:54 [01] Copying ./mysql/host.frm to /var/mariadb/bafoo2/mysql/host.frm
|
180207 13:26:54 [01] ...done
|
180207 13:26:54 [01] Copying ./mysql/func.MYI to /var/mariadb/bafoo2/mysql/func.MYI
|
180207 13:26:54 [01] ...done
|
180207 13:26:54 [01] Copying ./mysql/general_log.frm to /var/mariadb/bafoo2/mysql/general_log.frm
|
180207 13:26:54 [01] ...done
|
180207 13:26:54 [01] Copying ./mysql/general_log.CSM to /var/mariadb/bafoo2/mysql/general_log.CSM
|
180207 13:26:54 [01] ...done
|
180207 13:26:54 [01] Copying ./mysql/general_log.CSV to /var/mariadb/bafoo2/mysql/general_log.CSV
|
180207 13:26:54 [01] ...done
|
180207 13:26:54 [01] Copying ./mysql/slow_log.frm to /var/mariadb/bafoo2/mysql/slow_log.frm
|
180207 13:26:54 [01] ...done
|
180207 13:26:54 [01] Copying ./mysql/slow_log.CSM to /var/mariadb/bafoo2/mysql/slow_log.CSM
|
180207 13:26:54 [01] ...done
|
180207 13:26:54 [01] Copying ./mysql/slow_log.CSV to /var/mariadb/bafoo2/mysql/slow_log.CSV
|
180207 13:26:54 [01] ...done
|
180207 13:26:54 [01] Copying ./mysql/db.MYI to /var/mariadb/bafoo2/mysql/db.MYI
|
180207 13:26:54 [01] ...done
|
180207 13:26:55 [01] Copying ./mysql/db.MYD to /var/mariadb/bafoo2/mysql/db.MYD
|
180207 13:26:55 [01] ...done
|
180207 13:26:55 [01] Copying ./mysql/innodb_table_stats.frm to /var/mariadb/bafoo2/mysql/innodb_table_stats.frm
|
180207 13:26:55 [01] ...done
|
180207 13:26:55 [01] Copying ./mysql/innodb_index_stats.frm to /var/mariadb/bafoo2/mysql/innodb_index_stats.frm
|
180207 13:26:55 [01] ...done
|
180207 13:26:55 [01] Copying ./mysql/proxies_priv.frm to /var/mariadb/bafoo2/mysql/proxies_priv.frm
|
180207 13:26:55 [01] ...done
|
180207 13:26:55 [01] Copying ./mysql/proxies_priv.MYI to /var/mariadb/bafoo2/mysql/proxies_priv.MYI
|
180207 13:26:55 [01] ...done
|
180207 13:26:55 [01] Copying ./mysql/proxies_priv.MYD to /var/mariadb/bafoo2/mysql/proxies_priv.MYD
|
180207 13:26:55 [01] ...done
|
180207 13:26:55 [01] Copying ./mysql/table_stats.frm to /var/mariadb/bafoo2/mysql/table_stats.frm
|
180207 13:26:55 [01] ...done
|
180207 13:26:55 [01] Copying ./mysql/table_stats.MYI to /var/mariadb/bafoo2/mysql/table_stats.MYI
|
180207 13:26:55 [01] ...done
|
180207 13:26:55 [01] Copying ./mysql/table_stats.MYD to /var/mariadb/bafoo2/mysql/table_stats.MYD
|
180207 13:26:55 [01] ...done
|
180207 13:26:55 [01] Copying ./mysql/column_stats.frm to /var/mariadb/bafoo2/mysql/column_stats.frm
|
180207 13:26:55 [01] ...done
|
180207 13:26:55 [01] Copying ./mysql/column_stats.MYI to /var/mariadb/bafoo2/mysql/column_stats.MYI
|
180207 13:26:55 [01] ...done
|
180207 13:26:55 [01] Copying ./mysql/column_stats.MYD to /var/mariadb/bafoo2/mysql/column_stats.MYD
|
180207 13:26:55 [01] ...done
|
180207 13:26:55 [01] Copying ./mysql/index_stats.frm to /var/mariadb/bafoo2/mysql/index_stats.frm
|
180207 13:26:55 [01] ...done
|
180207 13:26:55 [01] Copying ./mysql/index_stats.MYI to /var/mariadb/bafoo2/mysql/index_stats.MYI
|
180207 13:26:55 [01] ...done
|
180207 13:26:55 [01] Copying ./mysql/index_stats.MYD to /var/mariadb/bafoo2/mysql/index_stats.MYD
|
180207 13:26:55 [01] ...done
|
180207 13:26:55 [01] Copying ./mysql/gtid_slave_pos.frm to /var/mariadb/bafoo2/mysql/gtid_slave_pos.frm
|
180207 13:26:55 [01] ...done
|
180207 13:26:55 [01] Copying ./mysql/columns_priv.MYD to /var/mariadb/bafoo2/mysql/columns_priv.MYD
|
180207 13:26:55 [01] ...done
|
180207 13:26:55 [01] Copying ./mysql/func.MYD to /var/mariadb/bafoo2/mysql/func.MYD
|
180207 13:26:55 [01] ...done
|
180207 13:26:55 [01] Copying ./mysql/procs_priv.frm to /var/mariadb/bafoo2/mysql/procs_priv.frm
|
180207 13:26:55 [01] ...done
|
180207 13:26:55 [01] Copying ./mysql/user.MYD to /var/mariadb/bafoo2/mysql/user.MYD
|
180207 13:26:55 [01] ...done
|
180207 13:26:55 [01] Copying ./mysql/plugin.MYI to /var/mariadb/bafoo2/mysql/plugin.MYI
|
180207 13:26:55 [01] ...done
|
180207 13:26:55 [01] Copying ./mysql/tables_priv.frm to /var/mariadb/bafoo2/mysql/tables_priv.frm
|
180207 13:26:55 [01] ...done
|
180207 13:26:55 [01] Copying ./mysql/db.frm to /var/mariadb/bafoo2/mysql/db.frm
|
180207 13:26:55 [01] ...done
|
180207 13:26:56 [01] Copying ./mysql/plugin.frm to /var/mariadb/bafoo2/mysql/plugin.frm
|
180207 13:26:56 [01] ...done
|
180207 13:26:56 [01] Copying ./mysql/tables_priv.MYI to /var/mariadb/bafoo2/mysql/tables_priv.MYI
|
180207 13:26:56 [01] ...done
|
180207 13:26:56 [01] Copying ./mysql/tables_priv.MYD to /var/mariadb/bafoo2/mysql/tables_priv.MYD
|
180207 13:26:56 [01] ...done
|
180207 13:26:56 [01] Copying ./mysql/event.MYI to /var/mariadb/bafoo2/mysql/event.MYI
|
180207 13:26:56 [01] ...done
|
180207 13:26:56 [01] Copying ./mysql/event.MYD to /var/mariadb/bafoo2/mysql/event.MYD
|
180207 13:26:56 [01] ...done
|
180207 13:26:56 [01] Copying ./test/db.opt to /var/mariadb/bafoo2/test/db.opt
|
180207 13:26:56 [01] ...done
|
180207 13:26:56 [01] Copying ./boxoffice_mdb/db.opt to /var/mariadb/bafoo2/boxoffice_mdb/db.opt
|
180207 13:26:56 [01] ...done
|
180207 13:26:56 [01] Copying ./boxoffice_mdb/dim_date.frm to /var/mariadb/bafoo2/boxoffice_mdb/dim_date.frm
|
180207 13:26:56 [01] ...done
|
180207 13:26:56 [01] Copying ./boxoffice_mdb/dim_person.frm to /var/mariadb/bafoo2/boxoffice_mdb/dim_person.frm
|
180207 13:26:56 [01] ...done
|
180207 13:26:56 [01] Copying ./boxoffice_mdb/dim_showtime.frm to /var/mariadb/bafoo2/boxoffice_mdb/dim_showtime.frm
|
180207 13:26:56 [01] ...done
|
180207 13:26:56 [01] Copying ./boxoffice_mdb/dim_theater_mdc.frm to /var/mariadb/bafoo2/boxoffice_mdb/dim_theater_mdc.frm
|
180207 13:26:56 [01] ...done
|
180207 13:26:56 [01] Copying ./boxoffice_mdb/dim_theater.frm to /var/mariadb/bafoo2/boxoffice_mdb/dim_theater.frm
|
180207 13:26:56 [01] ...done
|
180207 13:26:56 [01] Copying ./boxoffice_mdb/dim_ticket_type.frm to /var/mariadb/bafoo2/boxoffice_mdb/dim_ticket_type.frm
|
180207 13:26:56 [01] ...done
|
180207 13:26:56 [01] Copying ./boxoffice_mdb/dim_title.frm to /var/mariadb/bafoo2/boxoffice_mdb/dim_title.frm
|
180207 13:26:56 [01] ...done
|
180207 13:26:56 [01] Copying ./boxoffice_mdb/fact_crew.frm to /var/mariadb/bafoo2/boxoffice_mdb/fact_crew.frm
|
180207 13:26:56 [01] ...done
|
180207 13:26:56 [01] Copying ./boxoffice_mdb/fact_tickets.frm to /var/mariadb/bafoo2/boxoffice_mdb/fact_tickets.frm
|
180207 13:26:56 [01] ...done
|
180207 13:26:56 [01] Copying ./performance_schema/db.opt to /var/mariadb/bafoo2/performance_schema/db.opt
|
180207 13:26:56 [01] ...done
|
180207 13:26:56 Finished backing up non-InnoDB tables and files
|
180207 13:26:56 [01] Copying aria_log_control to /var/mariadb/bafoo2/aria_log_control
|
180207 13:26:56 [01] ...done
|
180207 13:26:56 [01] Copying aria_log.00000001 to /var/mariadb/bafoo2/aria_log.00000001
|
180207 13:26:56 [01] ...done
|
180207 13:26:56 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
|
mariabackup: The latest check point (for incremental): '92943189'
|
mariabackup: Stopping log copying thread.
|
|
|
180207 13:26:56 >> log scanned up to (92943198)
|
180207 13:26:56 Executing UNLOCK TABLES
|
180207 13:26:56 All tables unlocked
|
180207 13:26:56 [00] Copying ib_buffer_pool to /var/mariadb/bafoo2/ib_buffer_pool
|
180207 13:26:56 [00] ...done
|
180207 13:26:56 Backup created in directory '/var/mariadb/bafoo2/'
|
180207 13:26:56 [00] Writing backup-my.cnf
|
180207 13:26:56 [00] ...done
|
180207 13:26:56 [00] Writing xtrabackup_info
|
180207 13:26:56 [00] ...done
|
mariabackup: Redo log (from LSN 92943189 to 92943198) was copied.
|
180207 13:26:56 completed OK!
|
3.issue mariabackup --prepare
|
|
|
|
|
|
|
|
[root@t4w3 mariadb]# mariabackup -u root -p1 --prepare --target-dir /var/mariadb/bafoo2
|
mariabackup based on MariaDB server 10.2.12-MariaDB Linux (x86_64)
|
mariabackup: cd to /var/mariadb/bafoo2/
|
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-02-07 13:27:20 140170716956800 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2018-02-07 13:27:20 140170716956800 [Note] InnoDB: Uses event mutexes
|
2018-02-07 13:27:20 140170716956800 [Note] InnoDB: Compressed tables use zlib 1.2.7
|
2018-02-07 13:27:20 140170716956800 [Note] InnoDB: Number of pools: 1
|
2018-02-07 13:27:20 140170716956800 [Note] InnoDB: Using generic crc32 instructions
|
2018-02-07 13:27:20 140170716956800 [Note] InnoDB: Initializing buffer pool, total size = 100M, instances = 1, chunk size = 100M
|
2018-02-07 13:27:20 140170716956800 [Note] InnoDB: Completed initialization of buffer pool
|
2018-02-07 13:27:20 140170368096000 [Note] InnoDB: page_cleaner coordinator priority: -20
|
2018-02-07 13:27:21 140170716956800 [Note] InnoDB: Highest supported file format is Barracuda.
|
2018-02-07 13:27:21 140170716956800 [Note] InnoDB: Starting crash recovery from checkpoint LSN=92943189
|
180207 13:27:21 completed OK!
|
4.5.
restore data mariabackup --copy-back
[root@t4w3 mariadb]# mariabackup -u root -p1 --copy-back --target-dir /var/mariadb/bafoo2 --datadir /var/lib/mysql/
|
mariabackup based on MariaDB server 10.2.12-MariaDB Linux (x86_64)
|
180207 13:30:03 [01] Copying ibdata1 to /var/lib/mysql/ibdata1
|
180207 13:30:04 [01] ...done
|
180207 13:30:05 [01] Copying ./mysql/innodb_table_stats.ibd to /var/lib/mysql/mysql/innodb_table_stats.ibd
|
180207 13:30:05 [01] ...done
|
180207 13:30:06 [01] Copying ./mysql/innodb_index_stats.ibd to /var/lib/mysql/mysql/innodb_index_stats.ibd
|
180207 13:30:06 [01] ...done
|
180207 13:30:06 [01] Copying ./mysql/gtid_slave_pos.ibd to /var/lib/mysql/mysql/gtid_slave_pos.ibd
|
180207 13:30:06 [01] ...done
|
180207 13:30:06 [01] Copying ./mysql/event.frm to /var/lib/mysql/mysql/event.frm
|
180207 13:30:06 [01] ...done
|
180207 13:30:06 [01] Copying ./mysql/user.frm to /var/lib/mysql/mysql/user.frm
|
180207 13:30:06 [01] ...done
|
180207 13:30:06 [01] Copying ./mysql/proc.MYD to /var/lib/mysql/mysql/proc.MYD
|
180207 13:30:06 [01] ...done
|
180207 13:30:06 [01] Copying ./mysql/func.frm to /var/lib/mysql/mysql/func.frm
|
180207 13:30:06 [01] ...done
|
180207 13:30:06 [01] Copying ./mysql/roles_mapping.frm to /var/lib/mysql/mysql/roles_mapping.frm
|
180207 13:30:06 [01] ...done
|
180207 13:30:06 [01] Copying ./mysql/roles_mapping.MYI to /var/lib/mysql/mysql/roles_mapping.MYI
|
180207 13:30:06 [01] ...done
|
180207 13:30:06 [01] Copying ./mysql/roles_mapping.MYD to /var/lib/mysql/mysql/roles_mapping.MYD
|
180207 13:30:06 [01] ...done
|
180207 13:30:06 [01] Copying ./mysql/proc.MYI to /var/lib/mysql/mysql/proc.MYI
|
180207 13:30:06 [01] ...done
|
180207 13:30:06 [01] Copying ./mysql/proc.frm to /var/lib/mysql/mysql/proc.frm
|
180207 13:30:06 [01] ...done
|
180207 13:30:06 [01] Copying ./mysql/user.MYI to /var/lib/mysql/mysql/user.MYI
|
180207 13:30:06 [01] ...done
|
180207 13:30:06 [01] Copying ./mysql/procs_priv.MYI to /var/lib/mysql/mysql/procs_priv.MYI
|
180207 13:30:06 [01] ...done
|
180207 13:30:06 [01] Copying ./mysql/servers.frm to /var/lib/mysql/mysql/servers.frm
|
180207 13:30:06 [01] ...done
|
180207 13:30:06 [01] Copying ./mysql/servers.MYI to /var/lib/mysql/mysql/servers.MYI
|
180207 13:30:06 [01] ...done
|
180207 13:30:06 [01] Copying ./mysql/servers.MYD to /var/lib/mysql/mysql/servers.MYD
|
180207 13:30:06 [01] ...done
|
180207 13:30:06 [01] Copying ./mysql/plugin.MYD to /var/lib/mysql/mysql/plugin.MYD
|
180207 13:30:06 [01] ...done
|
180207 13:30:06 [01] Copying ./mysql/columns_priv.MYI to /var/lib/mysql/mysql/columns_priv.MYI
|
180207 13:30:06 [01] ...done
|
180207 13:30:06 [01] Copying ./mysql/columns_priv.frm to /var/lib/mysql/mysql/columns_priv.frm
|
180207 13:30:06 [01] ...done
|
180207 13:30:06 [01] Copying ./mysql/host.MYI to /var/lib/mysql/mysql/host.MYI
|
180207 13:30:06 [01] ...done
|
180207 13:30:06 [01] Copying ./mysql/help_topic.frm to /var/lib/mysql/mysql/help_topic.frm
|
180207 13:30:06 [01] ...done
|
180207 13:30:06 [01] Copying ./mysql/help_topic.MYI to /var/lib/mysql/mysql/help_topic.MYI
|
180207 13:30:06 [01] ...done
|
180207 13:30:06 [01] Copying ./mysql/help_topic.MYD to /var/lib/mysql/mysql/help_topic.MYD
|
180207 13:30:06 [01] ...done
|
180207 13:30:06 [01] Copying ./mysql/help_category.frm to /var/lib/mysql/mysql/help_category.frm
|
180207 13:30:06 [01] ...done
|
180207 13:30:07 [01] Copying ./mysql/help_category.MYI to /var/lib/mysql/mysql/help_category.MYI
|
180207 13:30:07 [01] ...done
|
180207 13:30:07 [01] Copying ./mysql/help_category.MYD to /var/lib/mysql/mysql/help_category.MYD
|
180207 13:30:07 [01] ...done
|
180207 13:30:07 [01] Copying ./mysql/help_relation.frm to /var/lib/mysql/mysql/help_relation.frm
|
180207 13:30:07 [01] ...done
|
180207 13:30:07 [01] Copying ./mysql/help_relation.MYI to /var/lib/mysql/mysql/help_relation.MYI
|
180207 13:30:07 [01] ...done
|
180207 13:30:07 [01] Copying ./mysql/help_relation.MYD to /var/lib/mysql/mysql/help_relation.MYD
|
180207 13:30:07 [01] ...done
|
180207 13:30:07 [01] Copying ./mysql/help_keyword.frm to /var/lib/mysql/mysql/help_keyword.frm
|
180207 13:30:07 [01] ...done
|
180207 13:30:07 [01] Copying ./mysql/help_keyword.MYI to /var/lib/mysql/mysql/help_keyword.MYI
|
180207 13:30:07 [01] ...done
|
180207 13:30:07 [01] Copying ./mysql/help_keyword.MYD to /var/lib/mysql/mysql/help_keyword.MYD
|
180207 13:30:07 [01] ...done
|
180207 13:30:07 [01] Copying ./mysql/time_zone_name.frm to /var/lib/mysql/mysql/time_zone_name.frm
|
180207 13:30:07 [01] ...done
|
180207 13:30:07 [01] Copying ./mysql/time_zone_name.MYI to /var/lib/mysql/mysql/time_zone_name.MYI
|
180207 13:30:07 [01] ...done
|
180207 13:30:07 [01] Copying ./mysql/time_zone_name.MYD to /var/lib/mysql/mysql/time_zone_name.MYD
|
180207 13:30:07 [01] ...done
|
180207 13:30:07 [01] Copying ./mysql/time_zone.frm to /var/lib/mysql/mysql/time_zone.frm
|
180207 13:30:07 [01] ...done
|
180207 13:30:07 [01] Copying ./mysql/time_zone.MYI to /var/lib/mysql/mysql/time_zone.MYI
|
180207 13:30:07 [01] ...done
|
180207 13:30:07 [01] Copying ./mysql/time_zone.MYD to /var/lib/mysql/mysql/time_zone.MYD
|
180207 13:30:07 [01] ...done
|
180207 13:30:07 [01] Copying ./mysql/time_zone_transition.frm to /var/lib/mysql/mysql/time_zone_transition.frm
|
180207 13:30:07 [01] ...done
|
180207 13:30:07 [01] Copying ./mysql/time_zone_transition.MYI to /var/lib/mysql/mysql/time_zone_transition.MYI
|
180207 13:30:07 [01] ...done
|
180207 13:30:07 [01] Copying ./mysql/time_zone_transition.MYD to /var/lib/mysql/mysql/time_zone_transition.MYD
|
180207 13:30:07 [01] ...done
|
180207 13:30:07 [01] Copying ./mysql/time_zone_transition_type.frm to /var/lib/mysql/mysql/time_zone_transition_type.frm
|
180207 13:30:07 [01] ...done
|
180207 13:30:07 [01] Copying ./mysql/time_zone_transition_type.MYI to /var/lib/mysql/mysql/time_zone_transition_type.MYI
|
180207 13:30:07 [01] ...done
|
180207 13:30:07 [01] Copying ./mysql/time_zone_transition_type.MYD to /var/lib/mysql/mysql/time_zone_transition_type.MYD
|
180207 13:30:07 [01] ...done
|
180207 13:30:07 [01] Copying ./mysql/time_zone_leap_second.frm to /var/lib/mysql/mysql/time_zone_leap_second.frm
|
180207 13:30:07 [01] ...done
|
180207 13:30:07 [01] Copying ./mysql/time_zone_leap_second.MYI to /var/lib/mysql/mysql/time_zone_leap_second.MYI
|
180207 13:30:07 [01] ...done
|
180207 13:30:07 [01] Copying ./mysql/time_zone_leap_second.MYD to /var/lib/mysql/mysql/time_zone_leap_second.MYD
|
180207 13:30:07 [01] ...done
|
180207 13:30:07 [01] Copying ./mysql/procs_priv.MYD to /var/lib/mysql/mysql/procs_priv.MYD
|
180207 13:30:07 [01] ...done
|
180207 13:30:07 [01] Copying ./mysql/host.MYD to /var/lib/mysql/mysql/host.MYD
|
180207 13:30:07 [01] ...done
|
180207 13:30:07 [01] Copying ./mysql/host.frm to /var/lib/mysql/mysql/host.frm
|
180207 13:30:07 [01] ...done
|
180207 13:30:07 [01] Copying ./mysql/func.MYI to /var/lib/mysql/mysql/func.MYI
|
180207 13:30:07 [01] ...done
|
180207 13:30:07 [01] Copying ./mysql/general_log.frm to /var/lib/mysql/mysql/general_log.frm
|
180207 13:30:07 [01] ...done
|
180207 13:30:07 [01] Copying ./mysql/general_log.CSM to /var/lib/mysql/mysql/general_log.CSM
|
180207 13:30:07 [01] ...done
|
180207 13:30:08 [01] Copying ./mysql/general_log.CSV to /var/lib/mysql/mysql/general_log.CSV
|
180207 13:30:08 [01] ...done
|
180207 13:30:08 [01] Copying ./mysql/slow_log.frm to /var/lib/mysql/mysql/slow_log.frm
|
180207 13:30:08 [01] ...done
|
180207 13:30:08 [01] Copying ./mysql/slow_log.CSM to /var/lib/mysql/mysql/slow_log.CSM
|
180207 13:30:08 [01] ...done
|
180207 13:30:08 [01] Copying ./mysql/slow_log.CSV to /var/lib/mysql/mysql/slow_log.CSV
|
180207 13:30:08 [01] ...done
|
180207 13:30:08 [01] Copying ./mysql/db.MYI to /var/lib/mysql/mysql/db.MYI
|
180207 13:30:08 [01] ...done
|
180207 13:30:08 [01] Copying ./mysql/db.MYD to /var/lib/mysql/mysql/db.MYD
|
180207 13:30:08 [01] ...done
|
180207 13:30:08 [01] Copying ./mysql/innodb_table_stats.frm to /var/lib/mysql/mysql/innodb_table_stats.frm
|
180207 13:30:08 [01] ...done
|
180207 13:30:08 [01] Copying ./mysql/innodb_index_stats.frm to /var/lib/mysql/mysql/innodb_index_stats.frm
|
180207 13:30:08 [01] ...done
|
180207 13:30:08 [01] Copying ./mysql/proxies_priv.frm to /var/lib/mysql/mysql/proxies_priv.frm
|
180207 13:30:08 [01] ...done
|
180207 13:30:08 [01] Copying ./mysql/proxies_priv.MYI to /var/lib/mysql/mysql/proxies_priv.MYI
|
180207 13:30:08 [01] ...done
|
180207 13:30:08 [01] Copying ./mysql/proxies_priv.MYD to /var/lib/mysql/mysql/proxies_priv.MYD
|
180207 13:30:08 [01] ...done
|
180207 13:30:08 [01] Copying ./mysql/table_stats.frm to /var/lib/mysql/mysql/table_stats.frm
|
180207 13:30:08 [01] ...done
|
180207 13:30:08 [01] Copying ./mysql/table_stats.MYI to /var/lib/mysql/mysql/table_stats.MYI
|
180207 13:30:08 [01] ...done
|
180207 13:30:08 [01] Copying ./mysql/table_stats.MYD to /var/lib/mysql/mysql/table_stats.MYD
|
180207 13:30:08 [01] ...done
|
180207 13:30:08 [01] Copying ./mysql/column_stats.frm to /var/lib/mysql/mysql/column_stats.frm
|
180207 13:30:08 [01] ...done
|
180207 13:30:08 [01] Copying ./mysql/column_stats.MYI to /var/lib/mysql/mysql/column_stats.MYI
|
180207 13:30:08 [01] ...done
|
180207 13:30:08 [01] Copying ./mysql/column_stats.MYD to /var/lib/mysql/mysql/column_stats.MYD
|
180207 13:30:08 [01] ...done
|
180207 13:30:08 [01] Copying ./mysql/index_stats.frm to /var/lib/mysql/mysql/index_stats.frm
|
180207 13:30:08 [01] ...done
|
180207 13:30:08 [01] Copying ./mysql/index_stats.MYI to /var/lib/mysql/mysql/index_stats.MYI
|
180207 13:30:08 [01] ...done
|
180207 13:30:08 [01] Copying ./mysql/index_stats.MYD to /var/lib/mysql/mysql/index_stats.MYD
|
180207 13:30:08 [01] ...done
|
180207 13:30:08 [01] Copying ./mysql/gtid_slave_pos.frm to /var/lib/mysql/mysql/gtid_slave_pos.frm
|
180207 13:30:08 [01] ...done
|
180207 13:30:08 [01] Copying ./mysql/columns_priv.MYD to /var/lib/mysql/mysql/columns_priv.MYD
|
180207 13:30:08 [01] ...done
|
180207 13:30:08 [01] Copying ./mysql/func.MYD to /var/lib/mysql/mysql/func.MYD
|
180207 13:30:08 [01] ...done
|
180207 13:30:08 [01] Copying ./mysql/procs_priv.frm to /var/lib/mysql/mysql/procs_priv.frm
|
180207 13:30:08 [01] ...done
|
180207 13:30:08 [01] Copying ./mysql/user.MYD to /var/lib/mysql/mysql/user.MYD
|
180207 13:30:08 [01] ...done
|
180207 13:30:08 [01] Copying ./mysql/plugin.MYI to /var/lib/mysql/mysql/plugin.MYI
|
180207 13:30:08 [01] ...done
|
180207 13:30:08 [01] Copying ./mysql/tables_priv.frm to /var/lib/mysql/mysql/tables_priv.frm
|
180207 13:30:08 [01] ...done
|
180207 13:30:08 [01] Copying ./mysql/db.frm to /var/lib/mysql/mysql/db.frm
|
180207 13:30:08 [01] ...done
|
180207 13:30:08 [01] Copying ./mysql/plugin.frm to /var/lib/mysql/mysql/plugin.frm
|
180207 13:30:08 [01] ...done
|
180207 13:30:08 [01] Copying ./mysql/tables_priv.MYI to /var/lib/mysql/mysql/tables_priv.MYI
|
180207 13:30:08 [01] ...done
|
180207 13:30:09 [01] Copying ./mysql/tables_priv.MYD to /var/lib/mysql/mysql/tables_priv.MYD
|
180207 13:30:09 [01] ...done
|
180207 13:30:09 [01] Copying ./mysql/event.MYI to /var/lib/mysql/mysql/event.MYI
|
180207 13:30:09 [01] ...done
|
180207 13:30:09 [01] Copying ./mysql/event.MYD to /var/lib/mysql/mysql/event.MYD
|
180207 13:30:09 [01] ...done
|
180207 13:30:09 [01] Copying ./boxoffice_mdb/dim_date.ibd to /var/lib/mysql/boxoffice_mdb/dim_date.ibd
|
180207 13:30:09 [01] ...done
|
180207 13:30:09 [01] Copying ./boxoffice_mdb/dim_person.ibd to /var/lib/mysql/boxoffice_mdb/dim_person.ibd
|
180207 13:30:09 [01] ...done
|
180207 13:30:09 [01] Copying ./boxoffice_mdb/dim_showtime.ibd to /var/lib/mysql/boxoffice_mdb/dim_showtime.ibd
|
180207 13:30:09 [01] ...done
|
180207 13:30:10 [01] Copying ./boxoffice_mdb/dim_theater_mdc.ibd to /var/lib/mysql/boxoffice_mdb/dim_theater_mdc.ibd
|
180207 13:30:10 [01] ...done
|
180207 13:30:10 [01] Copying ./boxoffice_mdb/dim_theater.ibd to /var/lib/mysql/boxoffice_mdb/dim_theater.ibd
|
180207 13:30:10 [01] ...done
|
180207 13:30:10 [01] Copying ./boxoffice_mdb/dim_ticket_type.ibd to /var/lib/mysql/boxoffice_mdb/dim_ticket_type.ibd
|
180207 13:30:10 [01] ...done
|
180207 13:30:10 [01] Copying ./boxoffice_mdb/dim_title.ibd to /var/lib/mysql/boxoffice_mdb/dim_title.ibd
|
180207 13:30:10 [01] ...done
|
180207 13:30:10 [01] Copying ./boxoffice_mdb/fact_crew.ibd to /var/lib/mysql/boxoffice_mdb/fact_crew.ibd
|
180207 13:30:10 [01] ...done
|
180207 13:30:10 [01] Copying ./boxoffice_mdb/db.opt to /var/lib/mysql/boxoffice_mdb/db.opt
|
180207 13:30:10 [01] ...done
|
180207 13:30:10 [01] Copying ./boxoffice_mdb/dim_date.frm to /var/lib/mysql/boxoffice_mdb/dim_date.frm
|
180207 13:30:10 [01] ...done
|
180207 13:30:10 [01] Copying ./boxoffice_mdb/dim_person.frm to /var/lib/mysql/boxoffice_mdb/dim_person.frm
|
180207 13:30:10 [01] ...done
|
180207 13:30:10 [01] Copying ./boxoffice_mdb/dim_showtime.frm to /var/lib/mysql/boxoffice_mdb/dim_showtime.frm
|
180207 13:30:10 [01] ...done
|
180207 13:30:10 [01] Copying ./boxoffice_mdb/dim_theater_mdc.frm to /var/lib/mysql/boxoffice_mdb/dim_theater_mdc.frm
|
180207 13:30:10 [01] ...done
|
180207 13:30:10 [01] Copying ./boxoffice_mdb/dim_theater.frm to /var/lib/mysql/boxoffice_mdb/dim_theater.frm
|
180207 13:30:10 [01] ...done
|
180207 13:30:10 [01] Copying ./boxoffice_mdb/dim_ticket_type.frm to /var/lib/mysql/boxoffice_mdb/dim_ticket_type.frm
|
180207 13:30:10 [01] ...done
|
180207 13:30:10 [01] Copying ./boxoffice_mdb/dim_title.frm to /var/lib/mysql/boxoffice_mdb/dim_title.frm
|
180207 13:30:10 [01] ...done
|
180207 13:30:10 [01] Copying ./boxoffice_mdb/fact_crew.frm to /var/lib/mysql/boxoffice_mdb/fact_crew.frm
|
180207 13:30:10 [01] ...done
|
180207 13:30:10 [01] Copying ./boxoffice_mdb/fact_tickets.frm to /var/lib/mysql/boxoffice_mdb/fact_tickets.frm
|
180207 13:30:10 [01] ...done
|
180207 13:30:10 [01] Copying ./test/db.opt to /var/lib/mysql/test/db.opt
|
180207 13:30:10 [01] ...done
|
180207 13:30:10 [01] Copying ./performance_schema/db.opt to /var/lib/mysql/performance_schema/db.opt
|
180207 13:30:10 [01] ...done
|
180207 13:30:10 [01] Copying ./aria_log_control to /var/lib/mysql/aria_log_control
|
180207 13:30:10 [01] ...done
|
180207 13:30:10 [01] Copying ./aria_log.00000001 to /var/lib/mysql/aria_log.00000001
|
180207 13:30:10 [01] ...done
|
180207 13:30:10 [01] Copying ./ib_buffer_pool to /var/lib/mysql/ib_buffer_pool
|
180207 13:30:10 [01] ...done
|
180207 13:30:10 [01] Copying ./xtrabackup_info to /var/lib/mysql/xtrabackup_info
|
180207 13:30:10 [01] ...done
|
180207 13:30:11 completed OK!
|
|
6.start mysql service
[root@t4w3 mariadb]# service mysql start
Starting mysql (via systemctl): [ OK ]
7.select from table X - fails and table cannot be recovered
MariaDB [(none)]> select * from boxoffice_mdb.fact_tickets limit 1 ;
|
ERROR 1814 (HY000): Tablespace has been discarded for table `fact_tickets`
|
MariaDB [(none)]> select * from boxoffice_mdb.fact_tickets limit 1 ;
|
ERROR 1814 (HY000): Tablespace has been discarded for table `fact_tickets`
|
MariaDB [(none)]> ALTER TABLE boxoffice_mdb.fact_tickets import TABLESPACE;
|
ERROR 1030 (HY000): Got error 194 "Tablespace is missing for a table" from storage engine InnoDB
|
|
Attachments
Issue Links
- relates to
-
-
- Closed
-