# Create PXC Cluster: sed: -e expression

**URL:** https://forums.percona.com/t/create-pxc-cluster-sed-e-expression/9659
**Category:** Percona Operator for MySQL
**Tags:** percona
**Created:** [March 15, 2021, 12:55pm UTC](https://forums.percona.com/t/create-pxc-cluster-sed-e-expression/9659 "2021-03-15T12:55:01Z")
**Posts on this page:** 20
**Page:** 1

<div class="post-metadata">

### Author: ![Zoltan\_Morvai](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/zoltan_morvai/32/3198_2.png) [@Zoltan\_Morvai](https://forums.percona.com/u/Zoltan_Morvai)
#### Post date: [March 15, 2021, 12:55pm UTC](https://forums.percona.com/t/create-pxc-cluster-sed-e-expression/9659/1 "2021-03-15T12:55:02Z")

</div>

Hello,  
I have had the following problem (bug?):

- PXC Operator 1.7.0
- Cluster with 3 Instance

Pod Log / Error with create cluster, first instance:  
…  
+ sed ‘/^[mysqld]/a wsrep\_provider\_options=“pc.weight=10”\n’ /etc/mysql/node.cnf  
+ sed -r ‘s|\[1\]?server\_id=._$|server\_id=10|’ /etc/mysql/node.cnf  
+ sed -r ‘s|\[2\]?coredumper$|coredumper|’ /etc/mysql/node.cnf  
+ sed -r 's|\[3\]?wsrep\_node\_address=._$|wsrep\_node\_address=x.x.x.x|’ /etc/mysql/node.cnf  
+ sed -r ‘s|\[4\]?wsrep\_cluster\_name=._$|wsrep\_cluster\_name=btest-pxc|’ /etc/mysql/node.cnf  
+ sed -r 's|\[5\]?wsrep\_sst\_donor=._$|wsrep\_sst\_donor=|’ /etc/mysql/node.cnf  
+ sed -r ‘s|\[6\]?wsrep\_cluster\_address=._$|wsrep\_cluster\_address=gcomm://|’ /etc/mysql/node.cnf  
+ sed -r 's|\[7\]?wsrep\_node\_incoming\_address=._$|wsrep\_node\_incoming\_address=btest-pxc-0.btest- pxc.pxc.svc.cluster.local:3306|’ /etc/mysql/node.cnf  
**sed: -e expression #1, char 72: unterminated `s’ command**

If I define the variable XTRABACKUP\_PASSWORD in **pxc-configure-pxc.sh** then it continues to run (XTRABACKUP\_PASSWORD=backup\_password):

```
....
NODE_IP=$(hostname -I | awk ' { print $1 } ')
CLUSTER_NAME="$(hostname -f | cut -d'.' -f2)"
SERVER_ID=${HOSTNAME/$CLUSTER_NAME-}
NODE_NAME=$(hostname -f)
NODE_PORT=3306
XTRABACKUP_PASSWORD=backup_password
...

```

Password is originally defined in secret, of course.

thx  
Zoltan

* * *

1. # 

2. # 

3. # 

4. # 

5. # 

6. # 

7. #

---

<div class="post-metadata">

### Author: ![vadimtk](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vadimtk/32/9528_2.png) [@vadimtk](https://forums.percona.com/u/vadimtk)
#### Post date: [March 16, 2021, 11:21am UTC](https://forums.percona.com/t/create-pxc-cluster-sed-e-expression/9659/2 "2021-03-16T11:21:10Z")

</div>

Do you use a custom cr.yaml file?  
Can you share it ?

---

<div class="post-metadata">

### Author: ![Zoltan\_Morvai](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/zoltan_morvai/32/3198_2.png) [@Zoltan\_Morvai](https://forums.percona.com/u/Zoltan_Morvai)
#### Post date: [March 16, 2021, 2:52pm UTC](https://forums.percona.com/t/create-pxc-cluster-sed-e-expression/9659/3 "2021-03-16T14:52:33Z")

</div>

yes, my custom cr YAML:

```
#
# PXC Test Cluster
# Node : 3
# SQL Proxy : NO
# Monitor (pmm) : YES
# Backup : NO
#
apiVersion: pxc.percona.com/v1-7-0
kind: PerconaXtraDBCluster
metadata:
  name: booqer
  namespace: pxc
  finalizers:
    - delete-pxc-pods-in-order
# - delete-proxysql-pvc
    - delete-pxc-pvc
# annotations:
# percona.com/issue-vault-token: "true"
spec:
  crVersion: 1.7.0
  secretsName: pxc-secrets-booqer
  vaultSecretName: keyring-secret-vault
  sslSecretName: my-cluster-ssl
  sslInternalSecretName: my-cluster-ssl-internal
  logCollectorSecretName: my-log-collector-secrets
  allowUnsafeConfigurations: true
# pause: false
  updateStrategy: SmartUpdate
  upgradeOptions:
    versionServiceEndpoint: https://check.percona.com
    apply: recommended
    schedule: "11 4 * * 6"
  pxc:
    size: 3
    image: percona/percona-xtradb-cluster:8.0.21-12.1
    autoRecovery: true
    configuration: |
        [client]
        default-character-set=utf8mb4
        [mysql]
        default-character-set=utf8mb4
        [mysqld]
        character-set-client-handshake=false
        character-set-server=utf8mb4
        collation-server="utf8mb4_unicode_ci"
        #innodb_buffer_pool_size=805306368
        max_connections=2048
        sql_mode = "STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE"
        #wsrep_debug=ON
        #wsrep_provider_options="gcache.size=1G; gcache.recover=yes"
    containerSecurityContext:
      privileged: false
    podSecurityContext:
      runAsUser: 1001
      runAsGroup: 1001
      supplementalGroups: [1001]
    resources:
      requests:
        memory: 1G
        cpu: "1"
# ephemeral-storage: 1Gi
      limits:
        memory: 4G
        cpu: "4"
# ephemeral-storage: 1Gi
# nodeSelector:
# disktype: ssd
    affinity:
      antiAffinityTopologyKey: "kubernetes.io/hostname"
# advanced:
# nodeAffinity:
# requiredDuringSchedulingIgnoredDuringExecution:
# nodeSelectorTerms:
# - matchExpressions:
# - key: kubernetes.io/e2e-az-name
# operator: In
# values:
# - e2e-az1
# - e2e-az2
# tolerations:
# - key: "node.alpha.kubernetes.io/unreachable"
# operator: "Exists"
# effect: "NoExecute"
# tolerationSeconds: 6000
    podDisruptionBudget:
      maxUnavailable: 1
# minAvailable: 0
    volumeSpec:
      persistentVolumeClaim:
        storageClassName: "cephfs"
        accessModes: ["ReadWriteMany"]
        resources:
          requests:
            storage: 21Gi
    gracePeriod: 600
  haproxy:
    enabled: true
    size: 2
    image: percona/percona-xtradb-cluster-operator:1.7.0-haproxy
    resources:
      requests:
        memory: 30Mi
        cpu: 50m
      limits:
        memory: 500Mi
        cpu: 500m
# priorityClassName: high-priority
# nodeSelector:
# disktype: ssd
# sidecarResources:
# requests:
# memory: 1G
# cpu: 500m
# limits:
# memory: 2G
# cpu: 600m
# serviceAccountName: percona-xtradb-cluster-operator-workload
    affinity:
      antiAffinityTopologyKey: "kubernetes.io/hostname"
# advanced:
# nodeAffinity:
# requiredDuringSchedulingIgnoredDuringExecution:
# nodeSelectorTerms:
# - matchExpressions:
# - key: kubernetes.io/e2e-az-name
# operator: In
# values:
# - e2e-az1
# - e2e-az2
# tolerations:
# - key: "node.alpha.kubernetes.io/unreachable"
# operator: "Exists"
# effect: "NoExecute"
# tolerationSeconds: 6000
    podDisruptionBudget:
      maxUnavailable: 1
# minAvailable: 0
    gracePeriod: 30
# loadBalancerSourceRanges:
# - 10.0.0.0/8
# serviceAnnotations:
# service.beta.kubernetes.io/aws-load-balancer-backend-protocol: http
  proxysql:
    enabled: false
    size: 1
    image: percona/percona-xtradb-cluster-operator:1.7.0-proxysql
    resources:
      requests:
        memory: 1G
        cpu: 600m
# limits:
# memory: 1G
# cpu: 700m
# priorityClassName: high-priority
# nodeSelector:
# disktype: ssd
# sidecarResources:
# requests:
# memory: 1G
# cpu: 500m
# limits:
# memory: 2G
# cpu: 600m
# serviceAccountName: percona-xtradb-cluster-operator-workload
    affinity:
      antiAffinityTopologyKey: "kubernetes.io/hostname"
# advanced:
# nodeAffinity:
# requiredDuringSchedulingIgnoredDuringExecution:
# nodeSelectorTerms:
# - matchExpressions:
# - key: kubernetes.io/e2e-az-name
# operator: In
# values:
# - e2e-az1
# - e2e-az2
# tolerations:
# - key: "node.alpha.kubernetes.io/unreachable"
# operator: "Exists"
# effect: "NoExecute"
# tolerationSeconds: 6000
    volumeSpec:
# emptyDir: {}
# hostPath:
# path: /data
# type: Directory
      persistentVolumeClaim:
# storageClassName: standard
# accessModes: ["ReadWriteOnce"]
        resources:
          requests:
            storage: 2Gi
    podDisruptionBudget:
      maxUnavailable: 1
# minAvailable: 0
    gracePeriod: 30
# loadBalancerSourceRanges:
# - 10.0.0.0/8
# serviceAnnotations:
# service.beta.kubernetes.io/aws-load-balancer-backend-protocol: http
  logcollector:
    enabled: false
    image: percona/percona-xtradb-cluster-operator:1.7.0-logcollector
  pmm:
    enabled: true
    image: percona/pmm-client:2.12.0
    serverHost: monitoring-service
    serverUser: pmm
# pxcParams: "--disable-tablestats-limit=2000"
# proxysqlParams: "--custom-labels=CUSTOM-LABELS"
    resources:
      requests:
        memory: 200M
        cpu: 500m
  backup:
    enabled: false
    image: percona/percona-xtradb-cluster-operator:1.7.0-pxc8.0-backup
# serviceAccountName: percona-xtradb-cluster-operator
# imagePullSecrets:
# - name: private-registry-credentials
    pitr:
      enabled: false
    # storageName: STORAGE-NAME-HERE
    # timeBetweenUploads: 60
    # storages:
    # ceph-fs:
    # type: filesystem
    # volume:
    # persistentVolumeClaim:
    # storageClassName: "cephfs"
    # accessModes:
    # - ReadWriteOnce
    # resources:
    # requests:
    # storage: 56Mi
    # schedule:
    # - name: "sat-night-backup"
    # schedule: "0 0 * * 6"
    # keep: 3
    # storageName: s3-us-west
    # - name: "daily-backup"
    # schedule: "0 0 * * *"
    # keep: 5
    # storageName: fs-pvc%

```

---

<div class="post-metadata">

### Author: ![Sergey\_Pronin](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/sergey_pronin/32/14887_2.png) [@Sergey\_Pronin](https://forums.percona.com/u/Sergey_Pronin)
#### Post date: [March 17, 2021, 7:42am UTC](https://forums.percona.com/t/create-pxc-cluster-sed-e-expression/9659/4 "2021-03-17T07:42:10Z")

</div>

Hello @Zoltan_Morvai ,

I have tried to deploy the cr.yaml you shared and it worked for me. I removed podSecurityContext section completely and changed the storage configuration (I have another class).  
Do you have any other customizations?  
How did you come to the conclusion that **pxc-configure-pxc.sh** needs to be changed?

---

<div class="post-metadata">

### Author: ![Zoltan\_Morvai](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/zoltan_morvai/32/3198_2.png) [@Zoltan\_Morvai](https://forums.percona.com/u/Zoltan_Morvai)
#### Post date: [March 17, 2021, 1:14pm UTC](https://forums.percona.com/t/create-pxc-cluster-sed-e-expression/9659/5 "2021-03-17T13:14:29Z")

</div>

Thank you for the reply.  
Yes, I have also changed the secret (see below).  
I saw at which line the script error occurred, then it was clear to me that the variable XTRABACKUP\_PASSWORD is not defined.

```
apiVersion: v1
kind: Secret
metadata:
  name: pxc-secrets-booqer
type: Opaque
stringData:
  root: yu73Pu8ueZJ8WyRj9947iaoa
  xtrabackup: 4fW9d27i3KT3p4UsQm8
  monitor: monitory
  clustercheck: clustercheckpassword
  proxyadmin: admin_password
  pmmserver: supa|^|pazz
  operator: xTc7Fwpg8N2344G79qg

```

---

<div class="post-metadata">

### Author: ![browseman](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/browseman/32/98_2.png) [@browseman](https://forums.percona.com/u/browseman)
#### Post date: [March 17, 2021, 1:42pm UTC](https://forums.percona.com/t/create-pxc-cluster-sed-e-expression/9659/6 "2021-03-17T13:42:48Z")

</div>

On a first glance it seems that the use of ‘|’ character in the password is braking the sed. As can be seen from the first snippet, sed is using the same ‘|’ for logical delimiter.  
May be you can try the same setup, just change ‘|’ with some other special character before that. Please write back if this did help as it can be helpful for others.

---

<div class="post-metadata">

### Author: ![Sergey\_Pronin](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/sergey_pronin/32/14887_2.png) [@Sergey\_Pronin](https://forums.percona.com/u/Sergey_Pronin)
#### Post date: [March 17, 2021, 2:10pm UTC](https://forums.percona.com/t/create-pxc-cluster-sed-e-expression/9659/7 "2021-03-17T14:10:10Z")

</div>

It worked for me with these Secrets as well 😕  
Special char is not a problem.

---

<div class="post-metadata">

### Author: ![Zoltan\_Morvai](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/zoltan_morvai/32/3198_2.png) [@Zoltan\_Morvai](https://forums.percona.com/u/Zoltan_Morvai)
#### Post date: [March 17, 2021, 6:27pm UTC](https://forums.percona.com/t/create-pxc-cluster-sed-e-expression/9659/8 "2021-03-17T18:27:25Z")

</div>

Maybe one more point: I have 2 namespaces where I have installed the operators separately. In the first NS it worked without problems, there is only 1 replica. I only get the error in the 2nd NS with 3 replicas.

---

<div class="post-metadata">

### Author: ![Zoltan\_Morvai](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/zoltan_morvai/32/3198_2.png) [@Zoltan\_Morvai](https://forums.percona.com/u/Zoltan_Morvai)
#### Post date: [March 17, 2021, 6:33pm UTC](https://forums.percona.com/t/create-pxc-cluster-sed-e-expression/9659/9 "2021-03-17T18:33:07Z")

</div>

Another interesting thing: I wanted to install 2 different PXC in the same NS. Let’s call them PXC-A and PXC-B. So 1 operator with 2 PXC clusters (not NS overlapping operators).  
After having successfully installed the PXC-A, the PXC-B cannot be installed. But what was super interesting, I saw in the PXC-A DB log that it tried to reach the members of the PXC-B!  
It shouldn’t happen, should it!  
Then I moved the PXC-B to a separate NS, but that didn’t work either. ☹

---

<div class="post-metadata">

### Author: ![Zoltan\_Morvai](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/zoltan_morvai/32/3198_2.png) [@Zoltan\_Morvai](https://forums.percona.com/u/Zoltan_Morvai)
#### Post date: [March 22, 2021, 1:04pm UTC](https://forums.percona.com/t/create-pxc-cluster-sed-e-expression/9659/10 "2021-03-22T13:04:36Z")

</div>

Hello spronin,

any news?  
Have I been right with the 2 Instazen (reproducible), or the problem is just me?

Thank you.

---

<div class="post-metadata">

### Author: ![Sergey\_Pronin](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/sergey_pronin/32/14887_2.png) [@Sergey\_Pronin](https://forums.percona.com/u/Sergey_Pronin)
#### Post date: [March 22, 2021, 2:12pm UTC](https://forums.percona.com/t/create-pxc-cluster-sed-e-expression/9659/11 "2021-03-22T14:12:19Z")

</div>

Hello @Zoltan_Morvai ,

sorry for not coming back sooner. I’m running two clusters in one namespace:

```auto
cluster1-haproxy-0 2/2 Running 0 40m
cluster1-haproxy-1 2/2 Running 0 39m
cluster1-haproxy-2 2/2 Running 0 38m
cluster1-pxc-0 3/3 Running 0 36m
cluster1-pxc-1 3/3 Running 0 39m
cluster1-pxc-2 3/3 Running 0 38m
cluster2-haproxy-0 2/2 Running 1 34m
cluster2-pxc-0 3/3 Running 0 4m46s
cluster2-pxc-1 3/3 Running 0 29m
cluster2-pxc-2 3/3 Running 0 27m

```

They are both healthy and ready:

```auto
$ kubectl get pxc
NAME ENDPOINT STATUS PXC PROXYSQL HAPROXY AGE
cluster1 cluster1-haproxy.default ready 3 3 41m
cluster2 cluster2-haproxy.default ready 3 1 34m

```

And I don’t see logs overlapping.  
I would be curious to learn more about your use case. Are you running a cluster-wide mode of the operator or a namespace-scoped?

---

<div class="post-metadata">

### Author: ![Zoltan\_Morvai](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/zoltan_morvai/32/3198_2.png) [@Zoltan\_Morvai](https://forums.percona.com/u/Zoltan_Morvai)
#### Post date: [March 22, 2021, 3:18pm UTC](https://forums.percona.com/t/create-pxc-cluster-sed-e-expression/9659/12 "2021-03-22T15:18:38Z")

</div>

> [@Sergey\_Pronin](#):
>
> cluster-wide mode

no, I do not use cluster-wide mode

---

<div class="post-metadata">

### Author: ![Zoltan\_Morvai](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/zoltan_morvai/32/3198_2.png) [@Zoltan\_Morvai](https://forums.percona.com/u/Zoltan_Morvai)
#### Post date: [March 23, 2021, 7:27am UTC](https://forums.percona.com/t/create-pxc-cluster-sed-e-expression/9659/13 "2021-03-23T07:27:45Z")

</div>

Ok, thanks.  
It is then due to my environment.  
One more thing: my test environment (filesystem) is relatively slow. Initialization takes 3-4 minutes or longer, can it cause problems?

---

<div class="post-metadata">

### Author: ![Sergey\_Pronin](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/sergey_pronin/32/14887_2.png) [@Sergey\_Pronin](https://forums.percona.com/u/Sergey_Pronin)
#### Post date: [March 23, 2021, 9:56am UTC](https://forums.percona.com/t/create-pxc-cluster-sed-e-expression/9659/14 "2021-03-23T09:56:05Z")

</div>

@Zoltan_Morvai I don’t believe slow storage can cause any of these problems, but I will see if I can reproduce it with chaos eng.  
Maybe we are catching some weird race condition.

---

<div class="post-metadata">

### Author: ![mygov](https://avatars.discourse-cdn.com/v4/letter/m/8dc957/32.png) [@mygov](https://forums.percona.com/u/mygov)
#### Post date: [March 24, 2021, 7:21pm UTC](https://forums.percona.com/t/create-pxc-cluster-sed-e-expression/9659/15 "2021-03-24T19:21:53Z")

</div>

We have the same issue with the Operator for OKD / OpenShift.  
After we install the Percona XtraDB Cluster Operator via the OperatorHub (latest v1.7.0).  
Before “Create PerconaXtraDBClusters”, we created the namespace pxc and applied the secrets.yaml (See “Before You Start” section in operatorhubDOTio/operator/percona-xtradb-cluster-operator - we even tried with the default secrets in the before you start-section)

We tried also with the default YAML (Since I am only allowed to post two links, I replaced .com and https:// with XXX and . with DOT):

> ```
> apiVersion: pxc.perconaXXX/v1-7-0
> kind: PerconaXtraDBCluster
> metadata:
> name: cluster1
> finalizers:
> - delete-pxc-pods-in-order
> namespace: pxc
> spec:
> crVersion: 1.7.0
> secretsName: my-cluster-secrets
> vaultSecretName: keyring-secret-vault
> sslSecretName: my-cluster-ssl
> sslInternalSecretName: my-cluster-ssl-internal
> logCollectorSecretName: my-log-collector-secrets
> allowUnsafeConfigurations: false
> updateStrategy: SmartUpdate
> upgradeOptions:
> versionServiceEndpoint: 'XXXcheck.perconaXXX'
> apply: disabled
> schedule: 0 4 * * *
> pxc:
> size: 3
> image: 'percona/percona-xtradb-cluster:8.0.21-12.1'
> resources:
> requests:
> memory: 1G
> cpu: 600m
> affinity:
> antiAffinityTopologyKey: kubernetesDOTio/hostname
> podDisruptionBudget:
> maxUnavailable: 1
> volumeSpec:
> persistentVolumeClaim:
> resources:
> requests:
> storage: 6G
> gracePeriod: 600
> haproxy:
> enabled: true
> size: 3
> image: 'percona/percona-xtradb-cluster-operator:1.7.0-haproxy'
> resources:
> requests:
> memory: 1G
> cpu: 600m
> affinity:
> antiAffinityTopologyKey: kubernetesDOTio/hostname
> podDisruptionBudget:
> maxUnavailable: 1
> gracePeriod: 30
> proxysql:
> enabled: false
> size: 3
> image: 'percona/percona-xtradb-cluster-operator:1.7.0-proxysql'
> resources:
> requests:
> memory: 1G
> cpu: 600m
> affinity:
> antiAffinityTopologyKey: kubernetesDOTio/hostname
> volumeSpec:
> persistentVolumeClaim:
> resources:
> requests:
> storage: 2G
> podDisruptionBudget:
> maxUnavailable: 1
> gracePeriod: 30
> logcollector:
> enabled: true
> image: 'percona/percona-xtradb-cluster-operator:1.7.0-logcollector'
> pmm:
> enabled: false
> image: 'percona/pmm-client:2.12.0'
> serverHost: monitoring-service
> serverUser: pmm
> backup:
> image: 'percona/percona-xtradb-cluster-operator:1.7.0-pxc8.0-backup'
> pitr:
> enabled: false
> storageName: STORAGE-NAME-HERE
> timeBetweenUploads: 60
> storages:
> s3-us-west:
> type: s3
> s3:
> bucket: S3-BACKUP-BUCKET-NAME-HERE
> credentialsSecret: my-cluster-name-backup-s3
> region: us-west-2
> fs-pvc:
> type: filesystem
> volume:
> persistentVolumeClaim:
> accessModes:
> - ReadWriteOnce
> resources:
> requests:
> storage: 6G
> schedule:
> - name: sat-night-backup
> schedule: 0 0 * * 6
> keep: 3
> storageName: s3-us-west
> - name: daily-backup
> schedule: 0 0 * * *
> keep: 5
> storageName: fs-pvc
> 
> ```

After creating the pod cluster1-pxc-0 will stuck always in CrashLoopBackOff. The logs of the container pxc shows this error:

> ```
> + egrep -q '^[#]?log-error' /etc/mysql/node.cnf
> + sed '/^\[mysqld\]/a log-error=/var/lib/mysql/mysqld-error.log\n' /etc/mysql/node.cnf
> + egrep -q '^[#]?wsrep_sst_donor' /etc/mysql/node.cnf
> + sed '/^\[mysqld\]/a wsrep_sst_donor=\n' /etc/mysql/node.cnf
> + egrep -q '^[#]?wsrep_node_incoming_address' /etc/mysql/node.cnf
> + egrep -q '^[#]?wsrep_provider_options' /etc/mysql/node.cnf
> + sed '/^\[mysqld\]/a wsrep_provider_options="pc.weight=10"\n' /etc/mysql/node.cnf
> + sed -r 's|^[#]?server_id=.*$|server_id=10|' /etc/mysql/node.cnf
> + sed -r 's|^[#]?coredumper$|coredumper|' /etc/mysql/node.cnf
> + sed -r 's|^[#]?wsrep_node_address=.*$|wsrep_node_address=10.200.16.49|' /etc/mysql/node.cnf
> + sed -r 's|^[#]?wsrep_cluster_name=.*$|wsrep_cluster_name=cluster1-pxc|' /etc/mysql/node.cnf
> + sed -r 's|^[#]?wsrep_sst_donor=.*$|wsrep_sst_donor=|' /etc/mysql/node.cnf
> + sed -r 's|^[#]?wsrep_cluster_address=.*$|wsrep_cluster_address=gcomm://|' /etc/mysql/node.cnf
> + sed -r 's|^[#]?wsrep_node_incoming_address=.*$|wsrep_node_incoming_address=cluster1-pxc-0.cluster1-pxc.pxc.svc.cluster.local:3306|' /etc/mysql/node.cnf
> sed: -e expression #1, char 65: unterminated `s' command
> , err: exit status 1
> 
> ```

---

<div class="post-metadata">

### Author: ![Slava\_Sarzhan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/slava_sarzhan/32/3196_2.png) [@Slava\_Sarzhan](https://forums.percona.com/u/Slava_Sarzhan)
#### Post date: [March 25, 2021, 10:27am UTC](https://forums.percona.com/t/create-pxc-cluster-sed-e-expression/9659/16 "2021-03-25T10:27:02Z")

</div>

Hi @mygov ,

We have a task regarding this issue [[K8SPXC-573] Pod cluster1-pxc-0 fails with error: sed: -e expression #1, char 65: unterminated `s' command on OpenShift 4.6.9 - Percona JIRA](https://jira.percona.com/browse/K8SPXC-573) . It was fixed for the latest PXCO release. The fix will be available in next operator release (1.8.0).

---

<div class="post-metadata">

### Author: ![Zoltan\_Morvai](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/zoltan_morvai/32/3198_2.png) [@Zoltan\_Morvai](https://forums.percona.com/u/Zoltan_Morvai)
#### Post date: [March 25, 2021, 12:50pm UTC](https://forums.percona.com/t/create-pxc-cluster-sed-e-expression/9659/17 "2021-03-25T12:50:52Z")

</div>

> [@Slava\_Sarzhan](#):
>
> The fix will be available in next operator release (1.8.0).

can you already know when this 1.8.0 release is coming?

---

<div class="post-metadata">

### Author: ![Zoltan\_Morvai](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/zoltan_morvai/32/3198_2.png) [@Zoltan\_Morvai](https://forums.percona.com/u/Zoltan_Morvai)
#### Post date: [March 25, 2021, 12:53pm UTC](https://forums.percona.com/t/create-pxc-cluster-sed-e-expression/9659/18 "2021-03-25T12:53:34Z")

</div>

> [@mygov](#):
>
> After creating the pod cluster1-pxc-0 will stuck always in CrashLoopBackOff. The logs of the container pxc shows this error:

if you fix it manually runs the PXC cluster then clean?  
I have been getting lock file problems all the time.

---

<div class="post-metadata">

### Author: ![Slava\_Sarzhan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/slava_sarzhan/32/3196_2.png) [@Slava\_Sarzhan](https://forums.percona.com/u/Slava_Sarzhan)
#### Post date: [March 26, 2021, 10:15am UTC](https://forums.percona.com/t/create-pxc-cluster-sed-e-expression/9659/19 "2021-03-26T10:15:40Z")

</div>

> [@Zoltan\_Morvai](#):
>
> can you already know when this 1.8.0 release is coming?

We are starting the release process. 1.8.0 will be available in two or three weeks.

---

<div class="post-metadata">

### Author: ![mygov](https://avatars.discourse-cdn.com/v4/letter/m/8dc957/32.png) [@mygov](https://forums.percona.com/u/mygov)
#### Post date: [April 27, 2021, 8:03am UTC](https://forums.percona.com/t/create-pxc-cluster-sed-e-expression/9659/20 "2021-04-27T08:03:16Z")

</div>

@Slava_Sarzhan  
When can we expect the 1.8.0 release of the XtraDB Cluster Operator in [operatorhub.io](http://operatorhub.io)?

[Next page](https://forums.percona.com/t/create-pxc-cluster-sed-e-expression/9659.md?page=2)
