Galera Node is rejoined with SST after backup - restore with mariabackup

# service mysql stop

[root@t4w5 ~]# rm -rf /var/lib/mysql/*

[root@t4w5 ~]#

[root@t4w5 ~]# mariabackup -u root -p1 --copy-back --galera-info --target-dir /var/mariadb/backup/B1

mariabackup based on MariaDB server 10.3.6-MariaDB Linux (x86_64)

180430 18:25:01 [01] Copying ibdata1 to /var/lib/mysql/ibdata1

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./fi/people.ibd to /var/lib/mysql/fi/people.ibd

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./fi/db.opt to /var/lib/mysql/fi/db.opt

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./fi/people.frm to /var/lib/mysql/fi/people.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysqlslap/ff1.ibd to /var/lib/mysql/mysqlslap/ff1.ibd

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysqlslap/db.opt to /var/lib/mysql/mysqlslap/db.opt

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysqlslap/ff1.frm to /var/lib/mysql/mysqlslap/ff1.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./tpch/nation.ibd to /var/lib/mysql/tpch/nation.ibd

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./tpch/region.ibd to /var/lib/mysql/tpch/region.ibd

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./tpch/part.ibd to /var/lib/mysql/tpch/part.ibd

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./tpch/supplier.ibd to /var/lib/mysql/tpch/supplier.ibd

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./tpch/partsupp.ibd to /var/lib/mysql/tpch/partsupp.ibd

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./tpch/customer.ibd to /var/lib/mysql/tpch/customer.ibd

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./tpch/orders.ibd to /var/lib/mysql/tpch/orders.ibd

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./tpch/lineitem.ibd to /var/lib/mysql/tpch/lineitem.ibd

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./tpch/db.opt to /var/lib/mysql/tpch/db.opt

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./tpch/nation.frm to /var/lib/mysql/tpch/nation.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./tpch/region.frm to /var/lib/mysql/tpch/region.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./tpch/part.frm to /var/lib/mysql/tpch/part.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./tpch/supplier.frm to /var/lib/mysql/tpch/supplier.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./tpch/partsupp.frm to /var/lib/mysql/tpch/partsupp.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./tpch/customer.frm to /var/lib/mysql/tpch/customer.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./tpch/orders.frm to /var/lib/mysql/tpch/orders.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./tpch/lineitem.frm to /var/lib/mysql/tpch/lineitem.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/innodb_table_stats.ibd to /var/lib/mysql/mysql/innodb_table_stats.ibd

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/innodb_index_stats.ibd to /var/lib/mysql/mysql/innodb_index_stats.ibd

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/gtid_slave_pos.ibd to /var/lib/mysql/mysql/gtid_slave_pos.ibd

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/transaction_registry.ibd to /var/lib/mysql/mysql/transaction_registry.ibd

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/func.MYD to /var/lib/mysql/mysql/func.MYD

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/procs_priv.MYD to /var/lib/mysql/mysql/procs_priv.MYD

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/db.MYI to /var/lib/mysql/mysql/db.MYI

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/roles_mapping.frm to /var/lib/mysql/mysql/roles_mapping.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/roles_mapping.MYI to /var/lib/mysql/mysql/roles_mapping.MYI

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/roles_mapping.MYD to /var/lib/mysql/mysql/roles_mapping.MYD

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/tables_priv.MYD to /var/lib/mysql/mysql/tables_priv.MYD

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/servers.frm to /var/lib/mysql/mysql/servers.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/servers.MYI to /var/lib/mysql/mysql/servers.MYI

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/servers.MYD to /var/lib/mysql/mysql/servers.MYD

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/tables_priv.MYI to /var/lib/mysql/mysql/tables_priv.MYI

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/procs_priv.MYI to /var/lib/mysql/mysql/procs_priv.MYI

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/procs_priv.frm to /var/lib/mysql/mysql/procs_priv.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/help_topic.frm to /var/lib/mysql/mysql/help_topic.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/help_topic.MYI to /var/lib/mysql/mysql/help_topic.MYI

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/help_topic.MYD to /var/lib/mysql/mysql/help_topic.MYD

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/help_category.frm to /var/lib/mysql/mysql/help_category.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/help_category.MYI to /var/lib/mysql/mysql/help_category.MYI

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/help_category.MYD to /var/lib/mysql/mysql/help_category.MYD

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/help_relation.frm to /var/lib/mysql/mysql/help_relation.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/help_relation.MYI to /var/lib/mysql/mysql/help_relation.MYI

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/help_relation.MYD to /var/lib/mysql/mysql/help_relation.MYD

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/help_keyword.frm to /var/lib/mysql/mysql/help_keyword.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/help_keyword.MYI to /var/lib/mysql/mysql/help_keyword.MYI

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/help_keyword.MYD to /var/lib/mysql/mysql/help_keyword.MYD

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/time_zone_name.frm to /var/lib/mysql/mysql/time_zone_name.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/time_zone_name.MYI to /var/lib/mysql/mysql/time_zone_name.MYI

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/time_zone_name.MYD to /var/lib/mysql/mysql/time_zone_name.MYD

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/time_zone.frm to /var/lib/mysql/mysql/time_zone.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/time_zone.MYI to /var/lib/mysql/mysql/time_zone.MYI

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/time_zone.MYD to /var/lib/mysql/mysql/time_zone.MYD

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/time_zone_transition.frm to /var/lib/mysql/mysql/time_zone_transition.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/time_zone_transition.MYI to /var/lib/mysql/mysql/time_zone_transition.MYI

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/time_zone_transition.MYD to /var/lib/mysql/mysql/time_zone_transition.MYD

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/time_zone_transition_type.frm to /var/lib/mysql/mysql/time_zone_transition_type.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/time_zone_transition_type.MYI to /var/lib/mysql/mysql/time_zone_transition_type.MYI

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/time_zone_transition_type.MYD to /var/lib/mysql/mysql/time_zone_transition_type.MYD

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/time_zone_leap_second.frm to /var/lib/mysql/mysql/time_zone_leap_second.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/time_zone_leap_second.MYI to /var/lib/mysql/mysql/time_zone_leap_second.MYI

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/time_zone_leap_second.MYD to /var/lib/mysql/mysql/time_zone_leap_second.MYD

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/proc.frm to /var/lib/mysql/mysql/proc.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/general_log.frm to /var/lib/mysql/mysql/general_log.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/general_log.CSM to /var/lib/mysql/mysql/general_log.CSM

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/general_log.CSV to /var/lib/mysql/mysql/general_log.CSV

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/slow_log.frm to /var/lib/mysql/mysql/slow_log.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/slow_log.CSM to /var/lib/mysql/mysql/slow_log.CSM

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/slow_log.CSV to /var/lib/mysql/mysql/slow_log.CSV

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/innodb_table_stats.frm to /var/lib/mysql/mysql/innodb_table_stats.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/innodb_index_stats.frm to /var/lib/mysql/mysql/innodb_index_stats.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/proxies_priv.frm to /var/lib/mysql/mysql/proxies_priv.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/proxies_priv.MYI to /var/lib/mysql/mysql/proxies_priv.MYI

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/proxies_priv.MYD to /var/lib/mysql/mysql/proxies_priv.MYD

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/table_stats.frm to /var/lib/mysql/mysql/table_stats.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/table_stats.MYI to /var/lib/mysql/mysql/table_stats.MYI

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/table_stats.MYD to /var/lib/mysql/mysql/table_stats.MYD

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/column_stats.frm to /var/lib/mysql/mysql/column_stats.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/column_stats.MYI to /var/lib/mysql/mysql/column_stats.MYI

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/column_stats.MYD to /var/lib/mysql/mysql/column_stats.MYD

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/index_stats.frm to /var/lib/mysql/mysql/index_stats.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/index_stats.MYI to /var/lib/mysql/mysql/index_stats.MYI

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/index_stats.MYD to /var/lib/mysql/mysql/index_stats.MYD

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/gtid_slave_pos.frm to /var/lib/mysql/mysql/gtid_slave_pos.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/transaction_registry.frm to /var/lib/mysql/mysql/transaction_registry.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/func.MYI to /var/lib/mysql/mysql/func.MYI

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/proc.MYI to /var/lib/mysql/mysql/proc.MYI

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/db.MYD to /var/lib/mysql/mysql/db.MYD

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/plugin.MYI to /var/lib/mysql/mysql/plugin.MYI

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/host.frm to /var/lib/mysql/mysql/host.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/columns_priv.MYI to /var/lib/mysql/mysql/columns_priv.MYI

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/event.MYD to /var/lib/mysql/mysql/event.MYD

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/plugin.MYD to /var/lib/mysql/mysql/plugin.MYD

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/columns_priv.MYD to /var/lib/mysql/mysql/columns_priv.MYD

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/event.MYI to /var/lib/mysql/mysql/event.MYI

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/event.frm to /var/lib/mysql/mysql/event.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/user.MYD to /var/lib/mysql/mysql/user.MYD

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/columns_priv.frm to /var/lib/mysql/mysql/columns_priv.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/host.MYD to /var/lib/mysql/mysql/host.MYD

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/tables_priv.frm to /var/lib/mysql/mysql/tables_priv.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/db.frm to /var/lib/mysql/mysql/db.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/user.MYI to /var/lib/mysql/mysql/user.MYI

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/user.frm to /var/lib/mysql/mysql/user.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/func.frm to /var/lib/mysql/mysql/func.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/plugin.frm to /var/lib/mysql/mysql/plugin.frm

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/host.MYI to /var/lib/mysql/mysql/host.MYI

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./mysql/proc.MYD to /var/lib/mysql/mysql/proc.MYD

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./boxoffice_mdb/dim_date.ibd to /var/lib/mysql/boxoffice_mdb/dim_date.ibd

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./boxoffice_mdb/dim_person.ibd to /var/lib/mysql/boxoffice_mdb/dim_person.ibd

