Cluster fails to start if you change to Streaming replication
General
Escalation
General
Escalation
Description
Problem
I have created a one node PXC cluster on DBaaS. Then I tried to add some PXC settings:
After this MySQL fails to start:
As you can see I am setting binlog_format to ROW but error message still complaining the binlog_fromat is Statement.
Possible issue
How can that be? My guess is something changing the binlog_format back to STATEMENT during the initialisation/startup process. However I could not find it in the code.
We have to change these parameters to avoid OOM Killer.
Reproducing
Create a cluster and edit config and add
Then check the logs for the pod.
Environment
None
Attachments
1
Smart Checklist
Activity
Tibor Korocz (Percona) October 21, 2022 at 11:30 AM
In never version it is already fixed.
Tibor Korocz (Percona) October 21, 2022 at 11:29 AM
Thanks , you are correct this was a `2.28.0` , I will ask them if we can upgrade or not. Will close the ticket as well as this not happens in newer PXC.
Problem
I have created a one node PXC cluster on DBaaS. Then I tried to add some PXC settings:
After this MySQL fails to start:
As you can see I am setting binlog_format to ROW but error message still complaining the binlog_fromat is Statement.
Possible issue
How can that be? My guess is something changing the binlog_format back to STATEMENT during the initialisation/startup process. However I could not find it in the code.
This could be a blocker for https://jira.percona.com/browse/PXC-4047
We have to change these parameters to avoid OOM Killer.
Reproducing
Create a cluster and edit config and add
Then check the logs for the pod.