Skip to content

ABI Test

ABI Test #933

Workflow file for this run

# Test minimum and maximum ABI compatible postgres version
#
# Build timescaledb against specific postgres version and then run our
# tests with that library loaded in a different postgres version.
# This is to detect changes in required minimum/maximum postgres versions
# for our built packages.
# This test is expected to fail when upstream does ABI incompatible changes
# in a new minor postgresql version.
name: ABI Test
"on":
schedule:
# run daily 20:00 on main branch
- cron: '0 20 * * *'
push:
branches:
- prerelease_test
jobs:
config:
runs-on: ubuntu-latest
outputs:
pg13_abi_min: ${{ steps.config.outputs.pg13_abi_min }}
pg14_abi_min: ${{ steps.config.outputs.pg14_abi_min }}
pg15_abi_min: ${{ steps.config.outputs.pg15_abi_min }}
pg13_latest: ${{ steps.config.outputs.pg13_latest }}
pg14_latest: ${{ steps.config.outputs.pg14_latest }}
pg15_latest: ${{ steps.config.outputs.pg15_latest }}
steps:
- name: Checkout source code
uses: actions/checkout@v3
- name: Read configuration
id: config
run: python .github/gh_config_reader.py
abi_test:
name: ABI Test PG${{ matrix.test }}
runs-on: ubuntu-latest
needs: config
strategy:
fail-fast: false
matrix:
test: [ "13backward", "13forward", "14backward", "14forward",
"15backward", "15forward" ]
os: [ windows-2019 ]
include:
- test: 13backward
pg: 13
builder: ${{ fromJson(needs.config.outputs.pg13_latest) }}
tester: ${{ fromJson(needs.config.outputs.pg13_abi_min ) }}
- test: 13forward
pg: 13
builder: ${{ fromJson(needs.config.outputs.pg13_abi_min ) }}
tester: ${{ fromJson(needs.config.outputs.pg13_latest) }}
- test: 14backward
pg: 14
builder: ${{ fromJson(needs.config.outputs.pg14_latest) }}
tester: ${{ fromJson(needs.config.outputs.pg14_abi_min) }}
ignores: memoize
- test: 14forward
pg: 14
builder: ${{ fromJson(needs.config.outputs.pg14_abi_min) }}
tester: ${{ fromJson(needs.config.outputs.pg14_latest) }}
- test: 15backward
pg: 15
builder: ${{ fromJson(needs.config.outputs.pg15_latest) }}
tester: ${{ fromJson(needs.config.outputs.pg15_abi_min) }}
ignores: partialize_finalize
- test: 15forward
pg: 15
builder: ${{ fromJson(needs.config.outputs.pg15_abi_min) }}
tester: ${{ fromJson(needs.config.outputs.pg15_latest) }}
ignores: partialize_finalize
steps:
- name: Checkout TimescaleDB
uses: actions/checkout@v3
- name: Build extension
run: |
BUILDER_IMAGE="postgres:${{matrix.builder}}-alpine"
# Recent versions of alpine have OpenSSL 3 as the
# default version which is unfortunately not packaged
# for the earliest versions we check against in this
# test. So we pin the version we compile against to
# OpenSSL 1.1 in the backwards test.
if [[ "${{ matrix.test }}" == *backward ]]; then
EXTRA_PKGS="openssl1.1-compat-dev"
else
EXTRA_PKGS="openssl-dev"
fi
docker run -i --rm -v $(pwd):/mnt -e EXTRA_PKGS="${EXTRA_PKGS}" ${BUILDER_IMAGE} bash <<"EOF"
apk add cmake gcc make build-base krb5-dev git ${EXTRA_PKGS}
git config --global --add safe.directory /mnt
cd /mnt
BUILD_DIR=build_abi BUILD_FORCE_REMOVE=true ./bootstrap -DENABLE_MULTINODE_TESTS=ON
make -C build_abi install
mkdir -p build_abi/install_ext build_abi/install_lib
cp `pg_config --sharedir`/extension/timescaledb*.{control,sql} build_abi/install_ext
cp `pg_config --pkglibdir`/timescaledb*.so build_abi/install_lib
EOF
- name: Run tests
run: |
TEST_IMAGE="postgres:${{ matrix.tester }}-alpine"
if [[ "${{ matrix.test }}" == *backward ]]; then
EXTRA_PKGS="openssl-dev"
else
EXTRA_PKGS="openssl1.1-compat-dev"
fi
docker run -i --rm -v $(pwd):/mnt -e EXTRA_PKGS="${EXTRA_PKGS}" ${TEST_IMAGE} bash <<"EOF"
apk add cmake gcc make build-base krb5-dev sudo ${EXTRA_PKGS}
cd /mnt
cp build_abi/install_ext/* `pg_config --sharedir`/extension/
cp build_abi/install_lib/* `pg_config --pkglibdir`
chown -R postgres /mnt
set -o pipefail
sudo -u postgres make -C build_abi -k regresscheck regresscheck-t \
regresscheck-shared IGNORES="${{matrix.ignores}}" | tee installcheck.log
EOF
- name: Show regression diffs
if: always()
id: collectlogs
run: |
sudo chmod a+rw .
sudo find . -name regression.diffs -exec cat {} + > regression.log
sudo find . -name postmaster.log -exec cat {} + > postgres.log
if [[ -s regression.log ]]; then echo "regression_diff=true" >>$GITHUB_OUTPUT; fi
grep -e 'FAILED' -e 'failed (ignored)' installcheck.log || true
cat regression.log
- name: Save regression diffs
if: always() && steps.collectlogs.outputs.regression_diff == 'true'
uses: actions/upload-artifact@v3
with:
name: Regression diff ABI Breakage ${{ matrix.type }} PG${{ matrix.pg }}
path: regression.log
- name: Save postmaster.log
if: always()
uses: actions/upload-artifact@v3
with:
name: PostgreSQL log ABI Breakage ${{ matrix.type }} PG${{ matrix.pg }}
path: postgres.log