Log: /mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/logs/proxy-switch-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 + main + create_infra proxy-switch-32018 + local ns=proxy-switch-32018 + '[' -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 proxy-switch-1931 proxy-switch --type=merge -p '{"metadata":{"finalizers":[]}}' perconaxtradbcluster.pxc.percona.com/proxy-switch patched + kubectl_bin delete pxc --all --all-namespaces ++ mktemp + local LAST_OUT=/tmp/tmp.mXd1Fum9cq ++ mktemp + local LAST_ERR=/tmp/tmp.NWt1PfvyM7 + 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.mXd1Fum9cq perconaxtradbcluster.pxc.percona.com "proxy-switch" deleted from proxy-switch-1931 namespace + cat /tmp/tmp.NWt1PfvyM7 + rm /tmp/tmp.mXd1Fum9cq /tmp/tmp.NWt1PfvyM7 + return 0 + kubectl_bin delete pxc-backup --all --all-namespaces ++ mktemp + local LAST_OUT=/tmp/tmp.y91LNtdnWF ++ mktemp + local LAST_ERR=/tmp/tmp.W5HsszsZFd + 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.y91LNtdnWF No resources found + cat /tmp/tmp.W5HsszsZFd + rm /tmp/tmp.y91LNtdnWF /tmp/tmp.W5HsszsZFd + return 0 + kubectl_bin delete pxc-restore --all --all-namespaces ++ mktemp + local LAST_OUT=/tmp/tmp.skkLMJ9u1d ++ mktemp + local LAST_ERR=/tmp/tmp.sy0rsq5LoF + 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.skkLMJ9u1d No resources found + cat /tmp/tmp.sy0rsq5LoF + rm /tmp/tmp.skkLMJ9u1d /tmp/tmp.sy0rsq5LoF + return 0 + create_namespace pxc-operator + local namespace=pxc-operator + local skip_clean_namespace= + [[ 1 == 1 ]] + [[ -z '' ]] + destroy_chaos_mesh ++ sed s/NAMESPACE// ++ awk '-F ' '{print $2}' ++ tail -n1 ++ helm list --all-namespaces --filter chaos-mesh + 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 ++ awk '{print $1}' ++ grep validate-auth + 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 + grep -E -v '^kube-|^default|Terminating|pxc-operator|openshift|^gke-|^gmp-|^NAME' + '[' -n '' ']' + desc 'cleaned up old namespaces pxc-operator' + xargs kubectl delete ns + set +o xtrace ----------------------------------------------------------------------------------- cleaned up old namespaces pxc-operator ----------------------------------------------------------------------------------- + kubectl_bin delete namespace pxc-operator ++ mktemp ++ mktemp + local LAST_OUT=/tmp/tmp.b6t6Xd0YCM + awk '{print$1}' + local LAST_OUT=/tmp/tmp.5jMITs94Vd ++ mktemp ++ mktemp + local LAST_ERR=/tmp/tmp.LVGzvc8gTP + local exit_status=0 + local LAST_ERR=/tmp/tmp.miU2BNgVIm + 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 pxc-operator + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.5jMITs94Vd + cat /tmp/tmp.LVGzvc8gTP + rm /tmp/tmp.5jMITs94Vd /tmp/tmp.LVGzvc8gTP + return 0 namespace "proxy-switch-1931" deleted + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.b6t6Xd0YCM namespace "pxc-operator" deleted + cat /tmp/tmp.miU2BNgVIm + rm /tmp/tmp.b6t6Xd0YCM /tmp/tmp.miU2BNgVIm + 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.NI3YdJqOCN ++ mktemp + local LAST_ERR=/tmp/tmp.X2yokjkmKw + 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.NI3YdJqOCN namespace/pxc-operator created + cat /tmp/tmp.X2yokjkmKw + rm /tmp/tmp.NI3YdJqOCN /tmp/tmp.X2yokjkmKw + return 0 ++ kubectl_bin config current-context +++ mktemp ++ local LAST_OUT=/tmp/tmp.SsLIUFM8bk +++ mktemp ++ local LAST_ERR=/tmp/tmp.YPkWTG7Og3 ++ 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.SsLIUFM8bk ++ cat /tmp/tmp.YPkWTG7Og3 ++ rm /tmp/tmp.SsLIUFM8bk /tmp/tmp.YPkWTG7Og3 ++ return 0 + kubectl_bin config set-context gke_cloud-dev-112233_us-central1-a_jen-pxc-2290-96398578-2-cluster3 --namespace=pxc-operator ++ mktemp + local LAST_OUT=/tmp/tmp.VcAdNDjoDG ++ mktemp + local LAST_ERR=/tmp/tmp.v87xfiz9l0 + 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-2290-96398578-2-cluster3 --namespace=pxc-operator + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.VcAdNDjoDG Context "gke_cloud-dev-112233_us-central1-a_jen-pxc-2290-96398578-2-cluster3" modified. + cat /tmp/tmp.v87xfiz9l0 + rm /tmp/tmp.VcAdNDjoDG /tmp/tmp.v87xfiz9l0 + 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-2290/deploy/crd.yaml ++ mktemp + local LAST_OUT=/tmp/tmp.fEvyXYGTca ++ mktemp + local LAST_ERR=/tmp/tmp.B0CWYnz9TB + 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-2290/deploy/crd.yaml + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.fEvyXYGTca 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.B0CWYnz9TB + rm /tmp/tmp.fEvyXYGTca /tmp/tmp.B0CWYnz9TB + return 0 + '[' -n pxc-operator ']' + apply_rbac cw-rbac + local operator_namespace=pxc-operator + local rbac=cw-rbac + sed -e 's^namespace: .*^namespace: pxc-operator^' + cat /mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/deploy/cw-rbac.yaml + kubectl_bin apply -f - ++ mktemp + local LAST_OUT=/tmp/tmp.KfxleNNXGq ++ mktemp + local LAST_ERR=/tmp/tmp.k0nZomBSwD + 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.KfxleNNXGq 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.k0nZomBSwD + rm /tmp/tmp.KfxleNNXGq /tmp/tmp.k0nZomBSwD + return 0 + sed -e 's^image: .*^image: perconalab/percona-xtradb-cluster-operator:PR-2290-96398578^' + yq eval '(select(.kind == "Deployment").spec.template.spec.containers[] | select(.name == "percona-xtradb-cluster-operator").env[] | select(.name == "LOG_LEVEL").value) = "VERBOSE"' - + kubectl_bin apply -f - ++ mktemp + local LAST_OUT=/tmp/tmp.CxQvBe2Uxr ++ mktemp + local LAST_ERR=/tmp/tmp.coGSkbUSHl + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl apply -f - + sed -e 's^failureThreshold: .*^failureThreshold: 10^' + cat /mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/deploy/cw-operator.yaml + yq eval '(select(.kind == "Deployment").spec.template.spec.containers[] | select(.name == "percona-xtradb-cluster-operator").env[] | select(.name == "DISABLE_TELEMETRY").value) = "true"' - + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.CxQvBe2Uxr deployment.apps/percona-xtradb-cluster-operator created service/percona-xtradb-cluster-operator created + cat /tmp/tmp.coGSkbUSHl + rm /tmp/tmp.CxQvBe2Uxr /tmp/tmp.coGSkbUSHl + 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.jQWBJXOsKR ++ mktemp + local LAST_ERR=/tmp/tmp.02zBjSmns8 + 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.jQWBJXOsKR pod/percona-xtradb-cluster-operator-7b6f7d984c-xrnqc condition met + cat /tmp/tmp.02zBjSmns8 + rm /tmp/tmp.jQWBJXOsKR /tmp/tmp.02zBjSmns8 + 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.3lz568Jrpb +++ mktemp ++ local LAST_ERR=/tmp/tmp.c0p7N2cHtZ ++ 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.3lz568Jrpb ++ cat /tmp/tmp.c0p7N2cHtZ ++ rm /tmp/tmp.3lz568Jrpb /tmp/tmp.c0p7N2cHtZ ++ return 0 + wait_pod percona-xtradb-cluster-operator-7b6f7d984c-xrnqc 480 pxc-operator + local pod=percona-xtradb-cluster-operator-7b6f7d984c-xrnqc + local max_retry=480 + local ns=pxc-operator ++ echo percona-xtradb-cluster-operator-7b6f7d984c-xrnqc ++ grep -E '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container= + set +o xtrace pod/percona-xtradb-cluster-operator-7b6f7d984c-xrnqc condition met waiting for pod/percona-xtradb-cluster-operator-7b6f7d984c-xrnqc to become Ready.Ok + sleep 3 + create_namespace proxy-switch-32018 + local namespace=proxy-switch-32018 + local skip_clean_namespace= + [[ 1 == 1 ]] + [[ -z '' ]] + destroy_chaos_mesh ++ helm list --all-namespaces --filter chaos-mesh ++ awk '-F ' '{print $2}' ++ tail -n1 ++ 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 ----------------------------------------------------------------------------------- + grep -E -v '^kube-|^default|Terminating|pxc-operator|openshift|^gke-|^gmp-|^NAME' + awk '{print$1}' + '[' -n '' ']' + desc 'cleaned up old namespaces proxy-switch-32018' + xargs kubectl delete ns + set +o xtrace ----------------------------------------------------------------------------------- cleaned up old namespaces proxy-switch-32018 ----------------------------------------------------------------------------------- + kubectl_bin delete namespace proxy-switch-32018 + kubectl_bin get ns ++ mktemp ++ mktemp + local LAST_OUT=/tmp/tmp.vkVvbggJ8p + local LAST_OUT=/tmp/tmp.EkdG4dxodn ++ mktemp ++ mktemp + local LAST_ERR=/tmp/tmp.tJGXSEiZdY + local exit_status=0 ++ seq 0 2 + local LAST_ERR=/tmp/tmp.S8GAZuljOi + local exit_status=0 ++ 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 proxy-switch-32018 + exit_status=1 + set -e + '[' 1 '!=' 0 ']' + '[' 1 == 1 ']' + sleep 0 + for i in '$(seq 0 2)' + set +e + kubectl delete namespace proxy-switch-32018 + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.EkdG4dxodn + cat /tmp/tmp.tJGXSEiZdY + rm /tmp/tmp.EkdG4dxodn /tmp/tmp.tJGXSEiZdY + 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 proxy-switch-32018 + exit_status=1 + set -e + '[' 1 '!=' 0 ']' + '[' 1 == 1 ']' + sleep 0 + cat /tmp/tmp.vkVvbggJ8p + cat /tmp/tmp.S8GAZuljOi Error from server (NotFound): namespaces "proxy-switch-32018" not found + rm /tmp/tmp.vkVvbggJ8p /tmp/tmp.S8GAZuljOi + return 1 + : + wait_for_delete namespace/proxy-switch-32018 + local res=namespace/proxy-switch-32018 + echo -n 'waiting for namespace/proxy-switch-32018 to be deleted' waiting for namespace/proxy-switch-32018 to be deleted+ set +o xtrace Error from server (NotFound): namespaces "proxy-switch-32018" not found + desc 'create namespace proxy-switch-32018' + set +o xtrace ----------------------------------------------------------------------------------- create namespace proxy-switch-32018 ----------------------------------------------------------------------------------- + kubectl_bin create namespace proxy-switch-32018 ++ mktemp + local LAST_OUT=/tmp/tmp.vzuCYRZGql ++ mktemp + local LAST_ERR=/tmp/tmp.GXi6HFlLPx + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl create namespace proxy-switch-32018 + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.vzuCYRZGql namespace/proxy-switch-32018 created + cat /tmp/tmp.GXi6HFlLPx + rm /tmp/tmp.vzuCYRZGql /tmp/tmp.GXi6HFlLPx + return 0 ++ kubectl_bin config current-context +++ mktemp ++ local LAST_OUT=/tmp/tmp.nLtSqfPfqj +++ mktemp ++ local LAST_ERR=/tmp/tmp.3UGEnuTHnl ++ 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.nLtSqfPfqj ++ cat /tmp/tmp.3UGEnuTHnl ++ rm /tmp/tmp.nLtSqfPfqj /tmp/tmp.3UGEnuTHnl ++ return 0 + kubectl_bin config set-context gke_cloud-dev-112233_us-central1-a_jen-pxc-2290-96398578-2-cluster3 --namespace=proxy-switch-32018 ++ mktemp + local LAST_OUT=/tmp/tmp.YfzeJT6SIB ++ mktemp + local LAST_ERR=/tmp/tmp.K42HEbdok2 + 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-2290-96398578-2-cluster3 --namespace=proxy-switch-32018 + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.YfzeJT6SIB Context "gke_cloud-dev-112233_us-central1-a_jen-pxc-2290-96398578-2-cluster3" modified. + cat /tmp/tmp.K42HEbdok2 + rm /tmp/tmp.YfzeJT6SIB /tmp/tmp.K42HEbdok2 + 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-2290/e2e-tests/conf/minio-secret.yml -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/conf/cloud-secret.yml ++ mktemp + local LAST_OUT=/tmp/tmp.GGHzaBM4Tg ++ mktemp + local LAST_ERR=/tmp/tmp.OMVRuyNWPP + 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-2290/e2e-tests/conf/minio-secret.yml -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/conf/cloud-secret.yml + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.GGHzaBM4Tg secret/minio-secret created secret/aws-s3-secret created secret/gcp-cs-secret created secret/azure-secret created + cat /tmp/tmp.OMVRuyNWPP + rm /tmp/tmp.GGHzaBM4Tg /tmp/tmp.OMVRuyNWPP + return 0 + desc 'create PXC cluster with HAProxy' + set +o xtrace ----------------------------------------------------------------------------------- create PXC cluster with HAProxy ----------------------------------------------------------------------------------- + cluster=proxy-switch + spinup_pxc proxy-switch /mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/conf/proxy-switch.yml 3 10 + local cluster=proxy-switch + local config=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/conf/proxy-switch.yml + local size=3 + local sleep=10 + local secretsFile=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/conf/secrets.yml + local pxcClientFile=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/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-2290/e2e-tests/conf/secrets.yml ++ mktemp + local LAST_OUT=/tmp/tmp.B2QpRbgi0X ++ mktemp + local LAST_ERR=/tmp/tmp.UeTyAkIWbK + 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-2290/e2e-tests/conf/secrets.yml + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.B2QpRbgi0X secret/my-cluster-secrets created secret/some-name-ssl created secret/some-name-ssl-internal created + cat /tmp/tmp.UeTyAkIWbK + rm /tmp/tmp.B2QpRbgi0X /tmp/tmp.UeTyAkIWbK + return 0 + apply_config /mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/conf/client.yml + local config_file=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/conf/client.yml + local pvc_name= + '[' -z '' ']' + cat_config /mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/conf/client.yml '' + local input_file=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/conf/client.yml + local pvc_name= + kubectl_bin apply -f - + cat /mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/conf/client.yml ++ mktemp + /usr/bin/sed -e 's#apiVersion: pxc.percona.com/v.*$#apiVersion: pxc.percona.com/v1#' + /usr/bin/sed -e 's#image:.*\/percona-xtradb-cluster:.*$#image: perconalab/percona-xtradb-cluster-operator:main-pxc8.0#' + local LAST_OUT=/tmp/tmp.8izXLip9NL + /usr/bin/sed -e 's#image:.*-init$#image: perconalab/percona-xtradb-cluster-operator:PR-2290-96398578#' + /usr/bin/sed -e 's#image:.*-haproxy$#image: perconalab/percona-xtradb-cluster-operator:main-haproxy#' + /usr/bin/sed -e 's#image:.*-pxc\([0-9]*.[0-9]*\)\{0,1\}$#image: perconalab/percona-xtradb-cluster-operator:main-pxc8.0#' ++ mktemp + /usr/bin/sed -e s~minio-service.#namespace~minio-service.proxy-switch-32018~ + /usr/bin/sed -e 's#apply:.*#apply: Never#' + /usr/bin/sed -e 's#image:.*-proxysql$#image: perconalab/percona-xtradb-cluster-operator:main-proxysql#' + local LAST_ERR=/tmp/tmp.oaKQjnh4pt + local exit_status=0 + /usr/bin/sed -e 's#image:.*-logcollector$#image: perconalab/fluentbit:main-logcollector#' + /usr/bin/sed -e 's#image:.*-backup$#image: perconalab/percona-xtradb-cluster-operator:main-pxc8.0-backup#' + /usr/bin/sed -e 's#image:.*-pmm$#image: perconalab/pmm-client:dev-latest#' + /usr/bin/sed -e 's#claimName:..*-backup-pvc$#claimName: #' ++ 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.8izXLip9NL deployment.apps/pxc-client created + cat /tmp/tmp.oaKQjnh4pt + rm /tmp/tmp.8izXLip9NL /tmp/tmp.oaKQjnh4pt + return 0 + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + apply_config /mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/conf/proxy-switch.yml + local config_file=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/conf/proxy-switch.yml + local pvc_name= + '[' -z '' ']' + cat_config /mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/conf/proxy-switch.yml '' + kubectl_bin apply -f - + local input_file=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/conf/proxy-switch.yml + local pvc_name= + /usr/bin/sed -e 's#apiVersion: pxc.percona.com/v.*$#apiVersion: pxc.percona.com/v1#' + /usr/bin/sed -e 's#image:.*\/percona-xtradb-cluster:.*$#image: perconalab/percona-xtradb-cluster-operator:main-pxc8.0#' + /usr/bin/sed -e 's#image:.*-logcollector$#image: perconalab/fluentbit:main-logcollector#' + /usr/bin/sed -e 's#image:.*-proxysql$#image: perconalab/percona-xtradb-cluster-operator:main-proxysql#' + /usr/bin/sed -e 's#image:.*-backup$#image: perconalab/percona-xtradb-cluster-operator:main-pxc8.0-backup#' + /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#' + /usr/bin/sed -e 's#claimName:..*-backup-pvc$#claimName: #' + /usr/bin/sed -e 's#apply:.*#apply: Never#' + /usr/bin/sed -e s~minio-service.#namespace~minio-service.proxy-switch-32018~ + /usr/bin/sed -e 's#image:.*-init$#image: perconalab/percona-xtradb-cluster-operator:PR-2290-96398578#' ++ mktemp + cat /mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/conf/proxy-switch.yml + local LAST_OUT=/tmp/tmp.LRUWpBbdyn + /usr/bin/sed -e 's#image:.*-pxc\([0-9]*.[0-9]*\)\{0,1\}$#image: perconalab/percona-xtradb-cluster-operator:main-pxc8.0#' ++ mktemp + local LAST_ERR=/tmp/tmp.LVo537OxZF + 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.LRUWpBbdyn perconaxtradbcluster.pxc.percona.com/proxy-switch created + cat /tmp/tmp.LVo537OxZF + rm /tmp/tmp.LRUWpBbdyn /tmp/tmp.LVo537OxZF + return 0 + desc 'check if all 3 Pods started' + set +o xtrace ----------------------------------------------------------------------------------- check if all 3 Pods started ----------------------------------------------------------------------------------- ++ get_proxy proxy-switch ++ local target_cluster=proxy-switch +++ kubectl_bin get pxc proxy-switch -o 'jsonpath={.spec.haproxy.enabled}' ++++ mktemp +++ local LAST_OUT=/tmp/tmp.FbwxPxvi4l ++++ mktemp +++ local LAST_ERR=/tmp/tmp.xprpdlSR8X +++ local exit_status=0 ++++ seq 0 2 +++ for i in '$(seq 0 2)' +++ set +e +++ kubectl get pxc proxy-switch -o 'jsonpath={.spec.haproxy.enabled}' +++ exit_status=0 +++ set -e +++ '[' 0 '!=' 0 ']' +++ break +++ cat /tmp/tmp.FbwxPxvi4l +++ cat /tmp/tmp.xprpdlSR8X +++ rm /tmp/tmp.FbwxPxvi4l /tmp/tmp.xprpdlSR8X +++ return 0 ++ [[ true == \t\r\u\e ]] ++ echo proxy-switch-haproxy ++ return + local proxy=proxy-switch-haproxy + 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 proxy-switch-32018 ++ mktemp + local LAST_OUT=/tmp/tmp.1qyx7lwUwK ++ mktemp + local LAST_ERR=/tmp/tmp.EdB7AGcMhg + 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 proxy-switch-32018 + 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 proxy-switch-32018 + 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 proxy-switch-32018 + exit_status=1 + set -e + '[' 1 '!=' 0 ']' + '[' 1 == 1 ']' + sleep 0 + cat /tmp/tmp.1qyx7lwUwK + cat /tmp/tmp.EdB7AGcMhg error: no matching resources found + rm /tmp/tmp.1qyx7lwUwK /tmp/tmp.EdB7AGcMhg + return 1 + true + wait_for_running proxy-switch-haproxy 1 + local name=proxy-switch-haproxy + 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 proxy-switch-haproxy-0 480 + local pod=proxy-switch-haproxy-0 + local max_retry=480 + local ns= ++ grep -E '^(pxc|proxysql)$' ++ echo proxy-switch-haproxy-0 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container= + set +o xtrace pod/proxy-switch-haproxy-0 condition met waiting for pod/proxy-switch-haproxy-0 to become Ready.Ok + wait_for_running proxy-switch-pxc 3 + local name=proxy-switch-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 proxy-switch-pxc-0 480 + local pod=proxy-switch-pxc-0 + local max_retry=480 + local ns= ++ echo proxy-switch-pxc-0 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ grep -E '^(pxc|proxysql)$' + local container=pxc + set +o xtrace pod/proxy-switch-pxc-0 condition met waiting for pod/proxy-switch-pxc-0 to become Ready.Ok + for i in '$(seq 0 $last_pod)' + wait_pod proxy-switch-pxc-1 480 + local pod=proxy-switch-pxc-1 + local max_retry=480 + local ns= ++ echo proxy-switch-pxc-1 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ grep -E '^(pxc|proxysql)$' + local container=pxc + set +o xtrace pod/proxy-switch-pxc-1 condition met waiting for pod/proxy-switch-pxc-1 to become Ready.Ok + for i in '$(seq 0 $last_pod)' + wait_pod proxy-switch-pxc-2 480 + local pod=proxy-switch-pxc-2 + local max_retry=480 + local ns= ++ grep -E '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ echo proxy-switch-pxc-2 + local container=pxc + set +o xtrace pod/proxy-switch-pxc-2 condition met waiting for pod/proxy-switch-pxc-2 to become Ready.Ok + sleep 10 ++ kubectl get pxc proxy-switch -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.Zg9p0E92S9 +++ mktemp ++ local LAST_ERR=/tmp/tmp.vn8916aHNG ++ 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.Zg9p0E92S9 ++ cat /tmp/tmp.vn8916aHNG ++ rm /tmp/tmp.Zg9p0E92S9 /tmp/tmp.vn8916aHNG ++ return 0 + local root_pass=root_password + 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 proxy-switch-haproxy -uroot -p'\''root_password'\'' -P3306' + local 'command=CREATE DATABASE IF NOT EXISTS myApp; use myApp; CREATE TABLE IF NOT EXISTS myApp (id int PRIMARY KEY) ;' + local 'uri=-h proxy-switch-haproxy -uroot -p'\''root_password'\'' -P3306' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.65gbyEDz7D +++ mktemp ++ local LAST_ERR=/tmp/tmp.aQxJsZPl3J ++ 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.65gbyEDz7D ++ cat /tmp/tmp.aQxJsZPl3J ++ rm /tmp/tmp.65gbyEDz7D /tmp/tmp.aQxJsZPl3J ++ return 0 + client_pod=pxc-client-59944c5bbf-fdpl8 + wait_pod pxc-client-59944c5bbf-fdpl8 + local pod=pxc-client-59944c5bbf-fdpl8 + local max_retry=480 + local ns= ++ grep -E '^(pxc|proxysql)$' ++ echo pxc-client-59944c5bbf-fdpl8 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-fdpl8 condition met waiting for pod/pxc-client-59944c5bbf-fdpl8 to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + run_mysql 'INSERT myApp.myApp (id) VALUES (100500)' '-h proxy-switch-haproxy -uroot -p'\''root_password'\'' -P3306' + local 'command=INSERT myApp.myApp (id) VALUES (100500)' + local 'uri=-h proxy-switch-haproxy -uroot -p'\''root_password'\'' -P3306' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.d8x1xAIhEs +++ mktemp ++ local LAST_ERR=/tmp/tmp.pDzHjwXTbs ++ 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.d8x1xAIhEs ++ cat /tmp/tmp.pDzHjwXTbs ++ rm /tmp/tmp.d8x1xAIhEs /tmp/tmp.pDzHjwXTbs ++ return 0 + client_pod=pxc-client-59944c5bbf-fdpl8 + wait_pod pxc-client-59944c5bbf-fdpl8 + local pod=pxc-client-59944c5bbf-fdpl8 + local max_retry=480 + local ns= ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ grep -E '^(pxc|proxysql)$' ++ echo pxc-client-59944c5bbf-fdpl8 + local container= + set +o xtrace pod/pxc-client-59944c5bbf-fdpl8 condition met waiting for pod/pxc-client-59944c5bbf-fdpl8 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 proxy-switch-pxc-0.proxy-switch-pxc -uroot -p'\''root_password'\'' -P3306' + local command_id=select-1 + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-pxc-0.proxy-switch-pxc -uroot -p'\''root_password'\'' -P3306' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/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-2290/e2e-tests/proxy-switch/compare/select-1-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SELECT * from myApp.myApp;' '-h proxy-switch-pxc-0.proxy-switch-pxc -uroot -p'\''root_password'\'' -P3306' + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-pxc-0.proxy-switch-pxc -uroot -p'\''root_password'\'' -P3306' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.sryrEui7Ik +++ mktemp ++ local LAST_ERR=/tmp/tmp.fRZwIsx1Zi ++ 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.sryrEui7Ik ++ cat /tmp/tmp.fRZwIsx1Zi ++ rm /tmp/tmp.sryrEui7Ik /tmp/tmp.fRZwIsx1Zi ++ return 0 + client_pod=pxc-client-59944c5bbf-fdpl8 + wait_pod pxc-client-59944c5bbf-fdpl8 + local pod=pxc-client-59944c5bbf-fdpl8 + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-fdpl8 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ grep -E '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-fdpl8 condition met waiting for pod/pxc-client-59944c5bbf-fdpl8 to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + [[ ! -s /tmp/tmp.j2wBW4HTkS/select-1.sql ]] ++ grep 'Unknown MySQL server host' /tmp/tmp.j2wBW4HTkS/select-1.sql + [[ -n '' ]] + [[ 0 -eq 0 ]] + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/compare/select-1.sql /tmp/tmp.j2wBW4HTkS/select-1.sql + for i in '$(seq 0 $((size - 1)))' + compare_mysql_cmd select-1 'SELECT * from myApp.myApp;' '-h proxy-switch-pxc-1.proxy-switch-pxc -uroot -p'\''root_password'\'' -P3306' + local command_id=select-1 + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-pxc-1.proxy-switch-pxc -uroot -p'\''root_password'\'' -P3306' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/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-2290/e2e-tests/proxy-switch/compare/select-1-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SELECT * from myApp.myApp;' '-h proxy-switch-pxc-1.proxy-switch-pxc -uroot -p'\''root_password'\'' -P3306' + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-pxc-1.proxy-switch-pxc -uroot -p'\''root_password'\'' -P3306' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.31wngW3Xo2 +++ mktemp ++ local LAST_ERR=/tmp/tmp.fntsCZOlns ++ 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.31wngW3Xo2 ++ cat /tmp/tmp.fntsCZOlns ++ rm /tmp/tmp.31wngW3Xo2 /tmp/tmp.fntsCZOlns ++ return 0 + client_pod=pxc-client-59944c5bbf-fdpl8 + wait_pod pxc-client-59944c5bbf-fdpl8 + local pod=pxc-client-59944c5bbf-fdpl8 + local max_retry=480 + local ns= ++ grep -E '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ echo pxc-client-59944c5bbf-fdpl8 + local container= + set +o xtrace pod/pxc-client-59944c5bbf-fdpl8 condition met waiting for pod/pxc-client-59944c5bbf-fdpl8 to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + [[ ! -s /tmp/tmp.j2wBW4HTkS/select-1.sql ]] ++ grep 'Unknown MySQL server host' /tmp/tmp.j2wBW4HTkS/select-1.sql + [[ -n '' ]] + [[ 0 -eq 0 ]] + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/compare/select-1.sql /tmp/tmp.j2wBW4HTkS/select-1.sql + for i in '$(seq 0 $((size - 1)))' + compare_mysql_cmd select-1 'SELECT * from myApp.myApp;' '-h proxy-switch-pxc-2.proxy-switch-pxc -uroot -p'\''root_password'\'' -P3306' + local command_id=select-1 + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-pxc-2.proxy-switch-pxc -uroot -p'\''root_password'\'' -P3306' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/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-2290/e2e-tests/proxy-switch/compare/select-1-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SELECT * from myApp.myApp;' '-h proxy-switch-pxc-2.proxy-switch-pxc -uroot -p'\''root_password'\'' -P3306' + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-pxc-2.proxy-switch-pxc -uroot -p'\''root_password'\'' -P3306' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.exQQeWS2K2 +++ mktemp ++ local LAST_ERR=/tmp/tmp.d8bpYeRvkK ++ 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.exQQeWS2K2 ++ cat /tmp/tmp.d8bpYeRvkK ++ rm /tmp/tmp.exQQeWS2K2 /tmp/tmp.d8bpYeRvkK ++ return 0 + client_pod=pxc-client-59944c5bbf-fdpl8 + wait_pod pxc-client-59944c5bbf-fdpl8 + local pod=pxc-client-59944c5bbf-fdpl8 + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-fdpl8 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ grep -E '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-fdpl8 condition met waiting for pod/pxc-client-59944c5bbf-fdpl8 to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + [[ ! -s /tmp/tmp.j2wBW4HTkS/select-1.sql ]] ++ grep 'Unknown MySQL server host' /tmp/tmp.j2wBW4HTkS/select-1.sql + [[ -n '' ]] + [[ 0 -eq 0 ]] + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/compare/select-1.sql /tmp/tmp.j2wBW4HTkS/select-1.sql + is_keyring_plugin_in_use proxy-switch + local cluster=proxy-switch + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.4 ]] + kubectl_bin exec -it proxy-switch-pxc-0 -c pxc -- bash -c 'cat /etc/mysql/node.cnf' ++ mktemp + local LAST_OUT=/tmp/tmp.9VBfntg2Dl ++ mktemp + local LAST_ERR=/tmp/tmp.fiZjVR2KwC + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl exec -it proxy-switch-pxc-0 -c pxc -- bash -c 'cat /etc/mysql/node.cnf' + grep -E -o 'early-plugin-load=keyring_\w+.so' + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.9VBfntg2Dl + cat /tmp/tmp.fiZjVR2KwC Unable to use a TTY - input is not a terminal or the right kind of file + rm /tmp/tmp.9VBfntg2Dl /tmp/tmp.fiZjVR2KwC + return 0 + return 1 + desc 'check cluster is ready with HAProxy' + set +o xtrace ----------------------------------------------------------------------------------- check cluster is ready with HAProxy ----------------------------------------------------------------------------------- + wait_for_running proxy-switch-pxc 3 + local name=proxy-switch-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 proxy-switch-pxc-0 480 + local pod=proxy-switch-pxc-0 + local max_retry=480 + local ns= ++ echo proxy-switch-pxc-0 ++ grep -E '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container=pxc + set +o xtrace pod/proxy-switch-pxc-0 condition met waiting for pod/proxy-switch-pxc-0 to become Ready.Ok + for i in '$(seq 0 $last_pod)' + wait_pod proxy-switch-pxc-1 480 + local pod=proxy-switch-pxc-1 + local max_retry=480 + local ns= ++ grep -E '^(pxc|proxysql)$' ++ echo proxy-switch-pxc-1 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container=pxc + set +o xtrace pod/proxy-switch-pxc-1 condition met waiting for pod/proxy-switch-pxc-1 to become Ready.Ok + for i in '$(seq 0 $last_pod)' + wait_pod proxy-switch-pxc-2 480 + local pod=proxy-switch-pxc-2 + local max_retry=480 + local ns= ++ echo proxy-switch-pxc-2 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ grep -E '^(pxc|proxysql)$' + local container=pxc + set +o xtrace pod/proxy-switch-pxc-2 condition met waiting for pod/proxy-switch-pxc-2 to become Ready.Ok + wait_for_running proxy-switch-haproxy 3 + local name=proxy-switch-haproxy + 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 proxy-switch-haproxy-0 480 + local pod=proxy-switch-haproxy-0 + local max_retry=480 + local ns= ++ echo proxy-switch-haproxy-0 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ grep -E '^(pxc|proxysql)$' + local container= + set +o xtrace pod/proxy-switch-haproxy-0 condition met waiting for pod/proxy-switch-haproxy-0 to become Ready.Ok + for i in '$(seq 0 $last_pod)' + wait_pod proxy-switch-haproxy-1 480 + local pod=proxy-switch-haproxy-1 + local max_retry=480 + local ns= ++ grep -E '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ echo proxy-switch-haproxy-1 + local container= + set +o xtrace pod/proxy-switch-haproxy-1 condition met waiting for pod/proxy-switch-haproxy-1 to become Ready.Ok + for i in '$(seq 0 $last_pod)' + wait_pod proxy-switch-haproxy-2 480 + local pod=proxy-switch-haproxy-2 + local max_retry=480 + local ns= ++ echo proxy-switch-haproxy-2 ++ grep -E '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container= + set +o xtrace pod/proxy-switch-haproxy-2 condition met waiting for pod/proxy-switch-haproxy-2 to become Ready.Ok + wait_cluster_consistency proxy-switch 3 3 + local cluster_name=proxy-switch + 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/proxy-switch to be ready' waiting for pxc/proxy-switch to be ready++ kubectl_bin get pxc proxy-switch -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.cXRpcYz7pP +++ mktemp ++ local LAST_ERR=/tmp/tmp.AT1UnMu473 ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc proxy-switch -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.cXRpcYz7pP ++ cat /tmp/tmp.AT1UnMu473 ++ rm /tmp/tmp.cXRpcYz7pP /tmp/tmp.AT1UnMu473 ++ return 0 + [[ ready == \r\e\a\d\y ]] ++ kubectl_bin get pxc proxy-switch -o 'jsonpath={.status.pxc.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.kIoq1XQFaJ +++ mktemp ++ local LAST_ERR=/tmp/tmp.M5mZQNonvN ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc proxy-switch -o 'jsonpath={.status.pxc.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.kIoq1XQFaJ ++ cat /tmp/tmp.M5mZQNonvN ++ rm /tmp/tmp.kIoq1XQFaJ /tmp/tmp.M5mZQNonvN ++ return 0 + [[ 3 == \3 ]] +++ get_proxy_engine proxy-switch +++ local cluster_name=proxy-switch ++++ get_proxy proxy-switch ++++ local target_cluster=proxy-switch +++++ kubectl_bin get pxc proxy-switch -o 'jsonpath={.spec.haproxy.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.LATWdNjJEF ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.BqYovMEePj +++++ local exit_status=0 ++++++ seq 0 2 +++++ for i in '$(seq 0 2)' +++++ set +e +++++ kubectl get pxc proxy-switch -o 'jsonpath={.spec.haproxy.enabled}' +++++ exit_status=0 +++++ set -e +++++ '[' 0 '!=' 0 ']' +++++ break +++++ cat /tmp/tmp.LATWdNjJEF +++++ cat /tmp/tmp.BqYovMEePj +++++ rm /tmp/tmp.LATWdNjJEF /tmp/tmp.BqYovMEePj +++++ return 0 ++++ [[ true == \t\r\u\e ]] ++++ echo proxy-switch-haproxy ++++ return +++ local cluster_proxy=proxy-switch-haproxy +++ echo haproxy ++ kubectl_bin get pxc proxy-switch -o 'jsonpath={.status.haproxy.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.dlM39DrJAK +++ mktemp ++ local LAST_ERR=/tmp/tmp.nmaNd5zIoj ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc proxy-switch -o 'jsonpath={.status.haproxy.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.dlM39DrJAK ++ cat /tmp/tmp.nmaNd5zIoj ++ rm /tmp/tmp.dlM39DrJAK /tmp/tmp.nmaNd5zIoj ++ return 0 + [[ 3 == \3 ]] + echo + desc 'write data and check connectivity through HAProxy' + set +o xtrace ----------------------------------------------------------------------------------- write data and check connectivity through HAProxy ----------------------------------------------------------------------------------- + run_mysql 'CREATE DATABASE IF NOT EXISTS myApp; use myApp; CREATE TABLE IF NOT EXISTS myApp (id int PRIMARY KEY);' '-h proxy-switch-haproxy -uroot -proot_password' + local 'command=CREATE DATABASE IF NOT EXISTS myApp; use myApp; CREATE TABLE IF NOT EXISTS myApp (id int PRIMARY KEY);' + local 'uri=-h proxy-switch-haproxy -uroot -proot_password' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.WZXMkPUHin +++ mktemp ++ local LAST_ERR=/tmp/tmp.XzY5jCGDz4 ++ 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.WZXMkPUHin ++ cat /tmp/tmp.XzY5jCGDz4 ++ rm /tmp/tmp.WZXMkPUHin /tmp/tmp.XzY5jCGDz4 ++ return 0 + client_pod=pxc-client-59944c5bbf-fdpl8 + wait_pod pxc-client-59944c5bbf-fdpl8 + local pod=pxc-client-59944c5bbf-fdpl8 + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-fdpl8 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ grep -E '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-fdpl8 condition met waiting for pod/pxc-client-59944c5bbf-fdpl8 to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + run_mysql 'INSERT myApp.myApp (id) VALUES (100500)' '-h proxy-switch-haproxy -uroot -proot_password' + local 'command=INSERT myApp.myApp (id) VALUES (100500)' + local 'uri=-h proxy-switch-haproxy -uroot -proot_password' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.uw5lNrHc42 +++ mktemp ++ local LAST_ERR=/tmp/tmp.HZ5qJbSzvG ++ 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.uw5lNrHc42 ++ cat /tmp/tmp.HZ5qJbSzvG ++ rm /tmp/tmp.uw5lNrHc42 /tmp/tmp.HZ5qJbSzvG ++ return 0 + client_pod=pxc-client-59944c5bbf-fdpl8 + wait_pod pxc-client-59944c5bbf-fdpl8 + local pod=pxc-client-59944c5bbf-fdpl8 + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-fdpl8 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ grep -E '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-fdpl8 condition met waiting for pod/pxc-client-59944c5bbf-fdpl8 to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace ERROR 1062 (23000) at line 1: Duplicate entry '100500' for key 'myApp.PRIMARY' command terminated with exit code 1 + sleep 10 + compare_mysql_cmd select-1 'SELECT * from myApp.myApp;' '-h proxy-switch-haproxy -uroot -proot_password' + local command_id=select-1 + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-haproxy -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/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-2290/e2e-tests/proxy-switch/compare/select-1-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SELECT * from myApp.myApp;' '-h proxy-switch-haproxy -uroot -proot_password' + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-haproxy -uroot -proot_password' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.8Bdb2bTl0e +++ mktemp ++ local LAST_ERR=/tmp/tmp.9lQSv8V8Ct ++ 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.8Bdb2bTl0e ++ cat /tmp/tmp.9lQSv8V8Ct ++ rm /tmp/tmp.8Bdb2bTl0e /tmp/tmp.9lQSv8V8Ct ++ return 0 + client_pod=pxc-client-59944c5bbf-fdpl8 + wait_pod pxc-client-59944c5bbf-fdpl8 + local pod=pxc-client-59944c5bbf-fdpl8 + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-fdpl8 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ grep -E '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-fdpl8 condition met waiting for pod/pxc-client-59944c5bbf-fdpl8 to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + [[ ! -s /tmp/tmp.j2wBW4HTkS/select-1.sql ]] ++ grep 'Unknown MySQL server host' /tmp/tmp.j2wBW4HTkS/select-1.sql + [[ -n '' ]] + [[ 0 -eq 0 ]] + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/compare/select-1.sql /tmp/tmp.j2wBW4HTkS/select-1.sql + desc 'verify data exists on all PXC nodes' + set +o xtrace ----------------------------------------------------------------------------------- verify data exists on all PXC nodes ----------------------------------------------------------------------------------- + compare_mysql_cmd select-1 'SELECT * from myApp.myApp;' '-h proxy-switch-pxc-0.proxy-switch-pxc -uroot -proot_password' + local command_id=select-1 + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-pxc-0.proxy-switch-pxc -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/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-2290/e2e-tests/proxy-switch/compare/select-1-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SELECT * from myApp.myApp;' '-h proxy-switch-pxc-0.proxy-switch-pxc -uroot -proot_password' + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-pxc-0.proxy-switch-pxc -uroot -proot_password' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.GwufJknWwj +++ mktemp ++ local LAST_ERR=/tmp/tmp.I9lhfylHxS ++ 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.GwufJknWwj ++ cat /tmp/tmp.I9lhfylHxS ++ rm /tmp/tmp.GwufJknWwj /tmp/tmp.I9lhfylHxS ++ return 0 + client_pod=pxc-client-59944c5bbf-fdpl8 + wait_pod pxc-client-59944c5bbf-fdpl8 + local pod=pxc-client-59944c5bbf-fdpl8 + local max_retry=480 + local ns= ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ grep -E '^(pxc|proxysql)$' ++ echo pxc-client-59944c5bbf-fdpl8 + local container= + set +o xtrace pod/pxc-client-59944c5bbf-fdpl8 condition met waiting for pod/pxc-client-59944c5bbf-fdpl8 to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + [[ ! -s /tmp/tmp.j2wBW4HTkS/select-1.sql ]] ++ grep 'Unknown MySQL server host' /tmp/tmp.j2wBW4HTkS/select-1.sql + [[ -n '' ]] + [[ 0 -eq 0 ]] + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/compare/select-1.sql /tmp/tmp.j2wBW4HTkS/select-1.sql + compare_mysql_cmd select-1 'SELECT * from myApp.myApp;' '-h proxy-switch-pxc-1.proxy-switch-pxc -uroot -proot_password' + local command_id=select-1 + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-pxc-1.proxy-switch-pxc -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/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-2290/e2e-tests/proxy-switch/compare/select-1-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SELECT * from myApp.myApp;' '-h proxy-switch-pxc-1.proxy-switch-pxc -uroot -proot_password' + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-pxc-1.proxy-switch-pxc -uroot -proot_password' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.1pHBxn9DS9 +++ mktemp ++ local LAST_ERR=/tmp/tmp.S72KOOAUSz ++ 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.1pHBxn9DS9 ++ cat /tmp/tmp.S72KOOAUSz ++ rm /tmp/tmp.1pHBxn9DS9 /tmp/tmp.S72KOOAUSz ++ return 0 + client_pod=pxc-client-59944c5bbf-fdpl8 + wait_pod pxc-client-59944c5bbf-fdpl8 + local pod=pxc-client-59944c5bbf-fdpl8 + local max_retry=480 + local ns= ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ grep -E '^(pxc|proxysql)$' ++ echo pxc-client-59944c5bbf-fdpl8 + local container= + set +o xtrace pod/pxc-client-59944c5bbf-fdpl8 condition met waiting for pod/pxc-client-59944c5bbf-fdpl8 to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + [[ ! -s /tmp/tmp.j2wBW4HTkS/select-1.sql ]] ++ grep 'Unknown MySQL server host' /tmp/tmp.j2wBW4HTkS/select-1.sql + [[ -n '' ]] + [[ 0 -eq 0 ]] + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/compare/select-1.sql /tmp/tmp.j2wBW4HTkS/select-1.sql + compare_mysql_cmd select-1 'SELECT * from myApp.myApp;' '-h proxy-switch-pxc-2.proxy-switch-pxc -uroot -proot_password' + local command_id=select-1 + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-pxc-2.proxy-switch-pxc -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/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-2290/e2e-tests/proxy-switch/compare/select-1-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SELECT * from myApp.myApp;' '-h proxy-switch-pxc-2.proxy-switch-pxc -uroot -proot_password' + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-pxc-2.proxy-switch-pxc -uroot -proot_password' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.XkBGmXiqVT +++ mktemp ++ local LAST_ERR=/tmp/tmp.NJIGdNqeXk ++ 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.XkBGmXiqVT ++ cat /tmp/tmp.NJIGdNqeXk ++ rm /tmp/tmp.XkBGmXiqVT /tmp/tmp.NJIGdNqeXk ++ return 0 + client_pod=pxc-client-59944c5bbf-fdpl8 + wait_pod pxc-client-59944c5bbf-fdpl8 + local pod=pxc-client-59944c5bbf-fdpl8 + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-fdpl8 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ grep -E '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-fdpl8 condition met waiting for pod/pxc-client-59944c5bbf-fdpl8 to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + [[ ! -s /tmp/tmp.j2wBW4HTkS/select-1.sql ]] ++ grep 'Unknown MySQL server host' /tmp/tmp.j2wBW4HTkS/select-1.sql + [[ -n '' ]] + [[ 0 -eq 0 ]] + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/compare/select-1.sql /tmp/tmp.j2wBW4HTkS/select-1.sql + desc 'switch from HAProxy to ProxySQL' + set +o xtrace ----------------------------------------------------------------------------------- switch from HAProxy to ProxySQL ----------------------------------------------------------------------------------- + kubectl_bin patch pxc proxy-switch --type=json -p '[ {"op": "replace", "path": "/spec/haproxy/enabled", "value": false}, {"op": "replace", "path": "/spec/proxysql/enabled", "value": true} ]' ++ mktemp + local LAST_OUT=/tmp/tmp.GzmTEF1qxH ++ mktemp + local LAST_ERR=/tmp/tmp.Qh0fZZqUbW + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl patch pxc proxy-switch --type=json -p '[ {"op": "replace", "path": "/spec/haproxy/enabled", "value": false}, {"op": "replace", "path": "/spec/proxysql/enabled", "value": true} ]' + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.GzmTEF1qxH perconaxtradbcluster.pxc.percona.com/proxy-switch patched + cat /tmp/tmp.Qh0fZZqUbW + rm /tmp/tmp.GzmTEF1qxH /tmp/tmp.Qh0fZZqUbW + return 0 + desc 'wait for ProxySQL to be ready and HAProxy to be removed' + set +o xtrace ----------------------------------------------------------------------------------- wait for ProxySQL to be ready and HAProxy to be removed ----------------------------------------------------------------------------------- + wait_for_delete sts/proxy-switch-haproxy + local res=sts/proxy-switch-haproxy + echo -n 'waiting for sts/proxy-switch-haproxy to be deleted' waiting for sts/proxy-switch-haproxy to be deleted+ set +o xtrace Error from server (NotFound): statefulsets.apps "proxy-switch-haproxy" not found + wait_for_running proxy-switch-proxysql 3 + local name=proxy-switch-proxysql + 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 proxy-switch-proxysql-0 480 + local pod=proxy-switch-proxysql-0 + local max_retry=480 + local ns= ++ grep -E '^(pxc|proxysql)$' ++ echo proxy-switch-proxysql-0 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container=proxysql + set +o xtrace pod/proxy-switch-proxysql-0 condition met waiting for pod/proxy-switch-proxysql-0 to become Ready.Ok + for i in '$(seq 0 $last_pod)' + wait_pod proxy-switch-proxysql-1 480 + local pod=proxy-switch-proxysql-1 + local max_retry=480 + local ns= ++ echo proxy-switch-proxysql-1 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ grep -E '^(pxc|proxysql)$' + local container=proxysql + set +o xtrace pod/proxy-switch-proxysql-1 condition met waiting for pod/proxy-switch-proxysql-1 to become Ready.Ok + for i in '$(seq 0 $last_pod)' + wait_pod proxy-switch-proxysql-2 480 + local pod=proxy-switch-proxysql-2 + local max_retry=480 + local ns= ++ echo proxy-switch-proxysql-2 ++ grep -E '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container=proxysql + set +o xtrace pod/proxy-switch-proxysql-2 condition met waiting for pod/proxy-switch-proxysql-2 to become Ready.Ok + wait_cluster_consistency proxy-switch 3 3 + local cluster_name=proxy-switch + 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/proxy-switch to be ready' waiting for pxc/proxy-switch to be ready++ kubectl_bin get pxc proxy-switch -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.XA6tCbM6vx +++ mktemp ++ local LAST_ERR=/tmp/tmp.kZrGwqIrBH ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc proxy-switch -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.XA6tCbM6vx ++ cat /tmp/tmp.kZrGwqIrBH ++ rm /tmp/tmp.XA6tCbM6vx /tmp/tmp.kZrGwqIrBH ++ return 0 + [[ ready == \r\e\a\d\y ]] ++ kubectl_bin get pxc proxy-switch -o 'jsonpath={.status.pxc.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.BNkMZS7zEn +++ mktemp ++ local LAST_ERR=/tmp/tmp.l3WC03UQN8 ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc proxy-switch -o 'jsonpath={.status.pxc.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.BNkMZS7zEn ++ cat /tmp/tmp.l3WC03UQN8 ++ rm /tmp/tmp.BNkMZS7zEn /tmp/tmp.l3WC03UQN8 ++ return 0 + [[ 3 == \3 ]] +++ get_proxy_engine proxy-switch +++ local cluster_name=proxy-switch ++++ get_proxy proxy-switch ++++ local target_cluster=proxy-switch +++++ kubectl_bin get pxc proxy-switch -o 'jsonpath={.spec.haproxy.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.FxedekJgYl ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.H2WQoSmTTn +++++ local exit_status=0 ++++++ seq 0 2 +++++ for i in '$(seq 0 2)' +++++ set +e +++++ kubectl get pxc proxy-switch -o 'jsonpath={.spec.haproxy.enabled}' +++++ exit_status=0 +++++ set -e +++++ '[' 0 '!=' 0 ']' +++++ break +++++ cat /tmp/tmp.FxedekJgYl +++++ cat /tmp/tmp.H2WQoSmTTn +++++ rm /tmp/tmp.FxedekJgYl /tmp/tmp.H2WQoSmTTn +++++ return 0 ++++ [[ false == \t\r\u\e ]] +++++ kubectl_bin get pxc proxy-switch -o 'jsonpath={.spec.proxysql.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.dtzCHfvPzz ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.ETfqIs3DlP +++++ local exit_status=0 ++++++ seq 0 2 +++++ for i in '$(seq 0 2)' +++++ set +e +++++ kubectl get pxc proxy-switch -o 'jsonpath={.spec.proxysql.enabled}' +++++ exit_status=0 +++++ set -e +++++ '[' 0 '!=' 0 ']' +++++ break +++++ cat /tmp/tmp.dtzCHfvPzz +++++ cat /tmp/tmp.ETfqIs3DlP +++++ rm /tmp/tmp.dtzCHfvPzz /tmp/tmp.ETfqIs3DlP +++++ return 0 ++++ [[ true == \t\r\u\e ]] ++++ echo proxy-switch-proxysql ++++ return +++ local cluster_proxy=proxy-switch-proxysql +++ echo proxysql ++ kubectl_bin get pxc proxy-switch -o 'jsonpath={.status.proxysql.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.jimDTp7uyK +++ mktemp ++ local LAST_ERR=/tmp/tmp.FWlYVV54p2 ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc proxy-switch -o 'jsonpath={.status.proxysql.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.jimDTp7uyK ++ cat /tmp/tmp.FWlYVV54p2 ++ rm /tmp/tmp.jimDTp7uyK /tmp/tmp.FWlYVV54p2 ++ return 0 + [[ 3 == \3 ]] + echo + desc 'verify HAProxy pods are deleted' + set +o xtrace ----------------------------------------------------------------------------------- verify HAProxy pods are deleted ----------------------------------------------------------------------------------- + kubectl_bin get pods -l app.kubernetes.io/name=percona-xtradb-cluster,app.kubernetes.io/instance=proxy-switch,app.kubernetes.io/component=haproxy + grep -q haproxy + desc 'verify ProxySQL service exists' + set +o xtrace ----------------------------------------------------------------------------------- verify ProxySQL service exists ----------------------------------------------------------------------------------- + kubectl_bin get service proxy-switch-proxysql ++ mktemp + local LAST_OUT=/tmp/tmp.avwidOM9It ++ mktemp + local LAST_ERR=/tmp/tmp.wRpVFXTsAE + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl get service proxy-switch-proxysql + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.avwidOM9It NAME TYPE CLUSTER-IP EXTERNAL-IP PORT(S) AGE proxy-switch-proxysql ClusterIP 34.118.231.191 3306/TCP,33062/TCP,6070/TCP 63s + cat /tmp/tmp.wRpVFXTsAE + rm /tmp/tmp.avwidOM9It /tmp/tmp.wRpVFXTsAE + return 0 + desc 'check connectivity through ProxySQL after switch' + set +o xtrace ----------------------------------------------------------------------------------- check connectivity through ProxySQL after switch ----------------------------------------------------------------------------------- + sleep 20 + compare_mysql_cmd select-1 'SELECT * from myApp.myApp;' '-h proxy-switch-proxysql -uroot -proot_password' + local command_id=select-1 + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-proxysql -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/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-2290/e2e-tests/proxy-switch/compare/select-1-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SELECT * from myApp.myApp;' '-h proxy-switch-proxysql -uroot -proot_password' + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-proxysql -uroot -proot_password' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.7BIzkh2Nl8 +++ mktemp ++ local LAST_ERR=/tmp/tmp.YozsvgZnqA ++ 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.7BIzkh2Nl8 ++ cat /tmp/tmp.YozsvgZnqA ++ rm /tmp/tmp.7BIzkh2Nl8 /tmp/tmp.YozsvgZnqA ++ return 0 + client_pod=pxc-client-59944c5bbf-fdpl8 + wait_pod pxc-client-59944c5bbf-fdpl8 + local pod=pxc-client-59944c5bbf-fdpl8 + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-fdpl8 ++ grep -E '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-fdpl8 condition met waiting for pod/pxc-client-59944c5bbf-fdpl8 to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + [[ ! -s /tmp/tmp.j2wBW4HTkS/select-1.sql ]] ++ grep 'Unknown MySQL server host' /tmp/tmp.j2wBW4HTkS/select-1.sql + [[ -n '' ]] + [[ 0 -eq 0 ]] + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/compare/select-1.sql /tmp/tmp.j2wBW4HTkS/select-1.sql + desc 'write new data through ProxySQL' + set +o xtrace ----------------------------------------------------------------------------------- write new data through ProxySQL ----------------------------------------------------------------------------------- + run_mysql 'INSERT myApp.myApp (id) VALUES (100501)' '-h proxy-switch-proxysql -uroot -proot_password' + local 'command=INSERT myApp.myApp (id) VALUES (100501)' + local 'uri=-h proxy-switch-proxysql -uroot -proot_password' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.eIordTQJcD +++ mktemp ++ local LAST_ERR=/tmp/tmp.rhglVNTTAO ++ 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.eIordTQJcD ++ cat /tmp/tmp.rhglVNTTAO ++ rm /tmp/tmp.eIordTQJcD /tmp/tmp.rhglVNTTAO ++ return 0 + client_pod=pxc-client-59944c5bbf-fdpl8 + wait_pod pxc-client-59944c5bbf-fdpl8 + local pod=pxc-client-59944c5bbf-fdpl8 + local max_retry=480 + local ns= ++ grep -E '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ echo pxc-client-59944c5bbf-fdpl8 + local container= + set +o xtrace pod/pxc-client-59944c5bbf-fdpl8 condition met waiting for pod/pxc-client-59944c5bbf-fdpl8 to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + sleep 10 + compare_mysql_cmd select-2 'SELECT * from myApp.myApp;' '-h proxy-switch-proxysql -uroot -proot_password' + local command_id=select-2 + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-proxysql -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/compare/select-2.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-2290/e2e-tests/proxy-switch/compare/select-2-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SELECT * from myApp.myApp;' '-h proxy-switch-proxysql -uroot -proot_password' + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-proxysql -uroot -proot_password' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.YJJN9vJsVB +++ mktemp ++ local LAST_ERR=/tmp/tmp.UjHL6jhlgw ++ 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.YJJN9vJsVB ++ cat /tmp/tmp.UjHL6jhlgw ++ rm /tmp/tmp.YJJN9vJsVB /tmp/tmp.UjHL6jhlgw ++ return 0 + client_pod=pxc-client-59944c5bbf-fdpl8 + wait_pod pxc-client-59944c5bbf-fdpl8 + local pod=pxc-client-59944c5bbf-fdpl8 + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-fdpl8 ++ grep -E '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-fdpl8 condition met waiting for pod/pxc-client-59944c5bbf-fdpl8 to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + [[ ! -s /tmp/tmp.j2wBW4HTkS/select-2.sql ]] ++ grep 'Unknown MySQL server host' /tmp/tmp.j2wBW4HTkS/select-2.sql + [[ -n '' ]] + [[ 0 -eq 0 ]] + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/compare/select-2.sql /tmp/tmp.j2wBW4HTkS/select-2.sql + desc 'verify new data exists on all PXC nodes' + set +o xtrace ----------------------------------------------------------------------------------- verify new data exists on all PXC nodes ----------------------------------------------------------------------------------- + compare_mysql_cmd select-2 'SELECT * from myApp.myApp;' '-h proxy-switch-pxc-0.proxy-switch-pxc -uroot -proot_password' + local command_id=select-2 + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-pxc-0.proxy-switch-pxc -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/compare/select-2.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-2290/e2e-tests/proxy-switch/compare/select-2-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SELECT * from myApp.myApp;' '-h proxy-switch-pxc-0.proxy-switch-pxc -uroot -proot_password' + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-pxc-0.proxy-switch-pxc -uroot -proot_password' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.J0ZkDHdN3X +++ mktemp ++ local LAST_ERR=/tmp/tmp.b7IFRetlO1 ++ 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.J0ZkDHdN3X ++ cat /tmp/tmp.b7IFRetlO1 ++ rm /tmp/tmp.J0ZkDHdN3X /tmp/tmp.b7IFRetlO1 ++ return 0 + client_pod=pxc-client-59944c5bbf-fdpl8 + wait_pod pxc-client-59944c5bbf-fdpl8 + local pod=pxc-client-59944c5bbf-fdpl8 + local max_retry=480 + local ns= ++ grep -E '^(pxc|proxysql)$' ++ echo pxc-client-59944c5bbf-fdpl8 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-fdpl8 condition met waiting for pod/pxc-client-59944c5bbf-fdpl8 to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + [[ ! -s /tmp/tmp.j2wBW4HTkS/select-2.sql ]] ++ grep 'Unknown MySQL server host' /tmp/tmp.j2wBW4HTkS/select-2.sql + [[ -n '' ]] + [[ 0 -eq 0 ]] + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/compare/select-2.sql /tmp/tmp.j2wBW4HTkS/select-2.sql + compare_mysql_cmd select-2 'SELECT * from myApp.myApp;' '-h proxy-switch-pxc-1.proxy-switch-pxc -uroot -proot_password' + local command_id=select-2 + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-pxc-1.proxy-switch-pxc -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/compare/select-2.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-2290/e2e-tests/proxy-switch/compare/select-2-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SELECT * from myApp.myApp;' '-h proxy-switch-pxc-1.proxy-switch-pxc -uroot -proot_password' + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-pxc-1.proxy-switch-pxc -uroot -proot_password' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.lOz8Yd6fvz +++ mktemp ++ local LAST_ERR=/tmp/tmp.1j5FQMFQWy ++ 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.lOz8Yd6fvz ++ cat /tmp/tmp.1j5FQMFQWy ++ rm /tmp/tmp.lOz8Yd6fvz /tmp/tmp.1j5FQMFQWy ++ return 0 + client_pod=pxc-client-59944c5bbf-fdpl8 + wait_pod pxc-client-59944c5bbf-fdpl8 + local pod=pxc-client-59944c5bbf-fdpl8 + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-fdpl8 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ grep -E '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-fdpl8 condition met waiting for pod/pxc-client-59944c5bbf-fdpl8 to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + [[ ! -s /tmp/tmp.j2wBW4HTkS/select-2.sql ]] ++ grep 'Unknown MySQL server host' /tmp/tmp.j2wBW4HTkS/select-2.sql + [[ -n '' ]] + [[ 0 -eq 0 ]] + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/compare/select-2.sql /tmp/tmp.j2wBW4HTkS/select-2.sql + compare_mysql_cmd select-2 'SELECT * from myApp.myApp;' '-h proxy-switch-pxc-2.proxy-switch-pxc -uroot -proot_password' + local command_id=select-2 + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-pxc-2.proxy-switch-pxc -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/compare/select-2.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-2290/e2e-tests/proxy-switch/compare/select-2-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SELECT * from myApp.myApp;' '-h proxy-switch-pxc-2.proxy-switch-pxc -uroot -proot_password' + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-pxc-2.proxy-switch-pxc -uroot -proot_password' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.3iCWe2oc8o +++ mktemp ++ local LAST_ERR=/tmp/tmp.n1getmCoYh ++ 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.3iCWe2oc8o ++ cat /tmp/tmp.n1getmCoYh ++ rm /tmp/tmp.3iCWe2oc8o /tmp/tmp.n1getmCoYh ++ return 0 + client_pod=pxc-client-59944c5bbf-fdpl8 + wait_pod pxc-client-59944c5bbf-fdpl8 + local pod=pxc-client-59944c5bbf-fdpl8 + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-fdpl8 ++ grep -E '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-fdpl8 condition met waiting for pod/pxc-client-59944c5bbf-fdpl8 to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + [[ ! -s /tmp/tmp.j2wBW4HTkS/select-2.sql ]] ++ grep 'Unknown MySQL server host' /tmp/tmp.j2wBW4HTkS/select-2.sql + [[ -n '' ]] + [[ 0 -eq 0 ]] + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/compare/select-2.sql /tmp/tmp.j2wBW4HTkS/select-2.sql + desc 'verify ProxySQL is routing to primary' + set +o xtrace ----------------------------------------------------------------------------------- verify ProxySQL is routing to primary ----------------------------------------------------------------------------------- ++ get_proxy_primary '-h127.0.0.1 -P6032 -uproxyadmin -padmin_password' proxy-switch-proxysql-0 ++ local 'uri=-h127.0.0.1 -P6032 -uproxyadmin -padmin_password' ++ local pod=proxy-switch-proxysql-0 +++ run_mysql_local 'SELECT hostname FROM runtime_mysql_servers WHERE hostgroup_id=11 AND status='\''ONLINE'\'';' '-h127.0.0.1 -P6032 -uproxyadmin -padmin_password' proxy-switch-proxysql-0 proxysql +++ local 'command=SELECT hostname FROM runtime_mysql_servers WHERE hostgroup_id=11 AND status='\''ONLINE'\'';' +++ local 'uri=-h127.0.0.1 -P6032 -uproxyadmin -padmin_password' +++ local pod=proxy-switch-proxysql-0 +++ local container_name=proxysql +++ set +o xtrace ++ local ip=proxy-switch-pxc-0.proxy-switch-pxc.proxy-switch-32018.svc.cluster.local +++ echo proxy-switch-pxc-0.proxy-switch-pxc.proxy-switch-32018.svc.cluster.local +++ wc -l ++ '[' 1 '!=' 1 ']' ++ cut -d. -f1 ++ echo proxy-switch-pxc-0.proxy-switch-pxc.proxy-switch-32018.svc.cluster.local + initial_primary=proxy-switch-pxc-0 + '[' -z proxy-switch-pxc-0 ']' + echo 'ProxySQL is routing to primary: proxy-switch-pxc-0' ProxySQL is routing to primary: proxy-switch-pxc-0 + desc 'switch back to HAProxy from ProxySQL' + set +o xtrace ----------------------------------------------------------------------------------- switch back to HAProxy from ProxySQL ----------------------------------------------------------------------------------- + kubectl_bin patch pxc proxy-switch --type=json -p '[ {"op": "replace", "path": "/spec/haproxy/enabled", "value": true}, {"op": "replace", "path": "/spec/proxysql/enabled", "value": false} ]' ++ mktemp + local LAST_OUT=/tmp/tmp.tEwMd5xusm ++ mktemp + local LAST_ERR=/tmp/tmp.dXGWFWrigV + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl patch pxc proxy-switch --type=json -p '[ {"op": "replace", "path": "/spec/haproxy/enabled", "value": true}, {"op": "replace", "path": "/spec/proxysql/enabled", "value": false} ]' + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.tEwMd5xusm perconaxtradbcluster.pxc.percona.com/proxy-switch patched + cat /tmp/tmp.dXGWFWrigV + rm /tmp/tmp.tEwMd5xusm /tmp/tmp.dXGWFWrigV + return 0 + desc 'wait for HAProxy to be ready and ProxySQL to be removed' + set +o xtrace ----------------------------------------------------------------------------------- wait for HAProxy to be ready and ProxySQL to be removed ----------------------------------------------------------------------------------- + wait_for_delete sts/proxy-switch-proxysql + local res=sts/proxy-switch-proxysql + echo -n 'waiting for sts/proxy-switch-proxysql to be deleted' waiting for sts/proxy-switch-proxysql to be deleted+ set +o xtrace Error from server (NotFound): statefulsets.apps "proxy-switch-proxysql" not found + wait_for_running proxy-switch-haproxy 3 + local name=proxy-switch-haproxy + 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 proxy-switch-haproxy-0 480 + local pod=proxy-switch-haproxy-0 + local max_retry=480 + local ns= ++ echo proxy-switch-haproxy-0 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ grep -E '^(pxc|proxysql)$' + local container= + set +o xtrace pod/proxy-switch-haproxy-0 condition met waiting for pod/proxy-switch-haproxy-0 to become Ready.Ok + for i in '$(seq 0 $last_pod)' + wait_pod proxy-switch-haproxy-1 480 + local pod=proxy-switch-haproxy-1 + local max_retry=480 + local ns= ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ echo proxy-switch-haproxy-1 ++ grep -E '^(pxc|proxysql)$' + local container= + set +o xtrace pod/proxy-switch-haproxy-1 condition met waiting for pod/proxy-switch-haproxy-1 to become Ready.Ok + for i in '$(seq 0 $last_pod)' + wait_pod proxy-switch-haproxy-2 480 + local pod=proxy-switch-haproxy-2 + local max_retry=480 + local ns= ++ echo proxy-switch-haproxy-2 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ grep -E '^(pxc|proxysql)$' + local container= + set +o xtrace pod/proxy-switch-haproxy-2 condition met waiting for pod/proxy-switch-haproxy-2 to become Ready.Ok + wait_cluster_consistency proxy-switch 3 3 + local cluster_name=proxy-switch + 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/proxy-switch to be ready' waiting for pxc/proxy-switch to be ready++ kubectl_bin get pxc proxy-switch -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.HPc9mepUKP +++ mktemp ++ local LAST_ERR=/tmp/tmp.nmxWIbCWGx ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc proxy-switch -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.HPc9mepUKP ++ cat /tmp/tmp.nmxWIbCWGx ++ rm /tmp/tmp.HPc9mepUKP /tmp/tmp.nmxWIbCWGx ++ return 0 + [[ ready == \r\e\a\d\y ]] ++ kubectl_bin get pxc proxy-switch -o 'jsonpath={.status.pxc.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.72rGycPpa2 +++ mktemp ++ local LAST_ERR=/tmp/tmp.yYf6cjFaoh ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc proxy-switch -o 'jsonpath={.status.pxc.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.72rGycPpa2 ++ cat /tmp/tmp.yYf6cjFaoh ++ rm /tmp/tmp.72rGycPpa2 /tmp/tmp.yYf6cjFaoh ++ return 0 + [[ 3 == \3 ]] +++ get_proxy_engine proxy-switch +++ local cluster_name=proxy-switch ++++ get_proxy proxy-switch ++++ local target_cluster=proxy-switch +++++ kubectl_bin get pxc proxy-switch -o 'jsonpath={.spec.haproxy.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.lYBFA8hoAb ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.pmBTWrw4bv +++++ local exit_status=0 ++++++ seq 0 2 +++++ for i in '$(seq 0 2)' +++++ set +e +++++ kubectl get pxc proxy-switch -o 'jsonpath={.spec.haproxy.enabled}' +++++ exit_status=0 +++++ set -e +++++ '[' 0 '!=' 0 ']' +++++ break +++++ cat /tmp/tmp.lYBFA8hoAb +++++ cat /tmp/tmp.pmBTWrw4bv +++++ rm /tmp/tmp.lYBFA8hoAb /tmp/tmp.pmBTWrw4bv +++++ return 0 ++++ [[ true == \t\r\u\e ]] ++++ echo proxy-switch-haproxy ++++ return +++ local cluster_proxy=proxy-switch-haproxy +++ echo haproxy ++ kubectl_bin get pxc proxy-switch -o 'jsonpath={.status.haproxy.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.LmtnjkZcdq +++ mktemp ++ local LAST_ERR=/tmp/tmp.gPZbw8hLTm ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc proxy-switch -o 'jsonpath={.status.haproxy.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.LmtnjkZcdq ++ cat /tmp/tmp.gPZbw8hLTm ++ rm /tmp/tmp.LmtnjkZcdq /tmp/tmp.gPZbw8hLTm ++ return 0 + [[ 3 == \3 ]] + echo + desc 'verify ProxySQL pods are deleted' + set +o xtrace ----------------------------------------------------------------------------------- verify ProxySQL pods are deleted ----------------------------------------------------------------------------------- + grep -q proxysql + kubectl_bin get pods -l app.kubernetes.io/name=percona-xtradb-cluster,app.kubernetes.io/instance=proxy-switch,app.kubernetes.io/component=proxysql + desc 'check cluster is ready with HAProxy' + set +o xtrace ----------------------------------------------------------------------------------- check cluster is ready with HAProxy ----------------------------------------------------------------------------------- + wait_for_running proxy-switch-pxc 3 + local name=proxy-switch-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 proxy-switch-pxc-0 480 + local pod=proxy-switch-pxc-0 + local max_retry=480 + local ns= ++ grep -E '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ echo proxy-switch-pxc-0 + local container=pxc + set +o xtrace pod/proxy-switch-pxc-0 condition met waiting for pod/proxy-switch-pxc-0 to become Ready.Ok + for i in '$(seq 0 $last_pod)' + wait_pod proxy-switch-pxc-1 480 + local pod=proxy-switch-pxc-1 + local max_retry=480 + local ns= ++ grep -E '^(pxc|proxysql)$' ++ echo proxy-switch-pxc-1 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container=pxc + set +o xtrace pod/proxy-switch-pxc-1 condition met waiting for pod/proxy-switch-pxc-1 to become Ready.Ok + for i in '$(seq 0 $last_pod)' + wait_pod proxy-switch-pxc-2 480 + local pod=proxy-switch-pxc-2 + local max_retry=480 + local ns= ++ grep -E '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ echo proxy-switch-pxc-2 + local container=pxc + set +o xtrace pod/proxy-switch-pxc-2 condition met waiting for pod/proxy-switch-pxc-2 to become Ready.Ok + wait_for_running proxy-switch-haproxy 3 + local name=proxy-switch-haproxy + 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 proxy-switch-haproxy-0 480 + local pod=proxy-switch-haproxy-0 + local max_retry=480 + local ns= ++ echo proxy-switch-haproxy-0 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ grep -E '^(pxc|proxysql)$' + local container= + set +o xtrace pod/proxy-switch-haproxy-0 condition met waiting for pod/proxy-switch-haproxy-0 to become Ready.Ok + for i in '$(seq 0 $last_pod)' + wait_pod proxy-switch-haproxy-1 480 + local pod=proxy-switch-haproxy-1 + local max_retry=480 + local ns= ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ echo proxy-switch-haproxy-1 ++ grep -E '^(pxc|proxysql)$' + local container= + set +o xtrace pod/proxy-switch-haproxy-1 condition met waiting for pod/proxy-switch-haproxy-1 to become Ready.Ok + for i in '$(seq 0 $last_pod)' + wait_pod proxy-switch-haproxy-2 480 + local pod=proxy-switch-haproxy-2 + local max_retry=480 + local ns= ++ echo proxy-switch-haproxy-2 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ grep -E '^(pxc|proxysql)$' + local container= + set +o xtrace pod/proxy-switch-haproxy-2 condition met waiting for pod/proxy-switch-haproxy-2 to become Ready.Ok + wait_cluster_consistency proxy-switch 3 3 + local cluster_name=proxy-switch + 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/proxy-switch to be ready' waiting for pxc/proxy-switch to be ready++ kubectl_bin get pxc proxy-switch -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.0G3L3JZSAa +++ mktemp ++ local LAST_ERR=/tmp/tmp.7PgImLFEvY ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc proxy-switch -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.0G3L3JZSAa ++ cat /tmp/tmp.7PgImLFEvY ++ rm /tmp/tmp.0G3L3JZSAa /tmp/tmp.7PgImLFEvY ++ return 0 + [[ ready == \r\e\a\d\y ]] ++ kubectl_bin get pxc proxy-switch -o 'jsonpath={.status.pxc.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.f7T8Hf3rLd +++ mktemp ++ local LAST_ERR=/tmp/tmp.petSWJJb4y ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc proxy-switch -o 'jsonpath={.status.pxc.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.f7T8Hf3rLd ++ cat /tmp/tmp.petSWJJb4y ++ rm /tmp/tmp.f7T8Hf3rLd /tmp/tmp.petSWJJb4y ++ return 0 + [[ 3 == \3 ]] +++ get_proxy_engine proxy-switch +++ local cluster_name=proxy-switch ++++ get_proxy proxy-switch ++++ local target_cluster=proxy-switch +++++ kubectl_bin get pxc proxy-switch -o 'jsonpath={.spec.haproxy.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.Wj8FpxNHgp ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.Kud40b3O9e +++++ local exit_status=0 ++++++ seq 0 2 +++++ for i in '$(seq 0 2)' +++++ set +e +++++ kubectl get pxc proxy-switch -o 'jsonpath={.spec.haproxy.enabled}' +++++ exit_status=0 +++++ set -e +++++ '[' 0 '!=' 0 ']' +++++ break +++++ cat /tmp/tmp.Wj8FpxNHgp +++++ cat /tmp/tmp.Kud40b3O9e +++++ rm /tmp/tmp.Wj8FpxNHgp /tmp/tmp.Kud40b3O9e +++++ return 0 ++++ [[ true == \t\r\u\e ]] ++++ echo proxy-switch-haproxy ++++ return +++ local cluster_proxy=proxy-switch-haproxy +++ echo haproxy ++ kubectl_bin get pxc proxy-switch -o 'jsonpath={.status.haproxy.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.UxIjwWwvIQ +++ mktemp ++ local LAST_ERR=/tmp/tmp.E3j7lKw454 ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc proxy-switch -o 'jsonpath={.status.haproxy.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.UxIjwWwvIQ ++ cat /tmp/tmp.E3j7lKw454 ++ rm /tmp/tmp.UxIjwWwvIQ /tmp/tmp.E3j7lKw454 ++ return 0 + [[ 3 == \3 ]] + echo + desc 'verify HAProxy service exists' + set +o xtrace ----------------------------------------------------------------------------------- verify HAProxy service exists ----------------------------------------------------------------------------------- + kubectl_bin get service proxy-switch-haproxy ++ mktemp + local LAST_OUT=/tmp/tmp.vBSh9EogQx ++ mktemp + local LAST_ERR=/tmp/tmp.kMfZlE6BFH + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl get service proxy-switch-haproxy + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.vBSh9EogQx NAME TYPE CLUSTER-IP EXTERNAL-IP PORT(S) AGE proxy-switch-haproxy ClusterIP 34.118.232.135 3306/TCP,3309/TCP,33062/TCP,33060/TCP,8404/TCP 2m16s + cat /tmp/tmp.kMfZlE6BFH + rm /tmp/tmp.vBSh9EogQx /tmp/tmp.kMfZlE6BFH + return 0 + desc 'write data and check connectivity through HAProxy' + set +o xtrace ----------------------------------------------------------------------------------- write data and check connectivity through HAProxy ----------------------------------------------------------------------------------- + run_mysql 'CREATE DATABASE IF NOT EXISTS myApp; use myApp; CREATE TABLE IF NOT EXISTS myApp (id int PRIMARY KEY);' '-h proxy-switch-haproxy -uroot -proot_password' + local 'command=CREATE DATABASE IF NOT EXISTS myApp; use myApp; CREATE TABLE IF NOT EXISTS myApp (id int PRIMARY KEY);' + local 'uri=-h proxy-switch-haproxy -uroot -proot_password' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.hEwhsPsdxa +++ mktemp ++ local LAST_ERR=/tmp/tmp.PIWFJ7NA6I ++ 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.hEwhsPsdxa ++ cat /tmp/tmp.PIWFJ7NA6I ++ rm /tmp/tmp.hEwhsPsdxa /tmp/tmp.PIWFJ7NA6I ++ return 0 + client_pod=pxc-client-59944c5bbf-fdpl8 + wait_pod pxc-client-59944c5bbf-fdpl8 + local pod=pxc-client-59944c5bbf-fdpl8 + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-fdpl8 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ grep -E '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-fdpl8 condition met waiting for pod/pxc-client-59944c5bbf-fdpl8 to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + run_mysql 'INSERT myApp.myApp (id) VALUES (100502)' '-h proxy-switch-haproxy -uroot -proot_password' + local 'command=INSERT myApp.myApp (id) VALUES (100502)' + local 'uri=-h proxy-switch-haproxy -uroot -proot_password' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.yiKojDRWND +++ mktemp ++ local LAST_ERR=/tmp/tmp.lgo8PGdJLY ++ 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.yiKojDRWND ++ cat /tmp/tmp.lgo8PGdJLY ++ rm /tmp/tmp.yiKojDRWND /tmp/tmp.lgo8PGdJLY ++ return 0 + client_pod=pxc-client-59944c5bbf-fdpl8 + wait_pod pxc-client-59944c5bbf-fdpl8 + local pod=pxc-client-59944c5bbf-fdpl8 + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-fdpl8 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ grep -E '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-fdpl8 condition met waiting for pod/pxc-client-59944c5bbf-fdpl8 to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + sleep 10 + compare_mysql_cmd select-3 'SELECT * from myApp.myApp;' '-h proxy-switch-haproxy -uroot -proot_password' + local command_id=select-3 + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-haproxy -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/compare/select-3.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-2290/e2e-tests/proxy-switch/compare/select-3-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SELECT * from myApp.myApp;' '-h proxy-switch-haproxy -uroot -proot_password' + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-haproxy -uroot -proot_password' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.9EFQY80v9k +++ mktemp ++ local LAST_ERR=/tmp/tmp.pzq1M9hfGX ++ 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.9EFQY80v9k ++ cat /tmp/tmp.pzq1M9hfGX ++ rm /tmp/tmp.9EFQY80v9k /tmp/tmp.pzq1M9hfGX ++ return 0 + client_pod=pxc-client-59944c5bbf-fdpl8 + wait_pod pxc-client-59944c5bbf-fdpl8 + local pod=pxc-client-59944c5bbf-fdpl8 + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-fdpl8 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ grep -E '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-fdpl8 condition met waiting for pod/pxc-client-59944c5bbf-fdpl8 to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + [[ ! -s /tmp/tmp.j2wBW4HTkS/select-3.sql ]] ++ grep 'Unknown MySQL server host' /tmp/tmp.j2wBW4HTkS/select-3.sql + [[ -n '' ]] + [[ 0 -eq 0 ]] + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/compare/select-3.sql /tmp/tmp.j2wBW4HTkS/select-3.sql + desc 'verify data exists on all PXC nodes' + set +o xtrace ----------------------------------------------------------------------------------- verify data exists on all PXC nodes ----------------------------------------------------------------------------------- + compare_mysql_cmd select-3 'SELECT * from myApp.myApp;' '-h proxy-switch-pxc-0.proxy-switch-pxc -uroot -proot_password' + local command_id=select-3 + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-pxc-0.proxy-switch-pxc -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/compare/select-3.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-2290/e2e-tests/proxy-switch/compare/select-3-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SELECT * from myApp.myApp;' '-h proxy-switch-pxc-0.proxy-switch-pxc -uroot -proot_password' + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-pxc-0.proxy-switch-pxc -uroot -proot_password' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.WbhXd6Yp6Y +++ mktemp ++ local LAST_ERR=/tmp/tmp.EunKgSKiR4 ++ 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.WbhXd6Yp6Y ++ cat /tmp/tmp.EunKgSKiR4 ++ rm /tmp/tmp.WbhXd6Yp6Y /tmp/tmp.EunKgSKiR4 ++ return 0 + client_pod=pxc-client-59944c5bbf-fdpl8 + wait_pod pxc-client-59944c5bbf-fdpl8 + local pod=pxc-client-59944c5bbf-fdpl8 + local max_retry=480 + local ns= ++ grep -E '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ echo pxc-client-59944c5bbf-fdpl8 + local container= + set +o xtrace pod/pxc-client-59944c5bbf-fdpl8 condition met waiting for pod/pxc-client-59944c5bbf-fdpl8 to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + [[ ! -s /tmp/tmp.j2wBW4HTkS/select-3.sql ]] ++ grep 'Unknown MySQL server host' /tmp/tmp.j2wBW4HTkS/select-3.sql + [[ -n '' ]] + [[ 0 -eq 0 ]] + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/compare/select-3.sql /tmp/tmp.j2wBW4HTkS/select-3.sql + compare_mysql_cmd select-3 'SELECT * from myApp.myApp;' '-h proxy-switch-pxc-1.proxy-switch-pxc -uroot -proot_password' + local command_id=select-3 + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-pxc-1.proxy-switch-pxc -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/compare/select-3.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-2290/e2e-tests/proxy-switch/compare/select-3-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SELECT * from myApp.myApp;' '-h proxy-switch-pxc-1.proxy-switch-pxc -uroot -proot_password' + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-pxc-1.proxy-switch-pxc -uroot -proot_password' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.gQsZhL2fIa +++ mktemp ++ local LAST_ERR=/tmp/tmp.HtR5pBwjXO ++ 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.gQsZhL2fIa ++ cat /tmp/tmp.HtR5pBwjXO ++ rm /tmp/tmp.gQsZhL2fIa /tmp/tmp.HtR5pBwjXO ++ return 0 + client_pod=pxc-client-59944c5bbf-fdpl8 + wait_pod pxc-client-59944c5bbf-fdpl8 + local pod=pxc-client-59944c5bbf-fdpl8 + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-fdpl8 ++ grep -E '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-fdpl8 condition met waiting for pod/pxc-client-59944c5bbf-fdpl8 to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + [[ ! -s /tmp/tmp.j2wBW4HTkS/select-3.sql ]] ++ grep 'Unknown MySQL server host' /tmp/tmp.j2wBW4HTkS/select-3.sql + [[ -n '' ]] + [[ 0 -eq 0 ]] + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/compare/select-3.sql /tmp/tmp.j2wBW4HTkS/select-3.sql + compare_mysql_cmd select-3 'SELECT * from myApp.myApp;' '-h proxy-switch-pxc-2.proxy-switch-pxc -uroot -proot_password' + local command_id=select-3 + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-pxc-2.proxy-switch-pxc -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/compare/select-3.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-2290/e2e-tests/proxy-switch/compare/select-3-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SELECT * from myApp.myApp;' '-h proxy-switch-pxc-2.proxy-switch-pxc -uroot -proot_password' + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h proxy-switch-pxc-2.proxy-switch-pxc -uroot -proot_password' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.voDOpf5zNw +++ mktemp ++ local LAST_ERR=/tmp/tmp.T3p4DEMT3q ++ 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.voDOpf5zNw ++ cat /tmp/tmp.T3p4DEMT3q ++ rm /tmp/tmp.voDOpf5zNw /tmp/tmp.T3p4DEMT3q ++ return 0 + client_pod=pxc-client-59944c5bbf-fdpl8 + wait_pod pxc-client-59944c5bbf-fdpl8 + local pod=pxc-client-59944c5bbf-fdpl8 + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-fdpl8 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ grep -E '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-fdpl8 condition met waiting for pod/pxc-client-59944c5bbf-fdpl8 to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + [[ ! -s /tmp/tmp.j2wBW4HTkS/select-3.sql ]] ++ grep 'Unknown MySQL server host' /tmp/tmp.j2wBW4HTkS/select-3.sql + [[ -n '' ]] + [[ 0 -eq 0 ]] + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2290/e2e-tests/proxy-switch/compare/select-3.sql /tmp/tmp.j2wBW4HTkS/select-3.sql + desc 'clean up' + set +o xtrace ----------------------------------------------------------------------------------- clean up ----------------------------------------------------------------------------------- + destroy proxy-switch-32018 + local namespace=proxy-switch-32018 + local ignore_logs=true + desc 'destroy cluster/operator and all other resources' + set +o xtrace ----------------------------------------------------------------------------------- destroy cluster/operator and all other resources ----------------------------------------------------------------------------------- + '[' true == false -o 1 == 1 ']' + grep -v level=info + tee /tmp/tmp.j2wBW4HTkS/operator.log + sort -u + /usr/bin/sed -r 's/"ts":[0-9.]+//; s^limits-[0-9.]+/^^g' + grep -v 'the object has been modified' + grep -v 'get backup status: Job.batch' ++ 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.iCbzmfqs8Y +++ mktemp ++ local LAST_ERR=/tmp/tmp.hwPHsnNIbd ++ 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.iCbzmfqs8Y ++ cat /tmp/tmp.hwPHsnNIbd ++ rm /tmp/tmp.iCbzmfqs8Y /tmp/tmp.hwPHsnNIbd ++ return 0 + kubectl_bin logs -n pxc-operator percona-xtradb-cluster-operator-7b6f7d984c-xrnqc ++ mktemp + local LAST_OUT=/tmp/tmp.rYqwFLHiwp ++ mktemp + local LAST_ERR=/tmp/tmp.hoSaB5JCCV + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl logs -n pxc-operator percona-xtradb-cluster-operator-7b6f7d984c-xrnqc + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.rYqwFLHiwp + cat /tmp/tmp.hoSaB5JCCV + rm /tmp/tmp.rYqwFLHiwp /tmp/tmp.hoSaB5JCCV + return 0 2025-12-05T09:56:14.079Z INFO setup Manager starting up {"gitCommit": "9639857870f62bc8fb82fd2b378da1c03deacd15", "gitBranch": "PR-2290-96398578", "buildTime": "2025-12-05T09:17:40Z", "goVersion": "go1.25.5", "os": "linux", "arch": "amd64"} 2025-12-05T09:56:14.079Z INFO setup Runs on {"platform": "kubernetes", "version": "v1.31.14-gke.1033000"} 2025-12-05T09:56:14.082Z INFO setup Registering Components. 2025-12-05T09:56:14.868Z INFO controller-runtime.certwatcher Updated current TLS certificate {"cert": "/tmp/k8s-webhook-server/serving-certs/tls.crt", "key": "/tmp/k8s-webhook-server/serving-certs/tls.key"} 2025-12-05T09:56:14.868Z INFO controller-runtime.metrics Serving metrics server {"bindAddress": ":8080", "secure": false} 2025-12-05T09:56:14.868Z INFO controller-runtime.metrics Starting metrics server 2025-12-05T09:56:14.868Z INFO controller-runtime.webhook Registering webhook {"path": "/validate-percona-xtradbcluster"} 2025-12-05T09:56:14.868Z INFO controller-runtime.webhook Starting webhook server 2025-12-05T09:56:14.868Z INFO setup Starting the Cmd. 2025-12-05T09:56:14.868Z INFO starting server {"name": "health probe", "addr": "[::]:8081"} 2025-12-05T09:56:14.869Z INFO controller-runtime.certwatcher Starting certificate poll+watcher {"cert": "/tmp/k8s-webhook-server/serving-certs/tls.crt", "key": "/tmp/k8s-webhook-server/serving-certs/tls.key", "interval": "10s"} 2025-12-05T09:56:14.869Z INFO controller-runtime.webhook Serving webhook server {"host": "", "port": 9443} 2025-12-05T09:56:14.969Z INFO attempting to acquire leader lease pxc-operator/08db1feb.percona.com... 2025-12-05T09:56:15.000Z DEBUG events percona-xtradb-cluster-operator-7b6f7d984c-xrnqc_c8278cf1-b020-43ff-970d-00a71746b427 became leader {"type": "Normal", "object": {"kind":"Lease","namespace":"pxc-operator","name":"08db1feb.percona.com","uid":"caa0d2a3-5f90-43d9-8fd0-aeb48f454e2c","apiVersion":"coordination.k8s.io/v1","resourceVersion":"1764928574992975009"}, "reason": "LeaderElection"} 2025-12-05T09:56:15.000Z INFO successfully acquired lease pxc-operator/08db1feb.percona.com 2025-12-05T09:56:15.001Z INFO Starting EventSource {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "source": "kind source: *v1.Secret"} 2025-12-05T09:56:15.001Z INFO Starting EventSource {"controller": "pxcrestore-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBClusterRestore", "source": "kind source: *v1.PerconaXtraDBClusterRestore"} 2025-12-05T09:56:15.002Z INFO Starting EventSource {"controller": "pxcbackup-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBClusterBackup", "source": "kind source: *v1.PerconaXtraDBClusterBackup"} 2025-12-05T09:56:15.002Z INFO Starting EventSource {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "source": "kind source: *v1.PerconaXtraDBCluster"} 2025-12-05T09:56:15.102Z INFO Starting Controller {"controller": "pxcbackup-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBClusterBackup"} 2025-12-05T09:56:15.102Z INFO Starting Controller {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster"} 2025-12-05T09:56:15.102Z INFO Starting Controller {"controller": "pxcrestore-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBClusterRestore"} 2025-12-05T09:56:15.102Z INFO Starting workers {"controller": "pxcbackup-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBClusterBackup", "worker count": 1} 2025-12-05T09:56:15.102Z INFO Starting workers {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "worker count": 1} 2025-12-05T09:56:15.102Z INFO Starting workers {"controller": "pxcrestore-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBClusterRestore", "worker count": 1} 2025-12-05T09:56:52.186Z INFO Set CR version {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "6032e624-d291-4740-a276-e98a8349177f", "version": "1.19.0"} 2025-12-05T09:56:53.273Z DEBUG Creating object {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "6032e624-d291-4740-a276-e98a8349177f", "object": "auto-proxy-switch-pxc", "kind": "&TypeMeta{Kind:ConfigMap,APIVersion:v1,}"} 2025-12-05T09:56:53.391Z DEBUG Creating object {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "6032e624-d291-4740-a276-e98a8349177f", "object": "proxy-switch-haproxy", "kind": "&TypeMeta{Kind:StatefulSet,APIVersion:apps/v1,}"} 2025-12-05T09:56:53.442Z DEBUG Creating object {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "6032e624-d291-4740-a276-e98a8349177f", "object": "proxy-switch-pxc", "kind": "&TypeMeta{Kind:StatefulSet,APIVersion:apps/v1,}"} 2025-12-05T09:56:53.501Z DEBUG Creating object {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "6032e624-d291-4740-a276-e98a8349177f", "object": "proxy-switch-pxc", "kind": "&TypeMeta{Kind:Service,APIVersion:v1,}"} 2025-12-05T09:56:53.544Z DEBUG Creating object {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "6032e624-d291-4740-a276-e98a8349177f", "object": "proxy-switch-pxc-unready", "kind": "&TypeMeta{Kind:Service,APIVersion:v1,}"} 2025-12-05T09:56:53.752Z DEBUG Creating object {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "6032e624-d291-4740-a276-e98a8349177f", "object": "proxy-switch-haproxy", "kind": "&TypeMeta{Kind:Service,APIVersion:v1,}"} 2025-12-05T09:56:54.502Z DEBUG Creating object {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "6032e624-d291-4740-a276-e98a8349177f", "object": "proxy-switch-haproxy-replicas", "kind": "&TypeMeta{Kind:Service,APIVersion:v1,}"} 2025-12-05T09:56:55.625Z DEBUG Creating object {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "961c713c-05ee-4230-b8ab-1336efd25c86", "object": "proxy-switch-pxc", "kind": "&TypeMeta{Kind:PodDisruptionBudget,APIVersion:policy/v1,}"} 2025-12-05T09:56:55.640Z DEBUG Creating object {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "961c713c-05ee-4230-b8ab-1336efd25c86", "object": "proxy-switch-haproxy", "kind": "&TypeMeta{Kind:PodDisruptionBudget,APIVersion:policy/v1,}"} 2025-12-05T09:58:11.989Z INFO Password expiration policy updated {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "e18fdcc5-2dd1-41e3-84e9-80dfe9795270", "user": "operator"} 2025-12-05T09:58:12.030Z INFO Password expiration policy updated {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "e18fdcc5-2dd1-41e3-84e9-80dfe9795270", "user": "monitor"} 2025-12-05T09:58:12.089Z INFO User monitor: granted privileges {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "e18fdcc5-2dd1-41e3-84e9-80dfe9795270"} 2025-12-05T09:58:12.125Z INFO monitor user privileges granted {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "e18fdcc5-2dd1-41e3-84e9-80dfe9795270"} 2025-12-05T09:58:12.158Z INFO Password expiration policy updated {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "e18fdcc5-2dd1-41e3-84e9-80dfe9795270", "user": "xtrabackup"} 2025-12-05T09:58:12.215Z INFO User xtrabackup: granted privileges {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "e18fdcc5-2dd1-41e3-84e9-80dfe9795270"} 2025-12-05T09:58:12.284Z INFO Password expiration policy updated {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "e18fdcc5-2dd1-41e3-84e9-80dfe9795270", "user": "replication"} 2025-12-05T10:00:38.704Z INFO Password expiration policy updated {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "a14b666a-61ff-40b1-8ff1-1b6e617b8f01", "user": "root"} 2025-12-05T10:00:38.875Z INFO update PXC version (fetched from db) {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "a14b666a-61ff-40b1-8ff1-1b6e617b8f01", "new version": "8.0.43-34.1"} 2025-12-05T10:03:32.021Z INFO controller-runtime.cache Warning: watch ended with error {"reflector": "pkg/mod/k8s.io/client-go@v0.34.2/tools/cache/reflector.go:290", "type": "*v1.Event", "err": "very short watch: pkg/mod/k8s.io/client-go@v0.34.2/tools/cache/reflector.go:290: Unexpected watch close - watch lasted less than a second and no items received"} 2025-12-05T10:03:59.902Z DEBUG Creating object {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "1a8513c7-fdaa-4b9f-a671-9d67b64e4057", "object": "proxy-switch-proxysql", "kind": "&TypeMeta{Kind:StatefulSet,APIVersion:apps/v1,}"} 2025-12-05T10:04:00.202Z DEBUG Creating object {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "1a8513c7-fdaa-4b9f-a671-9d67b64e4057", "object": "proxy-switch-proxysql", "kind": "&TypeMeta{Kind:Service,APIVersion:v1,}"} 2025-12-05T10:04:00.360Z DEBUG Creating object {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "1a8513c7-fdaa-4b9f-a671-9d67b64e4057", "object": "proxy-switch-proxysql-unready", "kind": "&TypeMeta{Kind:Service,APIVersion:v1,}"} 2025-12-05T10:04:03.708Z INFO reconcile replication error {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "1a8513c7-fdaa-4b9f-a671-9d67b64e4057", "err": "get primary pxc pod: failed to get proxy connection: dial tcp: lookup proxy-switch-proxysql-unready.proxy-switch-32018 on 34.118.224.10:53: no such host"} 2025-12-05T10:04:04.424Z DEBUG Creating object {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "8bc9978c-8b09-46b0-a774-f07c11ebcce9", "object": "proxy-switch-proxysql", "kind": "&TypeMeta{Kind:PodDisruptionBudget,APIVersion:policy/v1,}"} 2025-12-05T10:04:08.038Z INFO reconcile replication error {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "8bc9978c-8b09-46b0-a774-f07c11ebcce9", "err": "get primary pxc pod: failed to get proxy connection: dial tcp: lookup proxy-switch-proxysql-unready.proxy-switch-32018 on 34.118.224.10:53: no such host"} 2025-12-05T10:04:12.648Z INFO reconcile replication error {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "c282ae55-a803-45b4-8bc8-1c24bff5a7b8", "err": "get primary pxc pod: failed to get proxy connection: dial tcp 10.106.137.12:6032: connect: connection refused"} 2025-12-05T10:04:17.855Z INFO reconcile replication error {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "ac5d1865-b415-4aab-b2d5-5efb73bc3a88", "err": "get primary pxc pod: not found"} 2025-12-05T10:04:18.082Z INFO reconcile replication error {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "36e08354-3147-4630-a2f5-3ab127aac662", "err": "get primary pxc pod: not found"} 2025-12-05T10:04:23.078Z INFO reconcile replication error {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "521957b4-aa7d-4ea0-ad92-20c366d1b1b2", "err": "get primary pxc pod: not found"} 2025-12-05T10:04:28.303Z INFO reconcile replication error {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "d6f8e5e6-a172-490d-9f4d-3e703ce21282", "err": "get primary pxc pod: not found"} 2025-12-05T10:04:49.516Z INFO reconcile replication error {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "1f84e26f-0d53-442e-be6b-8ca6f6969c9c", "err": "get primary pxc pod: not found"} 2025-12-05T10:04:56.620Z ERROR sync users {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "05a4b158-92e8-4693-a927-94d847533592", "error": "exec syncusers: failed to execute command in pod: command terminated with exit code 1 / / ERROR (line:515) : The cluster (with writer hostgroup:11) has not been configured in ProxySQL\nERROR (line:515) : The cluster (with writer hostgroup:11) has not been configured in ProxySQL\nERROR (line:515) : The cluster (with writer hostgroup:11) has not been configured in ProxySQL\nERROR (line:515) : The cluster (with writer hostgroup:11) has not been configured in ProxySQL\nERROR (line:515) : The cluster (with writer hostgroup:11) has not been configured in ProxySQL\n", "errorVerbose": "exec syncusers: failed to execute command in pod: command terminated with exit code 1 / / ERROR (line:515) : The cluster (with writer hostgroup:11) has not been configured in ProxySQL\nERROR (line:515) : The cluster (with writer hostgroup:11) has not been configured in ProxySQL\nERROR (line:515) : The cluster (with writer hostgroup:11) has not been configured in ProxySQL\nERROR (line:515) : The cluster (with writer hostgroup:11) has not been configured in ProxySQL\nERROR (line:515) : The cluster (with writer hostgroup:11) has not been configured in ProxySQL\n\ngithub.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc.(*ReconcilePerconaXtraDBCluster).syncPXCUsersWithProxySQL\n\t/go/src/github.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc/users.go:975\ngithub.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc.(*ReconcilePerconaXtraDBCluster).resyncPXCUsersWithProxySQL.func1\n\t/go/src/github.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc/controller.go:855\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1693"} 2025-12-05T10:05:05.447Z INFO reconcile replication error {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "76a2857a-78ed-4556-a1cd-0541fa5295ac", "err": "get primary pxc pod: not found"} 2025-12-05T10:05:07.932Z ERROR sync users {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "61d8fd06-86e9-4cc1-9729-6b43033d01a7", "error": "exec syncusers: failed to execute command in pod: command terminated with exit code 1 / / ERROR (line:515) : The cluster (with writer hostgroup:11) has not been configured in ProxySQL\nERROR (line:515) : The cluster (with writer hostgroup:11) has not been configured in ProxySQL\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\n", "errorVerbose": "exec syncusers: failed to execute command in pod: command terminated with exit code 1 / / ERROR (line:515) : The cluster (with writer hostgroup:11) has not been configured in ProxySQL\nERROR (line:515) : The cluster (with writer hostgroup:11) has not been configured in ProxySQL\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\n\ngithub.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc.(*ReconcilePerconaXtraDBCluster).syncPXCUsersWithProxySQL\n\t/go/src/github.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc/users.go:975\ngithub.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc.(*ReconcilePerconaXtraDBCluster).resyncPXCUsersWithProxySQL.func1\n\t/go/src/github.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc/controller.go:855\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1693"} 2025-12-05T10:05:15.996Z INFO reconcile replication error {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "f8ef9d58-def7-42c5-b9f3-52b56b4677f8", "err": "get primary pxc pod: not found"} 2025-12-05T10:05:18.132Z ERROR sync users {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "2898f7e5-3be1-4f8a-a30b-ff60d4f2b42b", "error": "exec syncusers: failed to execute command in pod: command terminated with exit code 1 / / ERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\n", "errorVerbose": "exec syncusers: failed to execute command in pod: command terminated with exit code 1 / / ERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\n\ngithub.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc.(*ReconcilePerconaXtraDBCluster).syncPXCUsersWithProxySQL\n\t/go/src/github.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc/users.go:975\ngithub.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc.(*ReconcilePerconaXtraDBCluster).resyncPXCUsersWithProxySQL.func1\n\t/go/src/github.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc/controller.go:855\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1693"} 2025-12-05T10:05:21.224Z INFO reconcile replication error {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "3be2a982-4db3-440d-bbd2-e23b484cfdf6", "err": "get primary pxc pod: not found"} 2025-12-05T10:05:26.492Z INFO reconcile replication error {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "7f1a529c-b622-4c38-9631-40bef4777bd9", "err": "get primary pxc pod: not found"} 2025-12-05T10:05:29.252Z ERROR sync users {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "3be2a982-4db3-440d-bbd2-e23b484cfdf6", "error": "exec syncusers: failed to execute command in pod: command terminated with exit code 1 / / ERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\n", "errorVerbose": "exec syncusers: failed to execute command in pod: command terminated with exit code 1 / / ERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\n\ngithub.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc.(*ReconcilePerconaXtraDBCluster).syncPXCUsersWithProxySQL\n\t/go/src/github.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc/users.go:975\ngithub.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc.(*ReconcilePerconaXtraDBCluster).resyncPXCUsersWithProxySQL.func1\n\t/go/src/github.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc/controller.go:855\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1693"} 2025-12-05T10:05:31.755Z INFO reconcile replication error {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "7d08c1e4-c383-4a30-98ee-989d02f8a9ef", "err": "get primary pxc pod: not found"} 2025-12-05T10:05:39.037Z ERROR sync users {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "7d08c1e4-c383-4a30-98ee-989d02f8a9ef", "error": "exec syncusers: failed to execute command in pod: command terminated with exit code 1 / / ERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\n", "errorVerbose": "exec syncusers: failed to execute command in pod: command terminated with exit code 1 / / ERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\n\ngithub.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc.(*ReconcilePerconaXtraDBCluster).syncPXCUsersWithProxySQL\n\t/go/src/github.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc/users.go:975\ngithub.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc.(*ReconcilePerconaXtraDBCluster).resyncPXCUsersWithProxySQL.func1\n\t/go/src/github.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc/controller.go:855\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1693"} 2025-12-05T10:05:42.855Z INFO reconcile replication error {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "eb918181-acb4-4c44-9d6e-7d4d3aca9413", "err": "get primary pxc pod: not found"} 2025-12-05T10:05:50.316Z ERROR sync users {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "eb918181-acb4-4c44-9d6e-7d4d3aca9413", "error": "exec syncusers: failed to execute command in pod: command terminated with exit code 1 / / ERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\n", "errorVerbose": "exec syncusers: failed to execute command in pod: command terminated with exit code 1 / / ERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\nERROR (line:1612) : Could not find any nodes belonging to the cluster with writer hostgroup:11\nERROR (line:572) : Could not find a primary cluster node\n\ngithub.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc.(*ReconcilePerconaXtraDBCluster).syncPXCUsersWithProxySQL\n\t/go/src/github.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc/users.go:975\ngithub.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc.(*ReconcilePerconaXtraDBCluster).resyncPXCUsersWithProxySQL.func1\n\t/go/src/github.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc/controller.go:855\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1693"} 2025-12-05T10:05:58.541Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "7bc5bba3-a11f-4c39-9939-42593f2bd24a"} 2025-12-05T10:06:03.305Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "65dd28de-8dd2-464a-9473-81d33cc28203"} 2025-12-05T10:06:08.807Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "12e21439-f9ce-4dbe-aaee-e4602c2dac92"} 2025-12-05T10:06:13.837Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "610d93b1-1274-4289-a848-6e2375571a59"} 2025-12-05T10:06:18.896Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "78836e7b-bd03-425a-9a72-d56267841231"} 2025-12-05T10:06:24.287Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "bbfad924-8034-47a1-bbf9-d132bcae7389"} 2025-12-05T10:06:25.823Z DEBUG Creating object {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "fc9d82a2-5c86-4162-b7d3-4bb994c7ab3f", "object": "proxy-switch-haproxy", "kind": "&TypeMeta{Kind:StatefulSet,APIVersion:apps/v1,}"} 2025-12-05T10:06:25.894Z DEBUG Creating object {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "fc9d82a2-5c86-4162-b7d3-4bb994c7ab3f", "object": "proxy-switch-haproxy", "kind": "&TypeMeta{Kind:StatefulSet,APIVersion:apps/v1,}"} 2025-12-05T10:06:26.001Z DEBUG Creating object {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "fc9d82a2-5c86-4162-b7d3-4bb994c7ab3f", "object": "proxy-switch-haproxy", "kind": "&TypeMeta{Kind:Service,APIVersion:v1,}"} 2025-12-05T10:06:26.099Z DEBUG Creating object {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "fc9d82a2-5c86-4162-b7d3-4bb994c7ab3f", "object": "proxy-switch-haproxy-replicas", "kind": "&TypeMeta{Kind:Service,APIVersion:v1,}"} 2025-12-05T10:06:29.684Z INFO reconcile replication error {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "fc9d82a2-5c86-4162-b7d3-4bb994c7ab3f", "err": "get primary pxc pod: failed to get proxy connection: dial tcp 34.118.232.135:3306: connect: connection refused"} 2025-12-05T10:06:30.400Z DEBUG Creating object {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "1d1aeb9d-6f80-4664-8398-e6896b571ab7", "object": "proxy-switch-haproxy", "kind": "&TypeMeta{Kind:PodDisruptionBudget,APIVersion:policy/v1,}"} 2025-12-05T10:06:33.430Z INFO reconcile replication error {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "1d1aeb9d-6f80-4664-8398-e6896b571ab7", "err": "get primary pxc pod: failed to get proxy connection: dial tcp 34.118.232.135:3306: connect: connection refused"} 2025-12-05T10:06:38.402Z INFO reconcile replication error {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "8ce8d489-2b74-4d60-9725-0655365a8346", "err": "get primary pxc pod: failed to get proxy connection: dial tcp 34.118.232.135:3306: connect: connection refused"} 2025-12-05T10:07:01.620Z INFO reconcile replication error {"controller": "pxc-controller", "controllerGroup": "pxc.percona.com", "controllerKind": "PerconaXtraDBCluster", "PerconaXtraDBCluster": {"name":"proxy-switch","namespace":"proxy-switch-32018"}, "namespace": "proxy-switch-32018", "name": "proxy-switch", "reconcileID": "8b642a47-57f2-425c-961b-b628edd35b4c", "err": "get primary pxc pod: failed to get proxy connection: dial tcp 34.118.232.135:3306: i/o timeout"} github.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc.(*ReconcilePerconaXtraDBCluster).resyncPXCUsersWithProxySQL.func1 /go/src/github.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc/controller.go:857 + grep -v NAMESPACE + kubectl get pxc --all-namespaces -o wide + xargs -L 1 sh -xc 'kubectl patch pxc -n $0 $1 --type=merge -p "{\"metadata\":{\"finalizers\":[]}}"' + kubectl patch pxc -n proxy-switch-32018 proxy-switch --type=merge -p '{"metadata":{"finalizers":[]}}' perconaxtradbcluster.pxc.percona.com/proxy-switch patched + kubectl_bin delete pxc --all --all-namespaces ++ mktemp + local LAST_OUT=/tmp/tmp.IO4Y89PV6Y ++ mktemp + local LAST_ERR=/tmp/tmp.8cm40kl30W + 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.IO4Y89PV6Y perconaxtradbcluster.pxc.percona.com "proxy-switch" deleted from proxy-switch-32018 namespace + cat /tmp/tmp.8cm40kl30W + rm /tmp/tmp.IO4Y89PV6Y /tmp/tmp.8cm40kl30W + return 0 + kubectl_bin delete pxc-backup --all --all-namespaces ++ mktemp + local LAST_OUT=/tmp/tmp.Ac9ZRF31dW ++ mktemp + local LAST_ERR=/tmp/tmp.4G0hqvFzYn + 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.Ac9ZRF31dW No resources found + cat /tmp/tmp.4G0hqvFzYn + rm /tmp/tmp.Ac9ZRF31dW /tmp/tmp.4G0hqvFzYn + return 0 + kubectl_bin delete pxc-restore --all --all-namespaces ++ mktemp + local LAST_OUT=/tmp/tmp.O2Q61IZH3B ++ mktemp + local LAST_ERR=/tmp/tmp.pfeMuW7Jw1 + 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.O2Q61IZH3B No resources found + cat /tmp/tmp.pfeMuW7Jw1 + rm /tmp/tmp.O2Q61IZH3B /tmp/tmp.pfeMuW7Jw1 + return 0 + kubectl_bin delete ValidatingWebhookConfiguration percona-xtradbcluster-webhook ++ mktemp + local LAST_OUT=/tmp/tmp.HYqPE15Wc7 ++ mktemp + local LAST_ERR=/tmp/tmp.HUmfqH3zHv + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl delete ValidatingWebhookConfiguration percona-xtradbcluster-webhook + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.HYqPE15Wc7 validatingwebhookconfiguration.admissionregistration.k8s.io "percona-xtradbcluster-webhook" deleted + cat /tmp/tmp.HUmfqH3zHv + rm /tmp/tmp.HYqPE15Wc7 /tmp/tmp.HUmfqH3zHv + return 0 + kubectl_bin delete -f https://github.com/jetstack/cert-manager/releases/download/v1.18.2/cert-manager.yaml + : + '[' '!' -z '' ']' + '[' -n pxc-operator ']' + kubectl_bin delete --grace-period=0 --force=true namespace proxy-switch-32018 + rm -rf /tmp/tmp.j2wBW4HTkS + kubectl_bin delete --grace-period=0 --force=true namespace pxc-operator ++ mktemp ++ mktemp + local LAST_OUT=/tmp/tmp.jyauTPPWzO + desc 'test passed' + set +o xtrace + local LAST_OUT=/tmp/tmp.zN7RO9ibZQ ----------------------------------------------------------------------------------- test passed ----------------------------------------------------------------------------------- ++ mktemp ++ mktemp + local LAST_ERR=/tmp/tmp.4JHa7NowP1 + local exit_status=0 + local LAST_ERR=/tmp/tmp.WIYWnJ5Hgr + local exit_status=0 ++ seq 0 2 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl delete --grace-period=0 --force=true namespace proxy-switch-32018 + for i in '$(seq 0 2)' + set +e + kubectl delete --grace-period=0 --force=true namespace pxc-operator