180430 18:25:02 [01]        ...done

180430 18:25:02 [01] Copying ./boxoffice_mdb/dim_showtime.ibd to /var/lib/mysql/boxoffice_mdb/dim_showtime.ibd

180430 18:25:03 [01]        ...done

180430 18:25:03 [01] Copying ./boxoffice_mdb/dim_theater.ibd to /var/lib/mysql/boxoffice_mdb/dim_theater.ibd

180430 18:25:03 [01]        ...done

180430 18:25:03 [01] Copying ./boxoffice_mdb/dim_theater_mdc.ibd to /var/lib/mysql/boxoffice_mdb/dim_theater_mdc.ibd

180430 18:25:03 [01]        ...done

180430 18:25:03 [01] Copying ./boxoffice_mdb/dim_ticket_type.ibd to /var/lib/mysql/boxoffice_mdb/dim_ticket_type.ibd

180430 18:25:03 [01]        ...done

180430 18:25:03 [01] Copying ./boxoffice_mdb/dim_title.ibd to /var/lib/mysql/boxoffice_mdb/dim_title.ibd

180430 18:25:03 [01]        ...done

180430 18:25:03 [01] Copying ./boxoffice_mdb/fact_crew.ibd to /var/lib/mysql/boxoffice_mdb/fact_crew.ibd

180430 18:25:04 [01]        ...done

180430 18:25:04 [01] Copying ./boxoffice_mdb/fact_tickets.ibd to /var/lib/mysql/boxoffice_mdb/fact_tickets.ibd

180430 18:25:08 [01]        ...done

180430 18:25:08 [01] Copying ./boxoffice_mdb/db.opt to /var/lib/mysql/boxoffice_mdb/db.opt

180430 18:25:08 [01]        ...done

180430 18:25:08 [01] Copying ./boxoffice_mdb/dim_date.frm to /var/lib/mysql/boxoffice_mdb/dim_date.frm

180430 18:25:08 [01]        ...done

180430 18:25:08 [01] Copying ./boxoffice_mdb/dim_person.frm to /var/lib/mysql/boxoffice_mdb/dim_person.frm

180430 18:25:08 [01]        ...done

180430 18:25:08 [01] Copying ./boxoffice_mdb/dim_showtime.frm to /var/lib/mysql/boxoffice_mdb/dim_showtime.frm

180430 18:25:08 [01]        ...done

180430 18:25:08 [01] Copying ./boxoffice_mdb/dim_theater.frm to /var/lib/mysql/boxoffice_mdb/dim_theater.frm

180430 18:25:08 [01]        ...done

180430 18:25:08 [01] Copying ./boxoffice_mdb/dim_theater_mdc.frm to /var/lib/mysql/boxoffice_mdb/dim_theater_mdc.frm

180430 18:25:08 [01]        ...done

180430 18:25:08 [01] Copying ./boxoffice_mdb/dim_ticket_type.frm to /var/lib/mysql/boxoffice_mdb/dim_ticket_type.frm

180430 18:25:08 [01]        ...done

180430 18:25:08 [01] Copying ./boxoffice_mdb/dim_title.frm to /var/lib/mysql/boxoffice_mdb/dim_title.frm

180430 18:25:08 [01]        ...done

180430 18:25:08 [01] Copying ./boxoffice_mdb/fact_crew.frm to /var/lib/mysql/boxoffice_mdb/fact_crew.frm

180430 18:25:08 [01]        ...done

180430 18:25:08 [01] Copying ./boxoffice_mdb/fact_tickets.frm to /var/lib/mysql/boxoffice_mdb/fact_tickets.frm

180430 18:25:08 [01]        ...done

180430 18:25:08 [01] Copying ./sbtest/sbtest1.ibd to /var/lib/mysql/sbtest/sbtest1.ibd

180430 18:25:09 [01]        ...done

180430 18:25:09 [01] Copying ./sbtest/sbtest10.ibd to /var/lib/mysql/sbtest/sbtest10.ibd

180430 18:25:10 [01]        ...done

180430 18:25:10 [01] Copying ./sbtest/sbtest2.ibd to /var/lib/mysql/sbtest/sbtest2.ibd

180430 18:25:10 [01]        ...done

