环境信息
安装pxc过程中,启动第二个节点时出现如下错误:
gcs/src/gcs_group.cpp:gcs_group_handle_join_msg():766: Will never receive state.
安装包:
percona-xtrabackup-24-2.4.15-1.el7.x86_64.rpm
Percona-XtraDB-Cluster-5.7.25-rel28-31.35.1.Linux.x86_64.ssl101.tar.gz
日志分析:
2019-12-01T06:49:17.523802-08:00 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-12-01T06:49:17.523926-08:00 0 [Warning] WSREP: Node is running in bootstrap/initialize mode. Disabling pxc_strict_mode checks
100
100
100
100
2019-12-01T06:49:18.521551-08:00 0 [Warning] InnoDB: New log files created, LSN=45790
2019-12-01T06:49:18.693027-08:00 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2019-12-01T06:49:18.751601-08:00 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: c0c4d9e3-1449-11ea-b40b-000c29c20589.
2019-12-01T06:49:18.755176-08:00 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2019-12-01T06:49:18.948738-08:00 0 [Warning] CA certificate ca.pem is self signed.
2019-12-01T06:49:19.014433-08:00 1 [Note] A temporary password is generated for root@localhost: lPTwmCj!(9ja
2019-12-01T06:49:44.249683-08:00 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-12-01T06:49:44.252680-08:00 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
2019-12-01T06:49:44.252736-08:00 0 [Note] /usr/local/pxcmysql/bin/mysqld (mysqld 5.7.25-28-31.35-log) starting as process 58740 ...
2019-12-01T06:49:44.260104-08:00 0 [Note] WSREP: Setting wsrep_ready to false
2019-12-01T06:49:44.260127-08:00 0 [Note] WSREP: No pre-stored wsrep-start position found. Skipping position initialization.
2019-12-01T06:49:44.260132-08:00 0 [Note] WSREP: wsrep_load(): loading provider library '/usr/local/pxcmysql/lib/libgalera_smm.so'
2019-12-01T06:49:44.266323-08:00 0 [Note] WSREP: wsrep_load(): Galera 3.35(r) by Codership Oy <info@codership.com> loaded successfully.
2019-12-01T06:49:44.266424-08:00 0 [Note] WSREP: CRC-32C: using hardware acceleration.
2019-12-01T06:49:44.266757-08:00 0 [Warning] WSREP: Could not open state file for reading: '/data/mysql/mysql3306/data//grastate.dat'
2019-12-01T06:49:44.266765-08:00 0 [Warning] WSREP: No persistent state found. Bootstraping with default state
2019-12-01T06:49:44.266856-08:00 0 [Note] WSREP: Found saved state: 00000000-0000-0000-0000-000000000000:-1, safe_to_bootstrap: 1
2019-12-01T06:49:44.270417-08:00 0 [Note] WSREP: Passing config to GCS: base_dir = /data/mysql/mysql3306/data/; base_host = 192.168.31.110; base_port = 4567; cert.log_conflicts = no; cert.optimistic_pa = yes; 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 = 10; evs.stats_report_period = PT1M; evs.suspect_timeout = PT5S; evs.user_send_window = 4; evs.view_forget_timeout = PT24H; gcache.dir = /data/mysql/mysql3306/data/; gcache.freeze_purge_