node1_config.txt (1.4 KB)
node2_config .txt (1.4 KB)
OS version: rhel 9.6
xtradb version: 8.4.6
xtrabackup version 8.4.0-4
Keyring Encryption :
/appsSW/PerconaMYSQL/Percona-XtraDB-Cluster_8.4.6-6.1_Linux.x86_64.glibc2.34/bin/mysqld.my
{
“components”: “file://component_keyring_file”
}
/appsSW/PerconaMYSQL/Percona-XtraDB-Cluster_8.4.6-6.1_Linux.x86_64.glibc2.34/lib/plugin/component_keyring_file.cnf
{
“path”: “/appsDATA/PerconaMYSQL/eK/keyStore”,
“read_only”: false
}
ls -ld /appsDATA/PerconaMYSQL/eK/*
-rw-r-----. 1 mysql mysql 210 Apr 4 15:43 /appsDATA/PerconaMYSQL/eK/keyStore
I’m in the process of configuring 3 node cluster. Completed 1st node, cluster instance is up .
In 2nd node when I start Instance, it fails . I see following errors in log
2026-04-04T08:01:41.770066Z 1 [ERROR] [MY-012592] [InnoDB] Operating system error number 2 in a file operation.
2026-04-04T08:01:41.770114Z 1 [ERROR] [MY-012593] [InnoDB] The error means the system cannot find the path specified.
2026-04-04T08:01:41.770120Z 1 [ERROR] [MY-012594] [InnoDB] If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
2026-04-04T08:01:41.770126Z 1 [ERROR] [MY-012646] [InnoDB] File ./ibdata1: ‘open’ returned OS error 71. Cannot continue operation
2026-04-04T08:01:41.770158Z 1 [ERROR] [MY-012981] [InnoDB] Cannot continue operation.
2026-04-04T08:01:57.639228Z 0 [ERROR] [MY-000000] [WSREP-SST] ******************* FATAL ERROR **********************
2026-04-04T08:01:57.639259Z 0 [ERROR] [MY-000000] [WSREP-SST] xtrabackup_checkpoints missing. xtrabackup/SST failed on DONOR. Check DONOR log
2026-04-04T08:01:57.639265Z 0 [ERROR] [MY-000000] [WSREP-SST] Line 2430
2026-04-04T08:01:57.639269Z 0 [ERROR] [MY-000000] [WSREP-SST] ******************************************************
2026-04-04T08:01:57.639272Z 0 [ERROR] [MY-000000] [WSREP-SST] Cleanup after exit with status:2
2026-04-04T08:01:57.648888Z 0 [ERROR] [MY-000000] [Galera] ../../../../../percona-xtradb-cluster-galera/gcs/src/gcs_group.cpp:gcs_group_handle_join_msg():1346: Will never receive state. Need to abort.
Donor log from 1st node :
/appsDATA/PerconaMYSQL/data/innobackup.backup.log
2026-04-04T16:01:57.750519+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized server arguments: --server-id=101 --datadir=/appsDATA/PerconaMYSQL/data --innodb_buffer_pool_size=1073741824 --defaults_group=mysqld
2026-04-04T16:01:57.750658+08:00 0 [Note] [MY-011825] [Xtrabackup] recognized client arguments: --no-version-check=1 --parallel=4 --user=mysql.pxc.sst.user --password=* --socket=/appsDATA/PerconaMYSQL/sockets/pmysql.s0ckeT --lock-ddl --backup=1 --galera-info=1 --transition-key=* --stream=xbstream --xtrabackup-plugin-dir=/appsSW/PerconaMYSQL/Percona-XtraDB-Cluster_8.4.6-6.1_Linux.x86_64.glibc2.34/bin/pxc_extra/pxb-8.4/lib/plugin --target-dir=/tmp/pxc_sst_L3YP/donor_xb_Zk2s
/appsSW/PerconaMYSQL/Percona-XtraDB-Cluster_8.4.6-6.1_Linux.x86_64.glibc2.34/bin/pxc_extra/pxb-8.4/bin/xtrabackup version 8.4.0-4 based on MySQL server 8.4.0 Linux (x86_64) (revision id: c584cb20)
2026-04-04T16:01:57.750671+08:00 0 [Warning] [MY-011825] [Xtrabackup] version check is removed and --no-version-check is deprecated.
2026-04-04T16:01:57.750694+08:00 0 [Note] [MY-011825] [Xtrabackup] Connecting to MySQL server host: localhost, user: mysql.pxc.sst.user, password: set, port: not set, socket: /appsDATA/PerconaMYSQL/sockets/pmysql.s0ckeT
2026-04-04T16:01:57.837764+08:00 0 [Note] [MY-011825] [Xtrabackup] Using server version 8.4.6-6.1
2026-04-04T16:01:57.857981+08:00 0 [Note] [MY-011825] [Xtrabackup] Executing LOCK TABLES FOR BACKUP …
2026-04-04T16:01:57.859831+08:00 0 [Note] [MY-011825] [Xtrabackup] uses posix_fadvise().
2026-04-04T16:01:57.859874+08:00 0 [Note] [MY-011825] [Xtrabackup] cd to /appsDATA/PerconaMYSQL/data
2026-04-04T16:01:57.859891+08:00 0 [Note] [MY-011825] [Xtrabackup] open files limit requested 0, set to 8161
2026-04-04T16:01:57.860435+08:00 0 [Note] [MY-011825] [Xtrabackup] using the following InnoDB configuration:
2026-04-04T16:01:57.860447+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_home_dir = .
2026-04-04T16:01:57.860453+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_data_file_path = ibdata1:12M:autoextend
2026-04-04T16:01:57.860470+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_group_home_dir = ./
2026-04-04T16:01:57.860476+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_files_in_group = 2
2026-04-04T16:01:57.860483+08:00 0 [Note] [MY-011825] [Xtrabackup] innodb_log_file_size = 50331648
xtrabackup: Unknown error 1126
xtrabackup: Unknown error 3529
2026-04-04T16:01:57.861217+08:00 0 [ERROR] [MY-013709] [Server] Received an error while processing components from manifest file: Failed to load components from manifest file
2026-04-04T16:01:57.861262+08:00 0 [ERROR] [MY-011825] [Xtrabackup] failed to init keyring component
I’m able manually run xtrabackup successfully in node1 with additional cmd line argument :
‘–xtrabackup-plugin-dir’.
Is there an option to include this argument for wsrep_sst_method=‘xtrabackup-v2’