In "tests fail on old code" workflow, the old code must be the merge base #15341
Workflow file for this run
This file contains hidden or 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: pg_upgrade test | |
| "on": | |
| push: | |
| branches: | |
| - main | |
| - ?.*.x | |
| - prerelease_test | |
| pull_request: | |
| jobs: | |
| check_paths: | |
| runs-on: ubuntu-latest | |
| outputs: | |
| run_ci: >- | |
| ${{ github.event_name == 'push' | |
| || (steps.filter.outputs.sql == 'true' && !contains(github.event.pull_request.labels.*.name, 'skip-ci')) | |
| }} | |
| steps: | |
| - uses: actions/checkout@3d3c42e5aac5ba805825da76410c181273ba90b1 # v7.0.1 | |
| - uses: dorny/paths-filter@7b450fff21473bca461d4b92ce414b9d0420d706 # v4.0.2 | |
| id: filter | |
| with: | |
| filters: .github/filters.yaml | |
| pg_upgrade_test: | |
| needs: check_paths | |
| if: needs.check_paths.outputs.run_ci == 'true' | |
| name: pg_upgrade test from PG${{ matrix.pg_version_old }} to PG${{ matrix.pg_version_new }} | |
| runs-on: 'ubuntu-latest' | |
| strategy: | |
| matrix: | |
| include: | |
| - pg_version_old: 16 # 16 to 17 | |
| pg_version_new: 17 | |
| - pg_version_old: 16 # 16 to 18 | |
| pg_version_new: 18 | |
| - pg_version_old: 17 # 17 to 18 | |
| pg_version_new: 18 | |
| fail-fast: false | |
| env: | |
| OUTPUT_DIR: ${{ github.workspace }}/pg_upgrade_test | |
| steps: | |
| - name: Install Linux Dependencies | |
| timeout-minutes: 15 | |
| run: | | |
| sudo apt-get update | |
| sudo apt-get install pip postgresql-common | |
| - name: Install testgres | |
| run: | | |
| pip install testgres | |
| - name: Install PostgreSQL ${{ matrix.pg_version_old}} and ${{ matrix.pg_version_new }} | |
| timeout-minutes: 15 | |
| run: | | |
| yes | sudo /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh | |
| echo "deb https://packagecloud.io/timescale/timescaledb/ubuntu/ $(lsb_release -c -s) main" | sudo tee /etc/apt/sources.list.d/timescaledb.list | |
| wget --quiet --tries=6 --waitretry=15 -O - https://packagecloud.io/timescale/timescaledb/gpgkey | sudo apt-key add - | |
| sudo apt-get update | |
| sudo apt-get install -y \ | |
| postgresql-${{ matrix.pg_version_old }} postgresql-server-dev-${{ matrix.pg_version_old }} \ | |
| postgresql-${{ matrix.pg_version_new }} postgresql-server-dev-${{ matrix.pg_version_new }} | |
| sudo apt-get install -y --no-install-recommends \ | |
| timescaledb-2-postgresql-${{ matrix.pg_version_old }} \ | |
| timescaledb-2-postgresql-${{ matrix.pg_version_new }} | |
| - name: Checkout TimescaleDB | |
| uses: actions/checkout@3d3c42e5aac5ba805825da76410c181273ba90b1 # v7.0.1 | |
| - name: Build and install TimescaleDB on PostgreSQL ${{ matrix.pg_version_old}} | |
| env: | |
| BUILD_DIR: pg${{ matrix.pg_version_old }} | |
| run: | | |
| PATH="/usr/lib/postgresql/${{ matrix.pg_version_old }}/bin:$PATH" | |
| ./bootstrap -DCMAKE_BUILD_TYPE=Release -DWARNINGS_AS_ERRORS=OFF -DASSERTIONS=ON -DLINTER=OFF -DGENERATE_DOWNGRADE_SCRIPT=OFF -DREGRESS_CHECKS=OFF -DTAP_CHECKS=OFF | |
| make -j -C pg${{ matrix.pg_version_old }} | |
| sudo make -j -C pg${{ matrix.pg_version_old }} install | |
| - name: Build and install TimescaleDB on PostgreSQL ${{ matrix.pg_version_new}} | |
| env: | |
| BUILD_DIR: pg${{ matrix.pg_version_new }} | |
| run: | | |
| PATH="/usr/lib/postgresql/${{ matrix.pg_version_new }}/bin:$PATH" | |
| ./bootstrap -DCMAKE_BUILD_TYPE=Release -DWARNINGS_AS_ERRORS=OFF -DASSERTIONS=ON -DLINTER=OFF -DGENERATE_DOWNGRADE_SCRIPT=OFF -DREGRESS_CHECKS=OFF -DTAP_CHECKS=OFF | |
| make -j -C pg${{ matrix.pg_version_new }} | |
| sudo make -j -C pg${{ matrix.pg_version_new }} install | |
| - name: Run pg_upgrade test | |
| env: | |
| PGVERSIONOLD: ${{ matrix.pg_version_old }} | |
| PGVERSIONNEW: ${{ matrix.pg_version_new }} | |
| DIFFFILE: ${{ env.OUTPUT_DIR }}/upgrade_check.diff | |
| run: | | |
| scripts/test_pg_upgrade.py | |
| diff -u \ | |
| "${OUTPUT_DIR}/post.pg${PGVERSIONOLD}.log" \ | |
| "${OUTPUT_DIR}/post.pg${PGVERSIONNEW}.log" | \ | |
| tee "${DIFFFILE}" | |
| if [[ -s "${DIFFFILE}" ]]; then | |
| echo "pg_upgrade test for ${PGVERSIONOLD} -> ${PGVERSIONNEW} failed" | |
| exit 1 | |
| fi | |
| - name: Show pg_upgrade diffs | |
| if: always() | |
| env: | |
| DIFFFILE: ${{ env.OUTPUT_DIR }}/upgrade_check.diff | |
| DIROLD: pg${{ matrix.pg_version_old }} | |
| DIRNEW: pg${{ matrix.pg_version_new }} | |
| run: | | |
| cd ${OUTPUT_DIR} | |
| cat ${DIFFFILE} | |
| tar czf /tmp/pg_upgrade_artifacts.tgz \ | |
| ${DIFFFILE} \ | |
| ${OUTPUT_DIR}/*.log \ | |
| ${OUTPUT_DIR}/${DIROLD}/logs/* \ | |
| ${OUTPUT_DIR}/${DIRNEW}/logs/* \ | |
| ${OUTPUT_DIR}/${DIRNEW}/data/pg_upgrade_output.d/* | |
| - name: Upload pg_upgrade logs | |
| if: always() | |
| uses: actions/upload-artifact@043fb46d1a93c77aae656e7c1c64a875d1fc6a0a # v7.0.1 | |
| with: | |
| name: pg_upgrade logs from ${{ matrix.pg_version_old }} to ${{ matrix.pg_version_new }} | |
| path: /tmp/pg_upgrade_artifacts.tgz | |
| report_status: | |
| name: pg_upgrade summary | |
| needs: [check_paths, pg_upgrade_test] | |
| if: always() | |
| runs-on: timescaledb-runner-arm64 | |
| steps: | |
| - run: | | |
| # If the detector failed, or the matrix failed, exit with error | |
| if [[ "${{ needs.pg_upgrade_test.result }}" == "failure" ]]; then | |
| exit 1 | |
| fi | |
| echo "All checks passed or were safely skipped." | |