![RHEL8.4 与 Percona8.0.29 - 集群失败,错误代码 7](https://linux22.com/image/780977/RHEL8.4%20%E4%B8%8E%20Percona8.0.29%20-%20%E9%9B%86%E7%BE%A4%E5%A4%B1%E8%B4%A5%EF%BC%8C%E9%94%99%E8%AF%AF%E4%BB%A3%E7%A0%81%207.png)
我已经安装了 3 台 RHEL 8.4 服务器,还安装了最新版本的 Percona XtraDB 集群。我保留了 my.cnf 文件的基本版本,wsrep 也基本保留了节点名称、gcomm 寻址和集群名称所需的更改。主节点启动正常。它在 gcomm 中没有寻址,因为它将在添加节点时学习。为了确认,我确实尝试添加寻址并重新启动引导程序。当使用 systemctl start mysqld 将第二个节点添加到集群时,我遇到了加入失败。以下是日志文件的输出:
2022-10-08T18:59:10.228425Z 0 [Note] [MY-000000] [WSREP] Starting replication 2022-10-08T18:59:10.228469Z 0 [Note] [MY-000000] [Galera] Connecting with bootstrap option: 0 2022-10-08T18:59:10.228486Z 0 [Note] [MY-000000] [Galera] Setting GCS initial position to 00000000-0000-0000-0000-000000000000:-1 2022-10-08T18:59:10.228530Z 0 [Note] [MY-000000] [Galera] protonet asio version 0 2022-10-08T18:59:10.228864Z 0 [Note] [MY-000000] [Galera] Using CRC-32C for message checksums. 2022-10-08T18:59:10.228882Z 0 [Note] [MY-000000] [Galera] backend: asio 2022-10-08T18:59:10.228942Z 0 [Note] [MY-000000] [Galera] gcomm thread scheduling priority set to other:0 2022-10-08T18:59:10.229004Z 0 [Note] [MY-000000] [Galera] Fail to access the file (/var/lib/mysql//gvwstate.dat) error (No such file or directory). It is possible if node is booting for first time or re-booting after a graceful shutdown 2022-10-08T18:59:10.229018Z 0 [Note] [MY-000000] [Galera] Restoring primary-component from disk failed. Either node is booting for first time or re-booting after a graceful shutdown 2022-10-08T18:59:10.229115Z 0 [Note] [MY-000000] [Galera] GMCast version 0 2022-10-08T18:59:10.230004Z 0 [Warning] [MY-000000] [Galera] Failed to resolve ssl:// 192.168.56.151:4567 2022-10-08T18:59:10.230068Z 0 [Warning] [MY-000000] [Galera] Failed to resolve ssl:// 192.168.56.150:4567 2022-10-08T18:59:10.230110Z 0 [Note] [MY-000000] [Galera] (4ad2459a-8f81, 'ssl://0.0.0.0:4567') listening at ssl://0.0.0.0:4567 2022-10-08T18:59:10.230121Z 0 [Note] [MY-000000] [Galera] (4ad2459a-8f81, 'ssl://0.0.0.0:4567') multicast: , ttl: 1 2022-10-08T18:59:10.230305Z 0 [Note] [MY-000000] [Galera] EVS version 1 2022-10-08T18:59:10.230404Z 0 [Note] [MY-000000] [Galera] gcomm: connecting to group 'travelex-cluster', peer '192.168.56.152:, 192.168.56.151:, 192.168.56.150:' 2022-10-08T18:59:13.233756Z 0 [Note] [MY-000000] [Galera] announce period timed out (pc.announce_timeout) 2022-10-08T18:59:13.233864Z 0 [Note] [MY-000000] [Galera] EVS version upgrade 0 -> 1 2022-10-08T18:59:13.233880Z 0 [Note] [MY-000000] [Galera] PC protocol upgrade 0 -> 1 2022-10-08T18:59:13.233907Z 0 [Warning] [MY-000000] [Galera] no nodes coming from prim view, prim not possible 2022-10-08T18:59:13.233921Z 0 [Note] [MY-000000] [Galera] Current view of cluster as seen by this node view (view_id(NON_PRIM,4ad2459a-8f81,1) memb { 4ad2459a-8f81,0 } joined { } left { } partitioned { } ) 2022-10-08T18:59:13.734091Z 0 [Warning] [MY-000000] [Galera] last inactive check more than PT1.5S (3*evs.inactive_check_period) ago (PT3.50379S), skipping check 2022-10-08T18:59:43.262806Z 0 [Note] [MY-000000] [Galera] PC protocol downgrade 1 -> 0 2022-10-08T18:59:43.262849Z 0 [Note] [MY-000000] [Galera] Current view of cluster as seen by this node view ((empty)) 2022-10-08T18:59:43.263049Z 0 [ERROR] [MY-000000] [Galera] failed to open gcomm backend connection: 110: failed to reach primary view (pc.wait_prim_timeout): 110 (Connection timed out) at gcomm/src/pc.cpp:connect():161 2022-10-08T18:59:43.263068Z 0 [ERROR] [MY-000000] [Galera] gcs/src/gcs_core.cpp:gcs_core_open():219: Failed to open backend connection: -110 (Connection timed out) 2022-10-08T18:59:44.263935Z 0 [Note] [MY-000000] [Galera] gcomm: terminating thread 2022-10-08T18:59:44.263993Z 0 [Note] [MY-000000] [Galera] gcomm: joining thread 2022-10-08T18:59:44.264082Z 0 [ERROR] [MY-000000] [Galera] gcs/src/gcs.cpp:gcs_open():1811: Failed to open channel 'travelex-cluster' at 'gcomm://192.168.56.152, 192.168.56.151, 192.168.56.150': -110 (Connection timed out) 2022-10-08T18:59:44.264097Z 0 [ERROR] [MY-000000] [Galera] gcs connect failed: Connection timed out 2022-10-08T18:59:44.264107Z 0 [ERROR] [MY-000000] [WSREP] Provider/Node (gcomm://192.168.56.152, 192.168.56.151, 192.168.56.150) failed to establish connection with cluster (reason: 7) 2022-10-08T18:59:44.264124Z 0 [ERROR] [MY-010119] [Server] Aborting 2022-10-08T18:59:44.264289Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.29-21.1) Percona XtraDB Cluster (GPL), Release rel21, Revision 250bc93, WSREP version 26.4.3. 2022-10-08T18:59:44.264960Z 0 [Note] [MY-000000] [Galera] dtor state: CLOSED 2022-10-08T18:59:44.264991Z 0 [Note] [MY-000000] [Galera] MemPool(TrxHandleSlave): hit ratio: 0, misses: 0, in use: 0, in pool: 0 2022-10-08T18:59:44.266239Z 0 [Note] [MY-000000] [Galera] apply mon: entered 0 2022-10-08T18:59:44.267395Z 0 [Note] [MY-000000] [Galera] apply mon: entered 0 2022-10-08T18:59:44.268526Z 0 [Note] [MY-000000] [Galera] apply mon: entered 0 2022-10-08T18:59:44.268541Z 0 [Note] [MY-000000] [Galera] cert index usage at exit 0 2022-10-08T18:59:44.268546Z 0 [Note] [MY-000000] [Galera] cert trx map usage at exit 0 2022-10-08T18:59:44.268549Z 0 [Note] [MY-000000] [Galera] deps set usage at exit 0 2022-10-08T18:59:44.268555Z 0 [Note] [MY-000000] [Galera] avg deps dist 0 2022-10-08T18:59:44.268559Z 0 [Note] [MY-000000] [Galera] avg cert interval 0 2022-10-08T18:59:44.268562Z 0 [Note] [MY-000000] [Galera] cert index size 0 2022-10-08T18:59:44.268630Z 0 [Note] [MY-000000] [Galera] Service thread queue flushed. 2022-10-08T18:59:44.268787Z 0 [Note] [MY-000000] [Galera] wsdb trx map usage 0 conn query map usage 0 2022-10-08T18:59:44.268800Z 0 [Note] [MY-000000] [Galera] MemPool(LocalTrxHandle): hit ratio: 0, misses: 0, in use: 0, in pool: 0 2022-10-08T18:59:44.269107Z 0 [Note] [MY-000000] [Galera] Shifting CLOSED -> DESTROYED (TO: 0) 2022-10-08T18:59:44.276640Z 0 [Note] [MY-000000] [Galera] Flushing memory map to disk...
我尝试了很多不同的方法来解决这个问题,但都没有效果。任何帮助都非常感谢。
答案1
好吧,现在我自己的 openssl 自签名证书一切正常。
Freeradius 与 percona 集群一起工作,radman 也与 percona 集群一起工作。
非常感谢 Wilson Hauck 的帮助