180430 18:25:10 [01] Copying ./sbtest/sbtest3.ibd to /var/lib/mysql/sbtest/sbtest3.ibd

180430 18:25:11 [01]        ...done

180430 18:25:11 [01] Copying ./sbtest/sbtest4.ibd to /var/lib/mysql/sbtest/sbtest4.ibd

180430 18:25:12 [01]        ...done

180430 18:25:12 [01] Copying ./sbtest/sbtest5.ibd to /var/lib/mysql/sbtest/sbtest5.ibd

180430 18:25:13 [01]        ...done

180430 18:25:13 [01] Copying ./sbtest/sbtest6.ibd to /var/lib/mysql/sbtest/sbtest6.ibd

180430 18:25:13 [01]        ...done

180430 18:25:13 [01] Copying ./sbtest/sbtest7.ibd to /var/lib/mysql/sbtest/sbtest7.ibd

180430 18:25:15 [01]        ...done

180430 18:25:15 [01] Copying ./sbtest/sbtest8.ibd to /var/lib/mysql/sbtest/sbtest8.ibd

180430 18:25:16 [01]        ...done

180430 18:25:16 [01] Copying ./sbtest/sbtest9.ibd to /var/lib/mysql/sbtest/sbtest9.ibd

180430 18:25:17 [01]        ...done

180430 18:25:17 [01] Copying ./sbtest/db.opt to /var/lib/mysql/sbtest/db.opt

180430 18:25:17 [01]        ...done

180430 18:25:17 [01] Copying ./sbtest/sbtest1.frm to /var/lib/mysql/sbtest/sbtest1.frm

180430 18:25:17 [01]        ...done

180430 18:25:17 [01] Copying ./sbtest/sbtest10.frm to /var/lib/mysql/sbtest/sbtest10.frm

180430 18:25:17 [01]        ...done

180430 18:25:17 [01] Copying ./sbtest/sbtest2.frm to /var/lib/mysql/sbtest/sbtest2.frm

180430 18:25:17 [01]        ...done

180430 18:25:17 [01] Copying ./sbtest/sbtest3.frm to /var/lib/mysql/sbtest/sbtest3.frm

180430 18:25:17 [01]        ...done

180430 18:25:17 [01] Copying ./sbtest/sbtest4.frm to /var/lib/mysql/sbtest/sbtest4.frm

180430 18:25:17 [01]        ...done

180430 18:25:17 [01] Copying ./sbtest/sbtest5.frm to /var/lib/mysql/sbtest/sbtest5.frm

180430 18:25:17 [01]        ...done

180430 18:25:17 [01] Copying ./sbtest/sbtest6.frm to /var/lib/mysql/sbtest/sbtest6.frm

180430 18:25:17 [01]        ...done

180430 18:25:17 [01] Copying ./sbtest/sbtest7.frm to /var/lib/mysql/sbtest/sbtest7.frm

180430 18:25:17 [01]        ...done

180430 18:25:17 [01] Copying ./sbtest/sbtest8.frm to /var/lib/mysql/sbtest/sbtest8.frm

180430 18:25:17 [01]        ...done

180430 18:25:17 [01] Copying ./sbtest/sbtest9.frm to /var/lib/mysql/sbtest/sbtest9.frm

180430 18:25:17 [01]        ...done

180430 18:25:17 [01] Copying ./resourcestresser/cputable.ibd to /var/lib/mysql/resourcestresser/cputable.ibd

180430 18:25:17 [01]        ...done

180430 18:25:17 [01] Copying ./resourcestresser/iotable.ibd to /var/lib/mysql/resourcestresser/iotable.ibd

180430 18:25:17 [01]        ...done

180430 18:25:17 [01] Copying ./resourcestresser/iotablesmallrow.ibd to /var/lib/mysql/resourcestresser/iotablesmallrow.ibd

180430 18:25:17 [01]        ...done

180430 18:25:17 [01] Copying ./resourcestresser/locktable.ibd to /var/lib/mysql/resourcestresser/locktable.ibd

180430 18:25:17 [01]        ...done

180430 18:25:17 [01] Copying ./resourcestresser/db.opt to /var/lib/mysql/resourcestresser/db.opt

180430 18:25:17 [01]        ...done

180430 18:25:17 [01] Copying ./resourcestresser/cputable.frm to /var/lib/mysql/resourcestresser/cputable.frm

180430 18:25:17 [01]        ...done

180430 18:25:17 [01] Copying ./resourcestresser/iotable.frm to /var/lib/mysql/resourcestresser/iotable.frm

180430 18:25:17 [01]        ...done

180430 18:25:17 [01] Copying ./resourcestresser/iotablesmallrow.frm to /var/lib/mysql/resourcestresser/iotablesmallrow.frm

180430 18:25:17 [01]        ...done

180430 18:25:17 [01] Copying ./resourcestresser/locktable.frm to /var/lib/mysql/resourcestresser/locktable.frm

180430 18:25:17 [01]        ...done

180430 18:25:17 [01] Copying ./md_15252/BRc273a13dfd.ibd to /var/lib/mysql/md_15252/BRc273a13dfd.ibd

180430 18:25:17 [01]        ...done

180430 18:25:17 [01] Copying ./md_15252/CA9176ed2945.ibd to /var/lib/mysql/md_15252/CA9176ed2945.ibd

180430 18:25:21 [01]        ...done

180430 18:25:21 [01] Copying ./md_15252/CA24ade621e4.ibd to /var/lib/mysql/md_15252/CA24ade621e4.ibd

180430 18:25:21 [01]        ...done

180430 18:25:21 [01] Copying ./md_15252/DAc955f09819.ibd to /var/lib/mysql/md_15252/DAc955f09819.ibd

180430 18:25:21 [01]        ...done

180430 18:25:21 [01] Copying ./md_15252/DAebf122c2a3.ibd to /var/lib/mysql/md_15252/DAebf122c2a3.ibd

180430 18:25:21 [01]        ...done

180430 18:25:21 [01] Copying ./md_15252/OP3605a09ed5.ibd to /var/lib/mysql/md_15252/OP3605a09ed5.ibd

180430 18:25:21 [01]        ...done

180430 18:25:21 [01] Copying ./md_15252/PR03645fd534.ibd to /var/lib/mysql/md_15252/PR03645fd534.ibd

180430 18:25:21 [01]        ...done

180430 18:25:21 [01] Copying ./md_15252/VA13db63946f.ibd to /var/lib/mysql/md_15252/VA13db63946f.ibd

180430 18:25:21 [01]        ...done

180430 18:25:21 [01] Copying ./md_15252/db.opt to /var/lib/mysql/md_15252/db.opt

180430 18:25:21 [01]        ...done

180430 18:25:21 [01] Copying ./md_15252/BRc273a13dfd.frm to /var/lib/mysql/md_15252/BRc273a13dfd.frm

180430 18:25:21 [01]        ...done

180430 18:25:21 [01] Copying ./md_15252/CA9176ed2945.frm to /var/lib/mysql/md_15252/CA9176ed2945.frm

180430 18:25:21 [01]        ...done

