I am having a bit of a issue. Recently I moved from 8.0.28 to the .29 version
Recently I had a crash that exceeded the IST time and I am attempting to do a SST transfer. Mind you I have done this quite a few times on these systems with no issues at all. I made sure that the xtrabackup also was upgraded on the systems in question.
After spending most of the day on this I am thinking that on a pretty busy database cluster the following is going on
SST logs on the Donor system shows Completed OK with no issues
The System I am attempting to recover during the prepare phase shows the followin
And Crashes… This lead me down the path of thinking that the innodb files were somehow corrupt or that the donor system was having some sort of issue or even a LAN/WAN issue. All items as far as I could tell checked out (I tried loading it from 4 different Donor systems all items appear to be the same)
I then found this and wonder if this is the cause of the issue
Question MAY be associated with this… One of the Two that I upgraded last night crashed again… I know that running different versions in the cluster is not suggested but I was not ready to pull the trigger yet on all the systems. I noticed this on the system that was at .30 which COULD be related maybe?
2023-08-22T23:42:38.771342Z 12 [Note] [MY-000000] [WSREP] Updating WSREPXid: 40deb9d6-ab4f-11ea-bfba-532a142ff8ef:6903465699
2023-08-22T23:42:38.771385Z 12 [Note] [MY-000000] [WSREP] Thread with id (12) granted turn to proceed
2023-08-22T23:42:38.771396Z 12 [Note] [MY-000000] [WSREP] Un-Registering thread with id (12) from wsrep group commit queue
2023-08-22T23:42:38.771730Z 12 [Note] [MY-000000] [WSREP] wsrep_after_commit: 1, 1, 6903465699, 0
2023-08-22T23:42:38.771789Z 12 [Note] [MY-000000] [WSREP] wsrep: committed write set (6903465699)
2023-08-22T23:42:38.771799Z 12 [Note] [MY-000000] [WSREP] wsrep_after_apply 12
2023-08-22T23:42:38.771871Z 0 [Warning] [MY-000000] [Galera] Failed to report last committed 40deb9d6-ab4f-11ea-bfba-532a142ff8ef:6903465698, -77 (File descriptor in bad state)
Without going too deep, I would recommend you go to 8.0.32. .29, .30, and .31 all had various issues that came from upstream. Percona has some fixes in place, but things were just wobbly during those versions. .32 is the best stable version right now, IMO.
@matthewb Took your advice on a Smaller system of mine… One item that just does not seem right… and for some users it seems like if the lib they are using is older they get a ssl bad handshake at times… (Python) a upgrade of the librarys for python seems to fix it…
8.0.33-25.1 has this
Percona XtraDB Cluster (GPL), Release rel25, Revision 0c56202, WSREP version 184.108.40.206
8.0.29-21.1 has this
Percona XtraDB Cluster (GPL), Release rel21, Revision 250bc93, WSREP version 26.4.3
Seems really weird that the version would DECREASE as this is just a comment maybe a typo?