# 2 node's can not joine the bootstrap server **URL:** \ **Category:** Percona XtraDB Cluster\ **Created:** [March 9, 2021, 9:21pm UTC](https://forums.percona.com/t/2-nodes-can-not-joine-the-bootstrap-server/9609 "2021-03-09T21:21:09Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![jan\_wiebe\_klijnsma](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/jan_wiebe_klijnsma/32/3094_2.png) [@jan\_wiebe\_klijnsma](https://forums.percona.com/u/jan_wiebe_klijnsma)\ **Post date:** [March 9, 2021, 9:21pm UTC](https://forums.percona.com/t/2-nodes-can-not-joine-the-bootstrap-server/9609/1 "2021-03-09T21:21:09Z")
Mysql error log of db2/3 the config are the same for mysql en ip’s are correct and name. root@db2:~# grep -irn “error” /var/log/mysql/error.log 3: INFO: WSREP: Running position recovery with --log\_error=‘/var/lib/mysql/wsrep\_recovery\_verbose.BkWNLJ’ --pid-file=‘/var/lib/mysql/db2-recover.pid’ 4: ERROR! WSREP: Failed to recover position: 82:2021-03-09T18:39:08.377560Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: ‘Setup of socket: ‘/var/run/mysqld/mysqlx.sock’ failed, can’t create lock file /var/run/mysqld/mysqlx.sock.lock’ 83:2021-03-09T18:39:08.377849Z 0 [Note] [MY-011322] [Server] Plugin mysqlx reported: ‘Please see the MySQL documentation for ‘mysqlx\_socket’ system variables to fix the error’ 86:2021-03-09T18:39:08.453847Z 0 [ERROR] [MY-010958] [Server] Could not open log file. 87:2021-03-09T18:39:08.454112Z 0 [ERROR] [MY-010041] [Server] Can’t init tc log 88:2021-03-09T18:39:08.454653Z 0 [ERROR] [MY-010119] [Server] Aborting 170:2021-03-09T18:39:21.631652Z 0 [Warning] [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 262:2021-03-09T18:39:47.689821Z 0 [ERROR] [MY-000000] [WSREP-SST] \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* FATAL ERROR \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 263:2021-03-09T18:39:47.691059Z 0 [ERROR] [MY-000000] [WSREP-SST] Failed to start the mysql server that checks for async replication. 264:2021-03-09T18:39:47.691098Z 0 [ERROR] [MY-000000] [WSREP-SST] Check the parameters and retry 265:2021-03-09T18:39:47.691120Z 0 [ERROR] [MY-000000] [WSREP-SST] Line 483 pid:3167 266:2021-03-09T18:39:47.691154Z 0 [ERROR] [MY-000000] [WSREP-SST] ------------ mysql error log (START) ------------ 275: 2021-03-09T18:39:45.320278Z 0 [ERROR] [MY-011292] [Server] Plugin mysqlx reported: ‘Preparation of I/O interfaces failed, X Protocol won’t be accessible’ 276: 2021-03-09T18:39:45.320484Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: ‘Setup of socket: ‘/var/run/mysqld/mysqlx.sock’ failed, can’t create lock file /var/run/mysqld/mysqlx.sock.lock’ 278: 2021-03-09T18:39:45.428484Z 0 [ERROR] [MY-010958] [Server] Could not open log file. 279: 2021-03-09T18:39:45.428648Z 0 [ERROR] [MY-010041] [Server] Can’t init tc log 280: 2021-03-09T18:39:45.429293Z 0 [ERROR] [MY-010119] [Server] Aborting 283:2021-03-09T18:39:47.691195Z 0 [ERROR] [MY-000000] [WSREP-SST] ------------ mysql error log (END) ------------ 284:2021-03-09T18:39:47.691217Z 0 [ERROR] [MY-000000] [WSREP-SST] \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 286:2021-03-09T18:39:47.691956Z 0 [ERROR] [MY-000000] [WSREP-SST] Cleanup after exit with status:3 287:2021-03-09T18:39:47.704817Z 0 [ERROR] [MY-000000] [WSREP] Process completed with error: wsrep\_sst\_xtrabackup-v2 --role ‘joiner’ --address ‘10.0.201.81’ --datadir ‘/var/lib/mysql/’ --basedir ‘/usr/’ --plugindir ‘/usr/lib/mysql/plugin/’ --defaults-file ‘/etc/mysql/my.cnf’ --defaults-group-suffix ‘’ --parent ‘2524’ --mysqld-version ‘8.0.21-12.1’ --binlog ‘/var/lib/mysql/log/binlog’ : 3 (No such process) 288:2021-03-09T18:39:47.704876Z 0 [ERROR] [MY-000000] [WSREP] Failed to read uuid:seqno from joiner script. 289:2021-03-09T18:39:47.704898Z 0 [ERROR] [MY-000000] [WSREP] SST script aborted with error 3 (No such process) 294:2021-03-09T18:39:47.705315Z 2 [ERROR] [MY-000000] [Galera] Application received wrong state: 297:2021-03-09T18:39:47.705344Z 2 [ERROR] [MY-000000] [Galera] Application state transfer failed. This is unrecoverable condition, restart required. root@db3:~# grep -irn “error” /var/log/mysql/error.log 3: INFO: WSREP: Running position recovery with --log\_error=‘/var/lib/mysql/wsrep\_recovery\_verbose.QwZ2RC’ --pid-file=‘/var/lib/mysql/db3-recover.pid’ 4: ERROR! WSREP: Failed to recover position: 82:2021-03-09T19:40:37.467329Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: ‘Setup of socket: ‘/var/run/mysqld/mysqlx.sock’ failed, can’t create lock file /var/run/mysqld/mysqlx.sock.lock’ 83:2021-03-09T19:40:37.467797Z 0 [Note] [MY-011322] [Server] Plugin mysqlx reported: ‘Please see the MySQL documentation for ‘mysqlx\_socket’ system variables to fix the error’ 86:2021-03-09T19:40:37.592363Z 0 [ERROR] [MY-010958] [Server] Could not open log file. 87:2021-03-09T19:40:37.592695Z 0 [ERROR] [MY-010041] [Server] Can’t init tc log 88:2021-03-09T19:40:37.593380Z 0 [ERROR] [MY-010119] [Server] Aborting 170:2021-03-09T19:40:53.980031Z 0 [Warning] [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 262:2021-03-09T19:41:20.735135Z 0 [ERROR] [MY-000000] [WSREP-SST] \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* FATAL ERROR \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 263:2021-03-09T19:41:20.736298Z 0 [ERROR] [MY-000000] [WSREP-SST] Failed to start the mysql server that checks for async replication. 264:2021-03-09T19:41:20.736330Z 0 [ERROR] [MY-000000] [WSREP-SST] Check the parameters and retry 265:2021-03-09T19:41:20.736351Z 0 [ERROR] [MY-000000] [WSREP-SST] Line 483 pid:2161 266:2021-03-09T19:41:20.737790Z 0 [ERROR] [MY-000000] [WSREP-SST] ------------ mysql error log (START) ------------ 275: 2021-03-09T19:41:18.416682Z 0 [ERROR] [MY-011292] [Server] Plugin mysqlx reported: ‘Preparation of I/O interfaces failed, X Protocol won’t be accessible’ 276: 2021-03-09T19:41:18.416935Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: ‘Setup of socket: ‘/var/run/mysqld/mysqlx.sock’ failed, can’t create lock file /var/run/mysqld/mysqlx.sock.lock’ 278: 2021-03-09T19:41:18.524152Z 0 [ERROR] [MY-010958] [Server] Could not open log file. 279: 2021-03-09T19:41:18.524393Z 0 [ERROR] [MY-010041] [Server] Can’t init tc log 280: 2021-03-09T19:41:18.524922Z 0 [ERROR] [MY-010119] [Server] Aborting 283:2021-03-09T19:41:20.737865Z 0 [ERROR] [MY-000000] [WSREP-SST] ------------ mysql error log (END) ------------ 284:2021-03-09T19:41:20.737908Z 0 [ERROR] [MY-000000] [WSREP-SST] \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* 286:2021-03-09T19:41:20.737986Z 0 [ERROR] [MY-000000] [WSREP-SST] Cleanup after exit with status:3 287:2021-03-09T19:41:20.752378Z 0 [ERROR] [MY-000000] [WSREP] Process completed with error: wsrep\_sst\_xtrabackup-v2 --role ‘joiner’ --address ‘10.0.201.82’ --datadir ‘/var/lib/mysql/’ --basedir ‘/usr/’ --plugindir ‘/usr/lib/mysql/plugin/’ --defaults-file ‘/etc/mysql/my.cnf’ --defaults-group-suffix ‘’ --parent ‘1518’ --mysqld-version ‘8.0.21-12.1’ --binlog ‘/var/lib/mysql/log/binlog’ : 3 (No such process) 288:2021-03-09T19:41:20.752463Z 0 [ERROR] [MY-000000] [WSREP] Failed to read uuid:seqno from joiner script. 289:2021-03-09T19:41:20.752498Z 0 [ERROR] [MY-000000] [WSREP] SST script aborted with error 3 (No such process) 294:2021-03-09T19:41:20.753005Z 1 [ERROR] [MY-000000] [Galera] Application received wrong state: 297:2021-03-09T19:41:20.753038Z 1 [ERROR] [MY-000000] [Galera] Application state transfer failed. This is unrecoverable condition, restart required. ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [March 10, 2021, 3:40pm UTC](https://forums.percona.com/t/2-nodes-can-not-joine-the-bootstrap-server/9609/2 "2021-03-10T15:40:46Z")
Looks like you have permissions issues. Check that your /var/lib/mysql and /var/log/mysql are owned by ‘mysql’. Also, be sure SELinux/Apparmour are in permissive modes.