180430 18:25:21 [01] Copying ./md_15252/CA24ade621e4.frm to /var/lib/mysql/md_15252/CA24ade621e4.frm

180430 18:25:21 [01]        ...done

180430 18:25:21 [01] Copying ./md_15252/DAc955f09819.frm to /var/lib/mysql/md_15252/DAc955f09819.frm

180430 18:25:21 [01]        ...done

180430 18:25:21 [01] Copying ./md_15252/DAebf122c2a3.frm to /var/lib/mysql/md_15252/DAebf122c2a3.frm

180430 18:25:21 [01]        ...done

180430 18:25:21 [01] Copying ./md_15252/OP3605a09ed5.frm to /var/lib/mysql/md_15252/OP3605a09ed5.frm

180430 18:25:21 [01]        ...done

180430 18:25:21 [01] Copying ./md_15252/PR03645fd534.frm to /var/lib/mysql/md_15252/PR03645fd534.frm

180430 18:25:21 [01]        ...done

180430 18:25:21 [01] Copying ./md_15252/VA13db63946f.frm to /var/lib/mysql/md_15252/VA13db63946f.frm

180430 18:25:21 [01]        ...done

180430 18:25:21 [01] Copying ./test/db.opt to /var/lib/mysql/test/db.opt

180430 18:25:21 [01]        ...done

180430 18:25:21 [01] Copying ./tpch1/db.opt to /var/lib/mysql/tpch1/db.opt

180430 18:25:21 [01]        ...done

180430 18:25:21 [01] Copying ./performance_schema/db.opt to /var/lib/mysql/performance_schema/db.opt

180430 18:25:21 [01]        ...done

180430 18:25:21 [01] Copying ./ffr/db.opt to /var/lib/mysql/ffr/db.opt

180430 18:25:21 [01]        ...done

180430 18:25:21 [01] Copying ./ffr/f.MYI to /var/lib/mysql/ffr/f.MYI

180430 18:25:21 [01]        ...done

180430 18:25:21 [01] Copying ./ffr/f.MYD to /var/lib/mysql/ffr/f.MYD

180430 18:25:21 [01]        ...done

180430 18:25:21 [01] Copying ./ffr/f.frm to /var/lib/mysql/ffr/f.frm

180430 18:25:21 [01]        ...done

180430 18:25:21 [01] Copying ./aria_log_control to /var/lib/mysql/aria_log_control

180430 18:25:21 [01]        ...done

180430 18:25:21 [01] Copying ./aria_log.00000001 to /var/lib/mysql/aria_log.00000001

180430 18:25:21 [01]        ...done

180430 18:25:21 [01] Copying ./xtrabackup_galera_info to /var/lib/mysql/xtrabackup_galera_info

180430 18:25:21 [01]        ...done

180430 18:25:21 [01] Copying ./ib_buffer_pool to /var/lib/mysql/ib_buffer_pool

180430 18:25:21 [01]        ...done

180430 18:25:21 [01] Copying ./xtrabackup_info to /var/lib/mysql/xtrabackup_info

180430 18:25:21 [01]        ...done

180430 18:25:21 [01] Copying ./xtrabackup_binlog_pos_innodb to /var/lib/mysql/xtrabackup_binlog_pos_innodb

180430 18:25:21 [01]        ...done

180430 18:25:21 completed OK!

018-04-30 18:29:46 0 [Note] WSREP: Read nil XID from storage engines, skipping position init

2018-04-30 18:29:46 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/lib64/galera/libgalera_smm.so'

2018-04-30 18:29:46 0 [Note] WSREP: wsrep_load(): Galera 25.3.22(r3764) by Codership Oy <info@codership.com> loaded successfully.

2018-04-30 18:29:46 0 [Note] WSREP: CRC-32C: using "slicing-by-8" algorithm.

2018-04-30 18:29:46 0 [Warning] WSREP: Could not open state file for reading: '/var/lib/mysql//grastate.dat'

2018-04-30 18:29:46 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 1

2018-04-30 18:29:46 0 [Note] WSREP: Passing config to GCS: base_dir = /var/lib/mysql/; base_host = 192.168.104.195; base_port = 4567; cert.log_conflicts = no; debug = no; evs.auto_evict = 0; evs.delay_margin = PT1S; evs.delayed_keep_period = PT30S; evs.inactive_check_period = PT0.5S; evs.inactive_timeout = PT15S; evs.join_retrans_period = PT1S; evs.max_install_timeouts = 3; evs.send_window = 4; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 2; evs.view_forget_timeout = PT24H; gcache.dir = /var/lib/mysql/; gcache.keep_pages_size = 0; gcache.mem_size = 0; gcache.name = /var/lib/mysql//galera.cache; gcache.page_size = 128M; gcache.recover = no; gcache.size = 128M; gcomm.thread_prio = ; gcs.fc_debug = 0; gcs.fc_factor = 1.0; gcs.fc_limit = 16; gcs.fc_master_slave = no; gcs.max_packet_size = 64500; gcs.max_throttle = 0.25; gcs.recv_q_hard_limit = 9223372036854775807; gcs.recv_q_soft_limit = 0.25; gcs.sync_donor = no; gmcast.segment = 0; gmcast.version = 0; pc.announce_timeout = PT3S; pc.checksum = false; p

2018-04-30 18:29:46 0 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> 00000000-0000-0000-0000-000000000000:-1

2018-04-30 18:29:46 0 [Note] WSREP: Assign initial position for certification: -1, protocol version: -1

2018-04-30 18:29:46 0 [Note] WSREP: wsrep_sst_grab()

2018-04-30 18:29:46 0 [Note] WSREP: Start replication

2018-04-30 18:29:46 0 [Note] WSREP: Setting initial position to 00000000-0000-0000-0000-000000000000:-1

2018-04-30 18:29:46 0 [Note] WSREP: protonet asio version 0

2018-04-30 18:29:46 0 [Note] WSREP: Using CRC-32C for message checksums.

2018-04-30 18:29:46 0 [Note] WSREP: backend: asio

2018-04-30 18:29:46 0 [Note] WSREP: gcomm thread scheduling priority set to other:0

