Log: /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/logs/upgrade-proxysql-8-0.log WARNING: version difference between client (1.30) and server (1.26) exceeds the supported minor version skew of +/-1 WARNING: version difference between client (1.30) and server (1.26) exceeds the supported minor version skew of +/-1 + CLUSTER=upgrade-proxysql + CLUSTER_SIZE=3 + TARGET_OPERATOR_VER=1.15.0 + TARGET_IMAGE=perconalab/percona-xtradb-cluster-operator:PR-1752-44f0e1a8 + TARGET_IMAGE_PXC=perconalab/percona-xtradb-cluster-operator:main-pxc8.0 + 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-pxc8.0-backup + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 == *\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-pxc8.0 ++ /usr/bin/sed -r 's/.*([0-9].[0-9])$/\1/' + PXC_VER=8.0 ++ jq -r '.versions[].operator' ++ sort -V ++ curl -s https://check.percona.com/versions/v1/pxc-operator ++ tail -n1 + INIT_OPERATOR_VER=1.14.0 + [[ 1.14.0 == \1\.\1\5\.\0 ]] + GIT_TAG=v1.14.0 ++ curl -s 'https://check.percona.com/versions/v1/pxc-operator/1.14.0/latest?databaseVersion=8.0' + INIT_OPERATOR_IMAGES='{"versions":[{"product":"pxc-operator","operator":"1.14.0","matrix":{"mongod":{},"pxc":{"8.0.36-28.1":{"imagePath":"percona/percona-xtradb-cluster:8.0.36-28.1","imageHash":"ed99f585a27257726a985fee5f50cd957f94f5b9ae70a5d2f0fa1e68336f3abe","imageHashArm64":"","status":"recommended","critical":false}},"pmm":{"2.41.2":{"imagePath":"percona/pmm-client:2.41.2","imageHash":"16d2499c1cbcc1af51bd3752fe7623b0d0a319ee128b12d41cadf8080d1ce56b","imageHashArm64":"","status":"recommended","critical":false}},"proxysql":{"2.5.5-1.2":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-proxysql2.5.5-1.2","imageHash":"fcd7c1366f26f3dbaeff65d7ee08c43bbb88838cec9a0085447c1b56c717870d","imageHashArm64":"","status":"recommended","critical":false}},"haproxy":{"2.8.5":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-haproxy","imageHash":"15b9dad6d59c7995456b92fb1b5c17501ecbc8bafb758ff6e7417d409f06bbbd","imageHashArm64":"","status":"recommended","critical":false}},"backup":{"8.0.35-2":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-pxc8.0.36-backup-pxb8.0.35","imageHash":"c17261dc7c40af2ab28510e702d4b6a2fb76b30001991fad3ddfa4271cc18157","imageHashArm64":"","status":"recommended","critical":false}},"operator":{"1.14.0":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0","imageHash":"e1b5b1d9db19f394f47b32f374a017d9debcf1e06325ab7bcc4b233da59f6f19","imageHashArm64":"2652b81a26be7b07e084e1ccbfe42e64143eb6a32e4529f1e4b27e1061dbc0b1","status":"recommended","critical":false}},"logCollector":{"1.14.0":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-logcollector","imageHash":"f8f56b8da5b1d9859dded3f89b7ce41c5b3ceba6d78f7d4152bd0b14bafc60f4","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 ++ echo '{"versions":[{"product":"pxc-operator","operator":"1.14.0","matrix":{"mongod":{},"pxc":{"8.0.36-28.1":{"imagePath":"percona/percona-xtradb-cluster:8.0.36-28.1","imageHash":"ed99f585a27257726a985fee5f50cd957f94f5b9ae70a5d2f0fa1e68336f3abe","imageHashArm64":"","status":"recommended","critical":false}},"pmm":{"2.41.2":{"imagePath":"percona/pmm-client:2.41.2","imageHash":"16d2499c1cbcc1af51bd3752fe7623b0d0a319ee128b12d41cadf8080d1ce56b","imageHashArm64":"","status":"recommended","critical":false}},"proxysql":{"2.5.5-1.2":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-proxysql2.5.5-1.2","imageHash":"fcd7c1366f26f3dbaeff65d7ee08c43bbb88838cec9a0085447c1b56c717870d","imageHashArm64":"","status":"recommended","critical":false}},"haproxy":{"2.8.5":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-haproxy","imageHash":"15b9dad6d59c7995456b92fb1b5c17501ecbc8bafb758ff6e7417d409f06bbbd","imageHashArm64":"","status":"recommended","critical":false}},"backup":{"8.0.35-2":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-pxc8.0.36-backup-pxb8.0.35","imageHash":"c17261dc7c40af2ab28510e702d4b6a2fb76b30001991fad3ddfa4271cc18157","imageHashArm64":"","status":"recommended","critical":false}},"operator":{"1.14.0":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0","imageHash":"e1b5b1d9db19f394f47b32f374a017d9debcf1e06325ab7bcc4b233da59f6f19","imageHashArm64":"2652b81a26be7b07e084e1ccbfe42e64143eb6a32e4529f1e4b27e1061dbc0b1","status":"recommended","critical":false}},"logCollector":{"1.14.0":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-logcollector","imageHash":"f8f56b8da5b1d9859dded3f89b7ce41c5b3ceba6d78f7d4152bd0b14bafc60f4","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.operator[].imagePath' + IMAGE=percona/percona-xtradb-cluster-operator:1.14.0 ++ echo perconalab/percona-xtradb-cluster-operator:PR-1752-44f0e1a8 ++ cut -d/ -f1 + [[ perconalab == \p\e\r\c\o\n\a\l\a\b ]] + IMAGE=perconalab/percona-xtradb-cluster-operator:1.14.0 ++ jq -r '.versions[].matrix.pxc[].imagePath' ++ echo '{"versions":[{"product":"pxc-operator","operator":"1.14.0","matrix":{"mongod":{},"pxc":{"8.0.36-28.1":{"imagePath":"percona/percona-xtradb-cluster:8.0.36-28.1","imageHash":"ed99f585a27257726a985fee5f50cd957f94f5b9ae70a5d2f0fa1e68336f3abe","imageHashArm64":"","status":"recommended","critical":false}},"pmm":{"2.41.2":{"imagePath":"percona/pmm-client:2.41.2","imageHash":"16d2499c1cbcc1af51bd3752fe7623b0d0a319ee128b12d41cadf8080d1ce56b","imageHashArm64":"","status":"recommended","critical":false}},"proxysql":{"2.5.5-1.2":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-proxysql2.5.5-1.2","imageHash":"fcd7c1366f26f3dbaeff65d7ee08c43bbb88838cec9a0085447c1b56c717870d","imageHashArm64":"","status":"recommended","critical":false}},"haproxy":{"2.8.5":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-haproxy","imageHash":"15b9dad6d59c7995456b92fb1b5c17501ecbc8bafb758ff6e7417d409f06bbbd","imageHashArm64":"","status":"recommended","critical":false}},"backup":{"8.0.35-2":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-pxc8.0.36-backup-pxb8.0.35","imageHash":"c17261dc7c40af2ab28510e702d4b6a2fb76b30001991fad3ddfa4271cc18157","imageHashArm64":"","status":"recommended","critical":false}},"operator":{"1.14.0":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0","imageHash":"e1b5b1d9db19f394f47b32f374a017d9debcf1e06325ab7bcc4b233da59f6f19","imageHashArm64":"2652b81a26be7b07e084e1ccbfe42e64143eb6a32e4529f1e4b27e1061dbc0b1","status":"recommended","critical":false}},"logCollector":{"1.14.0":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-logcollector","imageHash":"f8f56b8da5b1d9859dded3f89b7ce41c5b3ceba6d78f7d4152bd0b14bafc60f4","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_PXC=percona/percona-xtradb-cluster:8.0.36-28.1 ++ jq -r '.versions[].matrix.pmm[].imagePath' ++ echo '{"versions":[{"product":"pxc-operator","operator":"1.14.0","matrix":{"mongod":{},"pxc":{"8.0.36-28.1":{"imagePath":"percona/percona-xtradb-cluster:8.0.36-28.1","imageHash":"ed99f585a27257726a985fee5f50cd957f94f5b9ae70a5d2f0fa1e68336f3abe","imageHashArm64":"","status":"recommended","critical":false}},"pmm":{"2.41.2":{"imagePath":"percona/pmm-client:2.41.2","imageHash":"16d2499c1cbcc1af51bd3752fe7623b0d0a319ee128b12d41cadf8080d1ce56b","imageHashArm64":"","status":"recommended","critical":false}},"proxysql":{"2.5.5-1.2":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-proxysql2.5.5-1.2","imageHash":"fcd7c1366f26f3dbaeff65d7ee08c43bbb88838cec9a0085447c1b56c717870d","imageHashArm64":"","status":"recommended","critical":false}},"haproxy":{"2.8.5":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-haproxy","imageHash":"15b9dad6d59c7995456b92fb1b5c17501ecbc8bafb758ff6e7417d409f06bbbd","imageHashArm64":"","status":"recommended","critical":false}},"backup":{"8.0.35-2":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-pxc8.0.36-backup-pxb8.0.35","imageHash":"c17261dc7c40af2ab28510e702d4b6a2fb76b30001991fad3ddfa4271cc18157","imageHashArm64":"","status":"recommended","critical":false}},"operator":{"1.14.0":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0","imageHash":"e1b5b1d9db19f394f47b32f374a017d9debcf1e06325ab7bcc4b233da59f6f19","imageHashArm64":"2652b81a26be7b07e084e1ccbfe42e64143eb6a32e4529f1e4b27e1061dbc0b1","status":"recommended","critical":false}},"logCollector":{"1.14.0":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-logcollector","imageHash":"f8f56b8da5b1d9859dded3f89b7ce41c5b3ceba6d78f7d4152bd0b14bafc60f4","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.41.2 ++ echo '{"versions":[{"product":"pxc-operator","operator":"1.14.0","matrix":{"mongod":{},"pxc":{"8.0.36-28.1":{"imagePath":"percona/percona-xtradb-cluster:8.0.36-28.1","imageHash":"ed99f585a27257726a985fee5f50cd957f94f5b9ae70a5d2f0fa1e68336f3abe","imageHashArm64":"","status":"recommended","critical":false}},"pmm":{"2.41.2":{"imagePath":"percona/pmm-client:2.41.2","imageHash":"16d2499c1cbcc1af51bd3752fe7623b0d0a319ee128b12d41cadf8080d1ce56b","imageHashArm64":"","status":"recommended","critical":false}},"proxysql":{"2.5.5-1.2":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-proxysql2.5.5-1.2","imageHash":"fcd7c1366f26f3dbaeff65d7ee08c43bbb88838cec9a0085447c1b56c717870d","imageHashArm64":"","status":"recommended","critical":false}},"haproxy":{"2.8.5":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-haproxy","imageHash":"15b9dad6d59c7995456b92fb1b5c17501ecbc8bafb758ff6e7417d409f06bbbd","imageHashArm64":"","status":"recommended","critical":false}},"backup":{"8.0.35-2":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-pxc8.0.36-backup-pxb8.0.35","imageHash":"c17261dc7c40af2ab28510e702d4b6a2fb76b30001991fad3ddfa4271cc18157","imageHashArm64":"","status":"recommended","critical":false}},"operator":{"1.14.0":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0","imageHash":"e1b5b1d9db19f394f47b32f374a017d9debcf1e06325ab7bcc4b233da59f6f19","imageHashArm64":"2652b81a26be7b07e084e1ccbfe42e64143eb6a32e4529f1e4b27e1061dbc0b1","status":"recommended","critical":false}},"logCollector":{"1.14.0":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-logcollector","imageHash":"f8f56b8da5b1d9859dded3f89b7ce41c5b3ceba6d78f7d4152bd0b14bafc60f4","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.proxysql[].imagePath' + IMAGE_PROXY=percona/percona-xtradb-cluster-operator:1.14.0-proxysql2.5.5-1.2 ++ echo '{"versions":[{"product":"pxc-operator","operator":"1.14.0","matrix":{"mongod":{},"pxc":{"8.0.36-28.1":{"imagePath":"percona/percona-xtradb-cluster:8.0.36-28.1","imageHash":"ed99f585a27257726a985fee5f50cd957f94f5b9ae70a5d2f0fa1e68336f3abe","imageHashArm64":"","status":"recommended","critical":false}},"pmm":{"2.41.2":{"imagePath":"percona/pmm-client:2.41.2","imageHash":"16d2499c1cbcc1af51bd3752fe7623b0d0a319ee128b12d41cadf8080d1ce56b","imageHashArm64":"","status":"recommended","critical":false}},"proxysql":{"2.5.5-1.2":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-proxysql2.5.5-1.2","imageHash":"fcd7c1366f26f3dbaeff65d7ee08c43bbb88838cec9a0085447c1b56c717870d","imageHashArm64":"","status":"recommended","critical":false}},"haproxy":{"2.8.5":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-haproxy","imageHash":"15b9dad6d59c7995456b92fb1b5c17501ecbc8bafb758ff6e7417d409f06bbbd","imageHashArm64":"","status":"recommended","critical":false}},"backup":{"8.0.35-2":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-pxc8.0.36-backup-pxb8.0.35","imageHash":"c17261dc7c40af2ab28510e702d4b6a2fb76b30001991fad3ddfa4271cc18157","imageHashArm64":"","status":"recommended","critical":false}},"operator":{"1.14.0":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0","imageHash":"e1b5b1d9db19f394f47b32f374a017d9debcf1e06325ab7bcc4b233da59f6f19","imageHashArm64":"2652b81a26be7b07e084e1ccbfe42e64143eb6a32e4529f1e4b27e1061dbc0b1","status":"recommended","critical":false}},"logCollector":{"1.14.0":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-logcollector","imageHash":"f8f56b8da5b1d9859dded3f89b7ce41c5b3ceba6d78f7d4152bd0b14bafc60f4","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/percona-xtradb-cluster-operator:1.14.0-haproxy ++ echo '{"versions":[{"product":"pxc-operator","operator":"1.14.0","matrix":{"mongod":{},"pxc":{"8.0.36-28.1":{"imagePath":"percona/percona-xtradb-cluster:8.0.36-28.1","imageHash":"ed99f585a27257726a985fee5f50cd957f94f5b9ae70a5d2f0fa1e68336f3abe","imageHashArm64":"","status":"recommended","critical":false}},"pmm":{"2.41.2":{"imagePath":"percona/pmm-client:2.41.2","imageHash":"16d2499c1cbcc1af51bd3752fe7623b0d0a319ee128b12d41cadf8080d1ce56b","imageHashArm64":"","status":"recommended","critical":false}},"proxysql":{"2.5.5-1.2":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-proxysql2.5.5-1.2","imageHash":"fcd7c1366f26f3dbaeff65d7ee08c43bbb88838cec9a0085447c1b56c717870d","imageHashArm64":"","status":"recommended","critical":false}},"haproxy":{"2.8.5":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-haproxy","imageHash":"15b9dad6d59c7995456b92fb1b5c17501ecbc8bafb758ff6e7417d409f06bbbd","imageHashArm64":"","status":"recommended","critical":false}},"backup":{"8.0.35-2":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-pxc8.0.36-backup-pxb8.0.35","imageHash":"c17261dc7c40af2ab28510e702d4b6a2fb76b30001991fad3ddfa4271cc18157","imageHashArm64":"","status":"recommended","critical":false}},"operator":{"1.14.0":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0","imageHash":"e1b5b1d9db19f394f47b32f374a017d9debcf1e06325ab7bcc4b233da59f6f19","imageHashArm64":"2652b81a26be7b07e084e1ccbfe42e64143eb6a32e4529f1e4b27e1061dbc0b1","status":"recommended","critical":false}},"logCollector":{"1.14.0":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-logcollector","imageHash":"f8f56b8da5b1d9859dded3f89b7ce41c5b3ceba6d78f7d4152bd0b14bafc60f4","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.backup[].imagePath' + IMAGE_BACKUP=percona/percona-xtradb-cluster-operator:1.14.0-pxc8.0.36-backup-pxb8.0.35 + [[ 1.15.0 == \1\.\1\4\.\0 ]] + 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.VoENIMuEqE ++ mktemp + local LAST_ERR=/tmp/tmp.Olevf3pBlr + 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.VoENIMuEqE namespace/cert-manager created + cat /tmp/tmp.Olevf3pBlr + rm /tmp/tmp.VoENIMuEqE /tmp/tmp.Olevf3pBlr + return 0 + kubectl_bin label namespace cert-manager certmanager.k8s.io/disable-validation=true ++ mktemp + local LAST_OUT=/tmp/tmp.j5s2ngAXma ++ mktemp + local LAST_ERR=/tmp/tmp.nr357gET1m + 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.j5s2ngAXma namespace/cert-manager labeled + cat /tmp/tmp.nr357gET1m + rm /tmp/tmp.j5s2ngAXma /tmp/tmp.nr357gET1m + return 0 + kubectl_bin apply -f https://github.com/jetstack/cert-manager/releases/download/v1.14.2/cert-manager.yaml --validate=false ++ mktemp + local LAST_OUT=/tmp/tmp.2hYfnLjszI ++ mktemp + local LAST_ERR=/tmp/tmp.PirpKnadsF + 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.14.2/cert-manager.yaml --validate=false + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.2hYfnLjszI 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 configured 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-webhook:dynamic-serving created rolebinding.rbac.authorization.k8s.io/cert-manager-cainjector:leaderelection unchanged rolebinding.rbac.authorization.k8s.io/cert-manager:leaderelection configured rolebinding.rbac.authorization.k8s.io/cert-manager-webhook:dynamic-serving 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.PirpKnadsF 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.2hYfnLjszI /tmp/tmp.PirpKnadsF + return 0 + '[' '' == 4.10 ']' + sleep 70 + create_infra_gh upgrade-proxysql-10153 v1.14.0 + local ns=upgrade-proxysql-10153 + local git_tag=v1.14.0 + '[' -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 ++ sed s/NAMESPACE// ++ awk '-F ' '{print $2}' + local chaos_mesh_ns= + '[' -n '' ']' ++ kubectl get MutatingWebhookConfiguration ++ awk '{print $1}' ++ grep chaos-mesh + timeout 30 kubectl delete MutatingWebhookConfiguration error: resource(s) were provided, but no name was specified + : ++ kubectl get ValidatingWebhookConfiguration ++ awk '{print $1}' ++ grep chaos-mesh + timeout 30 kubectl delete ValidatingWebhookConfiguration error: resource(s) were provided, but no name was specified + : ++ kubectl get ValidatingWebhookConfiguration ++ grep validate-auth ++ awk '{print $1}' + timeout 30 kubectl delete ValidatingWebhookConfiguration error: resource(s) were provided, but no name was specified + : ++ kubectl api-resources ++ grep chaos-mesh ++ awk '{print $1}' ++ 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 '' ']' + desc 'cleaned up old namespaces pxc-operator' + xargs kubectl delete ns + set +o xtrace ----------------------------------------------------------------------------------- cleaned up old namespaces pxc-operator ----------------------------------------------------------------------------------- ++ mktemp + kubectl_bin delete namespace pxc-operator ++ mktemp + local LAST_OUT=/tmp/tmp.ccPnqkU2lx + local LAST_OUT=/tmp/tmp.aXrzCLXGNa ++ mktemp ++ mktemp + local LAST_ERR=/tmp/tmp.NVV7vlIxvw + local LAST_ERR=/tmp/tmp.c7JAtxaYBX + local exit_status=0 + local exit_status=0 ++ seq 0 2 ++ seq 0 2 + egrep -v '^kube-|^default$|Terminating|pxc-operator|openshift|^NAME' + for i in '$(seq 0 2)' + set +e + for i in '$(seq 0 2)' + kubectl get ns + set +e + kubectl delete namespace pxc-operator + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.aXrzCLXGNa + cat /tmp/tmp.c7JAtxaYBX + rm /tmp/tmp.aXrzCLXGNa /tmp/tmp.c7JAtxaYBX + return 0 namespace "cert-manager" deleted namespace "upgrade-proxysql-1501" 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.ccPnqkU2lx namespace "pxc-operator" deleted + cat /tmp/tmp.NVV7vlIxvw + rm /tmp/tmp.ccPnqkU2lx /tmp/tmp.NVV7vlIxvw + return 0 + wait_for_delete namespace/pxc-operator + local res=namespace/pxc-operator + echo -n 'namespace/pxc-operator - ' namespace/pxc-operator - + 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.9LGdsHWkbX ++ mktemp + local LAST_ERR=/tmp/tmp.erHXdTNlkP + 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.9LGdsHWkbX namespace/pxc-operator created + cat /tmp/tmp.erHXdTNlkP + rm /tmp/tmp.9LGdsHWkbX /tmp/tmp.erHXdTNlkP + return 0 ++ kubectl_bin config current-context +++ mktemp ++ local LAST_OUT=/tmp/tmp.gNbZpb2fZL +++ mktemp ++ local LAST_ERR=/tmp/tmp.CZ6BqnAmRD ++ 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.gNbZpb2fZL ++ cat /tmp/tmp.CZ6BqnAmRD ++ rm /tmp/tmp.gNbZpb2fZL /tmp/tmp.CZ6BqnAmRD ++ return 0 + kubectl_bin config set-context gke_cloud-dev-112233_us-central1-a_jen-pxc-1752-44f0e1a8-4-cluster5 --namespace=pxc-operator ++ mktemp + local LAST_OUT=/tmp/tmp.yZJeFxzHpC ++ mktemp + local LAST_ERR=/tmp/tmp.YCAjYDyRe1 + 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-1752-44f0e1a8-4-cluster5 --namespace=pxc-operator + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.yZJeFxzHpC Context "gke_cloud-dev-112233_us-central1-a_jen-pxc-1752-44f0e1a8-4-cluster5" modified. + cat /tmp/tmp.YCAjYDyRe1 + rm /tmp/tmp.yZJeFxzHpC /tmp/tmp.YCAjYDyRe1 + return 0 + deploy_operator_gh v1.14.0 + local git_tag=v1.14.0 + 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.0nzfWCsqG9 +++ mktemp ++ local LAST_ERR=/tmp/tmp.M2BpLmitJT ++ 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.0nzfWCsqG9 ++ cat /tmp/tmp.M2BpLmitJT ++ rm /tmp/tmp.0nzfWCsqG9 /tmp/tmp.M2BpLmitJT ++ return 0 + [[ -n perconaxtradbclusters.pxc.percona.com ]] ++ kubectl_bin get crd/perconaxtradbclusters.pxc.percona.com -o 'jsonpath={.spec.versions[?(@.name == "v1-14-0")].name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.Ei4ujJSrOK +++ mktemp ++ local LAST_ERR=/tmp/tmp.LVo4kMMXld ++ 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-14-0")].name}' ++ exit_status=0 ++ set -e ++ '[' 0 '!=' 0 ']' ++ break ++ cat /tmp/tmp.Ei4ujJSrOK ++ cat /tmp/tmp.LVo4kMMXld ++ rm /tmp/tmp.Ei4ujJSrOK /tmp/tmp.LVo4kMMXld ++ return 0 + [[ -n '' ]] + kubectl_bin apply --server-side --force-conflicts -f https://raw.githubusercontent.com/percona/percona-xtradb-cluster-operator/v1.14.0/deploy/crd.yaml ++ mktemp + local LAST_OUT=/tmp/tmp.DTh0UMGI6t ++ mktemp + local LAST_ERR=/tmp/tmp.bw1NopiHDj + 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.14.0/deploy/crd.yaml + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.DTh0UMGI6t + cat /tmp/tmp.bw1NopiHDj + rm /tmp/tmp.DTh0UMGI6t /tmp/tmp.bw1NopiHDj + 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.14.0 + local operator_namespace=pxc-operator + local rbac=cw-rbac + local git_tag=v1.14.0 + curl -s https://raw.githubusercontent.com/percona/percona-xtradb-cluster-operator/v1.14.0/deploy/cw-rbac.yaml + /usr/bin/sed -i -e 's^namespace: .*^namespace: pxc-operator^' /tmp/tmp.AvTQUWmnaD/rbac_v1.14.0.yaml + kubectl_bin apply -f /tmp/tmp.AvTQUWmnaD/rbac_v1.14.0.yaml ++ mktemp + local LAST_OUT=/tmp/tmp.FCRwJlqVLt ++ mktemp + local LAST_ERR=/tmp/tmp.CIWMJmNuPT + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl apply -f /tmp/tmp.AvTQUWmnaD/rbac_v1.14.0.yaml + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.FCRwJlqVLt clusterrole.rbac.authorization.k8s.io/percona-xtradb-cluster-operator configured serviceaccount/percona-xtradb-cluster-operator created clusterrolebinding.rbac.authorization.k8s.io/service-account-percona-xtradb-cluster-operator unchanged + cat /tmp/tmp.CIWMJmNuPT + rm /tmp/tmp.FCRwJlqVLt /tmp/tmp.CIWMJmNuPT + return 0 + curl -s https://raw.githubusercontent.com/percona/percona-xtradb-cluster-operator/v1.14.0/deploy/cw-operator.yaml + cat /tmp/tmp.AvTQUWmnaD/cw-operator.yaml_v1.14.0.yaml + sed -e 's^image: .*^image: perconalab/percona-xtradb-cluster-operator:1.14.0^' + yq eval '(select(.kind == "Deployment").spec.template.spec.containers[] | select(.name == "percona-xtradb-cluster-operator").env[] | select(.name == "DISABLE_TELEMETRY").value) = "true"' + 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.mHHXDDYXTA ++ mktemp + local LAST_ERR=/tmp/tmp.VnyKhFcwXo + 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.mHHXDDYXTA deployment.apps/percona-xtradb-cluster-operator created service/percona-xtradb-cluster-operator created + cat /tmp/tmp.VnyKhFcwXo + rm /tmp/tmp.mHHXDDYXTA /tmp/tmp.VnyKhFcwXo + return 0 + sleep 2 ++ get_operator_pod ++ local label_prefix=app.kubernetes.io/ +++ grep -c percona-xtradb-cluster-operator +++ kubectl get pods --selector=app.kubernetes.io/name=percona-xtradb-cluster-operator -n pxc-operator ++ local check_label=1 ++ [[ 1 -eq 0 ]] ++ kubectl_bin get pods --selector=app.kubernetes.io/name=percona-xtradb-cluster-operator -o 'jsonpath={.items[].metadata.name}' -n pxc-operator +++ mktemp ++ local LAST_OUT=/tmp/tmp.kAs2LQ4vpS +++ mktemp ++ local LAST_ERR=/tmp/tmp.acRbjJ267Y ++ 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.kAs2LQ4vpS ++ cat /tmp/tmp.acRbjJ267Y ++ rm /tmp/tmp.kAs2LQ4vpS /tmp/tmp.acRbjJ267Y ++ return 0 + wait_pod percona-xtradb-cluster-operator-7b86f9967b-g2zq5 + local pod=percona-xtradb-cluster-operator-7b86f9967b-g2zq5 + local max_retry=480 + local ns= ++ echo percona-xtradb-cluster-operator-7b86f9967b-g2zq5 ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/percona-xtradb-cluster-operator-7b86f9967b-g2zq5 condition met percona-xtradb-cluster-operator-7b86f9967b-g2zq5.Ok + create_namespace upgrade-proxysql-10153 + local namespace=upgrade-proxysql-10153 + local skip_clean_namespace= + [[ 1 == 1 ]] + [[ -z '' ]] + destroy_chaos_mesh ++ helm list --all-namespaces --filter chaos-mesh ++ tail -n1 ++ sed s/NAMESPACE// ++ awk '-F ' '{print $2}' + local chaos_mesh_ns= + '[' -n '' ']' ++ 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 ++ awk '{print $1}' ++ grep chaos-mesh + timeout 30 kubectl delete ValidatingWebhookConfiguration error: resource(s) were provided, but no name was specified + : ++ grep validate-auth ++ awk '{print $1}' ++ kubectl get ValidatingWebhookConfiguration + timeout 30 kubectl delete ValidatingWebhookConfiguration error: resource(s) were provided, but no name was specified + : ++ grep chaos-mesh ++ kubectl api-resources ++ awk '{print $1}' ++ awk '{print $1}' ++ kubectl get crd ++ grep chaos-mesh.org + timeout 30 kubectl delete crd error: resource(s) were provided, but no name was specified + : ++ kubectl get clusterrolebinding ++ awk '{print $1}' ++ grep chaos-mesh + timeout 30 kubectl delete clusterrolebinding error: resource(s) were provided, but no name was specified + : ++ kubectl get clusterrole ++ grep chaos-mesh ++ awk '{print $1}' + timeout 30 kubectl delete clusterrole error: resource(s) were provided, but no name was specified + : + desc 'cleaned up all old namespaces' + set +o xtrace ----------------------------------------------------------------------------------- cleaned up all old namespaces ----------------------------------------------------------------------------------- + kubectl_bin get ns + awk '{print$1}' + '[' -n '' ']' + desc 'cleaned up old namespaces upgrade-proxysql-10153' + xargs kubectl delete ns + set +o xtrace ----------------------------------------------------------------------------------- cleaned up old namespaces upgrade-proxysql-10153 ----------------------------------------------------------------------------------- + kubectl_bin delete namespace upgrade-proxysql-10153 + egrep -v '^kube-|^default$|Terminating|pxc-operator|openshift|^NAME' ++ mktemp ++ mktemp + local LAST_OUT=/tmp/tmp.cNoy3TZ3oU ++ mktemp + local LAST_ERR=/tmp/tmp.CSCIfqrg2n + local exit_status=0 ++ seq 0 2 + local LAST_OUT=/tmp/tmp.JnLuEdZfhf ++ mktemp + for i in '$(seq 0 2)' + set +e + kubectl get ns + local LAST_ERR=/tmp/tmp.pl81JHFVn1 + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl delete namespace upgrade-proxysql-10153 + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.cNoy3TZ3oU + cat /tmp/tmp.CSCIfqrg2n + rm /tmp/tmp.cNoy3TZ3oU /tmp/tmp.CSCIfqrg2n + 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-10153 + exit_status=1 + set -e + '[' 1 '!=' 0 ']' + '[' 1 == 1 ']' + sleep 0 + for i in '$(seq 0 2)' + set +e + kubectl delete namespace upgrade-proxysql-10153 Error from server (Forbidden): namespaces "default" is forbidden: this namespace may not be deleted + exit_status=1 + set -e + '[' 1 '!=' 0 ']' + '[' 1 == 1 ']' + sleep 0 + cat /tmp/tmp.JnLuEdZfhf + cat /tmp/tmp.pl81JHFVn1 Error from server (NotFound): namespaces "upgrade-proxysql-10153" not found + rm /tmp/tmp.JnLuEdZfhf /tmp/tmp.pl81JHFVn1 + return 1 + : + wait_for_delete namespace/upgrade-proxysql-10153 + local res=namespace/upgrade-proxysql-10153 + echo -n 'namespace/upgrade-proxysql-10153 - ' namespace/upgrade-proxysql-10153 - + set +o xtrace Error from server (NotFound): namespaces "upgrade-proxysql-10153" not found + desc 'create namespace upgrade-proxysql-10153' + set +o xtrace ----------------------------------------------------------------------------------- create namespace upgrade-proxysql-10153 ----------------------------------------------------------------------------------- + kubectl_bin create namespace upgrade-proxysql-10153 ++ mktemp + local LAST_OUT=/tmp/tmp.YSyQBqNxk6 ++ mktemp + local LAST_ERR=/tmp/tmp.UXEqjz9Ogi + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl create namespace upgrade-proxysql-10153 + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.YSyQBqNxk6 namespace/upgrade-proxysql-10153 created + cat /tmp/tmp.UXEqjz9Ogi + rm /tmp/tmp.YSyQBqNxk6 /tmp/tmp.UXEqjz9Ogi + return 0 ++ kubectl_bin config current-context +++ mktemp ++ local LAST_OUT=/tmp/tmp.RttEqJlpmI +++ mktemp ++ local LAST_ERR=/tmp/tmp.RQNnEzh76a ++ 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.RttEqJlpmI ++ cat /tmp/tmp.RQNnEzh76a ++ rm /tmp/tmp.RttEqJlpmI /tmp/tmp.RQNnEzh76a ++ return 0 + kubectl_bin config set-context gke_cloud-dev-112233_us-central1-a_jen-pxc-1752-44f0e1a8-4-cluster5 --namespace=upgrade-proxysql-10153 ++ mktemp + local LAST_OUT=/tmp/tmp.T1sImADdqg ++ mktemp + local LAST_ERR=/tmp/tmp.QBh75NxrCY + 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-1752-44f0e1a8-4-cluster5 --namespace=upgrade-proxysql-10153 + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.T1sImADdqg Context "gke_cloud-dev-112233_us-central1-a_jen-pxc-1752-44f0e1a8-4-cluster5" modified. + cat /tmp/tmp.QBh75NxrCY + rm /tmp/tmp.T1sImADdqg /tmp/tmp.QBh75NxrCY + 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-1752/e2e-tests/conf/minio-secret.yml -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/conf/cloud-secret.yml ++ mktemp + local LAST_OUT=/tmp/tmp.HBVzLDrIpx ++ mktemp + local LAST_ERR=/tmp/tmp.00kNrdfMxT + 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-1752/e2e-tests/conf/minio-secret.yml -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/conf/cloud-secret.yml + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.HBVzLDrIpx secret/minio-secret created secret/aws-s3-secret created secret/gcp-cs-secret created secret/azure-secret created + cat /tmp/tmp.00kNrdfMxT + rm /tmp/tmp.HBVzLDrIpx /tmp/tmp.00kNrdfMxT + return 0 + local proxy=proxysql + local cr_yaml=/tmp/tmp.AvTQUWmnaD/cr_1.14.0_proxysql.yaml + prepare_cr_yaml /tmp/tmp.AvTQUWmnaD/cr_1.14.0_proxysql.yaml proxysql upgrade-proxysql 3 v1.14.0 + local cr_yaml=/tmp/tmp.AvTQUWmnaD/cr_1.14.0_proxysql.yaml + local proxy=proxysql + local cluster=upgrade-proxysql + local cluster_size=3 + local git_tag=v1.14.0 + curl -s https://raw.githubusercontent.com/percona/percona-xtradb-cluster-operator/v1.14.0/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.AvTQUWmnaD/cr_1.14.0_proxysql.yaml + spinup_pxc upgrade-proxysql /tmp/tmp.AvTQUWmnaD/cr_1.14.0_proxysql.yaml 3 30 /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/conf/secrets_without_tls.yml + local cluster=upgrade-proxysql + local config=/tmp/tmp.AvTQUWmnaD/cr_1.14.0_proxysql.yaml + local size=3 + local sleep=30 + local secretsFile=/mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/conf/secrets_without_tls.yml + local pxcClientFile=/mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/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-1752/e2e-tests/conf/secrets_without_tls.yml ++ mktemp + local LAST_OUT=/tmp/tmp.Rvcwpxlsiw ++ mktemp + local LAST_ERR=/tmp/tmp.vwHbPGrC9p + 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-1752/e2e-tests/conf/secrets_without_tls.yml + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.Rvcwpxlsiw secret/my-cluster-secrets created + cat /tmp/tmp.vwHbPGrC9p + rm /tmp/tmp.Rvcwpxlsiw /tmp/tmp.vwHbPGrC9p + return 0 + apply_config /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/conf/client.yml + '[' -z '' ']' + cat_config /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/conf/client.yml + kubectl_bin apply -f - + /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:8.0.36-28.1#' + /usr/bin/sed -e 's#apply:.*#apply: Never#' + /usr/bin/sed -e 's#image:.*-pxc\([0-9]*.[0-9]*\)\{0,1\}$#image: percona/percona-xtradb-cluster:8.0.36-28.1#' + /usr/bin/sed -e 's#image:.*-haproxy$#image: percona/percona-xtradb-cluster-operator:1.14.0-haproxy#' + /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-10153~ + /usr/bin/sed -e 's#image:.*-proxysql$#image: percona/percona-xtradb-cluster-operator:1.14.0-proxysql2.5.5-1.2#' + /usr/bin/sed -e 's#image:.*-backup$#image: percona/percona-xtradb-cluster-operator:1.14.0-pxc8.0.36-backup-pxb8.0.35#' + local LAST_OUT=/tmp/tmp.1eZdZtqab2 + cat /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/conf/client.yml + /usr/bin/sed -e 's#image:.*-pmm$#image: percona/pmm-client:2.41.2#' ++ mktemp + /usr/bin/sed -e 's#image:.*-init$#image: perconalab/percona-xtradb-cluster-operator:1.14.0#' + local LAST_ERR=/tmp/tmp.x5oM1hGOAH + 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.1eZdZtqab2 deployment.apps/pxc-client created + cat /tmp/tmp.x5oM1hGOAH + rm /tmp/tmp.1eZdZtqab2 /tmp/tmp.x5oM1hGOAH + return 0 + [[ percona/percona-xtradb-cluster:8.0.36-28.1 =~ 5\.7 ]] + apply_config /tmp/tmp.AvTQUWmnaD/cr_1.14.0_proxysql.yaml + '[' -z '' ']' + kubectl_bin apply -f - + cat_config /tmp/tmp.AvTQUWmnaD/cr_1.14.0_proxysql.yaml + cat /tmp/tmp.AvTQUWmnaD/cr_1.14.0_proxysql.yaml ++ mktemp + /usr/bin/sed -e 's#apiVersion: pxc.percona.com/v.*$#apiVersion: pxc.percona.com/v1#' + /usr/bin/sed -e 's#image:.*\/percona-xtradb-cluster:.*$#image: percona/percona-xtradb-cluster:8.0.36-28.1#' + local LAST_OUT=/tmp/tmp.ccuEENBq17 + /usr/bin/sed -e 's#image:.*-pxc\([0-9]*.[0-9]*\)\{0,1\}$#image: percona/percona-xtradb-cluster:8.0.36-28.1#' + /usr/bin/sed -e 's#image:.*-proxysql$#image: percona/percona-xtradb-cluster-operator:1.14.0-proxysql2.5.5-1.2#' + /usr/bin/sed -e 's#image:.*-pmm$#image: percona/pmm-client:2.41.2#' + /usr/bin/sed -e 's#apply:.*#apply: Never#' + /usr/bin/sed -e 's#image:.*-haproxy$#image: percona/percona-xtradb-cluster-operator:1.14.0-haproxy#' ++ mktemp + /usr/bin/sed -e 's#image:.*-init$#image: perconalab/percona-xtradb-cluster-operator:1.14.0#' + /usr/bin/sed -e 's#image:.*-backup$#image: percona/percona-xtradb-cluster-operator:1.14.0-pxc8.0.36-backup-pxb8.0.35#' + /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-10153~ + local LAST_ERR=/tmp/tmp.UbwCoeuF8Q + 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.ccuEENBq17 perconaxtradbcluster.pxc.percona.com/upgrade-proxysql created + cat /tmp/tmp.UbwCoeuF8Q + rm /tmp/tmp.ccuEENBq17 /tmp/tmp.UbwCoeuF8Q + 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.40IFdD4IB9 ++++ mktemp +++ local LAST_ERR=/tmp/tmp.VSqQQQD3B1 +++ 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.40IFdD4IB9 +++ cat /tmp/tmp.VSqQQQD3B1 +++ rm /tmp/tmp.40IFdD4IB9 /tmp/tmp.VSqQQQD3B1 +++ return 0 ++ [[ false == \t\r\u\e ]] +++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.enabled}' ++++ mktemp +++ local LAST_OUT=/tmp/tmp.c64PUM4jwT ++++ mktemp +++ local LAST_ERR=/tmp/tmp.gm3ZdopSy0 +++ 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.c64PUM4jwT +++ cat /tmp/tmp.gm3ZdopSy0 +++ rm /tmp/tmp.c64PUM4jwT /tmp/tmp.gm3ZdopSy0 +++ 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-10153 ++ mktemp + local LAST_OUT=/tmp/tmp.kKVzlrRZX4 ++ mktemp + local LAST_ERR=/tmp/tmp.1TMUekSJpW + 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-10153 + 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-10153 + 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-10153 + exit_status=1 + set -e + '[' 1 '!=' 0 ']' + '[' 1 == 1 ']' + sleep 0 + cat /tmp/tmp.kKVzlrRZX4 + cat /tmp/tmp.1TMUekSJpW error: no matching resources found + rm /tmp/tmp.kKVzlrRZX4 /tmp/tmp.1TMUekSJpW + 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 upgrade-proxysql-proxysql-0..........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 upgrade-proxysql-pxc-0.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 upgrade-proxysql-pxc-1.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= ++ egrep '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ echo upgrade-proxysql-pxc-2 + local container=pxc + set +o xtrace pod/upgrade-proxysql-pxc-2 condition met upgrade-proxysql-pxc-2.Ok + sleep 30 + desc 'write data' + set +o xtrace ----------------------------------------------------------------------------------- write data ----------------------------------------------------------------------------------- + [[ percona/percona-xtradb-cluster:8.0.36-28.1 =~ 5\.7 ]] + 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.HBlPxCMOz3 +++ mktemp ++ local LAST_ERR=/tmp/tmp.270BMhCrUb ++ 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.HBlPxCMOz3 ++ cat /tmp/tmp.270BMhCrUb ++ rm /tmp/tmp.HBlPxCMOz3 /tmp/tmp.270BMhCrUb ++ return 0 + client_pod=pxc-client-5f84f5b989-4k2lh + wait_pod pxc-client-5f84f5b989-4k2lh + local pod=pxc-client-5f84f5b989-4k2lh + local max_retry=480 + local ns= ++ egrep '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ echo pxc-client-5f84f5b989-4k2lh + local container= + set +o xtrace pod/pxc-client-5f84f5b989-4k2lh condition met pxc-client-5f84f5b989-4k2lh.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.ylXAqaG97P +++ mktemp ++ local LAST_ERR=/tmp/tmp.4RMOwdaDtN ++ 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.ylXAqaG97P ++ cat /tmp/tmp.4RMOwdaDtN ++ rm /tmp/tmp.ylXAqaG97P /tmp/tmp.4RMOwdaDtN ++ return 0 + client_pod=pxc-client-5f84f5b989-4k2lh + wait_pod pxc-client-5f84f5b989-4k2lh + local pod=pxc-client-5f84f5b989-4k2lh + local max_retry=480 + local ns= ++ echo pxc-client-5f84f5b989-4k2lh ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-5f84f5b989-4k2lh condition met pxc-client-5f84f5b989-4k2lh.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-1752/e2e-tests/upgrade-proxysql/compare/select-1.sql + [[ percona/percona-xtradb-cluster:8.0.36-28.1 =~ 8\.0 ]] + '[' -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/select-1-80.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.8n9WEUssUd +++ mktemp ++ local LAST_ERR=/tmp/tmp.cwhqOYoRVN ++ 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.8n9WEUssUd ++ cat /tmp/tmp.cwhqOYoRVN ++ rm /tmp/tmp.8n9WEUssUd /tmp/tmp.cwhqOYoRVN ++ return 0 + client_pod=pxc-client-5f84f5b989-4k2lh + wait_pod pxc-client-5f84f5b989-4k2lh + local pod=pxc-client-5f84f5b989-4k2lh + local max_retry=480 + local ns= ++ echo pxc-client-5f84f5b989-4k2lh ++ egrep '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container= + set +o xtrace pod/pxc-client-5f84f5b989-4k2lh condition met pxc-client-5f84f5b989-4k2lh.Ok + set +o xtrace + '[' '!' -s /tmp/tmp.AvTQUWmnaD/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/select-1.sql /tmp/tmp.AvTQUWmnaD/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-1752/e2e-tests/upgrade-proxysql/compare/select-1.sql + [[ percona/percona-xtradb-cluster:8.0.36-28.1 =~ 8\.0 ]] + '[' -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/select-1-80.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.2BlZ2crGJB +++ mktemp ++ local LAST_ERR=/tmp/tmp.i5MjkiUWGd ++ 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.2BlZ2crGJB ++ cat /tmp/tmp.i5MjkiUWGd ++ rm /tmp/tmp.2BlZ2crGJB /tmp/tmp.i5MjkiUWGd ++ return 0 + client_pod=pxc-client-5f84f5b989-4k2lh + wait_pod pxc-client-5f84f5b989-4k2lh + local pod=pxc-client-5f84f5b989-4k2lh + local max_retry=480 + local ns= ++ echo pxc-client-5f84f5b989-4k2lh ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-5f84f5b989-4k2lh condition met pxc-client-5f84f5b989-4k2lh.Ok + set +o xtrace + '[' '!' -s /tmp/tmp.AvTQUWmnaD/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/select-1.sql /tmp/tmp.AvTQUWmnaD/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-1752/e2e-tests/upgrade-proxysql/compare/select-1.sql + [[ percona/percona-xtradb-cluster:8.0.36-28.1 =~ 8\.0 ]] + '[' -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/select-1-80.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.ehgxUR4pn4 +++ mktemp ++ local LAST_ERR=/tmp/tmp.2W34WHnpSE ++ 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.ehgxUR4pn4 ++ cat /tmp/tmp.2W34WHnpSE ++ rm /tmp/tmp.ehgxUR4pn4 /tmp/tmp.2W34WHnpSE ++ return 0 + client_pod=pxc-client-5f84f5b989-4k2lh + wait_pod pxc-client-5f84f5b989-4k2lh + local pod=pxc-client-5f84f5b989-4k2lh + local max_retry=480 + local ns= ++ echo pxc-client-5f84f5b989-4k2lh ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-5f84f5b989-4k2lh condition met pxc-client-5f84f5b989-4k2lh.Ok + set +o xtrace + '[' '!' -s /tmp/tmp.AvTQUWmnaD/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/select-1.sql /tmp/tmp.AvTQUWmnaD/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.8afcLOxLns +++ mktemp ++ local LAST_ERR=/tmp/tmp.TkVv6a5HXv ++ 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.8afcLOxLns ++ cat /tmp/tmp.TkVv6a5HXv Unable to use a TTY - input is not a terminal or the right kind of file ++ rm /tmp/tmp.8afcLOxLns /tmp/tmp.TkVv6a5HXv ++ 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[@]}"' ++ kubectl_bin get statefulset upgrade-proxysql-pxc -o 'jsonpath={.metadata.generation}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.uh21qALdTG +++ mktemp ++ local LAST_ERR=/tmp/tmp.AavuATVaR9 ++ 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.uh21qALdTG ++ cat /tmp/tmp.AavuATVaR9 ++ rm /tmp/tmp.uh21qALdTG /tmp/tmp.AavuATVaR9 ++ return 0 + current_generation=1 + [[ 1 != \1 ]] + for container in '"${containers[@]}"' ++ kubectl_bin get statefulset upgrade-proxysql-proxysql -o 'jsonpath={.metadata.generation}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.ScEDJJnFiv +++ mktemp ++ local LAST_ERR=/tmp/tmp.S5vUTlnH5m ++ 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.ScEDJJnFiv ++ cat /tmp/tmp.S5vUTlnH5m ++ rm /tmp/tmp.ScEDJJnFiv /tmp/tmp.S5vUTlnH5m ++ 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-1752/deploy/crd.yaml ++ mktemp + local LAST_OUT=/tmp/tmp.UsWveBnSbX ++ mktemp + local LAST_ERR=/tmp/tmp.pMlxjwvhKt + 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-1752/deploy/crd.yaml + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.UsWveBnSbX 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.pMlxjwvhKt + rm /tmp/tmp.UsWveBnSbX /tmp/tmp.pMlxjwvhKt + 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-1752/deploy/cw-rbac.yaml + sed -e 's^namespace: .*^namespace: pxc-operator^' + kubectl_bin apply -f - ++ mktemp + local LAST_OUT=/tmp/tmp.ssIREl3FxU ++ mktemp + local LAST_ERR=/tmp/tmp.VGNMcpzV3L + 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.ssIREl3FxU clusterrole.rbac.authorization.k8s.io/percona-xtradb-cluster-operator configured serviceaccount/percona-xtradb-cluster-operator created clusterrolebinding.rbac.authorization.k8s.io/service-account-percona-xtradb-cluster-operator unchanged + cat /tmp/tmp.VGNMcpzV3L + rm /tmp/tmp.ssIREl3FxU /tmp/tmp.VGNMcpzV3L + 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-1752-44f0e1a8"}]}}}}' -n pxc-operator ++ mktemp + local LAST_OUT=/tmp/tmp.FGK6u80bEU ++ mktemp + local LAST_ERR=/tmp/tmp.V8K4rC1y0G + 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-1752-44f0e1a8"}]}}}}' -n pxc-operator + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.FGK6u80bEU deployment.apps/percona-xtradb-cluster-operator patched + cat /tmp/tmp.V8K4rC1y0G + rm /tmp/tmp.FGK6u80bEU /tmp/tmp.V8K4rC1y0G + return 0 + kubectl_bin rollout status deployment/percona-xtradb-cluster-operator -n pxc-operator ++ mktemp + local LAST_OUT=/tmp/tmp.oKrhBIWrPG ++ mktemp + local LAST_ERR=/tmp/tmp.yX1RHB5Qdc + 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.oKrhBIWrPG 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.yX1RHB5Qdc + rm /tmp/tmp.oKrhBIWrPG /tmp/tmp.yX1RHB5Qdc + 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.tPUEMDX2CG +++ mktemp ++ local LAST_ERR=/tmp/tmp.0vPYIQTvgm ++ 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.tPUEMDX2CG ++ cat /tmp/tmp.0vPYIQTvgm ++ rm /tmp/tmp.tPUEMDX2CG /tmp/tmp.0vPYIQTvgm ++ return 0 + [[ 1 -eq 1 ]] + '[' -n pxc-operator ']' ++ kubectl_bin config current-context +++ mktemp ++ local LAST_OUT=/tmp/tmp.8Xdn5e1Da0 +++ mktemp ++ local LAST_ERR=/tmp/tmp.GeFA2XCPLw ++ 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.8Xdn5e1Da0 ++ cat /tmp/tmp.GeFA2XCPLw ++ rm /tmp/tmp.8Xdn5e1Da0 /tmp/tmp.GeFA2XCPLw ++ return 0 + kubectl_bin config set-context gke_cloud-dev-112233_us-central1-a_jen-pxc-1752-44f0e1a8-4-cluster5 --namespace=pxc-operator ++ mktemp + local LAST_OUT=/tmp/tmp.l14KPf0k2P ++ mktemp + local LAST_ERR=/tmp/tmp.tqkCjwr7FL + 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-1752-44f0e1a8-4-cluster5 --namespace=pxc-operator + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.l14KPf0k2P Context "gke_cloud-dev-112233_us-central1-a_jen-pxc-1752-44f0e1a8-4-cluster5" modified. + cat /tmp/tmp.tqkCjwr7FL + rm /tmp/tmp.l14KPf0k2P /tmp/tmp.tqkCjwr7FL + 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-1752-44f0e1a8 ++ awk '{print $1}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.419f6ULQky +++ mktemp ++ local LAST_ERR=/tmp/tmp.RrUFpE0lzh ++ 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.419f6ULQky ++ cat /tmp/tmp.RrUFpE0lzh ++ rm /tmp/tmp.419f6ULQky /tmp/tmp.RrUFpE0lzh ++ return 0 + wait_pod percona-xtradb-cluster-operator-64754964cb-zq97t + local pod=percona-xtradb-cluster-operator-64754964cb-zq97t + local max_retry=480 + local ns= ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ echo percona-xtradb-cluster-operator-64754964cb-zq97t ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/percona-xtradb-cluster-operator-64754964cb-zq97t condition met percona-xtradb-cluster-operator-64754964cb-zq97t.Ok ++ kubectl_bin config current-context +++ mktemp ++ local LAST_OUT=/tmp/tmp.3EEGxsgg7G +++ mktemp ++ local LAST_ERR=/tmp/tmp.L5Pu9qTuBt ++ 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.3EEGxsgg7G ++ cat /tmp/tmp.L5Pu9qTuBt ++ rm /tmp/tmp.3EEGxsgg7G /tmp/tmp.L5Pu9qTuBt ++ return 0 + kubectl_bin config set-context gke_cloud-dev-112233_us-central1-a_jen-pxc-1752-44f0e1a8-4-cluster5 --namespace=upgrade-proxysql-10153 ++ mktemp + local LAST_OUT=/tmp/tmp.aKgJ4W0Rp5 ++ mktemp + local LAST_ERR=/tmp/tmp.VDKmBiqP3C + 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-1752-44f0e1a8-4-cluster5 --namespace=upgrade-proxysql-10153 + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.aKgJ4W0Rp5 Context "gke_cloud-dev-112233_us-central1-a_jen-pxc-1752-44f0e1a8-4-cluster5" modified. + cat /tmp/tmp.VDKmBiqP3C + rm /tmp/tmp.aKgJ4W0Rp5 /tmp/tmp.VDKmBiqP3C + 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.pqFCP4Y77i ++++ mktemp +++ local LAST_ERR=/tmp/tmp.lTMHQWz6gK +++ 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.pqFCP4Y77i +++ cat /tmp/tmp.lTMHQWz6gK +++ rm /tmp/tmp.pqFCP4Y77i /tmp/tmp.lTMHQWz6gK +++ return 0 ++ [[ false == \t\r\u\e ]] +++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.enabled}' ++++ mktemp +++ local LAST_OUT=/tmp/tmp.17n0E9Y8YS ++++ mktemp +++ local LAST_ERR=/tmp/tmp.5wFxuD7zBk +++ 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.17n0E9Y8YS +++ cat /tmp/tmp.5wFxuD7zBk +++ rm /tmp/tmp.17n0E9Y8YS /tmp/tmp.5wFxuD7zBk +++ return 0 ++ [[ true == \t\r\u\e ]] ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.size}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.jIWX1BoXwr +++ mktemp ++ local LAST_ERR=/tmp/tmp.w8ayhD2OUS ++ 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.jIWX1BoXwr ++ cat /tmp/tmp.w8ayhD2OUS ++ rm /tmp/tmp.jIWX1BoXwr /tmp/tmp.w8ayhD2OUS ++ 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.BRCzMJDweA +++ mktemp ++ local LAST_ERR=/tmp/tmp.UoWEfHhHWN ++ 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.BRCzMJDweA ++ cat /tmp/tmp.UoWEfHhHWN ++ rm /tmp/tmp.BRCzMJDweA /tmp/tmp.UoWEfHhHWN ++ 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.jtoWb7IKQB +++ mktemp ++ local LAST_ERR=/tmp/tmp.RxzFjTBOH2 ++ 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.jtoWb7IKQB ++ cat /tmp/tmp.RxzFjTBOH2 ++ rm /tmp/tmp.jtoWb7IKQB /tmp/tmp.RxzFjTBOH2 ++ 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.62WcdG43wE ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.vBCxAqDXAC +++++ 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.62WcdG43wE +++++ cat /tmp/tmp.vBCxAqDXAC +++++ rm /tmp/tmp.62WcdG43wE /tmp/tmp.vBCxAqDXAC +++++ return 0 ++++ [[ false == \t\r\u\e ]] +++++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.em6jOJro7F ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.3RwBwM5xDG +++++ 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.em6jOJro7F +++++ cat /tmp/tmp.3RwBwM5xDG +++++ rm /tmp/tmp.em6jOJro7F /tmp/tmp.3RwBwM5xDG +++++ 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.9kKal5ySfQ +++ mktemp ++ local LAST_ERR=/tmp/tmp.S2b5IOfpkO ++ 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.9kKal5ySfQ ++ cat /tmp/tmp.S2b5IOfpkO ++ rm /tmp/tmp.9kKal5ySfQ /tmp/tmp.S2b5IOfpkO ++ 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 upgrade-proxysql-pxc-0.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 upgrade-proxysql-pxc-1.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 upgrade-proxysql-pxc-2.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-1752/e2e-tests/upgrade-proxysql/compare/select-1.sql + [[ percona/percona-xtradb-cluster:8.0.36-28.1 =~ 8\.0 ]] + '[' -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/select-1-80.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.rNZVF4oEzU +++ mktemp ++ local LAST_ERR=/tmp/tmp.xUgkblrKUy ++ 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.rNZVF4oEzU ++ cat /tmp/tmp.xUgkblrKUy ++ rm /tmp/tmp.rNZVF4oEzU /tmp/tmp.xUgkblrKUy ++ return 0 + client_pod=pxc-client-5f84f5b989-4k2lh + wait_pod pxc-client-5f84f5b989-4k2lh + local pod=pxc-client-5f84f5b989-4k2lh + local max_retry=480 + local ns= ++ echo pxc-client-5f84f5b989-4k2lh ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-5f84f5b989-4k2lh condition met pxc-client-5f84f5b989-4k2lh.Ok + set +o xtrace + '[' '!' -s /tmp/tmp.AvTQUWmnaD/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/select-1.sql /tmp/tmp.AvTQUWmnaD/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-1752/e2e-tests/upgrade-proxysql/compare/select-1.sql + [[ percona/percona-xtradb-cluster:8.0.36-28.1 =~ 8\.0 ]] + '[' -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/select-1-80.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.kJIVy1kKBN +++ mktemp ++ local LAST_ERR=/tmp/tmp.HIcZzuIlwn ++ 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.kJIVy1kKBN ++ cat /tmp/tmp.HIcZzuIlwn ++ rm /tmp/tmp.kJIVy1kKBN /tmp/tmp.HIcZzuIlwn ++ return 0 + client_pod=pxc-client-5f84f5b989-4k2lh + wait_pod pxc-client-5f84f5b989-4k2lh + local pod=pxc-client-5f84f5b989-4k2lh + local max_retry=480 + local ns= ++ echo pxc-client-5f84f5b989-4k2lh ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-5f84f5b989-4k2lh condition met pxc-client-5f84f5b989-4k2lh.Ok + set +o xtrace + '[' '!' -s /tmp/tmp.AvTQUWmnaD/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/select-1.sql /tmp/tmp.AvTQUWmnaD/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-1752/e2e-tests/upgrade-proxysql/compare/select-1.sql + [[ percona/percona-xtradb-cluster:8.0.36-28.1 =~ 8\.0 ]] + '[' -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/select-1-80.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.hNCb35J77E +++ mktemp ++ local LAST_ERR=/tmp/tmp.pMEPgRZ0P2 ++ 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.hNCb35J77E ++ cat /tmp/tmp.pMEPgRZ0P2 ++ rm /tmp/tmp.hNCb35J77E /tmp/tmp.pMEPgRZ0P2 ++ return 0 + client_pod=pxc-client-5f84f5b989-4k2lh + wait_pod pxc-client-5f84f5b989-4k2lh + local pod=pxc-client-5f84f5b989-4k2lh + local max_retry=480 + local ns= ++ echo pxc-client-5f84f5b989-4k2lh ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-5f84f5b989-4k2lh condition met pxc-client-5f84f5b989-4k2lh.Ok + set +o xtrace + '[' '!' -s /tmp/tmp.AvTQUWmnaD/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/select-1.sql /tmp/tmp.AvTQUWmnaD/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.S4JoQXvCDP +++ mktemp ++ local LAST_ERR=/tmp/tmp.rJUkNyugRT ++ 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.S4JoQXvCDP ++ cat /tmp/tmp.rJUkNyugRT ++ rm /tmp/tmp.S4JoQXvCDP /tmp/tmp.rJUkNyugRT ++ return 0 + [[ perconalab/percona-xtradb-cluster-operator:PR-1752-44f0e1a8 == perconalab/percona-xtradb-cluster-operator:PR-1752-44f0e1a8 ]] ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.image}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.JgtmLK6jZU +++ mktemp ++ local LAST_ERR=/tmp/tmp.rJqfM6JjnI ++ 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.JgtmLK6jZU ++ cat /tmp/tmp.rJqfM6JjnI ++ rm /tmp/tmp.JgtmLK6jZU /tmp/tmp.rJqfM6JjnI ++ return 0 + [[ percona/percona-xtradb-cluster-operator:1.14.0-proxysql2.5.5-1.2 == percona/percona-xtradb-cluster-operator:1.14.0-proxysql2.5.5-1.2 ]] ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.haproxy.image}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.iYcxyODFvM +++ mktemp ++ local LAST_ERR=/tmp/tmp.98jbB1hnKJ ++ 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.iYcxyODFvM ++ cat /tmp/tmp.98jbB1hnKJ ++ rm /tmp/tmp.iYcxyODFvM /tmp/tmp.98jbB1hnKJ ++ return 0 + [[ percona/percona-xtradb-cluster-operator:1.14.0-haproxy == percona/percona-xtradb-cluster-operator:1.14.0-haproxy ]] ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.backup.image}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.7JCwR50VSY +++ mktemp ++ local LAST_ERR=/tmp/tmp.AV7AzKFT6G ++ 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.7JCwR50VSY ++ cat /tmp/tmp.AV7AzKFT6G ++ rm /tmp/tmp.7JCwR50VSY /tmp/tmp.AV7AzKFT6G ++ return 0 + [[ percona/percona-xtradb-cluster-operator:1.14.0-pxc8.0.36-backup-pxb8.0.35 == percona/percona-xtradb-cluster-operator:1.14.0-pxc8.0.36-backup-pxb8.0.35 ]] ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.pmm.image}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.drqPrEss5m +++ mktemp ++ local LAST_ERR=/tmp/tmp.9QkfdxGKGa ++ 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.drqPrEss5m ++ cat /tmp/tmp.9QkfdxGKGa ++ rm /tmp/tmp.drqPrEss5m /tmp/tmp.9QkfdxGKGa ++ return 0 + [[ percona/pmm-client:2.41.2 == percona/pmm-client:2.41.2 ]] ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.pxc.image}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.rBxn9W9OmU +++ mktemp ++ local LAST_ERR=/tmp/tmp.zNMWMWGfR2 ++ 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.rBxn9W9OmU ++ cat /tmp/tmp.zNMWMWGfR2 ++ rm /tmp/tmp.rBxn9W9OmU /tmp/tmp.zNMWMWGfR2 ++ return 0 + [[ percona/percona-xtradb-cluster:8.0.36-28.1 == percona/percona-xtradb-cluster:8.0.36-28.1 ]] + : 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[@]}"' ++ kubectl_bin get statefulset upgrade-proxysql-pxc -o 'jsonpath={.metadata.generation}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.Aey3q8vFkK +++ mktemp ++ local LAST_ERR=/tmp/tmp.1kLFKZsZ5U ++ 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.Aey3q8vFkK ++ cat /tmp/tmp.1kLFKZsZ5U ++ rm /tmp/tmp.Aey3q8vFkK /tmp/tmp.1kLFKZsZ5U ++ return 0 + current_generation=1 + [[ 1 != \1 ]] + for container in '"${containers[@]}"' ++ kubectl_bin get statefulset upgrade-proxysql-proxysql -o 'jsonpath={.metadata.generation}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.YplpLmceHS +++ mktemp ++ local LAST_ERR=/tmp/tmp.HNxhMlfZDX ++ 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.YplpLmceHS ++ cat /tmp/tmp.HNxhMlfZDX ++ rm /tmp/tmp.YplpLmceHS /tmp/tmp.HNxhMlfZDX ++ 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.15.0", "pxc": { "image": "perconalab/percona-xtradb-cluster-operator:main-pxc8.0" }, "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-pxc8.0-backup" } }}' ++ mktemp + local LAST_OUT=/tmp/tmp.5BVOLz2NQj ++ mktemp + local LAST_ERR=/tmp/tmp.d93R2mpjGm + 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.15.0", "pxc": { "image": "perconalab/percona-xtradb-cluster-operator:main-pxc8.0" }, "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-pxc8.0-backup" } }}' + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.5BVOLz2NQj perconaxtradbcluster.pxc.percona.com/upgrade-proxysql patched + cat /tmp/tmp.d93R2mpjGm + rm /tmp/tmp.5BVOLz2NQj /tmp/tmp.d93R2mpjGm + 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.9POGCpVpEr ++++ mktemp +++ local LAST_ERR=/tmp/tmp.etXKSssIfH +++ 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.9POGCpVpEr +++ cat /tmp/tmp.etXKSssIfH +++ rm /tmp/tmp.9POGCpVpEr /tmp/tmp.etXKSssIfH +++ return 0 ++ [[ false == \t\r\u\e ]] +++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.enabled}' ++++ mktemp +++ local LAST_OUT=/tmp/tmp.9jhqQjXt8G ++++ mktemp +++ local LAST_ERR=/tmp/tmp.c9ITGUuzOB +++ 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.9jhqQjXt8G +++ cat /tmp/tmp.c9ITGUuzOB +++ rm /tmp/tmp.9jhqQjXt8G /tmp/tmp.c9ITGUuzOB +++ return 0 ++ [[ true == \t\r\u\e ]] ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.size}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.F7PPI2psAu +++ mktemp ++ local LAST_ERR=/tmp/tmp.OhBYGHHG4C ++ 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.F7PPI2psAu ++ cat /tmp/tmp.OhBYGHHG4C ++ rm /tmp/tmp.F7PPI2psAu /tmp/tmp.OhBYGHHG4C ++ 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.XhV6wnU15I +++ mktemp ++ local LAST_ERR=/tmp/tmp.F6oNfIZznd ++ 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.XhV6wnU15I ++ cat /tmp/tmp.F6oNfIZznd ++ rm /tmp/tmp.XhV6wnU15I /tmp/tmp.F6oNfIZznd ++ 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.G4kD42NAle +++ mktemp ++ local LAST_ERR=/tmp/tmp.vQuE2lx0mY ++ 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.G4kD42NAle ++ cat /tmp/tmp.vQuE2lx0mY ++ rm /tmp/tmp.G4kD42NAle /tmp/tmp.vQuE2lx0mY ++ 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.D3pXkPWf1Y +++ mktemp ++ local LAST_ERR=/tmp/tmp.7XJtEtyLJ0 ++ 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.D3pXkPWf1Y ++ cat /tmp/tmp.7XJtEtyLJ0 ++ rm /tmp/tmp.D3pXkPWf1Y /tmp/tmp.7XJtEtyLJ0 ++ 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.5bnUCmOdkz +++ mktemp ++ local LAST_ERR=/tmp/tmp.eVBW7wY5qO ++ 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.5bnUCmOdkz ++ cat /tmp/tmp.eVBW7wY5qO ++ rm /tmp/tmp.5bnUCmOdkz /tmp/tmp.eVBW7wY5qO ++ 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.zdZFmX1jtM +++ mktemp ++ local LAST_ERR=/tmp/tmp.RKkhQEaCB6 ++ 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.zdZFmX1jtM ++ cat /tmp/tmp.RKkhQEaCB6 ++ rm /tmp/tmp.zdZFmX1jtM /tmp/tmp.RKkhQEaCB6 ++ 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.ehJh3JJmeQ +++ mktemp ++ local LAST_ERR=/tmp/tmp.2TkRtIOJq2 ++ 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.ehJh3JJmeQ ++ cat /tmp/tmp.2TkRtIOJq2 ++ rm /tmp/tmp.ehJh3JJmeQ /tmp/tmp.2TkRtIOJq2 ++ 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.vmoIygKF7l +++ mktemp ++ local LAST_ERR=/tmp/tmp.ECwOw2JuOq ++ 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.vmoIygKF7l ++ cat /tmp/tmp.ECwOw2JuOq ++ rm /tmp/tmp.vmoIygKF7l /tmp/tmp.ECwOw2JuOq ++ 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.9evPjsB83J +++ mktemp ++ local LAST_ERR=/tmp/tmp.pYuYhJHgkm ++ 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.9evPjsB83J ++ cat /tmp/tmp.pYuYhJHgkm ++ rm /tmp/tmp.9evPjsB83J /tmp/tmp.pYuYhJHgkm ++ 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.Yuwly8qeEY +++ mktemp ++ local LAST_ERR=/tmp/tmp.ppW0VUghXn ++ 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.Yuwly8qeEY ++ cat /tmp/tmp.ppW0VUghXn ++ rm /tmp/tmp.Yuwly8qeEY /tmp/tmp.ppW0VUghXn ++ 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.C55PGPy3Nl +++ mktemp ++ local LAST_ERR=/tmp/tmp.c62DgmxSok ++ 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.C55PGPy3Nl ++ cat /tmp/tmp.c62DgmxSok ++ rm /tmp/tmp.C55PGPy3Nl /tmp/tmp.c62DgmxSok ++ 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.eMo4qcASh0 +++ mktemp ++ local LAST_ERR=/tmp/tmp.GsOLpKRa54 ++ 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.eMo4qcASh0 ++ cat /tmp/tmp.GsOLpKRa54 ++ rm /tmp/tmp.eMo4qcASh0 /tmp/tmp.GsOLpKRa54 ++ 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.AKM8Fm0hwF +++ mktemp ++ local LAST_ERR=/tmp/tmp.Ug3qOzfUut ++ 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.AKM8Fm0hwF ++ cat /tmp/tmp.Ug3qOzfUut ++ rm /tmp/tmp.AKM8Fm0hwF /tmp/tmp.Ug3qOzfUut ++ 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.tCSUxDNHXf +++ mktemp ++ local LAST_ERR=/tmp/tmp.MexKjsHpCP ++ 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.tCSUxDNHXf ++ cat /tmp/tmp.MexKjsHpCP ++ rm /tmp/tmp.tCSUxDNHXf /tmp/tmp.MexKjsHpCP ++ 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.IGJga0wi99 +++ mktemp ++ local LAST_ERR=/tmp/tmp.KD3wDmCMb7 ++ 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.IGJga0wi99 ++ cat /tmp/tmp.KD3wDmCMb7 ++ rm /tmp/tmp.IGJga0wi99 /tmp/tmp.KD3wDmCMb7 ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo 'waiting for cluster readyness' waiting for cluster readyness + sleep 20 + [[ 13 -ge 36 ]] + let i+=1 ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.U3OGHUVGip +++ mktemp ++ local LAST_ERR=/tmp/tmp.5UQXpcXnUO ++ 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.U3OGHUVGip ++ cat /tmp/tmp.5UQXpcXnUO ++ rm /tmp/tmp.U3OGHUVGip /tmp/tmp.5UQXpcXnUO ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo 'waiting for cluster readyness' waiting for cluster readyness + sleep 20 + [[ 14 -ge 36 ]] + let i+=1 ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.9x3DR1He6B +++ mktemp ++ local LAST_ERR=/tmp/tmp.KfngxouQbE ++ 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.9x3DR1He6B ++ cat /tmp/tmp.KfngxouQbE ++ rm /tmp/tmp.9x3DR1He6B /tmp/tmp.KfngxouQbE ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo 'waiting for cluster readyness' waiting for cluster readyness + sleep 20 + [[ 15 -ge 36 ]] + let i+=1 ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.5jji5KM15w +++ mktemp ++ local LAST_ERR=/tmp/tmp.fdHBaJGm56 ++ 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.5jji5KM15w ++ cat /tmp/tmp.fdHBaJGm56 ++ rm /tmp/tmp.5jji5KM15w /tmp/tmp.fdHBaJGm56 ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo 'waiting for cluster readyness' waiting for cluster readyness + sleep 20 + [[ 16 -ge 36 ]] + let i+=1 ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.iV6FNUCFLr +++ mktemp ++ local LAST_ERR=/tmp/tmp.CKr52cU2uL ++ 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.iV6FNUCFLr ++ cat /tmp/tmp.CKr52cU2uL ++ rm /tmp/tmp.iV6FNUCFLr /tmp/tmp.CKr52cU2uL ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo 'waiting for cluster readyness' waiting for cluster readyness + sleep 20 + [[ 17 -ge 36 ]] + let i+=1 ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.O0zkal8Y76 +++ mktemp ++ local LAST_ERR=/tmp/tmp.K1PpgP9yaa ++ 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.O0zkal8Y76 ++ cat /tmp/tmp.K1PpgP9yaa ++ rm /tmp/tmp.O0zkal8Y76 /tmp/tmp.K1PpgP9yaa ++ return 0 + [[ initializing == \r\e\a\d\y ]] + echo 'waiting for cluster readyness' waiting for cluster readyness + sleep 20 + [[ 18 -ge 36 ]] + let i+=1 ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.status.state}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.GwJEXbb9Gc +++ mktemp ++ local LAST_ERR=/tmp/tmp.01FvTQ7tBU ++ 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.GwJEXbb9Gc ++ cat /tmp/tmp.01FvTQ7tBU ++ rm /tmp/tmp.GwJEXbb9Gc /tmp/tmp.01FvTQ7tBU ++ 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.HBykEYv1Td +++ mktemp ++ local LAST_ERR=/tmp/tmp.iGbmDsoSuf ++ 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.HBykEYv1Td ++ cat /tmp/tmp.iGbmDsoSuf ++ rm /tmp/tmp.HBykEYv1Td /tmp/tmp.iGbmDsoSuf ++ 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.3rl90w83Uw ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.v5WJRpqaKs +++++ 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.3rl90w83Uw +++++ cat /tmp/tmp.v5WJRpqaKs +++++ rm /tmp/tmp.3rl90w83Uw /tmp/tmp.v5WJRpqaKs +++++ return 0 ++++ [[ false == \t\r\u\e ]] +++++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.IgUonBYpX3 ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.vdU72SrAdf +++++ 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.IgUonBYpX3 +++++ cat /tmp/tmp.vdU72SrAdf +++++ rm /tmp/tmp.IgUonBYpX3 /tmp/tmp.vdU72SrAdf +++++ 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.guPqav2r4f +++ mktemp ++ local LAST_ERR=/tmp/tmp.l95Y7SPMdV ++ 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.guPqav2r4f ++ cat /tmp/tmp.l95Y7SPMdV ++ rm /tmp/tmp.guPqav2r4f /tmp/tmp.l95Y7SPMdV ++ 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 upgrade-proxysql-pxc-0.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 upgrade-proxysql-pxc-1.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 ++ egrep '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container=pxc + set +o xtrace pod/upgrade-proxysql-pxc-2 condition met upgrade-proxysql-pxc-2.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-1752/e2e-tests/upgrade-proxysql/compare/select-1.sql + [[ percona/percona-xtradb-cluster:8.0.36-28.1 =~ 8\.0 ]] + '[' -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/select-1-80.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.auqgu7fm9k +++ mktemp ++ local LAST_ERR=/tmp/tmp.XnwtUd0mFe ++ 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.auqgu7fm9k ++ cat /tmp/tmp.XnwtUd0mFe ++ rm /tmp/tmp.auqgu7fm9k /tmp/tmp.XnwtUd0mFe ++ return 0 + client_pod=pxc-client-5f84f5b989-4k2lh + wait_pod pxc-client-5f84f5b989-4k2lh + local pod=pxc-client-5f84f5b989-4k2lh + local max_retry=480 + local ns= ++ echo pxc-client-5f84f5b989-4k2lh ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-5f84f5b989-4k2lh condition met pxc-client-5f84f5b989-4k2lh.Ok + set +o xtrace + '[' '!' -s /tmp/tmp.AvTQUWmnaD/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/select-1.sql /tmp/tmp.AvTQUWmnaD/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-1752/e2e-tests/upgrade-proxysql/compare/select-1.sql + [[ percona/percona-xtradb-cluster:8.0.36-28.1 =~ 8\.0 ]] + '[' -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/select-1-80.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.E7KOGo2o63 +++ mktemp ++ local LAST_ERR=/tmp/tmp.ZHcwQoEfOr ++ 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.E7KOGo2o63 ++ cat /tmp/tmp.ZHcwQoEfOr ++ rm /tmp/tmp.E7KOGo2o63 /tmp/tmp.ZHcwQoEfOr ++ return 0 + client_pod=pxc-client-5f84f5b989-4k2lh + wait_pod pxc-client-5f84f5b989-4k2lh + local pod=pxc-client-5f84f5b989-4k2lh + local max_retry=480 + local ns= ++ echo pxc-client-5f84f5b989-4k2lh ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-5f84f5b989-4k2lh condition met pxc-client-5f84f5b989-4k2lh.Ok + set +o xtrace + '[' '!' -s /tmp/tmp.AvTQUWmnaD/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/select-1.sql /tmp/tmp.AvTQUWmnaD/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-1752/e2e-tests/upgrade-proxysql/compare/select-1.sql + [[ percona/percona-xtradb-cluster:8.0.36-28.1 =~ 8\.0 ]] + '[' -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/select-1-80.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.RYYGUP0heN +++ mktemp ++ local LAST_ERR=/tmp/tmp.eOllTM7cSS ++ 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.RYYGUP0heN ++ cat /tmp/tmp.eOllTM7cSS ++ rm /tmp/tmp.RYYGUP0heN /tmp/tmp.eOllTM7cSS ++ return 0 + client_pod=pxc-client-5f84f5b989-4k2lh + wait_pod pxc-client-5f84f5b989-4k2lh + local pod=pxc-client-5f84f5b989-4k2lh + local max_retry=480 + local ns= ++ echo pxc-client-5f84f5b989-4k2lh ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-5f84f5b989-4k2lh condition met pxc-client-5f84f5b989-4k2lh.Ok + set +o xtrace + '[' '!' -s /tmp/tmp.AvTQUWmnaD/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/select-1.sql /tmp/tmp.AvTQUWmnaD/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.ebTR6bHpIx +++ mktemp ++ local LAST_ERR=/tmp/tmp.sqa2UzQzi6 ++ 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.ebTR6bHpIx ++ cat /tmp/tmp.sqa2UzQzi6 ++ rm /tmp/tmp.ebTR6bHpIx /tmp/tmp.sqa2UzQzi6 ++ return 0 + [[ perconalab/percona-xtradb-cluster-operator:PR-1752-44f0e1a8 == perconalab/percona-xtradb-cluster-operator:PR-1752-44f0e1a8 ]] ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.image}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.vYu09LmR83 +++ mktemp ++ local LAST_ERR=/tmp/tmp.rZ2s1CZkOM ++ 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.vYu09LmR83 ++ cat /tmp/tmp.rZ2s1CZkOM ++ rm /tmp/tmp.vYu09LmR83 /tmp/tmp.rZ2s1CZkOM ++ 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.03rL9rizLT +++ mktemp ++ local LAST_ERR=/tmp/tmp.iqaezd3xsZ ++ 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.03rL9rizLT ++ cat /tmp/tmp.iqaezd3xsZ ++ rm /tmp/tmp.03rL9rizLT /tmp/tmp.iqaezd3xsZ ++ 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.zfyBKuX4p5 +++ mktemp ++ local LAST_ERR=/tmp/tmp.nN4dbJiaUU ++ 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.zfyBKuX4p5 ++ cat /tmp/tmp.nN4dbJiaUU ++ rm /tmp/tmp.zfyBKuX4p5 /tmp/tmp.nN4dbJiaUU ++ return 0 + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0-backup == perconalab/percona-xtradb-cluster-operator:main-pxc8.0-backup ]] ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.pmm.image}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.jT1msNIhAh +++ mktemp ++ local LAST_ERR=/tmp/tmp.seYjlFITOi ++ 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.jT1msNIhAh ++ cat /tmp/tmp.seYjlFITOi ++ rm /tmp/tmp.jT1msNIhAh /tmp/tmp.seYjlFITOi ++ 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.AVJmDqsoul +++ mktemp ++ local LAST_ERR=/tmp/tmp.y6KcTukXHg ++ 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.AVJmDqsoul ++ cat /tmp/tmp.y6KcTukXHg ++ rm /tmp/tmp.AVJmDqsoul /tmp/tmp.y6KcTukXHg ++ return 0 + [[ perconalab/percona-xtradb-cluster-operator:main-pxc8.0 == perconalab/percona-xtradb-cluster-operator:main-pxc8.0 ]] + : 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[@]}"' ++ kubectl_bin get statefulset upgrade-proxysql-pxc -o 'jsonpath={.metadata.generation}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.msv6XBbQJa +++ mktemp ++ local LAST_ERR=/tmp/tmp.yos6zcwAtg ++ 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.msv6XBbQJa ++ cat /tmp/tmp.yos6zcwAtg ++ rm /tmp/tmp.msv6XBbQJa /tmp/tmp.yos6zcwAtg ++ return 0 + current_generation=2 + [[ 2 != \2 ]] + for container in '"${containers[@]}"' ++ kubectl_bin get statefulset upgrade-proxysql-proxysql -o 'jsonpath={.metadata.generation}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.Ubk2Mt3n1I +++ mktemp ++ local LAST_ERR=/tmp/tmp.Di9Df8NC4e ++ 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.Ubk2Mt3n1I ++ cat /tmp/tmp.Di9Df8NC4e ++ rm /tmp/tmp.Ubk2Mt3n1I /tmp/tmp.Di9Df8NC4e ++ 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-1752/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-pxc.yml + local new_result=/tmp/tmp.AvTQUWmnaD/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-1752/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-pxc-eks.yml ']' + [[ percona/percona-xtradb-cluster:8.0.36-28.1 =~ 8\.0 ]] + '[' -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-pxc-80.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.26 >= 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.26 >= 1.27' ++ bc -l + '[' 0 -eq 1 ']' + return 1 + version_gt 1.24 + 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.26 >= 1.24' ++ bc -l + '[' 1 -eq 1 ']' + return 0 + '[' -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-pxc-k124.yml ']' + version_gt 1.22 + 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.26 >= 1.22' ++ bc -l + '[' 1 -eq 1 ']' + return 0 + '[' -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-pxc-k122.yml ']' + version_gt 1.21 + 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.26 >= 1.21' ++ bc -l + '[' 1 -eq 1 ']' + return 0 + '[' -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-pxc-k121.yml ']' + '[' '!' -z '' -a -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-pxc-oc.yml ']' + '[' 0 = 1 -a -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-pxc-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."kubernetes.io/psp") | del(.metadata.annotations."batch.kubernetes.io/job-tracking") | 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(.. | 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-10153", "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.OQvTN137Jk ++ mktemp + local LAST_ERR=/tmp/tmp.XgjTFDjxeV + 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.OQvTN137Jk + cat /tmp/tmp.XgjTFDjxeV + rm /tmp/tmp.OQvTN137Jk /tmp/tmp.XgjTFDjxeV + return 0 + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-pxc.yml /tmp/tmp.AvTQUWmnaD/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-1752/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-proxysql.yml + local new_result=/tmp/tmp.AvTQUWmnaD/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-1752/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-proxysql-eks.yml ']' + [[ percona/percona-xtradb-cluster:8.0.36-28.1 =~ 8\.0 ]] + '[' -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-proxysql-80.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.26 >= 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.26 >= 1.27' ++ bc -l + '[' 0 -eq 1 ']' + return 1 + version_gt 1.24 + 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.26 >= 1.24' ++ bc -l + '[' 1 -eq 1 ']' + return 0 + '[' -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-proxysql-k124.yml ']' + version_gt 1.22 + 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.26 >= 1.22' ++ bc -l + '[' 1 -eq 1 ']' + return 0 + '[' -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-proxysql-k122.yml ']' + version_gt 1.21 + 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.26 >= 1.21' ++ bc -l + '[' 1 -eq 1 ']' + return 0 + '[' -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-proxysql-k121.yml ']' + '[' '!' -z '' -a -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-proxysql-oc.yml ']' + '[' 0 = 1 -a -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-proxysql-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."kubernetes.io/psp") | del(.metadata.annotations."batch.kubernetes.io/job-tracking") | 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(.. | 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-10153", "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.aq0Dd67MhE ++ mktemp + local LAST_ERR=/tmp/tmp.r1JgErXVnO + 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.aq0Dd67MhE + cat /tmp/tmp.r1JgErXVnO + rm /tmp/tmp.aq0Dd67MhE /tmp/tmp.r1JgErXVnO + return 0 + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1752/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-proxysql.yml /tmp/tmp.AvTQUWmnaD/statefulset_upgrade-proxysql-proxysql.yml + desc cleanup + set +o xtrace ----------------------------------------------------------------------------------- cleanup ----------------------------------------------------------------------------------- + destroy upgrade-proxysql-10153 + local namespace=upgrade-proxysql-10153 + 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' + tee /tmp/tmp.AvTQUWmnaD/operator.log + sort -u + /usr/bin/sed -r 's/"ts":[0-9.]+//; s^limits-[0-9.]+/^^g' ++ 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.CKTIVfTobo +++ mktemp ++ local LAST_ERR=/tmp/tmp.CvAP007lWm ++ 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.CKTIVfTobo ++ cat /tmp/tmp.CvAP007lWm ++ rm /tmp/tmp.CKTIVfTobo /tmp/tmp.CvAP007lWm ++ return 0 + kubectl_bin logs -n pxc-operator percona-xtradb-cluster-operator-64754964cb-zq97t ++ mktemp + local LAST_OUT=/tmp/tmp.pNwNXAgfYB ++ mktemp + local LAST_ERR=/tmp/tmp.MgNcVKYWSj + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl logs -n pxc-operator percona-xtradb-cluster-operator-64754964cb-zq97t + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.pNwNXAgfYB + cat /tmp/tmp.MgNcVKYWSj + rm /tmp/tmp.pNwNXAgfYB /tmp/tmp.MgNcVKYWSj + return 0 2024-07-08T09:52:53.974Z INFO setup Runs on {"platform": "kubernetes", "version": "v1.26.15-gke.1469001"} 2024-07-08T09:52:53.975Z INFO setup Manager starting up {"gitCommit": "44f0e1a80c0c8b8f0ea06b22799841ae06d9bf8c", "gitBranch": "PR-1752-44f0e1a8", "buildTime": "2024-07-08T07:48:21Z", "goVersion": "go1.22.5", "os": "linux", "arch": "amd64"} 2024-07-08T09:52:53.976Z INFO setup Registering Components. 2024-07-08T09:52:57.273Z INFO controller-runtime.webhook Registering webhook {"path": "/validate-percona-xtradbcluster"} 2024-07-08T09:52:57.276Z INFO controller-runtime.metrics Starting metrics server 2024-07-08T09:52:57.276Z INFO setup Starting the Cmd. 2024-07-08T09:52:57.277Z INFO controller-runtime.certwatcher Updated current TLS certificate 2024-07-08T09:52:57.277Z INFO controller-runtime.metrics Serving metrics server {"bindAddress": ":8080", "secure": false} 2024-07-08T09:52:57.277Z INFO controller-runtime.webhook Serving webhook server {"host": "", "port": 9443} 2024-07-08T09:52:57.277Z INFO controller-runtime.webhook Starting webhook server 2024-07-08T09:52:57.277Z INFO starting server {"name": "health probe", "addr": "[::]:8081"} 2024-07-08T09:52:57.278Z INFO controller-runtime.certwatcher Starting certificate watcher 2024-07-08T09:52:57.378Z INFO attempting to acquire leader lease pxc-operator/08db1feb.percona.com... 2024-07-08T09:53:12.484Z DEBUG events percona-xtradb-cluster-operator-64754964cb-zq97t_d2e756f0-a7eb-40e4-807e-b01a54340e50 became leader {"type": "Normal", "object": {"kind":"Lease","namespace":"pxc-operator","name":"08db1feb.percona.com","uid":"7e650863-ec3b-4805-a5cd-ed57a1da00dc","apiVersion":"coordination.k8s.io/v1","resourceVersion":"67148"}, "reason": "LeaderElection"} 2024-07-08T09:53:12.484Z INFO Starting Controller {"controller": "pxcbackup-controller"} 2024-07-08T09:53:12.484Z INFO Starting Controller {"controller": "pxc-controller"} 2024-07-08T09:53:12.484Z INFO Starting Controller {"controller": "pxcrestore-controller"} 2024-07-08T09:53:12.484Z INFO Starting EventSource {"controller": "pxcbackup-controller", "source": "kind source: *v1.PerconaXtraDBClusterBackup"} 2024-07-08T09:53:12.484Z INFO Starting EventSource {"controller": "pxc-controller", "source": "kind source: *v1.PerconaXtraDBCluster"} 2024-07-08T09:53:12.484Z INFO Starting EventSource {"controller": "pxcrestore-controller", "source": "kind source: *v1.PerconaXtraDBClusterRestore"} 2024-07-08T09:53:12.484Z INFO successfully acquired lease pxc-operator/08db1feb.percona.com 2024-07-08T09:53:12.591Z INFO Starting workers {"controller": "pxcbackup-controller", "worker count": 1} 2024-07-08T09:53:12.591Z INFO Starting workers {"controller": "pxc-controller", "worker count": 1} 2024-07-08T09:53:12.591Z INFO Starting workers {"controller": "pxcrestore-controller", "worker count": 1} 2024-07-08T09:53:14.423Z INFO Creating or updating backup job {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "57a89024-9570-493e-8b18-6d46c08ca1a4", "name": "407a2-daily-backup", "schedule": "0 0 * * *"} 2024-07-08T09:53:16.219Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "57a89024-9570-493e-8b18-6d46c08ca1a4"} 2024-07-08T09:53:23.029Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "f8c22982-cf30-4479-b62a-a5578edc1e55"} 2024-07-08T09:53:29.391Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "1d3a96b2-97f3-45f8-8bfc-5b1facf86a93"} 2024-07-08T09:53:35.707Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "8df0f675-6ec6-4089-b90a-c3f3e6c756d9"} 2024-07-08T09:53:42.288Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "21fbff79-0e08-40c7-8b23-28501f866536"} 2024-07-08T09:53:48.889Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "9d4f0f0e-bc00-4a94-a74f-aeabf3edfab6"} 2024-07-08T09:53:55.397Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "3d5a475a-95f2-4418-a356-70957e7c54da"} 2024-07-08T09:54:02.444Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "398edb81-16f7-4f39-afbf-5bf1712924de"} 2024-07-08T09:54:05.329Z INFO User xtrabackup: granted privileges {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "a8b46194-e947-49c8-891b-b06ffe0456be"} 2024-07-08T09:54:06.652Z INFO statefulSet was changed, run smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "ed9801bc-c818-456b-9334-9c606f57e554"} 2024-07-08T09:54:06.659Z INFO apply changes to secondary pod {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "ed9801bc-c818-456b-9334-9c606f57e554", "pod name": "upgrade-proxysql-pxc-2"} 2024-07-08T09:54:06.659Z INFO primary pod {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "ed9801bc-c818-456b-9334-9c606f57e554", "pod name": "upgrade-proxysql-pxc-0.upgrade-proxysql-pxc.upgrade-proxysql-10153.svc.cluster.local"} 2024-07-08T09:54:08.695Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "a8b46194-e947-49c8-891b-b06ffe0456be"} 2024-07-08T09:54:26.941Z INFO pod is waiting {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "ed9801bc-c818-456b-9334-9c606f57e554", "pod name": "upgrade-proxysql-pxc-2", "reason": "PodInitializing"} 2024-07-08T09:54:56.982Z INFO pod is running {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "ed9801bc-c818-456b-9334-9c606f57e554", "pod name": "upgrade-proxysql-pxc-2"} 2024-07-08T09:56:07.007Z INFO pod present in hostgroups {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "ed9801bc-c818-456b-9334-9c606f57e554", "pod name": "upgrade-proxysql-pxc-2"} 2024-07-08T09:56:07.014Z INFO apply changes to secondary pod {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "ed9801bc-c818-456b-9334-9c606f57e554", "pod name": "upgrade-proxysql-pxc-1"} 2024-07-08T09:56:07.014Z INFO pod is online {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "ed9801bc-c818-456b-9334-9c606f57e554", "pod name": "upgrade-proxysql-pxc-2"} 2024-07-08T09:56:57.306Z INFO pod is running {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "ed9801bc-c818-456b-9334-9c606f57e554", "pod name": "upgrade-proxysql-pxc-1"} 2024-07-08T09:57:57.333Z INFO pod present in hostgroups {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "ed9801bc-c818-456b-9334-9c606f57e554", "pod name": "upgrade-proxysql-pxc-1"} 2024-07-08T09:57:57.339Z INFO pod is online {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "ed9801bc-c818-456b-9334-9c606f57e554", "pod name": "upgrade-proxysql-pxc-1"} 2024-07-08T09:57:57.340Z INFO apply changes to primary pod {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "ed9801bc-c818-456b-9334-9c606f57e554", "pod name": "upgrade-proxysql-pxc-0"} 2024-07-08T09:58:17.653Z INFO pod is waiting {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "ed9801bc-c818-456b-9334-9c606f57e554", "pod name": "upgrade-proxysql-pxc-0", "reason": "PodInitializing"} 2024-07-08T09:58:57.659Z INFO pod is running {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "ed9801bc-c818-456b-9334-9c606f57e554", "pod name": "upgrade-proxysql-pxc-0"} 2024-07-08T10:00:07.684Z INFO pod present in hostgroups {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "ed9801bc-c818-456b-9334-9c606f57e554", "pod name": "upgrade-proxysql-pxc-0"} 2024-07-08T10:00:07.692Z INFO pod is online {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "ed9801bc-c818-456b-9334-9c606f57e554", "pod name": "upgrade-proxysql-pxc-0"} 2024-07-08T10:00:07.692Z INFO smart update finished {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "ed9801bc-c818-456b-9334-9c606f57e554"} 2024-07-08T10:00:07.849Z INFO update PXC version (fetched from db) {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "ed9801bc-c818-456b-9334-9c606f57e554", "new version": "8.0.36-28.1"} 2024-07-08T10:00:15.932Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "1a79013e-408d-404f-a1b7-e27b835a64ae"} 2024-07-08T10:00:19.532Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "69f69fc3-45e3-4d1a-b80b-ec7546622648"} 2024-07-08T10:00:24.869Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "59db9598-ed22-4305-9ba1-0d57c84d04c8"} 2024-07-08T10:00:46.134Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "53d844ab-6ef1-4d11-8efb-697a3e120ae1"} 2024-07-08T10:00:49.947Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "af44c258-c549-4082-b93f-d17571ec4b16"} 2024-07-08T10:00:54.849Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "55d7eea0-431a-46ed-aa6b-125f2b949ce5"} 2024-07-08T10:01:01.815Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "c3c15b66-b52d-4805-9f2f-25ab5481b305"} 2024-07-08T10:01:07.626Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "37f565b1-34bf-4f46-a7a6-95563bcf2652"} 2024-07-08T10:01:14.087Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "bb0c626b-bd83-45f8-a489-fba0784e0765"} 2024-07-08T10:01:20.599Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "c2174b44-ffed-488b-9e12-dbf1413565ff"} 2024-07-08T10:01:26.977Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "787eb39a-2a2e-4b12-b6df-b8e9405abd24"} 2024-07-08T10:01:34.576Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "8ca69eb0-566a-4a42-a9d4-c6a720d0e639"} 2024-07-08T10:01:40.685Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "f64a5ab4-04a2-448b-a29e-6846af8b5426"} 2024-07-08T10:01:47.626Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-10153", "name": "upgrade-proxysql", "reconcileID": "ae4faaa3-6bfd-4800-ac7f-a3d660fbed39"} /go/pkg/mod/sigs.k8s.io/controller-runtime@v0.18.4/pkg/internal/controller/controller.go:222 /go/pkg/mod/sigs.k8s.io/controller-runtime@v0.18.4/pkg/internal/controller/controller.go:261 /go/pkg/mod/sigs.k8s.io/controller-runtime@v0.18.4/pkg/internal/controller/controller.go:324 sigs.k8s.io/controller-runtime/pkg/internal/controller.(*Controller).processNextWorkItem sigs.k8s.io/controller-runtime/pkg/internal/controller.(*Controller).reconcileHandler sigs.k8s.io/controller-runtime/pkg/internal/controller.(*Controller).Start.func2.2 + 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-10153 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.6HZwCllsSD ++ mktemp + local LAST_ERR=/tmp/tmp.9nNQWoXC7q + 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.6HZwCllsSD perconaxtradbcluster.pxc.percona.com "upgrade-proxysql" deleted + cat /tmp/tmp.9nNQWoXC7q + rm /tmp/tmp.6HZwCllsSD /tmp/tmp.9nNQWoXC7q + return 0 + kubectl_bin delete pxc-backup --all --all-namespaces ++ mktemp + local LAST_OUT=/tmp/tmp.6ayVkgIPqg ++ mktemp + local LAST_ERR=/tmp/tmp.85AfDB2YxP + 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.6ayVkgIPqg No resources found + cat /tmp/tmp.85AfDB2YxP + rm /tmp/tmp.6ayVkgIPqg /tmp/tmp.85AfDB2YxP + return 0 + kubectl_bin delete pxc-restore --all --all-namespaces ++ mktemp + local LAST_OUT=/tmp/tmp.05ObMncQqR ++ mktemp + local LAST_ERR=/tmp/tmp.Vmy626R6Dn + 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.05ObMncQqR No resources found + cat /tmp/tmp.Vmy626R6Dn + rm /tmp/tmp.05ObMncQqR /tmp/tmp.Vmy626R6Dn + return 0 + kubectl_bin delete ValidatingWebhookConfiguration percona-xtradbcluster-webhook ++ mktemp + local LAST_OUT=/tmp/tmp.JEKEExc4ln ++ mktemp + local LAST_ERR=/tmp/tmp.hClNHbAPos + 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.JEKEExc4ln validatingwebhookconfiguration.admissionregistration.k8s.io "percona-xtradbcluster-webhook" deleted + cat /tmp/tmp.hClNHbAPos + rm /tmp/tmp.JEKEExc4ln /tmp/tmp.hClNHbAPos + return 0 + kubectl_bin delete -f https://github.com/jetstack/cert-manager/releases/download/v1.14.2/cert-manager.yaml + : + '[' '!' -z '' ']' + '[' -n pxc-operator ']' + kubectl_bin delete --grace-period=0 --force=true namespace upgrade-proxysql-10153 + rm -rf /tmp/tmp.AvTQUWmnaD + kubectl_bin delete --grace-period=0 --force=true namespace pxc-operator ++ mktemp ++ mktemp + local LAST_OUT=/tmp/tmp.G73GSJ4zTy + local LAST_OUT=/tmp/tmp.d4oucMAVSC ++ mktemp ++ mktemp ++ kubectl get crd ++ awk '{print $1}' ++ grep perconaxtradbcluster + local LAST_ERR=/tmp/tmp.6xt3AfPeUP + local exit_status=0 + local LAST_ERR=/tmp/tmp.6oJglqz7WD + local exit_status=0 ++ seq 0 2 ++ seq 0 2 ++ tr '\n' ' ' + for i in '$(seq 0 2)' + set +e + kubectl delete --grace-period=0 --force=true namespace pxc-operator + for i in '$(seq 0 2)' + set +e + kubectl delete --grace-period=0 --force=true namespace upgrade-proxysql-10153 + 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 -----------------------------------------------------------------------------------