Log: /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/logs/upgrade-proxysql-5-7.log WARNING: version difference between client (1.32) and server (1.28) exceeds the supported minor version skew of +/-1 WARNING: version difference between client (1.32) and server (1.28) exceeds the supported minor version skew of +/-1 + CLUSTER=upgrade-proxysql + CLUSTER_SIZE=3 + TARGET_OPERATOR_VER=1.16.0 + TARGET_IMAGE=perconalab/percona-xtradb-cluster-operator:PR-1697-26afa527 + TARGET_IMAGE_PXC=perconalab/percona-xtradb-cluster-operator:main-pxc5.7 + TARGET_IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest + TARGET_IMAGE_PROXY=perconalab/percona-xtradb-cluster-operator:main-proxysql + TARGET_IMAGE_HAPROXY=perconalab/percona-xtradb-cluster-operator:main-haproxy + TARGET_IMAGE_BACKUP=perconalab/percona-xtradb-cluster-operator:main-pxc5.7-backup + [[ perconalab/percona-xtradb-cluster-operator:main-pxc5.7 == *\p\e\r\c\o\n\a\-\x\t\r\a\d\b\-\c\l\u\s\t\e\r\-\o\p\e\r\a\t\o\r* ]] ++ echo -n perconalab/percona-xtradb-cluster-operator:main-pxc5.7 ++ /usr/bin/sed -r 's/.*([0-9].[0-9])$/\1/' + PXC_VER=5.7 ++ curl -s https://check.percona.com/versions/v1/pxc-operator ++ jq -r '.versions[].operator' ++ sort -V ++ tail -n1 + INIT_OPERATOR_VER=1.16.0 + [[ 1.16.0 == \1\.\1\6\.\0 ]] ++ curl -s https://check.percona.com/versions/v1/pxc-operator ++ tail -n2 ++ sort -V ++ head -n1 ++ jq -r '.versions[].operator' + INIT_OPERATOR_VER=1.15.1 + GIT_TAG=v1.15.1 ++ curl -s 'https://check.percona.com/versions/v1/pxc-operator/1.15.1/latest?databaseVersion=5.7' + INIT_OPERATOR_IMAGES='{"versions":[{"product":"pxc-operator","operator":"1.15.1","matrix":{"mongod":{},"pxc":{"5.7.44-31.65":{"imagePath":"percona/percona-xtradb-cluster:5.7.44-31.65","imageHash":"36fafdef46485839d4ff7c6dc73b4542b07031644c0152e911acb9734ff2be85","imageHashArm64":"","status":"recommended","critical":false}},"pmm":{"2.42.0":{"imagePath":"percona/pmm-client:2.42.0","imageHash":"14cb96de47e3bc239bf285f22ec6f170b4a1181301b19100f5b7dc22c210bf8c","imageHashArm64":"","status":"recommended","critical":false}},"proxysql":{"2.5.5":{"imagePath":"percona/proxysql2:2.5.5","imageHash":"d95b0c6782447fef22adea3e8b8143e79a6a757666ffd34a8c3eddd9f82d629c","imageHashArm64":"","status":"recommended","critical":false}},"haproxy":{"2.8.5":{"imagePath":"percona/haproxy:2.8.5","imageHash":"941f3bd0977bff9145e904bf8f8298a1a024d7f03152edaea0cf65fd1c137340","imageHashArm64":"","status":"recommended","critical":false}},"backup":{"2.4.29":{"imagePath":"percona/percona-xtradb-cluster-operator:1.15.1-pxc5.7-backup-pxb2.4.29","imageHash":"dfe6545b83b18450a3243441e6b43c3a6ed05dcc24a464286ffb9a7328fdb13f","imageHashArm64":"","status":"recommended","critical":false}},"operator":{"1.15.1":{"imagePath":"percona/percona-xtradb-cluster-operator:1.15.1","imageHash":"16a0078b5ededc4ae346168ee005aedf17f9ddddebf1eca067244d2f907bb7fa","imageHashArm64":"862c0be9f278aed33c521dabb55986b33da5eddb52cc99e205c7bb8feac9b22f","status":"recommended","critical":false}},"logCollector":{"1.15.1":{"imagePath":"percona/percona-xtradb-cluster-operator:1.15.1-logcollector-fluentbit3.1.4","imageHash":"24b068d55559cbe5dbadc2f52e5c096f7df60374e47c6b4d1a5e331fd2a75014","imageHashArm64":"","status":"recommended","critical":false}},"postgresql":{},"pgbackrest":{},"pgbackrestRepo":{},"pgbadger":{},"pgbouncer":{},"pxcOperator":{},"psmdbOperator":{},"pgOperatorApiserver":{},"pgOperatorEvent":{},"pgOperatorRmdata":{},"pgOperatorScheduler":{},"pgOperator":{},"pgOperatorDeployer":{},"psOperator":{},"mysql":{},"router":{},"orchestrator":{},"toolkit":{},"postgis":{}}}]}' + OPERATOR_NAME=percona-xtradb-cluster-operator ++ jq -r '.versions[].matrix.operator[].imagePath' ++ echo '{"versions":[{"product":"pxc-operator","operator":"1.15.1","matrix":{"mongod":{},"pxc":{"5.7.44-31.65":{"imagePath":"percona/percona-xtradb-cluster:5.7.44-31.65","imageHash":"36fafdef46485839d4ff7c6dc73b4542b07031644c0152e911acb9734ff2be85","imageHashArm64":"","status":"recommended","critical":false}},"pmm":{"2.42.0":{"imagePath":"percona/pmm-client:2.42.0","imageHash":"14cb96de47e3bc239bf285f22ec6f170b4a1181301b19100f5b7dc22c210bf8c","imageHashArm64":"","status":"recommended","critical":false}},"proxysql":{"2.5.5":{"imagePath":"percona/proxysql2:2.5.5","imageHash":"d95b0c6782447fef22adea3e8b8143e79a6a757666ffd34a8c3eddd9f82d629c","imageHashArm64":"","status":"recommended","critical":false}},"haproxy":{"2.8.5":{"imagePath":"percona/haproxy:2.8.5","imageHash":"941f3bd0977bff9145e904bf8f8298a1a024d7f03152edaea0cf65fd1c137340","imageHashArm64":"","status":"recommended","critical":false}},"backup":{"2.4.29":{"imagePath":"percona/percona-xtradb-cluster-operator:1.15.1-pxc5.7-backup-pxb2.4.29","imageHash":"dfe6545b83b18450a3243441e6b43c3a6ed05dcc24a464286ffb9a7328fdb13f","imageHashArm64":"","status":"recommended","critical":false}},"operator":{"1.15.1":{"imagePath":"percona/percona-xtradb-cluster-operator:1.15.1","imageHash":"16a0078b5ededc4ae346168ee005aedf17f9ddddebf1eca067244d2f907bb7fa","imageHashArm64":"862c0be9f278aed33c521dabb55986b33da5eddb52cc99e205c7bb8feac9b22f","status":"recommended","critical":false}},"logCollector":{"1.15.1":{"imagePath":"percona/percona-xtradb-cluster-operator:1.15.1-logcollector-fluentbit3.1.4","imageHash":"24b068d55559cbe5dbadc2f52e5c096f7df60374e47c6b4d1a5e331fd2a75014","imageHashArm64":"","status":"recommended","critical":false}},"postgresql":{},"pgbackrest":{},"pgbackrestRepo":{},"pgbadger":{},"pgbouncer":{},"pxcOperator":{},"psmdbOperator":{},"pgOperatorApiserver":{},"pgOperatorEvent":{},"pgOperatorRmdata":{},"pgOperatorScheduler":{},"pgOperator":{},"pgOperatorDeployer":{},"psOperator":{},"mysql":{},"router":{},"orchestrator":{},"toolkit":{},"postgis":{}}}]}' + IMAGE=percona/percona-xtradb-cluster-operator:1.15.1 ++ echo perconalab/percona-xtradb-cluster-operator:PR-1697-26afa527 ++ cut -d/ -f1 + [[ perconalab == \p\e\r\c\o\n\a\l\a\b ]] + IMAGE=perconalab/percona-xtradb-cluster-operator:1.15.1 ++ echo '{"versions":[{"product":"pxc-operator","operator":"1.15.1","matrix":{"mongod":{},"pxc":{"5.7.44-31.65":{"imagePath":"percona/percona-xtradb-cluster:5.7.44-31.65","imageHash":"36fafdef46485839d4ff7c6dc73b4542b07031644c0152e911acb9734ff2be85","imageHashArm64":"","status":"recommended","critical":false}},"pmm":{"2.42.0":{"imagePath":"percona/pmm-client:2.42.0","imageHash":"14cb96de47e3bc239bf285f22ec6f170b4a1181301b19100f5b7dc22c210bf8c","imageHashArm64":"","status":"recommended","critical":false}},"proxysql":{"2.5.5":{"imagePath":"percona/proxysql2:2.5.5","imageHash":"d95b0c6782447fef22adea3e8b8143e79a6a757666ffd34a8c3eddd9f82d629c","imageHashArm64":"","status":"recommended","critical":false}},"haproxy":{"2.8.5":{"imagePath":"percona/haproxy:2.8.5","imageHash":"941f3bd0977bff9145e904bf8f8298a1a024d7f03152edaea0cf65fd1c137340","imageHashArm64":"","status":"recommended","critical":false}},"backup":{"2.4.29":{"imagePath":"percona/percona-xtradb-cluster-operator:1.15.1-pxc5.7-backup-pxb2.4.29","imageHash":"dfe6545b83b18450a3243441e6b43c3a6ed05dcc24a464286ffb9a7328fdb13f","imageHashArm64":"","status":"recommended","critical":false}},"operator":{"1.15.1":{"imagePath":"percona/percona-xtradb-cluster-operator:1.15.1","imageHash":"16a0078b5ededc4ae346168ee005aedf17f9ddddebf1eca067244d2f907bb7fa","imageHashArm64":"862c0be9f278aed33c521dabb55986b33da5eddb52cc99e205c7bb8feac9b22f","status":"recommended","critical":false}},"logCollector":{"1.15.1":{"imagePath":"percona/percona-xtradb-cluster-operator:1.15.1-logcollector-fluentbit3.1.4","imageHash":"24b068d55559cbe5dbadc2f52e5c096f7df60374e47c6b4d1a5e331fd2a75014","imageHashArm64":"","status":"recommended","critical":false}},"postgresql":{},"pgbackrest":{},"pgbackrestRepo":{},"pgbadger":{},"pgbouncer":{},"pxcOperator":{},"psmdbOperator":{},"pgOperatorApiserver":{},"pgOperatorEvent":{},"pgOperatorRmdata":{},"pgOperatorScheduler":{},"pgOperator":{},"pgOperatorDeployer":{},"psOperator":{},"mysql":{},"router":{},"orchestrator":{},"toolkit":{},"postgis":{}}}]}' ++ jq -r '.versions[].matrix.pxc[].imagePath' + IMAGE_PXC=percona/percona-xtradb-cluster:5.7.44-31.65 ++ jq -r '.versions[].matrix.pmm[].imagePath' ++ echo '{"versions":[{"product":"pxc-operator","operator":"1.15.1","matrix":{"mongod":{},"pxc":{"5.7.44-31.65":{"imagePath":"percona/percona-xtradb-cluster:5.7.44-31.65","imageHash":"36fafdef46485839d4ff7c6dc73b4542b07031644c0152e911acb9734ff2be85","imageHashArm64":"","status":"recommended","critical":false}},"pmm":{"2.42.0":{"imagePath":"percona/pmm-client:2.42.0","imageHash":"14cb96de47e3bc239bf285f22ec6f170b4a1181301b19100f5b7dc22c210bf8c","imageHashArm64":"","status":"recommended","critical":false}},"proxysql":{"2.5.5":{"imagePath":"percona/proxysql2:2.5.5","imageHash":"d95b0c6782447fef22adea3e8b8143e79a6a757666ffd34a8c3eddd9f82d629c","imageHashArm64":"","status":"recommended","critical":false}},"haproxy":{"2.8.5":{"imagePath":"percona/haproxy:2.8.5","imageHash":"941f3bd0977bff9145e904bf8f8298a1a024d7f03152edaea0cf65fd1c137340","imageHashArm64":"","status":"recommended","critical":false}},"backup":{"2.4.29":{"imagePath":"percona/percona-xtradb-cluster-operator:1.15.1-pxc5.7-backup-pxb2.4.29","imageHash":"dfe6545b83b18450a3243441e6b43c3a6ed05dcc24a464286ffb9a7328fdb13f","imageHashArm64":"","status":"recommended","critical":false}},"operator":{"1.15.1":{"imagePath":"percona/percona-xtradb-cluster-operator:1.15.1","imageHash":"16a0078b5ededc4ae346168ee005aedf17f9ddddebf1eca067244d2f907bb7fa","imageHashArm64":"862c0be9f278aed33c521dabb55986b33da5eddb52cc99e205c7bb8feac9b22f","status":"recommended","critical":false}},"logCollector":{"1.15.1":{"imagePath":"percona/percona-xtradb-cluster-operator:1.15.1-logcollector-fluentbit3.1.4","imageHash":"24b068d55559cbe5dbadc2f52e5c096f7df60374e47c6b4d1a5e331fd2a75014","imageHashArm64":"","status":"recommended","critical":false}},"postgresql":{},"pgbackrest":{},"pgbackrestRepo":{},"pgbadger":{},"pgbouncer":{},"pxcOperator":{},"psmdbOperator":{},"pgOperatorApiserver":{},"pgOperatorEvent":{},"pgOperatorRmdata":{},"pgOperatorScheduler":{},"pgOperator":{},"pgOperatorDeployer":{},"psOperator":{},"mysql":{},"router":{},"orchestrator":{},"toolkit":{},"postgis":{}}}]}' + IMAGE_PMM_CLIENT=percona/pmm-client:2.42.0 ++ jq -r '.versions[].matrix.proxysql[].imagePath' ++ echo '{"versions":[{"product":"pxc-operator","operator":"1.15.1","matrix":{"mongod":{},"pxc":{"5.7.44-31.65":{"imagePath":"percona/percona-xtradb-cluster:5.7.44-31.65","imageHash":"36fafdef46485839d4ff7c6dc73b4542b07031644c0152e911acb9734ff2be85","imageHashArm64":"","status":"recommended","critical":false}},"pmm":{"2.42.0":{"imagePath":"percona/pmm-client:2.42.0","imageHash":"14cb96de47e3bc239bf285f22ec6f170b4a1181301b19100f5b7dc22c210bf8c","imageHashArm64":"","status":"recommended","critical":false}},"proxysql":{"2.5.5":{"imagePath":"percona/proxysql2:2.5.5","imageHash":"d95b0c6782447fef22adea3e8b8143e79a6a757666ffd34a8c3eddd9f82d629c","imageHashArm64":"","status":"recommended","critical":false}},"haproxy":{"2.8.5":{"imagePath":"percona/haproxy:2.8.5","imageHash":"941f3bd0977bff9145e904bf8f8298a1a024d7f03152edaea0cf65fd1c137340","imageHashArm64":"","status":"recommended","critical":false}},"backup":{"2.4.29":{"imagePath":"percona/percona-xtradb-cluster-operator:1.15.1-pxc5.7-backup-pxb2.4.29","imageHash":"dfe6545b83b18450a3243441e6b43c3a6ed05dcc24a464286ffb9a7328fdb13f","imageHashArm64":"","status":"recommended","critical":false}},"operator":{"1.15.1":{"imagePath":"percona/percona-xtradb-cluster-operator:1.15.1","imageHash":"16a0078b5ededc4ae346168ee005aedf17f9ddddebf1eca067244d2f907bb7fa","imageHashArm64":"862c0be9f278aed33c521dabb55986b33da5eddb52cc99e205c7bb8feac9b22f","status":"recommended","critical":false}},"logCollector":{"1.15.1":{"imagePath":"percona/percona-xtradb-cluster-operator:1.15.1-logcollector-fluentbit3.1.4","imageHash":"24b068d55559cbe5dbadc2f52e5c096f7df60374e47c6b4d1a5e331fd2a75014","imageHashArm64":"","status":"recommended","critical":false}},"postgresql":{},"pgbackrest":{},"pgbackrestRepo":{},"pgbadger":{},"pgbouncer":{},"pxcOperator":{},"psmdbOperator":{},"pgOperatorApiserver":{},"pgOperatorEvent":{},"pgOperatorRmdata":{},"pgOperatorScheduler":{},"pgOperator":{},"pgOperatorDeployer":{},"psOperator":{},"mysql":{},"router":{},"orchestrator":{},"toolkit":{},"postgis":{}}}]}' + IMAGE_PROXY=percona/proxysql2:2.5.5 ++ echo '{"versions":[{"product":"pxc-operator","operator":"1.15.1","matrix":{"mongod":{},"pxc":{"5.7.44-31.65":{"imagePath":"percona/percona-xtradb-cluster:5.7.44-31.65","imageHash":"36fafdef46485839d4ff7c6dc73b4542b07031644c0152e911acb9734ff2be85","imageHashArm64":"","status":"recommended","critical":false}},"pmm":{"2.42.0":{"imagePath":"percona/pmm-client:2.42.0","imageHash":"14cb96de47e3bc239bf285f22ec6f170b4a1181301b19100f5b7dc22c210bf8c","imageHashArm64":"","status":"recommended","critical":false}},"proxysql":{"2.5.5":{"imagePath":"percona/proxysql2:2.5.5","imageHash":"d95b0c6782447fef22adea3e8b8143e79a6a757666ffd34a8c3eddd9f82d629c","imageHashArm64":"","status":"recommended","critical":false}},"haproxy":{"2.8.5":{"imagePath":"percona/haproxy:2.8.5","imageHash":"941f3bd0977bff9145e904bf8f8298a1a024d7f03152edaea0cf65fd1c137340","imageHashArm64":"","status":"recommended","critical":false}},"backup":{"2.4.29":{"imagePath":"percona/percona-xtradb-cluster-operator:1.15.1-pxc5.7-backup-pxb2.4.29","imageHash":"dfe6545b83b18450a3243441e6b43c3a6ed05dcc24a464286ffb9a7328fdb13f","imageHashArm64":"","status":"recommended","critical":false}},"operator":{"1.15.1":{"imagePath":"percona/percona-xtradb-cluster-operator:1.15.1","imageHash":"16a0078b5ededc4ae346168ee005aedf17f9ddddebf1eca067244d2f907bb7fa","imageHashArm64":"862c0be9f278aed33c521dabb55986b33da5eddb52cc99e205c7bb8feac9b22f","status":"recommended","critical":false}},"logCollector":{"1.15.1":{"imagePath":"percona/percona-xtradb-cluster-operator:1.15.1-logcollector-fluentbit3.1.4","imageHash":"24b068d55559cbe5dbadc2f52e5c096f7df60374e47c6b4d1a5e331fd2a75014","imageHashArm64":"","status":"recommended","critical":false}},"postgresql":{},"pgbackrest":{},"pgbackrestRepo":{},"pgbadger":{},"pgbouncer":{},"pxcOperator":{},"psmdbOperator":{},"pgOperatorApiserver":{},"pgOperatorEvent":{},"pgOperatorRmdata":{},"pgOperatorScheduler":{},"pgOperator":{},"pgOperatorDeployer":{},"psOperator":{},"mysql":{},"router":{},"orchestrator":{},"toolkit":{},"postgis":{}}}]}' ++ jq -r '.versions[].matrix.haproxy[].imagePath' + IMAGE_HAPROXY=percona/haproxy:2.8.5 ++ jq -r '.versions[].matrix.backup[].imagePath' ++ echo '{"versions":[{"product":"pxc-operator","operator":"1.15.1","matrix":{"mongod":{},"pxc":{"5.7.44-31.65":{"imagePath":"percona/percona-xtradb-cluster:5.7.44-31.65","imageHash":"36fafdef46485839d4ff7c6dc73b4542b07031644c0152e911acb9734ff2be85","imageHashArm64":"","status":"recommended","critical":false}},"pmm":{"2.42.0":{"imagePath":"percona/pmm-client:2.42.0","imageHash":"14cb96de47e3bc239bf285f22ec6f170b4a1181301b19100f5b7dc22c210bf8c","imageHashArm64":"","status":"recommended","critical":false}},"proxysql":{"2.5.5":{"imagePath":"percona/proxysql2:2.5.5","imageHash":"d95b0c6782447fef22adea3e8b8143e79a6a757666ffd34a8c3eddd9f82d629c","imageHashArm64":"","status":"recommended","critical":false}},"haproxy":{"2.8.5":{"imagePath":"percona/haproxy:2.8.5","imageHash":"941f3bd0977bff9145e904bf8f8298a1a024d7f03152edaea0cf65fd1c137340","imageHashArm64":"","status":"recommended","critical":false}},"backup":{"2.4.29":{"imagePath":"percona/percona-xtradb-cluster-operator:1.15.1-pxc5.7-backup-pxb2.4.29","imageHash":"dfe6545b83b18450a3243441e6b43c3a6ed05dcc24a464286ffb9a7328fdb13f","imageHashArm64":"","status":"recommended","critical":false}},"operator":{"1.15.1":{"imagePath":"percona/percona-xtradb-cluster-operator:1.15.1","imageHash":"16a0078b5ededc4ae346168ee005aedf17f9ddddebf1eca067244d2f907bb7fa","imageHashArm64":"862c0be9f278aed33c521dabb55986b33da5eddb52cc99e205c7bb8feac9b22f","status":"recommended","critical":false}},"logCollector":{"1.15.1":{"imagePath":"percona/percona-xtradb-cluster-operator:1.15.1-logcollector-fluentbit3.1.4","imageHash":"24b068d55559cbe5dbadc2f52e5c096f7df60374e47c6b4d1a5e331fd2a75014","imageHashArm64":"","status":"recommended","critical":false}},"postgresql":{},"pgbackrest":{},"pgbackrestRepo":{},"pgbadger":{},"pgbouncer":{},"pxcOperator":{},"psmdbOperator":{},"pgOperatorApiserver":{},"pgOperatorEvent":{},"pgOperatorRmdata":{},"pgOperatorScheduler":{},"pgOperator":{},"pgOperatorDeployer":{},"psOperator":{},"mysql":{},"router":{},"orchestrator":{},"toolkit":{},"postgis":{}}}]}' + IMAGE_BACKUP=percona/percona-xtradb-cluster-operator:1.15.1-pxc5.7-backup-pxb2.4.29 + [[ 1.16.0 == \1\.\1\5\.\1 ]] + main + deploy_cert_manager + desc 'deploy cert manager' + set +o xtrace ----------------------------------------------------------------------------------- deploy cert manager ----------------------------------------------------------------------------------- + kubectl_bin create namespace cert-manager ++ mktemp + local LAST_OUT=/tmp/tmp.LJ83KuoL8z ++ mktemp + local LAST_ERR=/tmp/tmp.HynaA1qTLa + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl create namespace cert-manager + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.LJ83KuoL8z namespace/cert-manager created + cat /tmp/tmp.HynaA1qTLa + rm /tmp/tmp.LJ83KuoL8z /tmp/tmp.HynaA1qTLa + return 0 + kubectl_bin label namespace cert-manager certmanager.k8s.io/disable-validation=true ++ mktemp + local LAST_OUT=/tmp/tmp.qafvIdnLDE ++ mktemp + local LAST_ERR=/tmp/tmp.15bY7PkpJk + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl label namespace cert-manager certmanager.k8s.io/disable-validation=true + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.qafvIdnLDE namespace/cert-manager labeled + cat /tmp/tmp.15bY7PkpJk + rm /tmp/tmp.qafvIdnLDE /tmp/tmp.15bY7PkpJk + return 0 + kubectl_bin apply -f https://github.com/jetstack/cert-manager/releases/download/v1.16.2/cert-manager.yaml --validate=false ++ mktemp + local LAST_OUT=/tmp/tmp.r117fwbKVg ++ mktemp + local LAST_ERR=/tmp/tmp.twjYVZE92h + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl apply -f https://github.com/jetstack/cert-manager/releases/download/v1.16.2/cert-manager.yaml --validate=false + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.r117fwbKVg namespace/cert-manager configured customresourcedefinition.apiextensions.k8s.io/certificaterequests.cert-manager.io unchanged customresourcedefinition.apiextensions.k8s.io/certificates.cert-manager.io unchanged customresourcedefinition.apiextensions.k8s.io/challenges.acme.cert-manager.io unchanged customresourcedefinition.apiextensions.k8s.io/clusterissuers.cert-manager.io unchanged customresourcedefinition.apiextensions.k8s.io/issuers.cert-manager.io unchanged customresourcedefinition.apiextensions.k8s.io/orders.acme.cert-manager.io unchanged serviceaccount/cert-manager-cainjector created serviceaccount/cert-manager created serviceaccount/cert-manager-webhook created clusterrole.rbac.authorization.k8s.io/cert-manager-cainjector unchanged clusterrole.rbac.authorization.k8s.io/cert-manager-controller-issuers unchanged clusterrole.rbac.authorization.k8s.io/cert-manager-controller-clusterissuers unchanged clusterrole.rbac.authorization.k8s.io/cert-manager-controller-certificates unchanged clusterrole.rbac.authorization.k8s.io/cert-manager-controller-orders unchanged clusterrole.rbac.authorization.k8s.io/cert-manager-controller-challenges unchanged clusterrole.rbac.authorization.k8s.io/cert-manager-controller-ingress-shim unchanged clusterrole.rbac.authorization.k8s.io/cert-manager-cluster-view unchanged clusterrole.rbac.authorization.k8s.io/cert-manager-view unchanged clusterrole.rbac.authorization.k8s.io/cert-manager-edit unchanged clusterrole.rbac.authorization.k8s.io/cert-manager-controller-approve:cert-manager-io unchanged clusterrole.rbac.authorization.k8s.io/cert-manager-controller-certificatesigningrequests unchanged clusterrole.rbac.authorization.k8s.io/cert-manager-webhook:subjectaccessreviews unchanged clusterrolebinding.rbac.authorization.k8s.io/cert-manager-cainjector unchanged clusterrolebinding.rbac.authorization.k8s.io/cert-manager-controller-issuers unchanged clusterrolebinding.rbac.authorization.k8s.io/cert-manager-controller-clusterissuers unchanged clusterrolebinding.rbac.authorization.k8s.io/cert-manager-controller-certificates unchanged clusterrolebinding.rbac.authorization.k8s.io/cert-manager-controller-orders unchanged clusterrolebinding.rbac.authorization.k8s.io/cert-manager-controller-challenges unchanged clusterrolebinding.rbac.authorization.k8s.io/cert-manager-controller-ingress-shim unchanged clusterrolebinding.rbac.authorization.k8s.io/cert-manager-controller-approve:cert-manager-io unchanged clusterrolebinding.rbac.authorization.k8s.io/cert-manager-controller-certificatesigningrequests unchanged clusterrolebinding.rbac.authorization.k8s.io/cert-manager-webhook:subjectaccessreviews unchanged role.rbac.authorization.k8s.io/cert-manager-cainjector:leaderelection unchanged role.rbac.authorization.k8s.io/cert-manager:leaderelection unchanged role.rbac.authorization.k8s.io/cert-manager-tokenrequest created role.rbac.authorization.k8s.io/cert-manager-webhook:dynamic-serving created rolebinding.rbac.authorization.k8s.io/cert-manager-cainjector:leaderelection unchanged rolebinding.rbac.authorization.k8s.io/cert-manager:leaderelection unchanged rolebinding.rbac.authorization.k8s.io/cert-manager-cert-manager-tokenrequest created rolebinding.rbac.authorization.k8s.io/cert-manager-webhook:dynamic-serving created service/cert-manager-cainjector created service/cert-manager created service/cert-manager-webhook created deployment.apps/cert-manager-cainjector created deployment.apps/cert-manager created deployment.apps/cert-manager-webhook created mutatingwebhookconfiguration.admissionregistration.k8s.io/cert-manager-webhook configured validatingwebhookconfiguration.admissionregistration.k8s.io/cert-manager-webhook configured + cat /tmp/tmp.twjYVZE92h Warning: resource namespaces/cert-manager is missing the kubectl.kubernetes.io/last-applied-configuration annotation which is required by kubectl apply. kubectl apply should only be used on resources created declaratively by either kubectl create --save-config or kubectl apply. The missing annotation will be patched automatically. + rm /tmp/tmp.r117fwbKVg /tmp/tmp.twjYVZE92h + return 0 + '[' '' == 4.10 ']' + sleep 70 + create_infra_gh upgrade-proxysql-26075 v1.15.1 + local ns=upgrade-proxysql-26075 + local git_tag=v1.15.1 + '[' -n pxc-operator ']' + 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 ++ tail -n1 ++ awk '-F ' '{print $2}' ++ sed s/NAMESPACE// + local chaos_mesh_ns= + '[' -n '' ']' ++ kubectl get MutatingWebhookConfiguration ++ grep chaos-mesh ++ awk '{print $1}' + timeout 30 kubectl delete MutatingWebhookConfiguration error: resource(s) were provided, but no name was specified + : ++ kubectl get ValidatingWebhookConfiguration ++ grep chaos-mesh ++ awk '{print $1}' + timeout 30 kubectl delete ValidatingWebhookConfiguration error: resource(s) were provided, but no name was specified + : ++ kubectl get ValidatingWebhookConfiguration ++ grep validate-auth ++ awk '{print $1}' + timeout 30 kubectl delete ValidatingWebhookConfiguration error: resource(s) were provided, but no name was specified + : ++ kubectl api-resources ++ grep chaos-mesh ++ awk '{print $1}' ++ kubectl get crd ++ grep chaos-mesh.org ++ awk '{print $1}' + timeout 30 kubectl delete crd error: resource(s) were provided, but no name was specified + : ++ kubectl get clusterrolebinding ++ grep chaos-mesh ++ awk '{print $1}' + timeout 30 kubectl delete clusterrolebinding error: resource(s) were provided, but no name was specified + : ++ kubectl get clusterrole ++ grep chaos-mesh ++ awk '{print $1}' + timeout 30 kubectl delete clusterrole error: resource(s) were provided, but no name was specified + : + desc 'cleaned up all old namespaces' + set +o xtrace ----------------------------------------------------------------------------------- cleaned up all old namespaces ----------------------------------------------------------------------------------- + kubectl_bin get ns + awk '{print$1}' + '[' -n '' ']' ++ mktemp + desc 'cleaned up old namespaces pxc-operator' + xargs kubectl delete ns + set +o xtrace ----------------------------------------------------------------------------------- cleaned up old namespaces pxc-operator ----------------------------------------------------------------------------------- + kubectl_bin delete namespace pxc-operator ++ mktemp + local LAST_OUT=/tmp/tmp.58tDomth9o + egrep -v '^kube-|^default$|Terminating|pxc-operator|openshift|^NAME' ++ mktemp + local LAST_OUT=/tmp/tmp.B4C6M51waM + local LAST_ERR=/tmp/tmp.WfPrgDxyt8 + local exit_status=0 ++ mktemp ++ seq 0 2 + local LAST_ERR=/tmp/tmp.eKG0V0VmJ3 + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl get ns + for i in '$(seq 0 2)' + set +e + kubectl delete namespace pxc-operator + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.58tDomth9o + cat /tmp/tmp.WfPrgDxyt8 + rm /tmp/tmp.58tDomth9o /tmp/tmp.WfPrgDxyt8 + return 0 namespace "cert-manager" deleted namespace "gke-managed-system" deleted namespace "gmp-public" deleted namespace "gmp-system" deleted namespace "upgrade-proxysql-7301" deleted Error from server (Forbidden): namespaces "default" is forbidden: this namespace may not be deleted + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.B4C6M51waM namespace "pxc-operator" deleted + cat /tmp/tmp.eKG0V0VmJ3 + rm /tmp/tmp.B4C6M51waM /tmp/tmp.eKG0V0VmJ3 + 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.kBaWiFiH3E ++ mktemp + local LAST_ERR=/tmp/tmp.pQ9qnpKG2a + 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.kBaWiFiH3E namespace/pxc-operator created + cat /tmp/tmp.pQ9qnpKG2a + rm /tmp/tmp.kBaWiFiH3E /tmp/tmp.pQ9qnpKG2a + return 0 ++ kubectl_bin config current-context +++ mktemp ++ local LAST_OUT=/tmp/tmp.qnlpzcyJKC +++ mktemp ++ local LAST_ERR=/tmp/tmp.cHoGlNv2d7 ++ 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.qnlpzcyJKC ++ cat /tmp/tmp.cHoGlNv2d7 ++ rm /tmp/tmp.qnlpzcyJKC /tmp/tmp.cHoGlNv2d7 ++ return 0 + kubectl_bin config set-context gke_cloud-dev-112233_us-central1-a_jen-pxc-1697-26afa527-8-cluster4 --namespace=pxc-operator ++ mktemp + local LAST_OUT=/tmp/tmp.1IDw62xMZM ++ mktemp + local LAST_ERR=/tmp/tmp.SPykD5wUCf + 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-1697-26afa527-8-cluster4 --namespace=pxc-operator + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.1IDw62xMZM Context "gke_cloud-dev-112233_us-central1-a_jen-pxc-1697-26afa527-8-cluster4" modified. + cat /tmp/tmp.SPykD5wUCf + rm /tmp/tmp.1IDw62xMZM /tmp/tmp.SPykD5wUCf + return 0 + deploy_operator_gh v1.15.1 + local git_tag=v1.15.1 + desc 'start PXC operator' + set +o xtrace ----------------------------------------------------------------------------------- start PXC operator ----------------------------------------------------------------------------------- ++ kubectl_bin get crds -o 'jsonpath={.items[?(@.metadata.name == "perconaxtradbclusters.pxc.percona.com")].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.JR4uOrttWM +++ mktemp ++ local LAST_ERR=/tmp/tmp.ajrUykYYXo ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get crds -o 'jsonpath={.items[?(@.metadata.name == "perconaxtradbclusters.pxc.percona.com")].metadata.name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.JR4uOrttWM ++ cat /tmp/tmp.ajrUykYYXo ++ rm /tmp/tmp.JR4uOrttWM /tmp/tmp.ajrUykYYXo ++ return 0 + [[ -n perconaxtradbclusters.pxc.percona.com ]] ++ kubectl_bin get crd/perconaxtradbclusters.pxc.percona.com -o 'jsonpath={.spec.versions[?(@.name == "v1-15-1")].name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.TBHsKssHhw +++ mktemp ++ local LAST_ERR=/tmp/tmp.SQ4CpGFk6E ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get crd/perconaxtradbclusters.pxc.percona.com -o 'jsonpath={.spec.versions[?(@.name == "v1-15-1")].name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.TBHsKssHhw ++ cat /tmp/tmp.SQ4CpGFk6E ++ rm /tmp/tmp.TBHsKssHhw /tmp/tmp.SQ4CpGFk6E ++ return 0 + [[ -n '' ]] + kubectl_bin apply --server-side --force-conflicts -f https://raw.githubusercontent.com/percona/percona-xtradb-cluster-operator/v1.15.1/deploy/crd.yaml ++ mktemp + local LAST_OUT=/tmp/tmp.FrrDwibf11 ++ mktemp + local LAST_ERR=/tmp/tmp.YknGr9iejE + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl apply --server-side --force-conflicts -f https://raw.githubusercontent.com/percona/percona-xtradb-cluster-operator/v1.15.1/deploy/crd.yaml + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.FrrDwibf11 + cat /tmp/tmp.YknGr9iejE + rm /tmp/tmp.FrrDwibf11 /tmp/tmp.YknGr9iejE + return 0 + local rbac_yaml=rbac + local operator_yaml=operator.yaml + '[' -n pxc-operator ']' + rbac_yaml=cw-rbac + operator_yaml=cw-operator.yaml + apply_rbac_gh cw-rbac v1.15.1 + local operator_namespace=pxc-operator + local rbac=cw-rbac + local git_tag=v1.15.1 + curl -s https://raw.githubusercontent.com/percona/percona-xtradb-cluster-operator/v1.15.1/deploy/cw-rbac.yaml + /usr/bin/sed -i -e 's^namespace: .*^namespace: pxc-operator^' /tmp/tmp.Kfg0SCarWM/rbac_v1.15.1.yaml + kubectl_bin apply -f /tmp/tmp.Kfg0SCarWM/rbac_v1.15.1.yaml ++ mktemp + local LAST_OUT=/tmp/tmp.2kTjsIdG0B ++ mktemp + local LAST_ERR=/tmp/tmp.QqZPQqhowB + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl apply -f /tmp/tmp.Kfg0SCarWM/rbac_v1.15.1.yaml + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.2kTjsIdG0B 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.QqZPQqhowB + rm /tmp/tmp.2kTjsIdG0B /tmp/tmp.QqZPQqhowB + return 0 + curl -s https://raw.githubusercontent.com/percona/percona-xtradb-cluster-operator/v1.15.1/deploy/cw-operator.yaml + sed -e 's^image: .*^image: perconalab/percona-xtradb-cluster-operator:1.15.1^' + yq eval '(select(.kind == "Deployment").spec.template.spec.containers[] | select(.name == "percona-xtradb-cluster-operator").env[] | select(.name == "DISABLE_TELEMETRY").value) = "true"' + cat /tmp/tmp.Kfg0SCarWM/cw-operator.yaml_v1.15.1.yaml + yq eval '(select(.kind == "Deployment").spec.template.spec.containers[] | select(.name == "percona-xtradb-cluster-operator").env[] | select(.name == "LOG_LEVEL").value) = "DEBUG"' + kubectl_bin apply -n pxc-operator -f - ++ mktemp + local LAST_OUT=/tmp/tmp.PYKuR2BUVA ++ mktemp + local LAST_ERR=/tmp/tmp.UYZXhgQNz3 + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl apply -n pxc-operator -f - + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.PYKuR2BUVA deployment.apps/percona-xtradb-cluster-operator created service/percona-xtradb-cluster-operator created + cat /tmp/tmp.UYZXhgQNz3 + rm /tmp/tmp.PYKuR2BUVA /tmp/tmp.UYZXhgQNz3 + return 0 + sleep 2 ++ 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.qWbGOujgAs +++ mktemp ++ local LAST_ERR=/tmp/tmp.Y978D72FK9 ++ 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.qWbGOujgAs ++ cat /tmp/tmp.Y978D72FK9 ++ rm /tmp/tmp.qWbGOujgAs /tmp/tmp.Y978D72FK9 ++ return 0 + wait_pod percona-xtradb-cluster-operator-57fb8c46b8-vz49v + local pod=percona-xtradb-cluster-operator-57fb8c46b8-vz49v + local max_retry=480 + local ns= ++ echo percona-xtradb-cluster-operator-57fb8c46b8-vz49v ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/percona-xtradb-cluster-operator-57fb8c46b8-vz49v condition met waiting for pod/percona-xtradb-cluster-operator-57fb8c46b8-vz49v to become Ready.Ok + create_namespace upgrade-proxysql-26075 + local namespace=upgrade-proxysql-26075 + local skip_clean_namespace= + [[ 1 == 1 ]] + [[ -z '' ]] + destroy_chaos_mesh ++ helm list --all-namespaces --filter chaos-mesh ++ tail -n1 ++ awk '-F ' '{print $2}' ++ sed s/NAMESPACE// + local chaos_mesh_ns= + '[' -n '' ']' ++ kubectl get MutatingWebhookConfiguration ++ grep chaos-mesh ++ awk '{print $1}' + timeout 30 kubectl delete MutatingWebhookConfiguration error: resource(s) were provided, but no name was specified + : ++ kubectl get ValidatingWebhookConfiguration ++ grep chaos-mesh ++ awk '{print $1}' + timeout 30 kubectl delete ValidatingWebhookConfiguration error: resource(s) were provided, but no name was specified + : ++ kubectl get ValidatingWebhookConfiguration ++ grep validate-auth ++ awk '{print $1}' + timeout 30 kubectl delete ValidatingWebhookConfiguration error: resource(s) were provided, but no name was specified + : ++ kubectl api-resources ++ grep chaos-mesh ++ awk '{print $1}' ++ kubectl get crd ++ grep chaos-mesh.org ++ awk '{print $1}' + timeout 30 kubectl delete crd error: resource(s) were provided, but no name was specified + : ++ kubectl get clusterrolebinding ++ grep chaos-mesh ++ awk '{print $1}' + timeout 30 kubectl delete clusterrolebinding error: resource(s) were provided, but no name was specified + : ++ kubectl get clusterrole ++ grep chaos-mesh ++ awk '{print $1}' + timeout 30 kubectl delete clusterrole error: resource(s) were provided, but no name was specified + : + desc 'cleaned up all old namespaces' + set +o xtrace ----------------------------------------------------------------------------------- cleaned up all old namespaces ----------------------------------------------------------------------------------- + egrep -v '^kube-|^default$|Terminating|pxc-operator|openshift|^NAME' + awk '{print$1}' + '[' -n '' ']' + desc 'cleaned up old namespaces upgrade-proxysql-26075' + xargs kubectl delete ns + set +o xtrace ----------------------------------------------------------------------------------- cleaned up old namespaces upgrade-proxysql-26075 ----------------------------------------------------------------------------------- + kubectl_bin delete namespace upgrade-proxysql-26075 + kubectl_bin get ns ++ mktemp ++ mktemp + local LAST_OUT=/tmp/tmp.g8S7jeSegB ++ mktemp + local LAST_OUT=/tmp/tmp.C36Iv8vovf + local LAST_ERR=/tmp/tmp.6v3QP4cpue + local exit_status=0 ++ mktemp ++ seq 0 2 + local LAST_ERR=/tmp/tmp.PMIAcnFfUq + local exit_status=0 + 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 upgrade-proxysql-26075 + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.g8S7jeSegB + cat /tmp/tmp.6v3QP4cpue + rm /tmp/tmp.g8S7jeSegB /tmp/tmp.6v3QP4cpue + return 0 + exit_status=1 + set -e + '[' 1 '!=' 0 ']' + '[' 1 == 1 ']' + sleep 0 + for i in '$(seq 0 2)' + set +e + kubectl delete namespace upgrade-proxysql-26075 + exit_status=1 + set -e + '[' 1 '!=' 0 ']' + '[' 1 == 1 ']' + sleep 0 + for i in '$(seq 0 2)' + set +e + kubectl delete namespace upgrade-proxysql-26075 namespace "gke-managed-system" deleted + exit_status=1 + set -e + '[' 1 '!=' 0 ']' + '[' 1 == 1 ']' + sleep 0 + cat /tmp/tmp.C36Iv8vovf + cat /tmp/tmp.PMIAcnFfUq Error from server (NotFound): namespaces "upgrade-proxysql-26075" not found + rm /tmp/tmp.C36Iv8vovf /tmp/tmp.PMIAcnFfUq + return 1 + : + wait_for_delete namespace/upgrade-proxysql-26075 + local res=namespace/upgrade-proxysql-26075 + echo -n 'waiting for namespace/upgrade-proxysql-26075 to be deleted' waiting for namespace/upgrade-proxysql-26075 to be deleted+ set +o xtrace namespace "gmp-public" deleted namespace "gmp-system" deleted Error from server (Forbidden): namespaces "default" is forbidden: this namespace may not be deleted Error from server (NotFound): namespaces "upgrade-proxysql-26075" not found + desc 'create namespace upgrade-proxysql-26075' + set +o xtrace ----------------------------------------------------------------------------------- create namespace upgrade-proxysql-26075 ----------------------------------------------------------------------------------- + kubectl_bin create namespace upgrade-proxysql-26075 ++ mktemp + local LAST_OUT=/tmp/tmp.46i5gRvSef ++ mktemp + local LAST_ERR=/tmp/tmp.KgMe9tK8Oa + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl create namespace upgrade-proxysql-26075 + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.46i5gRvSef namespace/upgrade-proxysql-26075 created + cat /tmp/tmp.KgMe9tK8Oa + rm /tmp/tmp.46i5gRvSef /tmp/tmp.KgMe9tK8Oa + return 0 ++ kubectl_bin config current-context +++ mktemp ++ local LAST_OUT=/tmp/tmp.zezvCLizIo +++ mktemp ++ local LAST_ERR=/tmp/tmp.YKp5PfWg0O ++ 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.zezvCLizIo ++ cat /tmp/tmp.YKp5PfWg0O ++ rm /tmp/tmp.zezvCLizIo /tmp/tmp.YKp5PfWg0O ++ return 0 + kubectl_bin config set-context gke_cloud-dev-112233_us-central1-a_jen-pxc-1697-26afa527-8-cluster4 --namespace=upgrade-proxysql-26075 ++ mktemp + local LAST_OUT=/tmp/tmp.nw866DLvPO ++ mktemp + local LAST_ERR=/tmp/tmp.aT6yi7HTbl + 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-1697-26afa527-8-cluster4 --namespace=upgrade-proxysql-26075 + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.nw866DLvPO Context "gke_cloud-dev-112233_us-central1-a_jen-pxc-1697-26afa527-8-cluster4" modified. + cat /tmp/tmp.aT6yi7HTbl + rm /tmp/tmp.nw866DLvPO /tmp/tmp.aT6yi7HTbl + 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-1697/e2e-tests/conf/minio-secret.yml -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/conf/cloud-secret.yml ++ mktemp + local LAST_OUT=/tmp/tmp.1NysydppKF ++ mktemp + local LAST_ERR=/tmp/tmp.oMPmtOgirH + 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-1697/e2e-tests/conf/minio-secret.yml -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/conf/cloud-secret.yml + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.1NysydppKF secret/minio-secret created secret/aws-s3-secret created secret/gcp-cs-secret created secret/azure-secret created + cat /tmp/tmp.oMPmtOgirH + rm /tmp/tmp.1NysydppKF /tmp/tmp.oMPmtOgirH + return 0 + local proxy=proxysql + local cr_yaml=/tmp/tmp.Kfg0SCarWM/cr_1.15.1_proxysql.yaml + prepare_cr_yaml /tmp/tmp.Kfg0SCarWM/cr_1.15.1_proxysql.yaml proxysql upgrade-proxysql 3 v1.15.1 + local cr_yaml=/tmp/tmp.Kfg0SCarWM/cr_1.15.1_proxysql.yaml + local proxy=proxysql + local cluster=upgrade-proxysql + local cluster_size=3 + local git_tag=v1.15.1 + curl -s https://raw.githubusercontent.com/percona/percona-xtradb-cluster-operator/v1.15.1/deploy/cr.yaml + yq eval ' .metadata.name = "upgrade-proxysql" | .spec.secretsName = "my-cluster-secrets" | .spec.vaultSecretName = "some-name-vault" | .spec.sslSecretName = "some-name-ssl" | .spec.sslInternalSecretName = "some-name-ssl-internal" | .spec.upgradeOptions.apply = "disabled" | .spec.pxc.size = 3 | .spec.proxysql.size = 3 | .spec.haproxy.size = 3 | .spec.pxc.image = "-pxc" | .spec.proxysql.image = "-proxysql" | .spec.haproxy.image = "-haproxy" | .spec.backup.image = "-backup" | .spec.backup.storages.minio.s3.credentialsSecret = "minio-secret" | .spec.backup.storages.minio.s3.region = "us-east-1" | .spec.backup.storages.minio.s3.bucket = "operator-testing" | .spec.backup.storages.minio.s3.endpointUrl = "http://minio-service.#namespace:9000/" | .spec.backup.storages.minio.type = "s3" | .spec.pmm.image = "-pmm" ' - + [[ proxysql == \h\a\p\r\o\x\y ]] + yq -i eval ' .spec.haproxy.enabled = false | .spec.proxysql.enabled = true ' /tmp/tmp.Kfg0SCarWM/cr_1.15.1_proxysql.yaml + spinup_pxc upgrade-proxysql /tmp/tmp.Kfg0SCarWM/cr_1.15.1_proxysql.yaml 3 30 /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/conf/secrets_without_tls.yml + local cluster=upgrade-proxysql + local config=/tmp/tmp.Kfg0SCarWM/cr_1.15.1_proxysql.yaml + local size=3 + local sleep=30 + local secretsFile=/mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/conf/secrets_without_tls.yml + local pxcClientFile=/mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/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-1697/e2e-tests/conf/secrets_without_tls.yml ++ mktemp + local LAST_OUT=/tmp/tmp.nfgiLC4w5Y ++ mktemp + local LAST_ERR=/tmp/tmp.nfHo39Tciv + 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-1697/e2e-tests/conf/secrets_without_tls.yml + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.nfgiLC4w5Y secret/my-cluster-secrets created + cat /tmp/tmp.nfHo39Tciv + rm /tmp/tmp.nfgiLC4w5Y /tmp/tmp.nfHo39Tciv + return 0 + apply_config /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/conf/client.yml + '[' -z '' ']' + cat_config /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/conf/client.yml + kubectl_bin apply -f - + cat /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/conf/client.yml + /usr/bin/sed -e 's#apiVersion: pxc.percona.com/v.*$#apiVersion: pxc.percona.com/v1#' ++ mktemp + /usr/bin/sed -e 's#image:.*\/percona-xtradb-cluster:.*$#image: percona/percona-xtradb-cluster:5.7.44-31.65#' + /usr/bin/sed -e 's#image:.*-pxc\([0-9]*.[0-9]*\)\{0,1\}$#image: percona/percona-xtradb-cluster:5.7.44-31.65#' + /usr/bin/sed -e 's#image:.*-backup$#image: percona/percona-xtradb-cluster-operator:1.15.1-pxc5.7-backup-pxb2.4.29#' + /usr/bin/sed -e 's#image:.*-proxysql$#image: percona/proxysql2:2.5.5#' + /usr/bin/sed -e 's#image:.*-haproxy$#image: percona/haproxy:2.8.5#' + /usr/bin/sed -e 's#image:.*-pmm$#image: percona/pmm-client:2.42.0#' + /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.upgrade-proxysql-26075~ + /usr/bin/sed -e 's#image:.*-init$#image: perconalab/percona-xtradb-cluster-operator:1.15.1#' + /usr/bin/sed -e 's#apply:.*#apply: Never#' + local LAST_OUT=/tmp/tmp.SQEMcTkwaN ++ mktemp + local LAST_ERR=/tmp/tmp.Zc9oks6JI8 + 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.SQEMcTkwaN deployment.apps/pxc-client created + cat /tmp/tmp.Zc9oks6JI8 + rm /tmp/tmp.SQEMcTkwaN /tmp/tmp.Zc9oks6JI8 + return 0 + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 5\.7 ]] + [[ upgrade-proxysql == \d\e\m\a\n\d\-\b\a\c\k\u\p ]] + [[ upgrade-proxysql == \d\e\m\a\n\d\-\b\a\c\k\u\p\-\c\l\o\u\d ]] + apply_config /tmp/tmp.Kfg0SCarWM/cr_1.15.1_proxysql.yaml + '[' -z '' ']' + cat_config /tmp/tmp.Kfg0SCarWM/cr_1.15.1_proxysql.yaml + kubectl_bin apply -f - + cat /tmp/tmp.Kfg0SCarWM/cr_1.15.1_proxysql.yaml + /usr/bin/sed -e 's#apiVersion: pxc.percona.com/v.*$#apiVersion: pxc.percona.com/v1#' + /usr/bin/sed -e 's#image:.*-pxc\([0-9]*.[0-9]*\)\{0,1\}$#image: percona/percona-xtradb-cluster:5.7.44-31.65#' + /usr/bin/sed -e 's#image:.*\/percona-xtradb-cluster:.*$#image: percona/percona-xtradb-cluster:5.7.44-31.65#' + /usr/bin/sed -e 's#image:.*-pmm$#image: percona/pmm-client:2.42.0#' + /usr/bin/sed -e 's#image:.*-haproxy$#image: percona/haproxy:2.8.5#' ++ mktemp + /usr/bin/sed -e 's#image:.*-logcollector$#image: perconalab/percona-xtradb-cluster-operator:main-logcollector#' + /usr/bin/sed -e 's#image:.*-init$#image: perconalab/percona-xtradb-cluster-operator:1.15.1#' + /usr/bin/sed -e s~minio-service.#namespace~minio-service.upgrade-proxysql-26075~ + /usr/bin/sed -e 's#apply:.*#apply: Never#' + local LAST_OUT=/tmp/tmp.tqGqjD1u9q ++ mktemp + /usr/bin/sed -e 's#image:.*-backup$#image: percona/percona-xtradb-cluster-operator:1.15.1-pxc5.7-backup-pxb2.4.29#' + local LAST_ERR=/tmp/tmp.WaIEedOmsO + local exit_status=0 ++ seq 0 2 + /usr/bin/sed -e 's#image:.*-proxysql$#image: percona/proxysql2:2.5.5#' + for i in '$(seq 0 2)' + set +e + kubectl apply -f - + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.tqGqjD1u9q perconaxtradbcluster.pxc.percona.com/upgrade-proxysql created + cat /tmp/tmp.WaIEedOmsO + rm /tmp/tmp.tqGqjD1u9q /tmp/tmp.WaIEedOmsO + return 0 + desc 'check if all 3 Pods started' + set +o xtrace ----------------------------------------------------------------------------------- check if all 3 Pods started ----------------------------------------------------------------------------------- ++ get_proxy upgrade-proxysql ++ local target_cluster=upgrade-proxysql +++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.haproxy.enabled}' ++++ mktemp +++ local LAST_OUT=/tmp/tmp.RBiBcuPz0m ++++ mktemp +++ local LAST_ERR=/tmp/tmp.RxcneRAWL5 +++ local exit_status=0 ++++ seq 0 2 +++ for i in '$(seq 0 2)' +++ set +e +++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.spec.haproxy.enabled}' +++ exit_status=0 +++ set -e +++ '[' 0 '!=' 0 ']' +++ break +++ cat /tmp/tmp.RBiBcuPz0m +++ cat /tmp/tmp.RxcneRAWL5 +++ rm /tmp/tmp.RBiBcuPz0m /tmp/tmp.RxcneRAWL5 +++ return 0 ++ [[ false == \t\r\u\e ]] +++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.enabled}' ++++ mktemp +++ local LAST_OUT=/tmp/tmp.kqq1cbDAup ++++ mktemp +++ local LAST_ERR=/tmp/tmp.zPV7pZn0T4 +++ local exit_status=0 ++++ seq 0 2 +++ for i in '$(seq 0 2)' +++ set +e +++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.enabled}' +++ exit_status=0 +++ set -e +++ '[' 0 '!=' 0 ']' +++ break +++ cat /tmp/tmp.kqq1cbDAup +++ cat /tmp/tmp.zPV7pZn0T4 +++ rm /tmp/tmp.kqq1cbDAup /tmp/tmp.zPV7pZn0T4 +++ return 0 ++ [[ true == \t\r\u\e ]] ++ echo upgrade-proxysql-proxysql ++ return + local proxy=upgrade-proxysql-proxysql + kubectl_bin wait --for=condition=Ready pod -l app.kubernetes.io/instance=monitoring,app.kubernetes.io/managed-by=percona-xtradb-cluster-operator --timeout=300s -n upgrade-proxysql-26075 ++ mktemp + local LAST_OUT=/tmp/tmp.Y38AiIMIrp ++ mktemp + local LAST_ERR=/tmp/tmp.1JYUrKgCy4 + 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 upgrade-proxysql-26075 + 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 upgrade-proxysql-26075 + 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 upgrade-proxysql-26075 + exit_status=1 + set -e + '[' 1 '!=' 0 ']' + '[' 1 == 1 ']' + sleep 0 + cat /tmp/tmp.Y38AiIMIrp + cat /tmp/tmp.1JYUrKgCy4 error: no matching resources found + rm /tmp/tmp.Y38AiIMIrp /tmp/tmp.1JYUrKgCy4 + return 1 + true + wait_for_running upgrade-proxysql-proxysql 1 + local name=upgrade-proxysql-proxysql + let last_pod=0 + : + local max_retry=480 + desc 'wait for running cluster' + set +o xtrace ----------------------------------------------------------------------------------- wait for running cluster ----------------------------------------------------------------------------------- ++ seq 0 0 + for i in '$(seq 0 $last_pod)' + wait_pod upgrade-proxysql-proxysql-0 480 + local pod=upgrade-proxysql-proxysql-0 + local max_retry=480 + local ns= ++ echo upgrade-proxysql-proxysql-0 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container=proxysql + set +o xtrace Error from server (NotFound): pods "upgrade-proxysql-proxysql-0" not found waiting for pod/upgrade-proxysql-proxysql-0 to become Ready.................Ok + wait_for_running upgrade-proxysql-pxc 3 + local name=upgrade-proxysql-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 upgrade-proxysql-pxc-0 480 + local pod=upgrade-proxysql-pxc-0 + local max_retry=480 + local ns= ++ echo upgrade-proxysql-pxc-0 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container=pxc + set +o xtrace pod/upgrade-proxysql-pxc-0 condition met waiting for pod/upgrade-proxysql-pxc-0 to become Ready.Ok + for i in '$(seq 0 $last_pod)' + wait_pod upgrade-proxysql-pxc-1 480 + local pod=upgrade-proxysql-pxc-1 + local max_retry=480 + local ns= ++ echo upgrade-proxysql-pxc-1 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container=pxc + set +o xtrace pod/upgrade-proxysql-pxc-1 condition met waiting for pod/upgrade-proxysql-pxc-1 to become Ready.Ok + for i in '$(seq 0 $last_pod)' + wait_pod upgrade-proxysql-pxc-2 480 + local pod=upgrade-proxysql-pxc-2 + local max_retry=480 + local ns= ++ echo upgrade-proxysql-pxc-2 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container=pxc + set +o xtrace pod/upgrade-proxysql-pxc-2 condition met waiting for pod/upgrade-proxysql-pxc-2 to become Ready.Ok + sleep 30 + desc 'write data' + set +o xtrace ----------------------------------------------------------------------------------- write data ----------------------------------------------------------------------------------- + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 5\.7 ]] ++ is_keyring_plugin_in_use upgrade-proxysql ++ local cluster=upgrade-proxysql ++ kubectl_bin exec -it upgrade-proxysql-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.VDmwWpRdvL +++ mktemp ++ local LAST_ERR=/tmp/tmp.JKKZaj4Ihi ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl exec -it upgrade-proxysql-pxc-0 -c pxc -- bash -c 'cat /etc/mysql/node.cnf' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.VDmwWpRdvL ++ cat /tmp/tmp.JKKZaj4Ihi Unable to use a TTY - input is not a terminal or the right kind of file ++ rm /tmp/tmp.VDmwWpRdvL /tmp/tmp.JKKZaj4Ihi ++ return 0 + [[ -n '' ]] + run_mysql 'CREATE DATABASE IF NOT EXISTS myApp; use myApp; CREATE TABLE IF NOT EXISTS myApp (id int PRIMARY KEY) ;' '-h upgrade-proxysql-proxysql -uroot -proot_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 upgrade-proxysql-proxysql -uroot -proot_password -P3306' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.au53Ket6oH +++ mktemp ++ local LAST_ERR=/tmp/tmp.xZGN5pgSEl ++ 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.au53Ket6oH ++ cat /tmp/tmp.xZGN5pgSEl ++ rm /tmp/tmp.au53Ket6oH /tmp/tmp.xZGN5pgSEl ++ return 0 + client_pod=pxc-client-75589d8bb5-885cw + wait_pod pxc-client-75589d8bb5-885cw + local pod=pxc-client-75589d8bb5-885cw + local max_retry=480 + local ns= ++ echo pxc-client-75589d8bb5-885cw ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-75589d8bb5-885cw condition met waiting for pod/pxc-client-75589d8bb5-885cw to become Ready.Ok + set +o xtrace + run_mysql 'INSERT myApp.myApp (id) VALUES (100500)' '-h upgrade-proxysql-proxysql -uroot -proot_password -P3306' + local 'command=INSERT myApp.myApp (id) VALUES (100500)' + local 'uri=-h upgrade-proxysql-proxysql -uroot -proot_password -P3306' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.xSpgCvwTIn +++ mktemp ++ local LAST_ERR=/tmp/tmp.VLkjCuwWYy ++ 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.xSpgCvwTIn ++ cat /tmp/tmp.VLkjCuwWYy ++ rm /tmp/tmp.xSpgCvwTIn /tmp/tmp.VLkjCuwWYy ++ return 0 + client_pod=pxc-client-75589d8bb5-885cw + wait_pod pxc-client-75589d8bb5-885cw + local pod=pxc-client-75589d8bb5-885cw + local max_retry=480 + local ns= ++ echo pxc-client-75589d8bb5-885cw ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-75589d8bb5-885cw condition met waiting for pod/pxc-client-75589d8bb5-885cw to become Ready.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 upgrade-proxysql-pxc-0.upgrade-proxysql-pxc -uroot -proot_password -P3306' + local command_id=select-1 + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h upgrade-proxysql-pxc-0.upgrade-proxysql-pxc -uroot -proot_password -P3306' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/select-1.sql + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.4 ]] + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.0 ]] + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 5\.7 ]] + [[ -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/select-1-57.sql ]] + run_mysql 'SELECT * from myApp.myApp;' '-h upgrade-proxysql-pxc-0.upgrade-proxysql-pxc -uroot -proot_password -P3306' + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h upgrade-proxysql-pxc-0.upgrade-proxysql-pxc -uroot -proot_password -P3306' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.wsQ31BPGB1 +++ mktemp ++ local LAST_ERR=/tmp/tmp.lA3IvQqxXI ++ 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.wsQ31BPGB1 ++ cat /tmp/tmp.lA3IvQqxXI ++ rm /tmp/tmp.wsQ31BPGB1 /tmp/tmp.lA3IvQqxXI ++ return 0 + client_pod=pxc-client-75589d8bb5-885cw + wait_pod pxc-client-75589d8bb5-885cw + local pod=pxc-client-75589d8bb5-885cw + local max_retry=480 + local ns= ++ echo pxc-client-75589d8bb5-885cw ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-75589d8bb5-885cw condition met waiting for pod/pxc-client-75589d8bb5-885cw to become Ready.Ok + set +o xtrace + '[' '!' -s /tmp/tmp.Kfg0SCarWM/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/select-1.sql /tmp/tmp.Kfg0SCarWM/select-1.sql + for i in '$(seq 0 $((size - 1)))' + compare_mysql_cmd select-1 'SELECT * from myApp.myApp;' '-h upgrade-proxysql-pxc-1.upgrade-proxysql-pxc -uroot -proot_password -P3306' + local command_id=select-1 + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h upgrade-proxysql-pxc-1.upgrade-proxysql-pxc -uroot -proot_password -P3306' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/select-1.sql + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.4 ]] + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.0 ]] + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 5\.7 ]] + [[ -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/select-1-57.sql ]] + run_mysql 'SELECT * from myApp.myApp;' '-h upgrade-proxysql-pxc-1.upgrade-proxysql-pxc -uroot -proot_password -P3306' + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h upgrade-proxysql-pxc-1.upgrade-proxysql-pxc -uroot -proot_password -P3306' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.szFC83QA8w +++ mktemp ++ local LAST_ERR=/tmp/tmp.dUCC9eEvkq ++ 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.szFC83QA8w ++ cat /tmp/tmp.dUCC9eEvkq ++ rm /tmp/tmp.szFC83QA8w /tmp/tmp.dUCC9eEvkq ++ return 0 + client_pod=pxc-client-75589d8bb5-885cw + wait_pod pxc-client-75589d8bb5-885cw + local pod=pxc-client-75589d8bb5-885cw + local max_retry=480 + local ns= ++ echo pxc-client-75589d8bb5-885cw ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-75589d8bb5-885cw condition met waiting for pod/pxc-client-75589d8bb5-885cw to become Ready.Ok + set +o xtrace + '[' '!' -s /tmp/tmp.Kfg0SCarWM/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/select-1.sql /tmp/tmp.Kfg0SCarWM/select-1.sql + for i in '$(seq 0 $((size - 1)))' + compare_mysql_cmd select-1 'SELECT * from myApp.myApp;' '-h upgrade-proxysql-pxc-2.upgrade-proxysql-pxc -uroot -proot_password -P3306' + local command_id=select-1 + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h upgrade-proxysql-pxc-2.upgrade-proxysql-pxc -uroot -proot_password -P3306' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/select-1.sql + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.4 ]] + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.0 ]] + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 5\.7 ]] + [[ -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/select-1-57.sql ]] + run_mysql 'SELECT * from myApp.myApp;' '-h upgrade-proxysql-pxc-2.upgrade-proxysql-pxc -uroot -proot_password -P3306' + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h upgrade-proxysql-pxc-2.upgrade-proxysql-pxc -uroot -proot_password -P3306' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.gHgppJmS8X +++ mktemp ++ local LAST_ERR=/tmp/tmp.25BxbdrcZa ++ 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.gHgppJmS8X ++ cat /tmp/tmp.25BxbdrcZa ++ rm /tmp/tmp.gHgppJmS8X /tmp/tmp.25BxbdrcZa ++ return 0 + client_pod=pxc-client-75589d8bb5-885cw + wait_pod pxc-client-75589d8bb5-885cw + local pod=pxc-client-75589d8bb5-885cw + local max_retry=480 + local ns= ++ echo pxc-client-75589d8bb5-885cw ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-75589d8bb5-885cw condition met waiting for pod/pxc-client-75589d8bb5-885cw to become Ready.Ok + set +o xtrace + '[' '!' -s /tmp/tmp.Kfg0SCarWM/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/select-1.sql /tmp/tmp.Kfg0SCarWM/select-1.sql ++ is_keyring_plugin_in_use upgrade-proxysql ++ local cluster=upgrade-proxysql ++ kubectl_bin exec -it upgrade-proxysql-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.5FVBjVyTkw +++ mktemp ++ local LAST_ERR=/tmp/tmp.lW8VzWluPb ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl exec -it upgrade-proxysql-pxc-0 -c pxc -- bash -c 'cat /etc/mysql/node.cnf' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.5FVBjVyTkw ++ cat /tmp/tmp.lW8VzWluPb Unable to use a TTY - input is not a terminal or the right kind of file ++ rm /tmp/tmp.5FVBjVyTkw /tmp/tmp.lW8VzWluPb ++ return 0 + '[' '' ']' + compare_generation 1 proxysql upgrade-proxysql + local generation=1 + local proxy=proxysql + local cluster=upgrade-proxysql + local current_generation + [[ proxysql == \h\a\p\r\o\x\y ]] + containers=(pxc proxysql) + for container in '"${containers[@]}"' + check_generation 1 pxc upgrade-proxysql + local generation=1 + local container=pxc + local cluster=upgrade-proxysql + local current_generation ++ kubectl_bin get statefulset upgrade-proxysql-pxc -o 'jsonpath={.metadata.generation}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.TLhyII3Dvs +++ mktemp ++ local LAST_ERR=/tmp/tmp.xxMQeCtRFj ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get statefulset upgrade-proxysql-pxc -o 'jsonpath={.metadata.generation}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.TLhyII3Dvs ++ cat /tmp/tmp.xxMQeCtRFj ++ rm /tmp/tmp.TLhyII3Dvs /tmp/tmp.xxMQeCtRFj ++ return 0 + current_generation=1 + [[ 1 != \1 ]] + for container in '"${containers[@]}"' + check_generation 1 proxysql upgrade-proxysql + local generation=1 + local container=proxysql + local cluster=upgrade-proxysql + local current_generation ++ kubectl_bin get statefulset upgrade-proxysql-proxysql -o 'jsonpath={.metadata.generation}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.ylv5I2Dk2x +++ mktemp ++ local LAST_ERR=/tmp/tmp.rYGeuPJoDN ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get statefulset upgrade-proxysql-proxysql -o 'jsonpath={.metadata.generation}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.ylv5I2Dk2x ++ cat /tmp/tmp.rYGeuPJoDN ++ rm /tmp/tmp.ylv5I2Dk2x /tmp/tmp.rYGeuPJoDN ++ return 0 + current_generation=1 + [[ 1 != \1 ]] + desc 'upgrade operator' + set +o xtrace ----------------------------------------------------------------------------------- upgrade operator ----------------------------------------------------------------------------------- + kubectl_bin apply --server-side --force-conflicts -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/deploy/crd.yaml ++ mktemp + local LAST_OUT=/tmp/tmp.zofmpVsuzh ++ mktemp + local LAST_ERR=/tmp/tmp.QLIwTBxaMS + 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-1697/deploy/crd.yaml + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.zofmpVsuzh 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.QLIwTBxaMS + rm /tmp/tmp.zofmpVsuzh /tmp/tmp.QLIwTBxaMS + return 0 + [[ -n pxc-operator ]] + apply_rbac cw-rbac + local operator_namespace=pxc-operator + local rbac=cw-rbac + cat /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/deploy/cw-rbac.yaml + sed -e 's^namespace: .*^namespace: pxc-operator^' + kubectl_bin apply -f - ++ mktemp + local LAST_OUT=/tmp/tmp.avmAFyDB3F ++ mktemp + local LAST_ERR=/tmp/tmp.UGSl6Nddj0 + 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.avmAFyDB3F 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.UGSl6Nddj0 + rm /tmp/tmp.avmAFyDB3F /tmp/tmp.UGSl6Nddj0 + return 0 + kubectl_bin patch deployment percona-xtradb-cluster-operator '-p{"spec":{"template":{"spec":{"containers":[{"name":"percona-xtradb-cluster-operator","image":"perconalab/percona-xtradb-cluster-operator:PR-1697-26afa527"}]}}}}' -n pxc-operator ++ mktemp + local LAST_OUT=/tmp/tmp.xwbQtNlNqh ++ mktemp + local LAST_ERR=/tmp/tmp.Lxi7MdWRRq + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl patch deployment percona-xtradb-cluster-operator '-p{"spec":{"template":{"spec":{"containers":[{"name":"percona-xtradb-cluster-operator","image":"perconalab/percona-xtradb-cluster-operator:PR-1697-26afa527"}]}}}}' -n pxc-operator + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.xwbQtNlNqh deployment.apps/percona-xtradb-cluster-operator patched + cat /tmp/tmp.Lxi7MdWRRq + rm /tmp/tmp.xwbQtNlNqh /tmp/tmp.Lxi7MdWRRq + return 0 + kubectl_bin rollout status deployment/percona-xtradb-cluster-operator -n pxc-operator ++ mktemp + local LAST_OUT=/tmp/tmp.d5LQ81zXY5 ++ mktemp + local LAST_ERR=/tmp/tmp.0LrdD6jHGC + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl rollout status deployment/percona-xtradb-cluster-operator -n pxc-operator + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.d5LQ81zXY5 Waiting for deployment "percona-xtradb-cluster-operator" rollout to finish: 0 of 1 updated replicas are available... deployment "percona-xtradb-cluster-operator" successfully rolled out + cat /tmp/tmp.0LrdD6jHGC + rm /tmp/tmp.d5LQ81zXY5 /tmp/tmp.0LrdD6jHGC + return 0 + sleep 10 + desc 'wait for operator upgrade' + set +o xtrace ----------------------------------------------------------------------------------- wait for operator upgrade ----------------------------------------------------------------------------------- + local i=0 + local max=60 ++ kubectl_bin get pods --selector=app.kubernetes.io/name=percona-xtradb-cluster-operator -o 'custom-columns=NAME:.metadata.name,IMAGE:.spec.containers[0].image' -n pxc-operator ++ grep -vc NAME ++ awk '{print $1}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.6WFdUIgBxM +++ mktemp ++ local LAST_ERR=/tmp/tmp.g97zjGbHgc ++ 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 'custom-columns=NAME:.metadata.name,IMAGE:.spec.containers[0].image' -n pxc-operator ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.6WFdUIgBxM ++ cat /tmp/tmp.g97zjGbHgc ++ rm /tmp/tmp.6WFdUIgBxM /tmp/tmp.g97zjGbHgc ++ return 0 + [[ 1 -eq 1 ]] + '[' -n pxc-operator ']' ++ kubectl_bin config current-context +++ mktemp ++ local LAST_OUT=/tmp/tmp.mKbkANwrma +++ mktemp ++ local LAST_ERR=/tmp/tmp.Gfvw4H9wZs ++ 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.mKbkANwrma ++ cat /tmp/tmp.Gfvw4H9wZs ++ rm /tmp/tmp.mKbkANwrma /tmp/tmp.Gfvw4H9wZs ++ return 0 + kubectl_bin config set-context gke_cloud-dev-112233_us-central1-a_jen-pxc-1697-26afa527-8-cluster4 --namespace=pxc-operator ++ mktemp + local LAST_OUT=/tmp/tmp.Z6PZCXyba6 ++ mktemp + local LAST_ERR=/tmp/tmp.pyM0oe1NFE + 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-1697-26afa527-8-cluster4 --namespace=pxc-operator + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.Z6PZCXyba6 Context "gke_cloud-dev-112233_us-central1-a_jen-pxc-1697-26afa527-8-cluster4" modified. + cat /tmp/tmp.pyM0oe1NFE + rm /tmp/tmp.Z6PZCXyba6 /tmp/tmp.pyM0oe1NFE + return 0 ++ kubectl_bin get pods --selector=app.kubernetes.io/name=percona-xtradb-cluster-operator -o 'custom-columns=NAME:.metadata.name,IMAGE:.spec.containers[0].image' ++ grep perconalab/percona-xtradb-cluster-operator:PR-1697-26afa527 ++ awk '{print $1}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.WyMcQLE1t0 +++ mktemp ++ local LAST_ERR=/tmp/tmp.P4FBIRFHqS ++ 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 'custom-columns=NAME:.metadata.name,IMAGE:.spec.containers[0].image' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.WyMcQLE1t0 ++ cat /tmp/tmp.P4FBIRFHqS ++ rm /tmp/tmp.WyMcQLE1t0 /tmp/tmp.P4FBIRFHqS ++ return 0 + wait_pod percona-xtradb-cluster-operator-79dcbbbbbc-qgf4r + local pod=percona-xtradb-cluster-operator-79dcbbbbbc-qgf4r + local max_retry=480 + local ns= ++ echo percona-xtradb-cluster-operator-79dcbbbbbc-qgf4r ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/percona-xtradb-cluster-operator-79dcbbbbbc-qgf4r condition met waiting for pod/percona-xtradb-cluster-operator-79dcbbbbbc-qgf4r to become Ready.Ok ++ kubectl_bin config current-context +++ mktemp ++ local LAST_OUT=/tmp/tmp.0N5apqYiwu +++ mktemp ++ local LAST_ERR=/tmp/tmp.ZgClHcxCGt ++ 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.0N5apqYiwu ++ cat /tmp/tmp.ZgClHcxCGt ++ rm /tmp/tmp.0N5apqYiwu /tmp/tmp.ZgClHcxCGt ++ return 0 + kubectl_bin config set-context gke_cloud-dev-112233_us-central1-a_jen-pxc-1697-26afa527-8-cluster4 --namespace=upgrade-proxysql-26075 ++ mktemp + local LAST_OUT=/tmp/tmp.PF7SBYSvNn ++ mktemp + local LAST_ERR=/tmp/tmp.KADEGrjiit + 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-1697-26afa527-8-cluster4 --namespace=upgrade-proxysql-26075 + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.PF7SBYSvNn Context "gke_cloud-dev-112233_us-central1-a_jen-pxc-1697-26afa527-8-cluster4" modified. + cat /tmp/tmp.KADEGrjiit + rm /tmp/tmp.PF7SBYSvNn /tmp/tmp.KADEGrjiit + return 0 + desc 'check images and generation after operator upgrade' + set +o xtrace ----------------------------------------------------------------------------------- check images and generation after operator upgrade ----------------------------------------------------------------------------------- + check_pxc_liveness upgrade-proxysql 3 + local cluster=upgrade-proxysql + local cluster_size=3 + wait_cluster_consistency upgrade-proxysql 3 + local cluster_name=upgrade-proxysql + local cluster_size=3 + local proxy_size= + '[' -z '' ']' ++ get_proxy_size upgrade-proxysql ++ local cluster=upgrade-proxysql +++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.haproxy.enabled}' ++++ mktemp +++ local LAST_OUT=/tmp/tmp.HeotKijK14 ++++ mktemp +++ local LAST_ERR=/tmp/tmp.M3eWQVFMef +++ local exit_status=0 ++++ seq 0 2 +++ for i in '$(seq 0 2)' +++ set +e +++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.spec.haproxy.enabled}' +++ exit_status=0 +++ set -e +++ '[' 0 '!=' 0 ']' +++ break +++ cat /tmp/tmp.HeotKijK14 +++ cat /tmp/tmp.M3eWQVFMef +++ rm /tmp/tmp.HeotKijK14 /tmp/tmp.M3eWQVFMef +++ return 0 ++ [[ false == \t\r\u\e ]] +++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.enabled}' ++++ mktemp +++ local LAST_OUT=/tmp/tmp.pcg2vx2GpC ++++ mktemp +++ local LAST_ERR=/tmp/tmp.EYWTDM7Gxr +++ local exit_status=0 ++++ seq 0 2 +++ for i in '$(seq 0 2)' +++ set +e +++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.enabled}' +++ exit_status=0 +++ set -e +++ '[' 0 '!=' 0 ']' +++ break +++ cat /tmp/tmp.pcg2vx2GpC +++ cat /tmp/tmp.EYWTDM7Gxr +++ rm /tmp/tmp.pcg2vx2GpC /tmp/tmp.EYWTDM7Gxr +++ return 0 ++ [[ true == \t\r\u\e ]] ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.size}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.TQswBszA3Z +++ mktemp ++ local LAST_ERR=/tmp/tmp.X6tAMXdP9o ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.size}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.TQswBszA3Z ++ cat /tmp/tmp.X6tAMXdP9o ++ rm /tmp/tmp.TQswBszA3Z /tmp/tmp.X6tAMXdP9o ++ return 0 ++ return + proxy_size=3 + desc 'wait cluster consistency' + set +o xtrace ----------------------------------------------------------------------------------- wait cluster consistency ----------------------------------------------------------------------------------- + local i=0 + local max=36 + sleep 7 ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.iinbfZfkol +++ mktemp ++ local LAST_ERR=/tmp/tmp.DabOMUEMlb ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.iinbfZfkol ++ cat /tmp/tmp.DabOMUEMlb ++ rm /tmp/tmp.iinbfZfkol /tmp/tmp.DabOMUEMlb ++ return 0 + [[ ready == \r\e\a\d\y ]] ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.status.pxc.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.zmOJUFF5Om +++ mktemp ++ local LAST_ERR=/tmp/tmp.04Y742kEvE ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.status.pxc.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.zmOJUFF5Om ++ cat /tmp/tmp.04Y742kEvE ++ rm /tmp/tmp.zmOJUFF5Om /tmp/tmp.04Y742kEvE ++ return 0 + [[ 3 == \3 ]] +++ get_proxy_engine upgrade-proxysql +++ local cluster_name=upgrade-proxysql ++++ get_proxy upgrade-proxysql ++++ local target_cluster=upgrade-proxysql +++++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.haproxy.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.mI1tKPQ2nu ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.JdZbTzy002 +++++ local exit_status=0 ++++++ seq 0 2 +++++ for i in '$(seq 0 2)' +++++ set +e +++++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.spec.haproxy.enabled}' +++++ exit_status=0 +++++ set -e +++++ '[' 0 '!=' 0 ']' +++++ break +++++ cat /tmp/tmp.mI1tKPQ2nu +++++ cat /tmp/tmp.JdZbTzy002 +++++ rm /tmp/tmp.mI1tKPQ2nu /tmp/tmp.JdZbTzy002 +++++ return 0 ++++ [[ false == \t\r\u\e ]] +++++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.taOGHGoRu0 ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.FdYHuFwcRB +++++ local exit_status=0 ++++++ seq 0 2 +++++ for i in '$(seq 0 2)' +++++ set +e +++++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.enabled}' +++++ exit_status=0 +++++ set -e +++++ '[' 0 '!=' 0 ']' +++++ break +++++ cat /tmp/tmp.taOGHGoRu0 +++++ cat /tmp/tmp.FdYHuFwcRB +++++ rm /tmp/tmp.taOGHGoRu0 /tmp/tmp.FdYHuFwcRB +++++ return 0 ++++ [[ true == \t\r\u\e ]] ++++ echo upgrade-proxysql-proxysql ++++ return +++ local cluster_proxy=upgrade-proxysql-proxysql +++ echo proxysql ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.status.proxysql.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.wXtcGDzuC5 +++ mktemp ++ local LAST_ERR=/tmp/tmp.bTgcRuXDH6 ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.status.proxysql.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.wXtcGDzuC5 ++ cat /tmp/tmp.bTgcRuXDH6 ++ rm /tmp/tmp.wXtcGDzuC5 /tmp/tmp.bTgcRuXDH6 ++ return 0 + [[ 3 == \3 ]] + wait_for_running upgrade-proxysql-pxc 3 + local name=upgrade-proxysql-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 upgrade-proxysql-pxc-0 480 + local pod=upgrade-proxysql-pxc-0 + local max_retry=480 + local ns= ++ echo upgrade-proxysql-pxc-0 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container=pxc + set +o xtrace pod/upgrade-proxysql-pxc-0 condition met waiting for pod/upgrade-proxysql-pxc-0 to become Ready.Ok + for i in '$(seq 0 $last_pod)' + wait_pod upgrade-proxysql-pxc-1 480 + local pod=upgrade-proxysql-pxc-1 + local max_retry=480 + local ns= ++ echo upgrade-proxysql-pxc-1 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container=pxc + set +o xtrace pod/upgrade-proxysql-pxc-1 condition met waiting for pod/upgrade-proxysql-pxc-1 to become Ready.Ok + for i in '$(seq 0 $last_pod)' + wait_pod upgrade-proxysql-pxc-2 480 + local pod=upgrade-proxysql-pxc-2 + local max_retry=480 + local ns= ++ echo upgrade-proxysql-pxc-2 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container=pxc + set +o xtrace pod/upgrade-proxysql-pxc-2 condition met waiting for pod/upgrade-proxysql-pxc-2 to become Ready.Ok ++ seq 0 2 + for i in '$(seq 0 $((cluster_size - 1)))' + compare_mysql_cmd select-1 'SELECT * from myApp.myApp;' '-h upgrade-proxysql-pxc-0.upgrade-proxysql-pxc -uroot -proot_password' + local command_id=select-1 + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h upgrade-proxysql-pxc-0.upgrade-proxysql-pxc -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/select-1.sql + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.4 ]] + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.0 ]] + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 5\.7 ]] + [[ -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/select-1-57.sql ]] + run_mysql 'SELECT * from myApp.myApp;' '-h upgrade-proxysql-pxc-0.upgrade-proxysql-pxc -uroot -proot_password' + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h upgrade-proxysql-pxc-0.upgrade-proxysql-pxc -uroot -proot_password' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.7bEPM9UoHA +++ mktemp ++ local LAST_ERR=/tmp/tmp.wx4THOcNdv ++ 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.7bEPM9UoHA ++ cat /tmp/tmp.wx4THOcNdv ++ rm /tmp/tmp.7bEPM9UoHA /tmp/tmp.wx4THOcNdv ++ return 0 + client_pod=pxc-client-75589d8bb5-885cw + wait_pod pxc-client-75589d8bb5-885cw + local pod=pxc-client-75589d8bb5-885cw + local max_retry=480 + local ns= ++ echo pxc-client-75589d8bb5-885cw ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-75589d8bb5-885cw condition met waiting for pod/pxc-client-75589d8bb5-885cw to become Ready.Ok + set +o xtrace + '[' '!' -s /tmp/tmp.Kfg0SCarWM/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/select-1.sql /tmp/tmp.Kfg0SCarWM/select-1.sql + for i in '$(seq 0 $((cluster_size - 1)))' + compare_mysql_cmd select-1 'SELECT * from myApp.myApp;' '-h upgrade-proxysql-pxc-1.upgrade-proxysql-pxc -uroot -proot_password' + local command_id=select-1 + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h upgrade-proxysql-pxc-1.upgrade-proxysql-pxc -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/select-1.sql + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.4 ]] + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.0 ]] + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 5\.7 ]] + [[ -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/select-1-57.sql ]] + run_mysql 'SELECT * from myApp.myApp;' '-h upgrade-proxysql-pxc-1.upgrade-proxysql-pxc -uroot -proot_password' + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h upgrade-proxysql-pxc-1.upgrade-proxysql-pxc -uroot -proot_password' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.sbL4FpvFUM +++ mktemp ++ local LAST_ERR=/tmp/tmp.JJeFxYFeNc ++ 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.sbL4FpvFUM ++ cat /tmp/tmp.JJeFxYFeNc ++ rm /tmp/tmp.sbL4FpvFUM /tmp/tmp.JJeFxYFeNc ++ return 0 + client_pod=pxc-client-75589d8bb5-885cw + wait_pod pxc-client-75589d8bb5-885cw + local pod=pxc-client-75589d8bb5-885cw + local max_retry=480 + local ns= ++ echo pxc-client-75589d8bb5-885cw ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-75589d8bb5-885cw condition met waiting for pod/pxc-client-75589d8bb5-885cw to become Ready.Ok + set +o xtrace + '[' '!' -s /tmp/tmp.Kfg0SCarWM/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/select-1.sql /tmp/tmp.Kfg0SCarWM/select-1.sql + for i in '$(seq 0 $((cluster_size - 1)))' + compare_mysql_cmd select-1 'SELECT * from myApp.myApp;' '-h upgrade-proxysql-pxc-2.upgrade-proxysql-pxc -uroot -proot_password' + local command_id=select-1 + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h upgrade-proxysql-pxc-2.upgrade-proxysql-pxc -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/select-1.sql + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.4 ]] + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.0 ]] + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 5\.7 ]] + [[ -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/select-1-57.sql ]] + run_mysql 'SELECT * from myApp.myApp;' '-h upgrade-proxysql-pxc-2.upgrade-proxysql-pxc -uroot -proot_password' + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h upgrade-proxysql-pxc-2.upgrade-proxysql-pxc -uroot -proot_password' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.fV1bxj8jT2 +++ mktemp ++ local LAST_ERR=/tmp/tmp.o7EiZZgyq5 ++ 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.fV1bxj8jT2 ++ cat /tmp/tmp.o7EiZZgyq5 ++ rm /tmp/tmp.fV1bxj8jT2 /tmp/tmp.o7EiZZgyq5 ++ return 0 + client_pod=pxc-client-75589d8bb5-885cw + wait_pod pxc-client-75589d8bb5-885cw + local pod=pxc-client-75589d8bb5-885cw + local max_retry=480 + local ns= ++ echo pxc-client-75589d8bb5-885cw ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-75589d8bb5-885cw condition met waiting for pod/pxc-client-75589d8bb5-885cw to become Ready.Ok + set +o xtrace + '[' '!' -s /tmp/tmp.Kfg0SCarWM/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/select-1.sql /tmp/tmp.Kfg0SCarWM/select-1.sql ++ kubectl_bin get pod -n pxc-operator --selector=app.kubernetes.io/name=percona-xtradb-cluster-operator -o 'jsonpath={.items[*].spec.containers[?(@.name == "percona-xtradb-cluster-operator")].image}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.6lHsg9fLT9 +++ mktemp ++ local LAST_ERR=/tmp/tmp.6iZH9Bo6zE ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pod -n pxc-operator --selector=app.kubernetes.io/name=percona-xtradb-cluster-operator -o 'jsonpath={.items[*].spec.containers[?(@.name == "percona-xtradb-cluster-operator")].image}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.6lHsg9fLT9 ++ cat /tmp/tmp.6iZH9Bo6zE ++ rm /tmp/tmp.6lHsg9fLT9 /tmp/tmp.6iZH9Bo6zE ++ return 0 + [[ perconalab/percona-xtradb-cluster-operator:PR-1697-26afa527 == perconalab/percona-xtradb-cluster-operator:PR-1697-26afa527 ]] ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.image}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.RmUST0zflS +++ mktemp ++ local LAST_ERR=/tmp/tmp.Ri6eZUGVoM ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.image}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.RmUST0zflS ++ cat /tmp/tmp.Ri6eZUGVoM ++ rm /tmp/tmp.RmUST0zflS /tmp/tmp.Ri6eZUGVoM ++ return 0 + [[ percona/proxysql2:2.5.5 == percona/proxysql2:2.5.5 ]] ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.haproxy.image}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.Xk7toVnJfS +++ mktemp ++ local LAST_ERR=/tmp/tmp.AfTOPxEqqa ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.spec.haproxy.image}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.Xk7toVnJfS ++ cat /tmp/tmp.AfTOPxEqqa ++ rm /tmp/tmp.Xk7toVnJfS /tmp/tmp.AfTOPxEqqa ++ return 0 + [[ percona/haproxy:2.8.5 == percona/haproxy:2.8.5 ]] ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.backup.image}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.2ucCftAyqW +++ mktemp ++ local LAST_ERR=/tmp/tmp.Purwf0pbYC ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.spec.backup.image}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.2ucCftAyqW ++ cat /tmp/tmp.Purwf0pbYC ++ rm /tmp/tmp.2ucCftAyqW /tmp/tmp.Purwf0pbYC ++ return 0 + [[ percona/percona-xtradb-cluster-operator:1.15.1-pxc5.7-backup-pxb2.4.29 == percona/percona-xtradb-cluster-operator:1.15.1-pxc5.7-backup-pxb2.4.29 ]] ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.pmm.image}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.Bzu47gOhKr +++ mktemp ++ local LAST_ERR=/tmp/tmp.kNObx6UYgq ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.spec.pmm.image}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.Bzu47gOhKr ++ cat /tmp/tmp.kNObx6UYgq ++ rm /tmp/tmp.Bzu47gOhKr /tmp/tmp.kNObx6UYgq ++ return 0 + [[ percona/pmm-client:2.42.0 == percona/pmm-client:2.42.0 ]] ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.pxc.image}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.369vSd8zUF +++ mktemp ++ local LAST_ERR=/tmp/tmp.ZyWf5uDrnZ ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.spec.pxc.image}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.369vSd8zUF ++ cat /tmp/tmp.ZyWf5uDrnZ ++ rm /tmp/tmp.369vSd8zUF /tmp/tmp.ZyWf5uDrnZ ++ return 0 + [[ percona/percona-xtradb-cluster:5.7.44-31.65 == percona/percona-xtradb-cluster:5.7.44-31.65 ]] + : Operator image has been updated correctly + compare_generation 1 proxysql upgrade-proxysql + local generation=1 + local proxy=proxysql + local cluster=upgrade-proxysql + local current_generation + [[ proxysql == \h\a\p\r\o\x\y ]] + containers=(pxc proxysql) + for container in '"${containers[@]}"' + check_generation 1 pxc upgrade-proxysql + local generation=1 + local container=pxc + local cluster=upgrade-proxysql + local current_generation ++ kubectl_bin get statefulset upgrade-proxysql-pxc -o 'jsonpath={.metadata.generation}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.1bS3Qr6FR0 +++ mktemp ++ local LAST_ERR=/tmp/tmp.gpXJsJT6fc ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get statefulset upgrade-proxysql-pxc -o 'jsonpath={.metadata.generation}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.1bS3Qr6FR0 ++ cat /tmp/tmp.gpXJsJT6fc ++ rm /tmp/tmp.1bS3Qr6FR0 /tmp/tmp.gpXJsJT6fc ++ return 0 + current_generation=1 + [[ 1 != \1 ]] + for container in '"${containers[@]}"' + check_generation 1 proxysql upgrade-proxysql + local generation=1 + local container=proxysql + local cluster=upgrade-proxysql + local current_generation ++ kubectl_bin get statefulset upgrade-proxysql-proxysql -o 'jsonpath={.metadata.generation}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.qZJPMh5f79 +++ mktemp ++ local LAST_ERR=/tmp/tmp.wuffhPHqZv ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get statefulset upgrade-proxysql-proxysql -o 'jsonpath={.metadata.generation}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.qZJPMh5f79 ++ cat /tmp/tmp.wuffhPHqZv ++ rm /tmp/tmp.qZJPMh5f79 /tmp/tmp.wuffhPHqZv ++ return 0 + current_generation=1 + [[ 1 != \1 ]] + desc 'patch pxc images and upgrade' + set +o xtrace ----------------------------------------------------------------------------------- patch pxc images and upgrade ----------------------------------------------------------------------------------- + kubectl_bin patch pxc upgrade-proxysql --type=merge --patch '{ "spec": { "crVersion": "1.16.0", "pxc": { "image": "perconalab/percona-xtradb-cluster-operator:main-pxc5.7" }, "pmm": { "image": "perconalab/pmm-client:dev-latest" }, "haproxy": { "image": "perconalab/percona-xtradb-cluster-operator:main-haproxy" }, "proxysql": { "image": "perconalab/percona-xtradb-cluster-operator:main-proxysql" }, "backup": { "image": "perconalab/percona-xtradb-cluster-operator:main-pxc5.7-backup" } }}' ++ mktemp + local LAST_OUT=/tmp/tmp.1TPt9xQ6MI ++ mktemp + local LAST_ERR=/tmp/tmp.tofgYEimlv + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl patch pxc upgrade-proxysql --type=merge --patch '{ "spec": { "crVersion": "1.16.0", "pxc": { "image": "perconalab/percona-xtradb-cluster-operator:main-pxc5.7" }, "pmm": { "image": "perconalab/pmm-client:dev-latest" }, "haproxy": { "image": "perconalab/percona-xtradb-cluster-operator:main-haproxy" }, "proxysql": { "image": "perconalab/percona-xtradb-cluster-operator:main-proxysql" }, "backup": { "image": "perconalab/percona-xtradb-cluster-operator:main-pxc5.7-backup" } }}' + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.1TPt9xQ6MI perconaxtradbcluster.pxc.percona.com/upgrade-proxysql patched + cat /tmp/tmp.tofgYEimlv + rm /tmp/tmp.1TPt9xQ6MI /tmp/tmp.tofgYEimlv + return 0 + sleep 10 + desc 'check images and generation after full upgrade' + set +o xtrace ----------------------------------------------------------------------------------- check images and generation after full upgrade ----------------------------------------------------------------------------------- + check_pxc_liveness upgrade-proxysql 3 + local cluster=upgrade-proxysql + local cluster_size=3 + wait_cluster_consistency upgrade-proxysql 3 + local cluster_name=upgrade-proxysql + local cluster_size=3 + local proxy_size= + '[' -z '' ']' ++ get_proxy_size upgrade-proxysql ++ local cluster=upgrade-proxysql +++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.haproxy.enabled}' ++++ mktemp +++ local LAST_OUT=/tmp/tmp.z8JG6d3CyM ++++ mktemp +++ local LAST_ERR=/tmp/tmp.pFPH6HNcol +++ local exit_status=0 ++++ seq 0 2 +++ for i in '$(seq 0 2)' +++ set +e +++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.spec.haproxy.enabled}' +++ exit_status=0 +++ set -e +++ '[' 0 '!=' 0 ']' +++ break +++ cat /tmp/tmp.z8JG6d3CyM +++ cat /tmp/tmp.pFPH6HNcol +++ rm /tmp/tmp.z8JG6d3CyM /tmp/tmp.pFPH6HNcol +++ return 0 ++ [[ false == \t\r\u\e ]] +++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.enabled}' ++++ mktemp +++ local LAST_OUT=/tmp/tmp.CcqJVcI9tf ++++ mktemp +++ local LAST_ERR=/tmp/tmp.9so1mK1B4u +++ local exit_status=0 ++++ seq 0 2 +++ for i in '$(seq 0 2)' +++ set +e +++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.enabled}' +++ exit_status=0 +++ set -e +++ '[' 0 '!=' 0 ']' +++ break +++ cat /tmp/tmp.CcqJVcI9tf +++ cat /tmp/tmp.9so1mK1B4u +++ rm /tmp/tmp.CcqJVcI9tf /tmp/tmp.9so1mK1B4u +++ return 0 ++ [[ true == \t\r\u\e ]] ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.size}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.4OgVLbdC9J +++ mktemp ++ local LAST_ERR=/tmp/tmp.JXLtGLims2 ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.size}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.4OgVLbdC9J ++ cat /tmp/tmp.JXLtGLims2 ++ rm /tmp/tmp.4OgVLbdC9J /tmp/tmp.JXLtGLims2 ++ return 0 ++ return + proxy_size=3 + desc 'wait cluster consistency' + set +o xtrace ----------------------------------------------------------------------------------- wait cluster consistency ----------------------------------------------------------------------------------- + local i=0 + local max=36 + sleep 7 ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.WCv2ZKrFjR +++ mktemp ++ local LAST_ERR=/tmp/tmp.5x3s8rPTkA ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.WCv2ZKrFjR ++ cat /tmp/tmp.5x3s8rPTkA ++ rm /tmp/tmp.WCv2ZKrFjR /tmp/tmp.5x3s8rPTkA ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo 'waiting for cluster readyness' waiting for cluster readyness + sleep 20 + [[ 0 -ge 36 ]] + let i+=1 ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.dMPlBwFSce +++ mktemp ++ local LAST_ERR=/tmp/tmp.4GwBKbDc2A ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.dMPlBwFSce ++ cat /tmp/tmp.4GwBKbDc2A ++ rm /tmp/tmp.dMPlBwFSce /tmp/tmp.4GwBKbDc2A ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo 'waiting for cluster readyness' waiting for cluster readyness + sleep 20 + [[ 1 -ge 36 ]] + let i+=1 ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.dxWzFozxoJ +++ mktemp ++ local LAST_ERR=/tmp/tmp.1vsm8F3LLV ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.dxWzFozxoJ ++ cat /tmp/tmp.1vsm8F3LLV ++ rm /tmp/tmp.dxWzFozxoJ /tmp/tmp.1vsm8F3LLV ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo 'waiting for cluster readyness' waiting for cluster readyness + sleep 20 + [[ 2 -ge 36 ]] + let i+=1 ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.OoD0U0SWnw +++ mktemp ++ local LAST_ERR=/tmp/tmp.gg7H8InSrE ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.OoD0U0SWnw ++ cat /tmp/tmp.gg7H8InSrE ++ rm /tmp/tmp.OoD0U0SWnw /tmp/tmp.gg7H8InSrE ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo 'waiting for cluster readyness' waiting for cluster readyness + sleep 20 + [[ 3 -ge 36 ]] + let i+=1 ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.Zt6JwALKnJ +++ mktemp ++ local LAST_ERR=/tmp/tmp.Zpa3e279rA ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.Zt6JwALKnJ ++ cat /tmp/tmp.Zpa3e279rA ++ rm /tmp/tmp.Zt6JwALKnJ /tmp/tmp.Zpa3e279rA ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo 'waiting for cluster readyness' waiting for cluster readyness + sleep 20 + [[ 4 -ge 36 ]] + let i+=1 ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.zoA8Eh4fer +++ mktemp ++ local LAST_ERR=/tmp/tmp.3vZepYy4hL ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.zoA8Eh4fer ++ cat /tmp/tmp.3vZepYy4hL ++ rm /tmp/tmp.zoA8Eh4fer /tmp/tmp.3vZepYy4hL ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo 'waiting for cluster readyness' waiting for cluster readyness + sleep 20 + [[ 5 -ge 36 ]] + let i+=1 ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.VRRrPYJThS +++ mktemp ++ local LAST_ERR=/tmp/tmp.57pfzwACD1 ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.VRRrPYJThS ++ cat /tmp/tmp.57pfzwACD1 ++ rm /tmp/tmp.VRRrPYJThS /tmp/tmp.57pfzwACD1 ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo 'waiting for cluster readyness' waiting for cluster readyness + sleep 20 + [[ 6 -ge 36 ]] + let i+=1 ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.vo3Y2TFqNC +++ mktemp ++ local LAST_ERR=/tmp/tmp.PQxKgf994r ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.vo3Y2TFqNC ++ cat /tmp/tmp.PQxKgf994r ++ rm /tmp/tmp.vo3Y2TFqNC /tmp/tmp.PQxKgf994r ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo 'waiting for cluster readyness' waiting for cluster readyness + sleep 20 + [[ 7 -ge 36 ]] + let i+=1 ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.3RAoGyOSiu +++ mktemp ++ local LAST_ERR=/tmp/tmp.PkVy3nHT1K ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.3RAoGyOSiu ++ cat /tmp/tmp.PkVy3nHT1K ++ rm /tmp/tmp.3RAoGyOSiu /tmp/tmp.PkVy3nHT1K ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo 'waiting for cluster readyness' waiting for cluster readyness + sleep 20 + [[ 8 -ge 36 ]] + let i+=1 ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.g27I4vaXlP +++ mktemp ++ local LAST_ERR=/tmp/tmp.IuwDPPDv2H ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.g27I4vaXlP ++ cat /tmp/tmp.IuwDPPDv2H ++ rm /tmp/tmp.g27I4vaXlP /tmp/tmp.IuwDPPDv2H ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo 'waiting for cluster readyness' waiting for cluster readyness + sleep 20 + [[ 9 -ge 36 ]] + let i+=1 ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.jfimGgUoq9 +++ mktemp ++ local LAST_ERR=/tmp/tmp.89Svu598rp ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.jfimGgUoq9 ++ cat /tmp/tmp.89Svu598rp ++ rm /tmp/tmp.jfimGgUoq9 /tmp/tmp.89Svu598rp ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo 'waiting for cluster readyness' waiting for cluster readyness + sleep 20 + [[ 10 -ge 36 ]] + let i+=1 ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.1inurYj1wm +++ mktemp ++ local LAST_ERR=/tmp/tmp.cj7w4am3aK ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.1inurYj1wm ++ cat /tmp/tmp.cj7w4am3aK ++ rm /tmp/tmp.1inurYj1wm /tmp/tmp.cj7w4am3aK ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo 'waiting for cluster readyness' waiting for cluster readyness + sleep 20 + [[ 11 -ge 36 ]] + let i+=1 ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.Zc28HFxANb +++ mktemp ++ local LAST_ERR=/tmp/tmp.KzMFLe12i2 ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.Zc28HFxANb ++ cat /tmp/tmp.KzMFLe12i2 ++ rm /tmp/tmp.Zc28HFxANb /tmp/tmp.KzMFLe12i2 ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo 'waiting for cluster readyness' waiting for cluster readyness + sleep 20 + [[ 12 -ge 36 ]] + let i+=1 ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.cTUN6Es4Bi +++ mktemp ++ local LAST_ERR=/tmp/tmp.XKCoQgQ6cF ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.status.state}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.cTUN6Es4Bi ++ cat /tmp/tmp.XKCoQgQ6cF ++ rm /tmp/tmp.cTUN6Es4Bi /tmp/tmp.XKCoQgQ6cF ++ return 0 + [[ ready == \r\e\a\d\y ]] ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.status.pxc.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.5oOJvAXmZ8 +++ mktemp ++ local LAST_ERR=/tmp/tmp.tAqPXg4oZW ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.status.pxc.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.5oOJvAXmZ8 ++ cat /tmp/tmp.tAqPXg4oZW ++ rm /tmp/tmp.5oOJvAXmZ8 /tmp/tmp.tAqPXg4oZW ++ return 0 + [[ 3 == \3 ]] +++ get_proxy_engine upgrade-proxysql +++ local cluster_name=upgrade-proxysql ++++ get_proxy upgrade-proxysql ++++ local target_cluster=upgrade-proxysql +++++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.haproxy.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.1ZUVtr5aVV ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.f2yNmxO5gT +++++ local exit_status=0 ++++++ seq 0 2 +++++ for i in '$(seq 0 2)' +++++ set +e +++++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.spec.haproxy.enabled}' +++++ exit_status=0 +++++ set -e +++++ '[' 0 '!=' 0 ']' +++++ break +++++ cat /tmp/tmp.1ZUVtr5aVV +++++ cat /tmp/tmp.f2yNmxO5gT +++++ rm /tmp/tmp.1ZUVtr5aVV /tmp/tmp.f2yNmxO5gT +++++ return 0 ++++ [[ false == \t\r\u\e ]] +++++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.wxOFcTGQ0b ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.BVQmSxlaij +++++ local exit_status=0 ++++++ seq 0 2 +++++ for i in '$(seq 0 2)' +++++ set +e +++++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.enabled}' +++++ exit_status=0 +++++ set -e +++++ '[' 0 '!=' 0 ']' +++++ break +++++ cat /tmp/tmp.wxOFcTGQ0b +++++ cat /tmp/tmp.BVQmSxlaij +++++ rm /tmp/tmp.wxOFcTGQ0b /tmp/tmp.BVQmSxlaij +++++ return 0 ++++ [[ true == \t\r\u\e ]] ++++ echo upgrade-proxysql-proxysql ++++ return +++ local cluster_proxy=upgrade-proxysql-proxysql +++ echo proxysql ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.status.proxysql.ready}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.rEBEPDCf6R +++ mktemp ++ local LAST_ERR=/tmp/tmp.RugubfT54r ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.status.proxysql.ready}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.rEBEPDCf6R ++ cat /tmp/tmp.RugubfT54r ++ rm /tmp/tmp.rEBEPDCf6R /tmp/tmp.RugubfT54r ++ return 0 + [[ 3 == \3 ]] + wait_for_running upgrade-proxysql-pxc 3 + local name=upgrade-proxysql-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 upgrade-proxysql-pxc-0 480 + local pod=upgrade-proxysql-pxc-0 + local max_retry=480 + local ns= ++ echo upgrade-proxysql-pxc-0 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container=pxc + set +o xtrace pod/upgrade-proxysql-pxc-0 condition met waiting for pod/upgrade-proxysql-pxc-0 to become Ready.Ok + for i in '$(seq 0 $last_pod)' + wait_pod upgrade-proxysql-pxc-1 480 + local pod=upgrade-proxysql-pxc-1 + local max_retry=480 + local ns= ++ echo upgrade-proxysql-pxc-1 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container=pxc + set +o xtrace pod/upgrade-proxysql-pxc-1 condition met waiting for pod/upgrade-proxysql-pxc-1 to become Ready.Ok + for i in '$(seq 0 $last_pod)' + wait_pod upgrade-proxysql-pxc-2 480 + local pod=upgrade-proxysql-pxc-2 + local max_retry=480 + local ns= ++ echo upgrade-proxysql-pxc-2 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container=pxc + set +o xtrace pod/upgrade-proxysql-pxc-2 condition met waiting for pod/upgrade-proxysql-pxc-2 to become Ready.Ok ++ seq 0 2 + for i in '$(seq 0 $((cluster_size - 1)))' + compare_mysql_cmd select-1 'SELECT * from myApp.myApp;' '-h upgrade-proxysql-pxc-0.upgrade-proxysql-pxc -uroot -proot_password' + local command_id=select-1 + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h upgrade-proxysql-pxc-0.upgrade-proxysql-pxc -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/select-1.sql + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.4 ]] + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.0 ]] + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 5\.7 ]] + [[ -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/select-1-57.sql ]] + run_mysql 'SELECT * from myApp.myApp;' '-h upgrade-proxysql-pxc-0.upgrade-proxysql-pxc -uroot -proot_password' + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h upgrade-proxysql-pxc-0.upgrade-proxysql-pxc -uroot -proot_password' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.3vpHyCTGdq +++ mktemp ++ local LAST_ERR=/tmp/tmp.1gncaR6ftl ++ 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.3vpHyCTGdq ++ cat /tmp/tmp.1gncaR6ftl ++ rm /tmp/tmp.3vpHyCTGdq /tmp/tmp.1gncaR6ftl ++ return 0 + client_pod=pxc-client-75589d8bb5-885cw + wait_pod pxc-client-75589d8bb5-885cw + local pod=pxc-client-75589d8bb5-885cw + local max_retry=480 + local ns= ++ echo pxc-client-75589d8bb5-885cw ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-75589d8bb5-885cw condition met waiting for pod/pxc-client-75589d8bb5-885cw to become Ready.Ok + set +o xtrace + '[' '!' -s /tmp/tmp.Kfg0SCarWM/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/select-1.sql /tmp/tmp.Kfg0SCarWM/select-1.sql + for i in '$(seq 0 $((cluster_size - 1)))' + compare_mysql_cmd select-1 'SELECT * from myApp.myApp;' '-h upgrade-proxysql-pxc-1.upgrade-proxysql-pxc -uroot -proot_password' + local command_id=select-1 + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h upgrade-proxysql-pxc-1.upgrade-proxysql-pxc -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/select-1.sql + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.4 ]] + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.0 ]] + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 5\.7 ]] + [[ -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/select-1-57.sql ]] + run_mysql 'SELECT * from myApp.myApp;' '-h upgrade-proxysql-pxc-1.upgrade-proxysql-pxc -uroot -proot_password' + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h upgrade-proxysql-pxc-1.upgrade-proxysql-pxc -uroot -proot_password' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.IFhYtS378z +++ mktemp ++ local LAST_ERR=/tmp/tmp.fC7BiCtYmO ++ 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.IFhYtS378z ++ cat /tmp/tmp.fC7BiCtYmO ++ rm /tmp/tmp.IFhYtS378z /tmp/tmp.fC7BiCtYmO ++ return 0 + client_pod=pxc-client-75589d8bb5-885cw + wait_pod pxc-client-75589d8bb5-885cw + local pod=pxc-client-75589d8bb5-885cw + local max_retry=480 + local ns= ++ echo pxc-client-75589d8bb5-885cw ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-75589d8bb5-885cw condition met waiting for pod/pxc-client-75589d8bb5-885cw to become Ready.Ok + set +o xtrace + '[' '!' -s /tmp/tmp.Kfg0SCarWM/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/select-1.sql /tmp/tmp.Kfg0SCarWM/select-1.sql + for i in '$(seq 0 $((cluster_size - 1)))' + compare_mysql_cmd select-1 'SELECT * from myApp.myApp;' '-h upgrade-proxysql-pxc-2.upgrade-proxysql-pxc -uroot -proot_password' + local command_id=select-1 + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h upgrade-proxysql-pxc-2.upgrade-proxysql-pxc -uroot -proot_password' + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/select-1.sql + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.4 ]] + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.0 ]] + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 5\.7 ]] + [[ -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/select-1-57.sql ]] + run_mysql 'SELECT * from myApp.myApp;' '-h upgrade-proxysql-pxc-2.upgrade-proxysql-pxc -uroot -proot_password' + local 'command=SELECT * from myApp.myApp;' + local 'uri=-h upgrade-proxysql-pxc-2.upgrade-proxysql-pxc -uroot -proot_password' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.3dTqETKJrR +++ mktemp ++ local LAST_ERR=/tmp/tmp.2W6hpMZwua ++ 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.3dTqETKJrR ++ cat /tmp/tmp.2W6hpMZwua ++ rm /tmp/tmp.3dTqETKJrR /tmp/tmp.2W6hpMZwua ++ return 0 + client_pod=pxc-client-75589d8bb5-885cw + wait_pod pxc-client-75589d8bb5-885cw + local pod=pxc-client-75589d8bb5-885cw + local max_retry=480 + local ns= ++ echo pxc-client-75589d8bb5-885cw ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-75589d8bb5-885cw condition met waiting for pod/pxc-client-75589d8bb5-885cw to become Ready.Ok + set +o xtrace + '[' '!' -s /tmp/tmp.Kfg0SCarWM/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/select-1.sql /tmp/tmp.Kfg0SCarWM/select-1.sql ++ kubectl_bin get pod -n pxc-operator --selector=app.kubernetes.io/name=percona-xtradb-cluster-operator -o 'jsonpath={.items[*].spec.containers[?(@.name == "percona-xtradb-cluster-operator")].image}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.49WIKbrXk1 +++ mktemp ++ local LAST_ERR=/tmp/tmp.eDQIYBMD44 ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pod -n pxc-operator --selector=app.kubernetes.io/name=percona-xtradb-cluster-operator -o 'jsonpath={.items[*].spec.containers[?(@.name == "percona-xtradb-cluster-operator")].image}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.49WIKbrXk1 ++ cat /tmp/tmp.eDQIYBMD44 ++ rm /tmp/tmp.49WIKbrXk1 /tmp/tmp.eDQIYBMD44 ++ return 0 + [[ perconalab/percona-xtradb-cluster-operator:PR-1697-26afa527 == perconalab/percona-xtradb-cluster-operator:PR-1697-26afa527 ]] ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.image}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.XrdN1AVnHN +++ mktemp ++ local LAST_ERR=/tmp/tmp.ELLfaW1N3F ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.image}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.XrdN1AVnHN ++ cat /tmp/tmp.ELLfaW1N3F ++ rm /tmp/tmp.XrdN1AVnHN /tmp/tmp.ELLfaW1N3F ++ return 0 + [[ perconalab/percona-xtradb-cluster-operator:main-proxysql == perconalab/percona-xtradb-cluster-operator:main-proxysql ]] ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.haproxy.image}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.R0zv8Pyuwm +++ mktemp ++ local LAST_ERR=/tmp/tmp.NXpGLj5gWE ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.spec.haproxy.image}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.R0zv8Pyuwm ++ cat /tmp/tmp.NXpGLj5gWE ++ rm /tmp/tmp.R0zv8Pyuwm /tmp/tmp.NXpGLj5gWE ++ return 0 + [[ perconalab/percona-xtradb-cluster-operator:main-haproxy == perconalab/percona-xtradb-cluster-operator:main-haproxy ]] ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.backup.image}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.PjmlVdT43N +++ mktemp ++ local LAST_ERR=/tmp/tmp.JnYtCD8YI3 ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.spec.backup.image}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.PjmlVdT43N ++ cat /tmp/tmp.JnYtCD8YI3 ++ rm /tmp/tmp.PjmlVdT43N /tmp/tmp.JnYtCD8YI3 ++ return 0 + [[ perconalab/percona-xtradb-cluster-operator:main-pxc5.7-backup == perconalab/percona-xtradb-cluster-operator:main-pxc5.7-backup ]] ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.pmm.image}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.91gaHSFSMh +++ mktemp ++ local LAST_ERR=/tmp/tmp.AurRRxx4RZ ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.spec.pmm.image}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.91gaHSFSMh ++ cat /tmp/tmp.AurRRxx4RZ ++ rm /tmp/tmp.91gaHSFSMh /tmp/tmp.AurRRxx4RZ ++ return 0 + [[ perconalab/pmm-client:dev-latest == perconalab/pmm-client:dev-latest ]] ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.pxc.image}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.N5RImw1K2F +++ mktemp ++ local LAST_ERR=/tmp/tmp.Fm1LPiE0C3 ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get pxc upgrade-proxysql -o 'jsonpath={.spec.pxc.image}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.N5RImw1K2F ++ cat /tmp/tmp.Fm1LPiE0C3 ++ rm /tmp/tmp.N5RImw1K2F /tmp/tmp.Fm1LPiE0C3 ++ return 0 + [[ perconalab/percona-xtradb-cluster-operator:main-pxc5.7 == perconalab/percona-xtradb-cluster-operator:main-pxc5.7 ]] + : Cluster images have been updated correctly + compare_generation 2 proxysql upgrade-proxysql + local generation=2 + local proxy=proxysql + local cluster=upgrade-proxysql + local current_generation + [[ proxysql == \h\a\p\r\o\x\y ]] + containers=(pxc proxysql) + for container in '"${containers[@]}"' + check_generation 2 pxc upgrade-proxysql + local generation=2 + local container=pxc + local cluster=upgrade-proxysql + local current_generation ++ kubectl_bin get statefulset upgrade-proxysql-pxc -o 'jsonpath={.metadata.generation}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.Qk90z49nrO +++ mktemp ++ local LAST_ERR=/tmp/tmp.vK7igAWWuu ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get statefulset upgrade-proxysql-pxc -o 'jsonpath={.metadata.generation}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.Qk90z49nrO ++ cat /tmp/tmp.vK7igAWWuu ++ rm /tmp/tmp.Qk90z49nrO /tmp/tmp.vK7igAWWuu ++ return 0 + current_generation=2 + [[ 2 != \2 ]] + for container in '"${containers[@]}"' + check_generation 2 proxysql upgrade-proxysql + local generation=2 + local container=proxysql + local cluster=upgrade-proxysql + local current_generation ++ kubectl_bin get statefulset upgrade-proxysql-proxysql -o 'jsonpath={.metadata.generation}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.e72gGKMmbl +++ mktemp ++ local LAST_ERR=/tmp/tmp.dYvAQVu6oQ ++ local exit_status=0 +++ seq 0 2 ++ for i in '$(seq 0 2)' ++ set +e ++ kubectl get statefulset upgrade-proxysql-proxysql -o 'jsonpath={.metadata.generation}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.e72gGKMmbl ++ cat /tmp/tmp.dYvAQVu6oQ ++ rm /tmp/tmp.e72gGKMmbl /tmp/tmp.dYvAQVu6oQ ++ return 0 + current_generation=2 + [[ 2 != \2 ]] + compare_kubectl statefulset/upgrade-proxysql-pxc + local resource=statefulset/upgrade-proxysql-pxc + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-pxc.yml + local new_result=/tmp/tmp.Kfg0SCarWM/statefulset_upgrade-proxysql-pxc.yml + desc 'compare statefulset/upgrade-proxysql-pxc-' + set +o xtrace ----------------------------------------------------------------------------------- compare statefulset/upgrade-proxysql-pxc- ----------------------------------------------------------------------------------- + '[' 0 = 1 -a -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-pxc-eks.yml ']' + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.0 ]] + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.4 ]] + version_gt 1.29 + desc 'return true if kubernetes version equal or greater than desired' + set +o xtrace ----------------------------------------------------------------------------------- return true if kubernetes version equal or greater than desired ----------------------------------------------------------------------------------- ++ echo '1.28 >= 1.29' ++ bc -l + '[' 0 -eq 1 ']' + return 1 + version_gt 1.27 + desc 'return true if kubernetes version equal or greater than desired' + set +o xtrace ----------------------------------------------------------------------------------- return true if kubernetes version equal or greater than desired ----------------------------------------------------------------------------------- ++ echo '1.28 >= 1.27' ++ bc -l + '[' 1 -eq 1 ']' + return 0 + '[' -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-pxc-k127.yml ']' + expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-pxc-k127.yml + '[' '!' -z '' -a -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-pxc-k127-oc.yml ']' + version_gt 1.29 + desc 'return true if kubernetes version equal or greater than desired' + set +o xtrace ----------------------------------------------------------------------------------- return true if kubernetes version equal or greater than desired ----------------------------------------------------------------------------------- ++ echo '1.28 >= 1.29' ++ bc -l + '[' 0 -eq 1 ']' + return 1 + '[' 0 = 1 -a -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-pxc-k127-eks.yml ']' + kubectl_bin get -o yaml statefulset/upgrade-proxysql-pxc ++ mktemp + yq eval ' del(.metadata.managedFields) | del(.. | select(has("creationTimestamp")).creationTimestamp) | del(.. | select(has("namespace")).namespace) | del(.. | select(has("uid")).uid) | del(.metadata.resourceVersion) | del(.spec.template.spec.containers[].env[] | select(.name == "CLUSTER_HASH")) | del(.spec.template.spec.containers[].env[] | select(.name == "S3_BUCKET_PATH")) | del(.spec.template.spec.containers[].env[] | select(.name == "BACKUP_PATH")) | del(.spec.template.spec.containers[].env[] | select(.name == "S3_BUCKET_URL")) | del(.spec.template.spec.containers[].env[] | select(.name == "AZURE_CONTAINER_NAME")) | del(.metadata.selfLink) | del(.metadata.deletionTimestamp) | del(.metadata.annotations."kubectl.kubernetes.io/last-applied-configuration") | del(.metadata.annotations."kubernetes.io/psp") | del(.metadata.annotations."batch.kubernetes.io/job-tracking") | del(.metadata.labels."batch.kubernetes.io/job-name") | del(.metadata.labels."job-name") | del(.metadata.annotations."cloud.google.com/neg") | del(.metadata.annotations."k8s.v1.cni.cncf.io*") | del(.metadata.annotations."k8s.ovn.org/pod-networks") | del(.spec.template.metadata.annotations."last-applied-secret") | del(.spec.template.metadata.labels."batch.kubernetes.io/job-name") | del(.spec.template.metadata.labels."job-name") | del(.. | select(has("batch.kubernetes.io/controller-uid"))."batch.kubernetes.io/controller-uid") | del(.. | select(has("image")).image) | del(.. | select(has("clusterIP")).clusterIP) | del(.. | select(has("clusterIPs")).clusterIPs) | del(.. | select(has("dataSource")).dataSource) | del(.. | select(has("procMount")).procMount) | del(.. | select(has("storageClassName")).storageClassName) | del(.. | select(has("finalizers")).finalizers) | del(.. | select(has("kubernetes.io/pvc-protection"))."kubernetes.io/pvc-protection") | del(.. | select(has("volumeName")).volumeName) | del(.. | select(has("volume.beta.kubernetes.io/storage-provisioner"))."volume.beta.kubernetes.io/storage-provisioner") | del(.. | select(has("volume.kubernetes.io/storage-provisioner"))."volume.kubernetes.io/storage-provisioner") | del(.spec.volumeMode) | del(.spec.nodeName) | del(.. | select(has("volume.kubernetes.io/selected-node"))."volume.kubernetes.io/selected-node") | del(.. | select(has("percona.com/last-config-hash"))."percona.com/last-config-hash") | del(.. | select(has("percona.com/configuration-hash"))."percona.com/configuration-hash") | del(.. | select(has("percona.com/env-secret-config-hash"))."percona.com/env-secret-config-hash") | del(.. | select(has("percona.com/ssl-hash"))."percona.com/ssl-hash") | del(.. | select(has("percona.com/ssl-internal-hash"))."percona.com/ssl-internal-hash") | del(.spec.volumeClaimTemplates[].spec.volumeMode | select(. == "Filesystem")) | del(.. | select(has("healthCheckNodePort")).healthCheckNodePort) | del(.. | select(has("nodePort")).nodePort) | del(.. | select(has("imagePullSecrets")).imagePullSecrets) | del(.. | select(has("enableServiceLinks")).enableServiceLinks) | del(.status) | del(.spec.volumeClaimTemplates[].apiVersion) | del(.spec.volumeClaimTemplates[].kind) | del(.metadata.ownerReferences[].apiVersion) | del(.. | select(has("controller-uid")).controller-uid) | del(.. | select(has("preemptionPolicy")).preemptionPolicy) | del(.spec.ipFamilies) | del(.spec.ipFamilyPolicy) | (.. | select(. == "policy/v1beta1")) = "policy/v1" | del(.. | select(has("kubernetes.io/hostname"))."kubernetes.io/hostname") | (.. | select(tag == "!!str")) |= sub("upgrade-proxysql-26075", "namespace") | (.. | select(tag == "!!str")) |= sub("kube-api-access-.*", "kube-api-access") | del(.. | select(has("annotations")).annotations | select(length==0)) | del(.. | select(.[] == "percona-xtradb-cluster-operator-workload-token*"))' - + local LAST_OUT=/tmp/tmp.iBSXotvuFY ++ mktemp + local LAST_ERR=/tmp/tmp.oDR3APOD84 + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl get -o yaml statefulset/upgrade-proxysql-pxc + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.iBSXotvuFY + cat /tmp/tmp.oDR3APOD84 + rm /tmp/tmp.iBSXotvuFY /tmp/tmp.oDR3APOD84 + return 0 + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-pxc-k127.yml /tmp/tmp.Kfg0SCarWM/statefulset_upgrade-proxysql-pxc.yml + compare_kubectl statefulset/upgrade-proxysql-proxysql + local resource=statefulset/upgrade-proxysql-proxysql + local postfix= + local expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-proxysql.yml + local new_result=/tmp/tmp.Kfg0SCarWM/statefulset_upgrade-proxysql-proxysql.yml + desc 'compare statefulset/upgrade-proxysql-proxysql-' + set +o xtrace ----------------------------------------------------------------------------------- compare statefulset/upgrade-proxysql-proxysql- ----------------------------------------------------------------------------------- + '[' 0 = 1 -a -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-proxysql-eks.yml ']' + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.0 ]] + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.4 ]] + version_gt 1.29 + desc 'return true if kubernetes version equal or greater than desired' + set +o xtrace ----------------------------------------------------------------------------------- return true if kubernetes version equal or greater than desired ----------------------------------------------------------------------------------- ++ echo '1.28 >= 1.29' ++ bc -l + '[' 0 -eq 1 ']' + return 1 + version_gt 1.27 + desc 'return true if kubernetes version equal or greater than desired' + set +o xtrace ----------------------------------------------------------------------------------- return true if kubernetes version equal or greater than desired ----------------------------------------------------------------------------------- ++ echo '1.28 >= 1.27' ++ bc -l + '[' 1 -eq 1 ']' + return 0 + '[' -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-proxysql-k127.yml ']' + expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-proxysql-k127.yml + '[' '!' -z '' -a -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-proxysql-k127-oc.yml ']' + version_gt 1.29 + desc 'return true if kubernetes version equal or greater than desired' + set +o xtrace ----------------------------------------------------------------------------------- return true if kubernetes version equal or greater than desired ----------------------------------------------------------------------------------- ++ echo '1.28 >= 1.29' ++ bc -l + '[' 0 -eq 1 ']' + return 1 + '[' 0 = 1 -a -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-proxysql-k127-eks.yml ']' + kubectl_bin get -o yaml statefulset/upgrade-proxysql-proxysql ++ mktemp + yq eval ' del(.metadata.managedFields) | del(.. | select(has("creationTimestamp")).creationTimestamp) | del(.. | select(has("namespace")).namespace) | del(.. | select(has("uid")).uid) | del(.metadata.resourceVersion) | del(.spec.template.spec.containers[].env[] | select(.name == "CLUSTER_HASH")) | del(.spec.template.spec.containers[].env[] | select(.name == "S3_BUCKET_PATH")) | del(.spec.template.spec.containers[].env[] | select(.name == "BACKUP_PATH")) | del(.spec.template.spec.containers[].env[] | select(.name == "S3_BUCKET_URL")) | del(.spec.template.spec.containers[].env[] | select(.name == "AZURE_CONTAINER_NAME")) | del(.metadata.selfLink) | del(.metadata.deletionTimestamp) | del(.metadata.annotations."kubectl.kubernetes.io/last-applied-configuration") | del(.metadata.annotations."kubernetes.io/psp") | del(.metadata.annotations."batch.kubernetes.io/job-tracking") | del(.metadata.labels."batch.kubernetes.io/job-name") | del(.metadata.labels."job-name") | del(.metadata.annotations."cloud.google.com/neg") | del(.metadata.annotations."k8s.v1.cni.cncf.io*") | del(.metadata.annotations."k8s.ovn.org/pod-networks") | del(.spec.template.metadata.annotations."last-applied-secret") | del(.spec.template.metadata.labels."batch.kubernetes.io/job-name") | del(.spec.template.metadata.labels."job-name") | del(.. | select(has("batch.kubernetes.io/controller-uid"))."batch.kubernetes.io/controller-uid") | del(.. | select(has("image")).image) | del(.. | select(has("clusterIP")).clusterIP) | del(.. | select(has("clusterIPs")).clusterIPs) | del(.. | select(has("dataSource")).dataSource) | del(.. | select(has("procMount")).procMount) | del(.. | select(has("storageClassName")).storageClassName) | del(.. | select(has("finalizers")).finalizers) | del(.. | select(has("kubernetes.io/pvc-protection"))."kubernetes.io/pvc-protection") | del(.. | select(has("volumeName")).volumeName) | del(.. | select(has("volume.beta.kubernetes.io/storage-provisioner"))."volume.beta.kubernetes.io/storage-provisioner") | del(.. | select(has("volume.kubernetes.io/storage-provisioner"))."volume.kubernetes.io/storage-provisioner") | del(.spec.volumeMode) | del(.spec.nodeName) | del(.. | select(has("volume.kubernetes.io/selected-node"))."volume.kubernetes.io/selected-node") | del(.. | select(has("percona.com/last-config-hash"))."percona.com/last-config-hash") | del(.. | select(has("percona.com/configuration-hash"))."percona.com/configuration-hash") | del(.. | select(has("percona.com/env-secret-config-hash"))."percona.com/env-secret-config-hash") | del(.. | select(has("percona.com/ssl-hash"))."percona.com/ssl-hash") | del(.. | select(has("percona.com/ssl-internal-hash"))."percona.com/ssl-internal-hash") | del(.spec.volumeClaimTemplates[].spec.volumeMode | select(. == "Filesystem")) | del(.. | select(has("healthCheckNodePort")).healthCheckNodePort) | del(.. | select(has("nodePort")).nodePort) | del(.. | select(has("imagePullSecrets")).imagePullSecrets) | del(.. | select(has("enableServiceLinks")).enableServiceLinks) | del(.status) | del(.spec.volumeClaimTemplates[].apiVersion) | del(.spec.volumeClaimTemplates[].kind) | del(.metadata.ownerReferences[].apiVersion) | del(.. | select(has("controller-uid")).controller-uid) | del(.. | select(has("preemptionPolicy")).preemptionPolicy) | del(.spec.ipFamilies) | del(.spec.ipFamilyPolicy) | (.. | select(. == "policy/v1beta1")) = "policy/v1" | del(.. | select(has("kubernetes.io/hostname"))."kubernetes.io/hostname") | (.. | select(tag == "!!str")) |= sub("upgrade-proxysql-26075", "namespace") | (.. | select(tag == "!!str")) |= sub("kube-api-access-.*", "kube-api-access") | del(.. | select(has("annotations")).annotations | select(length==0)) | del(.. | select(.[] == "percona-xtradb-cluster-operator-workload-token*"))' - + local LAST_OUT=/tmp/tmp.NJVPxO0ZYY ++ mktemp + local LAST_ERR=/tmp/tmp.6I7lgS08E3 + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl get -o yaml statefulset/upgrade-proxysql-proxysql + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.NJVPxO0ZYY + cat /tmp/tmp.6I7lgS08E3 + rm /tmp/tmp.NJVPxO0ZYY /tmp/tmp.6I7lgS08E3 + return 0 + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1697/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-proxysql-k127.yml /tmp/tmp.Kfg0SCarWM/statefulset_upgrade-proxysql-proxysql.yml + desc cleanup + set +o xtrace ----------------------------------------------------------------------------------- cleanup ----------------------------------------------------------------------------------- + destroy upgrade-proxysql-26075 + local namespace=upgrade-proxysql-26075 + 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 + grep -v 'the object has been modified' + grep -v 'get backup status: Job.batch' ++ get_operator_pod ++ local label_prefix=app.kubernetes.io/ + sort -u + /usr/bin/sed -r 's/"ts":[0-9.]+//; s^limits-[0-9.]+/^^g' + tee /tmp/tmp.Kfg0SCarWM/operator.log +++ 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.aipPPwuhm4 +++ mktemp ++ local LAST_ERR=/tmp/tmp.6CTPdKR4Ko ++ 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.aipPPwuhm4 ++ cat /tmp/tmp.6CTPdKR4Ko ++ rm /tmp/tmp.aipPPwuhm4 /tmp/tmp.6CTPdKR4Ko ++ return 0 + kubectl_bin logs -n pxc-operator percona-xtradb-cluster-operator-79dcbbbbbc-qgf4r ++ mktemp + local LAST_OUT=/tmp/tmp.N8v33y7xkZ ++ mktemp + local LAST_ERR=/tmp/tmp.Xxj3I56z19 + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl logs -n pxc-operator percona-xtradb-cluster-operator-79dcbbbbbc-qgf4r + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.N8v33y7xkZ + cat /tmp/tmp.Xxj3I56z19 + rm /tmp/tmp.N8v33y7xkZ /tmp/tmp.Xxj3I56z19 + return 0 2024-12-20T15:43:58.049Z INFO setup Manager starting up {"gitCommit": "26afa5272972c583e9dc3f39e65e29a2744c72d8", "gitBranch": "PR-1697-26afa527", "buildTime": "2024-12-20T13:32:57Z", "goVersion": "go1.23.4", "os": "linux", "arch": "amd64"} 2024-12-20T15:43:58.049Z INFO setup Runs on {"platform": "kubernetes", "version": "v1.28.15-gke.1388000"} 2024-12-20T15:43:58.050Z INFO setup Registering Components. 2024-12-20T15:44:01.852Z INFO controller-runtime.webhook Registering webhook {"path": "/validate-percona-xtradbcluster"} 2024-12-20T15:44:01.855Z INFO controller-runtime.metrics Starting metrics server 2024-12-20T15:44:01.855Z INFO setup Starting the Cmd. 2024-12-20T15:44:01.934Z INFO controller-runtime.metrics Serving metrics server {"bindAddress": ":8080", "secure": false} 2024-12-20T15:44:01.934Z INFO controller-runtime.webhook Starting webhook server 2024-12-20T15:44:01.934Z INFO starting server {"name": "health probe", "addr": "[::]:8081"} 2024-12-20T15:44:01.935Z INFO controller-runtime.certwatcher Starting certificate watcher 2024-12-20T15:44:01.935Z INFO controller-runtime.certwatcher Updated current TLS certificate 2024-12-20T15:44:01.935Z INFO controller-runtime.webhook Serving webhook server {"host": "", "port": 9443} 2024-12-20T15:44:02.035Z INFO attempting to acquire leader lease pxc-operator/08db1feb.percona.com... 2024-12-20T15:44:20.033Z DEBUG events percona-xtradb-cluster-operator-79dcbbbbbc-qgf4r_b16219c2-5fe2-4096-a4cc-7005ebf8b7f5 became leader {"type": "Normal", "object": {"kind":"Lease","namespace":"pxc-operator","name":"08db1feb.percona.com","uid":"fe34a8d1-470e-49ae-b4de-94069408a59c","apiVersion":"coordination.k8s.io/v1","resourceVersion":"83247"}, "reason": "LeaderElection"} 2024-12-20T15:44:20.033Z INFO Starting Controller {"controller": "pxcbackup-controller"} 2024-12-20T15:44:20.033Z INFO Starting Controller {"controller": "pxc-controller"} 2024-12-20T15:44:20.033Z INFO Starting Controller {"controller": "pxcrestore-controller"} 2024-12-20T15:44:20.033Z INFO Starting EventSource {"controller": "pxcbackup-controller", "source": "kind source: *v1.PerconaXtraDBClusterBackup"} 2024-12-20T15:44:20.033Z INFO Starting EventSource {"controller": "pxc-controller", "source": "kind source: *v1.PerconaXtraDBCluster"} 2024-12-20T15:44:20.033Z INFO Starting EventSource {"controller": "pxcrestore-controller", "source": "kind source: *v1.PerconaXtraDBClusterRestore"} 2024-12-20T15:44:20.033Z INFO successfully acquired lease pxc-operator/08db1feb.percona.com 2024-12-20T15:44:20.144Z INFO Starting workers {"controller": "pxcbackup-controller", "worker count": 1} 2024-12-20T15:44:20.144Z INFO Starting workers {"controller": "pxc-controller", "worker count": 1} 2024-12-20T15:44:20.150Z INFO Starting workers {"controller": "pxcrestore-controller", "worker count": 1} 2024-12-20T15:44:21.783Z INFO Creating or updating backup job {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "eaedc867-96ee-476f-9b1e-78071f5ed547", "name": "36699-daily-backup", "schedule": "0 0 * * *"} 2024-12-20T15:44:22.828Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "eaedc867-96ee-476f-9b1e-78071f5ed547"} 2024-12-20T15:44:29.849Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "2360c2e6-ccc1-42e3-afa6-a9ce9c0be557"} 2024-12-20T15:44:35.703Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "58eb1299-9d1d-4ef3-b63b-713d3abaa6ea"} 2024-12-20T15:44:42.070Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "65517f35-412d-4bf6-9930-332314d8ebe0"} 2024-12-20T15:44:47.966Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "ef29b2df-243e-4eff-ad55-3379c473e28b"} 2024-12-20T15:44:50.159Z DEBUG Updating object {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "object": "upgrade-proxysql-pxc"} 2024-12-20T15:44:50.193Z DEBUG Updating object {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "object": "upgrade-proxysql-pxc"} 2024-12-20T15:44:50.215Z DEBUG Updating object {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "object": "upgrade-proxysql-proxysql"} 2024-12-20T15:44:50.277Z DEBUG Updating object {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "object": "upgrade-proxysql-proxysql"} 2024-12-20T15:44:51.305Z INFO statefulSet was changed, run smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352"} 2024-12-20T15:44:51.314Z INFO apply changes to secondary pod {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "pod": "upgrade-proxysql-pxc-2"} 2024-12-20T15:44:51.314Z INFO primary pod {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "pod": "upgrade-proxysql-pxc-0.upgrade-proxysql-pxc.upgrade-proxysql-26075.svc.cluster.local"} 2024-12-20T15:44:52.059Z INFO Pod is not updated {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "pod": "upgrade-proxysql-pxc-2", "currentRevision": "upgrade-proxysql-pxc-6dd9c969b", "targetRevision": "upgrade-proxysql-pxc-6b7bfdf99"} 2024-12-20T15:44:52.347Z ERROR sync users {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "error": "exec syncusers: failed to execute command in pod: unable to upgrade connection: container not found (\"proxysql\") / / ", "errorVerbose": "exec syncusers: failed to execute command in pod: unable to upgrade connection: container not found (\"proxysql\") / / \ngithub.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc.(*ReconcilePerconaXtraDBCluster).syncPXCUsersWithProxySQL\n\t/go/src/github.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc/users.go:925\ngithub.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc.(*ReconcilePerconaXtraDBCluster).resyncPXCUsersWithProxySQL.func1\n\t/go/src/github.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc/controller.go:1025\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1700"} 2024-12-20T15:45:02.134Z INFO Pod is not updated {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "pod": "upgrade-proxysql-pxc-2", "currentRevision": "upgrade-proxysql-pxc-6dd9c969b", "targetRevision": "upgrade-proxysql-pxc-6b7bfdf99"} 2024-12-20T15:45:12.640Z INFO Pod is not running {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "pod": "upgrade-proxysql-pxc-2", "phase": "Pending"} 2024-12-20T15:45:12.640Z INFO pod is waiting {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "pod": "upgrade-proxysql-pxc-2", "reason": "PodInitializing"} 2024-12-20T15:45:42.598Z INFO Pod is updated, running and ready {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "pod": "upgrade-proxysql-pxc-2"} 2024-12-20T15:46:02.625Z INFO pod present in hostgroups {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "pod": "upgrade-proxysql-pxc-2"} 2024-12-20T15:46:02.632Z INFO apply changes to secondary pod {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "pod": "upgrade-proxysql-pxc-1"} 2024-12-20T15:46:02.632Z INFO pod is online {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "pod": "upgrade-proxysql-pxc-2"} 2024-12-20T15:46:02.795Z INFO Pod is not updated {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "pod": "upgrade-proxysql-pxc-1", "currentRevision": "upgrade-proxysql-pxc-6dd9c969b", "targetRevision": "upgrade-proxysql-pxc-6b7bfdf99"} 2024-12-20T15:46:12.860Z INFO Pod is not updated {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "pod": "upgrade-proxysql-pxc-1", "currentRevision": "upgrade-proxysql-pxc-6dd9c969b", "targetRevision": "upgrade-proxysql-pxc-6b7bfdf99"} 2024-12-20T15:46:22.851Z INFO Pod is not running {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "pod": "upgrade-proxysql-pxc-1", "phase": "Pending"} 2024-12-20T15:46:22.851Z INFO pod is waiting {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "pod": "upgrade-proxysql-pxc-1", "reason": "PodInitializing"} 2024-12-20T15:46:32.843Z INFO Pod is not running {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "pod": "upgrade-proxysql-pxc-1", "phase": "Pending"} 2024-12-20T15:46:32.843Z INFO pod is waiting {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "pod": "upgrade-proxysql-pxc-1", "reason": "PodInitializing"} 2024-12-20T15:47:02.908Z INFO Pod is updated, running and ready {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "pod": "upgrade-proxysql-pxc-1"} 2024-12-20T15:47:42.940Z INFO pod present in hostgroups {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "pod": "upgrade-proxysql-pxc-1"} 2024-12-20T15:47:42.947Z INFO apply changes to primary pod {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "pod": "upgrade-proxysql-pxc-0"} 2024-12-20T15:47:42.947Z INFO pod is online {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "pod": "upgrade-proxysql-pxc-1"} 2024-12-20T15:47:43.171Z INFO Pod is not updated {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "pod": "upgrade-proxysql-pxc-0", "currentRevision": "upgrade-proxysql-pxc-6dd9c969b", "targetRevision": "upgrade-proxysql-pxc-6b7bfdf99"} 2024-12-20T15:47:53.263Z INFO Pod is not updated {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "pod": "upgrade-proxysql-pxc-0", "currentRevision": "upgrade-proxysql-pxc-6dd9c969b", "targetRevision": "upgrade-proxysql-pxc-6b7bfdf99"} 2024-12-20T15:48:03.230Z INFO pod is waiting {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "pod": "upgrade-proxysql-pxc-0", "reason": "PodInitializing"} 2024-12-20T15:48:03.231Z INFO Pod is not running {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "pod": "upgrade-proxysql-pxc-0", "phase": "Pending"} 2024-12-20T15:48:33.270Z INFO Pod is updated, running and ready {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "pod": "upgrade-proxysql-pxc-0"} 2024-12-20T15:49:43.299Z INFO pod present in hostgroups {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "pod": "upgrade-proxysql-pxc-0"} 2024-12-20T15:49:43.306Z DEBUG Updating object {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "object": "upgrade-proxysql-pxc"} 2024-12-20T15:49:43.306Z INFO pod is online {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "pod": "upgrade-proxysql-pxc-0"} 2024-12-20T15:49:43.306Z INFO smart update finished {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352"} 2024-12-20T15:49:43.319Z DEBUG Updating object {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "object": "upgrade-proxysql-pxc-unready"} 2024-12-20T15:49:43.337Z DEBUG Updating object {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "object": "upgrade-proxysql-proxysql"} 2024-12-20T15:49:43.362Z DEBUG Updating object {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "object": "upgrade-proxysql-proxysql-unready"} 2024-12-20T15:49:43.419Z INFO update PXC version (fetched from db) {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "0dc7f7c6-4d1b-4755-aeda-efffe4df8352", "new version": "5.7.44-48-57"} 2024-12-20T15:49:46.095Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "5cddd8fb-b85b-40b8-b238-c342d56352e2"} 2024-12-20T15:49:51.151Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "a323f8b2-699a-4c29-8fa5-eecb7c48e392"} 2024-12-20T15:49:57.234Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "c66042f4-d005-4482-b5b8-82b95ea8306e"} 2024-12-20T15:50:04.055Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "56f8948f-fb8f-4f7a-8201-3fe1f688f81e"} 2024-12-20T15:50:09.703Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-26075", "name": "upgrade-proxysql", "reconcileID": "b3ff2d3f-deff-403c-91d5-f0930b5e63da"} github.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc.(*ReconcilePerconaXtraDBCluster).resyncPXCUsersWithProxySQL.func1 /go/src/github.com/percona/percona-xtradb-cluster-operator/pkg/controller/pxc/controller.go:1027 + 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 upgrade-proxysql-26075 upgrade-proxysql --type=merge -p '{"metadata":{"finalizers":[]}}' perconaxtradbcluster.pxc.percona.com/upgrade-proxysql patched + kubectl_bin delete pxc --all --all-namespaces ++ mktemp + local LAST_OUT=/tmp/tmp.Jw31qV8Vmo ++ mktemp + local LAST_ERR=/tmp/tmp.NOrbvlwbxr + 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.Jw31qV8Vmo perconaxtradbcluster.pxc.percona.com "upgrade-proxysql" deleted + cat /tmp/tmp.NOrbvlwbxr + rm /tmp/tmp.Jw31qV8Vmo /tmp/tmp.NOrbvlwbxr + return 0 + kubectl_bin delete pxc-backup --all --all-namespaces ++ mktemp + local LAST_OUT=/tmp/tmp.oyFiciN3M1 ++ mktemp + local LAST_ERR=/tmp/tmp.Z76bit0H0L + 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.oyFiciN3M1 No resources found + cat /tmp/tmp.Z76bit0H0L + rm /tmp/tmp.oyFiciN3M1 /tmp/tmp.Z76bit0H0L + return 0 + kubectl_bin delete pxc-restore --all --all-namespaces ++ mktemp + local LAST_OUT=/tmp/tmp.QWcXRJRHTQ ++ mktemp + local LAST_ERR=/tmp/tmp.58uDMxAvHx + 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.QWcXRJRHTQ No resources found + cat /tmp/tmp.58uDMxAvHx + rm /tmp/tmp.QWcXRJRHTQ /tmp/tmp.58uDMxAvHx + return 0 + kubectl_bin delete ValidatingWebhookConfiguration percona-xtradbcluster-webhook ++ mktemp + local LAST_OUT=/tmp/tmp.whx1Ko6UV6 ++ mktemp + local LAST_ERR=/tmp/tmp.6QicWpXlRC + 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.whx1Ko6UV6 validatingwebhookconfiguration.admissionregistration.k8s.io "percona-xtradbcluster-webhook" deleted + cat /tmp/tmp.6QicWpXlRC + rm /tmp/tmp.whx1Ko6UV6 /tmp/tmp.6QicWpXlRC + return 0 + kubectl_bin delete -f https://github.com/jetstack/cert-manager/releases/download/v1.16.2/cert-manager.yaml + : + '[' '!' -z '' ']' + '[' -n pxc-operator ']' + kubectl_bin delete --grace-period=0 --force=true namespace upgrade-proxysql-26075 + rm -rf /tmp/tmp.Kfg0SCarWM + kubectl_bin delete --grace-period=0 --force=true namespace pxc-operator ++ mktemp ++ mktemp + local LAST_OUT=/tmp/tmp.r7n2soilTQ ++ mktemp + local LAST_OUT=/tmp/tmp.q9aotP5U6o ++ mktemp + local LAST_ERR=/tmp/tmp.hzkVXZ3sKe + local exit_status=0 ++ kubectl get crd ++ seq 0 2 + local LAST_ERR=/tmp/tmp.vt2w3nrmcK + local exit_status=0 ++ awk '{print $1}' ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl delete --grace-period=0 --force=true namespace upgrade-proxysql-26075 ++ grep perconaxtradbcluster + for i in '$(seq 0 2)' + set +e + kubectl delete --grace-period=0 --force=true namespace pxc-operator ++ tr '\n' ' ' + kubectl delete crd perconaxtradbclusterbackups.pxc.percona.com perconaxtradbclusterrestores.pxc.percona.com perconaxtradbclusters.pxc.percona.com customresourcedefinition.apiextensions.k8s.io "perconaxtradbclusterbackups.pxc.percona.com" deleted customresourcedefinition.apiextensions.k8s.io "perconaxtradbclusterrestores.pxc.percona.com" deleted customresourcedefinition.apiextensions.k8s.io "perconaxtradbclusters.pxc.percona.com" deleted + desc 'test passed' + set +o xtrace ----------------------------------------------------------------------------------- test passed -----------------------------------------------------------------------------------