2 node's can not joine the bootstrap server

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.

1 Like

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.

1 Like