.travis.yml

sudo: required
language: c
os:
  - linux
services:
  - docker
notifications:
  slack:
    if: (type = cron) AND (branch = master)
    on_success: change
    on_failure: always
    template:
      - "<!here>"
      - "%{repository_slug} (%{build_number}) : %{message}"
      - "Last commit: %{commit_subject} by %{author}"
      - "Build details: %{build_url}"
    rooms:
      - secure: "n4gHRucKsrlYNLVmoTxhsSbH780+8c+OjUCbaSxzyf7QYpbiD5HdCYAwBwJw6VkWPHQ+gXXy75szzcBmCOILEqx+m8WBLet+K9Kw1g3EE0r7lXT+OLWi0JJXvWBv/QdMwefilg7mC8P/USEwUSZfK/iW7tERvQc38ajGonqTsS4QWSg9zAlZZ1ZQJAALd4S4z+BJ/skAQNV+hAI1DLb8jf3A+Ex4/uMs9oAmfGiKqQTwmHlL698XFD83bv0XdxJYskkL8Eqt+19d0HD7lTCvez0yES2PCRXUWsWd2mIwTzGPYyDAU+5MifUvV2CaGDDAhIpzTYoZ4rl2SJc4uu6Fztat4UQB1GGc+TCNo5V8L3IdmzGjI2NSk88QItvpSiiNvtS0mr5As9dO8pIwuWwc4SL0u5bYw7Cq+y2s85huhKrYFVkdEptxjGInHjmq0KsuqpHoFE3E2DPD0fR0KhOekFkzobXg1cPubWHOmzm/PhVaMz3tFAtg83V2f+qg3UtfjMMgI84J/SsUdqv9J1G9R2iGxi56WKSWHHyMeloY8Pz2HFJzV0fPJQM+D5pJFpxQkSXyOMR72qJjeg0IZTiCndX9AEswbGQ3d/dwmYgbfzAah+OP37ZTYyEOsqJTEKvWq8GuJZTuhdJhhvA38Axv9jACcoQtxTKdKskOAUH3TWA="
env:
  global:
    - RETRY_PREFIX=$(if [ "${TRAVIS_PULL_REQUEST}" = "false" ]; then echo "travis_retry"; else echo ""; fi)
    - CODECOV_FLAGS="-F cron"
    - secure: "jy4DQH2syPR2v13igCNPTr044h3H/ilbJk6FifDMxGZVrOZR0dnkBx3O7qJMQOkEQvNxKsoq41k6HCP16qcgt4+HjxhcZonz5hKIiF8IpcB9r+TIlZunNTx7HjSNFZ3WCnham4AvMEthBHgAttRUhscy39ELCNUEobKS/youi7OHLOEXXShc84yTh3aSuGR3SnDVK1diLN5ufX6tN20pc3QvLMGZmA/jmJFcIQHGilhWGwwiJ45LSLwM9slvgGKbTM/K6btVBMOUnjM0h5WqPjRjDUL2tF+iZLEIpY8lFN/MQCnj0vP/BryDdoVPZS3TDQYwYuvASevQ4sOmULnM770jFqzClq4zkeM2GhMq67aYMmXjblu/qcLeCjZL+vfjMKpBMUydK/bCb097HvdRWDEPA0zItKWX9Kd6lVf2XbJCCh0ljp5REJEyk+plJ2V12nLpOPwY6zTtzcoTxEN6wcvUJfHAdNovpp63hWTnbAbEZamIdxwyCqpzThDobeD354TeXFUaKvrUw00iAiIhGL2QvwapaCbhlwM6NQAmdU3tMy3nZpka6bRI1kjyTh7CXfdwXV98ZJSiPdUFxyIgFNI2dKiL3BI1pvFDfq3mnmi3WqzZHCaQqDKNEtUrzxC40swIJGLcLUiqc5xX37P47jNDWrNIRDs8IdbM0tS9pFM="
before_install:
  # We need the PostgreSQL source for running the standard PostgreSQL regression tests
  - docker run -d --name pgbuild --env POSTGRES_HOST_AUTH_METHOD=trust -v ${TRAVIS_BUILD_DIR}:/build postgres:${PG_VERSION}-alpine
