Log: /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/logs/custom-users-8-0.log Warning: version difference between client (1.34) and server (1.31) exceeds the supported minor version skew of +/-1 Warning: version difference between client (1.34) and server (1.31) exceeds the supported minor version skew of +/-1 + create_infra custom-users-13629 + local ns=custom-users-13629 + '[' -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 custom-users-23880 some-name --type=merge -p '{"metadata":{"finalizers":[]}}' perconaxtradbcluster.pxc.percona.com/some-name patched + kubectl_bin delete pxc --all --all-namespaces ++ mktemp + local LAST_OUT=/tmp/tmp.Sf74cRLEBe ++ mktemp + local LAST_ERR=/tmp/tmp.GqJazSRU03 + 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.Sf74cRLEBe perconaxtradbcluster.pxc.percona.com "some-name" deleted from custom-users-23880 namespace + cat /tmp/tmp.GqJazSRU03 + rm /tmp/tmp.Sf74cRLEBe /tmp/tmp.GqJazSRU03 + return 0 + kubectl_bin delete pxc-backup --all --all-namespaces ++ mktemp + local LAST_OUT=/tmp/tmp.BB2TmsrzIy ++ mktemp + local LAST_ERR=/tmp/tmp.5tgE4Nk6GL + 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.BB2TmsrzIy No resources found + cat /tmp/tmp.5tgE4Nk6GL + rm /tmp/tmp.BB2TmsrzIy /tmp/tmp.5tgE4Nk6GL + return 0 + kubectl_bin delete pxc-restore --all --all-namespaces ++ mktemp + local LAST_OUT=/tmp/tmp.1kQ82bPb6U ++ mktemp + local LAST_ERR=/tmp/tmp.radBvshQlb + 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.1kQ82bPb6U No resources found + cat /tmp/tmp.radBvshQlb + rm /tmp/tmp.1kQ82bPb6U /tmp/tmp.radBvshQlb + return 0 + create_namespace pxc-operator + local namespace=pxc-operator + local skip_clean_namespace= + [[ 1 == 1 ]] + [[ -z '' ]] + destroy_chaos_mesh ++ helm list --all-namespaces --filter chaos-mesh ++ sed s/NAMESPACE// ++ tail -n1 ++ awk '-F ' '{print $2}' + local chaos_mesh_ns= + '[' -n '' ']' ++ grep chaos-mesh ++ kubectl get MutatingWebhookConfiguration ++ awk '{print $1}' + timeout 30 kubectl delete MutatingWebhookConfiguration error: resource(s) were provided, but no name was specified + : ++ kubectl get ValidatingWebhookConfiguration ++ awk '{print $1}' ++ grep chaos-mesh + 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}' ++ awk '{print $1}' ++ kubectl get crd ++ grep chaos-mesh.org + 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 + : ++ grep chaos-mesh ++ awk '{print $1}' ++ kubectl get clusterrole + 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 ----------------------------------------------------------------------------------- + '[' -n '' ']' + desc 'cleaned up old namespaces pxc-operator' + set +o xtrace ----------------------------------------------------------------------------------- cleaned up old namespaces pxc-operator ----------------------------------------------------------------------------------- + kubectl_bin delete namespace pxc-operator ++ mktemp + xargs kubectl delete ns + awk '{print$1}' + local LAST_OUT=/tmp/tmp.Sp2DlywiJD ++ mktemp + local LAST_ERR=/tmp/tmp.I1ylxbK0MJ + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl delete namespace pxc-operator + egrep -v '^kube-|^default|Terminating|pxc-operator|openshift|^gke-|^gmp-|^NAME' + kubectl_bin get ns ++ mktemp + local LAST_OUT=/tmp/tmp.Jk39mz4oLn ++ mktemp + local LAST_ERR=/tmp/tmp.E8t0AMXSXI + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl get ns + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.Jk39mz4oLn + cat /tmp/tmp.E8t0AMXSXI + rm /tmp/tmp.Jk39mz4oLn /tmp/tmp.E8t0AMXSXI + return 0 namespace "custom-users-23880" deleted + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.Sp2DlywiJD namespace "pxc-operator" deleted + cat /tmp/tmp.I1ylxbK0MJ + rm /tmp/tmp.Sp2DlywiJD /tmp/tmp.I1ylxbK0MJ + 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.A2YKtDmLeQ ++ mktemp + local LAST_ERR=/tmp/tmp.2nW2nCH0xk + 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.A2YKtDmLeQ namespace/pxc-operator created + cat /tmp/tmp.2nW2nCH0xk + rm /tmp/tmp.A2YKtDmLeQ /tmp/tmp.2nW2nCH0xk + return 0 ++ kubectl_bin config current-context +++ mktemp ++ local LAST_OUT=/tmp/tmp.rfCsSe2MfE +++ mktemp ++ local LAST_ERR=/tmp/tmp.SVxUAgdV24 ++ 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.rfCsSe2MfE ++ cat /tmp/tmp.SVxUAgdV24 ++ rm /tmp/tmp.rfCsSe2MfE /tmp/tmp.SVxUAgdV24 ++ return 0 + kubectl_bin config set-context gke_cloud-dev-112233_us-central1-a_jen-pxc-2202-c5e2e681-2-cluster4 --namespace=pxc-operator ++ mktemp + local LAST_OUT=/tmp/tmp.FEkiYIGgHU ++ mktemp + local LAST_ERR=/tmp/tmp.tGbQ60ryut + 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-2202-c5e2e681-2-cluster4 --namespace=pxc-operator + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.FEkiYIGgHU Context "gke_cloud-dev-112233_us-central1-a_jen-pxc-2202-c5e2e681-2-cluster4" modified. + cat /tmp/tmp.tGbQ60ryut + rm /tmp/tmp.FEkiYIGgHU /tmp/tmp.tGbQ60ryut + 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-2202/deploy/crd.yaml ++ mktemp + local LAST_OUT=/tmp/tmp.M1JDfctSLA ++ mktemp + local LAST_ERR=/tmp/tmp.6SCZpEkuR7 + 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-2202/deploy/crd.yaml + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.M1JDfctSLA 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.6SCZpEkuR7 + rm /tmp/tmp.M1JDfctSLA /tmp/tmp.6SCZpEkuR7 + 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^' + kubectl_bin apply -f - + cat /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/deploy/cw-rbac.yaml ++ mktemp + local LAST_OUT=/tmp/tmp.R46Y9c2X6g ++ mktemp + local LAST_ERR=/tmp/tmp.zCIv14XfI8 + 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.R46Y9c2X6g 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.zCIv14XfI8 + rm /tmp/tmp.R46Y9c2X6g /tmp/tmp.zCIv14XfI8 + return 0 + kubectl_bin apply -f - + cat /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/deploy/cw-operator.yaml ++ mktemp + local LAST_OUT=/tmp/tmp.C4Zs71dOEs ++ mktemp + local LAST_ERR=/tmp/tmp.xsMxxfdZfP + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl apply -f - + sed -e 's^image: .*^image: perconalab/percona-xtradb-cluster-operator:PR-2202-c5e2e681^' + yq eval '(select(.kind == "Deployment").spec.template.spec.containers[] | select(.name == "percona-xtradb-cluster-operator").env[] | select(.name == "LOG_LEVEL").value) = "VERBOSE"' - + yq eval '(select(.kind == "Deployment").spec.template.spec.containers[] | select(.name == "percona-xtradb-cluster-operator").env[] | select(.name == "DISABLE_TELEMETRY").value) = "true"' - + sed -e 's^failureThreshold: .*^failureThreshold: 10^' + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.C4Zs71dOEs deployment.apps/percona-xtradb-cluster-operator created service/percona-xtradb-cluster-operator created + cat /tmp/tmp.xsMxxfdZfP + rm /tmp/tmp.C4Zs71dOEs /tmp/tmp.xsMxxfdZfP + 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.JbgyMHgGM3 ++ mktemp + local LAST_ERR=/tmp/tmp.sWLK5I7WFf + 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.JbgyMHgGM3 pod/percona-xtradb-cluster-operator-d84c66648-66srf condition met + cat /tmp/tmp.sWLK5I7WFf + rm /tmp/tmp.JbgyMHgGM3 /tmp/tmp.sWLK5I7WFf + return 0 ++ get_operator_pod ++ local label_prefix=app.kubernetes.io/ +++ grep -c percona-xtradb-cluster-operator +++ kubectl get pods --selector=app.kubernetes.io/name=percona-xtradb-cluster-operator -n pxc-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.jqf1zniLDD +++ mktemp ++ local LAST_ERR=/tmp/tmp.iWOJeJQn1u ++ 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.jqf1zniLDD ++ cat /tmp/tmp.iWOJeJQn1u ++ rm /tmp/tmp.jqf1zniLDD /tmp/tmp.iWOJeJQn1u ++ return 0 + wait_pod percona-xtradb-cluster-operator-d84c66648-66srf 480 pxc-operator + local pod=percona-xtradb-cluster-operator-d84c66648-66srf + local max_retry=480 + local ns=pxc-operator ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ echo percona-xtradb-cluster-operator-d84c66648-66srf ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/percona-xtradb-cluster-operator-d84c66648-66srf condition met waiting for pod/percona-xtradb-cluster-operator-d84c66648-66srf to become Ready.Ok + sleep 3 + create_namespace custom-users-13629 + local namespace=custom-users-13629 + local skip_clean_namespace= + [[ 1 == 1 ]] + [[ -z '' ]] + destroy_chaos_mesh ++ helm list --all-namespaces --filter chaos-mesh ++ tail -n1 ++ sed s/NAMESPACE// ++ awk '-F ' '{print $2}' + local chaos_mesh_ns= + '[' -n '' ']' ++ grep chaos-mesh ++ kubectl get MutatingWebhookConfiguration ++ awk '{print $1}' + timeout 30 kubectl delete MutatingWebhookConfiguration error: resource(s) were provided, but no name was specified + : ++ grep chaos-mesh ++ awk '{print $1}' ++ kubectl get ValidatingWebhookConfiguration + timeout 30 kubectl delete ValidatingWebhookConfiguration error: resource(s) were provided, but no name was specified + : ++ grep validate-auth ++ awk '{print $1}' ++ kubectl get ValidatingWebhookConfiguration + timeout 30 kubectl delete ValidatingWebhookConfiguration error: resource(s) were provided, but no name was specified + : ++ awk '{print $1}' ++ kubectl api-resources ++ grep chaos-mesh ++ awk '{print $1}' ++ grep chaos-mesh.org ++ kubectl get crd + timeout 30 kubectl delete crd error: resource(s) were provided, but no name was specified + : ++ awk '{print $1}' ++ kubectl get clusterrolebinding ++ grep chaos-mesh + 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 + '[' -n '' ']' + desc 'cleaned up old namespaces custom-users-13629' + set +o xtrace ----------------------------------------------------------------------------------- cleaned up old namespaces custom-users-13629 ----------------------------------------------------------------------------------- + kubectl_bin delete namespace custom-users-13629 ++ mktemp + xargs kubectl delete ns + local LAST_OUT=/tmp/tmp.BhgFyXlgK3 + awk '{print$1}' ++ mktemp + local LAST_OUT=/tmp/tmp.zAQmlShK4b ++ mktemp ++ mktemp + local LAST_ERR=/tmp/tmp.apAB9VDdMT + local exit_status=0 + local LAST_ERR=/tmp/tmp.U1btUkIv3y + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl get ns ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl delete namespace custom-users-13629 + egrep -v '^kube-|^default|Terminating|pxc-operator|openshift|^gke-|^gmp-|^NAME' + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.BhgFyXlgK3 + cat /tmp/tmp.apAB9VDdMT + rm /tmp/tmp.BhgFyXlgK3 /tmp/tmp.apAB9VDdMT + exit_status=1 + set -e + '[' 1 '!=' 0 ']' + '[' 1 == 1 ']' + sleep 0 + for i in '$(seq 0 2)' + set +e + kubectl delete namespace custom-users-13629 + 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 custom-users-13629 + exit_status=1 + set -e + '[' 1 '!=' 0 ']' + '[' 1 == 1 ']' + sleep 0 + cat /tmp/tmp.zAQmlShK4b + cat /tmp/tmp.U1btUkIv3y Error from server (NotFound): namespaces "custom-users-13629" not found + rm /tmp/tmp.zAQmlShK4b /tmp/tmp.U1btUkIv3y + return 1 + : + wait_for_delete namespace/custom-users-13629 + local res=namespace/custom-users-13629 + echo -n 'waiting for namespace/custom-users-13629 to be deleted' waiting for namespace/custom-users-13629 to be deleted+ set +o xtrace Error from server (NotFound): namespaces "custom-users-13629" not found + desc 'create namespace custom-users-13629' + set +o xtrace ----------------------------------------------------------------------------------- create namespace custom-users-13629 ----------------------------------------------------------------------------------- + kubectl_bin create namespace custom-users-13629 ++ mktemp + local LAST_OUT=/tmp/tmp.cyrwqRVE07 ++ mktemp + local LAST_ERR=/tmp/tmp.Z9QXYvB7E9 + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl create namespace custom-users-13629 + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.cyrwqRVE07 namespace/custom-users-13629 created + cat /tmp/tmp.Z9QXYvB7E9 + rm /tmp/tmp.cyrwqRVE07 /tmp/tmp.Z9QXYvB7E9 + return 0 ++ kubectl_bin config current-context +++ mktemp ++ local LAST_OUT=/tmp/tmp.DTkuk35HGf +++ mktemp ++ local LAST_ERR=/tmp/tmp.c7uMFMBpRB ++ 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.DTkuk35HGf ++ cat /tmp/tmp.c7uMFMBpRB ++ rm /tmp/tmp.DTkuk35HGf /tmp/tmp.c7uMFMBpRB ++ return 0 + kubectl_bin config set-context gke_cloud-dev-112233_us-central1-a_jen-pxc-2202-c5e2e681-2-cluster4 --namespace=custom-users-13629 ++ mktemp + local LAST_OUT=/tmp/tmp.ZjeQKJRUNh ++ mktemp + local LAST_ERR=/tmp/tmp.EZBmbx4Hhr + 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-2202-c5e2e681-2-cluster4 --namespace=custom-users-13629 + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.ZjeQKJRUNh Context "gke_cloud-dev-112233_us-central1-a_jen-pxc-2202-c5e2e681-2-cluster4" modified. + cat /tmp/tmp.EZBmbx4Hhr + rm /tmp/tmp.ZjeQKJRUNh /tmp/tmp.EZBmbx4Hhr + 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-2202/e2e-tests/conf/minio-secret.yml -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/conf/cloud-secret.yml ++ mktemp + local LAST_OUT=/tmp/tmp.fStxqX1Uih ++ mktemp + local LAST_ERR=/tmp/tmp.IdSgh70jUb + 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-2202/e2e-tests/conf/minio-secret.yml -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/conf/cloud-secret.yml + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.fStxqX1Uih secret/minio-secret created secret/aws-s3-secret created secret/gcp-cs-secret created secret/azure-secret created + cat /tmp/tmp.IdSgh70jUb + rm /tmp/tmp.fStxqX1Uih /tmp/tmp.IdSgh70jUb + return 0 + desc 'create PXC cluster' + set +o xtrace ----------------------------------------------------------------------------------- create PXC cluster ----------------------------------------------------------------------------------- + cluster=some-name + kubectl_bin apply -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/conf/user-secrets.yml ++ mktemp + local LAST_OUT=/tmp/tmp.DC2jbFrtng ++ mktemp + local LAST_ERR=/tmp/tmp.0WVqbtSe4k + 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-2202/e2e-tests/custom-users/conf/user-secrets.yml + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.DC2jbFrtng secret/user-secrets created + cat /tmp/tmp.0WVqbtSe4k + rm /tmp/tmp.DC2jbFrtng /tmp/tmp.0WVqbtSe4k + return 0 + spinup_pxc some-name /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/conf/some-name.yml + local cluster=some-name + local config=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/conf/some-name.yml + local size=3 + local sleep=10 + local secretsFile=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/conf/secrets.yml + local pxcClientFile=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/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-2202/e2e-tests/conf/secrets.yml ++ mktemp + local LAST_OUT=/tmp/tmp.XMtV2c5Bwd ++ mktemp + local LAST_ERR=/tmp/tmp.ukfnloXKTy + 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-2202/e2e-tests/conf/secrets.yml + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.XMtV2c5Bwd secret/my-cluster-secrets created secret/some-name-ssl created secret/some-name-ssl-internal created + cat /tmp/tmp.ukfnloXKTy + rm /tmp/tmp.XMtV2c5Bwd /tmp/tmp.ukfnloXKTy + return 0 + apply_config /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/conf/client.yml + '[' -z '' ']' + cat_config /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/conf/client.yml + kubectl_bin apply -f - + cat /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/conf/client.yml + /usr/bin/sed -e 's#apiVersion: pxc.percona.com/v.*$#apiVersion: pxc.percona.com/v1#' ++ mktemp + local LAST_OUT=/tmp/tmp.idoKhsdDso + /usr/bin/sed -e 's#image:.*-proxysql$#image: perconalab/percona-xtradb-cluster-operator:main-proxysql#' + /usr/bin/sed -e 's#image:.*-haproxy$#image: perconalab/percona-xtradb-cluster-operator:main-haproxy#' + /usr/bin/sed -e 's#image:.*-init$#image: perconalab/percona-xtradb-cluster-operator:PR-2202-c5e2e681#' + /usr/bin/sed -e 's#image:.*\/percona-xtradb-cluster:.*$#image: perconalab/percona-xtradb-cluster-operator:main-pxc8.0#' + /usr/bin/sed -e s~minio-service.#namespace~minio-service.custom-users-13629~ + /usr/bin/sed -e 's#image:.*-pmm$#image: perconalab/pmm-client:dev-latest#' ++ mktemp + /usr/bin/sed -e 's#image:.*-backup$#image: perconalab/percona-xtradb-cluster-operator:main-pxc8.0-backup#' + local LAST_ERR=/tmp/tmp.C25FwvpZ2z + local exit_status=0 + /usr/bin/sed -e 's#image:.*-logcollector$#image: perconalab/percona-xtradb-cluster-operator:main-logcollector#' + /usr/bin/sed -e 's#image:.*-pxc\([0-9]*.[0-9]*\)\{0,1\}$#image: perconalab/percona-xtradb-cluster-operator:main-pxc8.0#' ++ seq 0 2 + /usr/bin/sed -e 's#apply:.*#apply: Never#' + for i in '$(seq 0 2)' + set +e + kubectl apply -f - + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.idoKhsdDso deployment.apps/pxc-client created + cat /tmp/tmp.C25FwvpZ2z + rm /tmp/tmp.idoKhsdDso /tmp/tmp.C25FwvpZ2z + return 0 + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + apply_config /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/conf/some-name.yml + '[' -z '' ']' + kubectl_bin apply -f - + cat_config /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/conf/some-name.yml + /usr/bin/sed -e 's#image:.*\/percona-xtradb-cluster:.*$#image: perconalab/percona-xtradb-cluster-operator:main-pxc8.0#' + /usr/bin/sed -e 's#image:.*-backup$#image: perconalab/percona-xtradb-cluster-operator:main-pxc8.0-backup#' + /usr/bin/sed -e 's#image:.*-proxysql$#image: perconalab/percona-xtradb-cluster-operator:main-proxysql#' + /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_OUT=/tmp/tmp.BsdhcfIJc5 ++ mktemp + local LAST_ERR=/tmp/tmp.2fTFmjh5Ul + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl apply -f - + cat /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/conf/some-name.yml + /usr/bin/sed -e 's#image:.*-haproxy$#image: perconalab/percona-xtradb-cluster-operator:main-haproxy#' + /usr/bin/sed -e 's#apiVersion: pxc.percona.com/v.*$#apiVersion: pxc.percona.com/v1#' + /usr/bin/sed -e 's#image:.*-logcollector$#image: perconalab/percona-xtradb-cluster-operator:main-logcollector#' + /usr/bin/sed -e s~minio-service.#namespace~minio-service.custom-users-13629~ + /usr/bin/sed -e 's#apply:.*#apply: Never#' + /usr/bin/sed -e 's#image:.*-init$#image: perconalab/percona-xtradb-cluster-operator:PR-2202-c5e2e681#' + /usr/bin/sed -e 's#image:.*-pmm$#image: perconalab/pmm-client:dev-latest#' + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.BsdhcfIJc5 perconaxtradbcluster.pxc.percona.com/some-name created + cat /tmp/tmp.2fTFmjh5Ul + rm /tmp/tmp.BsdhcfIJc5 /tmp/tmp.2fTFmjh5Ul + return 0 + desc 'check if all 3 Pods started' + set +o xtrace ----------------------------------------------------------------------------------- check if all 3 Pods started ----------------------------------------------------------------------------------- ++ get_proxy some-name ++ local target_cluster=some-name +++ kubectl_bin get pxc some-name -o 'jsonpath={.spec.haproxy.enabled}' ++++ mktemp +++ local LAST_OUT=/tmp/tmp.i9PXLvLrpi ++++ mktemp +++ local LAST_ERR=/tmp/tmp.xgGiVwfLxr +++ local exit_status=0 ++++ seq 0 2 +++ for i in '$(seq 0 2)' +++ set +e +++ kubectl get pxc some-name -o 'jsonpath={.spec.haproxy.enabled}' +++ exit_status=0 +++ set -e +++ '[' 0 '!=' 0 ']' +++ break +++ cat /tmp/tmp.i9PXLvLrpi +++ cat /tmp/tmp.xgGiVwfLxr +++ rm /tmp/tmp.i9PXLvLrpi /tmp/tmp.xgGiVwfLxr +++ return 0 ++ [[ true == \t\r\u\e ]] ++ echo some-name-haproxy ++ return + local proxy=some-name-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 custom-users-13629 ++ mktemp + local LAST_OUT=/tmp/tmp.MbxfpURepp ++ mktemp + local LAST_ERR=/tmp/tmp.DS9Z4QsiZu + 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 custom-users-13629 + 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 custom-users-13629 + 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 custom-users-13629 + exit_status=1 + set -e + '[' 1 '!=' 0 ']' + '[' 1 == 1 ']' + sleep 0 + cat /tmp/tmp.MbxfpURepp + cat /tmp/tmp.DS9Z4QsiZu error: no matching resources found + rm /tmp/tmp.MbxfpURepp /tmp/tmp.DS9Z4QsiZu + return 1 + true + wait_for_running some-name-haproxy 1 + local name=some-name-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 some-name-haproxy-0 480 + local pod=some-name-haproxy-0 + local max_retry=480 + local ns= ++ egrep '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ echo some-name-haproxy-0 + local container= + set +o xtrace pod/some-name-haproxy-0 condition met waiting for pod/some-name-haproxy-0 to become Ready.Ok + wait_for_running some-name-pxc 3 + local name=some-name-pxc + let last_pod=2 + local max_retry=480 + desc 'wait for running cluster' + set +o xtrace ----------------------------------------------------------------------------------- wait for running cluster ----------------------------------------------------------------------------------- ++ seq 0 2 + for i in '$(seq 0 $last_pod)' + wait_pod some-name-pxc-0 480 + local pod=some-name-pxc-0 + local max_retry=480 + local ns= ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' ++ echo some-name-pxc-0 + local container=pxc + set +o xtrace pod/some-name-pxc-0 condition met waiting for pod/some-name-pxc-0 to become Ready.Ok + for i in '$(seq 0 $last_pod)' + wait_pod some-name-pxc-1 480 + local pod=some-name-pxc-1 + local max_retry=480 + local ns= ++ echo some-name-pxc-1 ++ egrep '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container=pxc + set +o xtrace pod/some-name-pxc-1 condition met waiting for pod/some-name-pxc-1 to become Ready.Ok + for i in '$(seq 0 $last_pod)' + wait_pod some-name-pxc-2 480 + local pod=some-name-pxc-2 + local max_retry=480 + local ns= ++ echo some-name-pxc-2 ++ egrep '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container=pxc + set +o xtrace pod/some-name-pxc-2 condition met waiting for pod/some-name-pxc-2 to become Ready.Ok + sleep 10 ++ kubectl get pxc some-name -o 'jsonpath={.spec.secretsName}' + local secret_name=my-cluster-secrets ++ getSecretData my-cluster-secrets root ++ local secretName=my-cluster-secrets ++ local dataKey=root ++ kubectl_bin get secrets/my-cluster-secrets '--template={{.data.root}}' ++ base64 --decode +++ mktemp ++ local LAST_OUT=/tmp/tmp.kdWCE6N5A9 +++ mktemp ++ local LAST_ERR=/tmp/tmp.k9QBEVyWD7 ++ 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.kdWCE6N5A9 ++ cat /tmp/tmp.k9QBEVyWD7 ++ rm /tmp/tmp.kdWCE6N5A9 /tmp/tmp.k9QBEVyWD7 ++ 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 some-name-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 some-name-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.vXFTdguDrd +++ mktemp ++ local LAST_ERR=/tmp/tmp.5SisjMDcvV ++ 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.vXFTdguDrd ++ cat /tmp/tmp.5SisjMDcvV ++ rm /tmp/tmp.vXFTdguDrd /tmp/tmp.5SisjMDcvV ++ return 0 + client_pod=pxc-client-59944c5bbf-vfksl + wait_pod pxc-client-59944c5bbf-vfksl + local pod=pxc-client-59944c5bbf-vfksl + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-vfksl ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-vfksl condition met waiting for pod/pxc-client-59944c5bbf-vfksl to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + run_mysql 'INSERT myApp.myApp (id) VALUES (100500)' '-h some-name-haproxy -uroot -p'\''root_password'\'' -P3306' + local 'command=INSERT myApp.myApp (id) VALUES (100500)' + local 'uri=-h some-name-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.gtsSKQqNWa +++ mktemp ++ local LAST_ERR=/tmp/tmp.qkrEW2jiwT ++ 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.gtsSKQqNWa ++ cat /tmp/tmp.qkrEW2jiwT ++ rm /tmp/tmp.gtsSKQqNWa /tmp/tmp.qkrEW2jiwT ++ return 0 + client_pod=pxc-client-59944c5bbf-vfksl + wait_pod pxc-client-59944c5bbf-vfksl + local pod=pxc-client-59944c5bbf-vfksl + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-vfksl ++ egrep '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-vfksl condition met waiting for pod/pxc-client-59944c5bbf-vfksl to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + sleep 30 ++ seq 0 2 + for i in '$(seq 0 $((size - 1)))' + compare_mysql_cmd select-1 'SELECT * from myApp.myApp;' '-h some-name-pxc-0.some-name-pxc -uroot -p'\''root_password'\'' -P3306' + local command_id=select-1 + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h some-name-pxc-0.some-name-pxc -uroot -p'\''root_password'\'' -P3306' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/select-1.sql + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.4 ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.0 ]] + [[ -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/select-1-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SELECT * from myApp.myApp;' '-h some-name-pxc-0.some-name-pxc -uroot -p'\''root_password'\'' -P3306' + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h some-name-pxc-0.some-name-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.R41wqNDV6A +++ mktemp ++ local LAST_ERR=/tmp/tmp.HRDLSKooef ++ 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.R41wqNDV6A ++ cat /tmp/tmp.HRDLSKooef ++ rm /tmp/tmp.R41wqNDV6A /tmp/tmp.HRDLSKooef ++ return 0 + client_pod=pxc-client-59944c5bbf-vfksl + wait_pod pxc-client-59944c5bbf-vfksl + local pod=pxc-client-59944c5bbf-vfksl + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-vfksl ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-vfksl condition met waiting for pod/pxc-client-59944c5bbf-vfksl to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + '[' '!' -s /tmp/tmp.ScuwUWx5LO/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/select-1.sql /tmp/tmp.ScuwUWx5LO/select-1.sql + for i in '$(seq 0 $((size - 1)))' + compare_mysql_cmd select-1 'SELECT * from myApp.myApp;' '-h some-name-pxc-1.some-name-pxc -uroot -p'\''root_password'\'' -P3306' + local command_id=select-1 + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h some-name-pxc-1.some-name-pxc -uroot -p'\''root_password'\'' -P3306' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/select-1.sql + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.4 ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.0 ]] + [[ -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/select-1-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SELECT * from myApp.myApp;' '-h some-name-pxc-1.some-name-pxc -uroot -p'\''root_password'\'' -P3306' + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h some-name-pxc-1.some-name-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.W3mBjZdATx +++ mktemp ++ local LAST_ERR=/tmp/tmp.ELN6EfmVaD ++ 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.W3mBjZdATx ++ cat /tmp/tmp.ELN6EfmVaD ++ rm /tmp/tmp.W3mBjZdATx /tmp/tmp.ELN6EfmVaD ++ return 0 + client_pod=pxc-client-59944c5bbf-vfksl + wait_pod pxc-client-59944c5bbf-vfksl + local pod=pxc-client-59944c5bbf-vfksl + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-vfksl ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-vfksl condition met waiting for pod/pxc-client-59944c5bbf-vfksl to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + '[' '!' -s /tmp/tmp.ScuwUWx5LO/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/select-1.sql /tmp/tmp.ScuwUWx5LO/select-1.sql + for i in '$(seq 0 $((size - 1)))' + compare_mysql_cmd select-1 'SELECT * from myApp.myApp;' '-h some-name-pxc-2.some-name-pxc -uroot -p'\''root_password'\'' -P3306' + local command_id=select-1 + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h some-name-pxc-2.some-name-pxc -uroot -p'\''root_password'\'' -P3306' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/select-1.sql + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.4 ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.0 ]] + [[ -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/select-1-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SELECT * from myApp.myApp;' '-h some-name-pxc-2.some-name-pxc -uroot -p'\''root_password'\'' -P3306' + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h some-name-pxc-2.some-name-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.YZbFQ6jTbw +++ mktemp ++ local LAST_ERR=/tmp/tmp.iMMVQRPK30 ++ 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.YZbFQ6jTbw ++ cat /tmp/tmp.iMMVQRPK30 ++ rm /tmp/tmp.YZbFQ6jTbw /tmp/tmp.iMMVQRPK30 ++ return 0 + client_pod=pxc-client-59944c5bbf-vfksl + wait_pod pxc-client-59944c5bbf-vfksl + local pod=pxc-client-59944c5bbf-vfksl + local max_retry=480 + local ns= ++ egrep '^(pxc|proxysql)$' ++ echo pxc-client-59944c5bbf-vfksl ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-vfksl condition met waiting for pod/pxc-client-59944c5bbf-vfksl to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + '[' '!' -s /tmp/tmp.ScuwUWx5LO/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/select-1.sql /tmp/tmp.ScuwUWx5LO/select-1.sql ++ is_keyring_plugin_in_use some-name ++ local cluster=some-name ++ kubectl_bin exec -it some-name-pxc-0 -c pxc -- bash -c 'cat /etc/mysql/node.cnf' ++ egrep -o 'early-plugin-load=keyring_\w+.so' +++ mktemp ++ local LAST_OUT=/tmp/tmp.Wz8Ldqs8e9 +++ mktemp ++ local LAST_ERR=/tmp/tmp.P3Rz0pMPim ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl exec -it some-name-pxc-0 -c pxc -- bash -c 'cat /etc/mysql/node.cnf' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.Wz8Ldqs8e9 ++ cat /tmp/tmp.P3Rz0pMPim Unable to use a TTY - input is not a terminal or the right kind of file ++ rm /tmp/tmp.Wz8Ldqs8e9 /tmp/tmp.P3Rz0pMPim ++ return 0 + '[' '' ']' + desc 'check users created on cluster creation' + set +o xtrace ----------------------------------------------------------------------------------- check users created on cluster creation ----------------------------------------------------------------------------------- + compare_mysql_user '-h some-name-haproxy -uuser-one -ptestpass' + local 'uri=-h some-name-haproxy -uuser-one -ptestpass' + local postfix= ++ echo -h some-name-haproxy -uuser-one -ptestpass ++ sed -e 's/.*-u//; s/ .*//' + local user=user-one + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-one.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-2202/e2e-tests/custom-users/compare/user-one-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SHOW GRANTS;' '-h some-name-haproxy -uuser-one -ptestpass' + local 'command=SHOW GRANTS;' + local 'uri=-h some-name-haproxy -uuser-one -ptestpass' + /usr/bin/sed -E 's/'\''(10|192)[.][0-9][^'\'']*'\''//; s/'\''[^'\'']*[.]internal'\''//' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.KQ4MPNM7Wn +++ mktemp ++ local LAST_ERR=/tmp/tmp.jNTh4pTaZs ++ 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.KQ4MPNM7Wn ++ cat /tmp/tmp.jNTh4pTaZs ++ rm /tmp/tmp.KQ4MPNM7Wn /tmp/tmp.jNTh4pTaZs ++ return 0 + client_pod=pxc-client-59944c5bbf-vfksl + wait_pod pxc-client-59944c5bbf-vfksl + local pod=pxc-client-59944c5bbf-vfksl + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-vfksl ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-vfksl condition met waiting for pod/pxc-client-59944c5bbf-vfksl to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-one.sql /tmp/tmp.ScuwUWx5LO/user-one.sql + compare_mysql_cmd user-one-1 'SELECT User, Host from mysql.user WHERE User = '\''user-one'\'';' '-h some-name-haproxy -uroot -proot_password' + local command_id=user-one-1 + local 'command=SELECT User, Host from mysql.user WHERE User = '\''user-one'\'';' + local 'uri=-h some-name-haproxy -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-one-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-2202/e2e-tests/custom-users/compare/user-one-1-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SELECT User, Host from mysql.user WHERE User = '\''user-one'\'';' '-h some-name-haproxy -uroot -proot_password' + local 'command=SELECT User, Host from mysql.user WHERE User = '\''user-one'\'';' + local 'uri=-h some-name-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.1NN0mdLP9i +++ mktemp ++ local LAST_ERR=/tmp/tmp.hyf2okmJA6 ++ 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.1NN0mdLP9i ++ cat /tmp/tmp.hyf2okmJA6 ++ rm /tmp/tmp.1NN0mdLP9i /tmp/tmp.hyf2okmJA6 ++ return 0 + client_pod=pxc-client-59944c5bbf-vfksl + wait_pod pxc-client-59944c5bbf-vfksl + local pod=pxc-client-59944c5bbf-vfksl + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-vfksl ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-vfksl condition met waiting for pod/pxc-client-59944c5bbf-vfksl to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + '[' '!' -s /tmp/tmp.ScuwUWx5LO/user-one-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-one-1.sql /tmp/tmp.ScuwUWx5LO/user-one-1.sql + compare_mysql_cmd user-one-2 'SHOW GRANTS FOR '\''user-one'\''@'\''127.0.0.1'\'';' '-h some-name-haproxy -uroot -proot_password' + local command_id=user-one-2 + local 'command=SHOW GRANTS FOR '\''user-one'\''@'\''127.0.0.1'\'';' + local 'uri=-h some-name-haproxy -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-one-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-2202/e2e-tests/custom-users/compare/user-one-2-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SHOW GRANTS FOR '\''user-one'\''@'\''127.0.0.1'\'';' '-h some-name-haproxy -uroot -proot_password' + local 'command=SHOW GRANTS FOR '\''user-one'\''@'\''127.0.0.1'\'';' + local 'uri=-h some-name-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.1nIkV7tUXe +++ mktemp ++ local LAST_ERR=/tmp/tmp.mkqQNabX3q ++ 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.1nIkV7tUXe ++ cat /tmp/tmp.mkqQNabX3q ++ rm /tmp/tmp.1nIkV7tUXe /tmp/tmp.mkqQNabX3q ++ return 0 + client_pod=pxc-client-59944c5bbf-vfksl + wait_pod pxc-client-59944c5bbf-vfksl + local pod=pxc-client-59944c5bbf-vfksl + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-vfksl ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-vfksl condition met waiting for pod/pxc-client-59944c5bbf-vfksl to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + '[' '!' -s /tmp/tmp.ScuwUWx5LO/user-one-2.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-one-2.sql /tmp/tmp.ScuwUWx5LO/user-one-2.sql + compare_mysql_user '-h some-name-haproxy -uuser-two -ptestpass3' + local 'uri=-h some-name-haproxy -uuser-two -ptestpass3' + local postfix= ++ echo -h some-name-haproxy -uuser-two -ptestpass3 ++ sed -e 's/.*-u//; s/ .*//' + local user=user-two + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-two.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-2202/e2e-tests/custom-users/compare/user-two-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SHOW GRANTS;' '-h some-name-haproxy -uuser-two -ptestpass3' + local 'command=SHOW GRANTS;' + local 'uri=-h some-name-haproxy -uuser-two -ptestpass3' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.x18Iwxbp9k +++ mktemp + /usr/bin/sed -E 's/'\''(10|192)[.][0-9][^'\'']*'\''//; s/'\''[^'\'']*[.]internal'\''//' ++ local LAST_ERR=/tmp/tmp.aV0Mw5Lapq ++ 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.x18Iwxbp9k ++ cat /tmp/tmp.aV0Mw5Lapq ++ rm /tmp/tmp.x18Iwxbp9k /tmp/tmp.aV0Mw5Lapq ++ return 0 + client_pod=pxc-client-59944c5bbf-vfksl + wait_pod pxc-client-59944c5bbf-vfksl + local pod=pxc-client-59944c5bbf-vfksl + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-vfksl ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-vfksl condition met waiting for pod/pxc-client-59944c5bbf-vfksl to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-two.sql /tmp/tmp.ScuwUWx5LO/user-two.sql + compare_mysql_cmd user-two-1 'SELECT User, Host from mysql.user WHERE User = '\''user-two'\'';' '-h some-name-haproxy -uroot -proot_password' + local command_id=user-two-1 + local 'command=SELECT User, Host from mysql.user WHERE User = '\''user-two'\'';' + local 'uri=-h some-name-haproxy -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-two-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-2202/e2e-tests/custom-users/compare/user-two-1-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SELECT User, Host from mysql.user WHERE User = '\''user-two'\'';' '-h some-name-haproxy -uroot -proot_password' + local 'command=SELECT User, Host from mysql.user WHERE User = '\''user-two'\'';' + local 'uri=-h some-name-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.TYPZTdNZsh +++ mktemp ++ local LAST_ERR=/tmp/tmp.wKlU8npJTN ++ 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.TYPZTdNZsh ++ cat /tmp/tmp.wKlU8npJTN ++ rm /tmp/tmp.TYPZTdNZsh /tmp/tmp.wKlU8npJTN ++ return 0 + client_pod=pxc-client-59944c5bbf-vfksl + wait_pod pxc-client-59944c5bbf-vfksl + local pod=pxc-client-59944c5bbf-vfksl + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-vfksl ++ egrep '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-vfksl condition met waiting for pod/pxc-client-59944c5bbf-vfksl to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + '[' '!' -s /tmp/tmp.ScuwUWx5LO/user-two-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-two-1.sql /tmp/tmp.ScuwUWx5LO/user-two-1.sql + generatedUserSecret=some-name-custom-user-secret ++ kubectl_bin get secret some-name-custom-user-secret -o 'jsonpath={.data.user-three}' ++ base64 -d +++ mktemp ++ local LAST_OUT=/tmp/tmp.b3JPZeFT32 +++ mktemp ++ local LAST_ERR=/tmp/tmp.ml6X8ZM9pN ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get secret some-name-custom-user-secret -o 'jsonpath={.data.user-three}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.b3JPZeFT32 ++ cat /tmp/tmp.ml6X8ZM9pN ++ rm /tmp/tmp.b3JPZeFT32 /tmp/tmp.ml6X8ZM9pN ++ return 0 + userThreePass='f1Ki0{()8s++n+XZ' + compare_mysql_user '-h some-name-haproxy -uuser-three -p'\''f1Ki0{()8s++n+XZ'\''' + local 'uri=-h some-name-haproxy -uuser-three -p'\''f1Ki0{()8s++n+XZ'\''' + local postfix= ++ sed -e 's/.*-u//; s/ .*//' ++ echo -h some-name-haproxy -uuser-three '-p'\''f1Ki0{()8s++n+XZ'\''' + local user=user-three + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-three.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-2202/e2e-tests/custom-users/compare/user-three-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SHOW GRANTS;' '-h some-name-haproxy -uuser-three -p'\''f1Ki0{()8s++n+XZ'\''' + /usr/bin/sed -E 's/'\''(10|192)[.][0-9][^'\'']*'\''//; s/'\''[^'\'']*[.]internal'\''//' + local 'command=SHOW GRANTS;' + local 'uri=-h some-name-haproxy -uuser-three -p'\''f1Ki0{()8s++n+XZ'\''' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.8gJfI8CNKs +++ mktemp ++ local LAST_ERR=/tmp/tmp.diF2DI4XPY ++ 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.8gJfI8CNKs ++ cat /tmp/tmp.diF2DI4XPY ++ rm /tmp/tmp.8gJfI8CNKs /tmp/tmp.diF2DI4XPY ++ return 0 + client_pod=pxc-client-59944c5bbf-vfksl + wait_pod pxc-client-59944c5bbf-vfksl + local pod=pxc-client-59944c5bbf-vfksl + local max_retry=480 + local ns= ++ egrep '^(pxc|proxysql)$' ++ echo pxc-client-59944c5bbf-vfksl ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-vfksl condition met waiting for pod/pxc-client-59944c5bbf-vfksl to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-three.sql /tmp/tmp.ScuwUWx5LO/user-three.sql + compare_mysql_cmd user-three-1 'SELECT User, Host from mysql.user WHERE User = '\''user-three'\'';' '-h some-name-haproxy -uroot -proot_password' + local command_id=user-three-1 + local 'command=SELECT User, Host from mysql.user WHERE User = '\''user-three'\'';' + local 'uri=-h some-name-haproxy -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-three-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-2202/e2e-tests/custom-users/compare/user-three-1-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SELECT User, Host from mysql.user WHERE User = '\''user-three'\'';' '-h some-name-haproxy -uroot -proot_password' + local 'command=SELECT User, Host from mysql.user WHERE User = '\''user-three'\'';' + local 'uri=-h some-name-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.zjtcif9Mw6 +++ mktemp ++ local LAST_ERR=/tmp/tmp.jvevYW1Nfw ++ 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.zjtcif9Mw6 ++ cat /tmp/tmp.jvevYW1Nfw ++ rm /tmp/tmp.zjtcif9Mw6 /tmp/tmp.jvevYW1Nfw ++ return 0 + client_pod=pxc-client-59944c5bbf-vfksl + wait_pod pxc-client-59944c5bbf-vfksl + local pod=pxc-client-59944c5bbf-vfksl + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-vfksl ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-vfksl condition met waiting for pod/pxc-client-59944c5bbf-vfksl to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + '[' '!' -s /tmp/tmp.ScuwUWx5LO/user-three-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-three-1.sql /tmp/tmp.ScuwUWx5LO/user-three-1.sql + desc 'check password change' + set +o xtrace ----------------------------------------------------------------------------------- check password change ----------------------------------------------------------------------------------- + kubectl_bin patch secret user-secrets '-p={"stringData":{"pwd-key-one": "new-password"}}' ++ mktemp + local LAST_OUT=/tmp/tmp.dZIqtmki9m ++ mktemp + local LAST_ERR=/tmp/tmp.m4n3B9JuDB + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl patch secret user-secrets '-p={"stringData":{"pwd-key-one": "new-password"}}' + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.dZIqtmki9m secret/user-secrets patched + cat /tmp/tmp.m4n3B9JuDB + rm /tmp/tmp.dZIqtmki9m /tmp/tmp.m4n3B9JuDB + return 0 + sleep 15 + compare_mysql_user '-h some-name-haproxy -uuser-one -pnew-password' + local 'uri=-h some-name-haproxy -uuser-one -pnew-password' + local postfix= ++ sed -e 's/.*-u//; s/ .*//' ++ echo -h some-name-haproxy -uuser-one -pnew-password + local user=user-one + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-one.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-2202/e2e-tests/custom-users/compare/user-one-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SHOW GRANTS;' '-h some-name-haproxy -uuser-one -pnew-password' + local 'command=SHOW GRANTS;' + local 'uri=-h some-name-haproxy -uuser-one -pnew-password' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' + /usr/bin/sed -E 's/'\''(10|192)[.][0-9][^'\'']*'\''//; s/'\''[^'\'']*[.]internal'\''//' +++ mktemp ++ local LAST_OUT=/tmp/tmp.xNggwldeEJ +++ mktemp ++ local LAST_ERR=/tmp/tmp.2QeyFswy9o ++ 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.xNggwldeEJ ++ cat /tmp/tmp.2QeyFswy9o ++ rm /tmp/tmp.xNggwldeEJ /tmp/tmp.2QeyFswy9o ++ return 0 + client_pod=pxc-client-59944c5bbf-vfksl + wait_pod pxc-client-59944c5bbf-vfksl + local pod=pxc-client-59944c5bbf-vfksl + local max_retry=480 + local ns= ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' ++ echo pxc-client-59944c5bbf-vfksl + local container= + set +o xtrace pod/pxc-client-59944c5bbf-vfksl condition met waiting for pod/pxc-client-59944c5bbf-vfksl to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-one.sql /tmp/tmp.ScuwUWx5LO/user-one.sql + compare_mysql_cmd user-one-1 'SELECT User, Host from mysql.user WHERE User = '\''user-one'\'';' '-h some-name-haproxy -uroot -proot_password' + local command_id=user-one-1 + local 'command=SELECT User, Host from mysql.user WHERE User = '\''user-one'\'';' + local 'uri=-h some-name-haproxy -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-one-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-2202/e2e-tests/custom-users/compare/user-one-1-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SELECT User, Host from mysql.user WHERE User = '\''user-one'\'';' '-h some-name-haproxy -uroot -proot_password' + local 'command=SELECT User, Host from mysql.user WHERE User = '\''user-one'\'';' + local 'uri=-h some-name-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.T4AZRKT9b6 +++ mktemp ++ local LAST_ERR=/tmp/tmp.zksMSvXob9 ++ 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.T4AZRKT9b6 ++ cat /tmp/tmp.zksMSvXob9 ++ rm /tmp/tmp.T4AZRKT9b6 /tmp/tmp.zksMSvXob9 ++ return 0 + client_pod=pxc-client-59944c5bbf-vfksl + wait_pod pxc-client-59944c5bbf-vfksl + local pod=pxc-client-59944c5bbf-vfksl + local max_retry=480 + local ns= ++ egrep '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ echo pxc-client-59944c5bbf-vfksl + local container= + set +o xtrace pod/pxc-client-59944c5bbf-vfksl condition met waiting for pod/pxc-client-59944c5bbf-vfksl to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + '[' '!' -s /tmp/tmp.ScuwUWx5LO/user-one-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-one-1.sql /tmp/tmp.ScuwUWx5LO/user-one-1.sql + compare_mysql_cmd user-one-2 'SHOW GRANTS FOR '\''user-one'\''@'\''127.0.0.1'\'';' '-h some-name-haproxy -uroot -proot_password' + local command_id=user-one-2 + local 'command=SHOW GRANTS FOR '\''user-one'\''@'\''127.0.0.1'\'';' + local 'uri=-h some-name-haproxy -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-one-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-2202/e2e-tests/custom-users/compare/user-one-2-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SHOW GRANTS FOR '\''user-one'\''@'\''127.0.0.1'\'';' '-h some-name-haproxy -uroot -proot_password' + local 'command=SHOW GRANTS FOR '\''user-one'\''@'\''127.0.0.1'\'';' + local 'uri=-h some-name-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.joVsgXN7mS +++ mktemp ++ local LAST_ERR=/tmp/tmp.b3Cas2JI1P ++ 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.joVsgXN7mS ++ cat /tmp/tmp.b3Cas2JI1P ++ rm /tmp/tmp.joVsgXN7mS /tmp/tmp.b3Cas2JI1P ++ return 0 + client_pod=pxc-client-59944c5bbf-vfksl + wait_pod pxc-client-59944c5bbf-vfksl + local pod=pxc-client-59944c5bbf-vfksl + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-vfksl ++ egrep '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-vfksl condition met waiting for pod/pxc-client-59944c5bbf-vfksl to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + '[' '!' -s /tmp/tmp.ScuwUWx5LO/user-one-2.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-one-2.sql /tmp/tmp.ScuwUWx5LO/user-one-2.sql + desc 'check removing secretPasswordRef from user generates user password stored in generated custom-user-secret' + set +o xtrace ----------------------------------------------------------------------------------- check removing secretPasswordRef from user generates user password stored in generated custom-user-secret ----------------------------------------------------------------------------------- + kubectl_bin patch pxc some-name --type=json '-p=[{"op": "replace", "path": "/spec/users/1/passwordSecretRef", "value": null}]' ++ mktemp + local LAST_OUT=/tmp/tmp.96gfVKT8Wi ++ mktemp + local LAST_ERR=/tmp/tmp.vkRzaldreK + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl patch pxc some-name --type=json '-p=[{"op": "replace", "path": "/spec/users/1/passwordSecretRef", "value": null}]' + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.96gfVKT8Wi perconaxtradbcluster.pxc.percona.com/some-name patched + cat /tmp/tmp.vkRzaldreK + rm /tmp/tmp.96gfVKT8Wi /tmp/tmp.vkRzaldreK + return 0 + wait_cluster_consistency some-name 3 3 + local cluster_name=some-name + local cluster_size=3 + local proxy_size=3 + '[' -z 3 ']' + desc 'wait cluster consistency' + set +o xtrace ----------------------------------------------------------------------------------- wait cluster consistency ----------------------------------------------------------------------------------- + local i=0 + local max=300 + sleep 7 + echo -n 'waiting for pxc/some-name to be ready' waiting for pxc/some-name to be ready++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.0dS4A9j4OV +++ mktemp ++ local LAST_ERR=/tmp/tmp.ZIkfigFuVb ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.0dS4A9j4OV ++ cat /tmp/tmp.ZIkfigFuVb ++ rm /tmp/tmp.0dS4A9j4OV /tmp/tmp.ZIkfigFuVb ++ return 0 + [[ ready == \r\e\a\d\y ]] ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.pxc.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.45ZcNzMOmi +++ mktemp ++ local LAST_ERR=/tmp/tmp.bAQDozwhdT ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.pxc.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.45ZcNzMOmi ++ cat /tmp/tmp.bAQDozwhdT ++ rm /tmp/tmp.45ZcNzMOmi /tmp/tmp.bAQDozwhdT ++ return 0 + [[ 3 == \3 ]] +++ get_proxy_engine some-name +++ local cluster_name=some-name ++++ get_proxy some-name ++++ local target_cluster=some-name +++++ kubectl_bin get pxc some-name -o 'jsonpath={.spec.haproxy.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.1K1m7uE6VA ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.ZL8PxA9LPI +++++ local exit_status=0 ++++++ seq 0 2 +++++ for i in '$(seq 0 2)' +++++ set +e +++++ kubectl get pxc some-name -o 'jsonpath={.spec.haproxy.enabled}' +++++ exit_status=0 +++++ set -e +++++ '[' 0 '!=' 0 ']' +++++ break +++++ cat /tmp/tmp.1K1m7uE6VA +++++ cat /tmp/tmp.ZL8PxA9LPI +++++ rm /tmp/tmp.1K1m7uE6VA /tmp/tmp.ZL8PxA9LPI +++++ return 0 ++++ [[ true == \t\r\u\e ]] ++++ echo some-name-haproxy ++++ return +++ local cluster_proxy=some-name-haproxy +++ echo haproxy ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.haproxy.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.puzIBksnte +++ mktemp ++ local LAST_ERR=/tmp/tmp.GqXVJmpjAG ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.haproxy.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.puzIBksnte ++ cat /tmp/tmp.GqXVJmpjAG ++ rm /tmp/tmp.puzIBksnte /tmp/tmp.GqXVJmpjAG ++ return 0 + [[ 3 == \3 ]] + echo ++ kubectl_bin get secret some-name-custom-user-secret -o 'jsonpath={.data.user-two}' ++ base64 -d +++ mktemp ++ local LAST_OUT=/tmp/tmp.DP7nh72ZaU +++ mktemp ++ local LAST_ERR=/tmp/tmp.DYWdSB0wYM ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get secret some-name-custom-user-secret -o 'jsonpath={.data.user-two}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.DP7nh72ZaU ++ cat /tmp/tmp.DYWdSB0wYM ++ rm /tmp/tmp.DP7nh72ZaU /tmp/tmp.DYWdSB0wYM ++ return 0 + userTwoPass='Z,,#p&t)~m)LkBuLp' + compare_mysql_user '-h some-name-haproxy -uuser-two -p'\''Z,,#p&t)~m)LkBuLp'\''' + local 'uri=-h some-name-haproxy -uuser-two -p'\''Z,,#p&t)~m)LkBuLp'\''' + local postfix= ++ echo -h some-name-haproxy -uuser-two '-p'\''Z,,#p&t)~m)LkBuLp'\''' ++ sed -e 's/.*-u//; s/ .*//' + local user=user-two + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-two.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-2202/e2e-tests/custom-users/compare/user-two-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SHOW GRANTS;' '-h some-name-haproxy -uuser-two -p'\''Z,,#p&t)~m)LkBuLp'\''' + local 'command=SHOW GRANTS;' + local 'uri=-h some-name-haproxy -uuser-two -p'\''Z,,#p&t)~m)LkBuLp'\''' + /usr/bin/sed -E 's/'\''(10|192)[.][0-9][^'\'']*'\''//; s/'\''[^'\'']*[.]internal'\''//' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.QcTo6qMjGd +++ mktemp ++ local LAST_ERR=/tmp/tmp.78VVa6rCdV ++ 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.QcTo6qMjGd ++ cat /tmp/tmp.78VVa6rCdV ++ rm /tmp/tmp.QcTo6qMjGd /tmp/tmp.78VVa6rCdV ++ return 0 + client_pod=pxc-client-59944c5bbf-vfksl + wait_pod pxc-client-59944c5bbf-vfksl + local pod=pxc-client-59944c5bbf-vfksl + local max_retry=480 + local ns= ++ egrep '^(pxc|proxysql)$' ++ echo pxc-client-59944c5bbf-vfksl ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-vfksl condition met waiting for pod/pxc-client-59944c5bbf-vfksl to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-two.sql /tmp/tmp.ScuwUWx5LO/user-two.sql + desc 'delete initial users from CR and create a new one' + set +o xtrace ----------------------------------------------------------------------------------- delete initial users from CR and create a new one ----------------------------------------------------------------------------------- + kubectl_bin patch pxc some-name --type=merge '-p={ "spec": {"users":[ { "name":"user-four", "dbs": ["db1", "db2"], "grants":["SELECT, UPDATE"], "hosts": ["%"] } ]} }' ++ mktemp + local LAST_OUT=/tmp/tmp.dAyBU8laNt ++ mktemp + local LAST_ERR=/tmp/tmp.5cXkA2FJxJ + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl patch pxc some-name --type=merge '-p={ "spec": {"users":[ { "name":"user-four", "dbs": ["db1", "db2"], "grants":["SELECT, UPDATE"], "hosts": ["%"] } ]} }' + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.dAyBU8laNt perconaxtradbcluster.pxc.percona.com/some-name patched + cat /tmp/tmp.5cXkA2FJxJ + rm /tmp/tmp.dAyBU8laNt /tmp/tmp.5cXkA2FJxJ + return 0 + wait_cluster_consistency some-name 3 3 + local cluster_name=some-name + local cluster_size=3 + local proxy_size=3 + '[' -z 3 ']' + desc 'wait cluster consistency' + set +o xtrace ----------------------------------------------------------------------------------- wait cluster consistency ----------------------------------------------------------------------------------- + local i=0 + local max=300 + sleep 7 + echo -n 'waiting for pxc/some-name to be ready' waiting for pxc/some-name to be ready++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.gM8rs1dJR6 +++ mktemp ++ local LAST_ERR=/tmp/tmp.A8h1YLbmFz ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.gM8rs1dJR6 ++ cat /tmp/tmp.A8h1YLbmFz ++ rm /tmp/tmp.gM8rs1dJR6 /tmp/tmp.A8h1YLbmFz ++ return 0 + [[ ready == \r\e\a\d\y ]] ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.pxc.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.0Hy2u75Vvb +++ mktemp ++ local LAST_ERR=/tmp/tmp.jBoFa33pfC ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.pxc.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.0Hy2u75Vvb ++ cat /tmp/tmp.jBoFa33pfC ++ rm /tmp/tmp.0Hy2u75Vvb /tmp/tmp.jBoFa33pfC ++ return 0 + [[ 3 == \3 ]] +++ get_proxy_engine some-name +++ local cluster_name=some-name ++++ get_proxy some-name ++++ local target_cluster=some-name +++++ kubectl_bin get pxc some-name -o 'jsonpath={.spec.haproxy.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.cqL6uFnkvS ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.6ZP5RJITgW +++++ local exit_status=0 ++++++ seq 0 2 +++++ for i in '$(seq 0 2)' +++++ set +e +++++ kubectl get pxc some-name -o 'jsonpath={.spec.haproxy.enabled}' +++++ exit_status=0 +++++ set -e +++++ '[' 0 '!=' 0 ']' +++++ break +++++ cat /tmp/tmp.cqL6uFnkvS +++++ cat /tmp/tmp.6ZP5RJITgW +++++ rm /tmp/tmp.cqL6uFnkvS /tmp/tmp.6ZP5RJITgW +++++ return 0 ++++ [[ true == \t\r\u\e ]] ++++ echo some-name-haproxy ++++ return +++ local cluster_proxy=some-name-haproxy +++ echo haproxy ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.haproxy.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.CI9IDjydaN +++ mktemp ++ local LAST_ERR=/tmp/tmp.4yaX6nV3bD ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.haproxy.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.CI9IDjydaN ++ cat /tmp/tmp.4yaX6nV3bD ++ rm /tmp/tmp.CI9IDjydaN /tmp/tmp.4yaX6nV3bD ++ return 0 + [[ 3 == \3 ]] + echo ++ kubectl_bin get secret some-name-custom-user-secret -o 'jsonpath={.data.user-four}' ++ base64 -d +++ mktemp ++ local LAST_OUT=/tmp/tmp.oh4OCndiGA +++ mktemp ++ local LAST_ERR=/tmp/tmp.Yarwkpg7HC ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get secret some-name-custom-user-secret -o 'jsonpath={.data.user-four}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.oh4OCndiGA ++ cat /tmp/tmp.Yarwkpg7HC ++ rm /tmp/tmp.oh4OCndiGA /tmp/tmp.Yarwkpg7HC ++ return 0 + userFourPass='sMBlWYV[VoUH+3+<2u' + compare_mysql_user '-h some-name-haproxy -uuser-four -p'\''sMBlWYV[VoUH+3+<2u'\''' + local 'uri=-h some-name-haproxy -uuser-four -p'\''sMBlWYV[VoUH+3+<2u'\''' + local postfix= ++ echo -h some-name-haproxy -uuser-four '-p'\''sMBlWYV[VoUH+3+<2u'\''' ++ sed -e 's/.*-u//; s/ .*//' + local user=user-four + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-four.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-2202/e2e-tests/custom-users/compare/user-four-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SHOW GRANTS;' '-h some-name-haproxy -uuser-four -p'\''sMBlWYV[VoUH+3+<2u'\''' + /usr/bin/sed -E 's/'\''(10|192)[.][0-9][^'\'']*'\''//; s/'\''[^'\'']*[.]internal'\''//' + local 'command=SHOW GRANTS;' + local 'uri=-h some-name-haproxy -uuser-four -p'\''sMBlWYV[VoUH+3+<2u'\''' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.mpK5Ay1FMv +++ mktemp ++ local LAST_ERR=/tmp/tmp.RzvmEHGmof ++ 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.mpK5Ay1FMv ++ cat /tmp/tmp.RzvmEHGmof ++ rm /tmp/tmp.mpK5Ay1FMv /tmp/tmp.RzvmEHGmof ++ return 0 + client_pod=pxc-client-59944c5bbf-vfksl + wait_pod pxc-client-59944c5bbf-vfksl + local pod=pxc-client-59944c5bbf-vfksl + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-vfksl ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-vfksl condition met waiting for pod/pxc-client-59944c5bbf-vfksl to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-four.sql /tmp/tmp.ScuwUWx5LO/user-four.sql + compare_mysql_cmd user-four-1 'SELECT User, Host from mysql.user WHERE User = '\''user-four'\'';' '-h some-name-haproxy -uroot -proot_password' + local command_id=user-four-1 + local 'command=SELECT User, Host from mysql.user WHERE User = '\''user-four'\'';' + local 'uri=-h some-name-haproxy -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-four-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-2202/e2e-tests/custom-users/compare/user-four-1-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SELECT User, Host from mysql.user WHERE User = '\''user-four'\'';' '-h some-name-haproxy -uroot -proot_password' + local 'command=SELECT User, Host from mysql.user WHERE User = '\''user-four'\'';' + local 'uri=-h some-name-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.avqUGAC52i +++ mktemp ++ local LAST_ERR=/tmp/tmp.MnYk3CnKsz ++ 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.avqUGAC52i ++ cat /tmp/tmp.MnYk3CnKsz ++ rm /tmp/tmp.avqUGAC52i /tmp/tmp.MnYk3CnKsz ++ return 0 + client_pod=pxc-client-59944c5bbf-vfksl + wait_pod pxc-client-59944c5bbf-vfksl + local pod=pxc-client-59944c5bbf-vfksl + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-vfksl ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-vfksl condition met waiting for pod/pxc-client-59944c5bbf-vfksl to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + '[' '!' -s /tmp/tmp.ScuwUWx5LO/user-four-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-four-1.sql /tmp/tmp.ScuwUWx5LO/user-four-1.sql + compare_mysql_user '-h some-name-haproxy -uuser-one -pnew-password' + local 'uri=-h some-name-haproxy -uuser-one -pnew-password' + local postfix= ++ echo -h some-name-haproxy -uuser-one -pnew-password ++ sed -e 's/.*-u//; s/ .*//' + local user=user-one + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-one.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-2202/e2e-tests/custom-users/compare/user-one-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SHOW GRANTS;' '-h some-name-haproxy -uuser-one -pnew-password' + local 'command=SHOW GRANTS;' + /usr/bin/sed -E 's/'\''(10|192)[.][0-9][^'\'']*'\''//; s/'\''[^'\'']*[.]internal'\''//' + local 'uri=-h some-name-haproxy -uuser-one -pnew-password' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.x205Tgdmj0 +++ mktemp ++ local LAST_ERR=/tmp/tmp.lMR2POU1HW ++ 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.x205Tgdmj0 ++ cat /tmp/tmp.lMR2POU1HW ++ rm /tmp/tmp.x205Tgdmj0 /tmp/tmp.lMR2POU1HW ++ return 0 + client_pod=pxc-client-59944c5bbf-vfksl + wait_pod pxc-client-59944c5bbf-vfksl + local pod=pxc-client-59944c5bbf-vfksl + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-vfksl ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-vfksl condition met waiting for pod/pxc-client-59944c5bbf-vfksl to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-one.sql /tmp/tmp.ScuwUWx5LO/user-one.sql + compare_mysql_user '-h some-name-haproxy -uuser-two -p'\''Z,,#p&t)~m)LkBuLp'\''' + local 'uri=-h some-name-haproxy -uuser-two -p'\''Z,,#p&t)~m)LkBuLp'\''' + local postfix= ++ echo -h some-name-haproxy -uuser-two '-p'\''Z,,#p&t)~m)LkBuLp'\''' ++ sed -e 's/.*-u//; s/ .*//' + local user=user-two + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-two.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-2202/e2e-tests/custom-users/compare/user-two-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SHOW GRANTS;' '-h some-name-haproxy -uuser-two -p'\''Z,,#p&t)~m)LkBuLp'\''' + local 'command=SHOW GRANTS;' + /usr/bin/sed -E 's/'\''(10|192)[.][0-9][^'\'']*'\''//; s/'\''[^'\'']*[.]internal'\''//' + local 'uri=-h some-name-haproxy -uuser-two -p'\''Z,,#p&t)~m)LkBuLp'\''' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.0oAJSq3xHz +++ mktemp ++ local LAST_ERR=/tmp/tmp.DQMLWgxKj3 ++ 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.0oAJSq3xHz ++ cat /tmp/tmp.DQMLWgxKj3 ++ rm /tmp/tmp.0oAJSq3xHz /tmp/tmp.DQMLWgxKj3 ++ return 0 + client_pod=pxc-client-59944c5bbf-vfksl + wait_pod pxc-client-59944c5bbf-vfksl + local pod=pxc-client-59944c5bbf-vfksl + local max_retry=480 + local ns= ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' ++ echo pxc-client-59944c5bbf-vfksl + local container= + set +o xtrace pod/pxc-client-59944c5bbf-vfksl condition met waiting for pod/pxc-client-59944c5bbf-vfksl to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-two.sql /tmp/tmp.ScuwUWx5LO/user-two.sql + desc 'check user DBs updated' + set +o xtrace ----------------------------------------------------------------------------------- check user DBs updated ----------------------------------------------------------------------------------- + kubectl_bin patch pxc some-name --type=merge '-p={ "spec": {"users":[ { "name":"user-four", "dbs": ["db1", "db2", "db3"], "grants":["SELECT, UPDATE"], "hosts": ["%"] } ]} }' ++ mktemp + local LAST_OUT=/tmp/tmp.grwOpPnQsJ ++ mktemp + local LAST_ERR=/tmp/tmp.Cqj3IgFZX5 + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl patch pxc some-name --type=merge '-p={ "spec": {"users":[ { "name":"user-four", "dbs": ["db1", "db2", "db3"], "grants":["SELECT, UPDATE"], "hosts": ["%"] } ]} }' + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.grwOpPnQsJ perconaxtradbcluster.pxc.percona.com/some-name patched + cat /tmp/tmp.Cqj3IgFZX5 + rm /tmp/tmp.grwOpPnQsJ /tmp/tmp.Cqj3IgFZX5 + return 0 + wait_cluster_consistency some-name 3 3 + local cluster_name=some-name + local cluster_size=3 + local proxy_size=3 + '[' -z 3 ']' + desc 'wait cluster consistency' + set +o xtrace ----------------------------------------------------------------------------------- wait cluster consistency ----------------------------------------------------------------------------------- + local i=0 + local max=300 + sleep 7 + echo -n 'waiting for pxc/some-name to be ready' waiting for pxc/some-name to be ready++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.b176BLOMA6 +++ mktemp ++ local LAST_ERR=/tmp/tmp.EIgiQOIxNL ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.b176BLOMA6 ++ cat /tmp/tmp.EIgiQOIxNL ++ rm /tmp/tmp.b176BLOMA6 /tmp/tmp.EIgiQOIxNL ++ return 0 + [[ ready == \r\e\a\d\y ]] ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.pxc.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.XjTnaZxpDO +++ mktemp ++ local LAST_ERR=/tmp/tmp.tbLYcTd6ui ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.pxc.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.XjTnaZxpDO ++ cat /tmp/tmp.tbLYcTd6ui ++ rm /tmp/tmp.XjTnaZxpDO /tmp/tmp.tbLYcTd6ui ++ return 0 + [[ 3 == \3 ]] +++ get_proxy_engine some-name +++ local cluster_name=some-name ++++ get_proxy some-name ++++ local target_cluster=some-name +++++ kubectl_bin get pxc some-name -o 'jsonpath={.spec.haproxy.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.ugbc2bmKTA ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.zJeKz9Sjvx +++++ local exit_status=0 ++++++ seq 0 2 +++++ for i in '$(seq 0 2)' +++++ set +e +++++ kubectl get pxc some-name -o 'jsonpath={.spec.haproxy.enabled}' +++++ exit_status=0 +++++ set -e +++++ '[' 0 '!=' 0 ']' +++++ break +++++ cat /tmp/tmp.ugbc2bmKTA +++++ cat /tmp/tmp.zJeKz9Sjvx +++++ rm /tmp/tmp.ugbc2bmKTA /tmp/tmp.zJeKz9Sjvx +++++ return 0 ++++ [[ true == \t\r\u\e ]] ++++ echo some-name-haproxy ++++ return +++ local cluster_proxy=some-name-haproxy +++ echo haproxy ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.haproxy.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.5SOzXFMzOU +++ mktemp ++ local LAST_ERR=/tmp/tmp.pnbggRnamu ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.haproxy.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.5SOzXFMzOU ++ cat /tmp/tmp.pnbggRnamu ++ rm /tmp/tmp.5SOzXFMzOU /tmp/tmp.pnbggRnamu ++ return 0 + [[ 3 == \3 ]] + echo + compare_mysql_cmd user-four-2 'SHOW GRANTS FOR '\''user-four'\''@'\''%'\'';' '-h some-name-haproxy -uroot -proot_password' + local command_id=user-four-2 + local 'command=SHOW GRANTS FOR '\''user-four'\''@'\''%'\'';' + local 'uri=-h some-name-haproxy -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-four-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-2202/e2e-tests/custom-users/compare/user-four-2-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SHOW GRANTS FOR '\''user-four'\''@'\''%'\'';' '-h some-name-haproxy -uroot -proot_password' + local 'command=SHOW GRANTS FOR '\''user-four'\''@'\''%'\'';' + local 'uri=-h some-name-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.5AwBIOthUr +++ mktemp ++ local LAST_ERR=/tmp/tmp.gyWkixcCjy ++ 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.5AwBIOthUr ++ cat /tmp/tmp.gyWkixcCjy ++ rm /tmp/tmp.5AwBIOthUr /tmp/tmp.gyWkixcCjy ++ return 0 + client_pod=pxc-client-59944c5bbf-vfksl + wait_pod pxc-client-59944c5bbf-vfksl + local pod=pxc-client-59944c5bbf-vfksl + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-vfksl ++ egrep '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-vfksl condition met waiting for pod/pxc-client-59944c5bbf-vfksl to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + '[' '!' -s /tmp/tmp.ScuwUWx5LO/user-four-2.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-four-2.sql /tmp/tmp.ScuwUWx5LO/user-four-2.sql + desc 'check user grants updated' + set +o xtrace ----------------------------------------------------------------------------------- check user grants updated ----------------------------------------------------------------------------------- + kubectl_bin patch pxc some-name --type=merge '-p={ "spec": {"users":[ { "name":"user-four", "dbs": ["db1", "db2", "db3"], "grants":["SELECT, UPDATE, DELETE"], "hosts": ["%"] } ]} }' ++ mktemp + local LAST_OUT=/tmp/tmp.C2GJTcRzta ++ mktemp + local LAST_ERR=/tmp/tmp.Ernt6gdkC9 + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl patch pxc some-name --type=merge '-p={ "spec": {"users":[ { "name":"user-four", "dbs": ["db1", "db2", "db3"], "grants":["SELECT, UPDATE, DELETE"], "hosts": ["%"] } ]} }' + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.C2GJTcRzta perconaxtradbcluster.pxc.percona.com/some-name patched + cat /tmp/tmp.Ernt6gdkC9 + rm /tmp/tmp.C2GJTcRzta /tmp/tmp.Ernt6gdkC9 + return 0 + wait_cluster_consistency some-name 3 3 + local cluster_name=some-name + local cluster_size=3 + local proxy_size=3 + '[' -z 3 ']' + desc 'wait cluster consistency' + set +o xtrace ----------------------------------------------------------------------------------- wait cluster consistency ----------------------------------------------------------------------------------- + local i=0 + local max=300 + sleep 7 + echo -n 'waiting for pxc/some-name to be ready' waiting for pxc/some-name to be ready++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.mXmdzSAFFy +++ mktemp ++ local LAST_ERR=/tmp/tmp.HEzylmAhuY ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.mXmdzSAFFy ++ cat /tmp/tmp.HEzylmAhuY ++ rm /tmp/tmp.mXmdzSAFFy /tmp/tmp.HEzylmAhuY ++ return 0 + [[ ready == \r\e\a\d\y ]] ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.pxc.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.4iXvuxvEqa +++ mktemp ++ local LAST_ERR=/tmp/tmp.hBLDGt9EaP ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.pxc.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.4iXvuxvEqa ++ cat /tmp/tmp.hBLDGt9EaP ++ rm /tmp/tmp.4iXvuxvEqa /tmp/tmp.hBLDGt9EaP ++ return 0 + [[ 3 == \3 ]] +++ get_proxy_engine some-name +++ local cluster_name=some-name ++++ get_proxy some-name ++++ local target_cluster=some-name +++++ kubectl_bin get pxc some-name -o 'jsonpath={.spec.haproxy.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.8LiGx91zX9 ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.BCxEGxzzLz +++++ local exit_status=0 ++++++ seq 0 2 +++++ for i in '$(seq 0 2)' +++++ set +e +++++ kubectl get pxc some-name -o 'jsonpath={.spec.haproxy.enabled}' +++++ exit_status=0 +++++ set -e +++++ '[' 0 '!=' 0 ']' +++++ break +++++ cat /tmp/tmp.8LiGx91zX9 +++++ cat /tmp/tmp.BCxEGxzzLz +++++ rm /tmp/tmp.8LiGx91zX9 /tmp/tmp.BCxEGxzzLz +++++ return 0 ++++ [[ true == \t\r\u\e ]] ++++ echo some-name-haproxy ++++ return +++ local cluster_proxy=some-name-haproxy +++ echo haproxy ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.haproxy.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.D8VWQjvflg +++ mktemp ++ local LAST_ERR=/tmp/tmp.sAQnlbkpWt ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.haproxy.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.D8VWQjvflg ++ cat /tmp/tmp.sAQnlbkpWt ++ rm /tmp/tmp.D8VWQjvflg /tmp/tmp.sAQnlbkpWt ++ return 0 + [[ 3 == \3 ]] + echo + compare_mysql_cmd user-four-3 'SHOW GRANTS FOR '\''user-four'\''@'\''%'\'';' '-h some-name-haproxy -uroot -proot_password' + local command_id=user-four-3 + local 'command=SHOW GRANTS FOR '\''user-four'\''@'\''%'\'';' + local 'uri=-h some-name-haproxy -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-four-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-2202/e2e-tests/custom-users/compare/user-four-3-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SHOW GRANTS FOR '\''user-four'\''@'\''%'\'';' '-h some-name-haproxy -uroot -proot_password' + local 'command=SHOW GRANTS FOR '\''user-four'\''@'\''%'\'';' + local 'uri=-h some-name-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.pCUdAIGIzm +++ mktemp ++ local LAST_ERR=/tmp/tmp.4zcDrITfpM ++ 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.pCUdAIGIzm ++ cat /tmp/tmp.4zcDrITfpM ++ rm /tmp/tmp.pCUdAIGIzm /tmp/tmp.4zcDrITfpM ++ return 0 + client_pod=pxc-client-59944c5bbf-vfksl + wait_pod pxc-client-59944c5bbf-vfksl + local pod=pxc-client-59944c5bbf-vfksl + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-vfksl ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-vfksl condition met waiting for pod/pxc-client-59944c5bbf-vfksl to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + '[' '!' -s /tmp/tmp.ScuwUWx5LO/user-four-3.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-four-3.sql /tmp/tmp.ScuwUWx5LO/user-four-3.sql + desc 'check user recreated after deleted from DB' + set +o xtrace ----------------------------------------------------------------------------------- check user recreated after deleted from DB ----------------------------------------------------------------------------------- + run_mysql 'DROP USER '\''user-four'\''@'\''%'\'';' '-h some-name-haproxy -uroot -proot_password' + local 'command=DROP USER '\''user-four'\''@'\''%'\'';' + local 'uri=-h some-name-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.dwyH6O3SrF +++ mktemp ++ local LAST_ERR=/tmp/tmp.1tWs4Igoyl ++ 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.dwyH6O3SrF ++ cat /tmp/tmp.1tWs4Igoyl ++ rm /tmp/tmp.dwyH6O3SrF /tmp/tmp.1tWs4Igoyl ++ return 0 + client_pod=pxc-client-59944c5bbf-vfksl + wait_pod pxc-client-59944c5bbf-vfksl + local pod=pxc-client-59944c5bbf-vfksl + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-vfksl ++ egrep '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-vfksl condition met waiting for pod/pxc-client-59944c5bbf-vfksl to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + sleep 15 + compare_mysql_cmd user-four-1 'SELECT User, Host from mysql.user WHERE User = '\''user-four'\'';' '-h some-name-haproxy -uroot -proot_password' + local command_id=user-four-1 + local 'command=SELECT User, Host from mysql.user WHERE User = '\''user-four'\'';' + local 'uri=-h some-name-haproxy -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-four-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-2202/e2e-tests/custom-users/compare/user-four-1-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SELECT User, Host from mysql.user WHERE User = '\''user-four'\'';' '-h some-name-haproxy -uroot -proot_password' + local 'command=SELECT User, Host from mysql.user WHERE User = '\''user-four'\'';' + local 'uri=-h some-name-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.E2VInCPgSY +++ mktemp ++ local LAST_ERR=/tmp/tmp.Bl3YRnMeHv ++ 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.E2VInCPgSY ++ cat /tmp/tmp.Bl3YRnMeHv ++ rm /tmp/tmp.E2VInCPgSY /tmp/tmp.Bl3YRnMeHv ++ return 0 + client_pod=pxc-client-59944c5bbf-vfksl + wait_pod pxc-client-59944c5bbf-vfksl + local pod=pxc-client-59944c5bbf-vfksl + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-vfksl ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-vfksl condition met waiting for pod/pxc-client-59944c5bbf-vfksl to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + '[' '!' -s /tmp/tmp.ScuwUWx5LO/user-four-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-four-1.sql /tmp/tmp.ScuwUWx5LO/user-four-1.sql + compare_mysql_cmd user-four-3 'SHOW GRANTS FOR '\''user-four'\''@'\''%'\'';' '-h some-name-haproxy -uroot -proot_password' + local command_id=user-four-3 + local 'command=SHOW GRANTS FOR '\''user-four'\''@'\''%'\'';' + local 'uri=-h some-name-haproxy -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-four-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-2202/e2e-tests/custom-users/compare/user-four-3-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SHOW GRANTS FOR '\''user-four'\''@'\''%'\'';' '-h some-name-haproxy -uroot -proot_password' + local 'command=SHOW GRANTS FOR '\''user-four'\''@'\''%'\'';' + local 'uri=-h some-name-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.LbltHj7KQD +++ mktemp ++ local LAST_ERR=/tmp/tmp.goA2TtphPQ ++ 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.LbltHj7KQD ++ cat /tmp/tmp.goA2TtphPQ ++ rm /tmp/tmp.LbltHj7KQD /tmp/tmp.goA2TtphPQ ++ return 0 + client_pod=pxc-client-59944c5bbf-vfksl + wait_pod pxc-client-59944c5bbf-vfksl + local pod=pxc-client-59944c5bbf-vfksl + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-vfksl ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-vfksl condition met waiting for pod/pxc-client-59944c5bbf-vfksl to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + '[' '!' -s /tmp/tmp.ScuwUWx5LO/user-four-3.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-four-3.sql /tmp/tmp.ScuwUWx5LO/user-four-3.sql + desc 'check user update from DB' + set +o xtrace ----------------------------------------------------------------------------------- check user update from DB ----------------------------------------------------------------------------------- + run_mysql 'GRANT INSERT ON db1.* TO '\''user-four'\''@'\''%'\''' '-h some-name-haproxy -uroot -proot_password' + local 'command=GRANT INSERT ON db1.* TO '\''user-four'\''@'\''%'\''' + local 'uri=-h some-name-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.tyuCUjICRQ +++ mktemp ++ local LAST_ERR=/tmp/tmp.mjRwfTD0TW ++ 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.tyuCUjICRQ ++ cat /tmp/tmp.mjRwfTD0TW ++ rm /tmp/tmp.tyuCUjICRQ /tmp/tmp.mjRwfTD0TW ++ return 0 + client_pod=pxc-client-59944c5bbf-vfksl + wait_pod pxc-client-59944c5bbf-vfksl + local pod=pxc-client-59944c5bbf-vfksl + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-vfksl ++ egrep '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-vfksl condition met waiting for pod/pxc-client-59944c5bbf-vfksl to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + sleep 15 + compare_mysql_cmd user-four-1 'SELECT User, Host from mysql.user WHERE User = '\''user-four'\'';' '-h some-name-haproxy -uroot -proot_password' + local command_id=user-four-1 + local 'command=SELECT User, Host from mysql.user WHERE User = '\''user-four'\'';' + local 'uri=-h some-name-haproxy -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-four-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-2202/e2e-tests/custom-users/compare/user-four-1-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SELECT User, Host from mysql.user WHERE User = '\''user-four'\'';' '-h some-name-haproxy -uroot -proot_password' + local 'command=SELECT User, Host from mysql.user WHERE User = '\''user-four'\'';' + local 'uri=-h some-name-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.gAdopMTKDT +++ mktemp ++ local LAST_ERR=/tmp/tmp.BiVVp1Geq4 ++ 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.gAdopMTKDT ++ cat /tmp/tmp.BiVVp1Geq4 ++ rm /tmp/tmp.gAdopMTKDT /tmp/tmp.BiVVp1Geq4 ++ return 0 + client_pod=pxc-client-59944c5bbf-vfksl + wait_pod pxc-client-59944c5bbf-vfksl + local pod=pxc-client-59944c5bbf-vfksl + local max_retry=480 + local ns= ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' ++ echo pxc-client-59944c5bbf-vfksl + local container= + set +o xtrace pod/pxc-client-59944c5bbf-vfksl condition met waiting for pod/pxc-client-59944c5bbf-vfksl to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + '[' '!' -s /tmp/tmp.ScuwUWx5LO/user-four-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-four-1.sql /tmp/tmp.ScuwUWx5LO/user-four-1.sql + compare_mysql_cmd user-four-4 'SHOW GRANTS FOR '\''user-four'\''@'\''%'\'';' '-h some-name-haproxy -uroot -proot_password' + local command_id=user-four-4 + local 'command=SHOW GRANTS FOR '\''user-four'\''@'\''%'\'';' + local 'uri=-h some-name-haproxy -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-four-4.sql + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.4 ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 8\.0 ]] + [[ -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-four-4-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SHOW GRANTS FOR '\''user-four'\''@'\''%'\'';' '-h some-name-haproxy -uroot -proot_password' + local 'command=SHOW GRANTS FOR '\''user-four'\''@'\''%'\'';' + local 'uri=-h some-name-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.bGh60gfPH9 +++ mktemp ++ local LAST_ERR=/tmp/tmp.s2XTq9K6HB ++ 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.bGh60gfPH9 ++ cat /tmp/tmp.s2XTq9K6HB ++ rm /tmp/tmp.bGh60gfPH9 /tmp/tmp.s2XTq9K6HB ++ return 0 + client_pod=pxc-client-59944c5bbf-vfksl + wait_pod pxc-client-59944c5bbf-vfksl + local pod=pxc-client-59944c5bbf-vfksl + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-vfksl ++ egrep '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-vfksl condition met waiting for pod/pxc-client-59944c5bbf-vfksl to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + '[' '!' -s /tmp/tmp.ScuwUWx5LO/user-four-4.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-four-4.sql /tmp/tmp.ScuwUWx5LO/user-four-4.sql + desc 'check new user created after updated user name via CR' + set +o xtrace ----------------------------------------------------------------------------------- check new user created after updated user name via CR ----------------------------------------------------------------------------------- + kubectl_bin patch pxc some-name --type=merge '-p={ "spec": {"users":[ { "name":"user-five", "dbs": ["db1", "db2", "db3"], "grants":["SELECT, UPDATE, DELETE"], "hosts": ["%"] } ]} }' ++ mktemp + local LAST_OUT=/tmp/tmp.gUKC7ZcANx ++ mktemp + local LAST_ERR=/tmp/tmp.Dxn9m8cvuk + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl patch pxc some-name --type=merge '-p={ "spec": {"users":[ { "name":"user-five", "dbs": ["db1", "db2", "db3"], "grants":["SELECT, UPDATE, DELETE"], "hosts": ["%"] } ]} }' + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.gUKC7ZcANx perconaxtradbcluster.pxc.percona.com/some-name patched + cat /tmp/tmp.Dxn9m8cvuk + rm /tmp/tmp.gUKC7ZcANx /tmp/tmp.Dxn9m8cvuk + return 0 + wait_cluster_consistency some-name 3 3 + local cluster_name=some-name + local cluster_size=3 + local proxy_size=3 + '[' -z 3 ']' + desc 'wait cluster consistency' + set +o xtrace ----------------------------------------------------------------------------------- wait cluster consistency ----------------------------------------------------------------------------------- + local i=0 + local max=300 + sleep 7 + echo -n 'waiting for pxc/some-name to be ready' waiting for pxc/some-name to be ready++ kubectl_bin get pxc some-name -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.gd5oRFf4YX +++ mktemp ++ local LAST_ERR=/tmp/tmp.Zw1lUdZi1s ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.gd5oRFf4YX ++ cat /tmp/tmp.Zw1lUdZi1s ++ rm /tmp/tmp.gd5oRFf4YX /tmp/tmp.Zw1lUdZi1s ++ return 0 + [[ ready == \r\e\a\d\y ]] ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.pxc.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.nDfbVEP7PI +++ mktemp ++ local LAST_ERR=/tmp/tmp.oBcwnaW9ur ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.pxc.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.nDfbVEP7PI ++ cat /tmp/tmp.oBcwnaW9ur ++ rm /tmp/tmp.nDfbVEP7PI /tmp/tmp.oBcwnaW9ur ++ return 0 + [[ 3 == \3 ]] +++ get_proxy_engine some-name +++ local cluster_name=some-name ++++ get_proxy some-name ++++ local target_cluster=some-name +++++ kubectl_bin get pxc some-name -o 'jsonpath={.spec.haproxy.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.NEtK0LPuMO ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.p2Ft7Ndyyv +++++ local exit_status=0 ++++++ seq 0 2 +++++ for i in '$(seq 0 2)' +++++ set +e +++++ kubectl get pxc some-name -o 'jsonpath={.spec.haproxy.enabled}' +++++ exit_status=0 +++++ set -e +++++ '[' 0 '!=' 0 ']' +++++ break +++++ cat /tmp/tmp.NEtK0LPuMO +++++ cat /tmp/tmp.p2Ft7Ndyyv +++++ rm /tmp/tmp.NEtK0LPuMO /tmp/tmp.p2Ft7Ndyyv +++++ return 0 ++++ [[ true == \t\r\u\e ]] ++++ echo some-name-haproxy ++++ return +++ local cluster_proxy=some-name-haproxy +++ echo haproxy ++ kubectl_bin get pxc some-name -o 'jsonpath={.status.haproxy.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.w0RdiDXc26 +++ mktemp ++ local LAST_ERR=/tmp/tmp.Eovf0Vc9Br ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc some-name -o 'jsonpath={.status.haproxy.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.w0RdiDXc26 ++ cat /tmp/tmp.Eovf0Vc9Br ++ rm /tmp/tmp.w0RdiDXc26 /tmp/tmp.Eovf0Vc9Br ++ return 0 + [[ 3 == \3 ]] + echo ++ base64 -d ++ kubectl_bin get secret some-name-custom-user-secret -o 'jsonpath={.data.user-five}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.bghM5PULXy +++ mktemp ++ local LAST_ERR=/tmp/tmp.0njU16yc85 ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get secret some-name-custom-user-secret -o 'jsonpath={.data.user-five}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.bghM5PULXy ++ cat /tmp/tmp.0njU16yc85 ++ rm /tmp/tmp.bghM5PULXy /tmp/tmp.0njU16yc85 ++ return 0 + userFivePass='[e!I)oIl7%IRSzJp}' + compare_mysql_user '-h some-name-haproxy -uuser-five -p'\''[e!I)oIl7%IRSzJp}'\''' + local 'uri=-h some-name-haproxy -uuser-five -p'\''[e!I)oIl7%IRSzJp}'\''' + local postfix= ++ echo -h some-name-haproxy -uuser-five '-p'\''[e!I)oIl7%IRSzJp}'\''' ++ sed -e 's/.*-u//; s/ .*//' + local user=user-five + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-five.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-2202/e2e-tests/custom-users/compare/user-five-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SHOW GRANTS;' '-h some-name-haproxy -uuser-five -p'\''[e!I)oIl7%IRSzJp}'\''' + /usr/bin/sed -E 's/'\''(10|192)[.][0-9][^'\'']*'\''//; s/'\''[^'\'']*[.]internal'\''//' + local 'command=SHOW GRANTS;' + local 'uri=-h some-name-haproxy -uuser-five -p'\''[e!I)oIl7%IRSzJp}'\''' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.JXu0LUcj6J +++ mktemp ++ local LAST_ERR=/tmp/tmp.mhVMHYyZvu ++ 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.JXu0LUcj6J ++ cat /tmp/tmp.mhVMHYyZvu ++ rm /tmp/tmp.JXu0LUcj6J /tmp/tmp.mhVMHYyZvu ++ return 0 + client_pod=pxc-client-59944c5bbf-vfksl + wait_pod pxc-client-59944c5bbf-vfksl + local pod=pxc-client-59944c5bbf-vfksl + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-vfksl ++ egrep '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-vfksl condition met waiting for pod/pxc-client-59944c5bbf-vfksl to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-five.sql /tmp/tmp.ScuwUWx5LO/user-five.sql + compare_mysql_cmd user-five-1 'SELECT User, Host from mysql.user WHERE User = '\''user-five'\'';' '-h some-name-haproxy -uroot -proot_password' + local command_id=user-five-1 + local 'command=SELECT User, Host from mysql.user WHERE User = '\''user-five'\'';' + local 'uri=-h some-name-haproxy -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-five-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-2202/e2e-tests/custom-users/compare/user-five-1-80.sql ]] + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 =~ 5\.7 ]] + run_mysql 'SELECT User, Host from mysql.user WHERE User = '\''user-five'\'';' '-h some-name-haproxy -uroot -proot_password' + local 'command=SELECT User, Host from mysql.user WHERE User = '\''user-five'\'';' + local 'uri=-h some-name-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.RSfEw5UU5H +++ mktemp ++ local LAST_ERR=/tmp/tmp.Luf2bFjFVY ++ 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.RSfEw5UU5H ++ cat /tmp/tmp.Luf2bFjFVY ++ rm /tmp/tmp.RSfEw5UU5H /tmp/tmp.Luf2bFjFVY ++ return 0 + client_pod=pxc-client-59944c5bbf-vfksl + wait_pod pxc-client-59944c5bbf-vfksl + local pod=pxc-client-59944c5bbf-vfksl + local max_retry=480 + local ns= ++ echo pxc-client-59944c5bbf-vfksl ++ egrep '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container= + set +o xtrace pod/pxc-client-59944c5bbf-vfksl condition met waiting for pod/pxc-client-59944c5bbf-vfksl to become ReadyDefaulted container "pxc-client" out of: pxc-client, backup .Ok + set +o xtrace + '[' '!' -s /tmp/tmp.ScuwUWx5LO/user-five-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-2202/e2e-tests/custom-users/compare/user-five-1.sql /tmp/tmp.ScuwUWx5LO/user-five-1.sql + destroy custom-users-13629 + local namespace=custom-users-13629 + 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 + /usr/bin/sed -r 's/"ts":[0-9.]+//; s^limits-[0-9.]+/^^g' + tee /tmp/tmp.ScuwUWx5LO/operator.log + grep -v 'get backup status: Job.batch' + sort -u + grep -v 'the object has been modified' ++ 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.RUmI2YSQrx +++ mktemp ++ local LAST_ERR=/tmp/tmp.hJngBOfy5i ++ 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.RUmI2YSQrx ++ cat /tmp/tmp.hJngBOfy5i ++ rm /tmp/tmp.RUmI2YSQrx /tmp/tmp.hJngBOfy5i ++ return 0 + kubectl_bin logs -n pxc-operator percona-xtradb-cluster-operator-d84c66648-66srf ++ mktemp + local LAST_OUT=/tmp/tmp.xZNJ3CbgiN ++ mktemp + local LAST_ERR=/tmp/tmp.HuoZB1yAdK + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl logs -n pxc-operator percona-xtradb-cluster-operator-d84c66648-66srf + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.xZNJ3CbgiN + cat /tmp/tmp.HuoZB1yAdK + rm /tmp/tmp.xZNJ3CbgiN /tmp/tmp.HuoZB1yAdK + return 0 2025-10-08T22:33:28.364Z INFO setup Manager starting up {"gitCommit": "c5e2e681577ec5135cf7e4f3a99405aadfebe3aa", "gitBranch": "PR-2202-c5e2e681", "buildTime": "2025-10-08T22:13:19Z", "goVersion": "go1.24.8", "os": "linux", "arch": "amd64"} 2025-10-08T22:33:28.364Z INFO setup Runs on {"platform": "kubernetes", "version": "v1.31.13-gke.1008000"} 2025-10-08T22:33:28.367Z INFO setup Registering Components. 2025-10-08T22:33:32.658Z INFO controller-runtime.metrics Serving metrics server {"bindAddress": ":8080", "secure": false} 2025-10-08T22:33:32.658Z INFO controller-runtime.metrics Starting metrics server 2025-10-08T22:33:32.658Z INFO controller-runtime.webhook Registering webhook {"path": "/validate-percona-xtradbcluster"} 2025-10-08T22:33:32.658Z INFO setup Starting the Cmd. 2025-10-08T22:33:32.659Z 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-10-08T22:33:32.659Z 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-10-08T22:33:32.659Z INFO controller-runtime.webhook Serving webhook server {"host": "", "port": 9443} 2025-10-08T22:33:32.659Z INFO controller-runtime.webhook Starting webhook server 2025-10-08T22:33:32.659Z INFO starting server {"name": "health probe", "addr": "[::]:8081"} 2025-10-08T22:33:32.760Z INFO attempting to acquire leader lease pxc-operator/08db1feb.percona.com... 2025-10-08T22:33:32.790Z DEBUG events percona-xtradb-cluster-operator-d84c66648-66srf_0361ca21-2c6c-4364-a569-8dd101235beb became leader {"type": "Normal", "object": {"kind":"Lease","namespace":"pxc-operator","name":"08db1feb.percona.com","uid":"82b5c972-6c83-46f2-9536-454bf4964ceb","apiVersion":"coordination.k8s.io/v1","resourceVersion":"1759962812784367009"}, "reason": "LeaderElection"} 2025-10-08T22:33:32.790Z INFO Starting EventSource {"controller": "pxcbackup-controller", "source": "kind source: *v1.PerconaXtraDBClusterBackup"} 2025-10-08T22:33:32.790Z INFO Starting EventSource {"controller": "pxc-controller", "source": "kind source: *v1.PerconaXtraDBCluster"} 2025-10-08T22:33:32.790Z INFO Starting EventSource {"controller": "pxc-controller", "source": "kind source: *v1.Secret"} 2025-10-08T22:33:32.790Z INFO Starting EventSource {"controller": "pxcrestore-controller", "source": "kind source: *v1.PerconaXtraDBClusterRestore"} 2025-10-08T22:33:32.790Z INFO successfully acquired lease pxc-operator/08db1feb.percona.com 2025-10-08T22:33:32.891Z INFO Starting Controller {"controller": "pxcbackup-controller"} 2025-10-08T22:33:32.891Z INFO Starting Controller {"controller": "pxc-controller"} 2025-10-08T22:33:32.891Z INFO Starting Controller {"controller": "pxcrestore-controller"} 2025-10-08T22:33:32.891Z INFO Starting workers {"controller": "pxcbackup-controller", "worker count": 1} 2025-10-08T22:33:32.891Z INFO Starting workers {"controller": "pxc-controller", "worker count": 1} 2025-10-08T22:33:32.891Z INFO Starting workers {"controller": "pxcrestore-controller", "worker count": 1} 2025-10-08T22:34:22.977Z INFO Set CR version {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "b806b88b-6b2e-482a-8682-4767a012d7b1", "version": "1.19.0"} 2025-10-08T22:34:23.316Z DEBUG Creating object {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "b806b88b-6b2e-482a-8682-4767a012d7b1", "object": "auto-some-name-pxc", "kind": "&TypeMeta{Kind:ConfigMap,APIVersion:v1,}"} 2025-10-08T22:34:23.433Z DEBUG Creating object {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "b806b88b-6b2e-482a-8682-4767a012d7b1", "object": "some-name-haproxy", "kind": "&TypeMeta{Kind:StatefulSet,APIVersion:apps/v1,}"} 2025-10-08T22:34:23.483Z DEBUG Creating object {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "b806b88b-6b2e-482a-8682-4767a012d7b1", "object": "some-name-pxc", "kind": "&TypeMeta{Kind:StatefulSet,APIVersion:apps/v1,}"} 2025-10-08T22:34:23.525Z DEBUG Creating object {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "b806b88b-6b2e-482a-8682-4767a012d7b1", "object": "some-name-pxc", "kind": "&TypeMeta{Kind:Service,APIVersion:v1,}"} 2025-10-08T22:34:23.562Z DEBUG Creating object {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "b806b88b-6b2e-482a-8682-4767a012d7b1", "object": "some-name-pxc-unready", "kind": "&TypeMeta{Kind:Service,APIVersion:v1,}"} 2025-10-08T22:34:23.654Z DEBUG Creating object {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "b806b88b-6b2e-482a-8682-4767a012d7b1", "object": "some-name-haproxy", "kind": "&TypeMeta{Kind:Service,APIVersion:v1,}"} 2025-10-08T22:34:23.789Z DEBUG Creating object {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "b806b88b-6b2e-482a-8682-4767a012d7b1", "object": "some-name-haproxy-replicas", "kind": "&TypeMeta{Kind:Service,APIVersion:v1,}"} 2025-10-08T22:34:24.680Z DEBUG Creating object {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "e44fba9c-e160-43ec-8e84-21e2df2f8a29", "object": "some-name-pxc", "kind": "&TypeMeta{Kind:PodDisruptionBudget,APIVersion:policy/v1,}"} 2025-10-08T22:34:24.701Z DEBUG Creating object {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "e44fba9c-e160-43ec-8e84-21e2df2f8a29", "object": "some-name-haproxy", "kind": "&TypeMeta{Kind:PodDisruptionBudget,APIVersion:policy/v1,}"} 2025-10-08T22:35:41.115Z INFO Password expiration policy updated {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "ff9d0556-13f9-4460-ba13-503f1a61e405", "user": "operator"} 2025-10-08T22:35:41.167Z INFO Password expiration policy updated {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "ff9d0556-13f9-4460-ba13-503f1a61e405", "user": "monitor"} 2025-10-08T22:35:41.237Z INFO User monitor: granted privileges {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "ff9d0556-13f9-4460-ba13-503f1a61e405"} 2025-10-08T22:35:41.286Z INFO monitor user privileges granted {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "ff9d0556-13f9-4460-ba13-503f1a61e405"} 2025-10-08T22:35:41.330Z INFO Password expiration policy updated {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "ff9d0556-13f9-4460-ba13-503f1a61e405", "user": "xtrabackup"} 2025-10-08T22:35:41.372Z INFO User xtrabackup: granted privileges {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "ff9d0556-13f9-4460-ba13-503f1a61e405"} 2025-10-08T22:35:41.428Z INFO Password expiration policy updated {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "ff9d0556-13f9-4460-ba13-503f1a61e405", "user": "replication"} 2025-10-08T22:38:03.957Z INFO Password expiration policy updated {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "6c495ce9-b902-4193-86ef-3d20e3d22a6c", "user": "root"} 2025-10-08T22:38:04.001Z INFO Creating/updating user {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "6c495ce9-b902-4193-86ef-3d20e3d22a6c", "user": "user-one"} 2025-10-08T22:38:04.001Z INFO User not created {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "6c495ce9-b902-4193-86ef-3d20e3d22a6c", "user": "user-one"} 2025-10-08T22:38:04.100Z INFO Creating/updating user {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "6c495ce9-b902-4193-86ef-3d20e3d22a6c", "user": "user-two"} 2025-10-08T22:38:04.100Z INFO User created/updated {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "6c495ce9-b902-4193-86ef-3d20e3d22a6c", "user": "user-one"} 2025-10-08T22:38:04.100Z INFO User not created {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "6c495ce9-b902-4193-86ef-3d20e3d22a6c", "user": "user-two"} 2025-10-08T22:38:04.176Z INFO User created/updated {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "6c495ce9-b902-4193-86ef-3d20e3d22a6c", "user": "user-two"} 2025-10-08T22:38:04.215Z INFO Created custom user secrets {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "6c495ce9-b902-4193-86ef-3d20e3d22a6c", "secrets": "my-cluster-secrets"} 2025-10-08T22:38:04.215Z INFO Creating/updating user {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "6c495ce9-b902-4193-86ef-3d20e3d22a6c", "user": "user-three"} 2025-10-08T22:38:04.215Z INFO User not created {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "6c495ce9-b902-4193-86ef-3d20e3d22a6c", "user": "user-three"} 2025-10-08T22:38:04.242Z INFO User created/updated {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "6c495ce9-b902-4193-86ef-3d20e3d22a6c", "user": "user-three"} 2025-10-08T22:38:04.307Z INFO update PXC version (fetched from db) {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "6c495ce9-b902-4193-86ef-3d20e3d22a6c", "new version": "8.0.43-34.1"} 2025-10-08T22:40:28.959Z INFO User password changed {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "05a0c069-d6d2-4163-a6fd-47b4c006c901", "user": "user-one"} 2025-10-08T22:40:29.003Z INFO User password updated {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "05a0c069-d6d2-4163-a6fd-47b4c006c901", "user": "user-one"} 2025-10-08T22:41:08.956Z INFO User password changed {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "65467c10-4944-496a-aeca-d7f22ef85d93", "user": "user-two"} 2025-10-08T22:41:08.990Z INFO User password updated {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "65467c10-4944-496a-aeca-d7f22ef85d93", "user": "user-two"} 2025-10-08T22:41:28.687Z INFO Creating/updating user {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "47d22e64-9130-41f1-ace9-3ac263ef950d", "user": "user-four"} 2025-10-08T22:41:28.687Z INFO User not created {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "47d22e64-9130-41f1-ace9-3ac263ef950d", "user": "user-four"} 2025-10-08T22:41:28.737Z INFO User created/updated {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "47d22e64-9130-41f1-ace9-3ac263ef950d", "user": "user-four"} 2025-10-08T22:42:08.520Z INFO Creating/updating user {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "b8ed4800-1885-4591-bdca-f07ce567ba9c", "user": "user-four"} 2025-10-08T22:42:08.520Z INFO DBs changed {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "b8ed4800-1885-4591-bdca-f07ce567ba9c", "current": {"db1":{},"db2":{}}, "desired": ["db1", "db2", "db3"], "user": "user-four"} 2025-10-08T22:42:08.577Z INFO User created/updated {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "b8ed4800-1885-4591-bdca-f07ce567ba9c", "user": "user-four"} 2025-10-08T22:42:26.720Z INFO controller-runtime.cache Warning: watch ended with error {"reflector": "pkg/mod/k8s.io/client-go@v0.34.1/tools/cache/reflector.go:290", "type": "*v1.Event", "err": "very short watch: pkg/mod/k8s.io/client-go@v0.34.1/tools/cache/reflector.go:290: Unexpected watch close - watch lasted less than a second and no items received"} 2025-10-08T22:42:27.740Z INFO Creating/updating user {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "535e1751-af27-4056-bbd3-d96076f80250", "user": "user-four"} 2025-10-08T22:42:27.740Z INFO Grant not present in current grants {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "535e1751-af27-4056-bbd3-d96076f80250", "grant": "SELECT, UPDATE, DELETE", "user": "user-four"} 2025-10-08T22:42:27.805Z INFO User created/updated {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "535e1751-af27-4056-bbd3-d96076f80250", "user": "user-four"} 2025-10-08T22:43:04.662Z INFO Creating/updating user {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "f05ef256-414a-4c71-b414-b96b4de773d1", "user": "user-four"} 2025-10-08T22:43:04.662Z INFO User not created {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "f05ef256-414a-4c71-b414-b96b4de773d1", "user": "user-four"} 2025-10-08T22:43:04.715Z INFO User created/updated {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "f05ef256-414a-4c71-b414-b96b4de773d1", "user": "user-four"} 2025-10-08T22:43:48.184Z INFO Creating/updating user {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "c22c3d06-8425-448b-a4b9-d55c4519fee7", "user": "user-four"} 2025-10-08T22:43:48.184Z INFO Grant not present in current grants {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "c22c3d06-8425-448b-a4b9-d55c4519fee7", "grant": "SELECT, UPDATE, DELETE", "user": "user-four"} 2025-10-08T22:43:48.240Z INFO User created/updated {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "c22c3d06-8425-448b-a4b9-d55c4519fee7", "user": "user-four"} 2025-10-08T22:43:53.560Z INFO Creating/updating user {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "e2300ae1-d89a-41e7-82be-72a43f3903f0", "user": "user-four"} 2025-10-08T22:43:53.560Z INFO Grant not present in current grants {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "e2300ae1-d89a-41e7-82be-72a43f3903f0", "grant": "SELECT, UPDATE, DELETE", "user": "user-four"} 2025-10-08T22:43:53.615Z INFO User created/updated {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "e2300ae1-d89a-41e7-82be-72a43f3903f0", "user": "user-four"} 2025-10-08T22:43:58.965Z INFO Creating/updating user {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "e414f0a1-2dd7-4d34-a214-8138c9058c41", "user": "user-four"} 2025-10-08T22:43:58.965Z INFO Grant not present in current grants {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "e414f0a1-2dd7-4d34-a214-8138c9058c41", "grant": "SELECT, UPDATE, DELETE", "user": "user-four"} 2025-10-08T22:43:59.031Z INFO User created/updated {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "e414f0a1-2dd7-4d34-a214-8138c9058c41", "user": "user-four"} 2025-10-08T22:44:04.338Z INFO Creating/updating user {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "78f7fe58-0fc0-41a6-9af2-1f755e59be69", "user": "user-four"} 2025-10-08T22:44:04.338Z INFO Grant not present in current grants {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "78f7fe58-0fc0-41a6-9af2-1f755e59be69", "grant": "SELECT, UPDATE, DELETE", "user": "user-four"} 2025-10-08T22:44:04.401Z INFO User created/updated {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "78f7fe58-0fc0-41a6-9af2-1f755e59be69", "user": "user-four"} 2025-10-08T22:44:09.909Z INFO Creating/updating user {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "baacadaf-a37b-4400-9504-bf0a4cffc35c", "user": "user-four"} 2025-10-08T22:44:09.909Z INFO Grant not present in current grants {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "baacadaf-a37b-4400-9504-bf0a4cffc35c", "grant": "SELECT, UPDATE, DELETE", "user": "user-four"} 2025-10-08T22:44:09.973Z INFO User created/updated {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "baacadaf-a37b-4400-9504-bf0a4cffc35c", "user": "user-four"} 2025-10-08T22:44:15.271Z INFO Creating/updating user {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "4ee66ce5-16b7-4b9b-8218-8d5ebf61a4a5", "user": "user-four"} 2025-10-08T22:44:15.271Z INFO Grant not present in current grants {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "4ee66ce5-16b7-4b9b-8218-8d5ebf61a4a5", "grant": "SELECT, UPDATE, DELETE", "user": "user-four"} 2025-10-08T22:44:15.327Z INFO User created/updated {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "4ee66ce5-16b7-4b9b-8218-8d5ebf61a4a5", "user": "user-four"} 2025-10-08T22:44:16.209Z INFO Creating/updating user {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "d702c4ef-c8ef-43de-970d-9290d83bfccc", "user": "user-five"} 2025-10-08T22:44:16.209Z INFO User not created {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "d702c4ef-c8ef-43de-970d-9290d83bfccc", "user": "user-five"} 2025-10-08T22:44:16.273Z INFO User created/updated {"controller": "pxc-controller", "namespace": "custom-users-13629", "name": "some-name", "reconcileID": "d702c4ef-c8ef-43de-970d-9290d83bfccc", "user": "user-five"} + xargs -L 1 sh -xc 'kubectl patch pxc -n $0 $1 --type=merge -p "{\"metadata\":{\"finalizers\":[]}}"' + kubectl get pxc --all-namespaces -o wide + grep -v NAMESPACE + kubectl patch pxc -n custom-users-13629 some-name --type=merge -p '{"metadata":{"finalizers":[]}}' perconaxtradbcluster.pxc.percona.com/some-name patched + kubectl_bin delete pxc --all --all-namespaces ++ mktemp + local LAST_OUT=/tmp/tmp.8q81yKOlwK ++ mktemp + local LAST_ERR=/tmp/tmp.KgOD6ZEV4u + 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.8q81yKOlwK perconaxtradbcluster.pxc.percona.com "some-name" deleted from custom-users-13629 namespace + cat /tmp/tmp.KgOD6ZEV4u + rm /tmp/tmp.8q81yKOlwK /tmp/tmp.KgOD6ZEV4u + return 0 + kubectl_bin delete pxc-backup --all --all-namespaces ++ mktemp + local LAST_OUT=/tmp/tmp.ZDFv9FSv5x ++ mktemp + local LAST_ERR=/tmp/tmp.0dF8UTDGTv + 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.ZDFv9FSv5x No resources found + cat /tmp/tmp.0dF8UTDGTv + rm /tmp/tmp.ZDFv9FSv5x /tmp/tmp.0dF8UTDGTv + return 0 + kubectl_bin delete pxc-restore --all --all-namespaces ++ mktemp + local LAST_OUT=/tmp/tmp.LKfvXeLfGu ++ mktemp + local LAST_ERR=/tmp/tmp.IrA6TFqhKE + 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.LKfvXeLfGu No resources found + cat /tmp/tmp.IrA6TFqhKE + rm /tmp/tmp.LKfvXeLfGu /tmp/tmp.IrA6TFqhKE + return 0 + kubectl_bin delete ValidatingWebhookConfiguration percona-xtradbcluster-webhook ++ mktemp + local LAST_OUT=/tmp/tmp.1vTgwDoVZY ++ mktemp + local LAST_ERR=/tmp/tmp.OWrAtICPSL + 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.1vTgwDoVZY validatingwebhookconfiguration.admissionregistration.k8s.io "percona-xtradbcluster-webhook" deleted + cat /tmp/tmp.OWrAtICPSL + rm /tmp/tmp.1vTgwDoVZY /tmp/tmp.OWrAtICPSL + 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 custom-users-13629 + rm -rf /tmp/tmp.ScuwUWx5LO ++ mktemp + kubectl_bin delete --grace-period=0 --force=true namespace pxc-operator ++ mktemp + local LAST_OUT=/tmp/tmp.EQ93gtUwfg ++ mktemp + desc 'test passed' + set +o xtrace ----------------------------------------------------------------------------------- + local LAST_OUT=/tmp/tmp.ffpamnOfYK test passed ----------------------------------------------------------------------------------- ++ mktemp + local LAST_ERR=/tmp/tmp.EzoJdA7Jy1 + local exit_status=0 ++ seq 0 2 + local LAST_ERR=/tmp/tmp.OmU5Q0E2Ke + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl delete --grace-period=0 --force=true namespace custom-users-13629 + for i in '$(seq 0 2)' + set +e + kubectl delete --grace-period=0 --force=true namespace pxc-operator