2018-04-30 18:29:46 0 [Warning] WSREP: access file(/var/lib/mysql//gvwstate.dat) failed(No such file or directory)

2018-04-30 18:29:46 0 [Note] WSREP: restore pc from disk failed

2018-04-30 18:29:46 0 [Note] WSREP: GMCast version 0

2018-04-30 18:29:46 0 [Note] WSREP: (5053de41, 'tcp://0.0.0.0:4567') listening at tcp://0.0.0.0:4567

2018-04-30 18:29:46 0 [Note] WSREP: (5053de41, 'tcp://0.0.0.0:4567') multicast: , ttl: 1

2018-04-30 18:29:46 0 [Note] WSREP: EVS version 0

2018-04-30 18:29:46 0 [Note] WSREP: gcomm: connecting to group 'cluster1', peer '192.168.104.191:,192.168.104.195:,192.168.104.196:'

2018-04-30 18:29:46 0 [Note] WSREP: (5053de41, 'tcp://0.0.0.0:4567') connection established to 5053de41 tcp://192.168.104.195:4567

2018-04-30 18:29:46 0 [Warning] WSREP: (5053de41, 'tcp://0.0.0.0:4567') address 'tcp://192.168.104.195:4567' points to own listening address, blacklisting

2018-04-30 18:29:46 0 [Note] WSREP: (5053de41, 'tcp://0.0.0.0:4567') connection established to 6eedf2b3 tcp://192.168.104.196:4567

2018-04-30 18:29:46 0 [Note] WSREP: (5053de41, 'tcp://0.0.0.0:4567') turning message relay requesting on, nonlive peers: tcp://192.168.104.191:4444

2018-04-30 18:29:46 0 [Note] WSREP: (5053de41, 'tcp://0.0.0.0:4567') connection established to 675af5b8 tcp://192.168.104.191:4444

2018-04-30 18:29:47 0 [Note] WSREP: declaring 675af5b8 at tcp://192.168.104.191:4444 stable

2018-04-30 18:29:47 0 [Note] WSREP: declaring 6eedf2b3 at tcp://192.168.104.196:4567 stable

2018-04-30 18:29:47 0 [Note] WSREP: Node 675af5b8 state prim

2018-04-30 18:29:47 0 [Note] WSREP: view(view_id(PRIM,5053de41,97) memb {

        5053de41,0

        675af5b8,0

        6eedf2b3,0

} joined {

} left {

} partitioned {

})

2018-04-30 18:29:47 0 [Note] WSREP: save pc into disk

2018-04-30 18:29:47 0 [Note] WSREP: discarding pending addr without UUID: tcp://192.168.104.191:4567

2018-04-30 18:29:47 0 [Note] WSREP: gcomm: connected

2018-04-30 18:29:47 0 [Note] WSREP: Changing maximum packet size to 64500, resulting msg size: 32636

2018-04-30 18:29:47 0 [Note] WSREP: Shifting CLOSED -> OPEN (TO: 0)

2018-04-30 18:29:47 0 [Note] WSREP: Opened channel 'cluster1'

2018-04-30 18:29:47 0 [Note] WSREP: New COMPONENT: primary = yes, bootstrap = no, my_idx = 0, memb_num = 3

2018-04-30 18:29:47 0 [Note] WSREP: Waiting for SST to complete.

2018-04-30 18:29:47 0 [Note] WSREP: STATE_EXCHANGE: sent state UUID: 50ed0bfa-4c8b-11e8-aa6e-fbebb04cdd70

2018-04-30 18:29:47 0 [Note] WSREP: STATE EXCHANGE: sent state msg: 50ed0bfa-4c8b-11e8-aa6e-fbebb04cdd70

2018-04-30 18:29:47 0 [Note] WSREP: STATE EXCHANGE: got state msg: 50ed0bfa-4c8b-11e8-aa6e-fbebb04cdd70 from 0 (t4w5)

2018-04-30 18:29:47 0 [Note] WSREP: STATE EXCHANGE: got state msg: 50ed0bfa-4c8b-11e8-aa6e-fbebb04cdd70 from 1 (garb)

2018-04-30 18:29:47 0 [Note] WSREP: STATE EXCHANGE: got state msg: 50ed0bfa-4c8b-11e8-aa6e-fbebb04cdd70 from 2 (t4w6)

2018-04-30 18:29:47 0 [Note] WSREP: Quorum results:

        version    = 4,

        component  = PRIMARY,

        conf_id    = 96,

        members    = 2/3 (joined/total),

        act_id     = 137764,

        last_appl. = -1,

        protocols  = 0/7/3 (gcs/repl/appl),

        group UUID = b4c974d2-49fe-11e8-b950-9b4c947b49f6

2018-04-30 18:29:47 0 [Note] WSREP: Flow-control interval: [28, 28]

2018-04-30 18:29:47 0 [Note] WSREP: Trying to continue unpaused monitor

2018-04-30 18:29:47 0 [Note] WSREP: Shifting OPEN -> PRIMARY (TO: 137764)

2018-04-30 18:29:47 2 [Note] WSREP: State transfer required:

        Group state: b4c974d2-49fe-11e8-b950-9b4c947b49f6:137764

        Local state: 00000000-0000-0000-0000-000000000000:-1

2018-04-30 18:29:47 2 [Note] WSREP: New cluster view: global state: b4c974d2-49fe-11e8-b950-9b4c947b49f6:137764, view# 97: Primary, number of nodes: 3, my index: 0, protocol version 3

2018-04-30 18:29:47 2 [Warning] WSREP: Gap in state sequence. Need state transfer.

2018-04-30 18:29:47 0 [Note] WSREP: Running: 'wsrep_sst_mariabackup --role 'joiner' --address '192.168.104.195' --datadir '/var/lib/mysql/'   --parent '436'  '' '

WSREP_SST: [INFO] Streaming with xbstream (20180430 18:29:48.014)

WSREP_SST: [INFO] Using socat as streamer (20180430 18:29:48.017)

WSREP_SST: [INFO] Evaluating timeout -k 110 100 socat -u TCP-LISTEN:4444,reuseaddr stdio | pv -f  -i 10 -N joiner -F '%N => Rate:%r Avg:%a Elapsed:%t %e Bytes: %b %p'  | mbstream -x; RC=( ${PIPESTATUS[@]} ) (20180430 18:29:48.074)

2018-04-30 18:29:48 2 [Note] WSREP: Prepared SST request: mariabackup|192.168.104.195:4444/xtrabackup_sst//1

2018-04-30 18:29:48 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.

2018-04-30 18:29:48 2 [Note] WSREP: REPL Protocols: 7 (3, 2)

2018-04-30 18:29:48 2 [Note] WSREP: Assign initial position for certification: 137764, protocol version: 3

2018-04-30 18:29:48 0 [Note] WSREP: Service thread queue flushed.

2018-04-30 18:29:48 2 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (b4c974d2-49fe-11e8-b950-9b4c947b49f6): 1 (Operation not permitted)

         at galera/src/replicator_str.cpp:prepare_for_IST():482. IST will be unavailable.

2018-04-30 18:29:48 0 [Note] WSREP: Member 0.0 (t4w5) requested state transfer from '*any*'. Selected 2.0 (t4w6)(SYNCED) as donor.

2018-04-30 18:29:48 0 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 137764)

2018-04-30 18:29:48 2 [Note] WSREP: Requesting state transfer: success, donor: 2

2018-04-30 18:29:48 2 [Note] WSREP: GCache history reset: 00000000-0000-0000-0000-000000000000:0 -> b4c974d2-49fe-11e8-b950-9b4c947b49f6:137764

   joiner: => Rate:[ 215 B/s] Avg:[ 215 B/s] Elapsed:0:00:00

WSREP_SST: [INFO] NOTE: Joiner-Recv-gtid took 0 seconds (20180430 18:29:48.725)

WSREP_SST: [INFO] Proceeding with SST (20180430 18:29:48.742)