install:
  - docker exec -it pgbuild /bin/sh -c "apk add --no-cache --virtual .build-deps coreutils dpkg-dev findutils gcc libc-dev make util-linux-dev diffutils cmake bison flex curl git openssl-dev openssl && mkdir -p /build/debug /build/debug-nossl /postgres"
  - docker exec -it pgbuild /bin/sh -c "apk add --no-cache --virtual --update-cache --repository http://dl-3.alpinelinux.org/alpine/edge/testing/ --allow-untrusted lcov"
  # We need the PostgreSQL source for running the standard PostgreSQL regression tests
  - docker exec -it pgbuild /bin/sh -c "wget -O postgresql.tar.bz2 https://ftp.postgresql.org/pub/source/v\$PG_VERSION/postgresql-\$PG_VERSION.tar.bz2 && tar --extract --file postgresql.tar.bz2 --directory /postgres --strip-components 1"
  # We set /usr/local as prefix so the regression tools will be able to find
  # initdb, psql, and postgres
  - docker exec -it pgbuild /bin/sh -c "cd /postgres && ./configure --prefix=/usr/local --enable-debug --enable-cassert --without-readline --without-zlib --with-openssl"
  # We only need to build the regress and isolation stuff
  - docker exec -it pgbuild /bin/sh -c "make -C /postgres/src/test/regress"
  - docker exec -it pgbuild /bin/sh -c "make -C /postgres/src/test/isolation"
  # Ensure postgres user has permissions
  - docker exec -it pgbuild /bin/bash -c "chown -R postgres:postgres /build/"
  - docker exec -it pgbuild /bin/bash -c "chown -R postgres:postgres /postgres/"
script:
  # First build without OpenSSL
  - docker exec -it pgbuild /bin/sh -c "cd /build/debug-nossl && cmake .. -DUSE_OPENSSL=false -DPG_SOURCE_DIR=/postgres ${OTHER_CMAKE_FLAGS:-} -DCMAKE_BUILD_TYPE=Debug && make install && chown -R postgres:postgres /build/debug-nossl/"
  # Run only telemetry test to see that it works without OpenSSL
  - ${RETRY_PREFIX} docker exec -u postgres -it pgbuild /bin/sh -c "make -C /build/debug-nossl installcheck TESTS=telemetry PG_REGRESS_OPTS='--temp-instance=/tmp/pgdata'"
  # Now build with OpenSSL
  - docker exec -it pgbuild /bin/sh -c "cd /build/debug &&  cmake .. -DCMAKE_BUILD_TYPE=Debug -DUSE_OPENSSL=true -DPG_SOURCE_DIR=/postgres ${OTHER_CMAKE_FLAGS:-} && make install && chown -R postgres:postgres /build/debug/"
  # Now run all tests
  - ${RETRY_PREFIX} docker exec -u postgres -it pgbuild /bin/sh -c "make -k -C /build/debug installcheck IGNORES='${IGNORES}' PG_REGRESS_OPTS='--temp-instance=/tmp/pgdata'"
  # Run the PG regression tests too
  - ${RETRY_PREFIX} docker exec -u postgres -it pgbuild /bin/sh -c "make -C /build/debug pginstallcheck PG_REGRESS_OPTS='--temp-instance=/tmp/pgdata'"
after_failure:
  - docker exec -u postgres -it pgbuild find /build -name regression.diffs -exec cat {} +
  - docker exec -u postgres -it pgbuild find /build -name postmaster.log -exec cat {} +
after_success:
after_script:
  - docker rm -f pgbuild

