Skip to content

Add new expected output for unsupported regresison test #373

Add new expected output for unsupported regresison test

Add new expected output for unsupported regresison test #373

Workflow file for this run

name: "InstallChecks"
env:
# Use it just for a report
BRANCH_NAME: ${{ github.head_ref || github.ref_name }}
# Trigger it each timeon push or pull request. Honestly, it will be redundant
# most of the time, but external pull-request checks don't be missed out.
on:
push:
pull_request:
jobs:
build:
runs-on: ubuntu-latest
steps:
- uses: actions/checkout@v3
- name: "Define PostreSQL major version and set basic environment"
run: |
echo "The action workflow is triggered by the $BRANCH_NAME"
sudo apt install libipc-run-perl
git config --global user.email "ci@postgrespro.ru"
git config --global user.name "CI PgPro admin"
patch_name=$(ls aqo_*.patch|tail -1)
echo "CORE_PATCH_NAME=$patch_name" >> $GITHUB_ENV
# we can get number, otherwise set up master
vers_number=$(echo "$patch_name"|tr -d -c 0-9)
echo "PG_MAJOR_VERSION=$vers_number" >> $GITHUB_ENV
branch_name="REL_${vers_number}_STABLE"
echo "PG_BRANCH=$branch_name" >> $GITHUB_ENV
- name: "Set master branch name, if needed"
if: env.PG_MAJOR_VERSION == ''
run: |
branch_name="master"
echo "PG_BRANCH=$branch_name" >> $GITHUB_ENV
# Create workspace directory and environment variable.
# It is the second step because on the first we define versions and branches
- name: "Initial dir"
run: |
git clone -b $PG_BRANCH --depth=1 --single-branch https://github.com/postgres/postgres.git $GITHUB_WORKSPACE/../pg
# Invent variable with full path to PG directory just because github
# actions don't like relative paths ...
cd $GITHUB_WORKSPACE/../pg
echo PG_DIR=`pwd` >> $GITHUB_ENV
- name: "Prepare PG directory"
run: |
cd $PG_DIR
cp -r ../aqo contrib/aqo
patch -p1 --no-backup-if-mismatch < contrib/aqo/$CORE_PATCH_NAME
echo "COPT=-Werror" >> $GITHUB_ENV
echo "CONFIGURE_OPTS=--prefix=`pwd`/tmp_install --enable-tap-tests --enable-cassert" >> $GITHUB_ENV
# Instance-related environment
echo "$PG_DIR/tmp_install/bin" >> $GITHUB_PATH
echo "LD_LIBRARY_PATH=$PG_DIR/tmp_install/lib" >> $GITHUB_ENV
echo `pwd`/contrib/aqo/.github/scripts/job >> $GITHUB_PATH
# Just for debug
- name: "Environment (debug output)"
if: ${{ always() }}
run: |
echo "PG_MAJOR_VERSION: $PG_MAJOR_VERSION"
echo "PG_DIR: $PG_DIR"
echo "PG_BRANCH: $PG_BRANCH"
echo "CORE_PATCH_NAME: $CORE_PATCH_NAME"
# See these paths to understand correctness of the instance initialization
echo "PATHs: $PATH"
echo "PG Libs: $LD_LIBRARY_PATH"
- name: "Compilation"
run: |
cd $PG_DIR
echo "COPT: $COPT"
echo "CONFIGURE_OPTS: $CONFIGURE_OPTS"
./configure $CONFIGURE_OPTS CFLAGS="-O2" > /dev/null
make -j4 > /dev/null && make -j4 -C contrib > /dev/null
make install >> make.log && make -C contrib install > /dev/null
- name: "Launch AQO instance"
run: |
cd $PG_DIR
# Launch an instance with AQO extension
aqo_instance_launch.sh
AQO_VERSION=$(psql -t -c "SELECT extversion FROM pg_extension WHERE extname='aqo'")
echo "AQO_VERSION=$AQO_VERSION" >> $GITHUB_ENV
echo "Use AQO v.$AQO_VERSION"
# Pass installcheck in disabled mode
- name: installcheck_disabled
run: |
cd $PG_DIR
psql -c "ALTER SYSTEM SET aqo.force_collect_stat = 'off'"
psql -c "SELECT pg_reload_conf()"
make installcheck-world
- name: installcheck_disabled_forced_stat
run: |
cd $PG_DIR
psql -c "ALTER SYSTEM SET aqo.force_collect_stat = 'on'"
psql -c "SELECT pg_reload_conf()"
make installcheck-world
- name: installcheck_frozen
run: |
cd $PG_DIR
psql -c "ALTER SYSTEM SET aqo.mode = 'frozen'"
psql -c "ALTER SYSTEM SET aqo.force_collect_stat = 'on'"
psql -c "SELECT pg_reload_conf()"
make installcheck-world
- name: installcheck_controlled
run: |
cd $PG_DIR
psql -c "ALTER SYSTEM SET aqo.mode = 'controlled'"
psql -c "ALTER SYSTEM SET aqo.force_collect_stat = 'on'"
psql -c "SELECT pg_reload_conf()"
make installcheck-world
- name: installcheck_learn
continue-on-error: true
run: |
cd $PG_DIR
psql -c "ALTER SYSTEM SET aqo.mode = 'learn'"
psql -c "ALTER SYSTEM SET aqo.force_collect_stat = 'on'"
psql -c "SELECT pg_reload_conf()"
make -k installcheck-world
# Should work like a total off for all the AQO features
- name: installcheck_learn_queryid_off
continue-on-error: true
run: |
cd $PG_DIR
aqo_instance_launch.sh
psql -c "ALTER SYSTEM SET compute_query_id = 'off'"
psql -c "SELECT pg_reload_conf()"
# The AQO tests itself wouldn't pass
make -k installcheck-world
- name: installcheck_intelligent
continue-on-error: true
run: |
cd $PG_DIR
psql -c "ALTER SYSTEM SET compute_query_id = 'regress'"
psql -c "ALTER SYSTEM SET aqo.mode = 'intelligent'"
psql -c "ALTER SYSTEM SET aqo.force_collect_stat = 'on'"
psql -c "SELECT pg_reload_conf()"
make -k installcheck-world
- name: installcheck_forced
continue-on-error: true
run: |
cd $PG_DIR
psql -c "ALTER SYSTEM SET aqo.mode = 'forced'"
psql -c "ALTER SYSTEM SET aqo.force_collect_stat = 'on'"
psql -c "SELECT pg_reload_conf()"
make -k installcheck-world
# Save Artifacts
- name: Archive artifacts
if: ${{ always() }}
uses: actions/upload-artifact@v3
with:
name: ${{ env.AQO_VERSION }}-${{ env.PG_BRANCH }}-${{ env.CORE_PATCH_NAME }}-artifacts
path: |
${{ env.PG_DIR }}/src/test/regress/regression.diffs
${{ env.PG_DIR }}/logfile.log
${{ env.PG_DIR }}/contrib/aqo/tmp_check/log
retention-days: 2