Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-15234

mariabackup gets corrupted data without issuing errors

    XMLWordPrintable

    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

            Activity

              People

              Assignee:
              wlad Vladislav Vaintroub
              Reporter:
              winstone Zdravelina Sokolovska (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration

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