WSREP_SST: [INFO] Evaluating socat -u TCP-LISTEN:4444,reuseaddr stdio | pv -f  -i 10 -N joiner -F '%N => Rate:%r Avg:%a Elapsed:%t %e Bytes: %b %p'  | mbstream -x; RC=( ${PIPESTATUS[@]} ) (20180430 18:29:48.745)

WSREP_SST: [INFO] Cleaning the existing datadir and innodb-data/log directories (20180430 18:29:48.747)

removed ‘/var/lib/mysql/ibdata1’

removed ‘/var/lib/mysql/fi/people.ibd’

removed ‘/var/lib/mysql/fi/db.opt’

removed ‘/var/lib/mysql/fi/people.frm’

removed directory: ‘/var/lib/mysql/fi’

removed ‘/var/lib/mysql/mysqlslap/ff1.ibd’

removed ‘/var/lib/mysql/mysqlslap/db.opt’

removed ‘/var/lib/mysql/mysqlslap/ff1.frm’

removed directory: ‘/var/lib/mysql/mysqlslap’

removed ‘/var/lib/mysql/tpch/nation.ibd’

removed ‘/var/lib/mysql/tpch/region.ibd’

removed ‘/var/lib/mysql/tpch/part.ibd’

removed ‘/var/lib/mysql/tpch/supplier.ibd’

removed ‘/var/lib/mysql/tpch/partsupp.ibd’

removed ‘/var/lib/mysql/tpch/customer.ibd’

removed ‘/var/lib/mysql/tpch/orders.ibd’

removed ‘/var/lib/mysql/tpch/lineitem.ibd’

removed ‘/var/lib/mysql/tpch/db.opt’

removed ‘/var/lib/mysql/tpch/nation.frm’

removed ‘/var/lib/mysql/tpch/region.frm’

removed ‘/var/lib/mysql/tpch/part.frm’

removed ‘/var/lib/mysql/tpch/supplier.frm’

removed ‘/var/lib/mysql/tpch/partsupp.frm’

removed ‘/var/lib/mysql/tpch/customer.frm’

removed ‘/var/lib/mysql/tpch/orders.frm’

removed ‘/var/lib/mysql/tpch/lineitem.frm’

removed directory: ‘/var/lib/mysql/tpch’

removed ‘/var/lib/mysql/mysql/innodb_table_stats.ibd’

removed ‘/var/lib/mysql/mysql/innodb_index_stats.ibd’

removed ‘/var/lib/mysql/mysql/gtid_slave_pos.ibd’

removed ‘/var/lib/mysql/mysql/transaction_registry.ibd’

removed ‘/var/lib/mysql/mysql/func.MYD’

removed ‘/var/lib/mysql/mysql/procs_priv.MYD’

removed ‘/var/lib/mysql/mysql/db.MYI’

removed ‘/var/lib/mysql/mysql/roles_mapping.frm’

removed ‘/var/lib/mysql/mysql/roles_mapping.MYI’

removed ‘/var/lib/mysql/mysql/roles_mapping.MYD’

removed ‘/var/lib/mysql/mysql/tables_priv.MYD’

removed ‘/var/lib/mysql/mysql/servers.frm’

removed ‘/var/lib/mysql/mysql/servers.MYI’

removed ‘/var/lib/mysql/mysql/servers.MYD’

removed ‘/var/lib/mysql/mysql/tables_priv.MYI’

removed ‘/var/lib/mysql/mysql/procs_priv.MYI’

removed ‘/var/lib/mysql/mysql/procs_priv.frm’

removed ‘/var/lib/mysql/mysql/help_topic.frm’

removed ‘/var/lib/mysql/mysql/help_topic.MYI’

removed ‘/var/lib/mysql/mysql/help_topic.MYD’

removed ‘/var/lib/mysql/mysql/help_category.frm’

removed ‘/var/lib/mysql/mysql/help_category.MYI’

removed ‘/var/lib/mysql/mysql/help_category.MYD’

removed ‘/var/lib/mysql/mysql/help_relation.frm’

removed ‘/var/lib/mysql/mysql/help_relation.MYI’

removed ‘/var/lib/mysql/mysql/help_relation.MYD’

removed ‘/var/lib/mysql/mysql/help_keyword.frm’

removed ‘/var/lib/mysql/mysql/help_keyword.MYI’

removed ‘/var/lib/mysql/mysql/help_keyword.MYD’

removed ‘/var/lib/mysql/mysql/time_zone_name.frm’

removed ‘/var/lib/mysql/mysql/time_zone_name.MYI’

removed ‘/var/lib/mysql/mysql/time_zone_name.MYD’

removed ‘/var/lib/mysql/mysql/time_zone.frm’

removed ‘/var/lib/mysql/mysql/time_zone.MYI’

removed ‘/var/lib/mysql/mysql/time_zone.MYD’

removed ‘/var/lib/mysql/mysql/time_zone_transition.frm’

removed ‘/var/lib/mysql/mysql/time_zone_transition.MYI’

removed ‘/var/lib/mysql/mysql/time_zone_transition.MYD’

removed ‘/var/lib/mysql/mysql/time_zone_transition_type.frm’

removed ‘/var/lib/mysql/mysql/time_zone_transition_type.MYI’

removed ‘/var/lib/mysql/mysql/time_zone_transition_type.MYD’

removed ‘/var/lib/mysql/mysql/time_zone_leap_second.frm’

removed ‘/var/lib/mysql/mysql/time_zone_leap_second.MYI’

removed ‘/var/lib/mysql/mysql/time_zone_leap_second.MYD’

removed ‘/var/lib/mysql/mysql/proc.frm’

removed ‘/var/lib/mysql/mysql/general_log.frm’

removed ‘/var/lib/mysql/mysql/general_log.CSM’

removed ‘/var/lib/mysql/mysql/general_log.CSV’

removed ‘/var/lib/mysql/mysql/slow_log.frm’

removed ‘/var/lib/mysql/mysql/slow_log.CSM’

removed ‘/var/lib/mysql/mysql/slow_log.CSV’

removed ‘/var/lib/mysql/mysql/innodb_table_stats.frm’

removed ‘/var/lib/mysql/mysql/innodb_index_stats.frm’

removed ‘/var/lib/mysql/mysql/proxies_priv.frm’

removed ‘/var/lib/mysql/mysql/proxies_priv.MYI’

removed ‘/var/lib/mysql/mysql/proxies_priv.MYD’

removed ‘/var/lib/mysql/mysql/table_stats.frm’

removed ‘/var/lib/mysql/mysql/table_stats.MYI’

removed ‘/var/lib/mysql/mysql/table_stats.MYD’

removed ‘/var/lib/mysql/mysql/column_stats.frm’

removed ‘/var/lib/mysql/mysql/column_stats.MYI’

removed ‘/var/lib/mysql/mysql/column_stats.MYD’

removed ‘/var/lib/mysql/mysql/index_stats.frm’

removed ‘/var/lib/mysql/mysql/index_stats.MYI’

removed ‘/var/lib/mysql/mysql/index_stats.MYD’

