【MGR】MGR-imeout on wait for view after joining group

小亮520cl發表於2018-04-09
AIView
1.MGR其中一個節點掛了，按照以下的方式恢復
  1. 1.其中一臺second上備份全庫
  2.  /usr/local/mysql/bin/mysqldump -uroot -P3312 -S /data0/mysql/log/testdb/mysql_testdb.sock -prootroot --master-data=2 --databases TESTDB db1 db10 db11 db12 db2 db3 vodb > alldb.sql

  4. 2.sql有記錄gtid複製點資訊
  5. SET @@GLOBAL.GTID_PURGED='aaaaaaaa-bbbb-cccc-ddda-aaaaaaaaaaaa:1-36';


  8. 3.失敗節點匯入sql


  11. 4.mysql> START GROUP_REPLICATION;


  14. 然後就一直失敗：
2018-04-09T02:11:25.147448Z 0 [Note] Plugin group_replication reported: 'client connected to mysql02 24902 fd 66'

2018-04-09T02:11:55.147914Z 0 [ERROR] Plugin group_replication reported: '[GCS] Timeout while waiting for the group communication engine to be ready!'
2018-04-09T02:11:55.147974Z 0 [ERROR] Plugin group_replication reported: '[GCS] The group communication engine is not ready for the member to join. Local port: 24901'
2018-04-09T02:11:55.148058Z 0 [Note] Plugin group_replication reported: 'state 4272 action xa_terminate'
2018-04-09T02:11:55.148081Z 0 [Note] Plugin group_replication reported: 'new state x_start'
2018-04-09T02:11:55.148085Z 0 [Note] Plugin group_replication reported: 'state 4272 action xa_exit'
2018-04-09T02:11:55.148183Z 0 [Note] Plugin group_replication reported: 'Exiting xcom thread'
2018-04-09T02:11:55.148219Z 0 [Note] Plugin group_replication reported: 'new state x_start'
2018-04-09T02:11:55.148920Z 0 [Warning] Plugin group_replication reported: 'read failed'
2018-04-09T02:11:55.169025Z 0 [ERROR] Plugin group_replication reported: '[GCS] The member was unable to join the group. Local port: 24901'
null2018-04-09T02:12:25.145183Z 27 [ERROR] Plugin group_replication reported: 'Timeout on wait for view after joining group'
2018-04-09T02:12:26.145357Z 27 [Note] Plugin group_replication reported: 'Requesting to leave the group despite of not being a member'
2018-04-09T02:12:26.145417Z 27 [ERROR] Plugin group_replication reported: '[GCS] The member is leaving a group without being on one.'
2018-04-09T02:12:26.145551Z 27 [Note] Plugin group_replication reported: 'auto_increment_increment is reset to 1'
2018-04-09T02:12:26.145594Z 27 [Note] Plugin group_replication reported: 'auto_increment_offset is reset to 1'
2018-04-09T02:12:26.146050Z 32 [Note] Error reading relay log event for channel 'group_replication_applier': slave SQL thread was killed
2018-04-09T02:12:26.146573Z 29 [Note] Plugin group_replication reported: 'The group replication applier thread was killed'
2018-04-09T02:13:57.164181Z 27 [Note] Aborted connection 27 to db: 'unconnected' user: 'root' host: 'localhost' (Got timeout reading communication packets)
null2018-04-09T02:20:55.810967Z 34 [Note] Aborted connection 34 to db: 'mysql' user: 'root' host: 'localhost' (Got timeout reading communication packets)


2 修復過程
  1. mysql> SELECT * FROM performance_schema.replication_group_members;
  2. +---------------------------+--------------------------------------+-------------+-------------+--------------+
  3. | CHANNEL_NAME | MEMBER_ID | MEMBER_HOST | MEMBER_PORT | MEMBER_STATE |
  4. +---------------------------+--------------------------------------+-------------+-------------+--------------+
  5. | group_replication_applier | 0a4a3b1d-ebc1-11e7-bf81-005056b9d83d | mysql03 | 3312 | ONLINE |
  6. | group_replication_applier | 648a6cb1-ebc1-11e7-8425-005056b9f3f2 | mysql02 | 3312 | ONLINE |
  7. | group_replication_applier | d59224f9-ebc1-11e7-92f2-005056b96aae | mysql01 | 3312 | UNREACHABLE |
  8. +---------------------------+--------------------------------------+-------------+-------------+--------------+
  9.   
  UNREACHABLE  表示節點處於不可達狀態，無法與之發生網路通訊

  2.  檢查半天是防火強的原因

  1.   centos 6 的nc -vz ip port即可獲取狀態
   centos 7的nc命令有變化
  [root@mysql02 ~]# nc -w 1   10.168.17.202   3312 < /dev/null && echo "tcp port ok"





來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29096438/viewspace-2152698/，如需轉載，請註明出處，否則將追究法律責任。

相關文章