[MDEV-15234] mariabackup gets corrupted data without issuing errors Created: 2018-02-07  Updated: 2018-02-16  Resolved: 2018-02-15

Status: Closed
Project: MariaDB Server
Component/s: Backup
Affects Version/s: 10.2.12
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Zdravelina Sokolovska (Inactive) Assignee: Vladislav Vaintroub
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

CentOS 7.4

Issue Links:
Relates
relates to MDEV-15211 Mariabackups give "table 'X' doesn't ... Closed

 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



 Comments   
Comment by Vladislav Vaintroub [ 2018-02-07 ]

winstone Is your step 1 actually "corrupt" ?

Comment by Vladislav Vaintroub [ 2018-02-15 ]

It is a usage error. Discarded tablespaces are already removed from your original database . DISCARD is designed to be a temporary state, after which you IMPORT your table from some other place.

Corruption happens, when you change an existing .ibd file and write some random bytes to random places. mariabackup does not backup that, since it has a checksum verification

Generated at Thu Feb 08 08:19:41 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.