percona: add hotfix for socat

We've added a workaround image for an issue with an old version of
socat until Percona releases new images, the following was used to
build it:

  docker buildx build \
    --platform linux/amd64 --file Dockerfile.k8s
    --tag us-docker.pkg.dev/vexxhost-infra/openstack/percona-xtradb-cluster:5.7.36-31.55-socatfix
    'https://github.com/percona/percona-docker.git#main:percona-xtradb-cluster-5.7'

We should flip this back to upstream once they release a new image.

Sem-Ver: feature
Change-Id: I765140a0a7b17717e31781e8212cb60d432d8e17
diff --git a/releasenotes/notes/fix-socat-percona-891da2e4726505a4.yaml b/releasenotes/notes/fix-socat-percona-891da2e4726505a4.yaml
new file mode 100644
index 0000000..3776df6
--- /dev/null
+++ b/releasenotes/notes/fix-socat-percona-891da2e4726505a4.yaml
@@ -0,0 +1,4 @@
+---
+fixes:
+  - Percona XtraDB clusters would fail to bootstrap due to an upstream bug in
+    the images with a too old version of socat (https://jira.percona.com/browse/PXC-3914).
diff --git a/roles/percona_xtradb_cluster/tasks/main.yml b/roles/percona_xtradb_cluster/tasks/main.yml
index 81c35cd..890f2b2 100644
--- a/roles/percona_xtradb_cluster/tasks/main.yml
+++ b/roles/percona_xtradb_cluster/tasks/main.yml
@@ -35,7 +35,8 @@
         secretsName: percona-xtradb
         pxc:
           size: 3
-          image: percona/percona-xtradb-cluster:5.7.36-31.55
+          # NOTE(mnaser): https://jira.percona.com/browse/PXC-3914
+          image: us-docker.pkg.dev/vexxhost-infra/openstack/percona-xtradb-cluster:5.7.36-31.55-socatfix
           autoRecovery: true
           configuration: |
             [mysqld]