[MDEV-15234] mariabackup gets corrupted data without issuing errors - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Not a Bug
Affects Version/s: 10.2.12
Fix Version/s: N/A
Component/s: Backup
Labels:
None
Environment:
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

MDEV-15211 Mariabackups give "table 'X' doesn't exist in engine" when restoring backup

Closed

Activity

Ascending order - Click to sort in descending order

Vladislav Vaintroub added a comment - 2018-02-07 17:43

winstone Is your step 1 actually "corrupt" ?

Vladislav Vaintroub added a comment - 2018-02-07 17:43 winstone Is your step 1 actually "corrupt" ?

Vladislav Vaintroub added a comment - 2018-02-15 22:01

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

Vladislav Vaintroub added a comment - 2018-02-15 22:01 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

People

Assignee:: Vladislav Vaintroub

Reporter:: Zdravelina Sokolovska (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 2018-02-07 12:40

Updated:: 2018-02-16 09:41

Resolved:: 2018-02-15 22:01

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server