Log: /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/logs/users-8-0.log Warning: version difference between client (1.34) and server (1.31) exceeds the supported minor version skew of +/-1 Warning: version difference between client (1.34) and server (1.31) exceeds the supported minor version skew of +/-1 + create_infra users-4515 + local ns=users-4515 + '[' -n pxc-operator ']' + kubectl get pxc --all-namespaces -o wide + grep -v NAMESPACE + xargs -L 1 sh -xc 'kubectl patch pxc -n $0 $1 --type=merge -p "{\"metadata\":{\"finalizers\":[]}}"' + kubectl patch pxc -n users-27222 some-name --type=merge -p '{"metadata":{"finalizers":[]}}' perconaxtradbcluster.pxc.percona.com/some-name patched + kubectl_bin delete pxc --all --all-namespaces ++ mktemp + local LAST_OUT=/tmp/tmp.OHY6pMV3fn ++ mktemp + local LAST_ERR=/tmp/tmp.C74aa6Miib + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl delete pxc --all --all-namespaces + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.OHY6pMV3fn perconaxtradbcluster.pxc.percona.com "some-name" deleted from users-27222 namespace + cat /tmp/tmp.C74aa6Miib + rm /tmp/tmp.OHY6pMV3fn /tmp/tmp.C74aa6Miib + return 0 + kubectl_bin delete pxc-backup --all --all-namespaces ++ mktemp + local LAST_OUT=/tmp/tmp.STXryKcjtQ ++ mktemp + local LAST_ERR=/tmp/tmp.8her2epEx8 + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl delete pxc-backup --all --all-namespaces + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.STXryKcjtQ No resources found + cat /tmp/tmp.8her2epEx8 + rm /tmp/tmp.STXryKcjtQ /tmp/tmp.8her2epEx8 + return 0 + kubectl_bin delete pxc-restore --all --all-namespaces ++ mktemp + local LAST_OUT=/tmp/tmp.cwqWBbGmbe ++ mktemp + local LAST_ERR=/tmp/tmp.1B5iVOzOpq + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl delete pxc-restore --all --all-namespaces + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.cwqWBbGmbe No resources found + cat /tmp/tmp.1B5iVOzOpq + rm /tmp/tmp.cwqWBbGmbe /tmp/tmp.1B5iVOzOpq + return 0 + create_namespace pxc-operator + local namespace=pxc-operator + local skip_clean_namespace= + [[ 1 == 1 ]] + [[ -z '' ]] + destroy_chaos_mesh ++ helm list --all-namespaces --filter chaos-mesh ++ awk '-F ' '{print $2}' ++ sed s/NAMESPACE// ++ tail -n1 + local chaos_mesh_ns= + '[' -n '' ']' ++ kubectl get MutatingWebhookConfiguration ++ grep chaos-mesh ++ awk '{print $1}' + timeout 30 kubectl delete MutatingWebhookConfiguration error: resource(s) were provided, but no name was specified + : ++ kubectl get ValidatingWebhookConfiguration ++ grep chaos-mesh ++ awk '{print $1}' + timeout 30 kubectl delete ValidatingWebhookConfiguration error: resource(s) were provided, but no name was specified + : ++ kubectl get ValidatingWebhookConfiguration ++ grep validate-auth ++ awk '{print $1}' + timeout 30 kubectl delete ValidatingWebhookConfiguration error: resource(s) were provided, but no name was specified + : ++ kubectl api-resources ++ awk '{print $1}' ++ grep chaos-mesh ++ kubectl get crd ++ grep chaos-mesh.org ++ awk '{print $1}' + timeout 30 kubectl delete crd error: resource(s) were provided, but no name was specified + : ++ kubectl get clusterrolebinding ++ grep chaos-mesh ++ awk '{print $1}' + timeout 30 kubectl delete clusterrolebinding error: resource(s) were provided, but no name was specified + : ++ kubectl get clusterrole ++ grep chaos-mesh ++ awk '{print $1}' + timeout 30 kubectl delete clusterrole error: resource(s) were provided, but no name was specified + : + desc 'cleaned up all old namespaces' + set +o xtrace ----------------------------------------------------------------------------------- cleaned up all old namespaces ----------------------------------------------------------------------------------- + egrep -v '^kube-|^default|Terminating|pxc-operator|openshift|^gke-|^gmp-|^NAME' + awk '{print$1}' + '[' -n '' ']' + desc 'cleaned up old namespaces pxc-operator' + set +o xtrace ----------------------------------------------------------------------------------- cleaned up old namespaces pxc-operator ----------------------------------------------------------------------------------- + kubectl_bin delete namespace pxc-operator + xargs kubectl delete ns ++ mktemp + kubectl_bin get ns ++ mktemp + local LAST_OUT=/tmp/tmp.R3oGF4xZZN ++ mktemp + local LAST_OUT=/tmp/tmp.pj0A5BRICO ++ mktemp + local LAST_ERR=/tmp/tmp.FOKpaIIPZF + local exit_status=0 ++ seq 0 2 + local LAST_ERR=/tmp/tmp.KB59I7VLah + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl delete namespace pxc-operator + for i in '$(seq 0 2)' + set +e + kubectl get ns + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.pj0A5BRICO + cat /tmp/tmp.KB59I7VLah + rm /tmp/tmp.pj0A5BRICO /tmp/tmp.KB59I7VLah + return 0 namespace "users-27222" deleted + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.R3oGF4xZZN namespace "pxc-operator" deleted + cat /tmp/tmp.FOKpaIIPZF + rm /tmp/tmp.R3oGF4xZZN /tmp/tmp.FOKpaIIPZF + return 0 + wait_for_delete namespace/pxc-operator + local res=namespace/pxc-operator + echo -n 'waiting for namespace/pxc-operator to be deleted' waiting for namespace/pxc-operator to be deleted+ set +o xtrace Error from server (NotFound): namespaces "pxc-operator" not found + desc 'create namespace pxc-operator' + set +o xtrace ----------------------------------------------------------------------------------- create namespace pxc-operator ----------------------------------------------------------------------------------- + kubectl_bin create namespace pxc-operator ++ mktemp + local LAST_OUT=/tmp/tmp.j6zVCbBLRx ++ mktemp + local LAST_ERR=/tmp/tmp.Np0exUxlMi + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl create namespace pxc-operator + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.j6zVCbBLRx namespace/pxc-operator created + cat /tmp/tmp.Np0exUxlMi + rm /tmp/tmp.j6zVCbBLRx /tmp/tmp.Np0exUxlMi + return 0 ++ kubectl_bin config current-context +++ mktemp ++ local LAST_OUT=/tmp/tmp.PoQH0Xas8h +++ mktemp ++ local LAST_ERR=/tmp/tmp.aoueDXk9Ik ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl config current-context ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.PoQH0Xas8h ++ cat /tmp/tmp.aoueDXk9Ik ++ rm /tmp/tmp.PoQH0Xas8h /tmp/tmp.aoueDXk9Ik ++ return 0 + kubectl_bin config set-context gke_cloud-dev-112233_us-central1-a_jen-pxc-2221-842b7a7e-2-cluster2 --namespace=pxc-operator ++ mktemp + local LAST_OUT=/tmp/tmp.8NW9p2V44n ++ mktemp + local LAST_ERR=/tmp/tmp.uEuagriBno + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl config set-context gke_cloud-dev-112233_us-central1-a_jen-pxc-2221-842b7a7e-2-cluster2 --namespace=pxc-operator + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.8NW9p2V44n Context "gke_cloud-dev-112233_us-central1-a_jen-pxc-2221-842b7a7e-2-cluster2" modified. + cat /tmp/tmp.uEuagriBno + rm /tmp/tmp.8NW9p2V44n /tmp/tmp.uEuagriBno + return 0 + deploy_operator + desc 'start PXC operator' + set +o xtrace ----------------------------------------------------------------------------------- start PXC operator ----------------------------------------------------------------------------------- + kubectl_bin apply --server-side --force-conflicts -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/deploy/crd.yaml ++ mktemp + local LAST_OUT=/tmp/tmp.OmzonS5YKi ++ mktemp + local LAST_ERR=/tmp/tmp.FK7CN692Ho + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl apply --server-side --force-conflicts -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/deploy/crd.yaml + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.OmzonS5YKi customresourcedefinition.apiextensions.k8s.io/perconaxtradbclusterbackups.pxc.percona.com serverside-applied customresourcedefinition.apiextensions.k8s.io/perconaxtradbclusterrestores.pxc.percona.com serverside-applied customresourcedefinition.apiextensions.k8s.io/perconaxtradbclusters.pxc.percona.com serverside-applied + cat /tmp/tmp.FK7CN692Ho + rm /tmp/tmp.OmzonS5YKi /tmp/tmp.FK7CN692Ho + return 0 + '[' -n pxc-operator ']' + apply_rbac cw-rbac + local operator_namespace=pxc-operator + local rbac=cw-rbac + cat /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/deploy/cw-rbac.yaml + kubectl_bin apply -f - + sed -e 's^namespace: .*^namespace: pxc-operator^' ++ mktemp + local LAST_OUT=/tmp/tmp.uR6UHCHjFc ++ mktemp + local LAST_ERR=/tmp/tmp.wRey22Gki6 + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl apply -f - + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.uR6UHCHjFc clusterrole.rbac.authorization.k8s.io/percona-xtradb-cluster-operator unchanged serviceaccount/percona-xtradb-cluster-operator created clusterrolebinding.rbac.authorization.k8s.io/service-account-percona-xtradb-cluster-operator unchanged + cat /tmp/tmp.wRey22Gki6 + rm /tmp/tmp.uR6UHCHjFc /tmp/tmp.wRey22Gki6 + return 0 + cat /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/deploy/cw-operator.yaml + sed -e 's^failureThreshold: .*^failureThreshold: 10^' + yq eval '(select(.kind == "Deployment").spec.template.spec.containers[] | select(.name == "percona-xtradb-cluster-operator").env[] | select(.name == "DISABLE_TELEMETRY").value) = "true"' - + kubectl_bin apply -f - + yq eval '(select(.kind == "Deployment").spec.template.spec.containers[] | select(.name == "percona-xtradb-cluster-operator").env[] | select(.name == "LOG_LEVEL").value) = "VERBOSE"' - + sed -e 's^image: .*^image: perconalab/percona-xtradb-cluster-operator:PR-2221-842b7a7e^' ++ mktemp + local LAST_OUT=/tmp/tmp.HNluLokCIU ++ mktemp + local LAST_ERR=/tmp/tmp.1NdPmQvTMy + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl apply -f - + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.HNluLokCIU deployment.apps/percona-xtradb-cluster-operator created service/percona-xtradb-cluster-operator created + cat /tmp/tmp.1NdPmQvTMy + rm /tmp/tmp.HNluLokCIU /tmp/tmp.1NdPmQvTMy + return 0 + sleep 10 + kubectl_bin wait --for=condition=Ready pods -l app.kubernetes.io/component=operator,app.kubernetes.io/instance=percona-xtradb-cluster-operator,app.kubernetes.io/name=percona-xtradb-cluster-operator --timeout=30s ++ mktemp + local LAST_OUT=/tmp/tmp.rdFGG6lTwn ++ mktemp + local LAST_ERR=/tmp/tmp.Mcu59Ss3tX + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl wait --for=condition=Ready pods -l app.kubernetes.io/component=operator,app.kubernetes.io/instance=percona-xtradb-cluster-operator,app.kubernetes.io/name=percona-xtradb-cluster-operator --timeout=30s + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.rdFGG6lTwn pod/percona-xtradb-cluster-operator-6d956cbb4b-p6crc condition met + cat /tmp/tmp.Mcu59Ss3tX + rm /tmp/tmp.rdFGG6lTwn /tmp/tmp.Mcu59Ss3tX + return 0 ++ get_operator_pod ++ local label_prefix=app.kubernetes.io/ +++ kubectl get pods --selector=app.kubernetes.io/name=percona-xtradb-cluster-operator -n pxc-operator +++ grep -c percona-xtradb-cluster-operator ++ local check_label=1 ++ [[ 1 -eq 0 ]] ++ kubectl_bin get pods --selector=app.kubernetes.io/name=percona-xtradb-cluster-operator -o 'jsonpath={.items[].metadata.name}' -n pxc-operator +++ mktemp ++ local LAST_OUT=/tmp/tmp.mbenM080m5 +++ mktemp ++ local LAST_ERR=/tmp/tmp.IjH3aXe9is ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=app.kubernetes.io/name=percona-xtradb-cluster-operator -o 'jsonpath={.items[].metadata.name}' -n pxc-operator ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.mbenM080m5 ++ cat /tmp/tmp.IjH3aXe9is ++ rm /tmp/tmp.mbenM080m5 /tmp/tmp.IjH3aXe9is ++ return 0 + wait_pod percona-xtradb-cluster-operator-6d956cbb4b-p6crc 480 pxc-operator + local pod=percona-xtradb-cluster-operator-6d956cbb4b-p6crc + local max_retry=480 + local ns=pxc-operator ++ echo percona-xtradb-cluster-operator-6d956cbb4b-p6crc ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/percona-xtradb-cluster-operator-6d956cbb4b-p6crc condition met waiting for pod/percona-xtradb-cluster-operator-6d956cbb4b-p6crc to become Ready.Ok + sleep 3 + create_namespace users-4515 + local namespace=users-4515 + local skip_clean_namespace= + [[ 1 == 1 ]] + [[ -z '' ]] + destroy_chaos_mesh ++ helm list --all-namespaces --filter chaos-mesh ++ tail -n1 ++ awk '-F ' '{print $2}' ++ sed s/NAMESPACE// + local chaos_mesh_ns= + '[' -n '' ']' ++ kubectl get MutatingWebhookConfiguration ++ grep chaos-mesh ++ awk '{print $1}' + timeout 30 kubectl delete MutatingWebhookConfiguration error: resource(s) were provided, but no name was specified + : ++ kubectl get ValidatingWebhookConfiguration ++ grep chaos-mesh ++ awk '{print $1}' + timeout 30 kubectl delete ValidatingWebhookConfiguration error: resource(s) were provided, but no name was specified + : ++ kubectl get ValidatingWebhookConfiguration ++ grep validate-auth ++ awk '{print $1}' + timeout 30 kubectl delete ValidatingWebhookConfiguration error: resource(s) were provided, but no name was specified + : ++ kubectl api-resources ++ grep chaos-mesh ++ awk '{print $1}' ++ kubectl get crd ++ grep chaos-mesh.org ++ awk '{print $1}' + timeout 30 kubectl delete crd error: resource(s) were provided, but no name was specified + : ++ kubectl get clusterrolebinding ++ grep chaos-mesh ++ awk '{print $1}' + timeout 30 kubectl delete clusterrolebinding error: resource(s) were provided, but no name was specified + : ++ kubectl get clusterrole ++ grep chaos-mesh ++ awk '{print $1}' + timeout 30 kubectl delete clusterrole error: resource(s) were provided, but no name was specified + : + desc 'cleaned up all old namespaces' + set +o xtrace ----------------------------------------------------------------------------------- cleaned up all old namespaces ----------------------------------------------------------------------------------- + kubectl_bin get ns + egrep -v '^kube-|^default|Terminating|pxc-operator|openshift|^gke-|^gmp-|^NAME' + awk '{print$1}' + '[' -n '' ']' + desc 'cleaned up old namespaces users-4515' + set +o xtrace ----------------------------------------------------------------------------------- cleaned up old namespaces users-4515 ----------------------------------------------------------------------------------- + kubectl_bin delete namespace users-4515 ++ mktemp ++ mktemp + xargs kubectl delete ns + local LAST_OUT=/tmp/tmp.eeH4iCWMcr ++ mktemp + local LAST_OUT=/tmp/tmp.ntNwNx7eS3 ++ mktemp + local LAST_ERR=/tmp/tmp.7rs70usYPw + local exit_status=0 + local LAST_ERR=/tmp/tmp.fVNZiXegjl + local exit_status=0 ++ seq 0 2 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl get ns + for i in '$(seq 0 2)' + set +e + kubectl delete namespace users-4515 + exit_status=1 + set -e + '[' 1 '!=' 0 ']' + '[' 1 == 1 ']' + sleep 0 + for i in '$(seq 0 2)' + set +e + kubectl delete namespace users-4515 + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.eeH4iCWMcr + cat /tmp/tmp.7rs70usYPw + rm /tmp/tmp.eeH4iCWMcr /tmp/tmp.7rs70usYPw + return 0 error: resource(s) were provided, but no name was specified + exit_status=1 + set -e + '[' 1 '!=' 0 ']' + '[' 1 == 1 ']' + sleep 0 + for i in '$(seq 0 2)' + set +e + kubectl delete namespace users-4515 + exit_status=1 + set -e + '[' 1 '!=' 0 ']' + '[' 1 == 1 ']' + sleep 0 + cat /tmp/tmp.ntNwNx7eS3 + cat /tmp/tmp.fVNZiXegjl Error from server (NotFound): namespaces "users-4515" not found + rm /tmp/tmp.ntNwNx7eS3 /tmp/tmp.fVNZiXegjl + return 1 + : + wait_for_delete namespace/users-4515 + local res=namespace/users-4515 + echo -n 'waiting for namespace/users-4515 to be deleted' waiting for namespace/users-4515 to be deleted+ set +o xtrace Error from server (NotFound): namespaces "users-4515" not found + desc 'create namespace users-4515' + set +o xtrace ----------------------------------------------------------------------------------- create namespace users-4515 ----------------------------------------------------------------------------------- + kubectl_bin create namespace users-4515 ++ mktemp + local LAST_OUT=/tmp/tmp.b800HCAlKr ++ mktemp + local LAST_ERR=/tmp/tmp.EuTwcib9uD + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl create namespace users-4515 + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.b800HCAlKr namespace/users-4515 created + cat /tmp/tmp.EuTwcib9uD + rm /tmp/tmp.b800HCAlKr /tmp/tmp.EuTwcib9uD + return 0 ++ kubectl_bin config current-context +++ mktemp ++ local LAST_OUT=/tmp/tmp.R5PdcvtxYT +++ mktemp ++ local LAST_ERR=/tmp/tmp.usdFGVxLuI ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl config current-context ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.R5PdcvtxYT ++ cat /tmp/tmp.usdFGVxLuI ++ rm /tmp/tmp.R5PdcvtxYT /tmp/tmp.usdFGVxLuI ++ return 0 + kubectl_bin config set-context gke_cloud-dev-112233_us-central1-a_jen-pxc-2221-842b7a7e-2-cluster2 --namespace=users-4515 ++ mktemp + local LAST_OUT=/tmp/tmp.NPPX4qkKOj ++ mktemp + local LAST_ERR=/tmp/tmp.tuHzS2TkOp + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl config set-context gke_cloud-dev-112233_us-central1-a_jen-pxc-2221-842b7a7e-2-cluster2 --namespace=users-4515 + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.NPPX4qkKOj Context "gke_cloud-dev-112233_us-central1-a_jen-pxc-2221-842b7a7e-2-cluster2" modified. + cat /tmp/tmp.tuHzS2TkOp + rm /tmp/tmp.NPPX4qkKOj /tmp/tmp.tuHzS2TkOp + return 0 + apply_secrets + desc 'create secrets for cloud storages' + set +o xtrace ----------------------------------------------------------------------------------- create secrets for cloud storages ----------------------------------------------------------------------------------- + '[' -z '' ']' + kubectl_bin apply -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/conf/minio-secret.yml -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/conf/cloud-secret.yml ++ mktemp + local LAST_OUT=/tmp/tmp.MgWvdJNDUn ++ mktemp + local LAST_ERR=/tmp/tmp.CFsQdcwlSb + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl apply -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/conf/minio-secret.yml -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/conf/cloud-secret.yml + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.MgWvdJNDUn secret/minio-secret created secret/aws-s3-secret created secret/gcp-cs-secret created secret/azure-secret created + cat /tmp/tmp.CFsQdcwlSb + rm /tmp/tmp.MgWvdJNDUn /tmp/tmp.CFsQdcwlSb + return 0 + desc 'create PXC cluster with 1-password secret' + set +o xtrace ----------------------------------------------------------------------------------- create PXC cluster with 1-password secret ----------------------------------------------------------------------------------- + newpass=test-password ++ echo -n test-password ++ base64 + newpassencrypted=dGVzdC1wYXNzd29yZA== + cluster=some-name + spinup_pxc some-name /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/conf/some-name.yml '' '' /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/conf/secrets_one_pass.yml + local cluster=some-name + local config=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/conf/some-name.yml + local size=3 + local sleep=10 + local secretsFile=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/conf/secrets_one_pass.yml + local pxcClientFile=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/conf/client.yml + local port=3306 + desc 'create first PXC cluster' + set +o xtrace ----------------------------------------------------------------------------------- create first PXC cluster ----------------------------------------------------------------------------------- + kubectl_bin apply -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/conf/secrets_one_pass.yml ++ mktemp + local LAST_OUT=/tmp/tmp.osDyR0QQq5 ++ mktemp + local LAST_ERR=/tmp/tmp.bl3kEYkYFw + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl apply -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/conf/secrets_one_pass.yml + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.osDyR0QQq5 secret/my-cluster-secrets created secret/some-name-ssl created secret/some-name-ssl-internal created + cat /tmp/tmp.bl3kEYkYFw + rm /tmp/tmp.osDyR0QQq5 /tmp/tmp.bl3kEYkYFw + return 0 + apply_config /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/conf/client.yml + '[' -z '' ']' + cat_config /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/conf/client.yml + kubectl_bin apply -f - ++ mktemp + /usr/bin/sed -e 's#apiVersion: pxc.percona.com/v.*$#apiVersion: pxc.percona.com/v1#' + cat /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/conf/client.yml + local LAST_OUT=/tmp/tmp.ZaKqAzXPZt + /usr/bin/sed -e 's#image:.*\/percona-xtradb-cluster:.*$#image: perconalab/percona-xtradb-cluster-operator:main-pxc8.0#' + /usr/bin/sed -e 's#image:.*-backup$#image: perconalab/percona-xtradb-cluster-operator:main-pxc8.0-backup#' + /usr/bin/sed -e 's#apply:.*#apply: Never#' ++ mktemp + local LAST_ERR=/tmp/tmp.D6weGLVlm2 + /usr/bin/sed -e s~minio-service.#namespace~minio-service.users-4515~ + local exit_status=0 + /usr/bin/sed -e 's#image:.*-proxysql$#image: perconalab/percona-xtradb-cluster-operator:main-proxysql#' ++ seq 0 2 + /usr/bin/sed -e 's#image:.*-logcollector$#image: perconalab/percona-xtradb-cluster-operator:main-logcollector#' + /usr/bin/sed -e 's#image:.*-pxc\([0-9]*.[0-9]*\)\{0,1\}$#image: perconalab/percona-xtradb-cluster-operator:main-pxc8.0#' + for i in '$(seq 0 2)' + set +e + kubectl apply -f - + /usr/bin/sed -e 's#image:.*-init$#image: perconalab/percona-xtradb-cluster-operator:PR-2221-842b7a7e#' + /usr/bin/sed -e 's#image:.*-pmm$#image: perconalab/pmm-client:dev-latest#' + /usr/bin/sed -e 's#image:.*-haproxy$#image: perconalab/percona-xtradb-cluster-operator:main-haproxy#' + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.ZaKqAzXPZt deployment.apps/pxc-client created + cat /tmp/tmp.D6weGLVlm2 + rm /tmp/tmp.ZaKqAzXPZt /tmp/tmp.D6weGLVlm2 + return 0 + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + apply_config /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/conf/some-name.yml + '[' -z '' ']' + cat_config /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/conf/some-name.yml + kubectl_bin apply -f - + cat /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/conf/some-name.yml + /usr/bin/sed -e 's#apiVersion: pxc.percona.com/v.*$#apiVersion: pxc.percona.com/v1#' + /usr/bin/sed -e 's#image:.*-pxc\([0-9]*.[0-9]*\)\{0,1\}$#image: perconalab/percona-xtradb-cluster-operator:main-pxc8.0#' + /usr/bin/sed -e 's#image:.*\/percona-xtradb-cluster:.*$#image: perconalab/percona-xtradb-cluster-operator:main-pxc8.0#' + /usr/bin/sed -e 's#image:.*-init$#image: perconalab/percona-xtradb-cluster-operator:PR-2221-842b7a7e#' + /usr/bin/sed -e 's#apply:.*#apply: Never#' ++ mktemp + /usr/bin/sed -e 's#image:.*-backup$#image: perconalab/percona-xtradb-cluster-operator:main-pxc8.0-backup#' + /usr/bin/sed -e 's#image:.*-proxysql$#image: perconalab/percona-xtradb-cluster-operator:main-proxysql#' + /usr/bin/sed -e 's#image:.*-haproxy$#image: perconalab/percona-xtradb-cluster-operator:main-haproxy#' + local LAST_OUT=/tmp/tmp.DwOGphyYVG + /usr/bin/sed -e 's#image:.*-pmm$#image: perconalab/pmm-client:dev-latest#' ++ mktemp + local LAST_ERR=/tmp/tmp.6hrqR5Ya8Y + local exit_status=0 + /usr/bin/sed -e s~minio-service.#namespace~minio-service.users-4515~ + /usr/bin/sed -e 's#image:.*-logcollector$#image: perconalab/percona-xtradb-cluster-operator:main-logcollector#' ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl apply -f - + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.DwOGphyYVG perconaxtradbcluster.pxc.percona.com/some-name created + cat /tmp/tmp.6hrqR5Ya8Y + rm /tmp/tmp.DwOGphyYVG /tmp/tmp.6hrqR5Ya8Y + return 0 + desc 'check if all 3 Pods started' + set +o xtrace ----------------------------------------------------------------------------------- check if all 3 Pods started ----------------------------------------------------------------------------------- ++ get_proxy some-name ++ local target_cluster=some-name +++ kubectl_bin get pxc some-name -o 'jsonpath={.spec.haproxy.enabled}' ++++ mktemp +++ local LAST_OUT=/tmp/tmp.sLrHBGp5Ba ++++ mktemp +++ local LAST_ERR=/tmp/tmp.MJU4ODuP7E +++ local exit_status=0 ++++ seq 0 2 +++ for i in '$(seq 0 2)' +++ set +e +++ kubectl get pxc some-name -o 'jsonpath={.spec.haproxy.enabled}' +++ exit_status=0 +++ set -e +++ '[' 0 '!=' 0 ']' +++ break +++ cat /tmp/tmp.sLrHBGp5Ba +++ cat /tmp/tmp.MJU4ODuP7E +++ rm /tmp/tmp.sLrHBGp5Ba /tmp/tmp.MJU4ODuP7E +++ return 0 ++ [[ '' == \t\r\u\e ]] +++ kubectl_bin get pxc some-name -o 'jsonpath={.spec.proxysql.enabled}' ++++ mktemp +++ local LAST_OUT=/tmp/tmp.E00IOuVbRl ++++ mktemp +++ local LAST_ERR=/tmp/tmp.DMfmJrdBbQ +++ local exit_status=0 ++++ seq 0 2 +++ for i in '$(seq 0 2)' +++ set +e +++ kubectl get pxc some-name -o 'jsonpath={.spec.proxysql.enabled}' +++ exit_status=0 +++ set -e +++ '[' 0 '!=' 0 ']' +++ break +++ cat /tmp/tmp.E00IOuVbRl +++ cat /tmp/tmp.DMfmJrdBbQ +++ rm /tmp/tmp.E00IOuVbRl /tmp/tmp.DMfmJrdBbQ +++ return 0 ++ [[ true == \t\r\u\e ]] ++ echo some-name-proxysql ++ return + local proxy=some-name-proxysql + kubectl_bin wait --for=condition=Ready pod -l app.kubernetes.io/instance=monitoring,app.kubernetes.io/managed-by=percona-xtradb-cluster-operator --timeout=300s -n users-4515 ++ mktemp + local LAST_OUT=/tmp/tmp.ygpJ2XQH1Q ++ mktemp + local LAST_ERR=/tmp/tmp.CT8k7Zmkbd + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl wait --for=condition=Ready pod -l app.kubernetes.io/instance=monitoring,app.kubernetes.io/managed-by=percona-xtradb-cluster-operator --timeout=300s -n users-4515 + exit_status=1 + set -e + '[' 1 '!=' 0 ']' + '[' 1 == 1 ']' + sleep 0 + for i in '$(seq 0 2)' + set +e + kubectl wait --for=condition=Ready pod -l app.kubernetes.io/instance=monitoring,app.kubernetes.io/managed-by=percona-xtradb-cluster-operator --timeout=300s -n users-4515 + exit_status=1 + set -e + '[' 1 '!=' 0 ']' + '[' 1 == 1 ']' + sleep 0 + for i in '$(seq 0 2)' + set +e + kubectl wait --for=condition=Ready pod -l app.kubernetes.io/instance=monitoring,app.kubernetes.io/managed-by=percona-xtradb-cluster-operator --timeout=300s -n users-4515 + exit_status=1 + set -e + '[' 1 '!=' 0 ']' + '[' 1 == 1 ']' + sleep 0 + cat /tmp/tmp.ygpJ2XQH1Q + cat /tmp/tmp.CT8k7Zmkbd error: no matching resources found + rm /tmp/tmp.ygpJ2XQH1Q /tmp/tmp.CT8k7Zmkbd + return 1 + true + wait_for_running some-name-proxysql 1 + local name=some-name-proxysql + let last_pod=0 + : + local max_retry=480 + desc 'wait for running cluster' + set +o xtrace ----------------------------------------------------------------------------------- wait for running cluster ----------------------------------------------------------------------------------- ++ seq 0 0 + for i in '$(seq 0 $last_pod)' + wait_pod some-name-proxysql-0 480 + local pod=some-name-proxysql-0 + local max_retry=480 + local ns= ++ echo some-name-proxysql-0 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container=proxysql + set +o xtrace pod/some-name-proxysql-0 condition met waiting for pod/some-name-proxysql-0 to become Ready.Ok + wait_for_running some-name-pxc 3 + local name=some-name-pxc + let last_pod=2 + local max_retry=480 + desc 'wait for running cluster' + set +o xtrace ----------------------------------------------------------------------------------- wait for running cluster ----------------------------------------------------------------------------------- ++ seq 0 2 + for i in '$(seq 0 $last_pod)' + wait_pod some-name-pxc-0 480 + local pod=some-name-pxc-0 + local max_retry=480 + local ns= ++ echo some-name-pxc-0 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container=pxc + set +o xtrace pod/some-name-pxc-0 condition met waiting for pod/some-name-pxc-0 to become Ready.Ok + for i in '$(seq 0 $last_pod)' + wait_pod some-name-pxc-1 480 + local pod=some-name-pxc-1 + local max_retry=480 + local ns= ++ echo some-name-pxc-1 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container=pxc + set +o xtrace pod/some-name-pxc-1 condition met waiting for pod/some-name-pxc-1 to become Ready.Ok + for i in '$(seq 0 $last_pod)' + wait_pod some-name-pxc-2 480 + local pod=some-name-pxc-2 + local max_retry=480 + local ns= ++ echo some-name-pxc-2 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container=pxc + set +o xtrace pod/some-name-pxc-2 condition met waiting for pod/some-name-pxc-2 to become Ready.Ok + sleep 10 ++ kubectl get pxc some-name -o 'jsonpath={.spec.secretsName}' + local secret_name=my-cluster-secrets ++ getSecretData my-cluster-secrets root ++ local secretName=my-cluster-secrets ++ local dataKey=root ++ kubectl_bin get secrets/my-cluster-secrets '--template={{.data.root}}' ++ base64 --decode +++ mktemp ++ local LAST_OUT=/tmp/tmp.g9b8wZzccM +++ mktemp ++ local LAST_ERR=/tmp/tmp.T9GKiHAg9j ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get secrets/my-cluster-secrets '--template={{.data.root}}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.g9b8wZzccM ++ cat /tmp/tmp.T9GKiHAg9j ++ rm /tmp/tmp.g9b8wZzccM /tmp/tmp.T9GKiHAg9j ++ return 0 + local root_pass=hJxQNs-+MaXa0kA5 + desc 'write data' + set +o xtrace ----------------------------------------------------------------------------------- write data ----------------------------------------------------------------------------------- + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'CREATE DATABASE IF NOT EXISTS myApp; use myApp; CREATE TABLE IF NOT EXISTS myApp (id int PRIMARY KEY) ;' '-h some-name-proxysql -uroot -p'\''hJxQNs-+MaXa0kA5'\'' -P3306' + local 'command=CREATE DATABASE IF NOT EXISTS myApp; use myApp; CREATE TABLE IF NOT EXISTS myApp (id int PRIMARY KEY) ;' + local 'uri=-h some-name-proxysql -uroot -p'\''hJxQNs-+MaXa0kA5'\'' -P3306' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.dFQt9d2Jeo +++ mktemp ++ local LAST_ERR=/tmp/tmp.EHnOSeyJ6c ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.dFQt9d2Jeo ++ cat /tmp/tmp.EHnOSeyJ6c ++ rm /tmp/tmp.dFQt9d2Jeo /tmp/tmp.EHnOSeyJ6c ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + run_mysql 'INSERT myApp.myApp (id) VALUES (100500)' '-h some-name-proxysql -uroot -p'\''hJxQNs-+MaXa0kA5'\'' -P3306' + local 'command=INSERT myApp.myApp (id) VALUES (100500)' + local 'uri=-h some-name-proxysql -uroot -p'\''hJxQNs-+MaXa0kA5'\'' -P3306' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.9oKbSCv1pn +++ mktemp ++ local LAST_ERR=/tmp/tmp.OWpjLoDC1A ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.9oKbSCv1pn ++ cat /tmp/tmp.OWpjLoDC1A ++ rm /tmp/tmp.9oKbSCv1pn /tmp/tmp.OWpjLoDC1A ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + sleep 30 ++ seq 0 2 + for i in '$(seq 0 $((size - 1)))' + compare_mysql_cmd select-1 'SELECT * from myApp.myApp;' '-h some-name-pxc-0.some-name-pxc -uroot -p'\''hJxQNs-+MaXa0kA5'\'' -P3306' + local command_id=select-1 + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h some-name-pxc-0.some-name-pxc -uroot -p'\''hJxQNs-+MaXa0kA5'\'' -P3306' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-1.sql + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.4 ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.0 ]] + [[ -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-1-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SELECT * from myApp.myApp;' '-h some-name-pxc-0.some-name-pxc -uroot -p'\''hJxQNs-+MaXa0kA5'\'' -P3306' + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h some-name-pxc-0.some-name-pxc -uroot -p'\''hJxQNs-+MaXa0kA5'\'' -P3306' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.On8gIHpLX1 +++ mktemp ++ local LAST_ERR=/tmp/tmp.0krxGGMCb3 ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.On8gIHpLX1 ++ cat /tmp/tmp.0krxGGMCb3 ++ rm /tmp/tmp.On8gIHpLX1 /tmp/tmp.0krxGGMCb3 ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + '[' '!' -s /tmp/tmp.e7GavhpsLb/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-1.sql /tmp/tmp.e7GavhpsLb/select-1.sql + for i in '$(seq 0 $((size - 1)))' + compare_mysql_cmd select-1 'SELECT * from myApp.myApp;' '-h some-name-pxc-1.some-name-pxc -uroot -p'\''hJxQNs-+MaXa0kA5'\'' -P3306' + local command_id=select-1 + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h some-name-pxc-1.some-name-pxc -uroot -p'\''hJxQNs-+MaXa0kA5'\'' -P3306' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-1.sql + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.4 ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.0 ]] + [[ -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-1-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SELECT * from myApp.myApp;' '-h some-name-pxc-1.some-name-pxc -uroot -p'\''hJxQNs-+MaXa0kA5'\'' -P3306' + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h some-name-pxc-1.some-name-pxc -uroot -p'\''hJxQNs-+MaXa0kA5'\'' -P3306' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.LzIVwkynfI +++ mktemp ++ local LAST_ERR=/tmp/tmp.vP2VUTrokS ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.LzIVwkynfI ++ cat /tmp/tmp.vP2VUTrokS ++ rm /tmp/tmp.LzIVwkynfI /tmp/tmp.vP2VUTrokS ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + '[' '!' -s /tmp/tmp.e7GavhpsLb/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-1.sql /tmp/tmp.e7GavhpsLb/select-1.sql + for i in '$(seq 0 $((size - 1)))' + compare_mysql_cmd select-1 'SELECT * from myApp.myApp;' '-h some-name-pxc-2.some-name-pxc -uroot -p'\''hJxQNs-+MaXa0kA5'\'' -P3306' + local command_id=select-1 + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h some-name-pxc-2.some-name-pxc -uroot -p'\''hJxQNs-+MaXa0kA5'\'' -P3306' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-1.sql + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.4 ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.0 ]] + [[ -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-1-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SELECT * from myApp.myApp;' '-h some-name-pxc-2.some-name-pxc -uroot -p'\''hJxQNs-+MaXa0kA5'\'' -P3306' + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h some-name-pxc-2.some-name-pxc -uroot -p'\''hJxQNs-+MaXa0kA5'\'' -P3306' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.BhQciWKJxJ +++ mktemp ++ local LAST_ERR=/tmp/tmp.0xibgHqs6m ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.BhQciWKJxJ ++ cat /tmp/tmp.0xibgHqs6m ++ rm /tmp/tmp.BhQciWKJxJ /tmp/tmp.0xibgHqs6m ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + '[' '!' -s /tmp/tmp.e7GavhpsLb/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-1.sql /tmp/tmp.e7GavhpsLb/select-1.sql ++ is_keyring_plugin_in_use some-name ++ local cluster=some-name ++ kubectl_bin exec -it some-name-pxc-0 -c pxc -- bash -c 'cat /etc/mysql/node.cnf' ++ egrep -o 'early-plugin-load=keyring_\w+.so' +++ mktemp ++ local LAST_OUT=/tmp/tmp.D2CdzUkFix +++ mktemp ++ local LAST_ERR=/tmp/tmp.Fh8csp3txF ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl exec -it some-name-pxc-0 -c pxc -- bash -c 'cat /etc/mysql/node.cnf' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.D2CdzUkFix ++ cat /tmp/tmp.Fh8csp3txF Unable to use a TTY - input is not a terminal or the right kind of file ++ rm /tmp/tmp.D2CdzUkFix /tmp/tmp.Fh8csp3txF ++ return 0 + '[' '' ']' + desc 'test missing passwords were created and present in internal secrets' + set +o xtrace ----------------------------------------------------------------------------------- test missing passwords were created and present in internal secrets ----------------------------------------------------------------------------------- + empty_pwds=() + wrong_pwds=() + for user in root xtrabackup monitor proxyadmin operator replication + echo 'Checking root' Checking root ++ getSecretData my-cluster-secrets root ++ local secretName=my-cluster-secrets ++ local dataKey=root ++ kubectl_bin get secrets/my-cluster-secrets '--template={{.data.root}}' ++ base64 --decode +++ mktemp ++ local LAST_OUT=/tmp/tmp.nBAqPckNn9 +++ mktemp ++ local LAST_ERR=/tmp/tmp.3vtGJW9n9Q ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get secrets/my-cluster-secrets '--template={{.data.root}}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.nBAqPckNn9 ++ cat /tmp/tmp.3vtGJW9n9Q ++ rm /tmp/tmp.nBAqPckNn9 /tmp/tmp.3vtGJW9n9Q ++ return 0 + secret_pass=hJxQNs-+MaXa0kA5 ++ getSecretData internal-some-name root ++ local secretName=internal-some-name ++ local dataKey=root ++ kubectl_bin get secrets/internal-some-name '--template={{.data.root}}' ++ base64 --decode +++ mktemp ++ local LAST_OUT=/tmp/tmp.9lTnHGzwfy +++ mktemp ++ local LAST_ERR=/tmp/tmp.ay8mhI2TYe ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get secrets/internal-some-name '--template={{.data.root}}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.9lTnHGzwfy ++ cat /tmp/tmp.ay8mhI2TYe ++ rm /tmp/tmp.9lTnHGzwfy /tmp/tmp.ay8mhI2TYe ++ return 0 + int_secret_pass=hJxQNs-+MaXa0kA5 + [[ -z hJxQNs-+MaXa0kA5 ]] + [[ hJxQNs-+MaXa0kA5 != \h\J\x\Q\N\s\-\+\M\a\X\a\0\k\A\5 ]] + [[ root != \p\r\o\x\y\a\d\m\i\n ]] + [[ '' =~ root ]] + [[ '' =~ root ]] + echo 'Running compare for root' Running compare for root + compare_mysql_cmd select-4 'SHOW TABLES;' '-h some-name-proxysql -uroot -p'\''hJxQNs-+MaXa0kA5'\''' + local command_id=select-4 + local 'command=SHOW TABLES;' + local 'uri=-h some-name-proxysql -uroot -p'\''hJxQNs-+MaXa0kA5'\''' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4.sql + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.4 ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.0 ]] + [[ -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4-80.sql ]] + expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4-80.sql + run_mysql 'SHOW TABLES;' '-h some-name-proxysql -uroot -p'\''hJxQNs-+MaXa0kA5'\''' + local 'command=SHOW TABLES;' + local 'uri=-h some-name-proxysql -uroot -p'\''hJxQNs-+MaXa0kA5'\''' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.8chspEnyMB +++ mktemp ++ local LAST_ERR=/tmp/tmp.78w1TWTEaR ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.8chspEnyMB ++ cat /tmp/tmp.78w1TWTEaR ++ rm /tmp/tmp.8chspEnyMB /tmp/tmp.78w1TWTEaR ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + '[' '!' -s /tmp/tmp.e7GavhpsLb/select-4.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4-80.sql /tmp/tmp.e7GavhpsLb/select-4.sql + for user in root xtrabackup monitor proxyadmin operator replication + echo 'Checking xtrabackup' Checking xtrabackup ++ getSecretData my-cluster-secrets xtrabackup ++ local secretName=my-cluster-secrets ++ local dataKey=xtrabackup ++ kubectl_bin get secrets/my-cluster-secrets '--template={{.data.xtrabackup}}' ++ base64 --decode +++ mktemp ++ local LAST_OUT=/tmp/tmp.8CZXjebYXL +++ mktemp ++ local LAST_ERR=/tmp/tmp.zOarXa2GAt ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get secrets/my-cluster-secrets '--template={{.data.xtrabackup}}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.8CZXjebYXL ++ cat /tmp/tmp.zOarXa2GAt ++ rm /tmp/tmp.8CZXjebYXL /tmp/tmp.zOarXa2GAt ++ return 0 + secret_pass='SMwPww1F8KQ-?Eh6(' ++ getSecretData internal-some-name xtrabackup ++ local secretName=internal-some-name ++ local dataKey=xtrabackup ++ kubectl_bin get secrets/internal-some-name '--template={{.data.xtrabackup}}' ++ base64 --decode +++ mktemp ++ local LAST_OUT=/tmp/tmp.Ep5F99sfCU +++ mktemp ++ local LAST_ERR=/tmp/tmp.RrEvks4fXA ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get secrets/internal-some-name '--template={{.data.xtrabackup}}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.Ep5F99sfCU ++ cat /tmp/tmp.RrEvks4fXA ++ rm /tmp/tmp.Ep5F99sfCU /tmp/tmp.RrEvks4fXA ++ return 0 + int_secret_pass='SMwPww1F8KQ-?Eh6(' + [[ -z SMwPww1F8KQ-?Eh6( ]] + [[ SMwPww1F8KQ-?Eh6( != \S\M\w\P\w\w\1\F\8\K\Q\-\?\E\h\6\( ]] + [[ xtrabackup != \p\r\o\x\y\a\d\m\i\n ]] + [[ '' =~ xtrabackup ]] + [[ '' =~ xtrabackup ]] + echo 'Running compare for xtrabackup' Running compare for xtrabackup + compare_mysql_cmd select-4 'SHOW TABLES;' '-h some-name-proxysql -uxtrabackup -p'\''SMwPww1F8KQ-?Eh6('\''' + local command_id=select-4 + local 'command=SHOW TABLES;' + local 'uri=-h some-name-proxysql -uxtrabackup -p'\''SMwPww1F8KQ-?Eh6('\''' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4.sql + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.4 ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.0 ]] + [[ -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4-80.sql ]] + expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4-80.sql + run_mysql 'SHOW TABLES;' '-h some-name-proxysql -uxtrabackup -p'\''SMwPww1F8KQ-?Eh6('\''' + local 'command=SHOW TABLES;' + local 'uri=-h some-name-proxysql -uxtrabackup -p'\''SMwPww1F8KQ-?Eh6('\''' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.8sk4NoytVw +++ mktemp ++ local LAST_ERR=/tmp/tmp.56q6e6i4sy ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.8sk4NoytVw ++ cat /tmp/tmp.56q6e6i4sy ++ rm /tmp/tmp.8sk4NoytVw /tmp/tmp.56q6e6i4sy ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + '[' '!' -s /tmp/tmp.e7GavhpsLb/select-4.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4-80.sql /tmp/tmp.e7GavhpsLb/select-4.sql + for user in root xtrabackup monitor proxyadmin operator replication + echo 'Checking monitor' Checking monitor ++ getSecretData my-cluster-secrets monitor ++ local secretName=my-cluster-secrets ++ local dataKey=monitor ++ kubectl_bin get secrets/my-cluster-secrets '--template={{.data.monitor}}' ++ base64 --decode +++ mktemp ++ local LAST_OUT=/tmp/tmp.LW2oy5UnJ4 +++ mktemp ++ local LAST_ERR=/tmp/tmp.fCJLlX0aKO ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get secrets/my-cluster-secrets '--template={{.data.monitor}}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.LW2oy5UnJ4 ++ cat /tmp/tmp.fCJLlX0aKO ++ rm /tmp/tmp.LW2oy5UnJ4 /tmp/tmp.fCJLlX0aKO ++ return 0 + secret_pass=monitor_password ++ getSecretData internal-some-name monitor ++ local secretName=internal-some-name ++ local dataKey=monitor ++ kubectl_bin get secrets/internal-some-name '--template={{.data.monitor}}' ++ base64 --decode +++ mktemp ++ local LAST_OUT=/tmp/tmp.1p8rEY1h3H +++ mktemp ++ local LAST_ERR=/tmp/tmp.09TZrhfepE ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get secrets/internal-some-name '--template={{.data.monitor}}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.1p8rEY1h3H ++ cat /tmp/tmp.09TZrhfepE ++ rm /tmp/tmp.1p8rEY1h3H /tmp/tmp.09TZrhfepE ++ return 0 + int_secret_pass=monitor_password + [[ -z monitor_password ]] + [[ monitor_password != \m\o\n\i\t\o\r\_\p\a\s\s\w\o\r\d ]] + [[ monitor != \p\r\o\x\y\a\d\m\i\n ]] + [[ '' =~ monitor ]] + [[ '' =~ monitor ]] + echo 'Running compare for monitor' Running compare for monitor + compare_mysql_cmd select-4 'SHOW TABLES;' '-h some-name-proxysql -umonitor -p'\''monitor_password'\''' + local command_id=select-4 + local 'command=SHOW TABLES;' + local 'uri=-h some-name-proxysql -umonitor -p'\''monitor_password'\''' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4.sql + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.4 ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.0 ]] + [[ -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4-80.sql ]] + expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4-80.sql + run_mysql 'SHOW TABLES;' '-h some-name-proxysql -umonitor -p'\''monitor_password'\''' + local 'command=SHOW TABLES;' + local 'uri=-h some-name-proxysql -umonitor -p'\''monitor_password'\''' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.ZHcJYsYZpb +++ mktemp ++ local LAST_ERR=/tmp/tmp.Kv7jnMcpYQ ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.ZHcJYsYZpb ++ cat /tmp/tmp.Kv7jnMcpYQ ++ rm /tmp/tmp.ZHcJYsYZpb /tmp/tmp.Kv7jnMcpYQ ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ egrep '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + '[' '!' -s /tmp/tmp.e7GavhpsLb/select-4.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4-80.sql /tmp/tmp.e7GavhpsLb/select-4.sql + for user in root xtrabackup monitor proxyadmin operator replication + echo 'Checking proxyadmin' Checking proxyadmin ++ getSecretData my-cluster-secrets proxyadmin ++ local secretName=my-cluster-secrets ++ local dataKey=proxyadmin ++ kubectl_bin get secrets/my-cluster-secrets '--template={{.data.proxyadmin}}' ++ base64 --decode +++ mktemp ++ local LAST_OUT=/tmp/tmp.93RN8R8x5L +++ mktemp ++ local LAST_ERR=/tmp/tmp.pZXlnE1skS ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get secrets/my-cluster-secrets '--template={{.data.proxyadmin}}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.93RN8R8x5L ++ cat /tmp/tmp.pZXlnE1skS ++ rm /tmp/tmp.93RN8R8x5L /tmp/tmp.pZXlnE1skS ++ return 0 + secret_pass='T*!!yjELRIlAdC,pk' ++ getSecretData internal-some-name proxyadmin ++ local secretName=internal-some-name ++ local dataKey=proxyadmin ++ base64 --decode ++ kubectl_bin get secrets/internal-some-name '--template={{.data.proxyadmin}}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.GoJPaELNbF +++ mktemp ++ local LAST_ERR=/tmp/tmp.q76XWyrHs0 ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get secrets/internal-some-name '--template={{.data.proxyadmin}}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.GoJPaELNbF ++ cat /tmp/tmp.q76XWyrHs0 ++ rm /tmp/tmp.GoJPaELNbF /tmp/tmp.q76XWyrHs0 ++ return 0 + int_secret_pass='T*!!yjELRIlAdC,pk' + [[ -z T*!!yjELRIlAdC,pk ]] + [[ T*!!yjELRIlAdC,pk != \T\*\!\!\y\j\E\L\R\I\l\A\d\C\,\p\k ]] + [[ proxyadmin != \p\r\o\x\y\a\d\m\i\n ]] + [[ proxyadmin == \p\r\o\x\y\a\d\m\i\n ]] + [[ '' =~ proxyadmin ]] + [[ '' =~ proxyadmin ]] + echo 'Running compare for proxyadmin' Running compare for proxyadmin + compare_mysql_cmd_local select-2 'SHOW TABLES;' '-h127.0.0.1 -P6032 -uproxyadmin -p'\''T*!!yjELRIlAdC,pk'\''' some-name-proxysql-0 '' proxysql + local command_id=select-2 + local 'command=SHOW TABLES;' + local 'uri=-h127.0.0.1 -P6032 -uproxyadmin -p'\''T*!!yjELRIlAdC,pk'\''' + local pod=some-name-proxysql-0 + local postfix= + local container_name=proxysql + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-2.sql + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.0 ]] + '[' -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-2-80.sql ']' + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.4 ]] + run_mysql_local 'SHOW TABLES;' '-h127.0.0.1 -P6032 -uproxyadmin -p'\''T*!!yjELRIlAdC,pk'\''' some-name-proxysql-0 proxysql + local 'command=SHOW TABLES;' + local 'uri=-h127.0.0.1 -P6032 -uproxyadmin -p'\''T*!!yjELRIlAdC,pk'\''' + local pod=some-name-proxysql-0 + local container_name=proxysql + set +o xtrace + '[' '!' -s /tmp/tmp.e7GavhpsLb/select-2.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-2.sql /tmp/tmp.e7GavhpsLb/select-2.sql + for user in root xtrabackup monitor proxyadmin operator replication + echo 'Checking operator' Checking operator ++ getSecretData my-cluster-secrets operator ++ local secretName=my-cluster-secrets ++ local dataKey=operator ++ kubectl_bin get secrets/my-cluster-secrets '--template={{.data.operator}}' ++ base64 --decode +++ mktemp ++ local LAST_OUT=/tmp/tmp.Jzy5D7kDWH +++ mktemp ++ local LAST_ERR=/tmp/tmp.Z5WSO8AOP8 ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get secrets/my-cluster-secrets '--template={{.data.operator}}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.Jzy5D7kDWH ++ cat /tmp/tmp.Z5WSO8AOP8 ++ rm /tmp/tmp.Jzy5D7kDWH /tmp/tmp.Z5WSO8AOP8 ++ return 0 + secret_pass='[vF]ubfiOy2EN?(G' ++ getSecretData internal-some-name operator ++ local secretName=internal-some-name ++ local dataKey=operator ++ kubectl_bin get secrets/internal-some-name '--template={{.data.operator}}' ++ base64 --decode +++ mktemp ++ local LAST_OUT=/tmp/tmp.SvotTiEowU +++ mktemp ++ local LAST_ERR=/tmp/tmp.mb1pnI7Yxw ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get secrets/internal-some-name '--template={{.data.operator}}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.SvotTiEowU ++ cat /tmp/tmp.mb1pnI7Yxw ++ rm /tmp/tmp.SvotTiEowU /tmp/tmp.mb1pnI7Yxw ++ return 0 + int_secret_pass='[vF]ubfiOy2EN?(G' + [[ -z [vF]ubfiOy2EN?(G ]] + [[ [vF]ubfiOy2EN?(G != \[\v\F\]\u\b\f\i\O\y\2\E\N\?\(\G ]] + [[ operator != \p\r\o\x\y\a\d\m\i\n ]] + [[ '' =~ operator ]] + [[ '' =~ operator ]] + echo 'Running compare for operator' Running compare for operator + compare_mysql_cmd select-4 'SHOW TABLES;' '-h some-name-proxysql -uoperator -p'\''[vF]ubfiOy2EN?(G'\''' + local command_id=select-4 + local 'command=SHOW TABLES;' + local 'uri=-h some-name-proxysql -uoperator -p'\''[vF]ubfiOy2EN?(G'\''' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4.sql + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.4 ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.0 ]] + [[ -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4-80.sql ]] + expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4-80.sql + run_mysql 'SHOW TABLES;' '-h some-name-proxysql -uoperator -p'\''[vF]ubfiOy2EN?(G'\''' + local 'command=SHOW TABLES;' + local 'uri=-h some-name-proxysql -uoperator -p'\''[vF]ubfiOy2EN?(G'\''' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.4Spov3A9AB +++ mktemp ++ local LAST_ERR=/tmp/tmp.qRkLBDKkZe ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.4Spov3A9AB ++ cat /tmp/tmp.qRkLBDKkZe ++ rm /tmp/tmp.4Spov3A9AB /tmp/tmp.qRkLBDKkZe ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + '[' '!' -s /tmp/tmp.e7GavhpsLb/select-4.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4-80.sql /tmp/tmp.e7GavhpsLb/select-4.sql + for user in root xtrabackup monitor proxyadmin operator replication + echo 'Checking replication' Checking replication ++ getSecretData my-cluster-secrets replication ++ local secretName=my-cluster-secrets ++ local dataKey=replication ++ kubectl_bin get secrets/my-cluster-secrets '--template={{.data.replication}}' ++ base64 --decode +++ mktemp ++ local LAST_OUT=/tmp/tmp.mFFD85ZsSf +++ mktemp ++ local LAST_ERR=/tmp/tmp.btb4dCJvAq ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get secrets/my-cluster-secrets '--template={{.data.replication}}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.mFFD85ZsSf ++ cat /tmp/tmp.btb4dCJvAq ++ rm /tmp/tmp.mFFD85ZsSf /tmp/tmp.btb4dCJvAq ++ return 0 + secret_pass='9uy2X@kede+n@41!k' ++ getSecretData internal-some-name replication ++ local secretName=internal-some-name ++ local dataKey=replication ++ kubectl_bin get secrets/internal-some-name '--template={{.data.replication}}' ++ base64 --decode +++ mktemp ++ local LAST_OUT=/tmp/tmp.Vyhyx17WD7 +++ mktemp ++ local LAST_ERR=/tmp/tmp.4mNT72hrbP ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get secrets/internal-some-name '--template={{.data.replication}}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.Vyhyx17WD7 ++ cat /tmp/tmp.4mNT72hrbP ++ rm /tmp/tmp.Vyhyx17WD7 /tmp/tmp.4mNT72hrbP ++ return 0 + int_secret_pass='9uy2X@kede+n@41!k' + [[ -z 9uy2X@kede+n@41!k ]] + [[ 9uy2X@kede+n@41!k != \9\u\y\2\X\@\k\e\d\e\+\n\@\4\1\!\k ]] + [[ replication != \p\r\o\x\y\a\d\m\i\n ]] + [[ '' =~ replication ]] + [[ '' =~ replication ]] + echo 'Running compare for replication' Running compare for replication + compare_mysql_cmd select-4 'SHOW TABLES;' '-h some-name-proxysql -ureplication -p'\''9uy2X@kede+n@41!k'\''' + local command_id=select-4 + local 'command=SHOW TABLES;' + local 'uri=-h some-name-proxysql -ureplication -p'\''9uy2X@kede+n@41!k'\''' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4.sql + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.4 ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.0 ]] + [[ -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4-80.sql ]] + expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4-80.sql + run_mysql 'SHOW TABLES;' '-h some-name-proxysql -ureplication -p'\''9uy2X@kede+n@41!k'\''' + local 'command=SHOW TABLES;' + local 'uri=-h some-name-proxysql -ureplication -p'\''9uy2X@kede+n@41!k'\''' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.XBNpXY4iJZ +++ mktemp ++ local LAST_ERR=/tmp/tmp.qBWIsOp5qU ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.XBNpXY4iJZ ++ cat /tmp/tmp.qBWIsOp5qU ++ rm /tmp/tmp.XBNpXY4iJZ /tmp/tmp.qBWIsOp5qU ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ egrep '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + '[' '!' -s /tmp/tmp.e7GavhpsLb/select-4.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4-80.sql /tmp/tmp.e7GavhpsLb/select-4.sql + [[ -n '' ]] + [[ -n '' ]] + desc 'test root' + set +o xtrace ----------------------------------------------------------------------------------- test root ----------------------------------------------------------------------------------- + patch_secret my-cluster-secrets root dGVzdC1wYXNzd29yZA== + local secret=my-cluster-secrets + local key=root + local value=dGVzdC1wYXNzd29yZA== + kubectl_bin patch secret my-cluster-secrets '-p={"data":{"root": "dGVzdC1wYXNzd29yZA=="}}' ++ mktemp + local LAST_OUT=/tmp/tmp.ScCulrplpS ++ mktemp + local LAST_ERR=/tmp/tmp.yb0uQdArPx + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl patch secret my-cluster-secrets '-p={"data":{"root": "dGVzdC1wYXNzd29yZA=="}}' + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.ScCulrplpS secret/my-cluster-secrets patched + cat /tmp/tmp.yb0uQdArPx + rm /tmp/tmp.ScCulrplpS /tmp/tmp.yb0uQdArPx + return 0 + sleep 15 + compare_mysql_cmd select-4 'SHOW TABLES;' '-h some-name-proxysql -uroot -p'\''test-password'\''' + local command_id=select-4 + local 'command=SHOW TABLES;' + local 'uri=-h some-name-proxysql -uroot -p'\''test-password'\''' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4.sql + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.4 ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.0 ]] + [[ -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4-80.sql ]] + expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4-80.sql + run_mysql 'SHOW TABLES;' '-h some-name-proxysql -uroot -p'\''test-password'\''' + local 'command=SHOW TABLES;' + local 'uri=-h some-name-proxysql -uroot -p'\''test-password'\''' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.X0oJQNtLKA +++ mktemp ++ local LAST_ERR=/tmp/tmp.cIYN2O2NuV ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.X0oJQNtLKA ++ cat /tmp/tmp.cIYN2O2NuV ++ rm /tmp/tmp.X0oJQNtLKA /tmp/tmp.cIYN2O2NuV ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + '[' '!' -s /tmp/tmp.e7GavhpsLb/select-4.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4-80.sql /tmp/tmp.e7GavhpsLb/select-4.sql + desc 'test proxyadmin' + set +o xtrace ----------------------------------------------------------------------------------- test proxyadmin ----------------------------------------------------------------------------------- + kubectl_bin patch pxc some-name --type=merge '-p={"spec":{"proxysql":{"size":3}}}' ++ mktemp + local LAST_OUT=/tmp/tmp.6VR6M8evEO ++ mktemp + local LAST_ERR=/tmp/tmp.rXmjze1MRa + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl patch pxc some-name --type=merge '-p={"spec":{"proxysql":{"size":3}}}' + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.6VR6M8evEO perconaxtradbcluster.pxc.percona.com/some-name patched + cat /tmp/tmp.rXmjze1MRa + rm /tmp/tmp.6VR6M8evEO /tmp/tmp.rXmjze1MRa + return 0 + sleep 15 + wait_cluster_consistency some-name 3 3 + local cluster_name=some-name + local cluster_size=3 + local proxy_size=3 + '[' -z 3 ']' + desc 'wait cluster consistency' + set +o xtrace ----------------------------------------------------------------------------------- wait cluster consistency ----------------------------------------------------------------------------------- + local i=0 + local max=300 + sleep 7 + echo -n 'waiting for pxc/some-name to be ready' waiting for pxc/some-name to be ready++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.Y7eBxcepRu +++ mktemp ++ local LAST_ERR=/tmp/tmp.yQYl4WXYBv ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.Y7eBxcepRu ++ cat /tmp/tmp.yQYl4WXYBv ++ rm /tmp/tmp.Y7eBxcepRu /tmp/tmp.yQYl4WXYBv ++ return 0 + [[ ready == \r\e\a\d\y ]] ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.pxc.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.i5MK9vvUcY +++ mktemp ++ local LAST_ERR=/tmp/tmp.0322iXPj2K ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.pxc.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.i5MK9vvUcY ++ cat /tmp/tmp.0322iXPj2K ++ rm /tmp/tmp.i5MK9vvUcY /tmp/tmp.0322iXPj2K ++ return 0 + [[ 3 == \3 ]] +++ get_proxy_engine some-name +++ local cluster_name=some-name ++++ get_proxy some-name ++++ local target_cluster=some-name +++++ kubectl_bin get pxc some-name -o 'jsonpath={.spec.haproxy.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.JtbvMJ66fb ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.qkknQAg5df +++++ local exit_status=0 ++++++ seq 0 2 +++++ for i in '$(seq 0 2)' +++++ set +e +++++ kubectl get pxc some-name -o 'jsonpath={.spec.haproxy.enabled}' +++++ exit_status=0 +++++ set -e +++++ '[' 0 '!=' 0 ']' +++++ break +++++ cat /tmp/tmp.JtbvMJ66fb +++++ cat /tmp/tmp.qkknQAg5df +++++ rm /tmp/tmp.JtbvMJ66fb /tmp/tmp.qkknQAg5df +++++ return 0 ++++ [[ '' == \t\r\u\e ]] +++++ kubectl_bin get pxc some-name -o 'jsonpath={.spec.proxysql.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.U7soPbD4ex ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.h0TExShRr2 +++++ local exit_status=0 ++++++ seq 0 2 +++++ for i in '$(seq 0 2)' +++++ set +e +++++ kubectl get pxc some-name -o 'jsonpath={.spec.proxysql.enabled}' +++++ exit_status=0 +++++ set -e +++++ '[' 0 '!=' 0 ']' +++++ break +++++ cat /tmp/tmp.U7soPbD4ex +++++ cat /tmp/tmp.h0TExShRr2 +++++ rm /tmp/tmp.U7soPbD4ex /tmp/tmp.h0TExShRr2 +++++ return 0 ++++ [[ true == \t\r\u\e ]] ++++ echo some-name-proxysql ++++ return +++ local cluster_proxy=some-name-proxysql +++ echo proxysql ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.proxysql.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.ibtaVkL0Bt +++ mktemp ++ local LAST_ERR=/tmp/tmp.zEukCJyNVb ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.proxysql.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.ibtaVkL0Bt ++ cat /tmp/tmp.zEukCJyNVb ++ rm /tmp/tmp.ibtaVkL0Bt /tmp/tmp.zEukCJyNVb ++ return 0 + [[ 3 == \3 ]] + echo + patch_secret my-cluster-secrets proxyadmin dGVzdC1wYXNzd29yZA== + local secret=my-cluster-secrets + local key=proxyadmin + local value=dGVzdC1wYXNzd29yZA== + kubectl_bin patch secret my-cluster-secrets '-p={"data":{"proxyadmin": "dGVzdC1wYXNzd29yZA=="}}' ++ mktemp + local LAST_OUT=/tmp/tmp.4mcSILEzxk ++ mktemp + local LAST_ERR=/tmp/tmp.XBe8vtE7Sz + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl patch secret my-cluster-secrets '-p={"data":{"proxyadmin": "dGVzdC1wYXNzd29yZA=="}}' + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.4mcSILEzxk secret/my-cluster-secrets patched + cat /tmp/tmp.XBe8vtE7Sz + rm /tmp/tmp.4mcSILEzxk /tmp/tmp.XBe8vtE7Sz + return 0 + sleep 15 + wait_cluster_consistency some-name 3 3 + local cluster_name=some-name + local cluster_size=3 + local proxy_size=3 + '[' -z 3 ']' + desc 'wait cluster consistency' + set +o xtrace ----------------------------------------------------------------------------------- wait cluster consistency ----------------------------------------------------------------------------------- + local i=0 + local max=300 + sleep 7 + echo -n 'waiting for pxc/some-name to be ready' waiting for pxc/some-name to be ready++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.sM8GdCicUE +++ mktemp ++ local LAST_ERR=/tmp/tmp.15VE2IKKGg ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.sM8GdCicUE ++ cat /tmp/tmp.15VE2IKKGg ++ rm /tmp/tmp.sM8GdCicUE /tmp/tmp.15VE2IKKGg ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 0 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.kieHAFyoQX +++ mktemp ++ local LAST_ERR=/tmp/tmp.3rT62nlqXs ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.kieHAFyoQX ++ cat /tmp/tmp.3rT62nlqXs ++ rm /tmp/tmp.kieHAFyoQX /tmp/tmp.3rT62nlqXs ++ return 0 + [[ ready == \r\e\a\d\y ]] ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.pxc.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.8OrqZDfTMj +++ mktemp ++ local LAST_ERR=/tmp/tmp.AbCnXmcUfz ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.pxc.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.8OrqZDfTMj ++ cat /tmp/tmp.AbCnXmcUfz ++ rm /tmp/tmp.8OrqZDfTMj /tmp/tmp.AbCnXmcUfz ++ return 0 + [[ 3 == \3 ]] +++ get_proxy_engine some-name +++ local cluster_name=some-name ++++ get_proxy some-name ++++ local target_cluster=some-name +++++ kubectl_bin get pxc some-name -o 'jsonpath={.spec.haproxy.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.cYZ2UBWPxF ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.30lznBDSrT +++++ local exit_status=0 ++++++ seq 0 2 +++++ for i in '$(seq 0 2)' +++++ set +e +++++ kubectl get pxc some-name -o 'jsonpath={.spec.haproxy.enabled}' +++++ exit_status=0 +++++ set -e +++++ '[' 0 '!=' 0 ']' +++++ break +++++ cat /tmp/tmp.cYZ2UBWPxF +++++ cat /tmp/tmp.30lznBDSrT +++++ rm /tmp/tmp.cYZ2UBWPxF /tmp/tmp.30lznBDSrT +++++ return 0 ++++ [[ '' == \t\r\u\e ]] +++++ kubectl_bin get pxc some-name -o 'jsonpath={.spec.proxysql.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.1g3JLI6ls6 ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.iGUw89FTfN +++++ local exit_status=0 ++++++ seq 0 2 +++++ for i in '$(seq 0 2)' +++++ set +e +++++ kubectl get pxc some-name -o 'jsonpath={.spec.proxysql.enabled}' +++++ exit_status=0 +++++ set -e +++++ '[' 0 '!=' 0 ']' +++++ break +++++ cat /tmp/tmp.1g3JLI6ls6 +++++ cat /tmp/tmp.iGUw89FTfN +++++ rm /tmp/tmp.1g3JLI6ls6 /tmp/tmp.iGUw89FTfN +++++ return 0 ++++ [[ true == \t\r\u\e ]] ++++ echo some-name-proxysql ++++ return +++ local cluster_proxy=some-name-proxysql +++ echo proxysql ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.proxysql.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.m6s3Ch9jl3 +++ mktemp ++ local LAST_ERR=/tmp/tmp.cc0D0mjUW6 ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.proxysql.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.m6s3Ch9jl3 ++ cat /tmp/tmp.cc0D0mjUW6 ++ rm /tmp/tmp.m6s3Ch9jl3 /tmp/tmp.cc0D0mjUW6 ++ return 0 + [[ 3 == \3 ]] + echo + compare_mysql_cmd_local select-2 'SHOW TABLES;' '-h127.0.0.1 -P6032 -uproxyadmin -p'\''test-password'\''' some-name-proxysql-0 '' proxysql + local command_id=select-2 + local 'command=SHOW TABLES;' + local 'uri=-h127.0.0.1 -P6032 -uproxyadmin -p'\''test-password'\''' + local pod=some-name-proxysql-0 + local postfix= + local container_name=proxysql + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-2.sql + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.0 ]] + '[' -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-2-80.sql ']' + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.4 ]] + run_mysql_local 'SHOW TABLES;' '-h127.0.0.1 -P6032 -uproxyadmin -p'\''test-password'\''' some-name-proxysql-0 proxysql + local 'command=SHOW TABLES;' + local 'uri=-h127.0.0.1 -P6032 -uproxyadmin -p'\''test-password'\''' + local pod=some-name-proxysql-0 + local container_name=proxysql + set +o xtrace + '[' '!' -s /tmp/tmp.e7GavhpsLb/select-2.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-2.sql /tmp/tmp.e7GavhpsLb/select-2.sql + compare_mysql_cmd_local select-2 'SHOW TABLES;' '-h127.0.0.1 -P6032 -uproxyadmin -p'\''test-password'\''' some-name-proxysql-1 '' proxysql + local command_id=select-2 + local 'command=SHOW TABLES;' + local 'uri=-h127.0.0.1 -P6032 -uproxyadmin -p'\''test-password'\''' + local pod=some-name-proxysql-1 + local postfix= + local container_name=proxysql + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-2.sql + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.0 ]] + '[' -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-2-80.sql ']' + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.4 ]] + run_mysql_local 'SHOW TABLES;' '-h127.0.0.1 -P6032 -uproxyadmin -p'\''test-password'\''' some-name-proxysql-1 proxysql + local 'command=SHOW TABLES;' + local 'uri=-h127.0.0.1 -P6032 -uproxyadmin -p'\''test-password'\''' + local pod=some-name-proxysql-1 + local container_name=proxysql + set +o xtrace + '[' '!' -s /tmp/tmp.e7GavhpsLb/select-2.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-2.sql /tmp/tmp.e7GavhpsLb/select-2.sql + compare_mysql_cmd_local select-2 'SHOW TABLES;' '-h127.0.0.1 -P6032 -uproxyadmin -p'\''test-password'\''' some-name-proxysql-2 '' proxysql + local command_id=select-2 + local 'command=SHOW TABLES;' + local 'uri=-h127.0.0.1 -P6032 -uproxyadmin -p'\''test-password'\''' + local pod=some-name-proxysql-2 + local postfix= + local container_name=proxysql + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-2.sql + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.0 ]] + '[' -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-2-80.sql ']' + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.4 ]] + run_mysql_local 'SHOW TABLES;' '-h127.0.0.1 -P6032 -uproxyadmin -p'\''test-password'\''' some-name-proxysql-2 proxysql + local 'command=SHOW TABLES;' + local 'uri=-h127.0.0.1 -P6032 -uproxyadmin -p'\''test-password'\''' + local pod=some-name-proxysql-2 + local container_name=proxysql + set +o xtrace + '[' '!' -s /tmp/tmp.e7GavhpsLb/select-2.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-2.sql /tmp/tmp.e7GavhpsLb/select-2.sql + desc 'test xtrabackup' + set +o xtrace ----------------------------------------------------------------------------------- test xtrabackup ----------------------------------------------------------------------------------- + kubectl_bin patch pxc some-name --type=merge '-p={"spec":{"proxysql":{"size":2}}}' ++ mktemp + local LAST_OUT=/tmp/tmp.ETPYLFd1Rv ++ mktemp + local LAST_ERR=/tmp/tmp.ouM1qOsNOJ + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl patch pxc some-name --type=merge '-p={"spec":{"proxysql":{"size":2}}}' + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.ETPYLFd1Rv perconaxtradbcluster.pxc.percona.com/some-name patched + cat /tmp/tmp.ouM1qOsNOJ + rm /tmp/tmp.ETPYLFd1Rv /tmp/tmp.ouM1qOsNOJ + return 0 + patch_secret my-cluster-secrets xtrabackup dGVzdC1wYXNzd29yZA== + local secret=my-cluster-secrets + local key=xtrabackup + local value=dGVzdC1wYXNzd29yZA== + kubectl_bin patch secret my-cluster-secrets '-p={"data":{"xtrabackup": "dGVzdC1wYXNzd29yZA=="}}' ++ mktemp + local LAST_OUT=/tmp/tmp.hf5wBEjw3d ++ mktemp + local LAST_ERR=/tmp/tmp.5B6KMZVxJW + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl patch secret my-cluster-secrets '-p={"data":{"xtrabackup": "dGVzdC1wYXNzd29yZA=="}}' + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.hf5wBEjw3d secret/my-cluster-secrets patched + cat /tmp/tmp.5B6KMZVxJW + rm /tmp/tmp.hf5wBEjw3d /tmp/tmp.5B6KMZVxJW + return 0 + sleep 15 + wait_cluster_consistency some-name 3 2 + local cluster_name=some-name + local cluster_size=3 + local proxy_size=2 + '[' -z 2 ']' + desc 'wait cluster consistency' + set +o xtrace ----------------------------------------------------------------------------------- wait cluster consistency ----------------------------------------------------------------------------------- + local i=0 + local max=300 + sleep 7 + echo -n 'waiting for pxc/some-name to be ready' waiting for pxc/some-name to be ready++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.ehv4QgJ9AM +++ mktemp ++ local LAST_ERR=/tmp/tmp.FAm3t7fx5R ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.ehv4QgJ9AM ++ cat /tmp/tmp.FAm3t7fx5R ++ rm /tmp/tmp.ehv4QgJ9AM /tmp/tmp.FAm3t7fx5R ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 0 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.RSIiNuW4Ps +++ mktemp ++ local LAST_ERR=/tmp/tmp.f3zlUUNCcH ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.RSIiNuW4Ps ++ cat /tmp/tmp.f3zlUUNCcH ++ rm /tmp/tmp.RSIiNuW4Ps /tmp/tmp.f3zlUUNCcH ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 1 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.1pMM2t8Qge +++ mktemp ++ local LAST_ERR=/tmp/tmp.21YmBvBaUX ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.1pMM2t8Qge ++ cat /tmp/tmp.21YmBvBaUX ++ rm /tmp/tmp.1pMM2t8Qge /tmp/tmp.21YmBvBaUX ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 2 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.6mG4cyf6nN +++ mktemp ++ local LAST_ERR=/tmp/tmp.D4nR2DJnKn ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.6mG4cyf6nN ++ cat /tmp/tmp.D4nR2DJnKn ++ rm /tmp/tmp.6mG4cyf6nN /tmp/tmp.D4nR2DJnKn ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 3 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.4sbPC5rvq7 +++ mktemp ++ local LAST_ERR=/tmp/tmp.utFag1Sugm ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.4sbPC5rvq7 ++ cat /tmp/tmp.utFag1Sugm ++ rm /tmp/tmp.4sbPC5rvq7 /tmp/tmp.utFag1Sugm ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 4 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.nX2qwewYBW +++ mktemp ++ local LAST_ERR=/tmp/tmp.w5E5a8wqZw ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.nX2qwewYBW ++ cat /tmp/tmp.w5E5a8wqZw ++ rm /tmp/tmp.nX2qwewYBW /tmp/tmp.w5E5a8wqZw ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 5 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.NA9lnlFR7j +++ mktemp ++ local LAST_ERR=/tmp/tmp.MsXv9L9Z2e ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.NA9lnlFR7j ++ cat /tmp/tmp.MsXv9L9Z2e ++ rm /tmp/tmp.NA9lnlFR7j /tmp/tmp.MsXv9L9Z2e ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 6 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.rpKyyRlU93 +++ mktemp ++ local LAST_ERR=/tmp/tmp.2Xgg8kX5qv ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.rpKyyRlU93 ++ cat /tmp/tmp.2Xgg8kX5qv ++ rm /tmp/tmp.rpKyyRlU93 /tmp/tmp.2Xgg8kX5qv ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 7 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.Rk24CsimJ8 +++ mktemp ++ local LAST_ERR=/tmp/tmp.oIBj5RSF0Z ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.Rk24CsimJ8 ++ cat /tmp/tmp.oIBj5RSF0Z ++ rm /tmp/tmp.Rk24CsimJ8 /tmp/tmp.oIBj5RSF0Z ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 8 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.yBJGJy4hQ6 +++ mktemp ++ local LAST_ERR=/tmp/tmp.AfZaGi8Byo ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.yBJGJy4hQ6 ++ cat /tmp/tmp.AfZaGi8Byo ++ rm /tmp/tmp.yBJGJy4hQ6 /tmp/tmp.AfZaGi8Byo ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 9 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.4qB2x8lnwv +++ mktemp ++ local LAST_ERR=/tmp/tmp.fkOjjSggox ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.4qB2x8lnwv ++ cat /tmp/tmp.fkOjjSggox ++ rm /tmp/tmp.4qB2x8lnwv /tmp/tmp.fkOjjSggox ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 10 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.SkOCxLryEW +++ mktemp ++ local LAST_ERR=/tmp/tmp.W8WvZg6V4v ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.SkOCxLryEW ++ cat /tmp/tmp.W8WvZg6V4v ++ rm /tmp/tmp.SkOCxLryEW /tmp/tmp.W8WvZg6V4v ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 11 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.xZ3JxYBQqp +++ mktemp ++ local LAST_ERR=/tmp/tmp.izgWdE3Ni0 ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.xZ3JxYBQqp ++ cat /tmp/tmp.izgWdE3Ni0 ++ rm /tmp/tmp.xZ3JxYBQqp /tmp/tmp.izgWdE3Ni0 ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 12 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.86cvnHEz5c +++ mktemp ++ local LAST_ERR=/tmp/tmp.L8ZD4CBcnm ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.86cvnHEz5c ++ cat /tmp/tmp.L8ZD4CBcnm ++ rm /tmp/tmp.86cvnHEz5c /tmp/tmp.L8ZD4CBcnm ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 13 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.L6o78SHojH +++ mktemp ++ local LAST_ERR=/tmp/tmp.lbMGiJIGWV ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.L6o78SHojH ++ cat /tmp/tmp.lbMGiJIGWV ++ rm /tmp/tmp.L6o78SHojH /tmp/tmp.lbMGiJIGWV ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 14 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.reP2Z964jV +++ mktemp ++ local LAST_ERR=/tmp/tmp.0BR17OwScg ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.reP2Z964jV ++ cat /tmp/tmp.0BR17OwScg ++ rm /tmp/tmp.reP2Z964jV /tmp/tmp.0BR17OwScg ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 15 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.XBZLsdVcMB +++ mktemp ++ local LAST_ERR=/tmp/tmp.razFHQPLW3 ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.XBZLsdVcMB ++ cat /tmp/tmp.razFHQPLW3 ++ rm /tmp/tmp.XBZLsdVcMB /tmp/tmp.razFHQPLW3 ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 16 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.PeUDRBZl9F +++ mktemp ++ local LAST_ERR=/tmp/tmp.au3qgxRXdA ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.PeUDRBZl9F ++ cat /tmp/tmp.au3qgxRXdA ++ rm /tmp/tmp.PeUDRBZl9F /tmp/tmp.au3qgxRXdA ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 17 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.5nnym9TF9x +++ mktemp ++ local LAST_ERR=/tmp/tmp.7AKg7yDGr9 ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.5nnym9TF9x ++ cat /tmp/tmp.7AKg7yDGr9 ++ rm /tmp/tmp.5nnym9TF9x /tmp/tmp.7AKg7yDGr9 ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 18 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.QTAvw4zZPx +++ mktemp ++ local LAST_ERR=/tmp/tmp.7iealxuEDo ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.QTAvw4zZPx ++ cat /tmp/tmp.7iealxuEDo ++ rm /tmp/tmp.QTAvw4zZPx /tmp/tmp.7iealxuEDo ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 19 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.CCbosg3pX9 +++ mktemp ++ local LAST_ERR=/tmp/tmp.5mogOckyqQ ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.CCbosg3pX9 ++ cat /tmp/tmp.5mogOckyqQ ++ rm /tmp/tmp.CCbosg3pX9 /tmp/tmp.5mogOckyqQ ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 20 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.e40lGoxDvM +++ mktemp ++ local LAST_ERR=/tmp/tmp.3Y0739H7jz ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.e40lGoxDvM ++ cat /tmp/tmp.3Y0739H7jz ++ rm /tmp/tmp.e40lGoxDvM /tmp/tmp.3Y0739H7jz ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 21 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.inrHiZdA9g +++ mktemp ++ local LAST_ERR=/tmp/tmp.z9lYDpa5m5 ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.inrHiZdA9g ++ cat /tmp/tmp.z9lYDpa5m5 ++ rm /tmp/tmp.inrHiZdA9g /tmp/tmp.z9lYDpa5m5 ++ return 0 + [[ ready == \r\e\a\d\y ]] ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.pxc.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.9EIlnhBfbZ +++ mktemp ++ local LAST_ERR=/tmp/tmp.TUke4HwQXD ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.pxc.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.9EIlnhBfbZ ++ cat /tmp/tmp.TUke4HwQXD ++ rm /tmp/tmp.9EIlnhBfbZ /tmp/tmp.TUke4HwQXD ++ return 0 + [[ 3 == \3 ]] +++ get_proxy_engine some-name +++ local cluster_name=some-name ++++ get_proxy some-name ++++ local target_cluster=some-name +++++ kubectl_bin get pxc some-name -o 'jsonpath={.spec.haproxy.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.WDsTqUXFKp ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.8ywgMyMaUS +++++ local exit_status=0 ++++++ seq 0 2 +++++ for i in '$(seq 0 2)' +++++ set +e +++++ kubectl get pxc some-name -o 'jsonpath={.spec.haproxy.enabled}' +++++ exit_status=0 +++++ set -e +++++ '[' 0 '!=' 0 ']' +++++ break +++++ cat /tmp/tmp.WDsTqUXFKp +++++ cat /tmp/tmp.8ywgMyMaUS +++++ rm /tmp/tmp.WDsTqUXFKp /tmp/tmp.8ywgMyMaUS +++++ return 0 ++++ [[ '' == \t\r\u\e ]] +++++ kubectl_bin get pxc some-name -o 'jsonpath={.spec.proxysql.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.d5iIwtvyQ8 ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.qQLfuPaDVz +++++ local exit_status=0 ++++++ seq 0 2 +++++ for i in '$(seq 0 2)' +++++ set +e +++++ kubectl get pxc some-name -o 'jsonpath={.spec.proxysql.enabled}' +++++ exit_status=0 +++++ set -e +++++ '[' 0 '!=' 0 ']' +++++ break +++++ cat /tmp/tmp.d5iIwtvyQ8 +++++ cat /tmp/tmp.qQLfuPaDVz +++++ rm /tmp/tmp.d5iIwtvyQ8 /tmp/tmp.qQLfuPaDVz +++++ return 0 ++++ [[ true == \t\r\u\e ]] ++++ echo some-name-proxysql ++++ return +++ local cluster_proxy=some-name-proxysql +++ echo proxysql ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.proxysql.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.HUZ21VC47C +++ mktemp ++ local LAST_ERR=/tmp/tmp.qLPc8WosrY ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.proxysql.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.HUZ21VC47C ++ cat /tmp/tmp.qLPc8WosrY ++ rm /tmp/tmp.HUZ21VC47C /tmp/tmp.qLPc8WosrY ++ return 0 + [[ 2 == \2 ]] + echo + compare_mysql_cmd_local select-3 'SHOW DATABASES;' '-h 127.0.0.1 -uxtrabackup -p'\''test-password'\''' some-name-pxc-0 '' pxc + local command_id=select-3 + local 'command=SHOW DATABASES;' + local 'uri=-h 127.0.0.1 -uxtrabackup -p'\''test-password'\''' + local pod=some-name-pxc-0 + local postfix= + local container_name=pxc + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-3.sql + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.0 ]] + '[' -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-3-80.sql ']' + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.4 ]] + run_mysql_local 'SHOW DATABASES;' '-h 127.0.0.1 -uxtrabackup -p'\''test-password'\''' some-name-pxc-0 pxc + local 'command=SHOW DATABASES;' + local 'uri=-h 127.0.0.1 -uxtrabackup -p'\''test-password'\''' + local pod=some-name-pxc-0 + local container_name=pxc + set +o xtrace + '[' '!' -s /tmp/tmp.e7GavhpsLb/select-3.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-3.sql /tmp/tmp.e7GavhpsLb/select-3.sql + desc 'test monitor' + set +o xtrace ----------------------------------------------------------------------------------- test monitor ----------------------------------------------------------------------------------- + patch_secret my-cluster-secrets monitor dGVzdC1wYXNzd29yZA== + local secret=my-cluster-secrets + local key=monitor + local value=dGVzdC1wYXNzd29yZA== + kubectl_bin patch secret my-cluster-secrets '-p={"data":{"monitor": "dGVzdC1wYXNzd29yZA=="}}' ++ mktemp + local LAST_OUT=/tmp/tmp.ReGwbK12Mb ++ mktemp + local LAST_ERR=/tmp/tmp.zQP9zqM3sL + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl patch secret my-cluster-secrets '-p={"data":{"monitor": "dGVzdC1wYXNzd29yZA=="}}' + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.ReGwbK12Mb secret/my-cluster-secrets patched + cat /tmp/tmp.zQP9zqM3sL + rm /tmp/tmp.ReGwbK12Mb /tmp/tmp.zQP9zqM3sL + return 0 + wait_for_password_propagation my-cluster-secrets monitor + local secret=my-cluster-secrets + local user=monitor + local max_retry=240 ++ getSecretData my-cluster-secrets root ++ local secretName=my-cluster-secrets ++ local dataKey=root ++ kubectl_bin get secrets/my-cluster-secrets '--template={{.data.root}}' ++ base64 --decode +++ mktemp ++ local LAST_OUT=/tmp/tmp.D92cNc2kJq +++ mktemp ++ local LAST_ERR=/tmp/tmp.DKnUdl3eCT ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get secrets/my-cluster-secrets '--template={{.data.root}}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.D92cNc2kJq ++ cat /tmp/tmp.DKnUdl3eCT ++ rm /tmp/tmp.D92cNc2kJq /tmp/tmp.DKnUdl3eCT ++ return 0 + local root_pass=test-password + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + retry=0 + is_password_updated monitor '-h some-name-pxc -uroot -p'\''test-password'\''' + local username=monitor + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' + run_mysql 'SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' '-h some-name-pxc -uroot -p'\''test-password'\''' + grep additional_password + local 'command=SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.9dmYwzSvMj +++ mktemp ++ local LAST_ERR=/tmp/tmp.Ti6unFdBdN ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.9dmYwzSvMj ++ cat /tmp/tmp.Ti6unFdBdN ++ rm /tmp/tmp.9dmYwzSvMj /tmp/tmp.Ti6unFdBdN ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace {"additional_password": "*C1F414D9BAF378B656A849B31F9F8AF3125F558B"} + retry=0 + is_old_password_discarded monitor '-h some-name-pxc -uroot -p'\''test-password'\''' + local username=monitor + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' + run_mysql 'SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' '-h some-name-pxc -uroot -p'\''test-password'\''' + local 'command=SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' + grep NULL ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.NP4YDreQIh +++ mktemp ++ local LAST_ERR=/tmp/tmp.YW9A5TjoWa ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.NP4YDreQIh ++ cat /tmp/tmp.YW9A5TjoWa ++ rm /tmp/tmp.NP4YDreQIh /tmp/tmp.YW9A5TjoWa ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + echo 'waiting for password propagation' waiting for password propagation + sleep 1 + let retry+=1 + [[ 1 -ge 240 ]] + is_old_password_discarded monitor '-h some-name-pxc -uroot -p'\''test-password'\''' + local username=monitor + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' + grep NULL + run_mysql 'SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' '-h some-name-pxc -uroot -p'\''test-password'\''' + local 'command=SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.yVW4etZ5yy +++ mktemp ++ local LAST_ERR=/tmp/tmp.MQn6Qpt6KE ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.yVW4etZ5yy ++ cat /tmp/tmp.MQn6Qpt6KE ++ rm /tmp/tmp.yVW4etZ5yy /tmp/tmp.MQn6Qpt6KE ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + echo 'waiting for password propagation' waiting for password propagation + sleep 1 + let retry+=1 + [[ 2 -ge 240 ]] + is_old_password_discarded monitor '-h some-name-pxc -uroot -p'\''test-password'\''' + local username=monitor + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' + run_mysql 'SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' '-h some-name-pxc -uroot -p'\''test-password'\''' + local 'command=SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' + grep NULL ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.PsMjEnsmCh +++ mktemp ++ local LAST_ERR=/tmp/tmp.fqx6RWDw5P ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.PsMjEnsmCh ++ cat /tmp/tmp.fqx6RWDw5P ++ rm /tmp/tmp.PsMjEnsmCh /tmp/tmp.fqx6RWDw5P ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + echo 'waiting for password propagation' waiting for password propagation + sleep 1 + let retry+=1 + [[ 3 -ge 240 ]] + is_old_password_discarded monitor '-h some-name-pxc -uroot -p'\''test-password'\''' + local username=monitor + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' + run_mysql 'SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' '-h some-name-pxc -uroot -p'\''test-password'\''' + local 'command=SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' + grep NULL ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.Ii9bMbjuw5 +++ mktemp ++ local LAST_ERR=/tmp/tmp.jZSJMP5WCi ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.Ii9bMbjuw5 ++ cat /tmp/tmp.jZSJMP5WCi ++ rm /tmp/tmp.Ii9bMbjuw5 /tmp/tmp.jZSJMP5WCi ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + echo 'waiting for password propagation' waiting for password propagation + sleep 1 + let retry+=1 + [[ 4 -ge 240 ]] + is_old_password_discarded monitor '-h some-name-pxc -uroot -p'\''test-password'\''' + local username=monitor + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' + run_mysql 'SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' '-h some-name-pxc -uroot -p'\''test-password'\''' + grep NULL + local 'command=SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.IeOrnF7csN +++ mktemp ++ local LAST_ERR=/tmp/tmp.hztcufXMxO ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.IeOrnF7csN ++ cat /tmp/tmp.hztcufXMxO ++ rm /tmp/tmp.IeOrnF7csN /tmp/tmp.hztcufXMxO ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + echo 'waiting for password propagation' waiting for password propagation + sleep 1 + let retry+=1 + [[ 5 -ge 240 ]] + is_old_password_discarded monitor '-h some-name-pxc -uroot -p'\''test-password'\''' + local username=monitor + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' + grep NULL + run_mysql 'SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' '-h some-name-pxc -uroot -p'\''test-password'\''' + local 'command=SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.udovIkxoxi +++ mktemp ++ local LAST_ERR=/tmp/tmp.Sn39DIp2iE ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.udovIkxoxi ++ cat /tmp/tmp.Sn39DIp2iE ++ rm /tmp/tmp.udovIkxoxi /tmp/tmp.Sn39DIp2iE ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + echo 'waiting for password propagation' waiting for password propagation + sleep 1 + let retry+=1 + [[ 6 -ge 240 ]] + is_old_password_discarded monitor '-h some-name-pxc -uroot -p'\''test-password'\''' + local username=monitor + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' + grep NULL + run_mysql 'SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' '-h some-name-pxc -uroot -p'\''test-password'\''' + local 'command=SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.w7DeswoJt3 +++ mktemp ++ local LAST_ERR=/tmp/tmp.4oeMG4lj8w ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.w7DeswoJt3 ++ cat /tmp/tmp.4oeMG4lj8w ++ rm /tmp/tmp.w7DeswoJt3 /tmp/tmp.4oeMG4lj8w ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + echo 'waiting for password propagation' waiting for password propagation + sleep 1 + let retry+=1 + [[ 7 -ge 240 ]] + is_old_password_discarded monitor '-h some-name-pxc -uroot -p'\''test-password'\''' + local username=monitor + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' + run_mysql 'SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' '-h some-name-pxc -uroot -p'\''test-password'\''' + grep NULL + local 'command=SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.zH3hUJ7VUr +++ mktemp ++ local LAST_ERR=/tmp/tmp.zBD9pijpRW ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.zH3hUJ7VUr ++ cat /tmp/tmp.zBD9pijpRW ++ rm /tmp/tmp.zH3hUJ7VUr /tmp/tmp.zBD9pijpRW ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + echo 'waiting for password propagation' waiting for password propagation + sleep 1 + let retry+=1 + [[ 8 -ge 240 ]] + is_old_password_discarded monitor '-h some-name-pxc -uroot -p'\''test-password'\''' + local username=monitor + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' + run_mysql 'SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' '-h some-name-pxc -uroot -p'\''test-password'\''' + local 'command=SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' + grep NULL + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.ZFLvwL39ZM +++ mktemp ++ local LAST_ERR=/tmp/tmp.iDbib9zRrp ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.ZFLvwL39ZM ++ cat /tmp/tmp.iDbib9zRrp ++ rm /tmp/tmp.ZFLvwL39ZM /tmp/tmp.iDbib9zRrp ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + echo 'waiting for password propagation' waiting for password propagation + sleep 1 + let retry+=1 + [[ 9 -ge 240 ]] + is_old_password_discarded monitor '-h some-name-pxc -uroot -p'\''test-password'\''' + local username=monitor + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' + run_mysql 'SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' '-h some-name-pxc -uroot -p'\''test-password'\''' + local 'command=SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' + grep NULL ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.rqAwRZUxHV +++ mktemp ++ local LAST_ERR=/tmp/tmp.dvoa81MnJT ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.rqAwRZUxHV ++ cat /tmp/tmp.dvoa81MnJT ++ rm /tmp/tmp.rqAwRZUxHV /tmp/tmp.dvoa81MnJT ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + echo 'waiting for password propagation' waiting for password propagation + sleep 1 + let retry+=1 + [[ 10 -ge 240 ]] + is_old_password_discarded monitor '-h some-name-pxc -uroot -p'\''test-password'\''' + local username=monitor + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' + run_mysql 'SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' '-h some-name-pxc -uroot -p'\''test-password'\''' + local 'command=SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' + grep NULL ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.dZbZowf0V1 +++ mktemp ++ local LAST_ERR=/tmp/tmp.XcCZemBa2g ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.dZbZowf0V1 ++ cat /tmp/tmp.XcCZemBa2g ++ rm /tmp/tmp.dZbZowf0V1 /tmp/tmp.XcCZemBa2g ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + echo 'waiting for password propagation' waiting for password propagation + sleep 1 + let retry+=1 + [[ 11 -ge 240 ]] + is_old_password_discarded monitor '-h some-name-pxc -uroot -p'\''test-password'\''' + local username=monitor + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' + run_mysql 'SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' '-h some-name-pxc -uroot -p'\''test-password'\''' + grep NULL + local 'command=SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.xVE6fxK6bV +++ mktemp ++ local LAST_ERR=/tmp/tmp.tFVKyTe0ij ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.xVE6fxK6bV ++ cat /tmp/tmp.tFVKyTe0ij ++ rm /tmp/tmp.xVE6fxK6bV /tmp/tmp.tFVKyTe0ij ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + echo 'waiting for password propagation' waiting for password propagation + sleep 1 + let retry+=1 + [[ 12 -ge 240 ]] + is_old_password_discarded monitor '-h some-name-pxc -uroot -p'\''test-password'\''' + local username=monitor + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' + run_mysql 'SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' '-h some-name-pxc -uroot -p'\''test-password'\''' + local 'command=SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' + grep NULL ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.tEcG05694M +++ mktemp ++ local LAST_ERR=/tmp/tmp.3ZKPHqqFVq ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.tEcG05694M ++ cat /tmp/tmp.3ZKPHqqFVq ++ rm /tmp/tmp.tEcG05694M /tmp/tmp.3ZKPHqqFVq ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + echo 'waiting for password propagation' waiting for password propagation + sleep 1 + let retry+=1 + [[ 13 -ge 240 ]] + is_old_password_discarded monitor '-h some-name-pxc -uroot -p'\''test-password'\''' + local username=monitor + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' + run_mysql 'SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' '-h some-name-pxc -uroot -p'\''test-password'\''' + grep NULL + local 'command=SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.F5l4efDlQs +++ mktemp ++ local LAST_ERR=/tmp/tmp.vLIFsFzldL ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.F5l4efDlQs ++ cat /tmp/tmp.vLIFsFzldL ++ rm /tmp/tmp.F5l4efDlQs /tmp/tmp.vLIFsFzldL ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ egrep '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + echo 'waiting for password propagation' waiting for password propagation + sleep 1 + let retry+=1 + [[ 14 -ge 240 ]] + is_old_password_discarded monitor '-h some-name-pxc -uroot -p'\''test-password'\''' + local username=monitor + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' + grep NULL + run_mysql 'SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' '-h some-name-pxc -uroot -p'\''test-password'\''' + local 'command=SELECT User_attributes FROM mysql.user WHERE user='\''monitor'\''' + local 'uri=-h some-name-pxc -uroot -p'\''test-password'\''' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.sjgk4sfE7C +++ mktemp ++ local LAST_ERR=/tmp/tmp.u9tVOlX01u ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.sjgk4sfE7C ++ cat /tmp/tmp.u9tVOlX01u ++ rm /tmp/tmp.sjgk4sfE7C /tmp/tmp.u9tVOlX01u ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace NULL + wait_cluster_consistency some-name 3 2 + local cluster_name=some-name + local cluster_size=3 + local proxy_size=2 + '[' -z 2 ']' + desc 'wait cluster consistency' + set +o xtrace ----------------------------------------------------------------------------------- wait cluster consistency ----------------------------------------------------------------------------------- + local i=0 + local max=300 + sleep 7 + echo -n 'waiting for pxc/some-name to be ready' waiting for pxc/some-name to be ready++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.9OdI04xdrN +++ mktemp ++ local LAST_ERR=/tmp/tmp.abTjzxsXa1 ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.9OdI04xdrN ++ cat /tmp/tmp.abTjzxsXa1 ++ rm /tmp/tmp.9OdI04xdrN /tmp/tmp.abTjzxsXa1 ++ return 0 + [[ ready == \r\e\a\d\y ]] ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.pxc.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.gHAKSS9lSB +++ mktemp ++ local LAST_ERR=/tmp/tmp.EgDI7Zo7tm ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.pxc.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.gHAKSS9lSB ++ cat /tmp/tmp.EgDI7Zo7tm ++ rm /tmp/tmp.gHAKSS9lSB /tmp/tmp.EgDI7Zo7tm ++ return 0 + [[ 3 == \3 ]] +++ get_proxy_engine some-name +++ local cluster_name=some-name ++++ get_proxy some-name ++++ local target_cluster=some-name +++++ kubectl_bin get pxc some-name -o 'jsonpath={.spec.haproxy.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.J0cl0QPNQi ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.S7gzdLUND5 +++++ local exit_status=0 ++++++ seq 0 2 +++++ for i in '$(seq 0 2)' +++++ set +e +++++ kubectl get pxc some-name -o 'jsonpath={.spec.haproxy.enabled}' +++++ exit_status=0 +++++ set -e +++++ '[' 0 '!=' 0 ']' +++++ break +++++ cat /tmp/tmp.J0cl0QPNQi +++++ cat /tmp/tmp.S7gzdLUND5 +++++ rm /tmp/tmp.J0cl0QPNQi /tmp/tmp.S7gzdLUND5 +++++ return 0 ++++ [[ '' == \t\r\u\e ]] +++++ kubectl_bin get pxc some-name -o 'jsonpath={.spec.proxysql.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.8UoLzIBZZ2 ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.29yXnx9jzU +++++ local exit_status=0 ++++++ seq 0 2 +++++ for i in '$(seq 0 2)' +++++ set +e +++++ kubectl get pxc some-name -o 'jsonpath={.spec.proxysql.enabled}' +++++ exit_status=0 +++++ set -e +++++ '[' 0 '!=' 0 ']' +++++ break +++++ cat /tmp/tmp.8UoLzIBZZ2 +++++ cat /tmp/tmp.29yXnx9jzU +++++ rm /tmp/tmp.8UoLzIBZZ2 /tmp/tmp.29yXnx9jzU +++++ return 0 ++++ [[ true == \t\r\u\e ]] ++++ echo some-name-proxysql ++++ return +++ local cluster_proxy=some-name-proxysql +++ echo proxysql ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.proxysql.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.ucXdCqqIwr +++ mktemp ++ local LAST_ERR=/tmp/tmp.lLw2Mghn5U ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.proxysql.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.ucXdCqqIwr ++ cat /tmp/tmp.lLw2Mghn5U ++ rm /tmp/tmp.ucXdCqqIwr /tmp/tmp.lLw2Mghn5U ++ return 0 + [[ 2 == \2 ]] + echo + sleep 10 + compare_mysql_cmd select-4 'SHOW TABLES;' '-h some-name-proxysql -umonitor -p'\''test-password'\''' + local command_id=select-4 + local 'command=SHOW TABLES;' + local 'uri=-h some-name-proxysql -umonitor -p'\''test-password'\''' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4.sql + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.4 ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.0 ]] + [[ -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4-80.sql ]] + expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4-80.sql + run_mysql 'SHOW TABLES;' '-h some-name-proxysql -umonitor -p'\''test-password'\''' + local 'command=SHOW TABLES;' + local 'uri=-h some-name-proxysql -umonitor -p'\''test-password'\''' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.ukYSJOxX6U +++ mktemp ++ local LAST_ERR=/tmp/tmp.qSXs2644Gm ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.ukYSJOxX6U ++ cat /tmp/tmp.qSXs2644Gm ++ rm /tmp/tmp.ukYSJOxX6U /tmp/tmp.qSXs2644Gm ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + '[' '!' -s /tmp/tmp.e7GavhpsLb/select-4.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4-80.sql /tmp/tmp.e7GavhpsLb/select-4.sql + desc 'test operator' + set +o xtrace ----------------------------------------------------------------------------------- test operator ----------------------------------------------------------------------------------- + patch_secret my-cluster-secrets operator dGVzdC1wYXNzd29yZA== + local secret=my-cluster-secrets + local key=operator + local value=dGVzdC1wYXNzd29yZA== + kubectl_bin patch secret my-cluster-secrets '-p={"data":{"operator": "dGVzdC1wYXNzd29yZA=="}}' ++ mktemp + local LAST_OUT=/tmp/tmp.K5eOGpIpfa ++ mktemp + local LAST_ERR=/tmp/tmp.BWZa4JT0B4 + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl patch secret my-cluster-secrets '-p={"data":{"operator": "dGVzdC1wYXNzd29yZA=="}}' + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.K5eOGpIpfa secret/my-cluster-secrets patched + cat /tmp/tmp.BWZa4JT0B4 + rm /tmp/tmp.K5eOGpIpfa /tmp/tmp.BWZa4JT0B4 + return 0 + sleep 15 + wait_cluster_consistency some-name 3 2 + local cluster_name=some-name + local cluster_size=3 + local proxy_size=2 + '[' -z 2 ']' + desc 'wait cluster consistency' + set +o xtrace ----------------------------------------------------------------------------------- wait cluster consistency ----------------------------------------------------------------------------------- + local i=0 + local max=300 + sleep 7 + echo -n 'waiting for pxc/some-name to be ready' waiting for pxc/some-name to be ready++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.nfYrnMoOmM +++ mktemp ++ local LAST_ERR=/tmp/tmp.4BpTMVxXgN ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.nfYrnMoOmM ++ cat /tmp/tmp.4BpTMVxXgN ++ rm /tmp/tmp.nfYrnMoOmM /tmp/tmp.4BpTMVxXgN ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 0 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.FUKDegcGNU +++ mktemp ++ local LAST_ERR=/tmp/tmp.Gwo7tqPVjb ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.FUKDegcGNU ++ cat /tmp/tmp.Gwo7tqPVjb ++ rm /tmp/tmp.FUKDegcGNU /tmp/tmp.Gwo7tqPVjb ++ return 0 + [[ ready == \r\e\a\d\y ]] ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.pxc.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.3wfmMTHZ6V +++ mktemp ++ local LAST_ERR=/tmp/tmp.zkhLgIUeLI ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.pxc.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.3wfmMTHZ6V ++ cat /tmp/tmp.zkhLgIUeLI ++ rm /tmp/tmp.3wfmMTHZ6V /tmp/tmp.zkhLgIUeLI ++ return 0 + [[ 3 == \3 ]] +++ get_proxy_engine some-name +++ local cluster_name=some-name ++++ get_proxy some-name ++++ local target_cluster=some-name +++++ kubectl_bin get pxc some-name -o 'jsonpath={.spec.haproxy.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.Lrmr2h6Cv7 ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.iBnufBUUqS +++++ local exit_status=0 ++++++ seq 0 2 +++++ for i in '$(seq 0 2)' +++++ set +e +++++ kubectl get pxc some-name -o 'jsonpath={.spec.haproxy.enabled}' +++++ exit_status=0 +++++ set -e +++++ '[' 0 '!=' 0 ']' +++++ break +++++ cat /tmp/tmp.Lrmr2h6Cv7 +++++ cat /tmp/tmp.iBnufBUUqS +++++ rm /tmp/tmp.Lrmr2h6Cv7 /tmp/tmp.iBnufBUUqS +++++ return 0 ++++ [[ '' == \t\r\u\e ]] +++++ kubectl_bin get pxc some-name -o 'jsonpath={.spec.proxysql.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.RSLUSjUA6A ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.cJ9fYUy4yO +++++ local exit_status=0 ++++++ seq 0 2 +++++ for i in '$(seq 0 2)' +++++ set +e +++++ kubectl get pxc some-name -o 'jsonpath={.spec.proxysql.enabled}' +++++ exit_status=0 +++++ set -e +++++ '[' 0 '!=' 0 ']' +++++ break +++++ cat /tmp/tmp.RSLUSjUA6A +++++ cat /tmp/tmp.cJ9fYUy4yO +++++ rm /tmp/tmp.RSLUSjUA6A /tmp/tmp.cJ9fYUy4yO +++++ return 0 ++++ [[ true == \t\r\u\e ]] ++++ echo some-name-proxysql ++++ return +++ local cluster_proxy=some-name-proxysql +++ echo proxysql ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.proxysql.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.1gdG12jzQr +++ mktemp ++ local LAST_ERR=/tmp/tmp.QsI5mEJ8ae ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.proxysql.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.1gdG12jzQr ++ cat /tmp/tmp.QsI5mEJ8ae ++ rm /tmp/tmp.1gdG12jzQr /tmp/tmp.QsI5mEJ8ae ++ return 0 + [[ 2 == \2 ]] + echo + sleep 10 + compare_mysql_cmd select-4 'SHOW TABLES;' '-h some-name-proxysql -uoperator -p'\''test-password'\''' + local command_id=select-4 + local 'command=SHOW TABLES;' + local 'uri=-h some-name-proxysql -uoperator -p'\''test-password'\''' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4.sql + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.4 ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.0 ]] + [[ -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4-80.sql ]] + expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4-80.sql + run_mysql 'SHOW TABLES;' '-h some-name-proxysql -uoperator -p'\''test-password'\''' + local 'command=SHOW TABLES;' + local 'uri=-h some-name-proxysql -uoperator -p'\''test-password'\''' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.XyBeTvDdTw +++ mktemp ++ local LAST_ERR=/tmp/tmp.jETouxubCr ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.XyBeTvDdTw ++ cat /tmp/tmp.jETouxubCr ++ rm /tmp/tmp.XyBeTvDdTw /tmp/tmp.jETouxubCr ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + '[' '!' -s /tmp/tmp.e7GavhpsLb/select-4.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4-80.sql /tmp/tmp.e7GavhpsLb/select-4.sql + desc 'change secret name' + set +o xtrace ----------------------------------------------------------------------------------- change secret name ----------------------------------------------------------------------------------- + kubectl_bin patch pxc some-name --type merge --patch '{"spec": {"secretsName":"my-cluster-secrets-2"}}' ++ mktemp + local LAST_OUT=/tmp/tmp.3R8fUz836Q ++ mktemp + local LAST_ERR=/tmp/tmp.dsthfnraVL + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl patch pxc some-name --type merge --patch '{"spec": {"secretsName":"my-cluster-secrets-2"}}' + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.3R8fUz836Q perconaxtradbcluster.pxc.percona.com/some-name patched + cat /tmp/tmp.dsthfnraVL + rm /tmp/tmp.3R8fUz836Q /tmp/tmp.dsthfnraVL + return 0 + sleep 30 + wait_cluster_consistency some-name 3 2 + local cluster_name=some-name + local cluster_size=3 + local proxy_size=2 + '[' -z 2 ']' + desc 'wait cluster consistency' + set +o xtrace ----------------------------------------------------------------------------------- wait cluster consistency ----------------------------------------------------------------------------------- + local i=0 + local max=300 + sleep 7 + echo -n 'waiting for pxc/some-name to be ready' waiting for pxc/some-name to be ready++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.kPYeIJ6JHe +++ mktemp ++ local LAST_ERR=/tmp/tmp.8gY4zvivQH ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.kPYeIJ6JHe ++ cat /tmp/tmp.8gY4zvivQH ++ rm /tmp/tmp.kPYeIJ6JHe /tmp/tmp.8gY4zvivQH ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 0 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.y6RTp9aG0x +++ mktemp ++ local LAST_ERR=/tmp/tmp.PWiJ16I6ei ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.y6RTp9aG0x ++ cat /tmp/tmp.PWiJ16I6ei ++ rm /tmp/tmp.y6RTp9aG0x /tmp/tmp.PWiJ16I6ei ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 1 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.WjD4yrTQrr +++ mktemp ++ local LAST_ERR=/tmp/tmp.dHDuqoYhXb ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.WjD4yrTQrr ++ cat /tmp/tmp.dHDuqoYhXb ++ rm /tmp/tmp.WjD4yrTQrr /tmp/tmp.dHDuqoYhXb ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 2 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.ir1Nt2eYWe +++ mktemp ++ local LAST_ERR=/tmp/tmp.d5ATOMfcuG ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.ir1Nt2eYWe ++ cat /tmp/tmp.d5ATOMfcuG ++ rm /tmp/tmp.ir1Nt2eYWe /tmp/tmp.d5ATOMfcuG ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 3 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.VajRyGcA8k +++ mktemp ++ local LAST_ERR=/tmp/tmp.7YurMjBd4a ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.VajRyGcA8k ++ cat /tmp/tmp.7YurMjBd4a ++ rm /tmp/tmp.VajRyGcA8k /tmp/tmp.7YurMjBd4a ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 4 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.qhmcH8d9l0 +++ mktemp ++ local LAST_ERR=/tmp/tmp.HSVEjXGIGg ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.qhmcH8d9l0 ++ cat /tmp/tmp.HSVEjXGIGg ++ rm /tmp/tmp.qhmcH8d9l0 /tmp/tmp.HSVEjXGIGg ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 5 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.ujx7xYGJnG +++ mktemp ++ local LAST_ERR=/tmp/tmp.g6MZNjRejI ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.ujx7xYGJnG ++ cat /tmp/tmp.g6MZNjRejI ++ rm /tmp/tmp.ujx7xYGJnG /tmp/tmp.g6MZNjRejI ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 6 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.kdwhq7QvTd +++ mktemp ++ local LAST_ERR=/tmp/tmp.jVNaJYE9dg ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.kdwhq7QvTd ++ cat /tmp/tmp.jVNaJYE9dg ++ rm /tmp/tmp.kdwhq7QvTd /tmp/tmp.jVNaJYE9dg ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 7 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.r07I2ReLYC +++ mktemp ++ local LAST_ERR=/tmp/tmp.jHNwiManqr ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.r07I2ReLYC ++ cat /tmp/tmp.jHNwiManqr ++ rm /tmp/tmp.r07I2ReLYC /tmp/tmp.jHNwiManqr ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 8 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.TGUOLYgejr +++ mktemp ++ local LAST_ERR=/tmp/tmp.S2R2D4B11v ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.TGUOLYgejr ++ cat /tmp/tmp.S2R2D4B11v ++ rm /tmp/tmp.TGUOLYgejr /tmp/tmp.S2R2D4B11v ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 9 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.UI2vj6WOTn +++ mktemp ++ local LAST_ERR=/tmp/tmp.LQy2hg0o7x ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.UI2vj6WOTn ++ cat /tmp/tmp.LQy2hg0o7x ++ rm /tmp/tmp.UI2vj6WOTn /tmp/tmp.LQy2hg0o7x ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 10 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.Fvx5r7v7Km +++ mktemp ++ local LAST_ERR=/tmp/tmp.toEXKYni34 ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.Fvx5r7v7Km ++ cat /tmp/tmp.toEXKYni34 ++ rm /tmp/tmp.Fvx5r7v7Km /tmp/tmp.toEXKYni34 ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 11 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.BBPhcimJeN +++ mktemp ++ local LAST_ERR=/tmp/tmp.5dCMc8ezFH ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.BBPhcimJeN ++ cat /tmp/tmp.5dCMc8ezFH ++ rm /tmp/tmp.BBPhcimJeN /tmp/tmp.5dCMc8ezFH ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 12 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.D09NtK4uKq +++ mktemp ++ local LAST_ERR=/tmp/tmp.Wp7u64oRBZ ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.D09NtK4uKq ++ cat /tmp/tmp.Wp7u64oRBZ ++ rm /tmp/tmp.D09NtK4uKq /tmp/tmp.Wp7u64oRBZ ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 13 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.itVO0KSFnH +++ mktemp ++ local LAST_ERR=/tmp/tmp.qHZeLkW4ll ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.itVO0KSFnH ++ cat /tmp/tmp.qHZeLkW4ll ++ rm /tmp/tmp.itVO0KSFnH /tmp/tmp.qHZeLkW4ll ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 14 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.k30xfB9aFC +++ mktemp ++ local LAST_ERR=/tmp/tmp.4myTzQwN1m ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.k30xfB9aFC ++ cat /tmp/tmp.4myTzQwN1m ++ rm /tmp/tmp.k30xfB9aFC /tmp/tmp.4myTzQwN1m ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 15 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.a3DUeOIQN7 +++ mktemp ++ local LAST_ERR=/tmp/tmp.bM9sP1JvX0 ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.a3DUeOIQN7 ++ cat /tmp/tmp.bM9sP1JvX0 ++ rm /tmp/tmp.a3DUeOIQN7 /tmp/tmp.bM9sP1JvX0 ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 16 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.wU155A61qh +++ mktemp ++ local LAST_ERR=/tmp/tmp.yapBqhffdX ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.wU155A61qh ++ cat /tmp/tmp.yapBqhffdX ++ rm /tmp/tmp.wU155A61qh /tmp/tmp.yapBqhffdX ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 17 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.9syqG8QMIN +++ mktemp ++ local LAST_ERR=/tmp/tmp.WKairqGULd ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.9syqG8QMIN ++ cat /tmp/tmp.WKairqGULd ++ rm /tmp/tmp.9syqG8QMIN /tmp/tmp.WKairqGULd ++ return 0 + [[ ready == \r\e\a\d\y ]] ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.pxc.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.DKZFB62sAn +++ mktemp ++ local LAST_ERR=/tmp/tmp.xaf2NSYI2y ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.pxc.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.DKZFB62sAn ++ cat /tmp/tmp.xaf2NSYI2y ++ rm /tmp/tmp.DKZFB62sAn /tmp/tmp.xaf2NSYI2y ++ return 0 + [[ 3 == \3 ]] +++ get_proxy_engine some-name +++ local cluster_name=some-name ++++ get_proxy some-name ++++ local target_cluster=some-name +++++ kubectl_bin get pxc some-name -o 'jsonpath={.spec.haproxy.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.HhJGzSizIa ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.AZiEjQcfsF +++++ local exit_status=0 ++++++ seq 0 2 +++++ for i in '$(seq 0 2)' +++++ set +e +++++ kubectl get pxc some-name -o 'jsonpath={.spec.haproxy.enabled}' +++++ exit_status=0 +++++ set -e +++++ '[' 0 '!=' 0 ']' +++++ break +++++ cat /tmp/tmp.HhJGzSizIa +++++ cat /tmp/tmp.AZiEjQcfsF +++++ rm /tmp/tmp.HhJGzSizIa /tmp/tmp.AZiEjQcfsF +++++ return 0 ++++ [[ '' == \t\r\u\e ]] +++++ kubectl_bin get pxc some-name -o 'jsonpath={.spec.proxysql.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.QcEl6msLY3 ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.Dzu7UqY3GM +++++ local exit_status=0 ++++++ seq 0 2 +++++ for i in '$(seq 0 2)' +++++ set +e +++++ kubectl get pxc some-name -o 'jsonpath={.spec.proxysql.enabled}' +++++ exit_status=0 +++++ set -e +++++ '[' 0 '!=' 0 ']' +++++ break +++++ cat /tmp/tmp.QcEl6msLY3 +++++ cat /tmp/tmp.Dzu7UqY3GM +++++ rm /tmp/tmp.QcEl6msLY3 /tmp/tmp.Dzu7UqY3GM +++++ return 0 ++++ [[ true == \t\r\u\e ]] ++++ echo some-name-proxysql ++++ return +++ local cluster_proxy=some-name-proxysql +++ echo proxysql ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.proxysql.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.vSsrjrvXH2 +++ mktemp ++ local LAST_ERR=/tmp/tmp.x7lC1FKS3Q ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.proxysql.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.vSsrjrvXH2 ++ cat /tmp/tmp.x7lC1FKS3Q ++ rm /tmp/tmp.vSsrjrvXH2 /tmp/tmp.x7lC1FKS3Q ++ return 0 + [[ 2 == \2 ]] + echo + desc 'test new operator' + set +o xtrace ----------------------------------------------------------------------------------- test new operator ----------------------------------------------------------------------------------- + newpass=test-password2 ++ echo -n test-password2 ++ base64 + newpassencrypted=dGVzdC1wYXNzd29yZDI= + patch_secret my-cluster-secrets-2 operator dGVzdC1wYXNzd29yZDI= + local secret=my-cluster-secrets-2 + local key=operator + local value=dGVzdC1wYXNzd29yZDI= + kubectl_bin patch secret my-cluster-secrets-2 '-p={"data":{"operator": "dGVzdC1wYXNzd29yZDI="}}' ++ mktemp + local LAST_OUT=/tmp/tmp.cB4OwPm1vj ++ mktemp + local LAST_ERR=/tmp/tmp.RIpWI482U3 + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl patch secret my-cluster-secrets-2 '-p={"data":{"operator": "dGVzdC1wYXNzd29yZDI="}}' + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.cB4OwPm1vj secret/my-cluster-secrets-2 patched + cat /tmp/tmp.RIpWI482U3 + rm /tmp/tmp.cB4OwPm1vj /tmp/tmp.RIpWI482U3 + return 0 + sleep 15 + wait_cluster_consistency some-name 3 2 + local cluster_name=some-name + local cluster_size=3 + local proxy_size=2 + '[' -z 2 ']' + desc 'wait cluster consistency' + set +o xtrace ----------------------------------------------------------------------------------- wait cluster consistency ----------------------------------------------------------------------------------- + local i=0 + local max=300 + sleep 7 + echo -n 'waiting for pxc/some-name to be ready' waiting for pxc/some-name to be ready++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.5CHn5Syo2Z +++ mktemp ++ local LAST_ERR=/tmp/tmp.ZiNHGiV1Ry ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.5CHn5Syo2Z ++ cat /tmp/tmp.ZiNHGiV1Ry ++ rm /tmp/tmp.5CHn5Syo2Z /tmp/tmp.ZiNHGiV1Ry ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo -n . .+ sleep 5 + [[ 0 -ge 300 ]] + let i+=1 ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.huJWaf5QiX +++ mktemp ++ local LAST_ERR=/tmp/tmp.itCKEosRdO ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.huJWaf5QiX ++ cat /tmp/tmp.itCKEosRdO ++ rm /tmp/tmp.huJWaf5QiX /tmp/tmp.itCKEosRdO ++ return 0 + [[ ready == \r\e\a\d\y ]] ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.pxc.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.A0jxW8p2HH +++ mktemp ++ local LAST_ERR=/tmp/tmp.Jh9mYlkcaN ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.pxc.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.A0jxW8p2HH ++ cat /tmp/tmp.Jh9mYlkcaN ++ rm /tmp/tmp.A0jxW8p2HH /tmp/tmp.Jh9mYlkcaN ++ return 0 + [[ 3 == \3 ]] +++ get_proxy_engine some-name +++ local cluster_name=some-name ++++ get_proxy some-name ++++ local target_cluster=some-name +++++ kubectl_bin get pxc some-name -o 'jsonpath={.spec.haproxy.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.T32DsAODqh ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.tfnujsjEbw +++++ local exit_status=0 ++++++ seq 0 2 +++++ for i in '$(seq 0 2)' +++++ set +e +++++ kubectl get pxc some-name -o 'jsonpath={.spec.haproxy.enabled}' +++++ exit_status=0 +++++ set -e +++++ '[' 0 '!=' 0 ']' +++++ break +++++ cat /tmp/tmp.T32DsAODqh +++++ cat /tmp/tmp.tfnujsjEbw +++++ rm /tmp/tmp.T32DsAODqh /tmp/tmp.tfnujsjEbw +++++ return 0 ++++ [[ '' == \t\r\u\e ]] +++++ kubectl_bin get pxc some-name -o 'jsonpath={.spec.proxysql.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.qESu30mfl5 ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.McHrp3vtd4 +++++ local exit_status=0 ++++++ seq 0 2 +++++ for i in '$(seq 0 2)' +++++ set +e +++++ kubectl get pxc some-name -o 'jsonpath={.spec.proxysql.enabled}' +++++ exit_status=0 +++++ set -e +++++ '[' 0 '!=' 0 ']' +++++ break +++++ cat /tmp/tmp.qESu30mfl5 +++++ cat /tmp/tmp.McHrp3vtd4 +++++ rm /tmp/tmp.qESu30mfl5 /tmp/tmp.McHrp3vtd4 +++++ return 0 ++++ [[ true == \t\r\u\e ]] ++++ echo some-name-proxysql ++++ return +++ local cluster_proxy=some-name-proxysql +++ echo proxysql ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.proxysql.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.5cAhrp0Xja +++ mktemp ++ local LAST_ERR=/tmp/tmp.lt2xC1VCbZ ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.proxysql.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.5cAhrp0Xja ++ cat /tmp/tmp.lt2xC1VCbZ ++ rm /tmp/tmp.5cAhrp0Xja /tmp/tmp.lt2xC1VCbZ ++ return 0 + [[ 2 == \2 ]] + echo + sleep 20 + compare_mysql_cmd select-4 'SHOW TABLES;' '-h some-name-proxysql -uoperator -p'\''test-password2'\''' + local command_id=select-4 + local 'command=SHOW TABLES;' + local 'uri=-h some-name-proxysql -uoperator -p'\''test-password2'\''' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4.sql + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.4 ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.0 ]] + [[ -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4-80.sql ]] + expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4-80.sql + run_mysql 'SHOW TABLES;' '-h some-name-proxysql -uoperator -p'\''test-password2'\''' + local 'command=SHOW TABLES;' + local 'uri=-h some-name-proxysql -uoperator -p'\''test-password2'\''' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.CC6T4qyS2l +++ mktemp ++ local LAST_ERR=/tmp/tmp.IqZU6NK2LI ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.CC6T4qyS2l ++ cat /tmp/tmp.IqZU6NK2LI ++ rm /tmp/tmp.CC6T4qyS2l /tmp/tmp.IqZU6NK2LI ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + '[' '!' -s /tmp/tmp.e7GavhpsLb/select-4.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4-80.sql /tmp/tmp.e7GavhpsLb/select-4.sql ++ getSecretData my-cluster-secrets-2 root ++ local secretName=my-cluster-secrets-2 ++ local dataKey=root ++ kubectl_bin get secrets/my-cluster-secrets-2 '--template={{.data.root}}' ++ base64 --decode +++ mktemp ++ local LAST_OUT=/tmp/tmp.lqZGNCuLTU +++ mktemp ++ local LAST_ERR=/tmp/tmp.qVIdz2Tgwn ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get secrets/my-cluster-secrets-2 '--template={{.data.root}}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.lqZGNCuLTU ++ cat /tmp/tmp.qVIdz2Tgwn ++ rm /tmp/tmp.lqZGNCuLTU /tmp/tmp.qVIdz2Tgwn ++ return 0 + newpass='gDi$JdC1kSfR^vP,' + desc 'test new users sync' + set +o xtrace ----------------------------------------------------------------------------------- test new users sync ----------------------------------------------------------------------------------- + run_mysql 'CREATE USER '\''testsync'\''@'\''%'\'' IDENTIFIED BY '\''gDi$JdC1kSfR^vP,'\'';' '-h some-name-pxc -uroot -p'\''gDi$JdC1kSfR^vP,'\''' + local 'command=CREATE USER '\''testsync'\''@'\''%'\'' IDENTIFIED BY '\''gDi$JdC1kSfR^vP,'\'';' + local 'uri=-h some-name-pxc -uroot -p'\''gDi$JdC1kSfR^vP,'\''' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.UtWSs9vonP +++ mktemp ++ local LAST_ERR=/tmp/tmp.Ev7glf6Uxq ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.UtWSs9vonP ++ cat /tmp/tmp.Ev7glf6Uxq ++ rm /tmp/tmp.UtWSs9vonP /tmp/tmp.Ev7glf6Uxq ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + sleep 40 + compare_mysql_cmd select-4 'SHOW TABLES;' '-h some-name-proxysql -utestsync -p'\''gDi$JdC1kSfR^vP,'\''' + local command_id=select-4 + local 'command=SHOW TABLES;' + local 'uri=-h some-name-proxysql -utestsync -p'\''gDi$JdC1kSfR^vP,'\''' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4.sql + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.4 ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.0 ]] + [[ -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4-80.sql ]] + expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4-80.sql + run_mysql 'SHOW TABLES;' '-h some-name-proxysql -utestsync -p'\''gDi$JdC1kSfR^vP,'\''' + local 'command=SHOW TABLES;' + local 'uri=-h some-name-proxysql -utestsync -p'\''gDi$JdC1kSfR^vP,'\''' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.ZRPta0eFpf +++ mktemp ++ local LAST_ERR=/tmp/tmp.q9Tz2X5fWa ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.ZRPta0eFpf ++ cat /tmp/tmp.q9Tz2X5fWa ++ rm /tmp/tmp.ZRPta0eFpf /tmp/tmp.q9Tz2X5fWa ++ return 0 + client_pod=pxc-client-59944c5bbf-lzk8n + wait_pod pxc-client-59944c5bbf-lzk8n + local pod=pxc-client-59944c5bbf-lzk8n + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-lzk8n ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-lzk8n condition met waiting for pod/pxc-client-59944c5bbf-lzk8n to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + '[' '!' -s /tmp/tmp.e7GavhpsLb/select-4.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4-80.sql /tmp/tmp.e7GavhpsLb/select-4.sql --- /mnt/jenkins/workspace/cloud-pxc-operator_PR-2221/e2e-tests/users/compare/select-4-80.sql 2025-10-23 14:28:14.561585705 +0000 +++ /tmp/tmp.e7GavhpsLb/select-4.sql 2025-10-23 17:02:33.822709762 +0000 @@ -1,88 +1,2 @@ -ADMINISTRABLE_ROLE_AUTHORIZATIONS -APPLICABLE_ROLES -CHARACTER_SETS -CHECK_CONSTRAINTS -CLIENT_STATISTICS -COLLATIONS -COLLATION_CHARACTER_SET_APPLICABILITY -COLUMNS -COLUMNS_EXTENSIONS -COLUMN_PRIVILEGES -COLUMN_STATISTICS -COMPRESSION_DICTIONARY -COMPRESSION_DICTIONARY_TABLES -ENABLED_ROLES -ENGINES -EVENTS -FILES -GLOBAL_TEMPORARY_TABLES -INDEX_STATISTICS -INNODB_BUFFER_PAGE -INNODB_BUFFER_PAGE_LRU -INNODB_BUFFER_POOL_STATS -INNODB_CACHED_INDEXES -INNODB_CMP -INNODB_CMPMEM -INNODB_CMPMEM_RESET -INNODB_CMP_PER_INDEX -INNODB_CMP_PER_INDEX_RESET -INNODB_CMP_RESET -INNODB_COLUMNS -INNODB_DATAFILES -INNODB_FIELDS -INNODB_FOREIGN -INNODB_FOREIGN_COLS -INNODB_FT_BEING_DELETED -INNODB_FT_CONFIG -INNODB_FT_DEFAULT_STOPWORD -INNODB_FT_DELETED -INNODB_FT_INDEX_CACHE -INNODB_FT_INDEX_TABLE -INNODB_INDEXES -INNODB_METRICS -INNODB_SESSION_TEMP_TABLESPACES -INNODB_TABLES -INNODB_TABLESPACES -INNODB_TABLESPACES_BRIEF -INNODB_TABLESTATS -INNODB_TEMP_TABLE_INFO -INNODB_TRX -INNODB_VIRTUAL -KEYWORDS -KEY_COLUMN_USAGE -OPTIMIZER_TRACE -PARAMETERS -PARTITIONS -PLUGINS -PROCESSLIST -PROFILING -REFERENTIAL_CONSTRAINTS -RESOURCE_GROUPS -ROLE_COLUMN_GRANTS -ROLE_ROUTINE_GRANTS -ROLE_TABLE_GRANTS -ROUTINES -SCHEMATA -SCHEMATA_EXTENSIONS -SCHEMA_PRIVILEGES -STATISTICS -ST_GEOMETRY_COLUMNS -ST_SPATIAL_REFERENCE_SYSTEMS -ST_UNITS_OF_MEASURE -TABLES -TABLESPACES -TABLESPACES_EXTENSIONS -TABLES_EXTENSIONS -TABLE_CONSTRAINTS -TABLE_CONSTRAINTS_EXTENSIONS -TABLE_PRIVILEGES -TABLE_STATISTICS -TEMPORARY_TABLES -THREAD_STATISTICS -TRIGGERS -USER_ATTRIBUTES -USER_PRIVILEGES -USER_STATISTICS -VIEWS -VIEW_ROUTINE_USAGE -VIEW_TABLE_USAGE +ERROR 1045 (28000): ProxySQL Error: Access denied for user 'testsync'@'10.22.153.63' (using password: YES) +command terminated with exit code 1