Log: /mnt/jenkins/workspace/cloud-pxc-operator_PR-1774/e2e-tests/logs/upgrade-proxysql-5-7.log WARNING: version difference between client (1.30) and server (1.27) exceeds the supported minor version skew of +/-1 WARNING: version difference between client (1.30) and server (1.27) 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-1774-70b9684b + TARGET_IMAGE_PXC=perconalab/percona-xtradb-cluster-operator:main-pxc5.7 + TARGET_IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest + TARGET_IMAGE_PROXY=perconalab/percona-xtradb-cluster-operator:main-proxysql + TARGET_IMAGE_HAPROXY=perconalab/percona-xtradb-cluster-operator:main-haproxy + TARGET_IMAGE_BACKUP=perconalab/percona-xtradb-cluster-operator:main-pxc5.7-backup + [[ perconalab/percona-xtradb-cluster-operator:main-pxc5.7 == *\p\e\r\c\o\n\a\-\x\t\r\a\d\b\-\c\l\u\s\t\e\r\-\o\p\e\r\a\t\o\r* ]] ++ echo -n perconalab/percona-xtradb-cluster-operator:main-pxc5.7 ++ /usr/bin/sed -r 's/.*([0-9].[0-9])$/\1/' + PXC_VER=5.7 ++ sort -V ++ tail -n1 ++ jq -r '.versions[].operator' ++ curl -s https://check.percona.com/versions/v1/pxc-operator + 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=5.7' + INIT_OPERATOR_IMAGES='{"versions":[{"product":"pxc-operator", "operator":"1.14.0", "matrix":{"mongod":{}, "pxc":{"5.7.44-31.65":{"imagePath":"percona/percona-xtradb-cluster:5.7.44-31.65", "imageHash":"36fafdef46485839d4ff7c6dc73b4542b07031644c0152e911acb9734ff2be85", "imageHashArm64":"", "status":"recommended", "critical":false}}, "pmm":{"2.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":{"2.4.29":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-pxc5.7-backup-pxb2.4.29", "imageHash":"e4871437d1a6952f67c43bd10a236dd36c72519220971a8ce644e9320a2a642e", "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":{"5.7.44-31.65":{"imagePath":"percona/percona-xtradb-cluster:5.7.44-31.65", "imageHash":"36fafdef46485839d4ff7c6dc73b4542b07031644c0152e911acb9734ff2be85", "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":{"2.4.29":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-pxc5.7-backup-pxb2.4.29", "imageHash":"e4871437d1a6952f67c43bd10a236dd36c72519220971a8ce644e9320a2a642e", "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-1774-70b9684b ++ cut -d/ -f1 + [[ perconalab == \p\e\r\c\o\n\a\l\a\b ]] + IMAGE=perconalab/percona-xtradb-cluster-operator:1.14.0 ++ echo '{"versions":[{"product":"pxc-operator", "operator":"1.14.0", "matrix":{"mongod":{}, "pxc":{"5.7.44-31.65":{"imagePath":"percona/percona-xtradb-cluster:5.7.44-31.65", "imageHash":"36fafdef46485839d4ff7c6dc73b4542b07031644c0152e911acb9734ff2be85", "imageHashArm64":"", "status":"recommended", "critical":false}}, "pmm":{"2.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":{"2.4.29":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-pxc5.7-backup-pxb2.4.29", "imageHash":"e4871437d1a6952f67c43bd10a236dd36c72519220971a8ce644e9320a2a642e", "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.pxc[].imagePath' + IMAGE_PXC=percona/percona-xtradb-cluster:5.7.44-31.65 ++ echo '{"versions":[{"product":"pxc-operator", "operator":"1.14.0", "matrix":{"mongod":{}, "pxc":{"5.7.44-31.65":{"imagePath":"percona/percona-xtradb-cluster:5.7.44-31.65", "imageHash":"36fafdef46485839d4ff7c6dc73b4542b07031644c0152e911acb9734ff2be85", "imageHashArm64":"", "status":"recommended", "critical":false}}, "pmm":{"2.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":{"2.4.29":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-pxc5.7-backup-pxb2.4.29", "imageHash":"e4871437d1a6952f67c43bd10a236dd36c72519220971a8ce644e9320a2a642e", "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.pmm[].imagePath' + IMAGE_PMM_CLIENT=percona/pmm-client:2.41.2 ++ echo '{"versions":[{"product":"pxc-operator", "operator":"1.14.0", "matrix":{"mongod":{}, "pxc":{"5.7.44-31.65":{"imagePath":"percona/percona-xtradb-cluster:5.7.44-31.65", "imageHash":"36fafdef46485839d4ff7c6dc73b4542b07031644c0152e911acb9734ff2be85", "imageHashArm64":"", "status":"recommended", "critical":false}}, "pmm":{"2.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":{"2.4.29":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-pxc5.7-backup-pxb2.4.29", "imageHash":"e4871437d1a6952f67c43bd10a236dd36c72519220971a8ce644e9320a2a642e", "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":{"5.7.44-31.65":{"imagePath":"percona/percona-xtradb-cluster:5.7.44-31.65", "imageHash":"36fafdef46485839d4ff7c6dc73b4542b07031644c0152e911acb9734ff2be85", "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":{"2.4.29":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-pxc5.7-backup-pxb2.4.29", "imageHash":"e4871437d1a6952f67c43bd10a236dd36c72519220971a8ce644e9320a2a642e", "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":{"5.7.44-31.65":{"imagePath":"percona/percona-xtradb-cluster:5.7.44-31.65", "imageHash":"36fafdef46485839d4ff7c6dc73b4542b07031644c0152e911acb9734ff2be85", "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":{"2.4.29":{"imagePath":"percona/percona-xtradb-cluster-operator:1.14.0-pxc5.7-backup-pxb2.4.29", "imageHash":"e4871437d1a6952f67c43bd10a236dd36c72519220971a8ce644e9320a2a642e", "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-pxc5.7-backup-pxb2.4.29 + [[ 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.xT2vOzvkAL ++ mktemp + local LAST_ERR=/tmp/tmp.yEtnvYNCZt + 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.xT2vOzvkAL namespace/cert-manager created + cat /tmp/tmp.yEtnvYNCZt + rm /tmp/tmp.xT2vOzvkAL /tmp/tmp.yEtnvYNCZt + return 0 + kubectl_bin label namespace cert-manager certmanager.k8s.io/disable-validation=true ++ mktemp + local LAST_OUT=/tmp/tmp.QbzFDqVHz1 ++ mktemp + local LAST_ERR=/tmp/tmp.DXh9EknpWt + 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.QbzFDqVHz1 namespace/cert-manager labeled + cat /tmp/tmp.DXh9EknpWt + rm /tmp/tmp.QbzFDqVHz1 /tmp/tmp.DXh9EknpWt + 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.gONI3dERuM ++ mktemp + local LAST_ERR=/tmp/tmp.tfwLPPZeWg + 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.gONI3dERuM 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.tfwLPPZeWg 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.gONI3dERuM /tmp/tmp.tfwLPPZeWg + return 0 + '[' '' == 4.10 ']' + sleep 70 + create_infra_gh upgrade-proxysql-22248 v1.14.0 + local ns=upgrade-proxysql-22248 + 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 ++ awk '-F ' '{print $2}' ++ sed s/NAMESPACE// + local chaos_mesh_ns= + '[' -n '' ']' ++ kubectl get MutatingWebhookConfiguration ++ grep chaos-mesh ++ awk '{print $1}' + timeout 30 kubectl delete MutatingWebhookConfiguration error: resource(s) were provided, but no name was specified + : ++ kubectl get ValidatingWebhookConfiguration ++ grep chaos-mesh ++ awk '{print $1}' + timeout 30 kubectl delete ValidatingWebhookConfiguration error: resource(s) were provided, but no name was specified + : ++ kubectl get ValidatingWebhookConfiguration ++ grep validate-auth ++ awk '{print $1}' + timeout 30 kubectl delete ValidatingWebhookConfiguration error: resource(s) were provided, but no name was specified + : ++ kubectl api-resources ++ grep chaos-mesh ++ awk '{print $1}' ++ kubectl get crd ++ grep chaos-mesh.org ++ awk '{print $1}' + timeout 30 kubectl delete crd error: resource(s) were provided, but no name was specified + : ++ kubectl get clusterrolebinding ++ grep chaos-mesh ++ awk '{print $1}' + timeout 30 kubectl delete clusterrolebinding error: resource(s) were provided, but no name was specified + : ++ kubectl get clusterrole ++ grep chaos-mesh ++ awk '{print $1}' + timeout 30 kubectl delete clusterrole error: resource(s) were provided, but no name was specified + : + desc 'cleaned up all old namespaces' + set +o xtrace ----------------------------------------------------------------------------------- cleaned up all old namespaces ----------------------------------------------------------------------------------- + kubectl_bin get ns + egrep -v '^kube-|^default$|Terminating|pxc-operator|openshift|^NAME' + '[' -n '' ']' + desc 'cleaned up old namespaces pxc-operator' + set +o xtrace ++ mktemp ----------------------------------------------------------------------------------- cleaned up old namespaces pxc-operator ----------------------------------------------------------------------------------- + kubectl_bin delete namespace pxc-operator + awk '{print$1}' + xargs kubectl delete ns + local LAST_OUT=/tmp/tmp.MwiuiqviNP ++ mktemp ++ mktemp + local LAST_ERR=/tmp/tmp.1Y4jo0GjYz + local exit_status=0 ++ seq 0 2 + local LAST_OUT=/tmp/tmp.TxpOsTpTYq ++ mktemp + for i in '$(seq 0 2)' + set +e + kubectl get ns + local LAST_ERR=/tmp/tmp.NbeIiAq1al + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl delete namespace pxc-operator + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.MwiuiqviNP + cat /tmp/tmp.1Y4jo0GjYz + rm /tmp/tmp.MwiuiqviNP /tmp/tmp.1Y4jo0GjYz + return 0 namespace "cert-manager" deleted namespace "gmp-public" deleted namespace "gmp-system" deleted namespace "upgrade-proxysql-29644" 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.TxpOsTpTYq namespace "pxc-operator" deleted + cat /tmp/tmp.NbeIiAq1al + rm /tmp/tmp.TxpOsTpTYq /tmp/tmp.NbeIiAq1al + 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.vPkWxSYU2C ++ mktemp + local LAST_ERR=/tmp/tmp.UfyxG3GGV5 + 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.vPkWxSYU2C namespace/pxc-operator created + cat /tmp/tmp.UfyxG3GGV5 + rm /tmp/tmp.vPkWxSYU2C /tmp/tmp.UfyxG3GGV5 + return 0 ++ kubectl_bin config current-context +++ mktemp ++ local LAST_OUT=/tmp/tmp.RHnY0ctGud +++ mktemp ++ local LAST_ERR=/tmp/tmp.0xYmtMWaFs ++ 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.RHnY0ctGud ++ cat /tmp/tmp.0xYmtMWaFs ++ rm /tmp/tmp.RHnY0ctGud /tmp/tmp.0xYmtMWaFs ++ return 0 + kubectl_bin config set-context gke_cloud-dev-112233_us-central1-a_jen-pxc-1774-70b9684b-2-cluster6 --namespace=pxc-operator ++ mktemp + local LAST_OUT=/tmp/tmp.lw7J9p5kJR ++ mktemp + local LAST_ERR=/tmp/tmp.LfdiscMHFQ + 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-1774-70b9684b-2-cluster6 --namespace=pxc-operator + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.lw7J9p5kJR Context "gke_cloud-dev-112233_us-central1-a_jen-pxc-1774-70b9684b-2-cluster6" modified. + cat /tmp/tmp.LfdiscMHFQ + rm /tmp/tmp.lw7J9p5kJR /tmp/tmp.LfdiscMHFQ + 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.az5hRO0vdD +++ mktemp ++ local LAST_ERR=/tmp/tmp.NQ660PJ0T6 ++ 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.az5hRO0vdD ++ cat /tmp/tmp.NQ660PJ0T6 ++ rm /tmp/tmp.az5hRO0vdD /tmp/tmp.NQ660PJ0T6 ++ 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.l6WhRkK1ng +++ mktemp ++ local LAST_ERR=/tmp/tmp.JFxpMymb8B ++ 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.l6WhRkK1ng ++ cat /tmp/tmp.JFxpMymb8B ++ rm /tmp/tmp.l6WhRkK1ng /tmp/tmp.JFxpMymb8B ++ 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.3LKYpKfFbh ++ mktemp + local LAST_ERR=/tmp/tmp.Auud6tlbmd + 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.3LKYpKfFbh + cat /tmp/tmp.Auud6tlbmd + rm /tmp/tmp.3LKYpKfFbh /tmp/tmp.Auud6tlbmd + 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.sqKUwUqNIA/rbac_v1.14.0.yaml + kubectl_bin apply -f /tmp/tmp.sqKUwUqNIA/rbac_v1.14.0.yaml ++ mktemp + local LAST_OUT=/tmp/tmp.VwU1wTv9vb ++ mktemp + local LAST_ERR=/tmp/tmp.RTIqH8Hiij + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl apply -f /tmp/tmp.sqKUwUqNIA/rbac_v1.14.0.yaml + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.VwU1wTv9vb 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.RTIqH8Hiij + rm /tmp/tmp.VwU1wTv9vb /tmp/tmp.RTIqH8Hiij + return 0 + curl -s https://raw.githubusercontent.com/percona/percona-xtradb-cluster-operator/v1.14.0/deploy/cw-operator.yaml + cat /tmp/tmp.sqKUwUqNIA/cw-operator.yaml_v1.14.0.yaml + 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"' + sed -e 's^image: .*^image: perconalab/percona-xtradb-cluster-operator:1.14.0^' + kubectl_bin apply -n pxc-operator -f - ++ mktemp + local LAST_OUT=/tmp/tmp.UcnKnW2NU6 ++ mktemp + local LAST_ERR=/tmp/tmp.ekqHmnqgoS + 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.UcnKnW2NU6 deployment.apps/percona-xtradb-cluster-operator created service/percona-xtradb-cluster-operator created + cat /tmp/tmp.ekqHmnqgoS + rm /tmp/tmp.UcnKnW2NU6 /tmp/tmp.ekqHmnqgoS + return 0 + sleep 2 ++ get_operator_pod ++ local label_prefix=app.kubernetes.io/ +++ kubectl get pods --selector=app.kubernetes.io/name=percona-xtradb-cluster-operator -n pxc-operator +++ grep -c percona-xtradb-cluster-operator ++ local check_label=1 ++ [[ 1 -eq 0 ]] ++ kubectl_bin get pods --selector=app.kubernetes.io/name=percona-xtradb-cluster-operator -o 'jsonpath={.items[].metadata.name}' -n pxc-operator +++ mktemp ++ local LAST_OUT=/tmp/tmp.ggKsrmT9UY +++ mktemp ++ local LAST_ERR=/tmp/tmp.joQZ95ZofN ++ 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.ggKsrmT9UY ++ cat /tmp/tmp.joQZ95ZofN ++ rm /tmp/tmp.ggKsrmT9UY /tmp/tmp.joQZ95ZofN ++ return 0 + wait_pod percona-xtradb-cluster-operator-79cc44d5bb-58zjs + local pod=percona-xtradb-cluster-operator-79cc44d5bb-58zjs + local max_retry=480 + local ns= ++ echo percona-xtradb-cluster-operator-79cc44d5bb-58zjs ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/percona-xtradb-cluster-operator-79cc44d5bb-58zjs condition met percona-xtradb-cluster-operator-79cc44d5bb-58zjs.Ok + create_namespace upgrade-proxysql-22248 + local namespace=upgrade-proxysql-22248 + 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 ++ grep chaos-mesh ++ awk '{print $1}' + timeout 30 kubectl delete ValidatingWebhookConfiguration error: resource(s) were provided, but no name was specified + : ++ kubectl get ValidatingWebhookConfiguration ++ grep validate-auth ++ awk '{print $1}' + timeout 30 kubectl delete ValidatingWebhookConfiguration error: resource(s) were provided, but no name was specified + : ++ kubectl api-resources ++ grep chaos-mesh ++ awk '{print $1}' ++ kubectl get crd ++ grep chaos-mesh.org ++ awk '{print $1}' + timeout 30 kubectl delete crd error: resource(s) were provided, but no name was specified + : ++ kubectl get clusterrolebinding ++ awk '{print $1}' ++ grep chaos-mesh + timeout 30 kubectl delete clusterrolebinding error: resource(s) were provided, but no name was specified + : ++ kubectl get clusterrole ++ awk '{print $1}' ++ grep chaos-mesh + timeout 30 kubectl delete clusterrole error: resource(s) were provided, but no name was specified + : + desc 'cleaned up all old namespaces' + set +o xtrace ----------------------------------------------------------------------------------- cleaned up all old namespaces ----------------------------------------------------------------------------------- + kubectl_bin get ns + egrep -v '^kube-|^default$|Terminating|pxc-operator|openshift|^NAME' + awk '{print$1}' + '[' -n '' ']' + xargs kubectl delete ns + desc 'cleaned up old namespaces upgrade-proxysql-22248' + set +o xtrace ----------------------------------------------------------------------------------- cleaned up old namespaces upgrade-proxysql-22248 ----------------------------------------------------------------------------------- + kubectl_bin delete namespace upgrade-proxysql-22248 ++ mktemp ++ mktemp + local LAST_OUT=/tmp/tmp.v65ghHQfAh + local LAST_OUT=/tmp/tmp.8W1CweACAS ++ mktemp ++ mktemp + local LAST_ERR=/tmp/tmp.Vi20RvM6WN + local LAST_ERR=/tmp/tmp.R4nhTVsK3P + local exit_status=0 + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl delete namespace upgrade-proxysql-22248 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl get ns + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.v65ghHQfAh + exit_status=1 + set -e + '[' 1 '!=' 0 ']' + '[' 1 == 1 ']' + sleep 0 + cat /tmp/tmp.Vi20RvM6WN + for i in '$(seq 0 2)' + set +e + kubectl delete namespace upgrade-proxysql-22248 + rm /tmp/tmp.v65ghHQfAh /tmp/tmp.Vi20RvM6WN + 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-22248 namespace "gmp-public" deleted namespace "gmp-system" deleted 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.8W1CweACAS + cat /tmp/tmp.R4nhTVsK3P Error from server (NotFound): namespaces "upgrade-proxysql-22248" not found + rm /tmp/tmp.8W1CweACAS /tmp/tmp.R4nhTVsK3P + return 1 + : + wait_for_delete namespace/upgrade-proxysql-22248 + local res=namespace/upgrade-proxysql-22248 + echo -n 'namespace/upgrade-proxysql-22248 - ' namespace/upgrade-proxysql-22248 - + set +o xtrace Error from server (NotFound): namespaces "upgrade-proxysql-22248" not found + desc 'create namespace upgrade-proxysql-22248' + set +o xtrace ----------------------------------------------------------------------------------- create namespace upgrade-proxysql-22248 ----------------------------------------------------------------------------------- + kubectl_bin create namespace upgrade-proxysql-22248 ++ mktemp + local LAST_OUT=/tmp/tmp.i8bFvrlswS ++ mktemp + local LAST_ERR=/tmp/tmp.zXnftqGUtk + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl create namespace upgrade-proxysql-22248 + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.i8bFvrlswS namespace/upgrade-proxysql-22248 created + cat /tmp/tmp.zXnftqGUtk + rm /tmp/tmp.i8bFvrlswS /tmp/tmp.zXnftqGUtk + return 0 ++ kubectl_bin config current-context +++ mktemp ++ local LAST_OUT=/tmp/tmp.1W5LeBT1gX +++ mktemp ++ local LAST_ERR=/tmp/tmp.nCmRJ3YQw1 ++ 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.1W5LeBT1gX ++ cat /tmp/tmp.nCmRJ3YQw1 ++ rm /tmp/tmp.1W5LeBT1gX /tmp/tmp.nCmRJ3YQw1 ++ return 0 + kubectl_bin config set-context gke_cloud-dev-112233_us-central1-a_jen-pxc-1774-70b9684b-2-cluster6 --namespace=upgrade-proxysql-22248 ++ mktemp + local LAST_OUT=/tmp/tmp.CpA4yDnGhZ ++ mktemp + local LAST_ERR=/tmp/tmp.bQR5UbpGmc + 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-1774-70b9684b-2-cluster6 --namespace=upgrade-proxysql-22248 + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.CpA4yDnGhZ Context "gke_cloud-dev-112233_us-central1-a_jen-pxc-1774-70b9684b-2-cluster6" modified. + cat /tmp/tmp.bQR5UbpGmc + rm /tmp/tmp.CpA4yDnGhZ /tmp/tmp.bQR5UbpGmc + 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-1774/e2e-tests/conf/minio-secret.yml -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1774/e2e-tests/conf/cloud-secret.yml ++ mktemp + local LAST_OUT=/tmp/tmp.lssZ2Wr4jS ++ mktemp + local LAST_ERR=/tmp/tmp.1aK1bdvSaV + 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-1774/e2e-tests/conf/minio-secret.yml -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1774/e2e-tests/conf/cloud-secret.yml + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.lssZ2Wr4jS secret/minio-secret created secret/aws-s3-secret created secret/gcp-cs-secret created secret/azure-secret created + cat /tmp/tmp.1aK1bdvSaV + rm /tmp/tmp.lssZ2Wr4jS /tmp/tmp.1aK1bdvSaV + return 0 + local proxy=proxysql + local cr_yaml=/tmp/tmp.sqKUwUqNIA/cr_1.14.0_proxysql.yaml + prepare_cr_yaml /tmp/tmp.sqKUwUqNIA/cr_1.14.0_proxysql.yaml proxysql upgrade-proxysql 3 v1.14.0 + local cr_yaml=/tmp/tmp.sqKUwUqNIA/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.sqKUwUqNIA/cr_1.14.0_proxysql.yaml + spinup_pxc upgrade-proxysql /tmp/tmp.sqKUwUqNIA/cr_1.14.0_proxysql.yaml 3 30 /mnt/jenkins/workspace/cloud-pxc-operator_PR-1774/e2e-tests/conf/secrets_without_tls.yml + local cluster=upgrade-proxysql + local config=/tmp/tmp.sqKUwUqNIA/cr_1.14.0_proxysql.yaml + local size=3 + local sleep=30 + local secretsFile=/mnt/jenkins/workspace/cloud-pxc-operator_PR-1774/e2e-tests/conf/secrets_without_tls.yml + local pxcClientFile=/mnt/jenkins/workspace/cloud-pxc-operator_PR-1774/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-1774/e2e-tests/conf/secrets_without_tls.yml ++ mktemp + local LAST_OUT=/tmp/tmp.P20eQWhQh9 ++ mktemp + local LAST_ERR=/tmp/tmp.qJSK6W6DHo + 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-1774/e2e-tests/conf/secrets_without_tls.yml + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.P20eQWhQh9 secret/my-cluster-secrets created + cat /tmp/tmp.qJSK6W6DHo + rm /tmp/tmp.P20eQWhQh9 /tmp/tmp.qJSK6W6DHo + return 0 + apply_config /mnt/jenkins/workspace/cloud-pxc-operator_PR-1774/e2e-tests/conf/client.yml + '[' -z '' ']' + kubectl_bin apply -f - + cat_config /mnt/jenkins/workspace/cloud-pxc-operator_PR-1774/e2e-tests/conf/client.yml + cat /mnt/jenkins/workspace/cloud-pxc-operator_PR-1774/e2e-tests/conf/client.yml + /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-pxc5.7-backup-pxb2.4.29#' + /usr/bin/sed -e 's#image:.*-haproxy$#image: percona/percona-xtradb-cluster-operator:1.14.0-haproxy#' + /usr/bin/sed -e s~minio-service.#namespace~minio-service.upgrade-proxysql-22248~ + /usr/bin/sed -e 's#apply:.*#apply: Never#' + /usr/bin/sed -e 's#image:.*\/percona-xtradb-cluster:.*$#image: percona/percona-xtradb-cluster:5.7.44-31.65#' + /usr/bin/sed -e 's#apiVersion: pxc.percona.com/v.*$#apiVersion: pxc.percona.com/v1#' + /usr/bin/sed -e 's#image:.*-logcollector$#image: perconalab/percona-xtradb-cluster-operator:main-logcollector#' + /usr/bin/sed -e 's#image:.*-proxysql$#image: percona/percona-xtradb-cluster-operator:1.14.0-proxysql2.5.5-1.2#' + /usr/bin/sed -e 's#image:.*-pxc\([0-9]*.[0-9]*\)\{0,1\}$#image: percona/percona-xtradb-cluster:5.7.44-31.65#' ++ mktemp + local LAST_OUT=/tmp/tmp.8xhDCf04qs + /usr/bin/sed -e 's#image:.*-pmm$#image: percona/pmm-client:2.41.2#' ++ mktemp + local LAST_ERR=/tmp/tmp.o7cEN9bwsH + 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.8xhDCf04qs deployment.apps/pxc-client created + cat /tmp/tmp.o7cEN9bwsH + rm /tmp/tmp.8xhDCf04qs /tmp/tmp.o7cEN9bwsH + return 0 + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 5\.7 ]] + [[ upgrade-proxysql == \d\e\m\a\n\d\-\b\a\c\k\u\p ]] + [[ upgrade-proxysql == \d\e\m\a\n\d\-\b\a\c\k\u\p\-\c\l\o\u\d ]] + apply_config /tmp/tmp.sqKUwUqNIA/cr_1.14.0_proxysql.yaml + '[' -z '' ']' + kubectl_bin apply -f - + cat_config /tmp/tmp.sqKUwUqNIA/cr_1.14.0_proxysql.yaml ++ mktemp + local LAST_OUT=/tmp/tmp.zN8CnBaFj7 + /usr/bin/sed -e 's#image:.*\/percona-xtradb-cluster:.*$#image: percona/percona-xtradb-cluster:5.7.44-31.65#' + /usr/bin/sed -e 's#image:.*-init$#image: perconalab/percona-xtradb-cluster-operator:1.14.0#' + /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:.*-haproxy$#image: percona/percona-xtradb-cluster-operator:1.14.0-haproxy#' + /usr/bin/sed -e 's#image:.*-backup$#image: percona/percona-xtradb-cluster-operator:1.14.0-pxc5.7-backup-pxb2.4.29#' ++ mktemp + /usr/bin/sed -e 's#image:.*-pmm$#image: percona/pmm-client:2.41.2#' + cat /tmp/tmp.sqKUwUqNIA/cr_1.14.0_proxysql.yaml + local LAST_ERR=/tmp/tmp.vjkchfNFRV + local exit_status=0 ++ seq 0 2 + /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-22248~ + for i in '$(seq 0 2)' + set +e + kubectl apply -f - + /usr/bin/sed -e 's#apply:.*#apply: Never#' + /usr/bin/sed -e 's#apiVersion: pxc.percona.com/v.*$#apiVersion: pxc.percona.com/v1#' + /usr/bin/sed -e 's#image:.*-pxc\([0-9]*.[0-9]*\)\{0,1\}$#image: percona/percona-xtradb-cluster:5.7.44-31.65#' + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.zN8CnBaFj7 perconaxtradbcluster.pxc.percona.com/upgrade-proxysql created + cat /tmp/tmp.vjkchfNFRV + rm /tmp/tmp.zN8CnBaFj7 /tmp/tmp.vjkchfNFRV + 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.aKi63sKtyx ++++ mktemp +++ local LAST_ERR=/tmp/tmp.u9Qz2E95xr +++ 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.aKi63sKtyx +++ cat /tmp/tmp.u9Qz2E95xr +++ rm /tmp/tmp.aKi63sKtyx /tmp/tmp.u9Qz2E95xr +++ return 0 ++ [[ false == \t\r\u\e ]] +++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.enabled}' ++++ mktemp +++ local LAST_OUT=/tmp/tmp.cN8SoRUsqc ++++ mktemp +++ local LAST_ERR=/tmp/tmp.8b9jjGtEkA +++ 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.cN8SoRUsqc +++ cat /tmp/tmp.8b9jjGtEkA +++ rm /tmp/tmp.cN8SoRUsqc /tmp/tmp.8b9jjGtEkA +++ 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-22248 ++ mktemp + local LAST_OUT=/tmp/tmp.Pbeex4zqYC ++ mktemp + local LAST_ERR=/tmp/tmp.LNiD110nEz + 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-22248 + 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-22248 + 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-22248 + exit_status=1 + set -e + '[' 1 '!=' 0 ']' + '[' 1 == 1 ']' + sleep 0 + cat /tmp/tmp.Pbeex4zqYC + cat /tmp/tmp.LNiD110nEz error: no matching resources found + rm /tmp/tmp.Pbeex4zqYC /tmp/tmp.LNiD110nEz + 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 pod/upgrade-proxysql-proxysql-0 condition met 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= ++ 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 + sleep 30 + desc 'write data' + set +o xtrace ----------------------------------------------------------------------------------- write data ----------------------------------------------------------------------------------- + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 5\.7 ]] ++ is_keyring_plugin_in_use upgrade-proxysql ++ local cluster=upgrade-proxysql ++ kubectl_bin exec -it upgrade-proxysql-pxc-0 -c pxc -- bash -c 'cat /etc/mysql/node.cnf' ++ egrep -o 'early-plugin-load=keyring_\w+.so' +++ mktemp ++ local LAST_OUT=/tmp/tmp.sy25eJn4xf +++ mktemp ++ local LAST_ERR=/tmp/tmp.eNwfhWun6p ++ 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.sy25eJn4xf ++ cat /tmp/tmp.eNwfhWun6p Unable to use a TTY - input is not a terminal or the right kind of file ++ rm /tmp/tmp.sy25eJn4xf /tmp/tmp.eNwfhWun6p ++ return 0 + [[ -n '' ]] + run_mysql 'CREATE DATABASE IF NOT EXISTS myApp; use myApp; CREATE TABLE IF NOT EXISTS myApp (id int PRIMARY KEY) ;' '-h upgrade-proxysql-proxysql -uroot -proot_password -P3306' + local 'command=CREATE DATABASE IF NOT EXISTS myApp; use myApp; CREATE TABLE IF NOT EXISTS myApp (id int PRIMARY KEY) ;' + local 'uri=-h upgrade-proxysql-proxysql -uroot -proot_password -P3306' ++ get_client_pod ++ kubectl_bin get pods --selector=name=pxc-client -o 'jsonpath={.items[].metadata.name}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.rNi8D0IY6j +++ mktemp ++ local LAST_ERR=/tmp/tmp.hSQbNn50Ci ++ 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.rNi8D0IY6j ++ cat /tmp/tmp.hSQbNn50Ci ++ rm /tmp/tmp.rNi8D0IY6j /tmp/tmp.hSQbNn50Ci ++ return 0 + client_pod=pxc-client-7c58656fdc-nbcdt + wait_pod pxc-client-7c58656fdc-nbcdt + local pod=pxc-client-7c58656fdc-nbcdt + local max_retry=480 + local ns= ++ echo pxc-client-7c58656fdc-nbcdt ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-7c58656fdc-nbcdt condition met pxc-client-7c58656fdc-nbcdt.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.tU9RggAwPR +++ mktemp ++ local LAST_ERR=/tmp/tmp.5C1SsV1W3E ++ 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.tU9RggAwPR ++ cat /tmp/tmp.5C1SsV1W3E ++ rm /tmp/tmp.tU9RggAwPR /tmp/tmp.5C1SsV1W3E ++ return 0 + client_pod=pxc-client-7c58656fdc-nbcdt + wait_pod pxc-client-7c58656fdc-nbcdt + local pod=pxc-client-7c58656fdc-nbcdt + local max_retry=480 + local ns= ++ echo pxc-client-7c58656fdc-nbcdt ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-7c58656fdc-nbcdt condition met pxc-client-7c58656fdc-nbcdt.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-1774/e2e-tests/upgrade-proxysql/compare/select-1.sql + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.0 ]] + 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.34llF1Fvm0 +++ mktemp ++ local LAST_ERR=/tmp/tmp.4sRR5exlAM ++ 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.34llF1Fvm0 ++ cat /tmp/tmp.4sRR5exlAM ++ rm /tmp/tmp.34llF1Fvm0 /tmp/tmp.4sRR5exlAM ++ return 0 + client_pod=pxc-client-7c58656fdc-nbcdt + wait_pod pxc-client-7c58656fdc-nbcdt + local pod=pxc-client-7c58656fdc-nbcdt + local max_retry=480 + local ns= ++ echo pxc-client-7c58656fdc-nbcdt ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-7c58656fdc-nbcdt condition met pxc-client-7c58656fdc-nbcdt.Ok + set +o xtrace + '[' '!' -s /tmp/tmp.sqKUwUqNIA/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1774/e2e-tests/upgrade-proxysql/compare/select-1.sql /tmp/tmp.sqKUwUqNIA/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-1774/e2e-tests/upgrade-proxysql/compare/select-1.sql + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.0 ]] + 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.5sAKCZKi4u +++ mktemp ++ local LAST_ERR=/tmp/tmp.NPEVixjDEV ++ 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.5sAKCZKi4u ++ cat /tmp/tmp.NPEVixjDEV ++ rm /tmp/tmp.5sAKCZKi4u /tmp/tmp.NPEVixjDEV ++ return 0 + client_pod=pxc-client-7c58656fdc-nbcdt + wait_pod pxc-client-7c58656fdc-nbcdt + local pod=pxc-client-7c58656fdc-nbcdt + local max_retry=480 + local ns= ++ echo pxc-client-7c58656fdc-nbcdt ++ egrep '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container= + set +o xtrace pod/pxc-client-7c58656fdc-nbcdt condition met pxc-client-7c58656fdc-nbcdt.Ok + set +o xtrace + '[' '!' -s /tmp/tmp.sqKUwUqNIA/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1774/e2e-tests/upgrade-proxysql/compare/select-1.sql /tmp/tmp.sqKUwUqNIA/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-1774/e2e-tests/upgrade-proxysql/compare/select-1.sql + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.0 ]] + 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.xeIbX6qJRC +++ mktemp ++ local LAST_ERR=/tmp/tmp.WiUsX8nuPS ++ 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.xeIbX6qJRC ++ cat /tmp/tmp.WiUsX8nuPS ++ rm /tmp/tmp.xeIbX6qJRC /tmp/tmp.WiUsX8nuPS ++ return 0 + client_pod=pxc-client-7c58656fdc-nbcdt + wait_pod pxc-client-7c58656fdc-nbcdt + local pod=pxc-client-7c58656fdc-nbcdt + local max_retry=480 + local ns= ++ echo pxc-client-7c58656fdc-nbcdt ++ egrep '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container= + set +o xtrace pod/pxc-client-7c58656fdc-nbcdt condition met pxc-client-7c58656fdc-nbcdt.Ok + set +o xtrace + '[' '!' -s /tmp/tmp.sqKUwUqNIA/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1774/e2e-tests/upgrade-proxysql/compare/select-1.sql /tmp/tmp.sqKUwUqNIA/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.FdKonNOpLv +++ mktemp ++ local LAST_ERR=/tmp/tmp.LRYzrJelN9 ++ 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.FdKonNOpLv ++ cat /tmp/tmp.LRYzrJelN9 Unable to use a TTY - input is not a terminal or the right kind of file ++ rm /tmp/tmp.FdKonNOpLv /tmp/tmp.LRYzrJelN9 ++ return 0 + '[' '' ']' + compare_generation 1 proxysql upgrade-proxysql + local generation=1 + local proxy=proxysql + local cluster=upgrade-proxysql + local current_generation + [[ proxysql == \h\a\p\r\o\x\y ]] + containers=(pxc proxysql) + for container in '"${containers[@]}"' + check_generation 1 pxc upgrade-proxysql + local generation=1 + local container=pxc + local cluster=upgrade-proxysql + local current_generation ++ kubectl_bin get statefulset upgrade-proxysql-pxc -o 'jsonpath={.metadata.generation}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.5xu6Ufg7uU +++ mktemp ++ local LAST_ERR=/tmp/tmp.mkAWLwDMp0 ++ 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.5xu6Ufg7uU ++ cat /tmp/tmp.mkAWLwDMp0 ++ rm /tmp/tmp.5xu6Ufg7uU /tmp/tmp.mkAWLwDMp0 ++ return 0 + current_generation=1 + [[ 1 != \1 ]] + for container in '"${containers[@]}"' + check_generation 1 proxysql upgrade-proxysql + local generation=1 + local container=proxysql + local cluster=upgrade-proxysql + local current_generation ++ kubectl_bin get statefulset upgrade-proxysql-proxysql -o 'jsonpath={.metadata.generation}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.8Prgp54Z6j +++ mktemp ++ local LAST_ERR=/tmp/tmp.r4RjfvVexu ++ 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.8Prgp54Z6j ++ cat /tmp/tmp.r4RjfvVexu ++ rm /tmp/tmp.8Prgp54Z6j /tmp/tmp.r4RjfvVexu ++ 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-1774/deploy/crd.yaml ++ mktemp + local LAST_OUT=/tmp/tmp.9BSGboiHu0 ++ mktemp + local LAST_ERR=/tmp/tmp.c8ziaa2bC5 + 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-1774/deploy/crd.yaml + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.9BSGboiHu0 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.c8ziaa2bC5 + rm /tmp/tmp.9BSGboiHu0 /tmp/tmp.c8ziaa2bC5 + 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-1774/deploy/cw-rbac.yaml + sed -e 's^namespace: .*^namespace: pxc-operator^' + kubectl_bin apply -f - ++ mktemp + local LAST_OUT=/tmp/tmp.4yfaLVxlwp ++ mktemp + local LAST_ERR=/tmp/tmp.ERdrCflta7 + 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.4yfaLVxlwp 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.ERdrCflta7 + rm /tmp/tmp.4yfaLVxlwp /tmp/tmp.ERdrCflta7 + 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-1774-70b9684b"}]}}}}' -n pxc-operator ++ mktemp + local LAST_OUT=/tmp/tmp.a56VmqtVBG ++ mktemp + local LAST_ERR=/tmp/tmp.lmhjWljcRk + 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-1774-70b9684b"}]}}}}' -n pxc-operator + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.a56VmqtVBG deployment.apps/percona-xtradb-cluster-operator patched + cat /tmp/tmp.lmhjWljcRk + rm /tmp/tmp.a56VmqtVBG /tmp/tmp.lmhjWljcRk + return 0 + kubectl_bin rollout status deployment/percona-xtradb-cluster-operator -n pxc-operator ++ mktemp + local LAST_OUT=/tmp/tmp.XR3BeMCQkx ++ mktemp + local LAST_ERR=/tmp/tmp.ecVGaRdCMl + 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.XR3BeMCQkx 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.ecVGaRdCMl + rm /tmp/tmp.XR3BeMCQkx /tmp/tmp.ecVGaRdCMl + 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.Pk35KRT2d8 +++ mktemp ++ local LAST_ERR=/tmp/tmp.2iYAsPjPmz ++ 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.Pk35KRT2d8 ++ cat /tmp/tmp.2iYAsPjPmz ++ rm /tmp/tmp.Pk35KRT2d8 /tmp/tmp.2iYAsPjPmz ++ return 0 + [[ 1 -eq 1 ]] + '[' -n pxc-operator ']' ++ kubectl_bin config current-context +++ mktemp ++ local LAST_OUT=/tmp/tmp.zymO2CUFUE +++ mktemp ++ local LAST_ERR=/tmp/tmp.QZF6WnWuns ++ 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.zymO2CUFUE ++ cat /tmp/tmp.QZF6WnWuns ++ rm /tmp/tmp.zymO2CUFUE /tmp/tmp.QZF6WnWuns ++ return 0 + kubectl_bin config set-context gke_cloud-dev-112233_us-central1-a_jen-pxc-1774-70b9684b-2-cluster6 --namespace=pxc-operator ++ mktemp + local LAST_OUT=/tmp/tmp.Kmg3L10b2y ++ mktemp + local LAST_ERR=/tmp/tmp.VPSzU6urPJ + 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-1774-70b9684b-2-cluster6 --namespace=pxc-operator + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.Kmg3L10b2y Context "gke_cloud-dev-112233_us-central1-a_jen-pxc-1774-70b9684b-2-cluster6" modified. + cat /tmp/tmp.VPSzU6urPJ + rm /tmp/tmp.Kmg3L10b2y /tmp/tmp.VPSzU6urPJ + 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' ++ awk '{print $1}' +++ mktemp ++ grep perconalab/percona-xtradb-cluster-operator:PR-1774-70b9684b ++ local LAST_OUT=/tmp/tmp.u0hLvbbtVL +++ mktemp ++ local LAST_ERR=/tmp/tmp.nlaY15madH ++ 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.u0hLvbbtVL ++ cat /tmp/tmp.nlaY15madH ++ rm /tmp/tmp.u0hLvbbtVL /tmp/tmp.nlaY15madH ++ return 0 + wait_pod percona-xtradb-cluster-operator-6b944784cc-h57rc + local pod=percona-xtradb-cluster-operator-6b944784cc-h57rc + local max_retry=480 + local ns= ++ echo percona-xtradb-cluster-operator-6b944784cc-h57rc ++ egrep '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container= + set +o xtrace pod/percona-xtradb-cluster-operator-6b944784cc-h57rc condition met percona-xtradb-cluster-operator-6b944784cc-h57rc.Ok ++ kubectl_bin config current-context +++ mktemp ++ local LAST_OUT=/tmp/tmp.cw2CjCMtnx +++ mktemp ++ local LAST_ERR=/tmp/tmp.n0nhLDJuNw ++ 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.cw2CjCMtnx ++ cat /tmp/tmp.n0nhLDJuNw ++ rm /tmp/tmp.cw2CjCMtnx /tmp/tmp.n0nhLDJuNw ++ return 0 + kubectl_bin config set-context gke_cloud-dev-112233_us-central1-a_jen-pxc-1774-70b9684b-2-cluster6 --namespace=upgrade-proxysql-22248 ++ mktemp + local LAST_OUT=/tmp/tmp.FKxBmMjblL ++ mktemp + local LAST_ERR=/tmp/tmp.wORGHz1WiO + 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-1774-70b9684b-2-cluster6 --namespace=upgrade-proxysql-22248 + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.FKxBmMjblL Context "gke_cloud-dev-112233_us-central1-a_jen-pxc-1774-70b9684b-2-cluster6" modified. + cat /tmp/tmp.wORGHz1WiO + rm /tmp/tmp.FKxBmMjblL /tmp/tmp.wORGHz1WiO + 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.UUIZQnOyAx ++++ mktemp +++ local LAST_ERR=/tmp/tmp.mPKGw9gm5n +++ 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.UUIZQnOyAx +++ cat /tmp/tmp.mPKGw9gm5n +++ rm /tmp/tmp.UUIZQnOyAx /tmp/tmp.mPKGw9gm5n +++ return 0 ++ [[ false == \t\r\u\e ]] +++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.enabled}' ++++ mktemp +++ local LAST_OUT=/tmp/tmp.qDpux7wXqW ++++ mktemp +++ local LAST_ERR=/tmp/tmp.cmqsEKBWiZ +++ 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.qDpux7wXqW +++ cat /tmp/tmp.cmqsEKBWiZ +++ rm /tmp/tmp.qDpux7wXqW /tmp/tmp.cmqsEKBWiZ +++ return 0 ++ [[ true == \t\r\u\e ]] ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.size}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.CmibgBr4Id +++ mktemp ++ local LAST_ERR=/tmp/tmp.hGpmIvtrbA ++ 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.CmibgBr4Id ++ cat /tmp/tmp.hGpmIvtrbA ++ rm /tmp/tmp.CmibgBr4Id /tmp/tmp.hGpmIvtrbA ++ 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.3BBLCNdcIR +++ mktemp ++ local LAST_ERR=/tmp/tmp.gnOHVkjn8L ++ 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.3BBLCNdcIR ++ cat /tmp/tmp.gnOHVkjn8L ++ rm /tmp/tmp.3BBLCNdcIR /tmp/tmp.gnOHVkjn8L ++ 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.C87zefbRHv +++ mktemp ++ local LAST_ERR=/tmp/tmp.Ae8V2YHeEb ++ 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.C87zefbRHv ++ cat /tmp/tmp.Ae8V2YHeEb ++ rm /tmp/tmp.C87zefbRHv /tmp/tmp.Ae8V2YHeEb ++ 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.3CGj4ODs2z ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.IkQ5gd9wxF +++++ 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.3CGj4ODs2z +++++ cat /tmp/tmp.IkQ5gd9wxF +++++ rm /tmp/tmp.3CGj4ODs2z /tmp/tmp.IkQ5gd9wxF +++++ return 0 ++++ [[ false == \t\r\u\e ]] +++++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.Bfr7SCdetl ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.0MT8IPwLUW +++++ 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.Bfr7SCdetl +++++ cat /tmp/tmp.0MT8IPwLUW +++++ rm /tmp/tmp.Bfr7SCdetl /tmp/tmp.0MT8IPwLUW +++++ 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.tZEqOKCun1 +++ mktemp ++ local LAST_ERR=/tmp/tmp.XT7Jx6vgiF ++ 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.tZEqOKCun1 ++ cat /tmp/tmp.XT7Jx6vgiF ++ rm /tmp/tmp.tZEqOKCun1 /tmp/tmp.XT7Jx6vgiF ++ 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 ++ egrep '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + 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-1774/e2e-tests/upgrade-proxysql/compare/select-1.sql + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.0 ]] + 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.2JvDwKzkiB +++ mktemp ++ local LAST_ERR=/tmp/tmp.k0jzyjy0R4 ++ 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.2JvDwKzkiB ++ cat /tmp/tmp.k0jzyjy0R4 ++ rm /tmp/tmp.2JvDwKzkiB /tmp/tmp.k0jzyjy0R4 ++ return 0 + client_pod=pxc-client-7c58656fdc-nbcdt + wait_pod pxc-client-7c58656fdc-nbcdt + local pod=pxc-client-7c58656fdc-nbcdt + local max_retry=480 + local ns= ++ echo pxc-client-7c58656fdc-nbcdt ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-7c58656fdc-nbcdt condition met pxc-client-7c58656fdc-nbcdt.Ok + set +o xtrace + '[' '!' -s /tmp/tmp.sqKUwUqNIA/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1774/e2e-tests/upgrade-proxysql/compare/select-1.sql /tmp/tmp.sqKUwUqNIA/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-1774/e2e-tests/upgrade-proxysql/compare/select-1.sql + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.0 ]] + 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.N2hseqTy0y +++ mktemp ++ local LAST_ERR=/tmp/tmp.Twk7y89L6k ++ 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.N2hseqTy0y ++ cat /tmp/tmp.Twk7y89L6k ++ rm /tmp/tmp.N2hseqTy0y /tmp/tmp.Twk7y89L6k ++ return 0 + client_pod=pxc-client-7c58656fdc-nbcdt + wait_pod pxc-client-7c58656fdc-nbcdt + local pod=pxc-client-7c58656fdc-nbcdt + local max_retry=480 + local ns= ++ echo pxc-client-7c58656fdc-nbcdt ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-7c58656fdc-nbcdt condition met pxc-client-7c58656fdc-nbcdt.Ok + set +o xtrace + '[' '!' -s /tmp/tmp.sqKUwUqNIA/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1774/e2e-tests/upgrade-proxysql/compare/select-1.sql /tmp/tmp.sqKUwUqNIA/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-1774/e2e-tests/upgrade-proxysql/compare/select-1.sql + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.0 ]] + 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.VlQSFuJ8eH +++ mktemp ++ local LAST_ERR=/tmp/tmp.Nw7agPEcPe ++ 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.VlQSFuJ8eH ++ cat /tmp/tmp.Nw7agPEcPe ++ rm /tmp/tmp.VlQSFuJ8eH /tmp/tmp.Nw7agPEcPe ++ return 0 + client_pod=pxc-client-7c58656fdc-nbcdt + wait_pod pxc-client-7c58656fdc-nbcdt + local pod=pxc-client-7c58656fdc-nbcdt + local max_retry=480 + local ns= ++ echo pxc-client-7c58656fdc-nbcdt ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-7c58656fdc-nbcdt condition met pxc-client-7c58656fdc-nbcdt.Ok + set +o xtrace + '[' '!' -s /tmp/tmp.sqKUwUqNIA/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1774/e2e-tests/upgrade-proxysql/compare/select-1.sql /tmp/tmp.sqKUwUqNIA/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.RPLhkPoi4N +++ mktemp ++ local LAST_ERR=/tmp/tmp.VDHv2ZtgCk ++ 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.RPLhkPoi4N ++ cat /tmp/tmp.VDHv2ZtgCk ++ rm /tmp/tmp.RPLhkPoi4N /tmp/tmp.VDHv2ZtgCk ++ return 0 + [[ perconalab/percona-xtradb-cluster-operator:PR-1774-70b9684b == perconalab/percona-xtradb-cluster-operator:PR-1774-70b9684b ]] ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.image}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.bn4C7u0zhP +++ mktemp ++ local LAST_ERR=/tmp/tmp.Wsgb6aArgG ++ 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.bn4C7u0zhP ++ cat /tmp/tmp.Wsgb6aArgG ++ rm /tmp/tmp.bn4C7u0zhP /tmp/tmp.Wsgb6aArgG ++ 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.Nura48sgI0 +++ mktemp ++ local LAST_ERR=/tmp/tmp.3e5uVO9XL5 ++ 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.Nura48sgI0 ++ cat /tmp/tmp.3e5uVO9XL5 ++ rm /tmp/tmp.Nura48sgI0 /tmp/tmp.3e5uVO9XL5 ++ 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.dwmqy6nl9V +++ mktemp ++ local LAST_ERR=/tmp/tmp.VYqQcoYcpp ++ 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.dwmqy6nl9V ++ cat /tmp/tmp.VYqQcoYcpp ++ rm /tmp/tmp.dwmqy6nl9V /tmp/tmp.VYqQcoYcpp ++ return 0 + [[ percona/percona-xtradb-cluster-operator:1.14.0-pxc5.7-backup-pxb2.4.29 == percona/percona-xtradb-cluster-operator:1.14.0-pxc5.7-backup-pxb2.4.29 ]] ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.pmm.image}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.f7Vk6Z3mJw +++ mktemp ++ local LAST_ERR=/tmp/tmp.jfxkO2olgf ++ 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.f7Vk6Z3mJw ++ cat /tmp/tmp.jfxkO2olgf ++ rm /tmp/tmp.f7Vk6Z3mJw /tmp/tmp.jfxkO2olgf ++ 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.PYEblWZ6jO +++ mktemp ++ local LAST_ERR=/tmp/tmp.hfiShyrSv0 ++ 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.PYEblWZ6jO ++ cat /tmp/tmp.hfiShyrSv0 ++ rm /tmp/tmp.PYEblWZ6jO /tmp/tmp.hfiShyrSv0 ++ return 0 + [[ percona/percona-xtradb-cluster:5.7.44-31.65 == percona/percona-xtradb-cluster:5.7.44-31.65 ]] + : Operator image has been updated correctly + compare_generation 1 proxysql upgrade-proxysql + local generation=1 + local proxy=proxysql + local cluster=upgrade-proxysql + local current_generation + [[ proxysql == \h\a\p\r\o\x\y ]] + containers=(pxc proxysql) + for container in '"${containers[@]}"' + check_generation 1 pxc upgrade-proxysql + local generation=1 + local container=pxc + local cluster=upgrade-proxysql + local current_generation ++ kubectl_bin get statefulset upgrade-proxysql-pxc -o 'jsonpath={.metadata.generation}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.E0JwZZaDlz +++ mktemp ++ local LAST_ERR=/tmp/tmp.4XsKQoNoyX ++ 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.E0JwZZaDlz ++ cat /tmp/tmp.4XsKQoNoyX ++ rm /tmp/tmp.E0JwZZaDlz /tmp/tmp.4XsKQoNoyX ++ return 0 + current_generation=1 + [[ 1 != \1 ]] + for container in '"${containers[@]}"' + check_generation 1 proxysql upgrade-proxysql + local generation=1 + local container=proxysql + local cluster=upgrade-proxysql + local current_generation ++ kubectl_bin get statefulset upgrade-proxysql-proxysql -o 'jsonpath={.metadata.generation}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.QT2fC6CKEp +++ mktemp ++ local LAST_ERR=/tmp/tmp.oplOeJjrjC ++ 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.QT2fC6CKEp ++ cat /tmp/tmp.oplOeJjrjC ++ rm /tmp/tmp.QT2fC6CKEp /tmp/tmp.oplOeJjrjC ++ 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-pxc5.7" }, "pmm": { "image": "perconalab/pmm-client:dev-latest" }, "haproxy": { "image": "perconalab/percona-xtradb-cluster-operator:main-haproxy" }, "proxysql": { "image": "perconalab/percona-xtradb-cluster-operator:main-proxysql" }, "backup": { "image": "perconalab/percona-xtradb-cluster-operator:main-pxc5.7-backup" } }}' ++ mktemp + local LAST_OUT=/tmp/tmp.OwhZwCrKkP ++ mktemp + local LAST_ERR=/tmp/tmp.QDF4mUzMq9 + 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-pxc5.7" }, "pmm": { "image": "perconalab/pmm-client:dev-latest" }, "haproxy": { "image": "perconalab/percona-xtradb-cluster-operator:main-haproxy" }, "proxysql": { "image": "perconalab/percona-xtradb-cluster-operator:main-proxysql" }, "backup": { "image": "perconalab/percona-xtradb-cluster-operator:main-pxc5.7-backup" } }}' + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.OwhZwCrKkP perconaxtradbcluster.pxc.percona.com/upgrade-proxysql patched + cat /tmp/tmp.QDF4mUzMq9 + rm /tmp/tmp.OwhZwCrKkP /tmp/tmp.QDF4mUzMq9 + 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.hrIYMQhGUp ++++ mktemp +++ local LAST_ERR=/tmp/tmp.m4uW2wEYxy +++ 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.hrIYMQhGUp +++ cat /tmp/tmp.m4uW2wEYxy +++ rm /tmp/tmp.hrIYMQhGUp /tmp/tmp.m4uW2wEYxy +++ return 0 ++ [[ false == \t\r\u\e ]] +++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.enabled}' ++++ mktemp +++ local LAST_OUT=/tmp/tmp.EOPMvmWFHP ++++ mktemp +++ local LAST_ERR=/tmp/tmp.1Z4pbf4RM8 +++ 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.EOPMvmWFHP +++ cat /tmp/tmp.1Z4pbf4RM8 +++ rm /tmp/tmp.EOPMvmWFHP /tmp/tmp.1Z4pbf4RM8 +++ return 0 ++ [[ true == \t\r\u\e ]] ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.size}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.xI4ErofVuc +++ mktemp ++ local LAST_ERR=/tmp/tmp.0u2eJtZz1n ++ 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.xI4ErofVuc ++ cat /tmp/tmp.0u2eJtZz1n ++ rm /tmp/tmp.xI4ErofVuc /tmp/tmp.0u2eJtZz1n ++ 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.OPKw2oIowR +++ mktemp ++ local LAST_ERR=/tmp/tmp.xPGup2nOtS ++ 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.OPKw2oIowR ++ cat /tmp/tmp.xPGup2nOtS ++ rm /tmp/tmp.OPKw2oIowR /tmp/tmp.xPGup2nOtS ++ 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.X86HZaCWRt +++ mktemp ++ local LAST_ERR=/tmp/tmp.WAA10S7S3C ++ 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.X86HZaCWRt ++ cat /tmp/tmp.WAA10S7S3C ++ rm /tmp/tmp.X86HZaCWRt /tmp/tmp.WAA10S7S3C ++ 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.4QYiGZacSy +++ mktemp ++ local LAST_ERR=/tmp/tmp.yuCKAbRERo ++ 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.4QYiGZacSy ++ cat /tmp/tmp.yuCKAbRERo ++ rm /tmp/tmp.4QYiGZacSy /tmp/tmp.yuCKAbRERo ++ 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.pbu32Dx9Ba +++ mktemp ++ local LAST_ERR=/tmp/tmp.4DECQNZdrm ++ 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.pbu32Dx9Ba ++ cat /tmp/tmp.4DECQNZdrm ++ rm /tmp/tmp.pbu32Dx9Ba /tmp/tmp.4DECQNZdrm ++ 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.Z88TOalmNC +++ mktemp ++ local LAST_ERR=/tmp/tmp.t7TAGHQAZj ++ 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.Z88TOalmNC ++ cat /tmp/tmp.t7TAGHQAZj ++ rm /tmp/tmp.Z88TOalmNC /tmp/tmp.t7TAGHQAZj ++ 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.RiejF05JEj +++ mktemp ++ local LAST_ERR=/tmp/tmp.1BDZ8q9X0y ++ 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.RiejF05JEj ++ cat /tmp/tmp.1BDZ8q9X0y ++ rm /tmp/tmp.RiejF05JEj /tmp/tmp.1BDZ8q9X0y ++ 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.GWIFnQXB3o +++ mktemp ++ local LAST_ERR=/tmp/tmp.lL0HlabqwG ++ 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.GWIFnQXB3o ++ cat /tmp/tmp.lL0HlabqwG ++ rm /tmp/tmp.GWIFnQXB3o /tmp/tmp.lL0HlabqwG ++ 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.ZKhSiZehq5 +++ mktemp ++ local LAST_ERR=/tmp/tmp.MKB9EWgeym ++ 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.ZKhSiZehq5 ++ cat /tmp/tmp.MKB9EWgeym ++ rm /tmp/tmp.ZKhSiZehq5 /tmp/tmp.MKB9EWgeym ++ 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.webCqCVAOH +++ mktemp ++ local LAST_ERR=/tmp/tmp.LJ2X6vpteR ++ 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.webCqCVAOH ++ cat /tmp/tmp.LJ2X6vpteR ++ rm /tmp/tmp.webCqCVAOH /tmp/tmp.LJ2X6vpteR ++ 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.FEvXNb7aof +++ mktemp ++ local LAST_ERR=/tmp/tmp.ZsAer2Ns6T ++ 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.FEvXNb7aof ++ cat /tmp/tmp.ZsAer2Ns6T ++ rm /tmp/tmp.FEvXNb7aof /tmp/tmp.ZsAer2Ns6T ++ 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.bUSRQB4pbD +++ mktemp ++ local LAST_ERR=/tmp/tmp.MZcNS6kRhp ++ 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.bUSRQB4pbD ++ cat /tmp/tmp.MZcNS6kRhp ++ rm /tmp/tmp.bUSRQB4pbD /tmp/tmp.MZcNS6kRhp ++ 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.NR9pvWeaMm +++ mktemp ++ local LAST_ERR=/tmp/tmp.2A0OdZ4LPD ++ 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.NR9pvWeaMm ++ cat /tmp/tmp.2A0OdZ4LPD ++ rm /tmp/tmp.NR9pvWeaMm /tmp/tmp.2A0OdZ4LPD ++ 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.0UyGvFOlXF +++ mktemp ++ local LAST_ERR=/tmp/tmp.yigdjJwclA ++ 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.0UyGvFOlXF ++ cat /tmp/tmp.yigdjJwclA ++ rm /tmp/tmp.0UyGvFOlXF /tmp/tmp.yigdjJwclA ++ 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.nBRKhUfaYE +++ mktemp ++ local LAST_ERR=/tmp/tmp.toXScQMZsU ++ 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.nBRKhUfaYE ++ cat /tmp/tmp.toXScQMZsU ++ rm /tmp/tmp.nBRKhUfaYE /tmp/tmp.toXScQMZsU ++ 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.BHiCU6LnuK +++ mktemp ++ local LAST_ERR=/tmp/tmp.cq74pQkd2N ++ 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.BHiCU6LnuK ++ cat /tmp/tmp.cq74pQkd2N ++ rm /tmp/tmp.BHiCU6LnuK /tmp/tmp.cq74pQkd2N ++ 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.41swWyKYbb +++ mktemp ++ local LAST_ERR=/tmp/tmp.BU6tWLkja0 ++ 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.41swWyKYbb ++ cat /tmp/tmp.BU6tWLkja0 ++ rm /tmp/tmp.41swWyKYbb /tmp/tmp.BU6tWLkja0 ++ 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.0WFO2IsuDo +++ mktemp ++ local LAST_ERR=/tmp/tmp.EVHP2Gm53q ++ 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.0WFO2IsuDo ++ cat /tmp/tmp.EVHP2Gm53q ++ rm /tmp/tmp.0WFO2IsuDo /tmp/tmp.EVHP2Gm53q ++ 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.B53wTaXvCi +++ mktemp ++ local LAST_ERR=/tmp/tmp.rAwhKAa7Sl ++ 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.B53wTaXvCi ++ cat /tmp/tmp.rAwhKAa7Sl ++ rm /tmp/tmp.B53wTaXvCi /tmp/tmp.rAwhKAa7Sl ++ 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.sgIgD9J9BQ ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.7cC345PQqH +++++ 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.sgIgD9J9BQ +++++ cat /tmp/tmp.7cC345PQqH +++++ rm /tmp/tmp.sgIgD9J9BQ /tmp/tmp.7cC345PQqH +++++ return 0 ++++ [[ false == \t\r\u\e ]] +++++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.enabled}' ++++++ mktemp +++++ local LAST_OUT=/tmp/tmp.iULUTEstWk ++++++ mktemp +++++ local LAST_ERR=/tmp/tmp.h8vkAsYroq +++++ 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.iULUTEstWk +++++ cat /tmp/tmp.h8vkAsYroq +++++ rm /tmp/tmp.iULUTEstWk /tmp/tmp.h8vkAsYroq +++++ 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.UEdkf0MxBo +++ mktemp ++ local LAST_ERR=/tmp/tmp.5AGCL9Axsb ++ 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.UEdkf0MxBo ++ cat /tmp/tmp.5AGCL9Axsb ++ rm /tmp/tmp.UEdkf0MxBo /tmp/tmp.5AGCL9Axsb ++ 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 ++ egrep '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + 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-1774/e2e-tests/upgrade-proxysql/compare/select-1.sql + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.0 ]] + 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.cixMNTTJiu +++ mktemp ++ local LAST_ERR=/tmp/tmp.U3dzpcygYR ++ 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.cixMNTTJiu ++ cat /tmp/tmp.U3dzpcygYR ++ rm /tmp/tmp.cixMNTTJiu /tmp/tmp.U3dzpcygYR ++ return 0 + client_pod=pxc-client-7c58656fdc-bbvst + wait_pod pxc-client-7c58656fdc-bbvst + local pod=pxc-client-7c58656fdc-bbvst + local max_retry=480 + local ns= ++ echo pxc-client-7c58656fdc-bbvst ++ egrep '^(pxc|proxysql)$' ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' + local container= + set +o xtrace pod/pxc-client-7c58656fdc-bbvst condition met pxc-client-7c58656fdc-bbvst.Ok + set +o xtrace + '[' '!' -s /tmp/tmp.sqKUwUqNIA/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1774/e2e-tests/upgrade-proxysql/compare/select-1.sql /tmp/tmp.sqKUwUqNIA/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-1774/e2e-tests/upgrade-proxysql/compare/select-1.sql + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.0 ]] + 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.eLffR7JV3W +++ mktemp ++ local LAST_ERR=/tmp/tmp.Ad4EBzXrVH ++ 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.eLffR7JV3W ++ cat /tmp/tmp.Ad4EBzXrVH ++ rm /tmp/tmp.eLffR7JV3W /tmp/tmp.Ad4EBzXrVH ++ return 0 + client_pod=pxc-client-7c58656fdc-bbvst + wait_pod pxc-client-7c58656fdc-bbvst + local pod=pxc-client-7c58656fdc-bbvst + local max_retry=480 + local ns= ++ echo pxc-client-7c58656fdc-bbvst ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-7c58656fdc-bbvst condition met pxc-client-7c58656fdc-bbvst.Ok + set +o xtrace + '[' '!' -s /tmp/tmp.sqKUwUqNIA/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1774/e2e-tests/upgrade-proxysql/compare/select-1.sql /tmp/tmp.sqKUwUqNIA/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-1774/e2e-tests/upgrade-proxysql/compare/select-1.sql + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.0 ]] + 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.TcrTfkmr4W +++ mktemp ++ local LAST_ERR=/tmp/tmp.ICkbA27DSO ++ 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.TcrTfkmr4W ++ cat /tmp/tmp.ICkbA27DSO ++ rm /tmp/tmp.TcrTfkmr4W /tmp/tmp.ICkbA27DSO ++ return 0 + client_pod=pxc-client-7c58656fdc-bbvst + wait_pod pxc-client-7c58656fdc-bbvst + local pod=pxc-client-7c58656fdc-bbvst + local max_retry=480 + local ns= ++ echo pxc-client-7c58656fdc-bbvst ++ /usr/bin/sed -E 's/.*-(pxc|proxysql)-[0-9]/\1/' ++ egrep '^(pxc|proxysql)$' + local container= + set +o xtrace pod/pxc-client-7c58656fdc-bbvst condition met pxc-client-7c58656fdc-bbvst.Ok + set +o xtrace + '[' '!' -s /tmp/tmp.sqKUwUqNIA/select-1.sql ']' + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1774/e2e-tests/upgrade-proxysql/compare/select-1.sql /tmp/tmp.sqKUwUqNIA/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.KuuraSMkWh +++ mktemp ++ local LAST_ERR=/tmp/tmp.jEdUqx1bG0 ++ 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.KuuraSMkWh ++ cat /tmp/tmp.jEdUqx1bG0 ++ rm /tmp/tmp.KuuraSMkWh /tmp/tmp.jEdUqx1bG0 ++ return 0 + [[ perconalab/percona-xtradb-cluster-operator:PR-1774-70b9684b == perconalab/percona-xtradb-cluster-operator:PR-1774-70b9684b ]] ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.proxysql.image}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.aXZwSF7bEs +++ mktemp ++ local LAST_ERR=/tmp/tmp.GQgU2m5zvq ++ 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.aXZwSF7bEs ++ cat /tmp/tmp.GQgU2m5zvq ++ rm /tmp/tmp.aXZwSF7bEs /tmp/tmp.GQgU2m5zvq ++ 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.r4NcKmIBrV +++ mktemp ++ local LAST_ERR=/tmp/tmp.uCwguLqpuk ++ 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.r4NcKmIBrV ++ cat /tmp/tmp.uCwguLqpuk ++ rm /tmp/tmp.r4NcKmIBrV /tmp/tmp.uCwguLqpuk ++ 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.XqN3kh4ZjC +++ mktemp ++ local LAST_ERR=/tmp/tmp.UCX2LJUNL8 ++ 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.XqN3kh4ZjC ++ cat /tmp/tmp.UCX2LJUNL8 ++ rm /tmp/tmp.XqN3kh4ZjC /tmp/tmp.UCX2LJUNL8 ++ return 0 + [[ perconalab/percona-xtradb-cluster-operator:main-pxc5.7-backup == perconalab/percona-xtradb-cluster-operator:main-pxc5.7-backup ]] ++ kubectl_bin get pxc upgrade-proxysql -o 'jsonpath={.spec.pmm.image}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.J5if9MH0zK +++ mktemp ++ local LAST_ERR=/tmp/tmp.18SLFCX8B7 ++ 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.J5if9MH0zK ++ cat /tmp/tmp.18SLFCX8B7 ++ rm /tmp/tmp.J5if9MH0zK /tmp/tmp.18SLFCX8B7 ++ 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.K79TZZLk3Z +++ mktemp ++ local LAST_ERR=/tmp/tmp.XUXZDpev7T ++ 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.K79TZZLk3Z ++ cat /tmp/tmp.XUXZDpev7T ++ rm /tmp/tmp.K79TZZLk3Z /tmp/tmp.XUXZDpev7T ++ return 0 + [[ perconalab/percona-xtradb-cluster-operator:main-pxc5.7 == perconalab/percona-xtradb-cluster-operator:main-pxc5.7 ]] + : Cluster images have been updated correctly + compare_generation 2 proxysql upgrade-proxysql + local generation=2 + local proxy=proxysql + local cluster=upgrade-proxysql + local current_generation + [[ proxysql == \h\a\p\r\o\x\y ]] + containers=(pxc proxysql) + for container in '"${containers[@]}"' + check_generation 2 pxc upgrade-proxysql + local generation=2 + local container=pxc + local cluster=upgrade-proxysql + local current_generation ++ kubectl_bin get statefulset upgrade-proxysql-pxc -o 'jsonpath={.metadata.generation}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.bXQJ5U80ey +++ mktemp ++ local LAST_ERR=/tmp/tmp.AZ872xpJat ++ 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.bXQJ5U80ey ++ cat /tmp/tmp.AZ872xpJat ++ rm /tmp/tmp.bXQJ5U80ey /tmp/tmp.AZ872xpJat ++ return 0 + current_generation=2 + [[ 2 != \2 ]] + for container in '"${containers[@]}"' + check_generation 2 proxysql upgrade-proxysql + local generation=2 + local container=proxysql + local cluster=upgrade-proxysql + local current_generation ++ kubectl_bin get statefulset upgrade-proxysql-proxysql -o 'jsonpath={.metadata.generation}' +++ mktemp ++ local LAST_OUT=/tmp/tmp.drhInCSYvO +++ mktemp ++ local LAST_ERR=/tmp/tmp.mfkvpgv2ks ++ 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.drhInCSYvO ++ cat /tmp/tmp.mfkvpgv2ks ++ rm /tmp/tmp.drhInCSYvO /tmp/tmp.mfkvpgv2ks ++ 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-1774/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-pxc.yml + local new_result=/tmp/tmp.sqKUwUqNIA/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-1774/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-pxc-eks.yml ']' + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.0 ]] + 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.27 >= 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.27 >= 1.27' ++ bc -l + '[' 1 -eq 1 ']' + return 0 + '[' -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1774/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-pxc-k127.yml ']' + expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-1774/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-pxc-k127.yml + '[' '!' -z '' -a -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1774/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-pxc-k127-oc.yml ']' + '[' 0 = 1 -a -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1774/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-pxc-k127-eks.yml ']' + kubectl_bin get -o yaml statefulset/upgrade-proxysql-pxc + 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.labels."batch.kubernetes.io/job-name") | del(.metadata.annotations."cloud.google.com/neg") | del(.metadata.annotations."k8s.v1.cni.cncf.io*") | del(.metadata.annotations."k8s.ovn.org/pod-networks") | del(.spec.template.metadata.annotations."last-applied-secret") | del(.spec.template.metadata.labels."batch.kubernetes.io/job-name") | del(.. | 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-22248", "namespace") | (.. | select(tag == "!!str")) |= sub("kube-api-access-.*", "kube-api-access") | del(.. | select(has("annotations")).annotations | select(length==0)) | ++ mktemp del(.. | select(.[] == "percona-xtradb-cluster-operator-workload-token*"))' - + local LAST_OUT=/tmp/tmp.hVh1KQ153Z ++ mktemp + local LAST_ERR=/tmp/tmp.4Ctg5h0Qds + 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.hVh1KQ153Z + cat /tmp/tmp.4Ctg5h0Qds + rm /tmp/tmp.hVh1KQ153Z /tmp/tmp.4Ctg5h0Qds + return 0 + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1774/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-pxc-k127.yml /tmp/tmp.sqKUwUqNIA/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-1774/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-proxysql.yml + local new_result=/tmp/tmp.sqKUwUqNIA/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-1774/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-proxysql-eks.yml ']' + [[ percona/percona-xtradb-cluster:5.7.44-31.65 =~ 8\.0 ]] + 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.27 >= 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.27 >= 1.27' ++ bc -l + '[' 1 -eq 1 ']' + return 0 + '[' -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1774/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-proxysql-k127.yml ']' + expected_result=/mnt/jenkins/workspace/cloud-pxc-operator_PR-1774/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-proxysql-k127.yml + '[' '!' -z '' -a -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1774/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-proxysql-k127-oc.yml ']' + '[' 0 = 1 -a -f /mnt/jenkins/workspace/cloud-pxc-operator_PR-1774/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-proxysql-k127-eks.yml ']' + kubectl_bin get -o yaml statefulset/upgrade-proxysql-proxysql ++ mktemp + yq eval ' del(.metadata.managedFields) | del(.. | select(has("creationTimestamp")).creationTimestamp) | del(.. | select(has("namespace")).namespace) | del(.. | select(has("uid")).uid) | del(.metadata.resourceVersion) | del(.spec.template.spec.containers[].env[] | select(.name == "CLUSTER_HASH")) | del(.spec.template.spec.containers[].env[] | select(.name == "S3_BUCKET_PATH")) | del(.spec.template.spec.containers[].env[] | select(.name == "BACKUP_PATH")) | del(.spec.template.spec.containers[].env[] | select(.name == "S3_BUCKET_URL")) | del(.spec.template.spec.containers[].env[] | select(.name == "AZURE_CONTAINER_NAME")) | del(.metadata.selfLink) | del(.metadata.deletionTimestamp) | del(.metadata.annotations."kubernetes.io/psp") | del(.metadata.annotations."batch.kubernetes.io/job-tracking") | del(.metadata.labels."batch.kubernetes.io/job-name") | del(.metadata.annotations."cloud.google.com/neg") | del(.metadata.annotations."k8s.v1.cni.cncf.io*") | del(.metadata.annotations."k8s.ovn.org/pod-networks") | del(.spec.template.metadata.annotations."last-applied-secret") | del(.spec.template.metadata.labels."batch.kubernetes.io/job-name") | del(.. | 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-22248", "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.ukV5RBJYlF ++ mktemp + local LAST_ERR=/tmp/tmp.qIo0aZ1DO6 + 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.ukV5RBJYlF + cat /tmp/tmp.qIo0aZ1DO6 + rm /tmp/tmp.ukV5RBJYlF /tmp/tmp.qIo0aZ1DO6 + return 0 + diff -u /mnt/jenkins/workspace/cloud-pxc-operator_PR-1774/e2e-tests/upgrade-proxysql/compare/statefulset_upgrade-proxysql-proxysql-k127.yml /tmp/tmp.sqKUwUqNIA/statefulset_upgrade-proxysql-proxysql.yml + desc cleanup + set +o xtrace ----------------------------------------------------------------------------------- cleanup ----------------------------------------------------------------------------------- + destroy upgrade-proxysql-22248 + local namespace=upgrade-proxysql-22248 + 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' + tee /tmp/tmp.sqKUwUqNIA/operator.log + sort -u + /usr/bin/sed -r 's/"ts":[0-9.]+//; s^limits-[0-9.]+/^^g' + grep -v 'get backup status: Job.batch' ++ get_operator_pod ++ local label_prefix=app.kubernetes.io/ +++ kubectl get pods --selector=app.kubernetes.io/name=percona-xtradb-cluster-operator -n pxc-operator +++ grep -c percona-xtradb-cluster-operator ++ local check_label=1 ++ [[ 1 -eq 0 ]] ++ kubectl_bin get pods --selector=app.kubernetes.io/name=percona-xtradb-cluster-operator -o 'jsonpath={.items[].metadata.name}' -n pxc-operator +++ mktemp ++ local LAST_OUT=/tmp/tmp.W09C2fhAwf +++ mktemp ++ local LAST_ERR=/tmp/tmp.7kScRaGMUz ++ 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.W09C2fhAwf ++ cat /tmp/tmp.7kScRaGMUz ++ rm /tmp/tmp.W09C2fhAwf /tmp/tmp.7kScRaGMUz ++ return 0 + kubectl_bin logs -n pxc-operator percona-xtradb-cluster-operator-6b944784cc-dmn6b ++ mktemp + local LAST_OUT=/tmp/tmp.ZD6HaOfOsw ++ mktemp + local LAST_ERR=/tmp/tmp.Vr0htedvwp + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl logs -n pxc-operator percona-xtradb-cluster-operator-6b944784cc-dmn6b + exit_status=0 + set -e + '[' 0 '!=' 0 ']' + break + cat /tmp/tmp.ZD6HaOfOsw + cat /tmp/tmp.Vr0htedvwp + rm /tmp/tmp.ZD6HaOfOsw /tmp/tmp.Vr0htedvwp + return 0 2024-08-02T21:30:04.730Z INFO setup Manager starting up {"gitCommit": "70b9684b9628ddfcc3dab7c6787cbf6d29753b3d", "gitBranch": "PR-1774-70b9684b", "buildTime": "2024-08-02T20:45:17Z", "goVersion": "go1.22.5", "os": "linux", "arch": "amd64"} 2024-08-02T21:30:04.730Z INFO setup Runs on {"platform": "kubernetes", "version": "v1.27.16-gke.1008000"} 2024-08-02T21:30:04.731Z INFO setup Registering Components. 2024-08-02T21:30:07.930Z INFO controller-runtime.webhook Registering webhook {"path": "/validate-percona-xtradbcluster"} 2024-08-02T21:30:07.933Z INFO controller-runtime.metrics Starting metrics server 2024-08-02T21:30:07.933Z INFO setup Starting the Cmd. 2024-08-02T21:30:07.933Z INFO starting server {"name": "health probe", "addr": "[::]:8081"} 2024-08-02T21:30:07.934Z INFO controller-runtime.certwatcher Starting certificate watcher 2024-08-02T21:30:07.934Z INFO controller-runtime.certwatcher Updated current TLS certificate 2024-08-02T21:30:07.934Z INFO controller-runtime.metrics Serving metrics server {"bindAddress": ":8080", "secure": false} 2024-08-02T21:30:07.934Z INFO controller-runtime.webhook Serving webhook server {"host": "", "port": 9443} 2024-08-02T21:30:07.934Z INFO controller-runtime.webhook Starting webhook server 2024-08-02T21:30:08.135Z INFO attempting to acquire leader lease pxc-operator/08db1feb.percona.com... 2024-08-02T21:30:24.373Z DEBUG events percona-xtradb-cluster-operator-6b944784cc-dmn6b_9f655ac2-80f5-4655-81bf-dfb74ee51b38 became leader {"type": "Normal", "object": {"kind":"Lease","namespace":"pxc-operator","name":"08db1feb.percona.com","uid":"a957a66b-bb8c-41f2-aa1c-3b177e8d5b43","apiVersion":"coordination.k8s.io/v1","resourceVersion":"23979"}, "reason": "LeaderElection"} 2024-08-02T21:30:24.373Z INFO Starting Controller {"controller": "pxcbackup-controller"} 2024-08-02T21:30:24.373Z INFO Starting Controller {"controller": "pxc-controller"} 2024-08-02T21:30:24.373Z INFO Starting Controller {"controller": "pxcrestore-controller"} 2024-08-02T21:30:24.373Z INFO Starting EventSource {"controller": "pxcbackup-controller", "source": "kind source: *v1.PerconaXtraDBClusterBackup"} 2024-08-02T21:30:24.373Z INFO Starting EventSource {"controller": "pxc-controller", "source": "kind source: *v1.PerconaXtraDBCluster"} 2024-08-02T21:30:24.373Z INFO Starting EventSource {"controller": "pxcrestore-controller", "source": "kind source: *v1.PerconaXtraDBClusterRestore"} 2024-08-02T21:30:24.373Z INFO successfully acquired lease pxc-operator/08db1feb.percona.com 2024-08-02T21:30:24.479Z INFO Starting workers {"controller": "pxcrestore-controller", "worker count": 1} 2024-08-02T21:30:24.480Z INFO Starting workers {"controller": "pxcbackup-controller", "worker count": 1} 2024-08-02T21:30:24.480Z INFO Starting workers {"controller": "pxc-controller", "worker count": 1} 2024-08-02T21:30:25.025Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "9e776fcd-489b-4aa1-bb58-734f4794b84c"} 2024-08-02T21:30:25.027Z DEBUG Updating object {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "9e776fcd-489b-4aa1-bb58-734f4794b84c", "object": "upgrade-proxysql-proxysql"} 2024-08-02T21:30:25.134Z INFO Creating or updating backup job {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "9e776fcd-489b-4aa1-bb58-734f4794b84c", "name": "93e2f-daily-backup", "schedule": "0 0 * * *"} 2024-08-02T21:30:30.261Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "6f168b6d-b832-4ec5-8a9d-47dfb9f7eef5"} 2024-08-02T21:30:35.359Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "51d035b2-4480-41f4-9db2-9fddb31b0b15"} 2024-08-02T21:30:40.502Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "7b7959b5-5a0d-4198-bfc4-20cb1e023476"} 2024-08-02T21:30:45.622Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "d21b2cdf-f990-460c-b1c0-bb9a38513f10"} 2024-08-02T21:30:50.736Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "b1af0b47-5c1e-42cc-96ea-58872cdefd56"} 2024-08-02T21:30:55.838Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "ff64cdd7-22c7-44ba-92a1-3e7bddd6a80f"} 2024-08-02T21:30:55.970Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "426c913c-1ffb-45e5-b8ad-a10b1886212f"} 2024-08-02T21:31:00.962Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "67eaa923-f016-4d16-bf13-e6d7512eae06"} 2024-08-02T21:31:06.060Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "d02d54b7-08bb-4ab8-be13-be9275ec2893"} 2024-08-02T21:31:06.246Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "fe18b484-ebf5-4672-a9ad-4a11701063e8"} 2024-08-02T21:31:11.626Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "6343e663-1685-4b0c-8b36-ae6813f74a7f"} 2024-08-02T21:31:12.638Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "61ddd755-040a-4529-9932-f8862e18db75"} 2024-08-02T21:31:17.473Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "cecad251-7ca2-4c2b-9111-bfaf48277414"} 2024-08-02T21:31:22.676Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "5108f76c-5c71-415c-a9b9-e1e9c072bbec"} 2024-08-02T21:31:22.833Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "1f1f4a72-0f83-431f-9811-a7fc7c93f995"} 2024-08-02T21:31:27.856Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "c2f81a22-c9eb-484c-8848-a71ab973c461"} 2024-08-02T21:31:33.030Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "75894c12-21d8-4e9c-9ded-caa351beadbf"} 2024-08-02T21:31:33.149Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "30a8aed3-e253-48aa-b780-ab6afffbc86f"} 2024-08-02T21:31:38.150Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "2e2640bb-2bb5-4c7c-bb47-8565ed913fb1"} 2024-08-02T21:31:43.279Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "075fd7df-10a8-4a32-a91b-907d8154a2ec"} 2024-08-02T21:31:48.427Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "f9c3cda6-27a6-4991-8aa8-37f0ecee43b7"} 2024-08-02T21:31:53.543Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "28ad00f5-2136-41f7-b16a-5b07fc77c66e"} 2024-08-02T21:31:58.699Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "430783e2-0b54-48e3-984e-42f376d662b4"} 2024-08-02T21:32:04.009Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "ad20fbad-848e-4eef-a0f5-fe6142376e8a"} 2024-08-02T21:32:09.113Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "238618af-c58e-4940-a704-8aebde6dabdc"} 2024-08-02T21:32:14.224Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "7b981b81-7ce9-4cf3-a20f-8ac940494b54"} 2024-08-02T21:32:19.501Z INFO Waiting for ProxySQL to be ready before smart update {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "846f6192-0ba9-407e-9443-cce9922fe620"} 2024-08-02T21:32:36.850Z INFO update PXC version (fetched from db) {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "4abb22b3-857a-4e54-9e50-c203aa266700", "new version": "5.7.44-48-57"} 2024-08-02T21:32:39.324Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "4abb22b3-857a-4e54-9e50-c203aa266700"} 2024-08-02T21:32:44.406Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "2a51e3ae-7d60-4815-8c31-5d7739d914cb"} 2024-08-02T21:32:50.573Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "d47cfb9c-b55f-41dc-9bda-463fb19ae5d3"} 2024-08-02T21:32:56.879Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "9484f8db-0a1e-4938-9e3a-6887bb721555"} 2024-08-02T21:33:02.986Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "71fba223-13a9-4f68-908f-f556a3bd850e"} 2024-08-02T21:33:09.072Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "caed329e-e754-4736-82f2-21d788c0ca85"} 2024-08-02T21:33:15.503Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "a7806649-7ca7-4dc8-8aea-21f3f947c7fd"} 2024-08-02T21:33:21.384Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "32941bae-a16b-4bf0-afdd-10ccfb6539ab"} 2024-08-02T21:33:27.687Z DEBUG PXC users synced with ProxySQL {"controller": "pxc-controller", "namespace": "upgrade-proxysql-22248", "name": "upgrade-proxysql", "reconcileID": "d920551d-8bc3-45ba-9988-75d65a4d7641"} + 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-22248 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.dpX03SKFSh ++ mktemp + local LAST_ERR=/tmp/tmp.xr1KLEV9Pl + 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.dpX03SKFSh perconaxtradbcluster.pxc.percona.com "upgrade-proxysql" deleted + cat /tmp/tmp.xr1KLEV9Pl + rm /tmp/tmp.dpX03SKFSh /tmp/tmp.xr1KLEV9Pl + return 0 + kubectl_bin delete pxc-backup --all --all-namespaces ++ mktemp + local LAST_OUT=/tmp/tmp.D3q60V9laS ++ mktemp + local LAST_ERR=/tmp/tmp.gWL4SASt46 + 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.D3q60V9laS No resources found + cat /tmp/tmp.gWL4SASt46 + rm /tmp/tmp.D3q60V9laS /tmp/tmp.gWL4SASt46 + return 0 + kubectl_bin delete pxc-restore --all --all-namespaces ++ mktemp + local LAST_OUT=/tmp/tmp.NnZu62no2X ++ mktemp + local LAST_ERR=/tmp/tmp.bqJyv07MfL + 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.NnZu62no2X No resources found + cat /tmp/tmp.bqJyv07MfL + rm /tmp/tmp.NnZu62no2X /tmp/tmp.bqJyv07MfL + return 0 + kubectl_bin delete ValidatingWebhookConfiguration percona-xtradbcluster-webhook ++ mktemp + local LAST_OUT=/tmp/tmp.RiuOSccf3W ++ mktemp + local LAST_ERR=/tmp/tmp.9waWVYTDCs + 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.RiuOSccf3W validatingwebhookconfiguration.admissionregistration.k8s.io "percona-xtradbcluster-webhook" deleted + cat /tmp/tmp.9waWVYTDCs + rm /tmp/tmp.RiuOSccf3W /tmp/tmp.9waWVYTDCs + return 0 + kubectl_bin delete -f https://github.com/jetstack/cert-manager/releases/download/v1.14.2/cert-manager.yaml + : + '[' '!' -z '' ']' + '[' -n pxc-operator ']' + rm -rf /tmp/tmp.sqKUwUqNIA + kubectl_bin delete --grace-period=0 --force=true namespace pxc-operator + kubectl_bin delete --grace-period=0 --force=true namespace upgrade-proxysql-22248 ++ mktemp ++ mktemp + local LAST_OUT=/tmp/tmp.01q9ovRJtL + local LAST_OUT=/tmp/tmp.kA7u5MVST9 ++ grep perconaxtradbcluster ++ tr '\n' ' ' ++ mktemp + local LAST_ERR=/tmp/tmp.zXfDkvxzW1 + local exit_status=0 ++ kubectl get crd ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl delete --grace-period=0 --force=true namespace pxc-operator ++ awk '{print $1}' ++ mktemp + local LAST_ERR=/tmp/tmp.9A2UiULsy3 + local exit_status=0 ++ seq 0 2 + for i in '$(seq 0 2)' + set +e + kubectl delete --grace-period=0 --force=true namespace upgrade-proxysql-22248 + 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 -----------------------------------------------------------------------------------