mariaDB – ページ 2 – ぷすぅ～ぷすぅ～

以下のようのエラー


150812 19:57:48 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (dcd039d5-3f17-11e5-9f1a-b211dd95fd2d): 1 (Operation not permitted)
         at galera/src/replicator_str.cpp:prepare_for_IST():456. IST will be unavailable.
150812 19:57:48 [Note] WSREP: Member 1.0 (db2) requested state transfer from '*any*'. Selected 0.0 (db1)(SYNCED) as donor.
150812 19:57:48 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 8)
150812 19:57:48 [Note] WSREP: Requesting state transfer: success, donor: 0
150812 19:57:50 [Note] WSREP: (f76cecfe, 'tcp://0.0.0.0:4567') turning message relay requesting off
150812 19:58:03 [Warning] WSREP: 0.0 (db1): State transfer to 1.0 (db2) failed: -255 (Unknown error 255)
150812 19:58:03 [ERROR] WSREP: gcs/src/gcs_group.cpp:int gcs_group_handle_join_msg(gcs_group_t*, const gcs_recv_msg_t*)():731: Will never receive state. Need to abort.

150812 19:57:48 [Warning] WSREP: Failed to prepare for incremental state transfer: Local state UUID (00000000-0000-0000-0000-000000000000) does not match group state UUID (dcd039d5-3f17-11e5-9f1a-b211dd95fd2d): 1 (Operation not permitted)

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

150812 19:57:48 [Note] WSREP: Member 1.0 (db2) requested state transfer from '*any*'. Selected 0.0 (db1)(SYNCED) as donor.

150812 19:57:48 [Note] WSREP: Shifting PRIMARY -> JOINER (TO: 8)

150812 19:57:48 [Note] WSREP: Requesting state transfer: success, donor: 0

150812 19:57:50 [Note] WSREP: (f76cecfe, 'tcp://0.0.0.0:4567') turning message relay requesting off

150812 19:58:03 [Warning] WSREP: 0.0 (db1): State transfer to 1.0 (db2) failed: -255 (Unknown error 255)

150812 19:58:03 [ERROR] WSREP: gcs/src/gcs_group.cpp:int gcs_group_handle_join_msg(gcs_group_t*, const gcs_recv_msg_t*)():731: Will never receive state. Need to abort.

firewall がかかっているので、Galeraが構成できない。
firewall をオフにする。

centos 7で停止


systemctl stop firewalld

systemctl stop firewalld

centos 7で無効化(再起動後も停止)


systemctl disable firewalld

systemctl disable firewalld

centos7 以外のosは適宜ググって下さい。通常以下のような感じ
停止


service iptables stop

service iptables stop

無効化


chkconfig iptables off

chkconfig iptables off

以下のようなエラー


150812 15:32:23 [Warning] WSREP: Gap in state sequence. Need state transfer.
150812 15:32:23 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '192.168.122.44' --auth 'sst_user:dbpass' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --defaults-group-suffix '' --parent '10809'  '' '
150812 15:32:23 [ERROR] WSREP: Failed to read 'ready <addr>' from: wsrep_sst_rsync --role 'joiner' --address '192.168.122.44' --auth 'sst_user:dbpass' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --defaults-group-suffix '' --parent '10809'  ''
        Read: '(null)'
150812 15:32:23 [ERROR] WSREP: Process completed with error: wsrep_sst_rsync --role 'joiner' --address '192.168.122.44' --auth 'sst_user:dbpass' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --defaults-group-suffix '' --parent '10809'  '' : 2 (No such file or directory)
150812 15:32:23 [ERROR] WSREP: Failed to prepare for 'rsync' SST. Unrecoverable.
150812 15:32:23 [ERROR] Aborting
.....
Error in my_thread_global_end(): 1 threads didn't exit
150812 15:32:32 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended

150812 15:32:23 [Warning] WSREP: Gap in state sequence. Need state transfer.

150812 15:32:23 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'joiner' --address '192.168.122.44' --auth 'sst_user:dbpass' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --defaults-group-suffix '' --parent '10809' '' '

150812 15:32:23 [ERROR] WSREP: Failed to read 'ready <addr>' from: wsrep_sst_rsync --role 'joiner' --address '192.168.122.44' --auth 'sst_user:dbpass' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --defaults-group-suffix '' --parent '10809' ''

Read: '(null)'

150812 15:32:23 [ERROR] WSREP: Process completed with error: wsrep_sst_rsync --role 'joiner' --address '192.168.122.44' --auth 'sst_user:dbpass' --datadir '/var/lib/mysql/' --defaults-file '/etc/my.cnf' --defaults-group-suffix '' --parent '10809' '' : 2 (No such file or directory)

150812 15:32:23 [ERROR] WSREP: Failed to prepare for 'rsync' SST. Unrecoverable.

150812 15:32:23 [ERROR] Aborting

.....

Error in my_thread_global_end(): 1 threads didn't exit

150812 15:32:32 mysqld_safe mysqld from pid file /var/lib/mysql/localhost.localdomain.pid ended

SELinux を使わなくすると直る

SELinux の無効化（一時的)


setenforce 0

setenforce 0

永続的に無効化するために以下　/etc/selinux/config を以下のようにする。


SELINUX=disabled

SELINUX=disabled

SELinux に関するコマンド

SELinux の状態の確認


sestatus

sestatus

SELinux の無効化（一時的)


setenforce 0

setenforce 0

SELinux の有効化（一時的)


setenforce 1

setenforce 1

SELinux の使用有無を永続的に変更する場合

以下のファイルを変更する


/etc/selinux/config

/etc/selinux/config

無効化


SELINUX=disabled

SELINUX=disabled

有効化


SELINUX=enforcing

SELINUX=enforcing

カテゴリー: mariaDB

[mariadb] Galera Cluster でエラー WSREP: gcs/src/gcs_group.cpp:int gcs_group_handle_join_msg(gcs_group_t, const gcs_recv_msg_t)():731:

[mariadb] Galera Cluster でエラー ” : 2 (No such file or directory)

SELinux に関するコマンド

SELinux の使用有無を永続的に変更する場合