I followed the procedure mention at “Redirecting” but it fails with the below error:
2020-05-04T14:33:49.299851Z mysqld_safe Logging to ‘/percona_data/bench/d1/error.log’.Logging to ‘/percona_data/bench/d1/error.log’.2020-05-04T14:33:49.363507Z mysqld_safe Starting mysqld daemon with databases from /percona_data/bench/d12020-05-04T14:33:49.375591Z mysqld_safe Skipping wsrep-recover for empty datadir: /percona_data/bench/d12020-05-04T14:33:49.378939Z mysqld_safe Assigning 00000000-0000-0000-0000-000000000000:-1 to wsrep_start_position
And it is not generating the ‘/percona_data/bench/d1/error.log’ also so I am not able to debug in absence of error log.
Any suggestions, please
If you can share each instance’s my.cnf that would help. Also what version of PXC are you testing? FWIW, the short snippet from the log is not helping in the diagnosis. Is this coming from the bootstrapped node or the joining nodes?
Hi,
I have same issue. Trying to follow the steps here:
How to set up a three-node cluster on a single box
Downloaded the latest tarball and extracted in /usr/local/Percona-XtraDB-Cluster_8.0.27-18.1.x86_64
Here are the configs of the 3 my.cnf:
cat /etc/my.4000.cnf
[mysqld]
port = 4000
socket=/tmp/mysql.4000.sock
datadir=/app1/bench/d1
basedir=/usr/local/Percona-XtraDB-Cluster_8.0.27-18.1.x86_64
user=mysql
log_error=error.log
binlog_format=ROW
wsrep_cluster_address=‘gcomm://10.87.229.32:5030,10.87.229.32:6030’
wsrep_provider=/usr/local/Percona-XtraDB-Cluster_8.0.27-18.1.x86_64/lib/libgalera_smm.so
wsrep_sst_receive_address=10.87.229.32:4020
wsrep_node_incoming_address=10.87.229.32
wsrep_cluster_name=trimethylxanthine
wsrep_provider_options = “gmcast.listen_addr=tcp://10.87.229.32:4030;”
wsrep_sst_method=xtrabackup-v2
wsrep_node_name=node4000
innodb_autoinc_lock_mode=2
cat /etc/my.5000.cnf
[mysqld]
port = 5000
socket=/tmp/mysql.5000.sock
datadir=/app1/bench/d2
basedir=/usr/local/Percona-XtraDB-Cluster_8.0.27-18.1.x86_64
user=mysql
log_error=error.log
binlog_format=ROW
wsrep_cluster_address=‘gcomm://10.87.229.32:4030,10.87.229.32:6030’
wsrep_provider=/usr/local/Percona-XtraDB-Cluster_8.0.27-18.1.x86_64/lib/libgalera_smm.so
wsrep_sst_receive_address=10.87.229.32:5020
wsrep_node_incoming_address=10.87.229.32
wsrep_cluster_name=trimethylxanthine
wsrep_provider_options = “gmcast.listen_addr=tcp://10.87.229.32:5030;”
wsrep_sst_method=xtrabackup-v2
wsrep_node_name=node5000
innodb_autoinc_lock_mode=2
cat /etc/my.6000.cnf
[mysqld]
port = 6000
socket=/tmp/mysql.6000.sock
datadir=/app1/bench/d3
basedir=/usr/local/Percona-XtraDB-Cluster_8.0.27-18.1.x86_64
user=mysql
log_error=error.log
binlog_format=ROW
wsrep_cluster_address=‘gcomm://10.87.229.32:4030,10.87.229.32:5030’
wsrep_provider=/usr/local/Percona-XtraDB-Cluster_8.0.27-18.1.x86_64/lib/libgalera_smm.so
wsrep_sst_receive_address=10.87.229.32:6020
wsrep_node_incoming_address=10.87.229.32
wsrep_cluster_name=trimethylxanthine
wsrep_provider_options = “gmcast.listen_addr=tcp://10.87.229.32:6030;”
wsrep_sst_method=xtrabackup-v2
wsrep_node_name=node6000
innodb_autoinc_lock_mode=2
type or paste code here
When attempting to start the first node it gave me this error message:
Preformatted text# bin/mysqld_safe --defaults-file=/etc/my.4000.cnf --wsrep-new-cluster
2023-07-01T12:05:14.670117Z mysqld_safe Logging to ‘/app1/bench/d1/error.log’.
2023-07-01T12:05:14.671985Z mysqld_safe Logging to ‘/app1/bench/d1/error.log’.
2023-07-01T12:05:14.692600Z mysqld_safe Starting mysqld daemon with databases from /app1/bench/d1
2023-07-01T12:05:14.696485Z mysqld_safe Skipping wsrep-recover for empty datadir: /app1/bench/d1
2023-07-01T12:05:14.697387Z mysqld_safe Assigning 00000000-0000-0000-0000-000000000000:-1 to wsrep_start_position
2023-07-01T12:05:14.909989Z mysqld_safe mysqld from pid file /app1/bench/d1/rn000112059.pid ended with return value of 1Preformatted text
Also no error logs has been generated so I do not know where to check.
I am using almalinux8 ip 10.87.229.32
Please share some thoughts please.
Thanks
hey @Tulasi
I tried with 8.0.32 version and everything worked well for me
Hi Evgeniy,
tried 8.0.32 still no luck.
Can you please share your steps please?