Collect max_connections metric #29386

Workflow file for this run

.github/workflows/build_and_test.yml at a0a30e8

	name: Build and Test

	on:
	push:
	branches:
	- main
	- release
	- release-proxy
	pull_request:

	defaults:
	run:
	shell: bash -euxo pipefail {0}

	concurrency:
	# Allow only one workflow per any non-`main` branch.
	group: ${{ github.workflow }}-${{ github.ref_name }}-${{ github.ref_name == 'main' && github.sha \|\| 'anysha' }}
	cancel-in-progress: true

	env:
	RUST_BACKTRACE: 1
	COPT: '-Werror'
	AWS_ACCESS_KEY_ID: ${{ secrets.AWS_ACCESS_KEY_DEV }}
	AWS_SECRET_ACCESS_KEY: ${{ secrets.AWS_SECRET_KEY_DEV }}
	# A concurrency group that we use for e2e-tests runs, matches `concurrency.group` above with `github.repository` as a prefix
	E2E_CONCURRENCY_GROUP: ${{ github.repository }}-e2e-tests-${{ github.ref_name }}-${{ github.ref_name == 'main' && github.sha \|\| 'anysha' }}

	jobs:
	check-permissions:
	if: ${{ !contains(github.event.pull_request.labels.*.name, 'run-no-ci') }}
	uses: ./.github/workflows/check-permissions.yml
	with:
	github-event-name: ${{ github.event_name }}

	cancel-previous-e2e-tests:
	needs: [ check-permissions ]
	if: github.event_name == 'pull_request'
	runs-on: ubuntu-22.04

	steps:
	- name: Cancel previous e2e-tests runs for this PR
	env:
	GH_TOKEN: ${{ secrets.CI_ACCESS_TOKEN }}
	run: \|
	gh workflow --repo neondatabase/cloud \
	run cancel-previous-in-concurrency-group.yml \
	--field concurrency_group="${{ env.E2E_CONCURRENCY_GROUP }}"

	tag:
	needs: [ check-permissions ]
	runs-on: [ self-hosted, small ]
	container: 369495373322.dkr.ecr.eu-central-1.amazonaws.com/base:pinned
	outputs:
	build-tag: ${{steps.build-tag.outputs.tag}}

	steps:
	# Need `fetch-depth: 0` to count the number of commits in the branch
	- uses: actions/checkout@v4
	with:
	fetch-depth: 0

	- name: Get build tag
	run: \|
	echo run:$GITHUB_RUN_ID
	echo ref:$GITHUB_REF_NAME
	echo rev:$(git rev-list --count HEAD)
	if [[ "$GITHUB_REF_NAME" == "main" ]]; then
	echo "tag=$(git rev-list --count HEAD)" >> $GITHUB_OUTPUT
	elif [[ "$GITHUB_REF_NAME" == "release" ]]; then
	echo "tag=release-$(git rev-list --count HEAD)" >> $GITHUB_OUTPUT
	elif [[ "$GITHUB_REF_NAME" == "release-proxy" ]]; then
	echo "tag=release-proxy-$(git rev-list --count HEAD)" >> $GITHUB_OUTPUT
	else
	echo "GITHUB_REF_NAME (value '$GITHUB_REF_NAME') is not set to either 'main' or 'release'"
	echo "tag=$GITHUB_RUN_ID" >> $GITHUB_OUTPUT
	fi
	shell: bash
	id: build-tag

	check-build-tools-image:
	needs: [ check-permissions ]
	uses: ./.github/workflows/check-build-tools-image.yml

	build-build-tools-image:
	needs: [ check-build-tools-image ]
	uses: ./.github/workflows/build-build-tools-image.yml
	with:
	image-tag: ${{ needs.check-build-tools-image.outputs.image-tag }}
	secrets: inherit

	check-codestyle-python:
	needs: [ check-permissions, build-build-tools-image ]
	uses: ./.github/workflows/_check-codestyle-python.yml
	with:
	build-tools-image: ${{ needs.build-build-tools-image.outputs.image }}-bookworm
	secrets: inherit

	check-codestyle-jsonnet:
	needs: [ check-permissions, build-build-tools-image ]
	runs-on: [ self-hosted, small ]
	container:
	image: ${{ needs.build-build-tools-image.outputs.image }}
	credentials:
	username: ${{ secrets.NEON_DOCKERHUB_USERNAME }}
	password: ${{ secrets.NEON_DOCKERHUB_PASSWORD }}
	options: --init

	steps:
	- name: Checkout
	uses: actions/checkout@v4

	- name: Check Jsonnet code formatting
	run: \|
	make -C compute jsonnetfmt-test

	# Check that the vendor/postgres-* submodules point to the
	# corresponding REL_*_STABLE_neon branches.
	check-submodules:
	needs: [ check-permissions ]
	runs-on: ubuntu-22.04
	steps:
	- name: Checkout
	uses: actions/checkout@v4
	with:
	submodules: true

	- uses: dorny/paths-filter@v3
	id: check-if-submodules-changed
	with:
	filters: \|
	vendor:
	- 'vendor/**'

	- name: Check vendor/postgres-v14 submodule reference
	if: steps.check-if-submodules-changed.outputs.vendor == 'true'
	uses: jtmullen/submodule-branch-check-action@v1
	with:
	path: "vendor/postgres-v14"
	fetch_depth: "50"
	sub_fetch_depth: "50"
	pass_if_unchanged: true

	- name: Check vendor/postgres-v15 submodule reference
	if: steps.check-if-submodules-changed.outputs.vendor == 'true'
	uses: jtmullen/submodule-branch-check-action@v1
	with:
	path: "vendor/postgres-v15"
	fetch_depth: "50"
	sub_fetch_depth: "50"
	pass_if_unchanged: true

	- name: Check vendor/postgres-v16 submodule reference
	if: steps.check-if-submodules-changed.outputs.vendor == 'true'
	uses: jtmullen/submodule-branch-check-action@v1
	with:
	path: "vendor/postgres-v16"
	fetch_depth: "50"
	sub_fetch_depth: "50"
	pass_if_unchanged: true

	- name: Check vendor/postgres-v17 submodule reference
	if: steps.check-if-submodules-changed.outputs.vendor == 'true'
	uses: jtmullen/submodule-branch-check-action@v1
	with:
	path: "vendor/postgres-v17"
	fetch_depth: "50"
	sub_fetch_depth: "50"
	pass_if_unchanged: true

	check-codestyle-rust:
	needs: [ check-permissions, build-build-tools-image ]
	strategy:
	matrix:
	arch: [ x64, arm64 ]
	runs-on: ${{ fromJson(format('["self-hosted", "{0}"]', matrix.arch == 'arm64' && 'small-arm64' \|\| 'small')) }}

	container:
	image: ${{ needs.build-build-tools-image.outputs.image }}-bookworm
	credentials:
	username: ${{ secrets.NEON_DOCKERHUB_USERNAME }}
	password: ${{ secrets.NEON_DOCKERHUB_PASSWORD }}
	options: --init

	steps:
	- name: Checkout
	uses: actions/checkout@v4
	with:
	submodules: true

	- name: Cache cargo deps
	uses: actions/cache@v4
	with:
	path: \|
	~/.cargo/registry
	!~/.cargo/registry/src
	~/.cargo/git
	target
	key: v1-${{ runner.os }}-${{ runner.arch }}-cargo-${{ hashFiles('./Cargo.lock') }}-${{ hashFiles('./rust-toolchain.toml') }}-rust

	# Some of our rust modules use FFI and need those to be checked
	- name: Get postgres headers
	run: make postgres-headers -j$(nproc)

	# cargo hack runs the given cargo subcommand (clippy in this case) for all feature combinations.
	# This will catch compiler & clippy warnings in all feature combinations.
	# TODO: use cargo hack for build and test as well, but, that's quite expensive.
	# NB: keep clippy args in sync with ./run_clippy.sh
	#
	# The only difference between "clippy --debug" and "clippy --release" is that in --release mode,
	# #[cfg(debug_assertions)] blocks are not built. It's not worth building everything for second
	# time just for that, so skip "clippy --release".
	- run: \|
	CLIPPY_COMMON_ARGS="$( source .neon_clippy_args; echo "$CLIPPY_COMMON_ARGS")"
	if [ "$CLIPPY_COMMON_ARGS" = "" ]; then
	echo "No clippy args found in .neon_clippy_args"
	exit 1
	fi
	echo "CLIPPY_COMMON_ARGS=${CLIPPY_COMMON_ARGS}" >> $GITHUB_ENV
	- name: Run cargo clippy (debug)
	run: cargo hack --feature-powerset clippy $CLIPPY_COMMON_ARGS

	- name: Check documentation generation
	run: cargo doc --workspace --no-deps --document-private-items
	env:
	RUSTDOCFLAGS: "-Dwarnings -Arustdoc::private_intra_doc_links"

	# Use `${{ !cancelled() }}` to run quck tests after the longer clippy run
	- name: Check formatting
	if: ${{ !cancelled() }}
	run: cargo fmt --all -- --check

	# https://github.com/facebookincubator/cargo-guppy/tree/bec4e0eb29dcd1faac70b1b5360267fc02bf830e/tools/cargo-hakari#2-keep-the-workspace-hack-up-to-date-in-ci
	- name: Check rust dependencies
	if: ${{ !cancelled() }}
	run: \|
	cargo hakari generate --diff # workspace-hack Cargo.toml is up-to-date
	cargo hakari manage-deps --dry-run # all workspace crates depend on workspace-hack

	# https://github.com/EmbarkStudios/cargo-deny
	- name: Check rust licenses/bans/advisories/sources
	if: ${{ !cancelled() }}
	run: cargo deny check --hide-inclusion-graph

	build-and-test-locally:
	needs: [ tag, build-build-tools-image ]
	strategy:
	fail-fast: false
	matrix:
	arch: [ x64, arm64 ]
	# Do not build or run tests in debug for release branches
	build-type: ${{ fromJson((startsWith(github.ref_name, 'release') && github.event_name == 'push') && '["release"]' \|\| '["debug", "release"]') }}
	include:
	- build-type: release
	arch: arm64
	uses: ./.github/workflows/_build-and-test-locally.yml
	with:
	arch: ${{ matrix.arch }}
	build-tools-image: ${{ needs.build-build-tools-image.outputs.image }}-bookworm
	build-tag: ${{ needs.tag.outputs.build-tag }}
	build-type: ${{ matrix.build-type }}
	# Run tests on all Postgres versions in release builds and only on the latest version in debug builds
	pg-versions: ${{ matrix.build-type == 'release' && '["v14", "v15", "v16", "v17"]' \|\| '["v17"]' }}
	secrets: inherit

	# Keep `benchmarks` job outside of `build-and-test-locally` workflow to make job failures non-blocking
	get-benchmarks-durations:
	if: github.ref_name == 'main' \|\| contains(github.event.pull_request.labels.*.name, 'run-benchmarks')
	outputs:
	json: ${{ steps.get-benchmark-durations.outputs.json }}
	needs: [ check-permissions, build-build-tools-image ]
	runs-on: [ self-hosted, small ]
	container:
	image: ${{ needs.build-build-tools-image.outputs.image }}-bookworm
	credentials:
	username: ${{ secrets.NEON_DOCKERHUB_USERNAME }}
	password: ${{ secrets.NEON_DOCKERHUB_PASSWORD }}
	options: --init
	steps:
	- name: Checkout
	uses: actions/checkout@v4

	- name: Cache poetry deps
	uses: actions/cache@v4
	with:
	path: ~/.cache/pypoetry/virtualenvs
	key: v2-${{ runner.os }}-${{ runner.arch }}-python-deps-bookworm-${{ hashFiles('poetry.lock') }}

	- name: Install Python deps
	run: ./scripts/pysync

	- name: get benchmark durations
	id: get-benchmark-durations
	env:
	TEST_RESULT_CONNSTR: ${{ secrets.REGRESS_TEST_RESULT_CONNSTR_NEW }}
	run: \|
	poetry run ./scripts/benchmark_durations.py "${TEST_RESULT_CONNSTR}" \
	--days 10 \
	--output /tmp/benchmark_durations.json
	echo "json=$(jq --compact-output '.' /tmp/benchmark_durations.json)" >> $GITHUB_OUTPUT

	benchmarks:
	if: github.ref_name == 'main' \|\| contains(github.event.pull_request.labels.*.name, 'run-benchmarks')
	needs: [ check-permissions, build-and-test-locally, build-build-tools-image, get-benchmarks-durations ]
	runs-on: [ self-hosted, small ]
	container:
	image: ${{ needs.build-build-tools-image.outputs.image }}-bookworm
	credentials:
	username: ${{ secrets.NEON_DOCKERHUB_USERNAME }}
	password: ${{ secrets.NEON_DOCKERHUB_PASSWORD }}
	# for changed limits, see comments on `options:` earlier in this file
	options: --init --shm-size=512mb --ulimit memlock=67108864:67108864
	strategy:
	fail-fast: false
	matrix:
	# the amount of groups (N) should be reflected in `extra_params: --splits N ...`
	pytest_split_group: [ 1, 2, 3, 4, 5 ]
	build_type: [ release ]
	steps:
	- name: Checkout
	uses: actions/checkout@v4

	- name: Pytest benchmarks
	uses: ./.github/actions/run-python-test-set
	with:
	build_type: ${{ matrix.build_type }}
	test_selection: performance
	run_in_parallel: false
	save_perf_report: ${{ github.ref_name == 'main' }}
	extra_params: --splits 5 --group ${{ matrix.pytest_split_group }}
	benchmark_durations: ${{ needs.get-benchmarks-durations.outputs.json }}
	pg_version: v16
	env:
	VIP_VAP_ACCESS_TOKEN: "${{ secrets.VIP_VAP_ACCESS_TOKEN }}"
	PERF_TEST_RESULT_CONNSTR: "${{ secrets.PERF_TEST_RESULT_CONNSTR }}"
	TEST_RESULT_CONNSTR: "${{ secrets.REGRESS_TEST_RESULT_CONNSTR_NEW }}"
	PAGESERVER_VIRTUAL_FILE_IO_ENGINE: tokio-epoll-uring
	SYNC_BETWEEN_TESTS: true
	# XXX: no coverage data handling here, since benchmarks are run on release builds,
	# while coverage is currently collected for the debug ones

	report-benchmarks-failures:
	needs: [ benchmarks, create-test-report ]
	if: github.ref_name == 'main' && failure() && needs.benchmarks.result == 'failure'
	runs-on: ubuntu-22.04

	steps:
	- uses: slackapi/slack-github-action@v1
	with:
	channel-id: C060CNA47S9 # on-call-staging-storage-stream
	slack-message: \|
	Benchmarks failed on main <${{ github.event.head_commit.url }}\|${{ github.sha }}>
	<${{ needs.create-test-report.outputs.report-url }}\|Allure report>
	env:
	SLACK_BOT_TOKEN: ${{ secrets.SLACK_BOT_TOKEN }}

	create-test-report:
	needs: [ check-permissions, build-and-test-locally, coverage-report, build-build-tools-image, benchmarks ]
	if: ${{ !cancelled() && contains(fromJSON('["skipped", "success"]'), needs.check-permissions.result) }}
	outputs:
	report-url: ${{ steps.create-allure-report.outputs.report-url }}

	runs-on: [ self-hosted, small ]
	container:
	image: ${{ needs.build-build-tools-image.outputs.image }}-bookworm
	credentials:
	username: ${{ secrets.NEON_DOCKERHUB_USERNAME }}
	password: ${{ secrets.NEON_DOCKERHUB_PASSWORD }}
	options: --init

	steps:
	- uses: actions/checkout@v4

	- name: Create Allure report
	if: ${{ !cancelled() }}
	id: create-allure-report
	uses: ./.github/actions/allure-report-generate
	with:
	store-test-results-into-db: true
	env:
	REGRESS_TEST_RESULT_CONNSTR_NEW: ${{ secrets.REGRESS_TEST_RESULT_CONNSTR_NEW }}

	- uses: actions/github-script@v7
	if: ${{ !cancelled() }}
	with:
	# Retry script for 5XX server errors: https://github.com/actions/github-script#retries
	retries: 5
	script: \|
	const report = {
	reportUrl: "${{ steps.create-allure-report.outputs.report-url }}",
	reportJsonUrl: "${{ steps.create-allure-report.outputs.report-json-url }}",
	}

	const coverage = {
	coverageUrl: "${{ needs.coverage-report.outputs.coverage-html }}",
	summaryJsonUrl: "${{ needs.coverage-report.outputs.coverage-json }}",
	}

	const script = require("./scripts/comment-test-report.js")
	await script({
	github,
	context,
	fetch,
	report,
	coverage,
	})

	coverage-report:
	if: ${{ !startsWith(github.ref_name, 'release') }}
	needs: [ check-permissions, build-build-tools-image, build-and-test-locally ]
	runs-on: [ self-hosted, small ]
	container:
	image: ${{ needs.build-build-tools-image.outputs.image }}-bookworm
	credentials:
	username: ${{ secrets.NEON_DOCKERHUB_USERNAME }}
	password: ${{ secrets.NEON_DOCKERHUB_PASSWORD }}
	options: --init
	strategy:
	fail-fast: false
	matrix:
	build_type: [ debug ]
	outputs:
	coverage-html: ${{ steps.upload-coverage-report-new.outputs.report-url }}
	coverage-json: ${{ steps.upload-coverage-report-new.outputs.summary-json }}
	steps:
	# Need `fetch-depth: 0` for differential coverage (to get diff between two commits)
	- uses: actions/checkout@v4
	with:
	submodules: true
	fetch-depth: 0

	- name: Get Neon artifact
	uses: ./.github/actions/download
	with:
	name: neon-${{ runner.os }}-${{ runner.arch }}-${{ matrix.build_type }}-artifact
	path: /tmp/neon

	- name: Get coverage artifact
	uses: ./.github/actions/download
	with:
	name: coverage-data-artifact
	path: /tmp/coverage

	- name: Merge coverage data
	run: scripts/coverage "--profraw-prefix=$GITHUB_JOB" --dir=/tmp/coverage merge

	- name: Build coverage report
	env:
	COMMIT_URL: ${{ github.server_url }}/${{ github.repository }}/commit/${{ github.event.pull_request.head.sha \|\| github.sha }}
	run: \|
	scripts/coverage --dir=/tmp/coverage \
	report \
	--input-objects=/tmp/coverage/binaries.list \
	--commit-url=${COMMIT_URL} \
	--format=github

	scripts/coverage --dir=/tmp/coverage \
	report \
	--input-objects=/tmp/coverage/binaries.list \
	--format=lcov

	- name: Build coverage report NEW
	id: upload-coverage-report-new
	env:
	BUCKET: neon-github-public-dev
	# A differential coverage report is available only for PRs.
	# (i.e. for pushes into main/release branches we have a regular coverage report)
	COMMIT_SHA: ${{ github.event.pull_request.head.sha \|\| github.sha }}
	BASE_SHA: ${{ github.event.pull_request.base.sha \|\| github.sha }}
	run: \|
	CURRENT="${COMMIT_SHA}"
	BASELINE="$(git merge-base $BASE_SHA $CURRENT)"

	cp /tmp/coverage/report/lcov.info ./${CURRENT}.info

	GENHTML_ARGS="--ignore-errors path,unmapped,empty --synthesize-missing --demangle-cpp rustfilt --output-directory lcov-html ${CURRENT}.info"

	# Use differential coverage if the baseline coverage exists.
	# It can be missing if the coverage repoer wasn't uploaded yet or tests has failed on BASELINE commit.
	if aws s3 cp --only-show-errors s3://${BUCKET}/code-coverage/${BASELINE}/lcov.info ./${BASELINE}.info; then
	git diff ${BASELINE} ${CURRENT} -- '*.rs' > baseline-current.diff

	GENHTML_ARGS="--baseline-file ${BASELINE}.info --diff-file baseline-current.diff ${GENHTML_ARGS}"
	fi

	genhtml ${GENHTML_ARGS}

	aws s3 cp --only-show-errors --recursive ./lcov-html/ s3://${BUCKET}/code-coverage/${COMMIT_SHA}/lcov

	REPORT_URL=https://${BUCKET}.s3.amazonaws.com/code-coverage/${COMMIT_SHA}/lcov/index.html
	echo "report-url=${REPORT_URL}" >> $GITHUB_OUTPUT

	REPORT_URL=https://${BUCKET}.s3.amazonaws.com/code-coverage/${COMMIT_SHA}/lcov/summary.json
	echo "summary-json=${REPORT_URL}" >> $GITHUB_OUTPUT

	- uses: actions/github-script@v7
	env:
	REPORT_URL_NEW: ${{ steps.upload-coverage-report-new.outputs.report-url }}
	COMMIT_SHA: ${{ github.event.pull_request.head.sha \|\| github.sha }}
	with:
	# Retry script for 5XX server errors: https://github.com/actions/github-script#retries
	retries: 5
	script: \|
	const { REPORT_URL_NEW, COMMIT_SHA } = process.env

	await github.rest.repos.createCommitStatus({
	owner: context.repo.owner,
	repo: context.repo.repo,
	sha: `${COMMIT_SHA}`,
	state: 'success',
	target_url: `${REPORT_URL_NEW}`,
	context: 'Code coverage report NEW',
	})

	trigger-e2e-tests:
	if: ${{ !github.event.pull_request.draft \|\| contains( github.event.pull_request.labels.*.name, 'run-e2e-tests-in-draft') \|\| github.ref_name == 'main' \|\| github.ref_name == 'release' \|\| github.ref_name == 'release-proxy' }}
	needs: [ check-permissions, promote-images, tag ]
	uses: ./.github/workflows/trigger-e2e-tests.yml
	secrets: inherit

	neon-image-arch:
	needs: [ check-permissions, build-build-tools-image, tag ]
	strategy:
	matrix:
	arch: [ x64, arm64 ]

	runs-on: ${{ fromJson(format('["self-hosted", "{0}"]', matrix.arch == 'arm64' && 'large-arm64' \|\| 'large')) }}

	steps:
	- uses: actions/checkout@v4
	with:
	submodules: true

	- uses: neondatabase/dev-actions/set-docker-config-dir@6094485bf440001c94a94a3f9e221e81ff6b6193
	- uses: docker/setup-buildx-action@v3
	with:
	cache-binary: false

	- uses: docker/login-action@v3
	with:
	username: ${{ secrets.NEON_DOCKERHUB_USERNAME }}
	password: ${{ secrets.NEON_DOCKERHUB_PASSWORD }}

	- uses: docker/login-action@v3
	with:
	registry: cache.neon.build
	username: ${{ secrets.NEON_CI_DOCKERCACHE_USERNAME }}
	password: ${{ secrets.NEON_CI_DOCKERCACHE_PASSWORD }}

	- uses: docker/build-push-action@v6
	with:
	context: .
	# ARM-specific flags are recommended for Graviton ≥ 2, these flags are also supported by Ampere Altra (Azure)
	# https://github.com/aws/aws-graviton-getting-started/blob/57dc813626d0266f1cc12ef83474745bb1f31fb4/rust.md
	build-args: \|
	ADDITIONAL_RUSTFLAGS=${{ matrix.arch == 'arm64' && '-Ctarget-feature=+lse -Ctarget-cpu=neoverse-n1' \|\| '' }}
	GIT_VERSION=${{ github.event.pull_request.head.sha \|\| github.sha }}
	BUILD_TAG=${{ needs.tag.outputs.build-tag }}
	TAG=${{ needs.build-build-tools-image.outputs.image-tag }}-bookworm
	DEBIAN_VERSION=bookworm
	provenance: false
	push: true
	pull: true
	file: Dockerfile
	cache-from: type=registry,ref=cache.neon.build/neon:cache-bookworm-${{ matrix.arch }}
	cache-to: ${{ github.ref_name == 'main' && format('type=registry,ref=cache.neon.build/neon:cache-{0}-{1},mode=max', 'bookworm', matrix.arch) \|\| '' }}
	tags: \|
	neondatabase/neon:${{ needs.tag.outputs.build-tag }}-bookworm-${{ matrix.arch }}

	neon-image:
	needs: [ neon-image-arch, tag ]
	runs-on: ubuntu-22.04

	steps:
	- uses: docker/login-action@v3
	with:
	username: ${{ secrets.NEON_DOCKERHUB_USERNAME }}
	password: ${{ secrets.NEON_DOCKERHUB_PASSWORD }}

	- name: Create multi-arch image
	run: \|
	docker buildx imagetools create -t neondatabase/neon:${{ needs.tag.outputs.build-tag }} \
	-t neondatabase/neon:${{ needs.tag.outputs.build-tag }}-bookworm \
	neondatabase/neon:${{ needs.tag.outputs.build-tag }}-bookworm-x64 \
	neondatabase/neon:${{ needs.tag.outputs.build-tag }}-bookworm-arm64

	- uses: docker/login-action@v3
	with:
	registry: 369495373322.dkr.ecr.eu-central-1.amazonaws.com
	username: ${{ secrets.AWS_ACCESS_KEY_DEV }}
	password: ${{ secrets.AWS_SECRET_KEY_DEV }}

	- name: Push multi-arch image to ECR
	run: \|
	docker buildx imagetools create -t 369495373322.dkr.ecr.eu-central-1.amazonaws.com/neon:${{ needs.tag.outputs.build-tag }} \
	neondatabase/neon:${{ needs.tag.outputs.build-tag }}

	compute-node-image-arch:
	needs: [ check-permissions, build-build-tools-image, tag ]
	strategy:
	fail-fast: false
	matrix:
	version:
	# Much data was already generated on old PG versions with bullseye's
	# libraries, the locales of which can cause data incompatibilities.
	# However, new PG versions should be build on newer images,
	# as that reduces the support burden of old and ancient distros.
	- pg: v14
	debian: bullseye
	- pg: v15
	debian: bullseye
	- pg: v16
	debian: bullseye
	- pg: v17
	debian: bookworm
	arch: [ x64, arm64 ]

	runs-on: ${{ fromJson(format('["self-hosted", "{0}"]', matrix.arch == 'arm64' && 'large-arm64' \|\| 'large')) }}

	steps:
	- uses: actions/checkout@v4
	with:
	submodules: true

	- uses: neondatabase/dev-actions/set-docker-config-dir@6094485bf440001c94a94a3f9e221e81ff6b6193
	- uses: docker/setup-buildx-action@v3
	with:
	cache-binary: false
	# Disable parallelism for docker buildkit.
	# As we already build everything with `make -j$(nproc)`, running it in additional level of parallelisam blows up the Runner.
	buildkitd-config-inline: \|
	[worker.oci]
	max-parallelism = 1

	- uses: docker/login-action@v3
	with:
	username: ${{ secrets.NEON_DOCKERHUB_USERNAME }}
	password: ${{ secrets.NEON_DOCKERHUB_PASSWORD }}

	- uses: docker/login-action@v3
	with:
	registry: 369495373322.dkr.ecr.eu-central-1.amazonaws.com
	username: ${{ secrets.AWS_ACCESS_KEY_DEV }}
	password: ${{ secrets.AWS_SECRET_KEY_DEV }}

	- uses: docker/login-action@v3
	with:
	registry: cache.neon.build
	username: ${{ secrets.NEON_CI_DOCKERCACHE_USERNAME }}
	password: ${{ secrets.NEON_CI_DOCKERCACHE_PASSWORD }}

	- name: Build compute-node image
	uses: docker/build-push-action@v6
	with:
	context: .
	build-args: \|
	GIT_VERSION=${{ github.event.pull_request.head.sha \|\| github.sha }}
	PG_VERSION=${{ matrix.version.pg }}
	BUILD_TAG=${{ needs.tag.outputs.build-tag }}
	TAG=${{ needs.build-build-tools-image.outputs.image-tag }}-${{ matrix.version.debian }}
	DEBIAN_VERSION=${{ matrix.version.debian }}
	provenance: false
	push: true
	pull: true
	file: compute/compute-node.Dockerfile
	cache-from: type=registry,ref=cache.neon.build/compute-node-${{ matrix.version.pg }}:cache-${{ matrix.version.debian }}-${{ matrix.arch }}
	cache-to: ${{ github.ref_name == 'main' && format('type=registry,ref=cache.neon.build/compute-node-{0}:cache-{1}-{2},mode=max', matrix.version.pg, matrix.version.debian, matrix.arch) \|\| '' }}
	tags: \|
	neondatabase/compute-node-${{ matrix.version.pg }}:${{ needs.tag.outputs.build-tag }}-${{ matrix.version.debian }}-${{ matrix.arch }}

	- name: Build neon extensions test image
	if: matrix.version.pg == 'v16'
	uses: docker/build-push-action@v6
	with:
	context: .
	build-args: \|
	GIT_VERSION=${{ github.event.pull_request.head.sha \|\| github.sha }}
	PG_VERSION=${{ matrix.version.pg }}
	BUILD_TAG=${{ needs.tag.outputs.build-tag }}
	TAG=${{ needs.build-build-tools-image.outputs.image-tag }}-${{ matrix.version.debian }}
	DEBIAN_VERSION=${{ matrix.version.debian }}
	provenance: false
	push: true
	pull: true
	file: compute/compute-node.Dockerfile
	target: neon-pg-ext-test
	cache-from: type=registry,ref=cache.neon.build/neon-test-extensions-${{ matrix.version.pg }}:cache-${{ matrix.version.debian }}-${{ matrix.arch }}
	cache-to: ${{ github.ref_name == 'main' && format('type=registry,ref=cache.neon.build/neon-test-extensions-{0}:cache-{1}-{2},mode=max', matrix.version.pg, matrix.version.debian, matrix.arch) \|\| '' }}
	tags: \|
	neondatabase/neon-test-extensions-${{ matrix.version.pg }}:${{needs.tag.outputs.build-tag}}-${{ matrix.version.debian }}-${{ matrix.arch }}

	- name: Build compute-tools image
	# compute-tools are Postgres independent, so build it only once
	# We pick 16, because that builds on debian 11 with older glibc (and is
	# thus compatible with newer glibc), rather than 17 on Debian 12, as
	# that isn't guaranteed to be compatible with Debian 11
	if: matrix.version.pg == 'v16'
	uses: docker/build-push-action@v6
	with:
	target: compute-tools-image
	context: .
	build-args: \|
	GIT_VERSION=${{ github.event.pull_request.head.sha \|\| github.sha }}
	BUILD_TAG=${{ needs.tag.outputs.build-tag }}
	TAG=${{ needs.build-build-tools-image.outputs.image-tag }}-${{ matrix.version.debian }}
	DEBIAN_VERSION=${{ matrix.version.debian }}
	provenance: false
	push: true
	pull: true
	file: compute/compute-node.Dockerfile
	cache-from: type=registry,ref=cache.neon.build/neon-test-extensions-${{ matrix.version.pg }}:cache-${{ matrix.version.debian }}-${{ matrix.arch }}
	cache-to: ${{ github.ref_name == 'main' && format('type=registry,ref=cache.neon.build/compute-tools-{0}:cache-{1}-{2},mode=max', matrix.version.pg, matrix.version.debian, matrix.arch) \|\| '' }}
	tags: \|
	neondatabase/compute-tools:${{ needs.tag.outputs.build-tag }}-${{ matrix.version.debian }}-${{ matrix.arch }}

	compute-node-image:
	needs: [ compute-node-image-arch, tag ]
	runs-on: ubuntu-22.04

	strategy:
	matrix:
	version:
	# see the comment for `compute-node-image-arch` job
	- pg: v14
	debian: bullseye
	- pg: v15
	debian: bullseye
	- pg: v16
	debian: bullseye
	- pg: v17
	debian: bookworm

	steps:
	- uses: docker/login-action@v3
	with:
	username: ${{ secrets.NEON_DOCKERHUB_USERNAME }}
	password: ${{ secrets.NEON_DOCKERHUB_PASSWORD }}

	- name: Create multi-arch compute-node image
	run: \|
	docker buildx imagetools create -t neondatabase/compute-node-${{ matrix.version.pg }}:${{ needs.tag.outputs.build-tag }} \
	-t neondatabase/compute-node-${{ matrix.version.pg }}:${{ needs.tag.outputs.build-tag }}-${{ matrix.version.debian }} \
	neondatabase/compute-node-${{ matrix.version.pg }}:${{ needs.tag.outputs.build-tag }}-${{ matrix.version.debian }}-x64 \
	neondatabase/compute-node-${{ matrix.version.pg }}:${{ needs.tag.outputs.build-tag }}-${{ matrix.version.debian }}-arm64

	- name: Create multi-arch neon-test-extensions image
	if: matrix.version.pg == 'v16'
	run: \|
	docker buildx imagetools create -t neondatabase/neon-test-extensions-${{ matrix.version.pg }}:${{ needs.tag.outputs.build-tag }} \
	-t neondatabase/neon-test-extensions-${{ matrix.version.pg }}:${{ needs.tag.outputs.build-tag }}-${{ matrix.version.debian }} \
	neondatabase/neon-test-extensions-${{ matrix.version.pg }}:${{ needs.tag.outputs.build-tag }}-${{ matrix.version.debian }}-x64 \
	neondatabase/neon-test-extensions-${{ matrix.version.pg }}:${{ needs.tag.outputs.build-tag }}-${{ matrix.version.debian }}-arm64

	- name: Create multi-arch compute-tools image
	if: matrix.version.pg == 'v16'
	run: \|
	docker buildx imagetools create -t neondatabase/compute-tools:${{ needs.tag.outputs.build-tag }} \
	-t neondatabase/compute-tools:${{ needs.tag.outputs.build-tag }}-${{ matrix.version.debian }} \
	neondatabase/compute-tools:${{ needs.tag.outputs.build-tag }}-${{ matrix.version.debian }}-x64 \
	neondatabase/compute-tools:${{ needs.tag.outputs.build-tag }}-${{ matrix.version.debian }}-arm64

	- uses: docker/login-action@v3
	with:
	registry: 369495373322.dkr.ecr.eu-central-1.amazonaws.com
	username: ${{ secrets.AWS_ACCESS_KEY_DEV }}
	password: ${{ secrets.AWS_SECRET_KEY_DEV }}

	- name: Push multi-arch compute-node-${{ matrix.version.pg }} image to ECR
	run: \|
	docker buildx imagetools create -t 369495373322.dkr.ecr.eu-central-1.amazonaws.com/compute-node-${{ matrix.version.pg }}:${{ needs.tag.outputs.build-tag }} \
	neondatabase/compute-node-${{ matrix.version.pg }}:${{ needs.tag.outputs.build-tag }}

	- name: Push multi-arch compute-tools image to ECR
	if: matrix.version.pg == 'v16'
	run: \|
	docker buildx imagetools create -t 369495373322.dkr.ecr.eu-central-1.amazonaws.com/compute-tools:${{ needs.tag.outputs.build-tag }} \
	neondatabase/compute-tools:${{ needs.tag.outputs.build-tag }}

	vm-compute-node-image:
	needs: [ check-permissions, tag, compute-node-image ]
	runs-on: [ self-hosted, large ]
	strategy:
	fail-fast: false
	matrix:
	version:
	# see the comment for `compute-node-image-arch` job
	- pg: v14
	debian: bullseye
	- pg: v15
	debian: bullseye
	- pg: v16
	debian: bullseye
	- pg: v17
	debian: bookworm
	env:
	VM_BUILDER_VERSION: v0.35.0

	steps:
	- uses: actions/checkout@v4

	- name: Downloading vm-builder
	run: \|
	curl -fL https://github.com/neondatabase/autoscaling/releases/download/$VM_BUILDER_VERSION/vm-builder -o vm-builder
	chmod +x vm-builder

	- uses: neondatabase/dev-actions/set-docker-config-dir@6094485bf440001c94a94a3f9e221e81ff6b6193
	- uses: docker/login-action@v3
	with:
	username: ${{ secrets.NEON_DOCKERHUB_USERNAME }}
	password: ${{ secrets.NEON_DOCKERHUB_PASSWORD }}

	# Note: we need a separate pull step here because otherwise vm-builder will try to pull, and
	# it won't have the proper authentication (written at v0.6.0)
	- name: Pulling compute-node image
	run: \|
	docker pull neondatabase/compute-node-${{ matrix.version.pg }}:${{ needs.tag.outputs.build-tag }}

	- name: Build vm image
	run: \|
	./vm-builder \
	-size=2G \
	-spec=compute/vm-image-spec-${{ matrix.version.debian }}.yaml \
	-src=neondatabase/compute-node-${{ matrix.version.pg }}:${{ needs.tag.outputs.build-tag }} \
	-dst=neondatabase/vm-compute-node-${{ matrix.version.pg }}:${{ needs.tag.outputs.build-tag }}

	- name: Pushing vm-compute-node image
	run: \|
	docker push neondatabase/vm-compute-node-${{ matrix.version.pg }}:${{ needs.tag.outputs.build-tag }}

	test-images:
	needs: [ check-permissions, tag, neon-image, compute-node-image ]
	strategy:
	fail-fast: false
	matrix:
	arch: [ x64, arm64 ]

	runs-on: ${{ fromJson(format('["self-hosted", "{0}"]', matrix.arch == 'arm64' && 'small-arm64' \|\| 'small')) }}

	steps:
	- uses: actions/checkout@v4

	- uses: neondatabase/dev-actions/set-docker-config-dir@6094485bf440001c94a94a3f9e221e81ff6b6193
	- uses: docker/login-action@v3
	with:
	username: ${{ secrets.NEON_DOCKERHUB_USERNAME }}
	password: ${{ secrets.NEON_DOCKERHUB_PASSWORD }}

	# `neondatabase/neon` contains multiple binaries, all of them use the same input for the version into the same version formatting library.
	# Pick pageserver as currently the only binary with extra "version" features printed in the string to verify.
	# Regular pageserver version string looks like
	# Neon page server git-env:32d14403bd6ab4f4520a94cbfd81a6acef7a526c failpoints: true, features: []
	# Bad versions might loop like:
	# Neon page server git-env:local failpoints: true, features: ["testing"]
	# Ensure that we don't have bad versions.
	- name: Verify image versions
	shell: bash # ensure no set -e for better error messages
	run: \|
	pageserver_version=$(docker run --rm neondatabase/neon:${{ needs.tag.outputs.build-tag }} "/bin/sh" "-c" "/usr/local/bin/pageserver --version")

	echo "Pageserver version string: $pageserver_version"

	if ! echo "$pageserver_version" \| grep -qv 'git-env:local' ; then
	echo "Pageserver version should not be the default Dockerfile one"
	exit 1
	fi

	if ! echo "$pageserver_version" \| grep -qv '"testing"' ; then
	echo "Pageserver version should have no testing feature enabled"
	exit 1
	fi

	- name: Verify docker-compose example and test extensions
	timeout-minutes: 20
	run: env TAG=${{needs.tag.outputs.build-tag}} ./docker-compose/docker_compose_test.sh

	- name: Print logs and clean up
	if: always()
	run: \|
	docker compose -f ./docker-compose/docker-compose.yml logs \|\| 0
	docker compose -f ./docker-compose/docker-compose.yml down

	promote-images:
	needs: [ check-permissions, tag, test-images, vm-compute-node-image ]
	runs-on: ubuntu-22.04

	permissions:
	id-token: write # for `aws-actions/configure-aws-credentials`

	env:
	VERSIONS: v14 v15 v16 v17

	steps:
	- uses: docker/login-action@v3
	with:
	username: ${{ secrets.NEON_DOCKERHUB_USERNAME }}
	password: ${{ secrets.NEON_DOCKERHUB_PASSWORD }}

	- name: Login to dev ECR
	uses: docker/login-action@v3
	with:
	registry: 369495373322.dkr.ecr.eu-central-1.amazonaws.com
	username: ${{ secrets.AWS_ACCESS_KEY_DEV }}
	password: ${{ secrets.AWS_SECRET_KEY_DEV }}

	- name: Copy vm-compute-node images to ECR
	run: \|
	for version in ${VERSIONS}; do
	docker buildx imagetools create -t 369495373322.dkr.ecr.eu-central-1.amazonaws.com/vm-compute-node-${version}:${{ needs.tag.outputs.build-tag }} \
	neondatabase/vm-compute-node-${version}:${{ needs.tag.outputs.build-tag }}
	done

	- name: Add latest tag to images
	if: github.ref_name == 'main'
	run: \|
	for repo in neondatabase 369495373322.dkr.ecr.eu-central-1.amazonaws.com; do
	docker buildx imagetools create -t $repo/neon:latest \
	$repo/neon:${{ needs.tag.outputs.build-tag }}

	docker buildx imagetools create -t $repo/compute-tools:latest \
	$repo/compute-tools:${{ needs.tag.outputs.build-tag }}

	for version in ${VERSIONS}; do
	docker buildx imagetools create -t $repo/compute-node-${version}:latest \
	$repo/compute-node-${version}:${{ needs.tag.outputs.build-tag }}

	docker buildx imagetools create -t $repo/vm-compute-node-${version}:latest \
	$repo/vm-compute-node-${version}:${{ needs.tag.outputs.build-tag }}
	done
	done
	docker buildx imagetools create -t neondatabase/neon-test-extensions-v16:latest \
	neondatabase/neon-test-extensions-v16:${{ needs.tag.outputs.build-tag }}

	- name: Configure AWS-prod credentials
	if: github.ref_name == 'release'\|\| github.ref_name == 'release-proxy'
	uses: aws-actions/configure-aws-credentials@v4
	with:
	aws-region: eu-central-1
	mask-aws-account-id: true
	role-to-assume: ${{ secrets.PROD_GHA_OIDC_ROLE }}

	- name: Login to prod ECR
	uses: docker/login-action@v3
	if: github.ref_name == 'release'\|\| github.ref_name == 'release-proxy'
	with:
	registry: 093970136003.dkr.ecr.eu-central-1.amazonaws.com

	- name: Copy all images to prod ECR
	if: github.ref_name == 'release'\|\| github.ref_name == 'release-proxy'
	run: \|
	for image in neon compute-tools {vm-,}compute-node-{v14,v15,v16,v17}; do
	docker buildx imagetools create -t 093970136003.dkr.ecr.eu-central-1.amazonaws.com/${image}:${{ needs.tag.outputs.build-tag }} \
	369495373322.dkr.ecr.eu-central-1.amazonaws.com/${image}:${{ needs.tag.outputs.build-tag }}
	done

	push-to-acr-dev:
	if: github.ref_name == 'main'
	needs: [ tag, promote-images ]
	uses: ./.github/workflows/_push-to-acr.yml
	with:
	client_id: ${{ vars.AZURE_DEV_CLIENT_ID }}
	image_tag: ${{ needs.tag.outputs.build-tag }}
	images: neon compute-tools vm-compute-node-v14 vm-compute-node-v15 vm-compute-node-v16 vm-compute-node-v17 compute-node-v14 compute-node-v15 compute-node-v16 compute-node-v17
	registry_name: ${{ vars.AZURE_DEV_REGISTRY_NAME }}
	subscription_id: ${{ vars.AZURE_DEV_SUBSCRIPTION_ID }}
	tenant_id: ${{ vars.AZURE_TENANT_ID }}

	push-to-acr-prod:
	if: github.ref_name == 'release'\|\| github.ref_name == 'release-proxy'
	needs: [ tag, promote-images ]
	uses: ./.github/workflows/_push-to-acr.yml
	with:
	client_id: ${{ vars.AZURE_PROD_CLIENT_ID }}
	image_tag: ${{ needs.tag.outputs.build-tag }}
	images: neon compute-tools vm-compute-node-v14 vm-compute-node-v15 vm-compute-node-v16 vm-compute-node-v17 compute-node-v14 compute-node-v15 compute-node-v16 compute-node-v17
	registry_name: ${{ vars.AZURE_PROD_REGISTRY_NAME }}
	subscription_id: ${{ vars.AZURE_PROD_SUBSCRIPTION_ID }}
	tenant_id: ${{ vars.AZURE_TENANT_ID }}

	trigger-custom-extensions-build-and-wait:
	needs: [ check-permissions, tag ]
	runs-on: ubuntu-22.04
	steps:
	- name: Set PR's status to pending and request a remote CI test
	run: \|
	COMMIT_SHA=${{ github.event.pull_request.head.sha \|\| github.sha }}
	REMOTE_REPO="${{ github.repository_owner }}/build-custom-extensions"

	curl -f -X POST \
	https://api.github.com/repos/${{ github.repository }}/statuses/$COMMIT_SHA \
	-H "Accept: application/vnd.github.v3+json" \
	--user "${{ secrets.CI_ACCESS_TOKEN }}" \
	--data \
	"{
	\"state\": \"pending\",
	\"context\": \"build-and-upload-extensions\",
	\"description\": \"[$REMOTE_REPO] Remote CI job is about to start\"
	}"

	curl -f -X POST \
	https://api.github.com/repos/$REMOTE_REPO/actions/workflows/build_and_upload_extensions.yml/dispatches \
	-H "Accept: application/vnd.github.v3+json" \
	--user "${{ secrets.CI_ACCESS_TOKEN }}" \
	--data \
	"{
	\"ref\": \"main\",
	\"inputs\": {
	\"ci_job_name\": \"build-and-upload-extensions\",
	\"commit_hash\": \"$COMMIT_SHA\",
	\"remote_repo\": \"${{ github.repository }}\",
	\"compute_image_tag\": \"${{ needs.tag.outputs.build-tag }}\",
	\"remote_branch_name\": \"${{ github.ref_name }}\"
	}
	}"

	- name: Wait for extension build to finish
	env:
	GH_TOKEN: ${{ secrets.CI_ACCESS_TOKEN }}
	run: \|
	TIMEOUT=1800 # 30 minutes, usually it takes ~2-3 minutes, but if runners are busy, it might take longer
	INTERVAL=15 # try each N seconds

	last_status="" # a variable to carry the last status of the "build-and-upload-extensions" context

	for ((i=0; i <= TIMEOUT; i+=INTERVAL)); do
	sleep $INTERVAL

	# Get statuses for the latest commit in the PR / branch
	gh api \
	-H "Accept: application/vnd.github+json" \
	-H "X-GitHub-Api-Version: 2022-11-28" \
	"/repos/${{ github.repository }}/statuses/${{ github.event.pull_request.head.sha \|\| github.sha }}" > statuses.json

	# Get the latest status for the "build-and-upload-extensions" context
	last_status=$(jq --raw-output '[.[] \| select(.context == "build-and-upload-extensions")] \| sort_by(.created_at)[-1].state' statuses.json)
	if [ "${last_status}" = "pending" ]; then
	# Extension build is still in progress.
	continue
	elif [ "${last_status}" = "success" ]; then
	# Extension build is successful.
	exit 0
	else
	# Status is neither "pending" nor "success", exit the loop and fail the job.
	break
	fi
	done

	# Extension build failed, print `statuses.json` for debugging and fail the job.
	jq '.' statuses.json

	echo >&2 "Status of extension build is '${last_status}' != 'success'"
	exit 1

	deploy:
	needs: [ check-permissions, promote-images, tag, build-and-test-locally, trigger-custom-extensions-build-and-wait, push-to-acr-dev, push-to-acr-prod ]
	# `!failure() && !cancelled()` is required because the workflow depends on the job that can be skipped: `push-to-acr-dev` and `push-to-acr-prod`
	if: (github.ref_name == 'main' \|\| github.ref_name == 'release' \|\| github.ref_name == 'release-proxy') && !failure() && !cancelled()

	runs-on: [ self-hosted, small ]
	container: 369495373322.dkr.ecr.eu-central-1.amazonaws.com/ansible:latest
	steps:
	- uses: actions/checkout@v4

	- name: Trigger deploy workflow
	env:
	GH_TOKEN: ${{ secrets.CI_ACCESS_TOKEN }}
	run: \|
	if [[ "$GITHUB_REF_NAME" == "main" ]]; then
	gh workflow --repo neondatabase/infra run deploy-dev.yml --ref main -f branch=main -f dockerTag=${{needs.tag.outputs.build-tag}} -f deployPreprodRegion=false
	elif [[ "$GITHUB_REF_NAME" == "release" ]]; then
	gh workflow --repo neondatabase/infra run deploy-dev.yml --ref main \
	-f deployPgSniRouter=false \
	-f deployProxy=false \
	-f deployStorage=true \
	-f deployStorageBroker=true \
	-f deployStorageController=true \
	-f branch=main \
	-f dockerTag=${{needs.tag.outputs.build-tag}} \
	-f deployPreprodRegion=true

	gh workflow --repo neondatabase/infra run deploy-prod.yml --ref main \
	-f deployStorage=true \
	-f deployStorageBroker=true \
	-f deployStorageController=true \
	-f branch=main \
	-f dockerTag=${{needs.tag.outputs.build-tag}}
	elif [[ "$GITHUB_REF_NAME" == "release-proxy" ]]; then
	gh workflow --repo neondatabase/infra run deploy-dev.yml --ref main \
	-f deployPgSniRouter=true \
	-f deployProxy=true \
	-f deployStorage=false \
	-f deployStorageBroker=false \
	-f deployStorageController=false \
	-f branch=main \
	-f dockerTag=${{needs.tag.outputs.build-tag}} \
	-f deployPreprodRegion=true

	gh workflow --repo neondatabase/infra run deploy-proxy-prod.yml --ref main \
	-f deployPgSniRouter=true \
	-f deployProxyLink=true \
	-f deployPrivatelinkProxy=true \
	-f deployProxyScram=true \
	-f deployProxyAuthBroker=true \
	-f branch=main \
	-f dockerTag=${{needs.tag.outputs.build-tag}}
	else
	echo "GITHUB_REF_NAME (value '$GITHUB_REF_NAME') is not set to either 'main' or 'release'"
	exit 1
	fi

	- name: Create git tag
	if: github.ref_name == 'release' \|\| github.ref_name == 'release-proxy'
	uses: actions/github-script@v7
	with:
	# Retry script for 5XX server errors: https://github.com/actions/github-script#retries
	retries: 5
	script: \|
	await github.rest.git.createRef({
	owner: context.repo.owner,
	repo: context.repo.repo,
	ref: "refs/tags/${{ needs.tag.outputs.build-tag }}",
	sha: context.sha,
	})

	# TODO: check how GitHub releases looks for proxy releases and enable it if it's ok
	- name: Create GitHub release
	if: github.ref_name == 'release'
	uses: actions/github-script@v7
	with:
	# Retry script for 5XX server errors: https://github.com/actions/github-script#retries
	retries: 5
	script: \|
	await github.rest.repos.createRelease({
	owner: context.repo.owner,
	repo: context.repo.repo,
	tag_name: "${{ needs.tag.outputs.build-tag }}",
	generate_release_notes: true,
	})

	# The job runs on `release` branch and copies compatibility data and Neon artifact from the last release PR to the latest directory
	promote-compatibility-data:
	needs: [ deploy ]
	# `!failure() && !cancelled()` is required because the workflow transitively depends on the job that can be skipped: `push-to-acr-dev` and `push-to-acr-prod`
	if: github.ref_name == 'release' && !failure() && !cancelled()

	runs-on: ubuntu-22.04
	steps:
	- name: Fetch GITHUB_RUN_ID and COMMIT_SHA for the last merged release PR
	id: fetch-last-release-pr-info
	env:
	GH_TOKEN: ${{ secrets.GITHUB_TOKEN }}
	run: \|
	branch_name_and_pr_number=$(gh pr list \
	--repo "${GITHUB_REPOSITORY}" \
	--base release \
	--state merged \
	--limit 10 \
	--json mergeCommit,headRefName,number \
	--jq ".[] \| select(.mergeCommit.oid==\"${GITHUB_SHA}\") \| { branch_name: .headRefName, pr_number: .number }")
	branch_name=$(echo "${branch_name_and_pr_number}" \| jq -r '.branch_name')
	pr_number=$(echo "${branch_name_and_pr_number}" \| jq -r '.pr_number')

	run_id=$(gh run list \
	--repo "${GITHUB_REPOSITORY}" \
	--workflow build_and_test.yml \
	--branch "${branch_name}" \
	--json databaseId \
	--limit 1 \
	--jq '.[].databaseId')

	last_commit_sha=$(gh pr view "${pr_number}" \
	--repo "${GITHUB_REPOSITORY}" \
	--json commits \
	--jq '.commits[-1].oid')

	echo "run-id=${run_id}" \| tee -a ${GITHUB_OUTPUT}
	echo "commit-sha=${last_commit_sha}" \| tee -a ${GITHUB_OUTPUT}

	- name: Promote compatibility snapshot and Neon artifact
	env:
	BUCKET: neon-github-public-dev
	AWS_REGION: eu-central-1
	COMMIT_SHA: ${{ steps.fetch-last-release-pr-info.outputs.commit-sha }}
	RUN_ID: ${{ steps.fetch-last-release-pr-info.outputs.run-id }}
	run: \|
	old_prefix="artifacts/${COMMIT_SHA}/${RUN_ID}"
	new_prefix="artifacts/latest"

	files_to_promote=()
	files_on_s3=$(aws s3api list-objects-v2 --bucket ${BUCKET} --prefix ${old_prefix} \| jq -r '.Contents[]?.Key' \|\| true)

	for arch in X64 ARM64; do
	for build_type in debug release; do
	neon_artifact_filename="neon-Linux-${arch}-${build_type}-artifact.tar.zst"
	s3_key=$(echo "${files_on_s3}" \| grep ${neon_artifact_filename} \| sort --version-sort \| tail -1 \|\| true)
	if [ -z "${s3_key}" ]; then
	echo >&2 "Neither s3://${BUCKET}/${old_prefix}/${neon_artifact_filename} nor its version from previous attempts exist"
	exit 1
	fi

	files_to_promote+=("s3://${BUCKET}/${s3_key}")

	for pg_version in v14 v15 v16 v17; do
	# We run less tests for debug builds, so we don't need to promote them
	if [ "${build_type}" == "debug" ] && { [ "${arch}" == "ARM64" ] \|\| [ "${pg_version}" != "v17" ] ; }; then
	continue
	fi

	compatibility_data_filename="compatibility-snapshot-${arch}-${build_type}-pg${pg_version}.tar.zst"
	s3_key=$(echo "${files_on_s3}" \| grep ${compatibility_data_filename} \| sort --version-sort \| tail -1 \|\| true)
	if [ -z "${s3_key}" ]; then
	echo >&2 "Neither s3://${BUCKET}/${old_prefix}/${compatibility_data_filename} nor its version from previous attempts exist"
	exit 1
	fi

	files_to_promote+=("s3://${BUCKET}/${s3_key}")
	done
	done
	done

	for f in "${files_to_promote[@]}"; do
	time aws s3 cp --only-show-errors ${f} s3://${BUCKET}/${new_prefix}/
	done

	pin-build-tools-image:
	needs: [ build-build-tools-image, promote-images, build-and-test-locally ]
	if: github.ref_name == 'main'
	uses: ./.github/workflows/pin-build-tools-image.yml
	with:
	from-tag: ${{ needs.build-build-tools-image.outputs.image-tag }}
	secrets: inherit

	# This job simplifies setting branch protection rules (in GitHub UI)
	# by allowing to set only this job instead of listing many others.
	# It also makes it easier to rename or parametrise jobs (using matrix)
	# which requires changes in branch protection rules
	#
	# Note, that we can't add external check (like `neon-cloud-e2e`) we still need to use GitHub UI for that.
	#
	# https://github.com/neondatabase/neon/settings/branch_protection_rules
	conclusion:
	if: always()
	# Format `needs` differently to make the list more readable.
	# Usually we do `needs: [...]`
	needs:
	- build-and-test-locally
	- check-codestyle-python
	- check-codestyle-rust
	- promote-images
	- test-images
	- trigger-custom-extensions-build-and-wait
	runs-on: ubuntu-22.04
	steps:
	# The list of possible results:
	# https://docs.github.com/en/actions/learn-github-actions/contexts#needs-context
	- name: Fail the job if any of the dependencies do not succeed
	run: exit 1
	if: \|
	contains(needs.*.result, 'failure')
	\|\| contains(needs.*.result, 'cancelled')
	\|\| contains(needs.*.result, 'skipped')

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Collect max_connections metric #29386

Workflow file

Collect max_connections metric #29386

Jobs

Run details

Workflow file for this run