removed ‘/var/lib/mysql/mysql/gtid_slave_pos.frm’

removed ‘/var/lib/mysql/mysql/transaction_registry.frm’

removed ‘/var/lib/mysql/mysql/func.MYI’

removed ‘/var/lib/mysql/mysql/proc.MYI’

removed ‘/var/lib/mysql/mysql/db.MYD’

removed ‘/var/lib/mysql/mysql/plugin.MYI’

removed ‘/var/lib/mysql/mysql/host.frm’

removed ‘/var/lib/mysql/mysql/columns_priv.MYI’

removed ‘/var/lib/mysql/mysql/event.MYD’

removed ‘/var/lib/mysql/mysql/plugin.MYD’

removed ‘/var/lib/mysql/mysql/columns_priv.MYD’

removed ‘/var/lib/mysql/mysql/event.MYI’

removed ‘/var/lib/mysql/mysql/event.frm’

removed ‘/var/lib/mysql/mysql/user.MYD’

removed ‘/var/lib/mysql/mysql/columns_priv.frm’

removed ‘/var/lib/mysql/mysql/host.MYD’

removed ‘/var/lib/mysql/mysql/tables_priv.frm’

removed ‘/var/lib/mysql/mysql/db.frm’

removed ‘/var/lib/mysql/mysql/user.MYI’

removed ‘/var/lib/mysql/mysql/user.frm’

removed ‘/var/lib/mysql/mysql/func.frm’

removed ‘/var/lib/mysql/mysql/plugin.frm’

removed ‘/var/lib/mysql/mysql/host.MYI’

removed ‘/var/lib/mysql/mysql/proc.MYD’

removed directory: ‘/var/lib/mysql/mysql’

removed ‘/var/lib/mysql/boxoffice_mdb/dim_date.ibd’

removed ‘/var/lib/mysql/boxoffice_mdb/dim_person.ibd’

removed ‘/var/lib/mysql/boxoffice_mdb/dim_showtime.ibd’

removed ‘/var/lib/mysql/boxoffice_mdb/dim_theater.ibd’

removed ‘/var/lib/mysql/boxoffice_mdb/dim_theater_mdc.ibd’

removed ‘/var/lib/mysql/boxoffice_mdb/dim_ticket_type.ibd’

removed ‘/var/lib/mysql/boxoffice_mdb/dim_title.ibd’

removed ‘/var/lib/mysql/boxoffice_mdb/fact_crew.ibd’

removed ‘/var/lib/mysql/boxoffice_mdb/fact_tickets.ibd’

removed ‘/var/lib/mysql/boxoffice_mdb/db.opt’

removed ‘/var/lib/mysql/boxoffice_mdb/dim_date.frm’

removed ‘/var/lib/mysql/boxoffice_mdb/dim_person.frm’

removed ‘/var/lib/mysql/boxoffice_mdb/dim_showtime.frm’

removed ‘/var/lib/mysql/boxoffice_mdb/dim_theater.frm’

removed ‘/var/lib/mysql/boxoffice_mdb/dim_theater_mdc.frm’

removed ‘/var/lib/mysql/boxoffice_mdb/dim_ticket_type.frm’

removed ‘/var/lib/mysql/boxoffice_mdb/dim_title.frm’

removed ‘/var/lib/mysql/boxoffice_mdb/fact_crew.frm’

removed ‘/var/lib/mysql/boxoffice_mdb/fact_tickets.frm’

removed directory: ‘/var/lib/mysql/boxoffice_mdb’

removed ‘/var/lib/mysql/sbtest/sbtest1.ibd’

removed ‘/var/lib/mysql/sbtest/sbtest10.ibd’

removed ‘/var/lib/mysql/sbtest/sbtest2.ibd’

removed ‘/var/lib/mysql/sbtest/sbtest3.ibd’

removed ‘/var/lib/mysql/sbtest/sbtest4.ibd’

removed ‘/var/lib/mysql/sbtest/sbtest5.ibd’

removed ‘/var/lib/mysql/sbtest/sbtest6.ibd’

removed ‘/var/lib/mysql/sbtest/sbtest7.ibd’

removed ‘/var/lib/mysql/sbtest/sbtest8.ibd’

removed ‘/var/lib/mysql/sbtest/sbtest9.ibd’

removed ‘/var/lib/mysql/sbtest/db.opt’

removed ‘/var/lib/mysql/sbtest/sbtest1.frm’

removed ‘/var/lib/mysql/sbtest/sbtest10.frm’

removed ‘/var/lib/mysql/sbtest/sbtest2.frm’

removed ‘/var/lib/mysql/sbtest/sbtest3.frm’

removed ‘/var/lib/mysql/sbtest/sbtest4.frm’

removed ‘/var/lib/mysql/sbtest/sbtest5.frm’

removed ‘/var/lib/mysql/sbtest/sbtest6.frm’

removed ‘/var/lib/mysql/sbtest/sbtest7.frm’

removed ‘/var/lib/mysql/sbtest/sbtest8.frm’

removed ‘/var/lib/mysql/sbtest/sbtest9.frm’

removed directory: ‘/var/lib/mysql/sbtest’

removed ‘/var/lib/mysql/resourcestresser/cputable.ibd’

removed ‘/var/lib/mysql/resourcestresser/iotable.ibd’

removed ‘/var/lib/mysql/resourcestresser/iotablesmallrow.ibd’

removed ‘/var/lib/mysql/resourcestresser/locktable.ibd’

removed ‘/var/lib/mysql/resourcestresser/db.opt’

removed ‘/var/lib/mysql/resourcestresser/cputable.frm’

removed ‘/var/lib/mysql/resourcestresser/iotable.frm’

removed ‘/var/lib/mysql/resourcestresser/iotablesmallrow.frm’

removed ‘/var/lib/mysql/resourcestresser/locktable.frm’

removed directory: ‘/var/lib/mysql/resourcestresser’

removed ‘/var/lib/mysql/md_15252/BRc273a13dfd.ibd’

removed ‘/var/lib/mysql/md_15252/CA9176ed2945.ibd’

removed ‘/var/lib/mysql/md_15252/CA24ade621e4.ibd’

removed ‘/var/lib/mysql/md_15252/DAc955f09819.ibd’

removed ‘/var/lib/mysql/md_15252/DAebf122c2a3.ibd’

removed ‘/var/lib/mysql/md_15252/OP3605a09ed5.ibd’

removed ‘/var/lib/mysql/md_15252/PR03645fd534.ibd’

removed ‘/var/lib/mysql/md_15252/VA13db63946f.ibd’

removed ‘/var/lib/mysql/md_15252/db.opt’

removed ‘/var/lib/mysql/md_15252/BRc273a13dfd.frm’

removed ‘/var/lib/mysql/md_15252/CA9176ed2945.frm’

removed ‘/var/lib/mysql/md_15252/CA24ade621e4.frm’

removed ‘/var/lib/mysql/md_15252/DAc955f09819.frm’

removed ‘/var/lib/mysql/md_15252/DAebf122c2a3.frm’

removed ‘/var/lib/mysql/md_15252/OP3605a09ed5.frm’

