=== RUN kuttl harness.go:464: starting setup harness.go:255: running tests using configured kubeconfig. harness.go:278: Successful connection to cluster at: https://34.173.179.174 harness.go:363: running tests harness.go:75: going to run test suite with timeout of 180 seconds for each step harness.go:375: testsuite: e2e-tests/tests has 24 tests === RUN kuttl/harness === RUN kuttl/harness/users === PAUSE kuttl/harness/users === CONT kuttl/harness/users logger.go:42: 09:41:15 | users | Creating namespace: kuttl-test-great-dove logger.go:42: 09:41:15 | users/0-deploy-operator | starting test step 0-deploy-operator logger.go:42: 09:41:15 | users/0-deploy-operator | running command: [sh -c set -o errexit set -o xtrace source ../../functions init_temp_dir # do this only in the first TestStep deploy_operator deploy_client] logger.go:42: 09:41:15 | users/0-deploy-operator | + source ../../functions logger.go:42: 09:41:15 | users/0-deploy-operator | +++ realpath ../../.. logger.go:42: 09:41:15 | users/0-deploy-operator | ++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:41:15 | users/0-deploy-operator | ++ CERT_MANAGER_VER=1.17.1 logger.go:42: 09:41:15 | users/0-deploy-operator | ++++ pwd logger.go:42: 09:41:15 | users/0-deploy-operator | +++ basename /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/tests/users logger.go:42: 09:41:15 | users/0-deploy-operator | ++ test_name=users logger.go:42: 09:41:15 | users/0-deploy-operator | ++ source /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/vars.sh logger.go:42: 09:41:15 | users/0-deploy-operator | +++ export ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:41:15 | users/0-deploy-operator | +++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:41:15 | users/0-deploy-operator | +++ export DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:41:15 | users/0-deploy-operator | +++ DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:41:15 | users/0-deploy-operator | +++ export TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:41:15 | users/0-deploy-operator | +++ TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:41:15 | users/0-deploy-operator | +++ export TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:41:15 | users/0-deploy-operator | +++ TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:41:15 | users/0-deploy-operator | +++ export TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:41:15 | users/0-deploy-operator | +++ TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:41:15 | users/0-deploy-operator | ++++ git rev-parse --abbrev-ref HEAD logger.go:42: 09:41:15 | users/0-deploy-operator | +++ export GIT_BRANCH=PR-1165 logger.go:42: 09:41:15 | users/0-deploy-operator | +++ GIT_BRANCH=PR-1165 logger.go:42: 09:41:15 | users/0-deploy-operator | +++ export VERSION=PR-1165-9f6804715 logger.go:42: 09:41:15 | users/0-deploy-operator | +++ VERSION=PR-1165-9f6804715 logger.go:42: 09:41:15 | users/0-deploy-operator | +++ export IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:41:15 | users/0-deploy-operator | +++ IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:41:15 | users/0-deploy-operator | +++ export IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:41:15 | users/0-deploy-operator | +++ IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:41:15 | users/0-deploy-operator | +++ export PG_VER=17 logger.go:42: 09:41:15 | users/0-deploy-operator | +++ PG_VER=17 logger.go:42: 09:41:15 | users/0-deploy-operator | +++ export IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:41:15 | users/0-deploy-operator | +++ IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:41:15 | users/0-deploy-operator | +++ export IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:41:15 | users/0-deploy-operator | +++ IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:41:15 | users/0-deploy-operator | +++ export IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:41:15 | users/0-deploy-operator | +++ IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:41:15 | users/0-deploy-operator | +++ export IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:41:15 | users/0-deploy-operator | +++ IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:41:15 | users/0-deploy-operator | +++ export BUCKET=pg-operator-testing logger.go:42: 09:41:15 | users/0-deploy-operator | +++ BUCKET=pg-operator-testing logger.go:42: 09:41:15 | users/0-deploy-operator | +++ export PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:41:15 | users/0-deploy-operator | +++ PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:41:15 | users/0-deploy-operator | +++ export IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:41:15 | users/0-deploy-operator | +++ IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:41:15 | users/0-deploy-operator | +++ export IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:41:15 | users/0-deploy-operator | +++ IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:41:15 | users/0-deploy-operator | +++ export IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:41:15 | users/0-deploy-operator | +++ IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:41:15 | users/0-deploy-operator | +++ export IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:41:15 | users/0-deploy-operator | +++ IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:41:15 | users/0-deploy-operator | +++ export PGOV1_TAG=1.4.0 logger.go:42: 09:41:15 | users/0-deploy-operator | +++ PGOV1_TAG=1.4.0 logger.go:42: 09:41:15 | users/0-deploy-operator | +++ export PGOV1_VER=14 logger.go:42: 09:41:15 | users/0-deploy-operator | +++ PGOV1_VER=14 logger.go:42: 09:41:15 | users/0-deploy-operator | ++++ which gdate logger.go:42: 09:41:15 | users/0-deploy-operator | which: no gdate in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:41:15 | users/0-deploy-operator | ++++ which date logger.go:42: 09:41:15 | users/0-deploy-operator | +++ date=/usr/bin/date logger.go:42: 09:41:15 | users/0-deploy-operator | ++++ which gsed logger.go:42: 09:41:15 | users/0-deploy-operator | which: no gsed in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:41:15 | users/0-deploy-operator | ++++ which sed logger.go:42: 09:41:15 | users/0-deploy-operator | +++ sed=/usr/bin/sed logger.go:42: 09:41:15 | users/0-deploy-operator | +++ command -v oc logger.go:42: 09:41:15 | users/0-deploy-operator | ++ oc get projects logger.go:42: 09:41:15 | users/0-deploy-operator | + init_temp_dir logger.go:42: 09:41:15 | users/0-deploy-operator | + rm -rf /tmp/kuttl/pg/users logger.go:42: 09:41:15 | users/0-deploy-operator | + mkdir -p /tmp/kuttl/pg/users logger.go:42: 09:41:15 | users/0-deploy-operator | + deploy_operator logger.go:42: 09:41:15 | users/0-deploy-operator | + local cw_prefix= logger.go:42: 09:41:15 | users/0-deploy-operator | + destroy_operator logger.go:42: 09:41:15 | users/0-deploy-operator | + kubectl -n pg-operator delete deployment percona-postgresql-operator --force --grace-period=0 logger.go:42: 09:41:15 | users/0-deploy-operator | Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. logger.go:42: 09:41:15 | users/0-deploy-operator | Error from server (NotFound): deployments.apps "percona-postgresql-operator" not found logger.go:42: 09:41:15 | users/0-deploy-operator | + true logger.go:42: 09:41:15 | users/0-deploy-operator | + [[ -n pg-operator ]] logger.go:42: 09:41:15 | users/0-deploy-operator | + kubectl delete namespace pg-operator --force --grace-period=0 logger.go:42: 09:41:15 | users/0-deploy-operator | Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. logger.go:42: 09:41:16 | users/0-deploy-operator | Error from server (NotFound): namespaces "pg-operator" not found logger.go:42: 09:41:16 | users/0-deploy-operator | + true logger.go:42: 09:41:16 | users/0-deploy-operator | + [[ -n pg-operator ]] logger.go:42: 09:41:16 | users/0-deploy-operator | + create_namespace pg-operator logger.go:42: 09:41:16 | users/0-deploy-operator | + local namespace=pg-operator logger.go:42: 09:41:16 | users/0-deploy-operator | + [[ -n '' ]] logger.go:42: 09:41:16 | users/0-deploy-operator | + kubectl delete namespace pg-operator --ignore-not-found logger.go:42: 09:41:16 | users/0-deploy-operator | + kubectl wait --for=delete namespace pg-operator logger.go:42: 09:41:17 | users/0-deploy-operator | + kubectl create namespace pg-operator logger.go:42: 09:41:17 | users/0-deploy-operator | namespace/pg-operator created logger.go:42: 09:41:17 | users/0-deploy-operator | + cw_prefix=cw- logger.go:42: 09:41:17 | users/0-deploy-operator | + kubectl -n pg-operator apply --server-side --force-conflicts -f /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy/crd.yaml logger.go:42: 09:41:18 | users/0-deploy-operator | customresourcedefinition.apiextensions.k8s.io/crunchybridgeclusters.postgres-operator.crunchydata.com serverside-applied logger.go:42: 09:41:18 | users/0-deploy-operator | customresourcedefinition.apiextensions.k8s.io/perconapgbackups.pgv2.percona.com serverside-applied logger.go:42: 09:41:20 | users/0-deploy-operator | customresourcedefinition.apiextensions.k8s.io/perconapgclusters.pgv2.percona.com serverside-applied logger.go:42: 09:41:20 | users/0-deploy-operator | customresourcedefinition.apiextensions.k8s.io/perconapgrestores.pgv2.percona.com serverside-applied logger.go:42: 09:41:21 | users/0-deploy-operator | customresourcedefinition.apiextensions.k8s.io/perconapgupgrades.pgv2.percona.com serverside-applied logger.go:42: 09:41:21 | users/0-deploy-operator | customresourcedefinition.apiextensions.k8s.io/pgadmins.postgres-operator.crunchydata.com serverside-applied logger.go:42: 09:41:22 | users/0-deploy-operator | customresourcedefinition.apiextensions.k8s.io/pgupgrades.postgres-operator.crunchydata.com serverside-applied logger.go:42: 09:41:23 | users/0-deploy-operator | customresourcedefinition.apiextensions.k8s.io/postgresclusters.postgres-operator.crunchydata.com serverside-applied logger.go:42: 09:41:23 | users/0-deploy-operator | + kubectl -n pg-operator apply --server-side --force-conflicts -f /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy/cw-rbac.yaml logger.go:42: 09:41:24 | users/0-deploy-operator | serviceaccount/percona-postgresql-operator serverside-applied logger.go:42: 09:41:24 | users/0-deploy-operator | clusterrole.rbac.authorization.k8s.io/percona-postgresql-operator serverside-applied logger.go:42: 09:41:24 | users/0-deploy-operator | clusterrolebinding.rbac.authorization.k8s.io/percona-postgresql-operator serverside-applied logger.go:42: 09:41:24 | users/0-deploy-operator | + local disable_telemetry=true logger.go:42: 09:41:24 | users/0-deploy-operator | + '[' users == telemetry-transfer ']' logger.go:42: 09:41:24 | users/0-deploy-operator | + yq eval '(.spec.template.spec.containers[] | select(.name=="operator") | .env[] | select(.name=="DISABLE_TELEMETRY") | .value) = "true"' - logger.go:42: 09:41:24 | users/0-deploy-operator | + kubectl -n pg-operator apply -f - logger.go:42: 09:41:24 | users/0-deploy-operator | + yq eval '.spec.template.spec.containers[0].image = "perconalab/percona-postgresql-operator:PR-1165-9f6804715"' /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy/cw-operator.yaml logger.go:42: 09:41:25 | users/0-deploy-operator | deployment.apps/percona-postgresql-operator created logger.go:42: 09:41:25 | users/0-deploy-operator | + deploy_client logger.go:42: 09:41:25 | users/0-deploy-operator | + kubectl -n kuttl-test-great-dove apply -f /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf/client.yaml logger.go:42: 09:41:26 | users/0-deploy-operator | deployment.apps/pg-client created logger.go:42: 09:41:27 | users/0-deploy-operator | running command: [sh -c kubectl assert exist-enhanced deployment percona-postgresql-operator -n ${OPERATOR_NS:-$NAMESPACE} --field-selector status.readyReplicas=1] logger.go:42: 09:41:27 | users/0-deploy-operator | ASSERT deployment percona-postgresql-operator matching field criteria 'status.readyReplicas=1' should exist. logger.go:42: 09:41:27 | users/0-deploy-operator | ASSERT FAIL Resource(s) not found. logger.go:42: 09:41:28 | users/0-deploy-operator | running command: [sh -c kubectl assert exist-enhanced deployment percona-postgresql-operator -n ${OPERATOR_NS:-$NAMESPACE} --field-selector status.readyReplicas=1] logger.go:42: 09:41:29 | users/0-deploy-operator | ASSERT deployment percona-postgresql-operator matching field criteria 'status.readyReplicas=1' should exist. logger.go:42: 09:41:29 | users/0-deploy-operator | INFO Found 1 resource(s). logger.go:42: 09:41:29 | users/0-deploy-operator | NAME NAMESPACE COL0 logger.go:42: 09:41:29 | users/0-deploy-operator | percona-postgresql-operator pg-operator 1 logger.go:42: 09:41:29 | users/0-deploy-operator | ASSERT PASS logger.go:42: 09:41:29 | users/0-deploy-operator | test step completed 0-deploy-operator logger.go:42: 09:41:29 | users/1-create-cluster | starting test step 1-create-cluster logger.go:42: 09:41:29 | users/1-create-cluster | running command: [sh -c set -o errexit set -o xtrace source ../../functions get_cr "users" ${RANDOM}| kubectl -n "${NAMESPACE}" apply -f -] logger.go:42: 09:41:29 | users/1-create-cluster | + source ../../functions logger.go:42: 09:41:29 | users/1-create-cluster | +++ realpath ../../.. logger.go:42: 09:41:29 | users/1-create-cluster | ++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:41:29 | users/1-create-cluster | ++ CERT_MANAGER_VER=1.17.1 logger.go:42: 09:41:29 | users/1-create-cluster | ++++ pwd logger.go:42: 09:41:29 | users/1-create-cluster | +++ basename /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/tests/users logger.go:42: 09:41:29 | users/1-create-cluster | ++ test_name=users logger.go:42: 09:41:29 | users/1-create-cluster | ++ source /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/vars.sh logger.go:42: 09:41:29 | users/1-create-cluster | +++ export ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:41:29 | users/1-create-cluster | +++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:41:29 | users/1-create-cluster | +++ export DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:41:29 | users/1-create-cluster | +++ DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:41:29 | users/1-create-cluster | +++ export TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:41:29 | users/1-create-cluster | +++ TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:41:29 | users/1-create-cluster | +++ export TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:41:29 | users/1-create-cluster | +++ TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:41:29 | users/1-create-cluster | +++ export TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:41:29 | users/1-create-cluster | +++ TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:41:29 | users/1-create-cluster | ++++ git rev-parse --abbrev-ref HEAD logger.go:42: 09:41:29 | users/1-create-cluster | +++ export GIT_BRANCH=PR-1165 logger.go:42: 09:41:29 | users/1-create-cluster | +++ GIT_BRANCH=PR-1165 logger.go:42: 09:41:29 | users/1-create-cluster | +++ export VERSION=PR-1165-9f6804715 logger.go:42: 09:41:29 | users/1-create-cluster | +++ VERSION=PR-1165-9f6804715 logger.go:42: 09:41:29 | users/1-create-cluster | +++ export IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:41:29 | users/1-create-cluster | +++ IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:41:29 | users/1-create-cluster | +++ export IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:41:29 | users/1-create-cluster | +++ IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:41:29 | users/1-create-cluster | +++ export PG_VER=17 logger.go:42: 09:41:29 | users/1-create-cluster | +++ PG_VER=17 logger.go:42: 09:41:29 | users/1-create-cluster | +++ export IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:41:29 | users/1-create-cluster | +++ IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:41:29 | users/1-create-cluster | +++ export IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:41:29 | users/1-create-cluster | +++ IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:41:29 | users/1-create-cluster | +++ export IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:41:29 | users/1-create-cluster | +++ IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:41:29 | users/1-create-cluster | +++ export IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:41:29 | users/1-create-cluster | +++ IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:41:29 | users/1-create-cluster | +++ export BUCKET=pg-operator-testing logger.go:42: 09:41:29 | users/1-create-cluster | +++ BUCKET=pg-operator-testing logger.go:42: 09:41:29 | users/1-create-cluster | +++ export PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:41:29 | users/1-create-cluster | +++ PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:41:29 | users/1-create-cluster | +++ export IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:41:29 | users/1-create-cluster | +++ IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:41:29 | users/1-create-cluster | +++ export IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:41:29 | users/1-create-cluster | +++ IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:41:29 | users/1-create-cluster | +++ export IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:41:29 | users/1-create-cluster | +++ IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:41:29 | users/1-create-cluster | +++ export IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:41:29 | users/1-create-cluster | +++ IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:41:29 | users/1-create-cluster | +++ export PGOV1_TAG=1.4.0 logger.go:42: 09:41:29 | users/1-create-cluster | +++ PGOV1_TAG=1.4.0 logger.go:42: 09:41:29 | users/1-create-cluster | +++ export PGOV1_VER=14 logger.go:42: 09:41:29 | users/1-create-cluster | +++ PGOV1_VER=14 logger.go:42: 09:41:29 | users/1-create-cluster | ++++ which gdate logger.go:42: 09:41:29 | users/1-create-cluster | which: no gdate in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:41:29 | users/1-create-cluster | ++++ which date logger.go:42: 09:41:29 | users/1-create-cluster | +++ date=/usr/bin/date logger.go:42: 09:41:29 | users/1-create-cluster | ++++ which gsed logger.go:42: 09:41:29 | users/1-create-cluster | which: no gsed in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:41:29 | users/1-create-cluster | ++++ which sed logger.go:42: 09:41:29 | users/1-create-cluster | +++ sed=/usr/bin/sed logger.go:42: 09:41:29 | users/1-create-cluster | +++ command -v oc logger.go:42: 09:41:29 | users/1-create-cluster | ++ oc get projects logger.go:42: 09:41:29 | users/1-create-cluster | + get_cr users 16740 logger.go:42: 09:41:29 | users/1-create-cluster | + local cr_name=users logger.go:42: 09:41:29 | users/1-create-cluster | + kubectl -n kuttl-test-great-dove apply -f - logger.go:42: 09:41:29 | users/1-create-cluster | + '[' -z users ']' logger.go:42: 09:41:29 | users/1-create-cluster | + local repo_path=16740 logger.go:42: 09:41:29 | users/1-create-cluster | + yq eval ' logger.go:42: 09:41:29 | users/1-create-cluster | .metadata.name = "users" | logger.go:42: 09:41:29 | users/1-create-cluster | .metadata.labels = {"e2e":"users"} | logger.go:42: 09:41:29 | users/1-create-cluster | .spec.postgresVersion = 17 | logger.go:42: 09:41:29 | users/1-create-cluster | .spec.users += [{"name":"postgres","password":{"type":"AlphaNumeric"}}] | logger.go:42: 09:41:29 | users/1-create-cluster | .spec.users += [{"name":"users","password":{"type":"AlphaNumeric"}}] | logger.go:42: 09:41:29 | users/1-create-cluster | .spec.image = "perconalab/percona-postgresql-operator:main-ppg17-postgres" | logger.go:42: 09:41:29 | users/1-create-cluster | .spec.initContainer.image = "perconalab/percona-postgresql-operator:PR-1165-9f6804715" | logger.go:42: 09:41:29 | users/1-create-cluster | .spec.backups.pgbackrest.image = "perconalab/percona-postgresql-operator:main-pgbackrest17" | logger.go:42: 09:41:29 | users/1-create-cluster | .spec.proxy.pgBouncer.image = "perconalab/percona-postgresql-operator:main-pgbouncer17" | logger.go:42: 09:41:29 | users/1-create-cluster | .spec.pmm.image = "perconalab/pmm-client:dev-latest" | logger.go:42: 09:41:29 | users/1-create-cluster | .spec.pmm.secret = "users-pmm-secret" | logger.go:42: 09:41:29 | users/1-create-cluster | .spec.pmm.customClusterName = "users-pmm-custom-name" | logger.go:42: 09:41:29 | users/1-create-cluster | .spec.pmm.postgresParams = "--environment=dev-postgres" logger.go:42: 09:41:29 | users/1-create-cluster | ' /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy/cr.yaml logger.go:42: 09:41:29 | users/1-create-cluster | + [[ -n '' ]] logger.go:42: 09:41:29 | users/1-create-cluster | + case $test_name in logger.go:42: 09:41:29 | users/1-create-cluster | + cat /tmp/kuttl/pg/users/cr.yaml logger.go:42: 09:41:30 | users/1-create-cluster | perconapgcluster.pgv2.percona.com/users created logger.go:42: 09:42:39 | users/1-create-cluster | test step completed 1-create-cluster logger.go:42: 09:42:39 | users/2-write-data | starting test step 2-write-data logger.go:42: 09:42:39 | users/2-write-data | running command: [sh -c set -o errexit set -o xtrace source ../../functions run_psql_local \ 'CREATE DATABASE myapp; \c myapp \\\ CREATE TABLE IF NOT EXISTS myApp (id int PRIMARY KEY);' \ "postgres:$(get_psql_user_pass users-pguser-postgres)@$(get_psql_user_host users-pguser-postgres)" run_psql_local \ '\c myapp \\\ INSERT INTO myApp (id) VALUES (100500)' \ "postgres:$(get_psql_user_pass users-pguser-postgres)@$(get_psql_user_host users-pguser-postgres)"] logger.go:42: 09:42:39 | users/2-write-data | + source ../../functions logger.go:42: 09:42:39 | users/2-write-data | +++ realpath ../../.. logger.go:42: 09:42:39 | users/2-write-data | ++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:42:39 | users/2-write-data | ++ CERT_MANAGER_VER=1.17.1 logger.go:42: 09:42:39 | users/2-write-data | ++++ pwd logger.go:42: 09:42:39 | users/2-write-data | +++ basename /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/tests/users logger.go:42: 09:42:39 | users/2-write-data | ++ test_name=users logger.go:42: 09:42:39 | users/2-write-data | ++ source /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/vars.sh logger.go:42: 09:42:39 | users/2-write-data | +++ export ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:42:39 | users/2-write-data | +++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:42:39 | users/2-write-data | +++ export DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:42:39 | users/2-write-data | +++ DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:42:39 | users/2-write-data | +++ export TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:42:39 | users/2-write-data | +++ TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:42:39 | users/2-write-data | +++ export TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:42:39 | users/2-write-data | +++ TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:42:39 | users/2-write-data | +++ export TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:42:39 | users/2-write-data | +++ TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:42:39 | users/2-write-data | ++++ git rev-parse --abbrev-ref HEAD logger.go:42: 09:42:39 | users/2-write-data | +++ export GIT_BRANCH=PR-1165 logger.go:42: 09:42:39 | users/2-write-data | +++ GIT_BRANCH=PR-1165 logger.go:42: 09:42:39 | users/2-write-data | +++ export VERSION=PR-1165-9f6804715 logger.go:42: 09:42:39 | users/2-write-data | +++ VERSION=PR-1165-9f6804715 logger.go:42: 09:42:39 | users/2-write-data | +++ export IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:42:39 | users/2-write-data | +++ IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:42:39 | users/2-write-data | +++ export IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:42:39 | users/2-write-data | +++ IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:42:39 | users/2-write-data | +++ export PG_VER=17 logger.go:42: 09:42:39 | users/2-write-data | +++ PG_VER=17 logger.go:42: 09:42:39 | users/2-write-data | +++ export IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:42:39 | users/2-write-data | +++ IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:42:39 | users/2-write-data | +++ export IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:42:39 | users/2-write-data | +++ IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:42:39 | users/2-write-data | +++ export IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:42:39 | users/2-write-data | +++ IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:42:39 | users/2-write-data | +++ export IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:42:39 | users/2-write-data | +++ IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:42:39 | users/2-write-data | +++ export BUCKET=pg-operator-testing logger.go:42: 09:42:39 | users/2-write-data | +++ BUCKET=pg-operator-testing logger.go:42: 09:42:39 | users/2-write-data | +++ export PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:42:39 | users/2-write-data | +++ PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:42:39 | users/2-write-data | +++ export IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:42:39 | users/2-write-data | +++ IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:42:39 | users/2-write-data | +++ export IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:42:39 | users/2-write-data | +++ IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:42:39 | users/2-write-data | +++ export IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:42:39 | users/2-write-data | +++ IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:42:39 | users/2-write-data | +++ export IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:42:39 | users/2-write-data | +++ IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:42:39 | users/2-write-data | +++ export PGOV1_TAG=1.4.0 logger.go:42: 09:42:39 | users/2-write-data | +++ PGOV1_TAG=1.4.0 logger.go:42: 09:42:39 | users/2-write-data | +++ export PGOV1_VER=14 logger.go:42: 09:42:39 | users/2-write-data | +++ PGOV1_VER=14 logger.go:42: 09:42:39 | users/2-write-data | ++++ which gdate logger.go:42: 09:42:39 | users/2-write-data | which: no gdate in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:42:39 | users/2-write-data | ++++ which date logger.go:42: 09:42:39 | users/2-write-data | +++ date=/usr/bin/date logger.go:42: 09:42:39 | users/2-write-data | ++++ which gsed logger.go:42: 09:42:39 | users/2-write-data | which: no gsed in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:42:39 | users/2-write-data | ++++ which sed logger.go:42: 09:42:39 | users/2-write-data | +++ sed=/usr/bin/sed logger.go:42: 09:42:39 | users/2-write-data | +++ command -v oc logger.go:42: 09:42:39 | users/2-write-data | ++ oc get projects logger.go:42: 09:42:39 | users/2-write-data | ++ get_psql_user_pass users-pguser-postgres logger.go:42: 09:42:39 | users/2-write-data | ++ local secret_name=users-pguser-postgres logger.go:42: 09:42:39 | users/2-write-data | ++ kubectl -n kuttl-test-great-dove get secret/users-pguser-postgres '--template={{.data.password | base64decode}}' logger.go:42: 09:42:39 | users/2-write-data | ++ get_psql_user_host users-pguser-postgres logger.go:42: 09:42:39 | users/2-write-data | ++ local secret_name=users-pguser-postgres logger.go:42: 09:42:39 | users/2-write-data | ++ kubectl -n kuttl-test-great-dove get secret/users-pguser-postgres '--template={{.data.host | base64decode }}' logger.go:42: 09:42:40 | users/2-write-data | + run_psql_local 'CREATE DATABASE myapp; \c myapp \\\ CREATE TABLE IF NOT EXISTS myApp (id int PRIMARY KEY);' postgres:RgcjYdxqodVVZjVe8VK0NZN3@users-primary.kuttl-test-great-dove.svc logger.go:42: 09:42:40 | users/2-write-data | + local 'command=CREATE DATABASE myapp; \c myapp \\\ CREATE TABLE IF NOT EXISTS myApp (id int PRIMARY KEY);' logger.go:42: 09:42:40 | users/2-write-data | + local uri=postgres:RgcjYdxqodVVZjVe8VK0NZN3@users-primary.kuttl-test-great-dove.svc logger.go:42: 09:42:40 | users/2-write-data | + local driver=postgres logger.go:42: 09:42:40 | users/2-write-data | ++ get_client_pod logger.go:42: 09:42:40 | users/2-write-data | ++ kubectl -n kuttl-test-great-dove get pods --selector=name=pg-client -o 'jsonpath={.items[].metadata.name}' logger.go:42: 09:42:40 | users/2-write-data | + kubectl -n kuttl-test-great-dove exec pg-client-84d6c45668-s5nx8 -- bash -c 'printf '\''CREATE DATABASE myapp; \c myapp \\\ CREATE TABLE IF NOT EXISTS myApp (id int PRIMARY KEY);\n'\'' | psql -v ON_ERROR_STOP=1 -t -q postgres://'\''postgres:RgcjYdxqodVVZjVe8VK0NZN3@users-primary.kuttl-test-great-dove.svc'\''' logger.go:42: 09:42:42 | users/2-write-data | ++ get_psql_user_pass users-pguser-postgres logger.go:42: 09:42:42 | users/2-write-data | ++ local secret_name=users-pguser-postgres logger.go:42: 09:42:42 | users/2-write-data | ++ kubectl -n kuttl-test-great-dove get secret/users-pguser-postgres '--template={{.data.password | base64decode}}' logger.go:42: 09:42:42 | users/2-write-data | ++ get_psql_user_host users-pguser-postgres logger.go:42: 09:42:42 | users/2-write-data | ++ local secret_name=users-pguser-postgres logger.go:42: 09:42:42 | users/2-write-data | ++ kubectl -n kuttl-test-great-dove get secret/users-pguser-postgres '--template={{.data.host | base64decode }}' logger.go:42: 09:42:42 | users/2-write-data | + run_psql_local '\c myapp \\\ INSERT INTO myApp (id) VALUES (100500)' postgres:RgcjYdxqodVVZjVe8VK0NZN3@users-primary.kuttl-test-great-dove.svc logger.go:42: 09:42:42 | users/2-write-data | + local 'command=\c myapp \\\ INSERT INTO myApp (id) VALUES (100500)' logger.go:42: 09:42:42 | users/2-write-data | + local uri=postgres:RgcjYdxqodVVZjVe8VK0NZN3@users-primary.kuttl-test-great-dove.svc logger.go:42: 09:42:42 | users/2-write-data | + local driver=postgres logger.go:42: 09:42:42 | users/2-write-data | ++ get_client_pod logger.go:42: 09:42:42 | users/2-write-data | ++ kubectl -n kuttl-test-great-dove get pods --selector=name=pg-client -o 'jsonpath={.items[].metadata.name}' logger.go:42: 09:42:43 | users/2-write-data | + kubectl -n kuttl-test-great-dove exec pg-client-84d6c45668-s5nx8 -- bash -c 'printf '\''\c myapp \\\ INSERT INTO myApp (id) VALUES (100500)\n'\'' | psql -v ON_ERROR_STOP=1 -t -q postgres://'\''postgres:RgcjYdxqodVVZjVe8VK0NZN3@users-primary.kuttl-test-great-dove.svc'\''' [controller-runtime] log.SetLogger(...) was never called; logs will not be displayed. Detected at: > goroutine 14 [running]: > runtime/debug.Stack() > /nix/store/wkbckbd30nlhq4dxzg64q6y4vm1xx4fk-go-1.22.1/share/go/src/runtime/debug/stack.go:24 +0x5e > sigs.k8s.io/controller-runtime/pkg/log.eventuallyFulfillRoot() > /home/mowsiany/go/pkg/mod/sigs.k8s.io/controller-runtime@v0.16.3/pkg/log/log.go:60 +0xcd > sigs.k8s.io/controller-runtime/pkg/log.(*delegatingLogSink).WithName(0xc0002a9c00, {0x184a055, 0x14}) > /home/mowsiany/go/pkg/mod/sigs.k8s.io/controller-runtime@v0.16.3/pkg/log/deleg.go:147 +0x3e > github.com/go-logr/logr.Logger.WithName({{0x1acb7d8, 0xc0002a9c00}, 0x0}, {0x184a055?, 0xc000689f80?}) > /home/mowsiany/go/pkg/mod/github.com/go-logr/logr@v1.2.4/logr.go:336 +0x36 > sigs.k8s.io/controller-runtime/pkg/client.newClient(0x131ead3?, {0x0, 0xc00043c9a0, {0x1accd90, 0xc000386280}, 0x0, {0x0, 0x0}, 0x0}) > /home/mowsiany/go/pkg/mod/sigs.k8s.io/controller-runtime@v0.16.3/pkg/client/client.go:122 +0xf1 > sigs.k8s.io/controller-runtime/pkg/client.New(0xc00054e908?, {0x0, 0xc00043c9a0, {0x1accd90, 0xc000386280}, 0x0, {0x0, 0x0}, 0x0}) > /home/mowsiany/go/pkg/mod/sigs.k8s.io/controller-runtime@v0.16.3/pkg/client/client.go:103 +0x7d > github.com/kudobuilder/kuttl/pkg/test/utils.NewRetryClient(0xc00054e908, {0x0, 0xc00043c9a0, {0x1accd90, 0xc000386280}, 0x0, {0x0, 0x0}, 0x0}) > /home/mowsiany/go/src/github.com/kudobuilder/kuttl/pkg/test/utils/kubernetes.go:177 +0x127 > github.com/kudobuilder/kuttl/pkg/test.(*Harness).Client(0xc00052fb08, 0xbd?) > /home/mowsiany/go/src/github.com/kudobuilder/kuttl/pkg/test/harness.go:323 +0x18e > github.com/kudobuilder/kuttl/pkg/test.(*Step).Create(0xc0001f11e0, 0xc000517ba0, {0xc0005c1728, 0x15}) > /home/mowsiany/go/src/github.com/kudobuilder/kuttl/pkg/test/step.go:177 +0x63 > github.com/kudobuilder/kuttl/pkg/test.(*Step).Run(0xc0001f11e0, 0xc000517ba0, {0xc0005c1728, 0x15}) > /home/mowsiany/go/src/github.com/kudobuilder/kuttl/pkg/test/step.go:457 +0x24a > github.com/kudobuilder/kuttl/pkg/test.(*Case).Run(0xc00062b4a0, 0xc000517ba0, 0xc0002377a0) > /home/mowsiany/go/src/github.com/kudobuilder/kuttl/pkg/test/case.go:373 +0xaeb > github.com/kudobuilder/kuttl/pkg/test.(*Harness).RunTests.func1.1(0xc000517ba0) > /home/mowsiany/go/src/github.com/kudobuilder/kuttl/pkg/test/harness.go:401 +0x12e > testing.tRunner(0xc000517ba0, 0xc000014e88) > /nix/store/wkbckbd30nlhq4dxzg64q6y4vm1xx4fk-go-1.22.1/share/go/src/testing/testing.go:1689 +0xfb > created by testing.(*T).Run in goroutine 13 > /nix/store/wkbckbd30nlhq4dxzg64q6y4vm1xx4fk-go-1.22.1/share/go/src/testing/testing.go:1742 +0x390 logger.go:42: 09:42:44 | users/2-write-data | test step completed 2-write-data logger.go:42: 09:42:44 | users/3-read-from-primary | starting test step 3-read-from-primary logger.go:42: 09:42:44 | users/3-read-from-primary | running command: [sh -c set -o errexit set -o xtrace source ../../functions data=$(run_psql_local '\c myapp \\\ SELECT * from myApp;' "postgres:$(get_psql_user_pass users-pguser-postgres)@$(get_psql_user_host users-pguser-postgres)") kubectl create configmap -n "${NAMESPACE}" 03-read-from-primary --from-literal=data="${data}"] logger.go:42: 09:42:44 | users/3-read-from-primary | + source ../../functions logger.go:42: 09:42:44 | users/3-read-from-primary | +++ realpath ../../.. logger.go:42: 09:42:44 | users/3-read-from-primary | ++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:42:44 | users/3-read-from-primary | ++ CERT_MANAGER_VER=1.17.1 logger.go:42: 09:42:44 | users/3-read-from-primary | ++++ pwd logger.go:42: 09:42:44 | users/3-read-from-primary | +++ basename /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/tests/users logger.go:42: 09:42:44 | users/3-read-from-primary | ++ test_name=users logger.go:42: 09:42:44 | users/3-read-from-primary | ++ source /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/vars.sh logger.go:42: 09:42:44 | users/3-read-from-primary | +++ export ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:42:44 | users/3-read-from-primary | +++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:42:44 | users/3-read-from-primary | +++ export DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:42:44 | users/3-read-from-primary | +++ DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:42:44 | users/3-read-from-primary | +++ export TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:42:44 | users/3-read-from-primary | +++ TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:42:44 | users/3-read-from-primary | +++ export TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:42:44 | users/3-read-from-primary | +++ TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:42:44 | users/3-read-from-primary | +++ export TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:42:44 | users/3-read-from-primary | +++ TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:42:44 | users/3-read-from-primary | ++++ git rev-parse --abbrev-ref HEAD logger.go:42: 09:42:44 | users/3-read-from-primary | +++ export GIT_BRANCH=PR-1165 logger.go:42: 09:42:44 | users/3-read-from-primary | +++ GIT_BRANCH=PR-1165 logger.go:42: 09:42:44 | users/3-read-from-primary | +++ export VERSION=PR-1165-9f6804715 logger.go:42: 09:42:44 | users/3-read-from-primary | +++ VERSION=PR-1165-9f6804715 logger.go:42: 09:42:44 | users/3-read-from-primary | +++ export IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:42:44 | users/3-read-from-primary | +++ IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:42:44 | users/3-read-from-primary | +++ export IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:42:44 | users/3-read-from-primary | +++ IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:42:44 | users/3-read-from-primary | +++ export PG_VER=17 logger.go:42: 09:42:44 | users/3-read-from-primary | +++ PG_VER=17 logger.go:42: 09:42:44 | users/3-read-from-primary | +++ export IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:42:44 | users/3-read-from-primary | +++ IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:42:44 | users/3-read-from-primary | +++ export IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:42:44 | users/3-read-from-primary | +++ IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:42:44 | users/3-read-from-primary | +++ export IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:42:44 | users/3-read-from-primary | +++ IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:42:44 | users/3-read-from-primary | +++ export IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:42:44 | users/3-read-from-primary | +++ IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:42:44 | users/3-read-from-primary | +++ export BUCKET=pg-operator-testing logger.go:42: 09:42:44 | users/3-read-from-primary | +++ BUCKET=pg-operator-testing logger.go:42: 09:42:44 | users/3-read-from-primary | +++ export PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:42:44 | users/3-read-from-primary | +++ PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:42:44 | users/3-read-from-primary | +++ export IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:42:44 | users/3-read-from-primary | +++ IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:42:44 | users/3-read-from-primary | +++ export IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:42:44 | users/3-read-from-primary | +++ IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:42:44 | users/3-read-from-primary | +++ export IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:42:44 | users/3-read-from-primary | +++ IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:42:44 | users/3-read-from-primary | +++ export IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:42:44 | users/3-read-from-primary | +++ IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:42:44 | users/3-read-from-primary | +++ export PGOV1_TAG=1.4.0 logger.go:42: 09:42:44 | users/3-read-from-primary | +++ PGOV1_TAG=1.4.0 logger.go:42: 09:42:44 | users/3-read-from-primary | +++ export PGOV1_VER=14 logger.go:42: 09:42:44 | users/3-read-from-primary | +++ PGOV1_VER=14 logger.go:42: 09:42:44 | users/3-read-from-primary | ++++ which gdate logger.go:42: 09:42:44 | users/3-read-from-primary | which: no gdate in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:42:44 | users/3-read-from-primary | ++++ which date logger.go:42: 09:42:44 | users/3-read-from-primary | +++ date=/usr/bin/date logger.go:42: 09:42:44 | users/3-read-from-primary | ++++ which gsed logger.go:42: 09:42:44 | users/3-read-from-primary | which: no gsed in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:42:44 | users/3-read-from-primary | ++++ which sed logger.go:42: 09:42:44 | users/3-read-from-primary | +++ sed=/usr/bin/sed logger.go:42: 09:42:44 | users/3-read-from-primary | +++ command -v oc logger.go:42: 09:42:44 | users/3-read-from-primary | ++ oc get projects logger.go:42: 09:42:44 | users/3-read-from-primary | +++ get_psql_user_pass users-pguser-postgres logger.go:42: 09:42:44 | users/3-read-from-primary | +++ local secret_name=users-pguser-postgres logger.go:42: 09:42:44 | users/3-read-from-primary | +++ kubectl -n kuttl-test-great-dove get secret/users-pguser-postgres '--template={{.data.password | base64decode}}' logger.go:42: 09:42:44 | users/3-read-from-primary | +++ get_psql_user_host users-pguser-postgres logger.go:42: 09:42:44 | users/3-read-from-primary | +++ local secret_name=users-pguser-postgres logger.go:42: 09:42:44 | users/3-read-from-primary | +++ kubectl -n kuttl-test-great-dove get secret/users-pguser-postgres '--template={{.data.host | base64decode }}' logger.go:42: 09:42:44 | users/3-read-from-primary | ++ run_psql_local '\c myapp \\\ SELECT * from myApp;' postgres:RgcjYdxqodVVZjVe8VK0NZN3@users-primary.kuttl-test-great-dove.svc logger.go:42: 09:42:44 | users/3-read-from-primary | ++ local 'command=\c myapp \\\ SELECT * from myApp;' logger.go:42: 09:42:44 | users/3-read-from-primary | ++ local uri=postgres:RgcjYdxqodVVZjVe8VK0NZN3@users-primary.kuttl-test-great-dove.svc logger.go:42: 09:42:44 | users/3-read-from-primary | ++ local driver=postgres logger.go:42: 09:42:44 | users/3-read-from-primary | +++ get_client_pod logger.go:42: 09:42:44 | users/3-read-from-primary | +++ kubectl -n kuttl-test-great-dove get pods --selector=name=pg-client -o 'jsonpath={.items[].metadata.name}' logger.go:42: 09:42:45 | users/3-read-from-primary | ++ kubectl -n kuttl-test-great-dove exec pg-client-84d6c45668-s5nx8 -- bash -c 'printf '\''\c myapp \\\ SELECT * from myApp;\n'\'' | psql -v ON_ERROR_STOP=1 -t -q postgres://'\''postgres:RgcjYdxqodVVZjVe8VK0NZN3@users-primary.kuttl-test-great-dove.svc'\''' logger.go:42: 09:42:46 | users/3-read-from-primary | + data=' 100500' logger.go:42: 09:42:46 | users/3-read-from-primary | + kubectl create configmap -n kuttl-test-great-dove 03-read-from-primary '--from-literal=data= 100500' logger.go:42: 09:42:46 | users/3-read-from-primary | configmap/03-read-from-primary created logger.go:42: 09:42:46 | users/3-read-from-primary | test step completed 3-read-from-primary logger.go:42: 09:42:46 | users/4-update-default-user-password | starting test step 4-update-default-user-password logger.go:42: 09:42:46 | users/4-update-default-user-password | running command: [sh -c set -o errexit set -o xtrace source ../../functions kubectl -n ${NAMESPACE} patch secret users-pguser-postgres --type merge --patch '{"stringData": {"password": "default-db-password", "verifier":""}}' sleep 5] logger.go:42: 09:42:46 | users/4-update-default-user-password | + source ../../functions logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ realpath ../../.. logger.go:42: 09:42:46 | users/4-update-default-user-password | ++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:42:46 | users/4-update-default-user-password | ++ CERT_MANAGER_VER=1.17.1 logger.go:42: 09:42:46 | users/4-update-default-user-password | ++++ pwd logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ basename /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/tests/users logger.go:42: 09:42:46 | users/4-update-default-user-password | ++ test_name=users logger.go:42: 09:42:46 | users/4-update-default-user-password | ++ source /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/vars.sh logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ export ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ export DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ export TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ export TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ export TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:42:46 | users/4-update-default-user-password | ++++ git rev-parse --abbrev-ref HEAD logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ export GIT_BRANCH=PR-1165 logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ GIT_BRANCH=PR-1165 logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ export VERSION=PR-1165-9f6804715 logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ VERSION=PR-1165-9f6804715 logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ export IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ export IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ export PG_VER=17 logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ PG_VER=17 logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ export IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ export IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ export IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ export IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ export BUCKET=pg-operator-testing logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ BUCKET=pg-operator-testing logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ export PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ export IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ export IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ export IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ export IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ export PGOV1_TAG=1.4.0 logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ PGOV1_TAG=1.4.0 logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ export PGOV1_VER=14 logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ PGOV1_VER=14 logger.go:42: 09:42:46 | users/4-update-default-user-password | ++++ which gdate logger.go:42: 09:42:46 | users/4-update-default-user-password | which: no gdate in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:42:46 | users/4-update-default-user-password | ++++ which date logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ date=/usr/bin/date logger.go:42: 09:42:46 | users/4-update-default-user-password | ++++ which gsed logger.go:42: 09:42:46 | users/4-update-default-user-password | which: no gsed in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:42:46 | users/4-update-default-user-password | ++++ which sed logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ sed=/usr/bin/sed logger.go:42: 09:42:46 | users/4-update-default-user-password | +++ command -v oc logger.go:42: 09:42:46 | users/4-update-default-user-password | ++ oc get projects logger.go:42: 09:42:46 | users/4-update-default-user-password | + kubectl -n kuttl-test-great-dove patch secret users-pguser-postgres --type merge --patch '{"stringData": {"password": "default-db-password", "verifier":""}}' logger.go:42: 09:42:47 | users/4-update-default-user-password | secret/users-pguser-postgres patched logger.go:42: 09:42:47 | users/4-update-default-user-password | + sleep 5 logger.go:42: 09:42:52 | users/4-update-default-user-password | test step completed 4-update-default-user-password logger.go:42: 09:42:52 | users/5-write-data | starting test step 5-write-data logger.go:42: 09:42:52 | users/5-write-data | running command: [sh -c set -o errexit set -o xtrace source ../../functions run_psql_local \ '\c myapp \\\ INSERT INTO myApp (id) VALUES (100501)' \ "postgres:default-db-password@$(get_psql_user_host users-pguser-postgres)"] logger.go:42: 09:42:52 | users/5-write-data | + source ../../functions logger.go:42: 09:42:52 | users/5-write-data | +++ realpath ../../.. logger.go:42: 09:42:52 | users/5-write-data | ++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:42:52 | users/5-write-data | ++ CERT_MANAGER_VER=1.17.1 logger.go:42: 09:42:52 | users/5-write-data | ++++ pwd logger.go:42: 09:42:52 | users/5-write-data | +++ basename /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/tests/users logger.go:42: 09:42:52 | users/5-write-data | ++ test_name=users logger.go:42: 09:42:52 | users/5-write-data | ++ source /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/vars.sh logger.go:42: 09:42:52 | users/5-write-data | +++ export ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:42:52 | users/5-write-data | +++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:42:52 | users/5-write-data | +++ export DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:42:52 | users/5-write-data | +++ DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:42:52 | users/5-write-data | +++ export TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:42:52 | users/5-write-data | +++ TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:42:52 | users/5-write-data | +++ export TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:42:52 | users/5-write-data | +++ TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:42:52 | users/5-write-data | +++ export TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:42:52 | users/5-write-data | +++ TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:42:52 | users/5-write-data | ++++ git rev-parse --abbrev-ref HEAD logger.go:42: 09:42:52 | users/5-write-data | +++ export GIT_BRANCH=PR-1165 logger.go:42: 09:42:52 | users/5-write-data | +++ GIT_BRANCH=PR-1165 logger.go:42: 09:42:52 | users/5-write-data | +++ export VERSION=PR-1165-9f6804715 logger.go:42: 09:42:52 | users/5-write-data | +++ VERSION=PR-1165-9f6804715 logger.go:42: 09:42:52 | users/5-write-data | +++ export IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:42:52 | users/5-write-data | +++ IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:42:52 | users/5-write-data | +++ export IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:42:52 | users/5-write-data | +++ IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:42:52 | users/5-write-data | +++ export PG_VER=17 logger.go:42: 09:42:52 | users/5-write-data | +++ PG_VER=17 logger.go:42: 09:42:52 | users/5-write-data | +++ export IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:42:52 | users/5-write-data | +++ IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:42:52 | users/5-write-data | +++ export IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:42:52 | users/5-write-data | +++ IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:42:52 | users/5-write-data | +++ export IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:42:52 | users/5-write-data | +++ IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:42:52 | users/5-write-data | +++ export IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:42:52 | users/5-write-data | +++ IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:42:52 | users/5-write-data | +++ export BUCKET=pg-operator-testing logger.go:42: 09:42:52 | users/5-write-data | +++ BUCKET=pg-operator-testing logger.go:42: 09:42:52 | users/5-write-data | +++ export PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:42:52 | users/5-write-data | +++ PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:42:52 | users/5-write-data | +++ export IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:42:52 | users/5-write-data | +++ IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:42:52 | users/5-write-data | +++ export IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:42:52 | users/5-write-data | +++ IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:42:52 | users/5-write-data | +++ export IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:42:52 | users/5-write-data | +++ IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:42:52 | users/5-write-data | +++ export IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:42:52 | users/5-write-data | +++ IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:42:52 | users/5-write-data | +++ export PGOV1_TAG=1.4.0 logger.go:42: 09:42:52 | users/5-write-data | +++ PGOV1_TAG=1.4.0 logger.go:42: 09:42:52 | users/5-write-data | +++ export PGOV1_VER=14 logger.go:42: 09:42:52 | users/5-write-data | +++ PGOV1_VER=14 logger.go:42: 09:42:52 | users/5-write-data | ++++ which gdate logger.go:42: 09:42:52 | users/5-write-data | which: no gdate in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:42:52 | users/5-write-data | ++++ which date logger.go:42: 09:42:52 | users/5-write-data | +++ date=/usr/bin/date logger.go:42: 09:42:52 | users/5-write-data | ++++ which gsed logger.go:42: 09:42:52 | users/5-write-data | which: no gsed in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:42:52 | users/5-write-data | ++++ which sed logger.go:42: 09:42:52 | users/5-write-data | +++ sed=/usr/bin/sed logger.go:42: 09:42:52 | users/5-write-data | +++ command -v oc logger.go:42: 09:42:52 | users/5-write-data | ++ oc get projects logger.go:42: 09:42:52 | users/5-write-data | ++ get_psql_user_host users-pguser-postgres logger.go:42: 09:42:52 | users/5-write-data | ++ local secret_name=users-pguser-postgres logger.go:42: 09:42:52 | users/5-write-data | ++ kubectl -n kuttl-test-great-dove get secret/users-pguser-postgres '--template={{.data.host | base64decode }}' logger.go:42: 09:42:52 | users/5-write-data | + run_psql_local '\c myapp \\\ INSERT INTO myApp (id) VALUES (100501)' postgres:default-db-password@users-primary.kuttl-test-great-dove.svc logger.go:42: 09:42:52 | users/5-write-data | + local 'command=\c myapp \\\ INSERT INTO myApp (id) VALUES (100501)' logger.go:42: 09:42:52 | users/5-write-data | + local uri=postgres:default-db-password@users-primary.kuttl-test-great-dove.svc logger.go:42: 09:42:52 | users/5-write-data | + local driver=postgres logger.go:42: 09:42:52 | users/5-write-data | ++ get_client_pod logger.go:42: 09:42:52 | users/5-write-data | ++ kubectl -n kuttl-test-great-dove get pods --selector=name=pg-client -o 'jsonpath={.items[].metadata.name}' logger.go:42: 09:42:53 | users/5-write-data | + kubectl -n kuttl-test-great-dove exec pg-client-84d6c45668-s5nx8 -- bash -c 'printf '\''\c myapp \\\ INSERT INTO myApp (id) VALUES (100501)\n'\'' | psql -v ON_ERROR_STOP=1 -t -q postgres://'\''postgres:default-db-password@users-primary.kuttl-test-great-dove.svc'\''' logger.go:42: 09:42:53 | users/5-write-data | test step completed 5-write-data logger.go:42: 09:42:53 | users/6-read-from-primary | starting test step 6-read-from-primary logger.go:42: 09:42:53 | users/6-read-from-primary | running command: [sh -c set -o errexit set -o xtrace source ../../functions data=$(run_psql_local '\c myapp \\\ SELECT * from myApp;' "postgres:default-db-password@$(get_psql_user_host users-pguser-postgres)") kubectl create configmap -n "${NAMESPACE}" 06-read-from-primary --from-literal=data="${data}" kubectl get configmap -n "${NAMESPACE}" 06-read-from-primary -o yaml] logger.go:42: 09:42:53 | users/6-read-from-primary | + source ../../functions logger.go:42: 09:42:53 | users/6-read-from-primary | +++ realpath ../../.. logger.go:42: 09:42:53 | users/6-read-from-primary | ++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:42:53 | users/6-read-from-primary | ++ CERT_MANAGER_VER=1.17.1 logger.go:42: 09:42:53 | users/6-read-from-primary | ++++ pwd logger.go:42: 09:42:53 | users/6-read-from-primary | +++ basename /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/tests/users logger.go:42: 09:42:53 | users/6-read-from-primary | ++ test_name=users logger.go:42: 09:42:53 | users/6-read-from-primary | ++ source /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/vars.sh logger.go:42: 09:42:53 | users/6-read-from-primary | +++ export ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:42:53 | users/6-read-from-primary | +++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:42:53 | users/6-read-from-primary | +++ export DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:42:53 | users/6-read-from-primary | +++ DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:42:53 | users/6-read-from-primary | +++ export TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:42:53 | users/6-read-from-primary | +++ TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:42:53 | users/6-read-from-primary | +++ export TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:42:53 | users/6-read-from-primary | +++ TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:42:53 | users/6-read-from-primary | +++ export TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:42:53 | users/6-read-from-primary | +++ TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:42:53 | users/6-read-from-primary | ++++ git rev-parse --abbrev-ref HEAD logger.go:42: 09:42:53 | users/6-read-from-primary | +++ export GIT_BRANCH=PR-1165 logger.go:42: 09:42:53 | users/6-read-from-primary | +++ GIT_BRANCH=PR-1165 logger.go:42: 09:42:53 | users/6-read-from-primary | +++ export VERSION=PR-1165-9f6804715 logger.go:42: 09:42:53 | users/6-read-from-primary | +++ VERSION=PR-1165-9f6804715 logger.go:42: 09:42:53 | users/6-read-from-primary | +++ export IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:42:53 | users/6-read-from-primary | +++ IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:42:53 | users/6-read-from-primary | +++ export IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:42:53 | users/6-read-from-primary | +++ IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:42:53 | users/6-read-from-primary | +++ export PG_VER=17 logger.go:42: 09:42:53 | users/6-read-from-primary | +++ PG_VER=17 logger.go:42: 09:42:53 | users/6-read-from-primary | +++ export IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:42:53 | users/6-read-from-primary | +++ IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:42:53 | users/6-read-from-primary | +++ export IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:42:53 | users/6-read-from-primary | +++ IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:42:53 | users/6-read-from-primary | +++ export IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:42:53 | users/6-read-from-primary | +++ IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:42:53 | users/6-read-from-primary | +++ export IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:42:53 | users/6-read-from-primary | +++ IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:42:53 | users/6-read-from-primary | +++ export BUCKET=pg-operator-testing logger.go:42: 09:42:53 | users/6-read-from-primary | +++ BUCKET=pg-operator-testing logger.go:42: 09:42:53 | users/6-read-from-primary | +++ export PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:42:53 | users/6-read-from-primary | +++ PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:42:53 | users/6-read-from-primary | +++ export IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:42:53 | users/6-read-from-primary | +++ IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:42:53 | users/6-read-from-primary | +++ export IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:42:53 | users/6-read-from-primary | +++ IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:42:53 | users/6-read-from-primary | +++ export IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:42:53 | users/6-read-from-primary | +++ IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:42:53 | users/6-read-from-primary | +++ export IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:42:53 | users/6-read-from-primary | +++ IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:42:53 | users/6-read-from-primary | +++ export PGOV1_TAG=1.4.0 logger.go:42: 09:42:53 | users/6-read-from-primary | +++ PGOV1_TAG=1.4.0 logger.go:42: 09:42:53 | users/6-read-from-primary | +++ export PGOV1_VER=14 logger.go:42: 09:42:53 | users/6-read-from-primary | +++ PGOV1_VER=14 logger.go:42: 09:42:53 | users/6-read-from-primary | ++++ which gdate logger.go:42: 09:42:53 | users/6-read-from-primary | which: no gdate in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:42:53 | users/6-read-from-primary | ++++ which date logger.go:42: 09:42:53 | users/6-read-from-primary | +++ date=/usr/bin/date logger.go:42: 09:42:53 | users/6-read-from-primary | ++++ which gsed logger.go:42: 09:42:53 | users/6-read-from-primary | which: no gsed in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:42:53 | users/6-read-from-primary | ++++ which sed logger.go:42: 09:42:53 | users/6-read-from-primary | +++ sed=/usr/bin/sed logger.go:42: 09:42:53 | users/6-read-from-primary | +++ command -v oc logger.go:42: 09:42:53 | users/6-read-from-primary | ++ oc get projects logger.go:42: 09:42:53 | users/6-read-from-primary | +++ get_psql_user_host users-pguser-postgres logger.go:42: 09:42:53 | users/6-read-from-primary | +++ local secret_name=users-pguser-postgres logger.go:42: 09:42:53 | users/6-read-from-primary | +++ kubectl -n kuttl-test-great-dove get secret/users-pguser-postgres '--template={{.data.host | base64decode }}' logger.go:42: 09:42:54 | users/6-read-from-primary | ++ run_psql_local '\c myapp \\\ SELECT * from myApp;' postgres:default-db-password@users-primary.kuttl-test-great-dove.svc logger.go:42: 09:42:54 | users/6-read-from-primary | ++ local 'command=\c myapp \\\ SELECT * from myApp;' logger.go:42: 09:42:54 | users/6-read-from-primary | ++ local uri=postgres:default-db-password@users-primary.kuttl-test-great-dove.svc logger.go:42: 09:42:54 | users/6-read-from-primary | ++ local driver=postgres logger.go:42: 09:42:54 | users/6-read-from-primary | +++ get_client_pod logger.go:42: 09:42:54 | users/6-read-from-primary | +++ kubectl -n kuttl-test-great-dove get pods --selector=name=pg-client -o 'jsonpath={.items[].metadata.name}' logger.go:42: 09:42:54 | users/6-read-from-primary | ++ kubectl -n kuttl-test-great-dove exec pg-client-84d6c45668-s5nx8 -- bash -c 'printf '\''\c myapp \\\ SELECT * from myApp;\n'\'' | psql -v ON_ERROR_STOP=1 -t -q postgres://'\''postgres:default-db-password@users-primary.kuttl-test-great-dove.svc'\''' logger.go:42: 09:42:55 | users/6-read-from-primary | + data=' 100500 logger.go:42: 09:42:55 | users/6-read-from-primary | 100501' logger.go:42: 09:42:55 | users/6-read-from-primary | + kubectl create configmap -n kuttl-test-great-dove 06-read-from-primary '--from-literal=data= 100500 logger.go:42: 09:42:55 | users/6-read-from-primary | 100501' logger.go:42: 09:42:55 | users/6-read-from-primary | configmap/06-read-from-primary created logger.go:42: 09:42:55 | users/6-read-from-primary | + kubectl get configmap -n kuttl-test-great-dove 06-read-from-primary -o yaml logger.go:42: 09:42:56 | users/6-read-from-primary | apiVersion: v1 logger.go:42: 09:42:56 | users/6-read-from-primary | data: logger.go:42: 09:42:56 | users/6-read-from-primary | data: |2- logger.go:42: 09:42:56 | users/6-read-from-primary | 100500 logger.go:42: 09:42:56 | users/6-read-from-primary | 100501 logger.go:42: 09:42:56 | users/6-read-from-primary | kind: ConfigMap logger.go:42: 09:42:56 | users/6-read-from-primary | metadata: logger.go:42: 09:42:56 | users/6-read-from-primary | creationTimestamp: "2025-06-05T09:42:55Z" logger.go:42: 09:42:56 | users/6-read-from-primary | name: 06-read-from-primary logger.go:42: 09:42:56 | users/6-read-from-primary | namespace: kuttl-test-great-dove logger.go:42: 09:42:56 | users/6-read-from-primary | resourceVersion: "46311" logger.go:42: 09:42:56 | users/6-read-from-primary | uid: e6f7698f-97dd-49cd-8b60-51e452207476 logger.go:42: 09:42:56 | users/6-read-from-primary | test step completed 6-read-from-primary logger.go:42: 09:42:56 | users/7-add-custom-user | starting test step 7-add-custom-user logger.go:42: 09:42:56 | users/7-add-custom-user | running command: [sh -c set -o errexit set -o xtrace source ../../functions kubectl -n ${NAMESPACE} patch perconapgcluster/${test_name} --type=json -p '[{"op":"add", "path":"/spec/autoCreateUserSchema","value":true},{"op":"add", "path":"/spec/users","value":[{"name":"rhino","databases":["zoo"],"password":{"type":"ASCII"},"secretName":"rhino-credentials"}]}]' sleep 10] logger.go:42: 09:42:56 | users/7-add-custom-user | + source ../../functions logger.go:42: 09:42:56 | users/7-add-custom-user | +++ realpath ../../.. logger.go:42: 09:42:56 | users/7-add-custom-user | ++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:42:56 | users/7-add-custom-user | ++ CERT_MANAGER_VER=1.17.1 logger.go:42: 09:42:56 | users/7-add-custom-user | ++++ pwd logger.go:42: 09:42:56 | users/7-add-custom-user | +++ basename /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/tests/users logger.go:42: 09:42:56 | users/7-add-custom-user | ++ test_name=users logger.go:42: 09:42:56 | users/7-add-custom-user | ++ source /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/vars.sh logger.go:42: 09:42:56 | users/7-add-custom-user | +++ export ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:42:56 | users/7-add-custom-user | +++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:42:56 | users/7-add-custom-user | +++ export DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:42:56 | users/7-add-custom-user | +++ DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:42:56 | users/7-add-custom-user | +++ export TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:42:56 | users/7-add-custom-user | +++ TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:42:56 | users/7-add-custom-user | +++ export TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:42:56 | users/7-add-custom-user | +++ TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:42:56 | users/7-add-custom-user | +++ export TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:42:56 | users/7-add-custom-user | +++ TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:42:56 | users/7-add-custom-user | ++++ git rev-parse --abbrev-ref HEAD logger.go:42: 09:42:56 | users/7-add-custom-user | +++ export GIT_BRANCH=PR-1165 logger.go:42: 09:42:56 | users/7-add-custom-user | +++ GIT_BRANCH=PR-1165 logger.go:42: 09:42:56 | users/7-add-custom-user | +++ export VERSION=PR-1165-9f6804715 logger.go:42: 09:42:56 | users/7-add-custom-user | +++ VERSION=PR-1165-9f6804715 logger.go:42: 09:42:56 | users/7-add-custom-user | +++ export IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:42:56 | users/7-add-custom-user | +++ IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:42:56 | users/7-add-custom-user | +++ export IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:42:56 | users/7-add-custom-user | +++ IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:42:56 | users/7-add-custom-user | +++ export PG_VER=17 logger.go:42: 09:42:56 | users/7-add-custom-user | +++ PG_VER=17 logger.go:42: 09:42:56 | users/7-add-custom-user | +++ export IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:42:56 | users/7-add-custom-user | +++ IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:42:56 | users/7-add-custom-user | +++ export IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:42:56 | users/7-add-custom-user | +++ IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:42:56 | users/7-add-custom-user | +++ export IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:42:56 | users/7-add-custom-user | +++ IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:42:56 | users/7-add-custom-user | +++ export IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:42:56 | users/7-add-custom-user | +++ IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:42:56 | users/7-add-custom-user | +++ export BUCKET=pg-operator-testing logger.go:42: 09:42:56 | users/7-add-custom-user | +++ BUCKET=pg-operator-testing logger.go:42: 09:42:56 | users/7-add-custom-user | +++ export PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:42:56 | users/7-add-custom-user | +++ PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:42:56 | users/7-add-custom-user | +++ export IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:42:56 | users/7-add-custom-user | +++ IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:42:56 | users/7-add-custom-user | +++ export IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:42:56 | users/7-add-custom-user | +++ IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:42:56 | users/7-add-custom-user | +++ export IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:42:56 | users/7-add-custom-user | +++ IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:42:56 | users/7-add-custom-user | +++ export IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:42:56 | users/7-add-custom-user | +++ IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:42:56 | users/7-add-custom-user | +++ export PGOV1_TAG=1.4.0 logger.go:42: 09:42:56 | users/7-add-custom-user | +++ PGOV1_TAG=1.4.0 logger.go:42: 09:42:56 | users/7-add-custom-user | +++ export PGOV1_VER=14 logger.go:42: 09:42:56 | users/7-add-custom-user | +++ PGOV1_VER=14 logger.go:42: 09:42:56 | users/7-add-custom-user | ++++ which gdate logger.go:42: 09:42:56 | users/7-add-custom-user | which: no gdate in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:42:56 | users/7-add-custom-user | ++++ which date logger.go:42: 09:42:56 | users/7-add-custom-user | +++ date=/usr/bin/date logger.go:42: 09:42:56 | users/7-add-custom-user | ++++ which gsed logger.go:42: 09:42:56 | users/7-add-custom-user | which: no gsed in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:42:56 | users/7-add-custom-user | ++++ which sed logger.go:42: 09:42:56 | users/7-add-custom-user | +++ sed=/usr/bin/sed logger.go:42: 09:42:56 | users/7-add-custom-user | +++ command -v oc logger.go:42: 09:42:56 | users/7-add-custom-user | ++ oc get projects logger.go:42: 09:42:56 | users/7-add-custom-user | + kubectl -n kuttl-test-great-dove patch perconapgcluster/users --type=json -p '[{"op":"add", "path":"/spec/autoCreateUserSchema","value":true},{"op":"add", "path":"/spec/users","value":[{"name":"rhino","databases":["zoo"],"password":{"type":"ASCII"},"secretName":"rhino-credentials"}]}]' logger.go:42: 09:42:57 | users/7-add-custom-user | perconapgcluster.pgv2.percona.com/users patched logger.go:42: 09:42:57 | users/7-add-custom-user | + sleep 10 logger.go:42: 09:43:07 | users/7-add-custom-user | test step completed 7-add-custom-user logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | starting test step 8-write-data-to-custom-db logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | running command: [sh -c set -o errexit set -o xtrace source ../../functions password=$(get_psql_user_pass rhino-credentials) user='rhino' db_name='zoo' schema='rhino' hostname=$(get_pgbouncer_host rhino-credentials) run_psql \ 'CREATE TABLE IF NOT EXISTS customApp (id int PRIMARY KEY);' \ "-h $hostname -U $user -d $db_name" "$password" run_psql \ "INSERT INTO $schema.customApp (id) VALUES (100500)" \ "-h $hostname -U $user -d $db_name" "$password" ] logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | + source ../../functions logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ realpath ../../.. logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | ++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | ++ CERT_MANAGER_VER=1.17.1 logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | ++++ pwd logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ basename /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/tests/users logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | ++ test_name=users logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | ++ source /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/vars.sh logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ export ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ export DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ export TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ export TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ export TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | ++++ git rev-parse --abbrev-ref HEAD logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ export GIT_BRANCH=PR-1165 logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ GIT_BRANCH=PR-1165 logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ export VERSION=PR-1165-9f6804715 logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ VERSION=PR-1165-9f6804715 logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ export IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ export IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ export PG_VER=17 logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ PG_VER=17 logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ export IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ export IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ export IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ export IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ export BUCKET=pg-operator-testing logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ BUCKET=pg-operator-testing logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ export PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ export IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ export IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ export IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ export IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ export PGOV1_TAG=1.4.0 logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ PGOV1_TAG=1.4.0 logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ export PGOV1_VER=14 logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ PGOV1_VER=14 logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | ++++ which gdate logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | which: no gdate in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | ++++ which date logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ date=/usr/bin/date logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | ++++ which gsed logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | which: no gsed in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | ++++ which sed logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ sed=/usr/bin/sed logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | +++ command -v oc logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | ++ oc get projects logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | ++ get_psql_user_pass rhino-credentials logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | ++ local secret_name=rhino-credentials logger.go:42: 09:43:07 | users/8-write-data-to-custom-db | ++ kubectl -n kuttl-test-great-dove get secret/rhino-credentials '--template={{.data.password | base64decode}}' logger.go:42: 09:43:08 | users/8-write-data-to-custom-db | + password='pGO()EFajkPe+2D*AL=)hJj_' logger.go:42: 09:43:08 | users/8-write-data-to-custom-db | + user=rhino logger.go:42: 09:43:08 | users/8-write-data-to-custom-db | + db_name=zoo logger.go:42: 09:43:08 | users/8-write-data-to-custom-db | + schema=rhino logger.go:42: 09:43:08 | users/8-write-data-to-custom-db | ++ get_pgbouncer_host rhino-credentials logger.go:42: 09:43:08 | users/8-write-data-to-custom-db | ++ local secret_name=rhino-credentials logger.go:42: 09:43:08 | users/8-write-data-to-custom-db | ++ kubectl -n kuttl-test-great-dove get secret/rhino-credentials -o 'jsonpath={.data.pgbouncer-host}' logger.go:42: 09:43:08 | users/8-write-data-to-custom-db | ++ base64 -d logger.go:42: 09:43:08 | users/8-write-data-to-custom-db | + hostname=users-pgbouncer.kuttl-test-great-dove.svc logger.go:42: 09:43:08 | users/8-write-data-to-custom-db | + run_psql 'CREATE TABLE IF NOT EXISTS customApp (id int PRIMARY KEY);' '-h users-pgbouncer.kuttl-test-great-dove.svc -U rhino -d zoo' 'pGO()EFajkPe+2D*AL=)hJj_' logger.go:42: 09:43:08 | users/8-write-data-to-custom-db | + local 'command=CREATE TABLE IF NOT EXISTS customApp (id int PRIMARY KEY);' logger.go:42: 09:43:08 | users/8-write-data-to-custom-db | + local 'uri=-h users-pgbouncer.kuttl-test-great-dove.svc -U rhino -d zoo' logger.go:42: 09:43:08 | users/8-write-data-to-custom-db | + local 'password=pGO()EFajkPe+2D*AL=)hJj_' logger.go:42: 09:43:08 | users/8-write-data-to-custom-db | ++ get_client_pod logger.go:42: 09:43:08 | users/8-write-data-to-custom-db | ++ kubectl -n kuttl-test-great-dove get pods --selector=name=pg-client -o 'jsonpath={.items[].metadata.name}' logger.go:42: 09:43:09 | users/8-write-data-to-custom-db | + kubectl -n kuttl-test-great-dove exec pg-client-84d6c45668-s5nx8 -- bash -c 'printf '\''CREATE TABLE IF NOT EXISTS customApp (id int PRIMARY KEY);\n'\'' | PGPASSWORD='\''pGO()EFajkPe+2D*AL=)hJj_'\'' psql -v ON_ERROR_STOP=1 -t -q -h users-pgbouncer.kuttl-test-great-dove.svc -U rhino -d zoo' logger.go:42: 09:43:09 | users/8-write-data-to-custom-db | + run_psql 'INSERT INTO rhino.customApp (id) VALUES (100500)' '-h users-pgbouncer.kuttl-test-great-dove.svc -U rhino -d zoo' 'pGO()EFajkPe+2D*AL=)hJj_' logger.go:42: 09:43:09 | users/8-write-data-to-custom-db | + local 'command=INSERT INTO rhino.customApp (id) VALUES (100500)' logger.go:42: 09:43:09 | users/8-write-data-to-custom-db | + local 'uri=-h users-pgbouncer.kuttl-test-great-dove.svc -U rhino -d zoo' logger.go:42: 09:43:09 | users/8-write-data-to-custom-db | + local 'password=pGO()EFajkPe+2D*AL=)hJj_' logger.go:42: 09:43:09 | users/8-write-data-to-custom-db | ++ get_client_pod logger.go:42: 09:43:09 | users/8-write-data-to-custom-db | ++ kubectl -n kuttl-test-great-dove get pods --selector=name=pg-client -o 'jsonpath={.items[].metadata.name}' logger.go:42: 09:43:10 | users/8-write-data-to-custom-db | + kubectl -n kuttl-test-great-dove exec pg-client-84d6c45668-s5nx8 -- bash -c 'printf '\''INSERT INTO rhino.customApp (id) VALUES (100500)\n'\'' | PGPASSWORD='\''pGO()EFajkPe+2D*AL=)hJj_'\'' psql -v ON_ERROR_STOP=1 -t -q -h users-pgbouncer.kuttl-test-great-dove.svc -U rhino -d zoo' logger.go:42: 09:43:11 | users/8-write-data-to-custom-db | test step completed 8-write-data-to-custom-db logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | starting test step 9-read-from-primary-custom-db logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | running command: [sh -c set -o errexit set -o xtrace source ../../functions password=$(get_psql_user_pass rhino-credentials) user='rhino' db_name='zoo' schema='rhino' hostname=$(get_pgbouncer_host rhino-credentials) data=$(run_psql "SELECT * from $schema.customApp;" "-h $hostname -U $user -d $db_name" "$password") kubectl create configmap -n "${NAMESPACE}" 09-read-from-primary-custom-db --from-literal=data="${data}"] logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | + source ../../functions logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ realpath ../../.. logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | ++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | ++ CERT_MANAGER_VER=1.17.1 logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | ++++ pwd logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ basename /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/tests/users logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | ++ test_name=users logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | ++ source /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/vars.sh logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ export ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ export DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ export TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ export TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ export TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | ++++ git rev-parse --abbrev-ref HEAD logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ export GIT_BRANCH=PR-1165 logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ GIT_BRANCH=PR-1165 logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ export VERSION=PR-1165-9f6804715 logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ VERSION=PR-1165-9f6804715 logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ export IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ export IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ export PG_VER=17 logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ PG_VER=17 logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ export IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ export IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ export IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ export IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ export BUCKET=pg-operator-testing logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ BUCKET=pg-operator-testing logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ export PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ export IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ export IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ export IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ export IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ export PGOV1_TAG=1.4.0 logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ PGOV1_TAG=1.4.0 logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ export PGOV1_VER=14 logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ PGOV1_VER=14 logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | ++++ which gdate logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | which: no gdate in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | ++++ which date logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ date=/usr/bin/date logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | ++++ which gsed logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | which: no gsed in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | ++++ which sed logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ sed=/usr/bin/sed logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | +++ command -v oc logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | ++ oc get projects logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | ++ get_psql_user_pass rhino-credentials logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | ++ local secret_name=rhino-credentials logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | ++ kubectl -n kuttl-test-great-dove get secret/rhino-credentials '--template={{.data.password | base64decode}}' logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | + password='pGO()EFajkPe+2D*AL=)hJj_' logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | + user=rhino logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | + db_name=zoo logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | + schema=rhino logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | ++ get_pgbouncer_host rhino-credentials logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | ++ local secret_name=rhino-credentials logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | ++ kubectl -n kuttl-test-great-dove get secret/rhino-credentials -o 'jsonpath={.data.pgbouncer-host}' logger.go:42: 09:43:11 | users/9-read-from-primary-custom-db | ++ base64 -d logger.go:42: 09:43:12 | users/9-read-from-primary-custom-db | + hostname=users-pgbouncer.kuttl-test-great-dove.svc logger.go:42: 09:43:12 | users/9-read-from-primary-custom-db | ++ run_psql 'SELECT * from rhino.customApp;' '-h users-pgbouncer.kuttl-test-great-dove.svc -U rhino -d zoo' 'pGO()EFajkPe+2D*AL=)hJj_' logger.go:42: 09:43:12 | users/9-read-from-primary-custom-db | ++ local 'command=SELECT * from rhino.customApp;' logger.go:42: 09:43:12 | users/9-read-from-primary-custom-db | ++ local 'uri=-h users-pgbouncer.kuttl-test-great-dove.svc -U rhino -d zoo' logger.go:42: 09:43:12 | users/9-read-from-primary-custom-db | ++ local 'password=pGO()EFajkPe+2D*AL=)hJj_' logger.go:42: 09:43:12 | users/9-read-from-primary-custom-db | +++ get_client_pod logger.go:42: 09:43:12 | users/9-read-from-primary-custom-db | +++ kubectl -n kuttl-test-great-dove get pods --selector=name=pg-client -o 'jsonpath={.items[].metadata.name}' logger.go:42: 09:43:12 | users/9-read-from-primary-custom-db | ++ kubectl -n kuttl-test-great-dove exec pg-client-84d6c45668-s5nx8 -- bash -c 'printf '\''SELECT * from rhino.customApp;\n'\'' | PGPASSWORD='\''pGO()EFajkPe+2D*AL=)hJj_'\'' psql -v ON_ERROR_STOP=1 -t -q -h users-pgbouncer.kuttl-test-great-dove.svc -U rhino -d zoo' logger.go:42: 09:43:13 | users/9-read-from-primary-custom-db | + data=' 100500' logger.go:42: 09:43:13 | users/9-read-from-primary-custom-db | + kubectl create configmap -n kuttl-test-great-dove 09-read-from-primary-custom-db '--from-literal=data= 100500' logger.go:42: 09:43:13 | users/9-read-from-primary-custom-db | configmap/09-read-from-primary-custom-db created logger.go:42: 09:43:14 | users/9-read-from-primary-custom-db | test step completed 9-read-from-primary-custom-db logger.go:42: 09:43:14 | users/10-update-custom-user-password | starting test step 10-update-custom-user-password logger.go:42: 09:43:14 | users/10-update-custom-user-password | running command: [sh -c set -o errexit set -o xtrace source ../../functions kubectl -n ${NAMESPACE} patch secret rhino-credentials --type merge --patch '{"stringData": {"password": "custom-db-password","verifier":""}}' sleep 5] logger.go:42: 09:43:14 | users/10-update-custom-user-password | + source ../../functions logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ realpath ../../.. logger.go:42: 09:43:14 | users/10-update-custom-user-password | ++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:43:14 | users/10-update-custom-user-password | ++ CERT_MANAGER_VER=1.17.1 logger.go:42: 09:43:14 | users/10-update-custom-user-password | ++++ pwd logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ basename /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/tests/users logger.go:42: 09:43:14 | users/10-update-custom-user-password | ++ test_name=users logger.go:42: 09:43:14 | users/10-update-custom-user-password | ++ source /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/vars.sh logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ export ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ export DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ export TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ export TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ export TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:43:14 | users/10-update-custom-user-password | ++++ git rev-parse --abbrev-ref HEAD logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ export GIT_BRANCH=PR-1165 logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ GIT_BRANCH=PR-1165 logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ export VERSION=PR-1165-9f6804715 logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ VERSION=PR-1165-9f6804715 logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ export IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ export IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ export PG_VER=17 logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ PG_VER=17 logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ export IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ export IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ export IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ export IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ export BUCKET=pg-operator-testing logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ BUCKET=pg-operator-testing logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ export PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ export IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ export IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ export IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ export IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ export PGOV1_TAG=1.4.0 logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ PGOV1_TAG=1.4.0 logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ export PGOV1_VER=14 logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ PGOV1_VER=14 logger.go:42: 09:43:14 | users/10-update-custom-user-password | ++++ which gdate logger.go:42: 09:43:14 | users/10-update-custom-user-password | which: no gdate in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:43:14 | users/10-update-custom-user-password | ++++ which date logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ date=/usr/bin/date logger.go:42: 09:43:14 | users/10-update-custom-user-password | ++++ which gsed logger.go:42: 09:43:14 | users/10-update-custom-user-password | which: no gsed in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:43:14 | users/10-update-custom-user-password | ++++ which sed logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ sed=/usr/bin/sed logger.go:42: 09:43:14 | users/10-update-custom-user-password | +++ command -v oc logger.go:42: 09:43:14 | users/10-update-custom-user-password | ++ oc get projects logger.go:42: 09:43:14 | users/10-update-custom-user-password | + kubectl -n kuttl-test-great-dove patch secret rhino-credentials --type merge --patch '{"stringData": {"password": "custom-db-password","verifier":""}}' logger.go:42: 09:43:14 | users/10-update-custom-user-password | secret/rhino-credentials patched logger.go:42: 09:43:14 | users/10-update-custom-user-password | + sleep 5 logger.go:42: 09:43:19 | users/10-update-custom-user-password | test step completed 10-update-custom-user-password logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | starting test step 11-write-data-to-custom-db logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | running command: [sh -c set -o errexit set -o xtrace source ../../functions password=$(get_psql_user_pass rhino-credentials) user='rhino' db_name='zoo' schema='rhino' hostname=$(get_pgbouncer_host rhino-credentials) run_psql \ "INSERT INTO $schema.customApp (id) VALUES (100501)" \ "-h $hostname -U $user -d $db_name" "$password"] logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | + source ../../functions logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ realpath ../../.. logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | ++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | ++ CERT_MANAGER_VER=1.17.1 logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | ++++ pwd logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ basename /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/tests/users logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | ++ test_name=users logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | ++ source /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/vars.sh logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ export ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ export DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ export TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ export TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ export TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | ++++ git rev-parse --abbrev-ref HEAD logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ export GIT_BRANCH=PR-1165 logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ GIT_BRANCH=PR-1165 logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ export VERSION=PR-1165-9f6804715 logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ VERSION=PR-1165-9f6804715 logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ export IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ export IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ export PG_VER=17 logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ PG_VER=17 logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ export IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ export IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ export IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ export IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ export BUCKET=pg-operator-testing logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ BUCKET=pg-operator-testing logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ export PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ export IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ export IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ export IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ export IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ export PGOV1_TAG=1.4.0 logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ PGOV1_TAG=1.4.0 logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ export PGOV1_VER=14 logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ PGOV1_VER=14 logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | ++++ which gdate logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | which: no gdate in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | ++++ which date logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ date=/usr/bin/date logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | ++++ which gsed logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | which: no gsed in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | ++++ which sed logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ sed=/usr/bin/sed logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | +++ command -v oc logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | ++ oc get projects logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | ++ get_psql_user_pass rhino-credentials logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | ++ local secret_name=rhino-credentials logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | ++ kubectl -n kuttl-test-great-dove get secret/rhino-credentials '--template={{.data.password | base64decode}}' logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | + password=custom-db-password logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | + user=rhino logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | + db_name=zoo logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | + schema=rhino logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | ++ get_pgbouncer_host rhino-credentials logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | ++ local secret_name=rhino-credentials logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | ++ kubectl -n kuttl-test-great-dove get secret/rhino-credentials -o 'jsonpath={.data.pgbouncer-host}' logger.go:42: 09:43:19 | users/11-write-data-to-custom-db | ++ base64 -d logger.go:42: 09:43:20 | users/11-write-data-to-custom-db | + hostname=users-pgbouncer.kuttl-test-great-dove.svc logger.go:42: 09:43:20 | users/11-write-data-to-custom-db | + run_psql 'INSERT INTO rhino.customApp (id) VALUES (100501)' '-h users-pgbouncer.kuttl-test-great-dove.svc -U rhino -d zoo' custom-db-password logger.go:42: 09:43:20 | users/11-write-data-to-custom-db | + local 'command=INSERT INTO rhino.customApp (id) VALUES (100501)' logger.go:42: 09:43:20 | users/11-write-data-to-custom-db | + local 'uri=-h users-pgbouncer.kuttl-test-great-dove.svc -U rhino -d zoo' logger.go:42: 09:43:20 | users/11-write-data-to-custom-db | + local password=custom-db-password logger.go:42: 09:43:20 | users/11-write-data-to-custom-db | ++ get_client_pod logger.go:42: 09:43:20 | users/11-write-data-to-custom-db | ++ kubectl -n kuttl-test-great-dove get pods --selector=name=pg-client -o 'jsonpath={.items[].metadata.name}' logger.go:42: 09:43:20 | users/11-write-data-to-custom-db | + kubectl -n kuttl-test-great-dove exec pg-client-84d6c45668-s5nx8 -- bash -c 'printf '\''INSERT INTO rhino.customApp (id) VALUES (100501)\n'\'' | PGPASSWORD='\''custom-db-password'\'' psql -v ON_ERROR_STOP=1 -t -q -h users-pgbouncer.kuttl-test-great-dove.svc -U rhino -d zoo' logger.go:42: 09:43:21 | users/11-write-data-to-custom-db | test step completed 11-write-data-to-custom-db logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | starting test step 12-read-from-primary-custom-db logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | running command: [sh -c set -o errexit set -o xtrace source ../../functions password=$(get_psql_user_pass rhino-credentials) user='rhino' db_name='zoo' schema='rhino' hostname=$(get_pgbouncer_host rhino-credentials) data=$(run_psql "SELECT * from $schema.customApp;" "-h $hostname -U $user -d $db_name" "$password") kubectl create configmap -n "${NAMESPACE}" 12-read-from-primary-custom-db --from-literal=data="${data}"] logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | + source ../../functions logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ realpath ../../.. logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | ++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | ++ CERT_MANAGER_VER=1.17.1 logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | ++++ pwd logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ basename /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/tests/users logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | ++ test_name=users logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | ++ source /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/vars.sh logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ export ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ export DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ export TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ export TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ export TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | ++++ git rev-parse --abbrev-ref HEAD logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ export GIT_BRANCH=PR-1165 logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ GIT_BRANCH=PR-1165 logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ export VERSION=PR-1165-9f6804715 logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ VERSION=PR-1165-9f6804715 logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ export IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ export IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ export PG_VER=17 logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ PG_VER=17 logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ export IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ export IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ export IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ export IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ export BUCKET=pg-operator-testing logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ BUCKET=pg-operator-testing logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ export PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ export IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ export IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ export IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ export IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ export PGOV1_TAG=1.4.0 logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ PGOV1_TAG=1.4.0 logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ export PGOV1_VER=14 logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ PGOV1_VER=14 logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | ++++ which gdate logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | which: no gdate in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | ++++ which date logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ date=/usr/bin/date logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | ++++ which gsed logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | which: no gsed in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | ++++ which sed logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ sed=/usr/bin/sed logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | +++ command -v oc logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | ++ oc get projects logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | ++ get_psql_user_pass rhino-credentials logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | ++ local secret_name=rhino-credentials logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | ++ kubectl -n kuttl-test-great-dove get secret/rhino-credentials '--template={{.data.password | base64decode}}' logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | + password=custom-db-password logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | + user=rhino logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | + db_name=zoo logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | + schema=rhino logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | ++ get_pgbouncer_host rhino-credentials logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | ++ local secret_name=rhino-credentials logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | ++ kubectl -n kuttl-test-great-dove get secret/rhino-credentials -o 'jsonpath={.data.pgbouncer-host}' logger.go:42: 09:43:21 | users/12-read-from-primary-custom-db | ++ base64 -d logger.go:42: 09:43:22 | users/12-read-from-primary-custom-db | + hostname=users-pgbouncer.kuttl-test-great-dove.svc logger.go:42: 09:43:22 | users/12-read-from-primary-custom-db | ++ run_psql 'SELECT * from rhino.customApp;' '-h users-pgbouncer.kuttl-test-great-dove.svc -U rhino -d zoo' custom-db-password logger.go:42: 09:43:22 | users/12-read-from-primary-custom-db | ++ local 'command=SELECT * from rhino.customApp;' logger.go:42: 09:43:22 | users/12-read-from-primary-custom-db | ++ local 'uri=-h users-pgbouncer.kuttl-test-great-dove.svc -U rhino -d zoo' logger.go:42: 09:43:22 | users/12-read-from-primary-custom-db | ++ local password=custom-db-password logger.go:42: 09:43:22 | users/12-read-from-primary-custom-db | +++ get_client_pod logger.go:42: 09:43:22 | users/12-read-from-primary-custom-db | +++ kubectl -n kuttl-test-great-dove get pods --selector=name=pg-client -o 'jsonpath={.items[].metadata.name}' logger.go:42: 09:43:22 | users/12-read-from-primary-custom-db | ++ kubectl -n kuttl-test-great-dove exec pg-client-84d6c45668-s5nx8 -- bash -c 'printf '\''SELECT * from rhino.customApp;\n'\'' | PGPASSWORD='\''custom-db-password'\'' psql -v ON_ERROR_STOP=1 -t -q -h users-pgbouncer.kuttl-test-great-dove.svc -U rhino -d zoo' logger.go:42: 09:43:23 | users/12-read-from-primary-custom-db | + data=' 100500 logger.go:42: 09:43:23 | users/12-read-from-primary-custom-db | 100501' logger.go:42: 09:43:23 | users/12-read-from-primary-custom-db | + kubectl create configmap -n kuttl-test-great-dove 12-read-from-primary-custom-db '--from-literal=data= 100500 logger.go:42: 09:43:23 | users/12-read-from-primary-custom-db | 100501' logger.go:42: 09:43:23 | users/12-read-from-primary-custom-db | configmap/12-read-from-primary-custom-db created logger.go:42: 09:43:24 | users/12-read-from-primary-custom-db | test step completed 12-read-from-primary-custom-db logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | starting test step 13-add-custom-user-with-public-schema-access logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | running command: [sh -c set -o errexit set -o xtrace source ../../functions kubectl -n ${NAMESPACE} patch perconapgcluster/${test_name} --type=json -p '[{"op":"add", "path":"/spec/autoCreateUserSchema","value":true},{"op":"add", "path":"/spec/users","value":[{"name":"chico","databases":["spain"],"password":{"type":"ASCII"},"secretName":"chico-credentials", "grantPublicSchemaAccess": true}]}]' sleep 10] logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | + source ../../functions logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ realpath ../../.. logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | ++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | ++ CERT_MANAGER_VER=1.17.1 logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | ++++ pwd logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ basename /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/tests/users logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | ++ test_name=users logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | ++ source /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/vars.sh logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ export ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ export DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ export TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ export TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ export TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | ++++ git rev-parse --abbrev-ref HEAD logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ export GIT_BRANCH=PR-1165 logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ GIT_BRANCH=PR-1165 logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ export VERSION=PR-1165-9f6804715 logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ VERSION=PR-1165-9f6804715 logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ export IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ export IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ export PG_VER=17 logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ PG_VER=17 logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ export IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ export IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ export IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ export IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ export BUCKET=pg-operator-testing logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ BUCKET=pg-operator-testing logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ export PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ export IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ export IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ export IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ export IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ export PGOV1_TAG=1.4.0 logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ PGOV1_TAG=1.4.0 logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ export PGOV1_VER=14 logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ PGOV1_VER=14 logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | ++++ which gdate logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | which: no gdate in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | ++++ which date logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ date=/usr/bin/date logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | ++++ which gsed logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | which: no gsed in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | ++++ which sed logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ sed=/usr/bin/sed logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | +++ command -v oc logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | ++ oc get projects logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | + kubectl -n kuttl-test-great-dove patch perconapgcluster/users --type=json -p '[{"op":"add", "path":"/spec/autoCreateUserSchema","value":true},{"op":"add", "path":"/spec/users","value":[{"name":"chico","databases":["spain"],"password":{"type":"ASCII"},"secretName":"chico-credentials", "grantPublicSchemaAccess": true}]}]' logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | perconapgcluster.pgv2.percona.com/users patched logger.go:42: 09:43:24 | users/13-add-custom-user-with-public-schema-access | + sleep 10 logger.go:42: 09:43:35 | users/13-add-custom-user-with-public-schema-access | test step completed 13-add-custom-user-with-public-schema-access logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | starting test step 14-write-data-to-custom-db logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | running command: [sh -c set -o errexit set -o xtrace source ../../functions password=$(get_psql_user_pass chico-credentials) user='chico' db_name='spain' schema='public' hostname=$(get_pgbouncer_host chico-credentials) run_psql \ 'SET search_path TO public;CREATE TABLE IF NOT EXISTS customApp (id int PRIMARY KEY);' \ "-h $hostname -U $user -d $db_name" "$password" run_psql \ "INSERT INTO $schema.customApp (id) VALUES (100500)" \ "-h $hostname -U $user -d $db_name" "$password" ] logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | + source ../../functions logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ realpath ../../.. logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | ++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | ++ CERT_MANAGER_VER=1.17.1 logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | ++++ pwd logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ basename /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/tests/users logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | ++ test_name=users logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | ++ source /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/vars.sh logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ export ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ export DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ export TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ export TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ export TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | ++++ git rev-parse --abbrev-ref HEAD logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ export GIT_BRANCH=PR-1165 logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ GIT_BRANCH=PR-1165 logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ export VERSION=PR-1165-9f6804715 logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ VERSION=PR-1165-9f6804715 logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ export IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ export IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ export PG_VER=17 logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ PG_VER=17 logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ export IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ export IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ export IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ export IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ export BUCKET=pg-operator-testing logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ BUCKET=pg-operator-testing logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ export PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ export IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ export IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ export IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ export IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ export PGOV1_TAG=1.4.0 logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ PGOV1_TAG=1.4.0 logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ export PGOV1_VER=14 logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ PGOV1_VER=14 logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | ++++ which gdate logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | which: no gdate in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | ++++ which date logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ date=/usr/bin/date logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | ++++ which gsed logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | which: no gsed in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | ++++ which sed logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ sed=/usr/bin/sed logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | +++ command -v oc logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | ++ oc get projects logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | ++ get_psql_user_pass chico-credentials logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | ++ local secret_name=chico-credentials logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | ++ kubectl -n kuttl-test-great-dove get secret/chico-credentials '--template={{.data.password | base64decode}}' logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | + password='Fwr9uz4}ih^tn]kM[0rSmYcB' logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | + user=chico logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | + db_name=spain logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | + schema=public logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | ++ get_pgbouncer_host chico-credentials logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | ++ local secret_name=chico-credentials logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | ++ kubectl -n kuttl-test-great-dove get secret/chico-credentials -o 'jsonpath={.data.pgbouncer-host}' logger.go:42: 09:43:35 | users/14-write-data-to-custom-db | ++ base64 -d logger.go:42: 09:43:36 | users/14-write-data-to-custom-db | + hostname=users-pgbouncer.kuttl-test-great-dove.svc logger.go:42: 09:43:36 | users/14-write-data-to-custom-db | + run_psql 'SET search_path TO public;CREATE TABLE IF NOT EXISTS customApp (id int PRIMARY KEY);' '-h users-pgbouncer.kuttl-test-great-dove.svc -U chico -d spain' 'Fwr9uz4}ih^tn]kM[0rSmYcB' logger.go:42: 09:43:36 | users/14-write-data-to-custom-db | + local 'command=SET search_path TO public;CREATE TABLE IF NOT EXISTS customApp (id int PRIMARY KEY);' logger.go:42: 09:43:36 | users/14-write-data-to-custom-db | + local 'uri=-h users-pgbouncer.kuttl-test-great-dove.svc -U chico -d spain' logger.go:42: 09:43:36 | users/14-write-data-to-custom-db | + local 'password=Fwr9uz4}ih^tn]kM[0rSmYcB' logger.go:42: 09:43:36 | users/14-write-data-to-custom-db | ++ get_client_pod logger.go:42: 09:43:36 | users/14-write-data-to-custom-db | ++ kubectl -n kuttl-test-great-dove get pods --selector=name=pg-client -o 'jsonpath={.items[].metadata.name}' logger.go:42: 09:43:36 | users/14-write-data-to-custom-db | + kubectl -n kuttl-test-great-dove exec pg-client-84d6c45668-s5nx8 -- bash -c 'printf '\''SET search_path TO public;CREATE TABLE IF NOT EXISTS customApp (id int PRIMARY KEY);\n'\'' | PGPASSWORD='\''Fwr9uz4}ih^tn]kM[0rSmYcB'\'' psql -v ON_ERROR_STOP=1 -t -q -h users-pgbouncer.kuttl-test-great-dove.svc -U chico -d spain' logger.go:42: 09:43:37 | users/14-write-data-to-custom-db | + run_psql 'INSERT INTO public.customApp (id) VALUES (100500)' '-h users-pgbouncer.kuttl-test-great-dove.svc -U chico -d spain' 'Fwr9uz4}ih^tn]kM[0rSmYcB' logger.go:42: 09:43:37 | users/14-write-data-to-custom-db | + local 'command=INSERT INTO public.customApp (id) VALUES (100500)' logger.go:42: 09:43:37 | users/14-write-data-to-custom-db | + local 'uri=-h users-pgbouncer.kuttl-test-great-dove.svc -U chico -d spain' logger.go:42: 09:43:37 | users/14-write-data-to-custom-db | + local 'password=Fwr9uz4}ih^tn]kM[0rSmYcB' logger.go:42: 09:43:37 | users/14-write-data-to-custom-db | ++ get_client_pod logger.go:42: 09:43:37 | users/14-write-data-to-custom-db | ++ kubectl -n kuttl-test-great-dove get pods --selector=name=pg-client -o 'jsonpath={.items[].metadata.name}' logger.go:42: 09:43:37 | users/14-write-data-to-custom-db | + kubectl -n kuttl-test-great-dove exec pg-client-84d6c45668-s5nx8 -- bash -c 'printf '\''INSERT INTO public.customApp (id) VALUES (100500)\n'\'' | PGPASSWORD='\''Fwr9uz4}ih^tn]kM[0rSmYcB'\'' psql -v ON_ERROR_STOP=1 -t -q -h users-pgbouncer.kuttl-test-great-dove.svc -U chico -d spain' logger.go:42: 09:43:38 | users/14-write-data-to-custom-db | test step completed 14-write-data-to-custom-db logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | starting test step 15-read-from-primary-custom-db logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | running command: [sh -c set -o errexit set -o xtrace source ../../functions password=$(get_psql_user_pass chico-credentials) user='chico' db_name='spain' schema='public' hostname=$(get_pgbouncer_host chico-credentials) data=$(run_psql "SELECT * from $schema.customApp;" "-h $hostname -U $user -d $db_name" "$password") kubectl create configmap -n "${NAMESPACE}" 10-read-from-primary-custom-db --from-literal=data="${data}"] logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | + source ../../functions logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ realpath ../../.. logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | ++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | ++ CERT_MANAGER_VER=1.17.1 logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | ++++ pwd logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ basename /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/tests/users logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | ++ test_name=users logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | ++ source /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/vars.sh logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ export ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ export DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ export TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ export TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ export TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | ++++ git rev-parse --abbrev-ref HEAD logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ export GIT_BRANCH=PR-1165 logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ GIT_BRANCH=PR-1165 logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ export VERSION=PR-1165-9f6804715 logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ VERSION=PR-1165-9f6804715 logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ export IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ export IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ export PG_VER=17 logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ PG_VER=17 logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ export IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ export IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ export IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ export IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ export BUCKET=pg-operator-testing logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ BUCKET=pg-operator-testing logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ export PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ export IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ export IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ export IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ export IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ export PGOV1_TAG=1.4.0 logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ PGOV1_TAG=1.4.0 logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ export PGOV1_VER=14 logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ PGOV1_VER=14 logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | ++++ which gdate logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | which: no gdate in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | ++++ which date logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ date=/usr/bin/date logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | ++++ which gsed logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | which: no gsed in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | ++++ which sed logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ sed=/usr/bin/sed logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | +++ command -v oc logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | ++ oc get projects logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | ++ get_psql_user_pass chico-credentials logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | ++ local secret_name=chico-credentials logger.go:42: 09:43:38 | users/15-read-from-primary-custom-db | ++ kubectl -n kuttl-test-great-dove get secret/chico-credentials '--template={{.data.password | base64decode}}' logger.go:42: 09:43:39 | users/15-read-from-primary-custom-db | + password='Fwr9uz4}ih^tn]kM[0rSmYcB' logger.go:42: 09:43:39 | users/15-read-from-primary-custom-db | + user=chico logger.go:42: 09:43:39 | users/15-read-from-primary-custom-db | + db_name=spain logger.go:42: 09:43:39 | users/15-read-from-primary-custom-db | + schema=public logger.go:42: 09:43:39 | users/15-read-from-primary-custom-db | ++ get_pgbouncer_host chico-credentials logger.go:42: 09:43:39 | users/15-read-from-primary-custom-db | ++ local secret_name=chico-credentials logger.go:42: 09:43:39 | users/15-read-from-primary-custom-db | ++ kubectl -n kuttl-test-great-dove get secret/chico-credentials -o 'jsonpath={.data.pgbouncer-host}' logger.go:42: 09:43:39 | users/15-read-from-primary-custom-db | ++ base64 -d logger.go:42: 09:43:39 | users/15-read-from-primary-custom-db | + hostname=users-pgbouncer.kuttl-test-great-dove.svc logger.go:42: 09:43:39 | users/15-read-from-primary-custom-db | ++ run_psql 'SELECT * from public.customApp;' '-h users-pgbouncer.kuttl-test-great-dove.svc -U chico -d spain' 'Fwr9uz4}ih^tn]kM[0rSmYcB' logger.go:42: 09:43:39 | users/15-read-from-primary-custom-db | ++ local 'command=SELECT * from public.customApp;' logger.go:42: 09:43:39 | users/15-read-from-primary-custom-db | ++ local 'uri=-h users-pgbouncer.kuttl-test-great-dove.svc -U chico -d spain' logger.go:42: 09:43:39 | users/15-read-from-primary-custom-db | ++ local 'password=Fwr9uz4}ih^tn]kM[0rSmYcB' logger.go:42: 09:43:39 | users/15-read-from-primary-custom-db | +++ get_client_pod logger.go:42: 09:43:39 | users/15-read-from-primary-custom-db | +++ kubectl -n kuttl-test-great-dove get pods --selector=name=pg-client -o 'jsonpath={.items[].metadata.name}' logger.go:42: 09:43:40 | users/15-read-from-primary-custom-db | ++ kubectl -n kuttl-test-great-dove exec pg-client-84d6c45668-s5nx8 -- bash -c 'printf '\''SELECT * from public.customApp;\n'\'' | PGPASSWORD='\''Fwr9uz4}ih^tn]kM[0rSmYcB'\'' psql -v ON_ERROR_STOP=1 -t -q -h users-pgbouncer.kuttl-test-great-dove.svc -U chico -d spain' logger.go:42: 09:43:40 | users/15-read-from-primary-custom-db | + data=' 100500' logger.go:42: 09:43:40 | users/15-read-from-primary-custom-db | + kubectl create configmap -n kuttl-test-great-dove 10-read-from-primary-custom-db '--from-literal=data= 100500' logger.go:42: 09:43:41 | users/15-read-from-primary-custom-db | configmap/10-read-from-primary-custom-db created logger.go:42: 09:43:41 | users/15-read-from-primary-custom-db | test step completed 15-read-from-primary-custom-db logger.go:42: 09:43:41 | users/99-remove-cluster-gracefully | starting test step 99-remove-cluster-gracefully logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | running command: [sh -c set -o errexit set -o xtrace source ../../functions remove_all_finalizers destroy_operator] logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | + source ../../functions logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ realpath ../../.. logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | ++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | ++ CERT_MANAGER_VER=1.17.1 logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | ++++ pwd logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ basename /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/tests/users logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | ++ test_name=users logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | ++ source /mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/vars.sh logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ export ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ ROOT_REPO=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165 logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ export DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ DEPLOY_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/deploy logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ export TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ TESTS_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ export TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ TESTS_CONFIG_DIR=/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/e2e-tests/conf logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ export TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ TEMP_DIR=/tmp/kuttl/pg/users logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | ++++ git rev-parse --abbrev-ref HEAD logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ export GIT_BRANCH=PR-1165 logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ GIT_BRANCH=PR-1165 logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ export VERSION=PR-1165-9f6804715 logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ VERSION=PR-1165-9f6804715 logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ export IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ IMAGE_BASE=perconalab/percona-postgresql-operator logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ export IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ IMAGE=perconalab/percona-postgresql-operator:PR-1165-9f6804715 logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ export PG_VER=17 logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ PG_VER=17 logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ export IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ IMAGE_PGBOUNCER=perconalab/percona-postgresql-operator:main-pgbouncer17 logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ export IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ IMAGE_POSTGRESQL=perconalab/percona-postgresql-operator:main-ppg17-postgres logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ export IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ IMAGE_BACKREST=perconalab/percona-postgresql-operator:main-pgbackrest17 logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ export IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ IMAGE_UPGRADE=perconalab/percona-postgresql-operator:main-upgrade logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ export BUCKET=pg-operator-testing logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ BUCKET=pg-operator-testing logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ export PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ PMM_SERVER_VERSION=9.9.9 logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ export IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ IMAGE_PMM_CLIENT=perconalab/pmm-client:dev-latest logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ export IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ IMAGE_PMM_SERVER=perconalab/pmm-server:dev-latest logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ export IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ IMAGE_PMM3_CLIENT=perconalab/pmm-client:3-dev-latest logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ export IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ IMAGE_PMM3_SERVER=perconalab/pmm-server:3-dev-latest logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ export PGOV1_TAG=1.4.0 logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ PGOV1_TAG=1.4.0 logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ export PGOV1_VER=14 logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ PGOV1_VER=14 logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | ++++ which gdate logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | which: no gdate in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | ++++ which date logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ date=/usr/bin/date logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | ++++ which gsed logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | which: no gsed in (/mnt/jenkins/workspace/cloud-pg-operator_PR-1165/bin/:/home/ec2-user/.krew/bin:/usr/local/bin:/usr/bin) logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | ++++ which sed logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ sed=/usr/bin/sed logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | +++ command -v oc logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | ++ oc get projects logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | + remove_all_finalizers logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | + resource_types=("pg-restore" "pg-backup" "pg") logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | + for resource in '"${resource_types[@]}"' logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | + echo 'removing all finalizers for pg-restore resources' logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | removing all finalizers for pg-restore resources logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | + kubectl -n kuttl-test-great-dove get pg-restore -o json logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | + jq '.items[] | .metadata.name' -r logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | + IFS= logger.go:42: 09:43:49 | users/99-remove-cluster-gracefully | + read -r name logger.go:42: 09:43:50 | users/99-remove-cluster-gracefully | + for resource in '"${resource_types[@]}"' logger.go:42: 09:43:50 | users/99-remove-cluster-gracefully | + echo 'removing all finalizers for pg-backup resources' logger.go:42: 09:43:50 | users/99-remove-cluster-gracefully | removing all finalizers for pg-backup resources logger.go:42: 09:43:50 | users/99-remove-cluster-gracefully | + kubectl -n kuttl-test-great-dove get pg-backup -o json logger.go:42: 09:43:50 | users/99-remove-cluster-gracefully | + IFS= logger.go:42: 09:43:50 | users/99-remove-cluster-gracefully | + jq '.items[] | .metadata.name' -r logger.go:42: 09:43:50 | users/99-remove-cluster-gracefully | + read -r name logger.go:42: 09:43:50 | users/99-remove-cluster-gracefully | + kubectl -n kuttl-test-great-dove delete pg-backup users-backup-qlc4-j9wmv --wait=0 logger.go:42: 09:43:51 | users/99-remove-cluster-gracefully | perconapgbackup.pgv2.percona.com "users-backup-qlc4-j9wmv" deleted logger.go:42: 09:43:51 | users/99-remove-cluster-gracefully | ++ kubectl -n kuttl-test-great-dove get pg-backup users-backup-qlc4-j9wmv -o yaml logger.go:42: 09:43:51 | users/99-remove-cluster-gracefully | ++ yq '.metadata.finalizers | length' logger.go:42: 09:43:51 | users/99-remove-cluster-gracefully | Error from server (NotFound): perconapgbackups.pgv2.percona.com "users-backup-qlc4-j9wmv" not found logger.go:42: 09:43:51 | users/99-remove-cluster-gracefully | + [[ 0 == \0 ]] logger.go:42: 09:43:51 | users/99-remove-cluster-gracefully | + continue logger.go:42: 09:43:51 | users/99-remove-cluster-gracefully | + IFS= logger.go:42: 09:43:51 | users/99-remove-cluster-gracefully | + read -r name logger.go:42: 09:43:51 | users/99-remove-cluster-gracefully | + for resource in '"${resource_types[@]}"' logger.go:42: 09:43:51 | users/99-remove-cluster-gracefully | + echo 'removing all finalizers for pg resources' logger.go:42: 09:43:51 | users/99-remove-cluster-gracefully | removing all finalizers for pg resources logger.go:42: 09:43:51 | users/99-remove-cluster-gracefully | + kubectl -n kuttl-test-great-dove get pg -o json logger.go:42: 09:43:51 | users/99-remove-cluster-gracefully | + jq '.items[] | .metadata.name' -r logger.go:42: 09:43:51 | users/99-remove-cluster-gracefully | + IFS= logger.go:42: 09:43:51 | users/99-remove-cluster-gracefully | + read -r name logger.go:42: 09:43:52 | users/99-remove-cluster-gracefully | + destroy_operator logger.go:42: 09:43:52 | users/99-remove-cluster-gracefully | + kubectl -n pg-operator delete deployment percona-postgresql-operator --force --grace-period=0 logger.go:42: 09:43:52 | users/99-remove-cluster-gracefully | Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. logger.go:42: 09:43:52 | users/99-remove-cluster-gracefully | deployment.apps "percona-postgresql-operator" force deleted logger.go:42: 09:43:52 | users/99-remove-cluster-gracefully | + [[ -n pg-operator ]] logger.go:42: 09:43:52 | users/99-remove-cluster-gracefully | + kubectl delete namespace pg-operator --force --grace-period=0 logger.go:42: 09:43:52 | users/99-remove-cluster-gracefully | Warning: Immediate deletion does not wait for confirmation that the running resource has been terminated. The resource may continue to run on the cluster indefinitely. logger.go:42: 09:43:53 | users/99-remove-cluster-gracefully | namespace "pg-operator" force deleted logger.go:42: 09:43:59 | users/99-remove-cluster-gracefully | test step completed 99-remove-cluster-gracefully logger.go:42: 09:43:59 | users | users events from ns kuttl-test-great-dove: logger.go:42: 09:43:59 | users | 2025-06-05 09:41:26 +0000 UTC Normal Pod pg-client-84d6c45668-s5nx8 Binding Scheduled Successfully assigned kuttl-test-great-dove/pg-client-84d6c45668-s5nx8 to gke-jen-pg-1165-9f680471-default-pool-7a51d93d-fzvn default-scheduler logger.go:42: 09:43:59 | users | 2025-06-05 09:41:26 +0000 UTC Normal ReplicaSet.apps pg-client-84d6c45668 SuccessfulCreate Created pod: pg-client-84d6c45668-s5nx8 replicaset-controller logger.go:42: 09:43:59 | users | 2025-06-05 09:41:26 +0000 UTC Normal Deployment.apps pg-client ScalingReplicaSet Scaled up replica set pg-client-84d6c45668 to 1 deployment-controller logger.go:42: 09:43:59 | users | 2025-06-05 09:41:27 +0000 UTC Normal Pod pg-client-84d6c45668-s5nx8.spec.containers{pg-client} Pulling Pulling image "perconalab/percona-distribution-postgresql:16" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:27 +0000 UTC Normal Pod pg-client-84d6c45668-s5nx8.spec.containers{pg-client} Pulled Successfully pulled image "perconalab/percona-distribution-postgresql:16" in 242ms (242ms including waiting). Image size: 319911229 bytes. kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:27 +0000 UTC Normal Pod pg-client-84d6c45668-s5nx8.spec.containers{pg-client} Created Created container: pg-client kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:27 +0000 UTC Normal Pod pg-client-84d6c45668-s5nx8.spec.containers{pg-client} Started Started container pg-client kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:30 +0000 UTC Normal Pod users-patroni-version-check Binding Scheduled Successfully assigned kuttl-test-great-dove/users-patroni-version-check to gke-jen-pg-1165-9f680471-default-pool-7a51d93d-fzvn default-scheduler logger.go:42: 09:43:59 | users | 2025-06-05 09:41:30 +0000 UTC Normal Pod users-patroni-version-check.spec.containers{patroni-version-check} Pulled Container image "perconalab/percona-postgresql-operator:main-ppg17-postgres" already present on machine kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:30 +0000 UTC Normal Pod users-patroni-version-check.spec.containers{patroni-version-check} Created Created container: patroni-version-check kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:31 +0000 UTC Normal Pod users-patroni-version-check.spec.containers{patroni-version-check} Started Started container patroni-version-check kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:36 +0000 UTC Normal PersistentVolumeClaim users-instance1-hdbw-pgdata WaitForFirstConsumer waiting for first consumer to be created before binding persistentvolume-controller logger.go:42: 09:43:59 | users | 2025-06-05 09:41:36 +0000 UTC Normal Pod users-patroni-version-check.spec.containers{patroni-version-check} Killing Stopping container patroni-version-check kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:37 +0000 UTC Normal PersistentVolumeClaim users-instance1-gdxf-pgdata WaitForFirstConsumer waiting for first consumer to be created before binding persistentvolume-controller logger.go:42: 09:43:59 | users | 2025-06-05 09:41:37 +0000 UTC Normal PersistentVolumeClaim users-instance1-gxf8-pgdata WaitForFirstConsumer waiting for first consumer to be created before binding persistentvolume-controller logger.go:42: 09:43:59 | users | 2025-06-05 09:41:37 +0000 UTC Normal StatefulSet.apps users-instance1-gxf8 SuccessfulCreate create Pod users-instance1-gxf8-0 in StatefulSet users-instance1-gxf8 successful statefulset-controller logger.go:42: 09:43:59 | users | 2025-06-05 09:41:37 +0000 UTC Normal PersistentVolumeClaim users-instance1-hdbw-pgdata ExternalProvisioning Waiting for a volume to be created either by the external provisioner 'pd.csi.storage.gke.io' or manually by the system administrator. If volume creation is delayed, please verify that the provisioner is running and correctly registered. persistentvolume-controller logger.go:42: 09:43:59 | users | 2025-06-05 09:41:37 +0000 UTC Normal PersistentVolumeClaim users-instance1-hdbw-pgdata Provisioning External provisioner is provisioning volume for claim "kuttl-test-great-dove/users-instance1-hdbw-pgdata" pd.csi.storage.gke.io_gke-c2498d124ace4d9a9743-101d-d47a-vm_903e77bc-bde7-4e60-875b-34d23e3d9bb1 logger.go:42: 09:43:59 | users | 2025-06-05 09:41:37 +0000 UTC Normal StatefulSet.apps users-instance1-hdbw SuccessfulCreate create Pod users-instance1-hdbw-0 in StatefulSet users-instance1-hdbw successful statefulset-controller logger.go:42: 09:43:59 | users | 2025-06-05 09:41:38 +0000 UTC Normal PersistentVolumeClaim users-instance1-gdxf-pgdata ExternalProvisioning Waiting for a volume to be created either by the external provisioner 'pd.csi.storage.gke.io' or manually by the system administrator. If volume creation is delayed, please verify that the provisioner is running and correctly registered. persistentvolume-controller logger.go:42: 09:43:59 | users | 2025-06-05 09:41:38 +0000 UTC Normal PersistentVolumeClaim users-instance1-gdxf-pgdata Provisioning External provisioner is provisioning volume for claim "kuttl-test-great-dove/users-instance1-gdxf-pgdata" pd.csi.storage.gke.io_gke-c2498d124ace4d9a9743-101d-d47a-vm_903e77bc-bde7-4e60-875b-34d23e3d9bb1 logger.go:42: 09:43:59 | users | 2025-06-05 09:41:38 +0000 UTC Normal StatefulSet.apps users-instance1-gdxf SuccessfulCreate create Pod users-instance1-gdxf-0 in StatefulSet users-instance1-gdxf successful statefulset-controller logger.go:42: 09:43:59 | users | 2025-06-05 09:41:38 +0000 UTC Normal PersistentVolumeClaim users-instance1-gxf8-pgdata ExternalProvisioning Waiting for a volume to be created either by the external provisioner 'pd.csi.storage.gke.io' or manually by the system administrator. If volume creation is delayed, please verify that the provisioner is running and correctly registered. persistentvolume-controller logger.go:42: 09:43:59 | users | 2025-06-05 09:41:38 +0000 UTC Normal PersistentVolumeClaim users-instance1-gxf8-pgdata Provisioning External provisioner is provisioning volume for claim "kuttl-test-great-dove/users-instance1-gxf8-pgdata" pd.csi.storage.gke.io_gke-c2498d124ace4d9a9743-101d-d47a-vm_903e77bc-bde7-4e60-875b-34d23e3d9bb1 logger.go:42: 09:43:59 | users | 2025-06-05 09:41:39 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-t9sxg Binding Scheduled Successfully assigned kuttl-test-great-dove/users-pgbouncer-5dcb77b6db-t9sxg to gke-jen-pg-1165-9f680471-default-pool-7a51d93d-fzvn default-scheduler logger.go:42: 09:43:59 | users | 2025-06-05 09:41:39 +0000 UTC Normal ReplicaSet.apps users-pgbouncer-5dcb77b6db SuccessfulCreate Created pod: users-pgbouncer-5dcb77b6db-t9sxg replicaset-controller logger.go:42: 09:43:59 | users | 2025-06-05 09:41:39 +0000 UTC Normal ReplicaSet.apps users-pgbouncer-5dcb77b6db SuccessfulCreate Created pod: users-pgbouncer-5dcb77b6db-48p76 replicaset-controller logger.go:42: 09:43:59 | users | 2025-06-05 09:41:39 +0000 UTC Normal PodDisruptionBudget.policy users-pgbouncer NoPods No matching pods found controllermanager logger.go:42: 09:43:59 | users | 2025-06-05 09:41:39 +0000 UTC Normal Deployment.apps users-pgbouncer ScalingReplicaSet Scaled up replica set users-pgbouncer-5dcb77b6db to 3 deployment-controller logger.go:42: 09:43:59 | users | 2025-06-05 09:41:39 +0000 UTC Normal StatefulSet.apps users-repo-host SuccessfulCreate create Pod users-repo-host-0 in StatefulSet users-repo-host successful statefulset-controller logger.go:42: 09:43:59 | users | 2025-06-05 09:41:39 +0000 UTC Normal PersistentVolumeClaim users-repo1 WaitForFirstConsumer waiting for first consumer to be created before binding persistentvolume-controller logger.go:42: 09:43:59 | users | 2025-06-05 09:41:39 +0000 UTC Normal PersistentVolumeClaim users-repo1 ExternalProvisioning Waiting for a volume to be created either by the external provisioner 'pd.csi.storage.gke.io' or manually by the system administrator. If volume creation is delayed, please verify that the provisioner is running and correctly registered. persistentvolume-controller logger.go:42: 09:43:59 | users | 2025-06-05 09:41:39 +0000 UTC Normal PersistentVolumeClaim users-repo1 Provisioning External provisioner is provisioning volume for claim "kuttl-test-great-dove/users-repo1" pd.csi.storage.gke.io_gke-c2498d124ace4d9a9743-101d-d47a-vm_903e77bc-bde7-4e60-875b-34d23e3d9bb1 logger.go:42: 09:43:59 | users | 2025-06-05 09:41:39 +0000 UTC Normal PostgresCluster.postgres-operator.crunchydata.com users RepoHostCreated created pgBackRest repository host StatefulSet/users-repo-host postgrescluster-controller logger.go:42: 09:43:59 | users | 2025-06-05 09:41:40 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-48p76 Binding Scheduled Successfully assigned kuttl-test-great-dove/users-pgbouncer-5dcb77b6db-48p76 to gke-jen-pg-1165-9f680471-default-pool-7a51d93d-5f71 default-scheduler logger.go:42: 09:43:59 | users | 2025-06-05 09:41:40 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-t6b4d Binding Scheduled Successfully assigned kuttl-test-great-dove/users-pgbouncer-5dcb77b6db-t6b4d to gke-jen-pg-1165-9f680471-default-pool-7a51d93d-x7st default-scheduler logger.go:42: 09:43:59 | users | 2025-06-05 09:41:40 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-t9sxg.spec.containers{pgbouncer} Pulling Pulling image "perconalab/percona-postgresql-operator:main-pgbouncer17" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:40 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-t9sxg.spec.containers{pgbouncer} Pulled Successfully pulled image "perconalab/percona-postgresql-operator:main-pgbouncer17" in 216ms (217ms including waiting). Image size: 82210392 bytes. kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:40 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-t9sxg.spec.containers{pgbouncer} Created Created container: pgbouncer kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:40 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-t9sxg.spec.containers{pgbouncer} Started Started container pgbouncer kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:40 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-t9sxg.spec.containers{pgbouncer-config} Pulling Pulling image "perconalab/percona-postgresql-operator:main-pgbouncer17" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:40 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-t9sxg.spec.containers{pgbouncer-config} Pulled Successfully pulled image "perconalab/percona-postgresql-operator:main-pgbouncer17" in 251ms (251ms including waiting). Image size: 82210392 bytes. kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:40 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-t9sxg.spec.containers{pgbouncer-config} Created Created container: pgbouncer-config kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:40 +0000 UTC Normal ReplicaSet.apps users-pgbouncer-5dcb77b6db SuccessfulCreate Created pod: users-pgbouncer-5dcb77b6db-t6b4d replicaset-controller logger.go:42: 09:43:59 | users | 2025-06-05 09:41:41 +0000 UTC Normal Pod users-instance1-hdbw-0 Binding Scheduled Successfully assigned kuttl-test-great-dove/users-instance1-hdbw-0 to gke-jen-pg-1165-9f680471-default-pool-7a51d93d-fzvn default-scheduler logger.go:42: 09:43:59 | users | 2025-06-05 09:41:41 +0000 UTC Normal PersistentVolumeClaim users-instance1-hdbw-pgdata ProvisioningSucceeded Successfully provisioned volume pvc-edbdcf57-69fe-42cd-b925-cb929bfeb4f8 pd.csi.storage.gke.io_gke-c2498d124ace4d9a9743-101d-d47a-vm_903e77bc-bde7-4e60-875b-34d23e3d9bb1 logger.go:42: 09:43:59 | users | 2025-06-05 09:41:41 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-48p76.spec.containers{pgbouncer} Pulling Pulling image "perconalab/percona-postgresql-operator:main-pgbouncer17" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:41 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-48p76.spec.containers{pgbouncer} Pulled Successfully pulled image "perconalab/percona-postgresql-operator:main-pgbouncer17" in 210ms (210ms including waiting). Image size: 82210392 bytes. kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:41 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-48p76.spec.containers{pgbouncer} Created Created container: pgbouncer kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:41 +0000 UTC Warning Pod users-pgbouncer-5dcb77b6db-t6b4d FailedMount MountVolume.SetUp failed for volume "pgbouncer-config" : failed to sync configmap cache: timed out waiting for the condition kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:41 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-t9sxg.spec.containers{pgbouncer-config} Started Started container pgbouncer-config kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:42 +0000 UTC Normal PersistentVolumeClaim users-instance1-gdxf-pgdata ProvisioningSucceeded Successfully provisioned volume pvc-4a9affc5-2ec6-4b1e-be27-45dbd893dfff pd.csi.storage.gke.io_gke-c2498d124ace4d9a9743-101d-d47a-vm_903e77bc-bde7-4e60-875b-34d23e3d9bb1 logger.go:42: 09:43:59 | users | 2025-06-05 09:41:42 +0000 UTC Normal PersistentVolumeClaim users-instance1-gxf8-pgdata ProvisioningSucceeded Successfully provisioned volume pvc-6ce7dd92-4a0f-4a03-ab0e-1a5144200755 pd.csi.storage.gke.io_gke-c2498d124ace4d9a9743-101d-d47a-vm_903e77bc-bde7-4e60-875b-34d23e3d9bb1 logger.go:42: 09:43:59 | users | 2025-06-05 09:41:42 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-48p76.spec.containers{pgbouncer} Started Started container pgbouncer kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:42 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-48p76.spec.containers{pgbouncer-config} Pulling Pulling image "perconalab/percona-postgresql-operator:main-pgbouncer17" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:42 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-48p76.spec.containers{pgbouncer-config} Pulled Successfully pulled image "perconalab/percona-postgresql-operator:main-pgbouncer17" in 203ms (203ms including waiting). Image size: 82210392 bytes. kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:42 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-48p76.spec.containers{pgbouncer-config} Created Created container: pgbouncer-config kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:42 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-48p76.spec.containers{pgbouncer-config} Started Started container pgbouncer-config kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:42 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-t6b4d.spec.containers{pgbouncer} Pulling Pulling image "perconalab/percona-postgresql-operator:main-pgbouncer17" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:42 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-t6b4d.spec.containers{pgbouncer} Pulled Successfully pulled image "perconalab/percona-postgresql-operator:main-pgbouncer17" in 221ms (221ms including waiting). Image size: 82210392 bytes. kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:42 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-t6b4d.spec.containers{pgbouncer} Created Created container: pgbouncer kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:42 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-t6b4d.spec.containers{pgbouncer} Started Started container pgbouncer kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:42 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-t6b4d.spec.containers{pgbouncer-config} Pulling Pulling image "perconalab/percona-postgresql-operator:main-pgbouncer17" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:42 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-t6b4d.spec.containers{pgbouncer-config} Pulled Successfully pulled image "perconalab/percona-postgresql-operator:main-pgbouncer17" in 213ms (213ms including waiting). Image size: 82210392 bytes. kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:42 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-t6b4d.spec.containers{pgbouncer-config} Created Created container: pgbouncer-config kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:43 +0000 UTC Normal Pod users-instance1-gdxf-0 Binding Scheduled Successfully assigned kuttl-test-great-dove/users-instance1-gdxf-0 to gke-jen-pg-1165-9f680471-default-pool-7a51d93d-x7st default-scheduler logger.go:42: 09:43:59 | users | 2025-06-05 09:41:43 +0000 UTC Normal Pod users-instance1-gxf8-0 Binding Scheduled Successfully assigned kuttl-test-great-dove/users-instance1-gxf8-0 to gke-jen-pg-1165-9f680471-default-pool-7a51d93d-5f71 default-scheduler logger.go:42: 09:43:59 | users | 2025-06-05 09:41:43 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-t6b4d.spec.containers{pgbouncer-config} Started Started container pgbouncer-config kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:43 +0000 UTC Normal PersistentVolumeClaim users-repo1 ProvisioningSucceeded Successfully provisioned volume pvc-9facaa03-9f24-4f9a-81a6-34a74ff57d11 pd.csi.storage.gke.io_gke-c2498d124ace4d9a9743-101d-d47a-vm_903e77bc-bde7-4e60-875b-34d23e3d9bb1 logger.go:42: 09:43:59 | users | 2025-06-05 09:41:44 +0000 UTC Normal Pod users-repo-host-0 Binding Scheduled Successfully assigned kuttl-test-great-dove/users-repo-host-0 to gke-jen-pg-1165-9f680471-default-pool-7a51d93d-fzvn default-scheduler logger.go:42: 09:43:59 | users | 2025-06-05 09:41:49 +0000 UTC Normal Pod users-instance1-hdbw-0 SuccessfulAttachVolume AttachVolume.Attach succeeded for volume "pvc-edbdcf57-69fe-42cd-b925-cb929bfeb4f8" attachdetach-controller logger.go:42: 09:43:59 | users | 2025-06-05 09:41:51 +0000 UTC Normal Pod users-instance1-gdxf-0 SuccessfulAttachVolume AttachVolume.Attach succeeded for volume "pvc-4a9affc5-2ec6-4b1e-be27-45dbd893dfff" attachdetach-controller logger.go:42: 09:43:59 | users | 2025-06-05 09:41:51 +0000 UTC Normal Pod users-instance1-gxf8-0 SuccessfulAttachVolume AttachVolume.Attach succeeded for volume "pvc-6ce7dd92-4a0f-4a03-ab0e-1a5144200755" attachdetach-controller logger.go:42: 09:43:59 | users | 2025-06-05 09:41:51 +0000 UTC Normal Pod users-instance1-hdbw-0.spec.initContainers{postgres-startup} Pulling Pulling image "perconalab/percona-postgresql-operator:main-ppg17-postgres" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:51 +0000 UTC Normal Pod users-instance1-hdbw-0.spec.initContainers{postgres-startup} Pulled Successfully pulled image "perconalab/percona-postgresql-operator:main-ppg17-postgres" in 204ms (204ms including waiting). Image size: 524282456 bytes. kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:51 +0000 UTC Normal Pod users-instance1-hdbw-0.spec.initContainers{postgres-startup} Created Created container: postgres-startup kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:51 +0000 UTC Normal Pod users-instance1-hdbw-0.spec.initContainers{postgres-startup} Started Started container postgres-startup kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:51 +0000 UTC Normal Pod users-instance1-hdbw-0.spec.initContainers{database-init} Pulling Pulling image "perconalab/percona-postgresql-operator:PR-1165-9f6804715" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:52 +0000 UTC Normal Pod users-instance1-gdxf-0.spec.initContainers{postgres-startup} Pulling Pulling image "perconalab/percona-postgresql-operator:main-ppg17-postgres" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:52 +0000 UTC Normal Pod users-instance1-gdxf-0.spec.initContainers{postgres-startup} Pulled Successfully pulled image "perconalab/percona-postgresql-operator:main-ppg17-postgres" in 254ms (254ms including waiting). Image size: 524282456 bytes. kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:52 +0000 UTC Normal Pod users-instance1-gdxf-0.spec.initContainers{postgres-startup} Created Created container: postgres-startup kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:52 +0000 UTC Normal Pod users-instance1-gdxf-0.spec.initContainers{postgres-startup} Started Started container postgres-startup kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:52 +0000 UTC Normal Pod users-instance1-gxf8-0.spec.initContainers{postgres-startup} Pulling Pulling image "perconalab/percona-postgresql-operator:main-ppg17-postgres" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:52 +0000 UTC Normal Pod users-instance1-hdbw-0.spec.initContainers{database-init} Pulled Successfully pulled image "perconalab/percona-postgresql-operator:PR-1165-9f6804715" in 226ms (226ms including waiting). Image size: 93710528 bytes. kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:52 +0000 UTC Normal Pod users-instance1-hdbw-0.spec.initContainers{database-init} Created Created container: database-init kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:52 +0000 UTC Normal Pod users-instance1-hdbw-0.spec.initContainers{database-init} Started Started container database-init kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:52 +0000 UTC Normal Pod users-instance1-hdbw-0.spec.initContainers{nss-wrapper-init} Pulling Pulling image "perconalab/percona-postgresql-operator:main-ppg17-postgres" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:52 +0000 UTC Normal Pod users-repo-host-0 SuccessfulAttachVolume AttachVolume.Attach succeeded for volume "pvc-9facaa03-9f24-4f9a-81a6-34a74ff57d11" attachdetach-controller logger.go:42: 09:43:59 | users | 2025-06-05 09:41:53 +0000 UTC Normal Pod users-instance1-gdxf-0.spec.initContainers{database-init} Pulling Pulling image "perconalab/percona-postgresql-operator:PR-1165-9f6804715" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:53 +0000 UTC Normal Pod users-instance1-gdxf-0.spec.initContainers{database-init} Pulled Successfully pulled image "perconalab/percona-postgresql-operator:PR-1165-9f6804715" in 235ms (235ms including waiting). Image size: 93710528 bytes. kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:53 +0000 UTC Normal Pod users-instance1-gdxf-0.spec.initContainers{database-init} Created Created container: database-init kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:53 +0000 UTC Normal Pod users-instance1-gdxf-0.spec.initContainers{database-init} Started Started container database-init kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:53 +0000 UTC Normal Pod users-instance1-gxf8-0.spec.initContainers{postgres-startup} Pulled Successfully pulled image "perconalab/percona-postgresql-operator:main-ppg17-postgres" in 237ms (237ms including waiting). Image size: 524282456 bytes. kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:53 +0000 UTC Normal Pod users-instance1-gxf8-0.spec.initContainers{postgres-startup} Created Created container: postgres-startup kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:53 +0000 UTC Normal Pod users-instance1-gxf8-0.spec.initContainers{postgres-startup} Started Started container postgres-startup kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:53 +0000 UTC Normal Pod users-instance1-gxf8-0.spec.initContainers{database-init} Pulling Pulling image "perconalab/percona-postgresql-operator:PR-1165-9f6804715" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:53 +0000 UTC Normal Pod users-instance1-hdbw-0.spec.initContainers{nss-wrapper-init} Pulled Successfully pulled image "perconalab/percona-postgresql-operator:main-ppg17-postgres" in 113ms (113ms including waiting). Image size: 524282456 bytes. kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:53 +0000 UTC Normal Pod users-instance1-hdbw-0.spec.initContainers{nss-wrapper-init} Created Created container: nss-wrapper-init kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:53 +0000 UTC Normal Pod users-instance1-hdbw-0.spec.initContainers{nss-wrapper-init} Started Started container nss-wrapper-init kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:53 +0000 UTC Normal Pod users-instance1-hdbw-0.spec.containers{database} Pulling Pulling image "perconalab/percona-postgresql-operator:main-ppg17-postgres" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:53 +0000 UTC Normal Pod users-repo-host-0.spec.initContainers{pgbackrest-log-dir} Pulling Pulling image "perconalab/percona-postgresql-operator:main-pgbackrest17" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:53 +0000 UTC Normal Pod users-repo-host-0.spec.initContainers{pgbackrest-log-dir} Pulled Successfully pulled image "perconalab/percona-postgresql-operator:main-pgbackrest17" in 208ms (208ms including waiting). Image size: 151557725 bytes. kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:53 +0000 UTC Normal Pod users-repo-host-0.spec.initContainers{pgbackrest-log-dir} Created Created container: pgbackrest-log-dir kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:53 +0000 UTC Normal Pod users-repo-host-0.spec.initContainers{pgbackrest-log-dir} Started Started container pgbackrest-log-dir kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:53 +0000 UTC Normal Pod users-repo-host-0.spec.initContainers{nss-wrapper-init} Pulling Pulling image "perconalab/percona-postgresql-operator:main-pgbackrest17" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:54 +0000 UTC Normal Pod users-instance1-gdxf-0.spec.initContainers{nss-wrapper-init} Pulling Pulling image "perconalab/percona-postgresql-operator:main-ppg17-postgres" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:54 +0000 UTC Normal Pod users-instance1-gdxf-0.spec.initContainers{nss-wrapper-init} Pulled Successfully pulled image "perconalab/percona-postgresql-operator:main-ppg17-postgres" in 236ms (236ms including waiting). Image size: 524282456 bytes. kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:54 +0000 UTC Normal Pod users-instance1-gdxf-0.spec.initContainers{nss-wrapper-init} Created Created container: nss-wrapper-init kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:54 +0000 UTC Normal Pod users-instance1-gdxf-0.spec.initContainers{nss-wrapper-init} Started Started container nss-wrapper-init kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:54 +0000 UTC Normal Pod users-instance1-gxf8-0.spec.initContainers{database-init} Pulled Successfully pulled image "perconalab/percona-postgresql-operator:PR-1165-9f6804715" in 257ms (257ms including waiting). Image size: 93710528 bytes. kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:54 +0000 UTC Normal Pod users-instance1-gxf8-0.spec.initContainers{database-init} Created Created container: database-init kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:54 +0000 UTC Normal Pod users-instance1-gxf8-0.spec.initContainers{database-init} Started Started container database-init kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:54 +0000 UTC Normal Pod users-instance1-gxf8-0.spec.initContainers{nss-wrapper-init} Pulling Pulling image "perconalab/percona-postgresql-operator:main-ppg17-postgres" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:54 +0000 UTC Normal Pod users-instance1-hdbw-0.spec.containers{database} Pulled Successfully pulled image "perconalab/percona-postgresql-operator:main-ppg17-postgres" in 264ms (264ms including waiting). Image size: 524282456 bytes. kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:54 +0000 UTC Normal Pod users-instance1-hdbw-0.spec.containers{database} Created Created container: database kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:54 +0000 UTC Normal Pod users-instance1-hdbw-0.spec.containers{database} Started Started container database kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:54 +0000 UTC Normal Pod users-instance1-hdbw-0.spec.containers{replication-cert-copy} Pulling Pulling image "perconalab/percona-postgresql-operator:main-ppg17-postgres" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:54 +0000 UTC Normal Pod users-instance1-hdbw-0.spec.containers{replication-cert-copy} Pulled Successfully pulled image "perconalab/percona-postgresql-operator:main-ppg17-postgres" in 147ms (148ms including waiting). Image size: 524282456 bytes. kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:54 +0000 UTC Normal Pod users-instance1-hdbw-0.spec.containers{replication-cert-copy} Created Created container: replication-cert-copy kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:54 +0000 UTC Normal Pod users-instance1-hdbw-0.spec.containers{replication-cert-copy} Started Started container replication-cert-copy kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:54 +0000 UTC Normal Pod users-instance1-hdbw-0.spec.containers{pgbackrest} Pulling Pulling image "perconalab/percona-postgresql-operator:main-pgbackrest17" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:54 +0000 UTC Normal Pod users-instance1-hdbw-0.spec.containers{pgbackrest} Pulled Successfully pulled image "perconalab/percona-postgresql-operator:main-pgbackrest17" in 245ms (245ms including waiting). Image size: 151557725 bytes. kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:54 +0000 UTC Normal Pod users-instance1-hdbw-0.spec.containers{pgbackrest} Created Created container: pgbackrest kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:54 +0000 UTC Normal Pod users-instance1-hdbw-0.spec.containers{pgbackrest} Started Started container pgbackrest kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:54 +0000 UTC Normal Pod users-repo-host-0.spec.initContainers{nss-wrapper-init} Pulled Successfully pulled image "perconalab/percona-postgresql-operator:main-pgbackrest17" in 247ms (247ms including waiting). Image size: 151557725 bytes. kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:54 +0000 UTC Normal Pod users-repo-host-0.spec.initContainers{nss-wrapper-init} Created Created container: nss-wrapper-init kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:54 +0000 UTC Normal Pod users-repo-host-0.spec.initContainers{nss-wrapper-init} Started Started container nss-wrapper-init kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:54 +0000 UTC Normal Pod users-repo-host-0.spec.containers{pgbackrest} Pulling Pulling image "perconalab/percona-postgresql-operator:main-pgbackrest17" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:55 +0000 UTC Normal Pod users-instance1-gdxf-0.spec.containers{database} Pulling Pulling image "perconalab/percona-postgresql-operator:main-ppg17-postgres" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:55 +0000 UTC Normal Pod users-instance1-gdxf-0.spec.containers{database} Pulled Successfully pulled image "perconalab/percona-postgresql-operator:main-ppg17-postgres" in 264ms (264ms including waiting). Image size: 524282456 bytes. kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:55 +0000 UTC Normal Pod users-instance1-gdxf-0.spec.containers{database} Created Created container: database kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:55 +0000 UTC Normal Pod users-instance1-gxf8-0.spec.initContainers{nss-wrapper-init} Pulled Successfully pulled image "perconalab/percona-postgresql-operator:main-ppg17-postgres" in 241ms (241ms including waiting). Image size: 524282456 bytes. kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:55 +0000 UTC Normal Pod users-instance1-gxf8-0.spec.initContainers{nss-wrapper-init} Created Created container: nss-wrapper-init kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:55 +0000 UTC Normal Pod users-instance1-gxf8-0.spec.initContainers{nss-wrapper-init} Started Started container nss-wrapper-init kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:55 +0000 UTC Normal Pod users-instance1-gxf8-0.spec.containers{database} Pulling Pulling image "perconalab/percona-postgresql-operator:main-ppg17-postgres" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:55 +0000 UTC Normal Pod users-instance1-hdbw-0.spec.containers{pgbackrest-config} Pulling Pulling image "perconalab/percona-postgresql-operator:main-pgbackrest17" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:55 +0000 UTC Normal Pod users-repo-host-0.spec.containers{pgbackrest} Pulled Successfully pulled image "perconalab/percona-postgresql-operator:main-pgbackrest17" in 106ms (106ms including waiting). Image size: 151557725 bytes. kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:55 +0000 UTC Normal Pod users-repo-host-0.spec.containers{pgbackrest} Created Created container: pgbackrest kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:55 +0000 UTC Normal Pod users-repo-host-0.spec.containers{pgbackrest} Started Started container pgbackrest kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:55 +0000 UTC Normal Pod users-repo-host-0.spec.containers{pgbackrest-config} Pulling Pulling image "perconalab/percona-postgresql-operator:main-pgbackrest17" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:55 +0000 UTC Normal Pod users-repo-host-0.spec.containers{pgbackrest-config} Pulled Successfully pulled image "perconalab/percona-postgresql-operator:main-pgbackrest17" in 225ms (225ms including waiting). Image size: 151557725 bytes. kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:55 +0000 UTC Normal Pod users-repo-host-0.spec.containers{pgbackrest-config} Created Created container: pgbackrest-config kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:55 +0000 UTC Normal Pod users-repo-host-0.spec.containers{pgbackrest-config} Started Started container pgbackrest-config kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:56 +0000 UTC Normal Pod users-instance1-gdxf-0.spec.containers{database} Started Started container database kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:56 +0000 UTC Normal Pod users-instance1-gdxf-0.spec.containers{replication-cert-copy} Pulling Pulling image "perconalab/percona-postgresql-operator:main-ppg17-postgres" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:56 +0000 UTC Normal Pod users-instance1-gdxf-0.spec.containers{replication-cert-copy} Pulled Successfully pulled image "perconalab/percona-postgresql-operator:main-ppg17-postgres" in 254ms (254ms including waiting). Image size: 524282456 bytes. kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:56 +0000 UTC Normal Pod users-instance1-gxf8-0.spec.containers{database} Pulled Successfully pulled image "perconalab/percona-postgresql-operator:main-ppg17-postgres" in 247ms (247ms including waiting). Image size: 524282456 bytes. kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:56 +0000 UTC Normal Pod users-instance1-gxf8-0.spec.containers{database} Created Created container: database kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:57 +0000 UTC Normal Pod users-instance1-gdxf-0.spec.containers{replication-cert-copy} Created Created container: replication-cert-copy kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:57 +0000 UTC Normal Pod users-instance1-gdxf-0.spec.containers{replication-cert-copy} Started Started container replication-cert-copy kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:57 +0000 UTC Normal Pod users-instance1-gdxf-0.spec.containers{pgbackrest} Pulling Pulling image "perconalab/percona-postgresql-operator:main-pgbackrest17" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:57 +0000 UTC Normal Pod users-instance1-gdxf-0.spec.containers{pgbackrest} Pulled Successfully pulled image "perconalab/percona-postgresql-operator:main-pgbackrest17" in 223ms (223ms including waiting). Image size: 151557725 bytes. kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:57 +0000 UTC Normal Pod users-instance1-gdxf-0.spec.containers{pgbackrest} Created Created container: pgbackrest kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:57 +0000 UTC Normal Pod users-instance1-gdxf-0.spec.containers{pgbackrest} Started Started container pgbackrest kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:57 +0000 UTC Normal Pod users-instance1-gdxf-0.spec.containers{pgbackrest-config} Pulling Pulling image "perconalab/percona-postgresql-operator:main-pgbackrest17" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:57 +0000 UTC Normal Pod users-instance1-gxf8-0.spec.containers{database} Started Started container database kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:57 +0000 UTC Normal Pod users-instance1-gxf8-0.spec.containers{replication-cert-copy} Pulling Pulling image "perconalab/percona-postgresql-operator:main-ppg17-postgres" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:57 +0000 UTC Normal Pod users-instance1-gxf8-0.spec.containers{replication-cert-copy} Pulled Successfully pulled image "perconalab/percona-postgresql-operator:main-ppg17-postgres" in 203ms (203ms including waiting). Image size: 524282456 bytes. kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:57 +0000 UTC Normal Pod users-instance1-gxf8-0.spec.containers{replication-cert-copy} Created Created container: replication-cert-copy kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:57 +0000 UTC Normal Pod users-instance1-gxf8-0.spec.containers{replication-cert-copy} Started Started container replication-cert-copy kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:57 +0000 UTC Normal Pod users-instance1-gxf8-0.spec.containers{pgbackrest} Pulling Pulling image "perconalab/percona-postgresql-operator:main-pgbackrest17" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:57 +0000 UTC Normal Pod users-instance1-gxf8-0.spec.containers{pgbackrest} Pulled Successfully pulled image "perconalab/percona-postgresql-operator:main-pgbackrest17" in 261ms (261ms including waiting). Image size: 151557725 bytes. kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:57 +0000 UTC Normal Pod users-instance1-gxf8-0.spec.containers{pgbackrest} Created Created container: pgbackrest kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:58 +0000 UTC Normal Pod users-instance1-gxf8-0.spec.containers{pgbackrest} Started Started container pgbackrest kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:41:58 +0000 UTC Normal Pod users-instance1-gxf8-0.spec.containers{pgbackrest-config} Pulling Pulling image "perconalab/percona-postgresql-operator:main-pgbackrest17" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:42:06 +0000 UTC Normal Pod users-backup-qlc4-c5vpx Binding Scheduled Successfully assigned kuttl-test-great-dove/users-backup-qlc4-c5vpx to gke-jen-pg-1165-9f680471-default-pool-7a51d93d-5f71 default-scheduler logger.go:42: 09:43:59 | users | 2025-06-05 09:42:06 +0000 UTC Normal Job.batch users-backup-qlc4 SuccessfulCreate Created pod: users-backup-qlc4-c5vpx job-controller logger.go:42: 09:43:59 | users | 2025-06-05 09:42:06 +0000 UTC Normal PostgresCluster.postgres-operator.crunchydata.com users StanzasCreated pgBackRest stanza creation completed successfully postgrescluster-controller logger.go:42: 09:43:59 | users | 2025-06-05 09:42:07 +0000 UTC Normal Pod users-backup-qlc4-c5vpx.spec.initContainers{pgbackrest-init} Pulling Pulling image "perconalab/percona-postgresql-operator:PR-1165-9f6804715" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:42:07 +0000 UTC Normal Pod users-backup-qlc4-c5vpx.spec.initContainers{pgbackrest-init} Pulled Successfully pulled image "perconalab/percona-postgresql-operator:PR-1165-9f6804715" in 232ms (232ms including waiting). Image size: 93710528 bytes. kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:42:07 +0000 UTC Normal Pod users-backup-qlc4-c5vpx.spec.initContainers{pgbackrest-init} Created Created container: pgbackrest-init kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:42:07 +0000 UTC Normal Pod users-backup-qlc4-c5vpx.spec.initContainers{pgbackrest-init} Started Started container pgbackrest-init kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:42:08 +0000 UTC Normal Pod users-backup-qlc4-c5vpx.spec.containers{pgbackrest} Pulling Pulling image "perconalab/percona-postgresql-operator:main-pgbackrest17" kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:42:09 +0000 UTC Normal Pod users-backup-qlc4-c5vpx.spec.containers{pgbackrest} Pulled Successfully pulled image "perconalab/percona-postgresql-operator:main-pgbackrest17" in 179ms (179ms including waiting). Image size: 151557725 bytes. kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:42:09 +0000 UTC Normal Pod users-backup-qlc4-c5vpx.spec.containers{pgbackrest} Created Created container: pgbackrest kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:42:09 +0000 UTC Normal Pod users-backup-qlc4-c5vpx.spec.containers{pgbackrest} Started Started container pgbackrest kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:42:11 +0000 UTC Warning PostgresCluster.postgres-operator.crunchydata.com users UnableToCreateStanzas command terminated with exit code 50: repo1-path = /pgbackrest/repo1 2025-06-05 09:42:11.208 P00 ERROR: [050]: unable to acquire lock on file '/tmp/pgbackrest/db-backup-1.lock': Resource temporarily unavailable HINT: is another pgBackRest process running? 2025-06-05 09:42:11.287 P00 ERROR: [050]: unable to acquire lock on file '/tmp/pgbackrest/db-backup-1.lock': Resource temporarily unavailable HINT: is another pgBackRest process running? postgrescluster-controller logger.go:42: 09:43:59 | users | 2025-06-05 09:42:37 +0000 UTC Normal Job.batch users-backup-qlc4 Completed Job completed job-controller logger.go:42: 09:43:59 | users | 2025-06-05 09:43:44 +0000 UTC Normal StatefulSet.apps users-instance1-gdxf SuccessfulDelete delete Pod users-instance1-gdxf-0 in StatefulSet users-instance1-gdxf successful statefulset-controller logger.go:42: 09:43:59 | users | 2025-06-05 09:43:44 +0000 UTC Normal StatefulSet.apps users-instance1-gxf8 SuccessfulDelete delete Pod users-instance1-gxf8-0 in StatefulSet users-instance1-gxf8 successful statefulset-controller logger.go:42: 09:43:59 | users | 2025-06-05 09:43:46 +0000 UTC Normal StatefulSet.apps users-instance1-hdbw SuccessfulDelete delete Pod users-instance1-hdbw-0 in StatefulSet users-instance1-hdbw successful statefulset-controller logger.go:42: 09:43:59 | users | 2025-06-05 09:43:49 +0000 UTC Normal PodDisruptionBudget.policy users-set-instance1 NoPods No matching pods found controllermanager logger.go:42: 09:43:59 | users | 2025-06-05 09:43:50 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-48p76.spec.containers{pgbouncer} Killing Stopping container pgbouncer kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:43:50 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-48p76.spec.containers{pgbouncer-config} Killing Stopping container pgbouncer-config kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:43:50 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-t6b4d.spec.containers{pgbouncer} Killing Stopping container pgbouncer kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:43:50 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-t6b4d.spec.containers{pgbouncer-config} Killing Stopping container pgbouncer-config kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:43:50 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-t9sxg.spec.containers{pgbouncer} Killing Stopping container pgbouncer kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:43:50 +0000 UTC Normal Pod users-pgbouncer-5dcb77b6db-t9sxg.spec.containers{pgbouncer-config} Killing Stopping container pgbouncer-config kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:43:50 +0000 UTC Normal Pod users-repo-host-0.spec.containers{pgbackrest} Killing Stopping container pgbackrest kubelet logger.go:42: 09:43:59 | users | 2025-06-05 09:43:50 +0000 UTC Normal Pod users-repo-host-0.spec.containers{pgbackrest-config} Killing Stopping container pgbackrest-config kubelet logger.go:42: 09:43:59 | users | Deleting namespace: kuttl-test-great-dove === NAME kuttl harness.go:407: run tests finished harness.go:515: cleaning up harness.go:572: removing temp folder: "" --- PASS: kuttl (203.06s) --- PASS: kuttl/harness (0.00s) --- PASS: kuttl/harness/users (202.61s) PASS