jobs:
  include:

    # This runs tests on ARM32 emulation
    - if: branch = arm_test
      stage: test
      name: "Regression 11.0 ARM processors"
      env:
        - PG_VERSION=11.0
        - RETRY_PREFIX=""
      before_install:
        - docker run --rm --privileged multiarch/qemu-user-static:register --reset
        - docker run -d --name docker_arm_emulator -v ${TRAVIS_BUILD_DIR}:/timescaledb timescaledev/timescaledb-arm32:pg${PG_VERSION} /bin/sleep infinity
        - docker exec docker_arm_emulator /bin/bash -c "chown -R postgres:postgres /timescaledb"
      install:
        - docker exec docker_arm_emulator /bin/bash -c "mkdir /build && chown postgres:postgres /build"
        - docker exec -u postgres docker_arm_emulator /bin/bash -c "cd /build && CFLAGS='-Werror -O2' cmake /timescaledb -DCMAKE_BUILD_TYPE=Debug && make"
        - docker exec docker_arm_emulator /bin/bash -c "cd /build && make install"
      before_script:
      after_failure:
        - docker exec -u postgres -it docker_arm_emulator find /build -name regression.diffs -exec cat {} +
        - docker exec -u postgres -it docker_arm_emulator find /build -name postmaster.log -exec cat {} +
      script:
      # allow 50 mins to run
        - travis_wait 50 docker exec -u postgres docker_arm_emulator /bin/bash -c "cd /build && make installcheck IGNORES='multi_transaction_indexing bgw_db_scheduler bgw_job_delete continuous_aggs_insert continuous_aggs_bgw plan_ordered_append-11 parallel-11 compression_ddl continuous_aggs_insert continuous_aggs_multi'"
      after_script:
        - docker rm -f docker_arm_emulator

    - if: branch = arm_test
      stage: test
      name: "Regression 12.0 ARM processors"
      env:
        - PG_VERSION=12.0
        - RETRY_PREFIX=""
      before_install:
        - docker run --rm --privileged multiarch/qemu-user-static:register --reset
        - docker run -d --name docker_arm_emulator -v ${TRAVIS_BUILD_DIR}:/timescaledb timescaledev/timescaledb-arm32:pg${PG_VERSION} /bin/sleep infinity
        - docker exec docker_arm_emulator /bin/bash -c "chown -R postgres:postgres /timescaledb"
      install:
        - docker exec docker_arm_emulator /bin/bash -c "mkdir /build && chown postgres:postgres /build"
        - docker exec -u postgres docker_arm_emulator /bin/bash -c "cd /build && CFLAGS='-Werror -O2' cmake /timescaledb -DCMAKE_BUILD_TYPE=Debug && make"
        - docker exec docker_arm_emulator /bin/bash -c "cd /build && make install"
      before_script:
      after_failure:
        - docker exec -u postgres -it docker_arm_emulator find /build -name regression.diffs -exec cat {} +
        - docker exec -u postgres -it docker_arm_emulator find /build -name postmaster.log -exec cat {} +
      script:
      # allow 50 mins to run
        - travis_wait 50 docker exec -u postgres docker_arm_emulator /bin/bash -c "cd /build && make installcheck IGNORES='multi_transaction_indexing bgw_db_scheduler bgw_job_delete continuous_aggs_insert continuous_aggs_bgw plan_ordered_append-12 parallel-12 compression_ddl continuous_aggs_insert continuous_aggs_multi'"
      after_script:
        - docker rm -f docker_arm_emulator

    # cron and prerelease runs regression tests on earliest and latest for each major version either with or without CodeCov
    - if: (type = pull_request) OR (type = cron) OR NOT (branch = master)
      stage: test
      name: "Regression 11.0"
      env:
        - PG_VERSION=11.0
        - IGNORES="compression_ddl continuous_aggs_insert continuous_aggs_multi"

    - if: (type = cron) OR (branch = prerelease_test)
      stage: test
      name: "CodeCov 11.8"
      env:
        - PG_VERSION=11.8
        - OTHER_CMAKE_FLAGS="-DCMAKE_BUILD_TYPE=Debug -DCODECOVERAGE=ON -DCMAKE_C_FLAGS='-DNDEBUG'"
        - CODECOV_FLAGS="-F cron"
      after_success:
        - ci_env=`bash <(curl -s https://codecov.io/env)`
        - docker exec -it $ci_env pgbuild /bin/bash -c "cd /build/debug && bash <(curl -s https://codecov.io/bash) -c ${CODECOV_FLAGS} || echo \"Codecov did not collect coverage reports\" "

    - if: (type = pull_request) OR (type = cron) OR NOT (branch = master)
      stage: test
      name: "Regression 12.0"
      env:
        - PG_VERSION=12.0
        - IGNORES="compression_ddl continuous_aggs_insert continuous_aggs_multi"

    #get codecov info, we only run 12.3 on PRs and the rest in cron
    - if: (type = pull_request) OR (type = cron) OR NOT (branch = master)
      stage: test
      name: "CodeCov 12.3"
      env:
        - PG_VERSION=12.3
        - OTHER_CMAKE_FLAGS="-DCMAKE_BUILD_TYPE=Debug -DCODECOVERAGE=ON -DCMAKE_C_FLAGS='-DNDEBUG'"
        - CODECOV_FLAGS="-F pr"
      after_success:
        - ci_env=`bash <(curl -s https://codecov.io/env)`
        - docker exec -it $ci_env pgbuild /bin/bash -c "cd /build/debug && bash <(curl -s https://codecov.io/bash) -c ${CODECOV_FLAGS} || echo \"Codecov did not collect coverage reports\" "

    # This tests the ability to upgrade to the latest version on pg 11
    - if: (type = pull_request) OR (type = cron) OR (branch = prerelease_test)
      stage: test
      env: PG_VERSION=11.0
      name: "Update tests PostgreSQL 11.0"
      before_install:
      install:
      after_failure:
      after_script:
      after_success:
      script:
        - ${RETRY_PREFIX} bash ./scripts/test_updates_pg11.sh

    # This tests the ability to upgrade to the latest version on pg 12
    - if: (type = pull_request) OR (type = cron) OR (branch = prerelease_test)
      stage: test
      env: PG_VERSION=12.0
      name: "Update tests PostgreSQL 12.0"
      before_install:
      install:
      after_failure:
      after_script:
      after_success:
      script:
        - ${RETRY_PREFIX} bash ./scripts/test_updates_pg12.sh

    - if: (type = cron) OR (branch = prerelease_test)
      stage: test
      name: "ABI breakage smoketest 11.0"
      before_install:
      install:
      after_failure:
      after_script:
      script:
        - PG_MAJOR=11 PG_MINOR_COMPILE=0 bash -x ./scripts/docker-run-abi-test.sh

    - if: (type = cron) OR (branch = prerelease_test)
      stage: test
      name: "ABI breakage smoketest 12.0"
      before_install:
      install:
      after_failure:
      after_script:
      script:
        - PG_MAJOR=12 PG_MINOR_COMPILE=0 bash -x ./scripts/docker-run-abi-test.sh

    # ApacheOnly regression tests
    - if: (type = cron) OR (branch = prerelease_test)
      stage: test
      name: "ApacheOnly regression tests 12.0"
      env: PG_VERSION=12.0 OTHER_CMAKE_FLAGS="-DAPACHE_ONLY=true"

    - if: (type = cron) OR (branch = prerelease_test)
      stage: test
      name: "ApacheOnly regression tests 11.0"
      env: PG_VERSION=11.0 OTHER_CMAKE_FLAGS="-DAPACHE_ONLY=true"

    # Release mode regression tests
    - if: (type = cron) OR (branch = prerelease_test)
      stage: test
      name: "Release regression tests 12.3"
      env: PG_VERSION=12.3 OTHER_CMAKE_FLAGS="-DCMAKE_BUILD_TYPE='Release'"

    - if: (type = cron) OR (branch = prerelease_test)
      stage: test
      name: "Release regression tests 11.8"
      env: PG_VERSION=11.8 OTHER_CMAKE_FLAGS="-DCMAKE_BUILD_TYPE='Release'"

    # Memory spike test when running out of order random inserts into timescaledb database
    - if: (type = cron) OR (branch = prerelease_test)
      stage: test
      name: "Memory leak on insert tests"
      before_install:
      install:
      after_failure:
      after_success:
      after_script:
      env:
        - PG_VERSION=12.3
      before_script:
      script:
        - bash ./scripts/docker-run-memory-test.sh

    # Sanitizer tests
    - if: (type = cron) OR (branch = prerelease_test)
      stage: test
      name: "ASAN and UBSAN tests"
      before_install:
      install:
      after_failure:
      before_script:
      script:
        # TEST_MAX specifies the maximum test # to go up to
        - TIMESCALE_DIR=$TRAVIS_BUILD_DIR bash ./scripts/test_sanitizers.sh
      after_script:
        - kill $(jobs -p) # kill job that prints repeatedly

    # Coverity tests

    - if: (branch = coverity_scan) OR (branch = coverity_scan_11)
      stage: coverity
      name: "Coverity PG 11"
      env:
      before_install:
        - sudo apt-get install -y postgresql-11 postgresql-client-11 postgresql-contrib-11 postgresql-server-dev-11 cmake
      install:
      after_success:
      after_script:
      script: echo "Success"
      addons:
        postgresql: "11"
        coverity_scan:
          project:
            name: "timescale/timescaledb"
            description: "TimescaledDB an open-source time-series DB"
          notification_email: ci@timescale.com
          build_command_prepend: "./bootstrap -DCMAKE_BUILD_TYPE=Debug -DREGRESS_CHECKS=OFF && cd build"
          build_command: "make"
          branch_pattern: coverity_scan|coverity_scan_11

    - if: (branch = coverity_scan) OR (branch = coverity_scan_12)
      stage: coverity
      name: "Coverity PG 12"
      env:
      before_install:
        - sudo apt-get install -y postgresql-12 postgresql-client-12 postgresql-contrib-12 postgresql-server-dev-12 cmake
      install:
      after_success:
      after_script:
      script: echo "Success"
      addons:
        postgresql: "12"
        coverity_scan:
          project:
            name: "timescale/timescaledb"
            description: "TimescaledDB an open-source time-series DB"
          notification_email: ci@timescale.com
          build_command_prepend: "./bootstrap -DCMAKE_BUILD_TYPE=Debug -DREGRESS_CHECKS=OFF && cd build"
          build_command: "make"
          branch_pattern: coverity_scan|coverity_scan_12