removed ‘/var/lib/mysql/md_15252/PR03645fd534.frm’

removed ‘/var/lib/mysql/md_15252/VA13db63946f.frm’

removed directory: ‘/var/lib/mysql/md_15252’

removed ‘/var/lib/mysql/test/db.opt’

removed directory: ‘/var/lib/mysql/test’

removed ‘/var/lib/mysql/tpch1/db.opt’

removed directory: ‘/var/lib/mysql/tpch1’

removed ‘/var/lib/mysql/performance_schema/db.opt’

removed directory: ‘/var/lib/mysql/performance_schema’

removed ‘/var/lib/mysql/ffr/db.opt’

removed ‘/var/lib/mysql/ffr/f.MYI’

removed ‘/var/lib/mysql/ffr/f.MYD’

removed ‘/var/lib/mysql/ffr/f.frm’

removed directory: ‘/var/lib/mysql/ffr’

removed ‘/var/lib/mysql/aria_log_control’

removed ‘/var/lib/mysql/aria_log.00000001’

removed ‘/var/lib/mysql/ib_buffer_pool’

removed ‘/var/lib/mysql/xtrabackup_info’

removed ‘/var/lib/mysql/xtrabackup_binlog_pos_innodb’

removed ‘/var/lib/mysql/ib_logfile1’

removed ‘/var/lib/mysql/mysql.sock’

WSREP_SST: [INFO] Waiting for SST streaming to complete! (20180430 18:29:48.999)

2018-04-30 18:29:49 0 [Note] WSREP: (5053de41, 'tcp://0.0.0.0:4567') connection to peer 5053de41 with addr tcp://192.168.104.195:4567 timed out, no messages seen in PT3S

2018-04-30 18:29:50 0 [Note] WSREP: (5053de41, 'tcp://0.0.0.0:4567') turning message relay requesting off

   joiner: => Rate:[24.7MiB/s] Avg:[24.7MiB/s] Elapsed:0:00:32

WSREP_SST: [INFO] NOTE: Joiner-Recv-SST took 33 seconds (20180430 18:30:21.633)

2018-04-30 18:30:21 0 [Note] WSREP: 2.0 (t4w6): State transfer to 0.0 (t4w5) complete.

2018-04-30 18:30:21 0 [Note] WSREP: Member 2.0 (t4w6) synced with group.

WSREP_SST: [INFO] Preparing the backup at /var/lib/mysql//.sst (20180430 18:30:21.644)

WSREP_SST: [INFO] Evaluating mariabackup --innobackupex   --apply-log $rebuildcmd ${DATA} &>${DATA}/innobackup.prepare.log (20180430 18:30:21.649)

WSREP_SST: [INFO] NOTE: Xtrabackup prepare stage took 1 seconds (20180430 18:30:22.148)

rm: cannot remove ‘/var/lib/mysql//innobackup.prepare.log’: No such file or directory

rm: cannot remove ‘/var/lib/mysql//innobackup.move.log’: No such file or directory

WSREP_SST: [INFO] Moving the backup to /var/lib/mysql/ (20180430 18:30:22.152)

WSREP_SST: [INFO] Evaluating mariabackup --innobackupex       --move-back --force-non-empty-directories ${DATA} &>${DATA}/innobackup.move.log (20180430 18:30:22.157)

WSREP_SST: [INFO] NOTE: Xtrabackup move stage took 0 seconds (20180430 18:30:22.214)

WSREP_SST: [INFO] Move successful, removing /var/lib/mysql//.sst (20180430 18:30:22.217)

WSREP_SST: [INFO] Galera co-ords from recovery: b4c974d2-49fe-11e8-b950-9b4c947b49f6:137764 (20180430 18:30:22.224)

WSREP_SST: [INFO] Total time on joiner: 1 seconds (20180430 18:30:22.228)

WSREP_SST: [INFO] Removing the sst_in_progress file (20180430 18:30:22.231)

2018-04-30 18:30:22 0 [Note] WSREP: SST complete, seqno: 137764

2018-04-30 18:30:22 0 [Note] InnoDB: For Galera, using innodb_lock_schedule_algorithm=fcfs

2018-04-30 18:30:22 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2018-04-30 18:30:22 0 [Note] InnoDB: Uses event mutexes

2018-04-30 18:30:22 0 [Note] InnoDB: Compressed tables use zlib 1.2.7

2018-04-30 18:30:22 0 [Note] InnoDB: Using Linux native AIO

2018-04-30 18:30:22 0 [Note] InnoDB: Number of pools: 1

2018-04-30 18:30:22 0 [Note] InnoDB: Using generic crc32 instructions

2018-04-30 18:30:22 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M

2018-04-30 18:30:22 0 [Note] InnoDB: Completed initialization of buffer pool

2018-04-30 18:30:22 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().

2018-04-30 18:30:22 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 50331648 bytes

2018-04-30 18:30:22 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 50331648 bytes

2018-04-30 18:30:22 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0

2018-04-30 18:30:22 0 [Note] InnoDB: New log files created, LSN=68977130702

2018-04-30 18:30:22 0 [Note] InnoDB: 128 out of 128 rollback segments are active.

2018-04-30 18:30:22 0 [Note] InnoDB: Creating shared tablespace for temporary tables

2018-04-30 18:30:22 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2018-04-30 18:30:22 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.

2018-04-30 18:30:22 0 [Note] InnoDB: Waiting for purge to start

2018-04-30 18:30:22 0 [Note] InnoDB: 5.7.21 started; log sequence number 68977131020; transaction id 822534

2018-04-30 18:30:22 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool

2018-04-30 18:30:22 0 [Note] Plugin 'FEEDBACK' is disabled.

2018-04-30 18:30:22 0 [Note] Server socket created on IP: '0.0.0.0'.

2018-04-30 18:30:22 0 [Note] WSREP: Signalling provider to continue.

2018-04-30 18:30:22 0 [Note] WSREP: SST received: b4c974d2-49fe-11e8-b950-9b4c947b49f6:137764

2018-04-30 18:30:22 0 [Note] WSREP: 0.0 (t4w5): State transfer from 2.0 (t4w6) complete.

2018-04-30 18:30:22 0 [Note] WSREP: Shifting JOINER -> JOINED (TO: 137764)

2018-04-30 18:30:22 0 [Note] WSREP: Member 0.0 (t4w5) synced with group.

2018-04-30 18:30:22 0 [Note] WSREP: Shifting JOINED -> SYNCED (TO: 137764)

2018-04-30 18:30:22 9 [Note] WSREP: Synchronized with group, ready for connections

2018-04-30 18:30:22 9 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.

2018-04-30 18:30:22 0 [Note] Reading of all Master_info entries succeded

2018-04-30 18:30:22 0 [Note] Added new Master_info '' to hash table

2018-04-30 18:30:22 0 [Note] /usr/sbin/mysqld: ready for connections.

Version: '10.3.6-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server

2018-04-30 18:30:23 0 [Note] InnoDB: Buffer pool(s) load completed at 180430 18:30:23