InstallChecks #348
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: "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 "[email protected]" | |
| 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 | |