Merge pull request #130 from jnidzwetzki/dependabot/pip/isort-5.13.2 #256
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: Basic Integration Tests | |
on: | |
pull_request: | |
push: | |
branches: | |
- main | |
jobs: | |
config: | |
strategy: | |
fail-fast: false | |
matrix: | |
psql_version: ['12.13', '13.9', '14.4', '15.1'] | |
python_version: ['3.6', '3.8', '3.9', '3.10'] | |
# Python 3.6 is not available on ubuntu-22.04 | |
# see: https://raw.githubusercontent.com/actions/python-versions/main/versions-manifest.json | |
name: PostgreSQL ${{ matrix.psql_version }} and Python ${{ matrix.python_version }} integration test | |
runs-on: ubuntu-20.04 | |
steps: | |
- name: Checkout source code | |
uses: actions/checkout@v3 | |
- uses: actions/setup-python@v4 | |
with: | |
python-version: ${{ matrix.python_version }} | |
- name: Show Python version | |
run: python --version | |
- name: Install needed tools | |
run: | | |
sudo apt install python3-bpfcc systemtap-sdt-dev flex bison lcov build-essential libxml2-dev libssl-dev zlib1g-dev libreadline-dev | |
- name: Cache PostgreSQL build ${{ matrix.psql_version }} | |
id: postgresql-cache | |
uses: actions/cache@v3 | |
with: | |
path: ~/postgresql | |
key: postgresql-${{ matrix.psql_version }}-${{ hashFiles('.github/workflows/*') }} | |
- name: Build PostgreSQL | |
if: steps.postgresql-cache.outputs.cache-hit != 'true' | |
run: | | |
mkdir -p ~/postgresql | |
mkdir -p ~/postgresql/src/${{ matrix.psql_version }} | |
mkdir -p ~/postgresql/bin/${{ matrix.psql_version }} | |
# Data dir is not part of the cache | |
mkdir -p ~/postgresql_data/${{ matrix.psql_version }} | |
cd ~/postgresql/src/${{ matrix.psql_version }} | |
wget -q -O postgresql.tar.bz2 https://ftp.postgresql.org/pub/source/v${{ matrix.psql_version }}/postgresql-${{ matrix.psql_version }}.tar.bz2 | |
tar jxf postgresql.tar.bz2 --strip-components 1 -C . | |
CFLAGS="-ggdb -Og -g3 -fno-omit-frame-pointer" ./configure --prefix=$HOME/postgresql/bin/${{ matrix.psql_version }} --with-openssl --with-readline --with-zlib --with-libxml --enable-dtrace | |
make -j 8 | |
- name: Install PostgreSQL | |
run: | | |
cd ~/postgresql/src/${{ matrix.psql_version }} | |
make install | |
~/postgresql/bin/${{ matrix.psql_version }}/bin/initdb -D ~/postgresql_data/${{ matrix.psql_version }} | |
~/postgresql/bin/${{ matrix.psql_version }}/bin/pg_ctl -D ~/postgresql_data/${{ matrix.psql_version }} start | |
#sudo apt install curl ca-certificates gnupg | |
#sudo curl https://www.postgresql.org/media/keys/ACCC4CF8.asc | gpg --dearmor | sudo tee /etc/apt/trusted.gpg.d/apt.postgresql.org.gpg >/dev/null | |
#sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/pgdg.list' | |
#sudo apt update | |
#sudo apt install postgresql-${{ matrix.psql_version }} postgresql-${{ matrix.psql_version }}-dbgsym | |
#sudo /etc/init.d/postgresql start ${{ matrix.psql_version }} | |
#dpkg -L postgresql-${{ matrix.psql_version }}-dbgsym | |
#readelf --string-dump=.gnu_debuglink /usr/lib/postgresql/${{ matrix.psql_version }}/bin/postgres | |
#objdump -TC /usr/lib/postgresql/${{ matrix.psql_version }}/bin/postgres | |
- name: Install package | |
run: sudo python -m pip install . | |
- name: Check that pg_lock_tracer can be executed | |
run: | | |
pg_lock_tracer --version | |
sudo pg_lock_tracer -x ~/postgresql/bin/${{ matrix.psql_version }}/bin/postgres -v -p $(pidof postgres) --statistics --dry-run | |
- name: Check that pg_lw_lock_tracer can be executed | |
run: | | |
pg_lw_lock_tracer --version | |
sudo pg_lw_lock_tracer -p $(pidof postgres) --dry-run | |
- name: Check that animate_lock_graph can be executed | |
run: | | |
animate_lock_graph --version | |
animate_lock_graph -o animation.html -i examples/create_table_trace.json | |
diff animation.html -i examples/create_table_trace.html |