Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

PXC tarball install : Failed wsrep_sst_xtrabackup-v2 when adding new node

Description

PXC tarball install : Failed wsrep_sst_xtrabackup-v2 when adding new node

How to reproduce :

OS : CentOS Linux release 7.9.2009 (Core)

On all nodes :

Node172 : Modify my.cnf to reflect proper IPs and node identifiers

Node171 : Initialize first node.

Node171 : Bootstrap

Node172 : Try to join 2nd node then we got the error

WORKAROUND

Go to function get_mysqld_path line 297 then disable exit-on-error(set +e) setting at start of line and enable it at end of line(set -e)

 

We should be able to add the new node now :

Suggested Fix :

Please see workaround.

Environment

None

AFFECTED CS IDs

CS0042045

Activity

aristotle.po 
December 12, 2023 at 6:55 AM

Hi ,

1. Yes, I think this should be solved as there are workarounds and I can see in https://jira.percona.com/browse/PXC-4317 that upcoming release   **  8.0.35-27 should solve the issue.

2. Correct it was an issue in my environment.

> If that is true, it means that the initial workaround still works, right?

Yes, initial workaround still work.

Kamil Holubicki 
December 11, 2023 at 9:15 AM

Hi ,

Is my understanding correct that

  1. this issue should be solved

  2. it is not an issue, because it was the problem with your local env

Please confirm.

If that is true, it means that the initial workaround still works, right?

aristotle.po 
December 6, 2023 at 10:01 AM

Hi Kamil,

You are correct, we have two issues.

1) Realize another workround to run it as mysql user and it went good on my test :

2) I missed to create /var/run/mysqld/ folder owned by mysql OS user. It's ok now.

Kamil Holubicki 
December 6, 2023 at 9:16 AM

It seems we've got two problem here:
1. The one with set -e/+e workaround, which is the same as https://jira.percona.com/browse/PXC-4317
2. The other one with Can't start server: can't check PID filepath: No such file or directory

aristotle.po 
December 6, 2023 at 8:52 AM

The bug is only on tarball installation. I did not observe the it in rpms install.

Done

Details

Assignee

Reporter

Needs QA

Fix versions

Affects versions

Priority

Created June 2, 2023 at 10:24 AM
Updated March 8, 2024 at 1:46 PM
Resolved January 12, 2024 at 2:18 PM