Cloud Regression Test #268
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: Cloud Regression Test | |
| on: | |
| schedule: | |
| # * is a special character in YAML so you have to quote this string | |
| # ┌───────────── minute (0 - 59) | |
| # │ ┌───────────── hour (0 - 23) | |
| # │ │ ┌───────────── day of the month (1 - 31) | |
| # │ │ │ ┌───────────── month (1 - 12 or JAN-DEC) | |
| # │ │ │ │ ┌───────────── day of the week (0 - 6 or SUN-SAT) | |
| - cron: '45 1 * * *' # run once a day, timezone is utc | |
| workflow_dispatch: # adds ability to run this manually | |
| defaults: | |
| run: | |
| shell: bash -euxo pipefail {0} | |
| concurrency: | |
| # Allow only one workflow | |
| group: ${{ github.workflow }} | |
| cancel-in-progress: true | |
| permissions: | |
| id-token: write # aws-actions/configure-aws-credentials | |
| jobs: | |
| regress: | |
| env: | |
| POSTGRES_DISTRIB_DIR: /tmp/neon/pg_install | |
| TEST_OUTPUT: /tmp/test_output | |
| BUILD_TYPE: remote | |
| strategy: | |
| fail-fast: false | |
| matrix: | |
| pg-version: [16, 17] | |
| runs-on: us-east-2 | |
| container: | |
| image: neondatabase/build-tools:pinned-bookworm | |
| options: --init | |
| steps: | |
| - uses: actions/checkout@v4 | |
| with: | |
| submodules: true | |
| - name: Patch the test | |
| env: | |
| PG_VERSION: ${{matrix.pg-version}} | |
| run: | | |
| cd "vendor/postgres-v${PG_VERSION}" | |
| patch -p1 < "../../compute/patches/cloud_regress_pg${PG_VERSION}.patch" | |
| - name: Generate a random password | |
| id: pwgen | |
| run: | | |
| set +x | |
| DBPASS=$(dd if=/dev/random bs=48 count=1 2>/dev/null | base64) | |
| echo "::add-mask::${DBPASS//\//}" | |
| echo DBPASS="${DBPASS//\//}" >> "${GITHUB_OUTPUT}" | |
| - name: Change tests according to the generated password | |
| env: | |
| DBPASS: ${{ steps.pwgen.outputs.DBPASS }} | |
| PG_VERSION: ${{matrix.pg-version}} | |
| run: | | |
| cd vendor/postgres-v"${PG_VERSION}"/src/test/regress | |
| for fname in sql/*.sql expected/*.out; do | |
| sed -i.bak s/NEON_PASSWORD_PLACEHOLDER/"'${DBPASS}'"/ "${fname}" | |
| done | |
| for ph in $(grep NEON_MD5_PLACEHOLDER expected/password.out | awk '{print $3;}' | sort | uniq); do | |
| USER=$(echo "${ph}" | cut -c 22-) | |
| MD5=md5$(echo -n "${DBPASS}${USER}" | md5sum | awk '{print $1;}') | |
| sed -i.bak "s/${ph}/${MD5}/" expected/password.out | |
| done | |
| - name: Download Neon artifact | |
| uses: ./.github/actions/download | |
| with: | |
| name: neon-${{ runner.os }}-${{ runner.arch }}-release-artifact | |
| path: /tmp/neon/ | |
| prefix: latest | |
| aws-oicd-role-arn: ${{ vars.DEV_AWS_OIDC_ROLE_ARN }} | |
| - name: Create a new branch | |
| id: create-branch | |
| uses: ./.github/actions/neon-branch-create | |
| with: | |
| api_key: ${{ secrets.NEON_STAGING_API_KEY }} | |
| project_id: ${{ vars[format('PGREGRESS_PG{0}_PROJECT_ID', matrix.pg-version)] }} | |
| - name: Run the regression tests | |
| uses: ./.github/actions/run-python-test-set | |
| with: | |
| build_type: ${{ env.BUILD_TYPE }} | |
| test_selection: cloud_regress | |
| pg_version: ${{matrix.pg-version}} | |
| extra_params: -m remote_cluster | |
| aws-oicd-role-arn: ${{ vars.DEV_AWS_OIDC_ROLE_ARN }} | |
| env: | |
| BENCHMARK_CONNSTR: ${{steps.create-branch.outputs.dsn}} | |
| - name: Delete branch | |
| if: always() | |
| uses: ./.github/actions/neon-branch-delete | |
| with: | |
| api_key: ${{ secrets.NEON_STAGING_API_KEY }} | |
| project_id: ${{ vars[format('PGREGRESS_PG{0}_PROJECT_ID', matrix.pg-version)] }} | |
| branch_id: ${{steps.create-branch.outputs.branch_id}} | |
| - name: Create Allure report | |
| id: create-allure-report | |
| if: ${{ !cancelled() }} | |
| uses: ./.github/actions/allure-report-generate | |
| with: | |
| aws-oicd-role-arn: ${{ vars.DEV_AWS_OIDC_ROLE_ARN }} | |
| - name: Post to a Slack channel | |
| if: ${{ github.event.schedule && failure() }} | |
| uses: slackapi/slack-github-action@v1 | |
| with: | |
| channel-id: ${{ vars.SLACK_ON_CALL_QA_STAGING_STREAM }} | |
| slack-message: | | |
| Periodic pg_regress on staging: ${{ job.status }} | |
| <${{ github.server_url }}/${{ github.repository }}/actions/runs/${{ github.run_id }}|GitHub Run> | |
| <${{ steps.create-allure-report.outputs.report-url }}|Allure report> | |
| env: | |
| SLACK_BOT_TOKEN: ${{ secrets.SLACK_BOT_TOKEN }} | |