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

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

    XMLWordPrintable

Details

    Description

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

      Galera Node should be rejoined with IST after backup - restore with mariabackup
      but it appears that the galera grastate.dat file is not in mariabackup and Node is joined
      with SST.
      That may cause huge data transfer between Nodes and may increase the delay in the cluster.
      If save galera grastate.dat and copy it manually to the restored data-dir, Node is joined
      faster with IST.

      desync Node from the cluster and perform mariabackup with options
      --galera-info and --no-lock options
      in both cases of restoring data:
      A. Restore data (prepare and apply) on the local Node
      B. Restore data (prepare and apply) on another Node
      the Recovered Node is joined with SST

      set wsrep_desync and FTWRL on the Node.
      get mariabackup with options --galera-info and --no-lock options
      unlock tables , disable wsrep_desync .
      Use the backuped data to be restored either on the same Node or on some other Node

      Below mariabackup restored on the same Node

      # 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!
      
      

      1. service mysql start --wsrep_cluster_address=gcomm://192.168.104.196
        Starting mysql (via systemctl): [ 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
      
      

      Attachments

        Issue Links

          Activity

            People

              ramesh Ramesh Sivaraman
              winstone Zdravelina Sokolovska (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.