[Feature] Dynamic Table. #57
Workflow file for this run
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
| # -------------------------------------------------------------------- | |
| # | |
| # Licensed to the Apache Software Foundation (ASF) under one or more | |
| # contributor license agreements. See the NOTICE file distributed | |
| # with this work for additional information regarding copyright | |
| # ownership. The ASF licenses this file to You under the Apache | |
| # License, Version 2.0 (the "License"); you may not use this file | |
| # except in compliance with the License. You may obtain a copy of the | |
| # License at | |
| # | |
| # http://www.apache.org/licenses/LICENSE-2.0 | |
| # | |
| # Unless required by applicable law or agreed to in writing, software | |
| # distributed under the License is distributed on an "AS IS" BASIS, | |
| # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or | |
| # implied. See the License for the specific language governing | |
| # permissions and limitations under the License. | |
| # | |
| # -------------------------------------------------------------------- | |
| # | |
| # GitHub Actions Workflow: Apache Cloudberry Build | |
| # Description: Builds, tests, and packages Apache Cloudberry on Rocky Linux 9 | |
| # | |
| # Workflow Structure: | |
| # 1. Skip Check: | |
| # - Evaluates CI skip flags in commit messages or PR titles | |
| # - Supports [skip ci], [ci skip], [no ci] | |
| # - Successfully completes all checks if skip detected | |
| # | |
| # 2. Build Job: | |
| # - Sets up build environment in Rocky Linux 9 container | |
| # - Configures and builds Cloudberry | |
| # - Runs unit tests | |
| # - Creates RPM package and source tarball | |
| # - Performs build verification | |
| # - Uploads build artifacts | |
| # Key artifacts: RPM package, source tarball, build logs | |
| # | |
| # 3. Install Test Job: | |
| # - Sets up test environment in Rocky Linux 9 container | |
| # - Downloads build artifacts | |
| # - Verifies RPM package integrity | |
| # - Installs Cloudberry RPM | |
| # - Validates installation | |
| # Key artifacts: Installation logs, verification results | |
| # | |
| # 4. Test Job: | |
| # - Sets up test environment in Rocky Linux 9 container | |
| # - Downloads build artifacts | |
| # - Installs Cloudberry RPM | |
| # - Creates demo cluster | |
| # - Executes installcheck tests | |
| # - Parses and reports test results | |
| # Key artifacts: Test logs, regression files, test summaries | |
| # | |
| # 5. Report Job: | |
| # - Generates comprehensive build pipeline report | |
| # - Aggregates status from all jobs | |
| # - Provides failure notifications if needed | |
| # | |
| # Resource Requirements: | |
| # - Disk: Minimum 20GB free space | |
| # - Memory: Minimum 8GB RAM | |
| # - CPU: Recommended 4+ cores | |
| # | |
| # Container Images: | |
| # Build: apache/incubator-cloudberry:cbdb-build-rocky9-latest | |
| # - Rocky Linux 9 base with build dependencies | |
| # Test: apache/incubator-cloudberry:cbdb-test-rocky9-latest | |
| # - Rocky Linux 9 base with test dependencies | |
| # | |
| # Triggers: | |
| # - Push to build-devel branch | |
| # - Pull requests to build-devel branch | |
| # - Manual workflow dispatch | |
| # | |
| # Skip CI: | |
| # Add one of these flags to commit message or PR title: | |
| # - [skip ci] : Skip all CI checks | |
| # - [ci skip] : Skip all CI checks (alternative) | |
| # - [no ci] : Skip all CI checks (alternative) | |
| # | |
| # Environment Variables: | |
| # LOG_RETENTION_DAYS: Number of days to retain logs (default: 7) | |
| # BUILD_TIMESTAMP: Build start timestamp | |
| # SRC_DIR: Source directory path | |
| # CBDB_VERSION: Cloudberry version (99.0.0) | |
| # BUILD_NUMBER: Build number (1) | |
| # GITHUB_OUTPUT: GitHub Actions output file path | |
| # | |
| # Test Matrix: | |
| # - ICW Optimizer=off: Basic regression tests with optimizer disabled | |
| # - ICW expandshrink: Cluster expansion/shrinking tests | |
| # # Disabled tests: | |
| # # - ICW Optimizer=on: Advanced tests with optimizer | |
| # # - ICW Parallel: Parallel execution tests | |
| # | |
| # Artifacts Generated: | |
| # - RPM package (1 day retention) | |
| # - Source tarball (1 day retention) | |
| # - Build and test logs (7 days retention) | |
| # - Test results (7 days retention) | |
| # - Job execution reports (7 days retention) | |
| # | |
| # Dependencies: | |
| # - Cloudberry build scripts repository | |
| # - GitHub Actions artifacts for job communication | |
| # | |
| # Notes: | |
| # - Requires Docker Hub authentication | |
| # - Uses concurrent job control | |
| # - Provides detailed job summaries | |
| # - Includes comprehensive error handling | |
| # - Maintains build artifacts for downstream use | |
| # | |
| # -------------------------------------------------------------------- | |
| name: Apache Cloudberry Build | |
| on: | |
| push: | |
| branches: [main] | |
| pull_request: | |
| branches: [main] | |
| types: [opened, synchronize, reopened] | |
| workflow_dispatch: | |
| concurrency: | |
| group: ${{ github.workflow }}-${{ github.ref }} | |
| cancel-in-progress: false | |
| permissions: | |
| contents: read | |
| packages: read | |
| actions: write | |
| env: | |
| LOG_RETENTION_DAYS: 7 | |
| jobs: | |
| # Initial job to check for skip flags | |
| check-skip: | |
| runs-on: ubuntu-latest | |
| outputs: | |
| should_skip: ${{ steps.skip-check.outputs.should_skip }} | |
| steps: | |
| - id: skip-check | |
| shell: bash | |
| run: | | |
| # Get the message to check based on event type | |
| MESSAGE="" | |
| if [[ "${{ github.event_name }}" == "pull_request" ]]; then | |
| MESSAGE="${{ github.event.pull_request.title }}" | |
| else | |
| MESSAGE="${{ github.event.head_commit.message }}" | |
| fi | |
| # Check for skip patterns | |
| if echo "$MESSAGE" | grep -qE '\[skip[ -]ci\]|\[ci[ -]skip\]|\[no[ -]ci\]'; then | |
| echo "should_skip=true" >> $GITHUB_OUTPUT | |
| else | |
| echo "should_skip=false" >> $GITHUB_OUTPUT | |
| fi | |
| - name: Report Skip Status | |
| if: steps.skip-check.outputs.should_skip == 'true' | |
| run: | | |
| echo "CI Skip flag detected - skipping all checks" | |
| exit 0 | |
| build: | |
| name: Build Apache Cloudberry | |
| needs: check-skip | |
| runs-on: ubuntu-latest | |
| timeout-minutes: 120 | |
| outputs: | |
| build_timestamp: ${{ steps.set_timestamp.outputs.timestamp }} | |
| container: | |
| image: apache/incubator-cloudberry:cbdb-build-rocky9-latest | |
| options: >- | |
| --user root | |
| -h cdw | |
| steps: | |
| - name: Skip Check | |
| if: needs.check-skip.outputs.should_skip == 'true' | |
| run: | | |
| echo "Build skipped via CI skip flag" >> $GITHUB_STEP_SUMMARY | |
| exit 0 | |
| - name: Set build timestamp | |
| if: needs.check-skip.outputs.should_skip != 'true' | |
| id: set_timestamp # Add an ID to reference this step | |
| run: | | |
| timestamp=$(date +'%Y%m%d_%H%M%S') | |
| echo "timestamp=$timestamp" | tee -a $GITHUB_OUTPUT # Use GITHUB_OUTPUT for job outputs | |
| echo "BUILD_TIMESTAMP=$timestamp" | tee -a $GITHUB_ENV # Also set as environment variable | |
| - name: Checkout Apache Cloudberry (apache/cloudberry) | |
| if: needs.check-skip.outputs.should_skip != 'true' | |
| uses: actions/checkout@v4 | |
| with: | |
| fetch-depth: 1 | |
| - name: Checkout CI Build/Test Scripts (apache/cloudberry-devops-release) | |
| if: needs.check-skip.outputs.should_skip != 'true' | |
| uses: actions/checkout@v4 | |
| with: | |
| repository: apache/cloudberry-devops-release | |
| path: cloudberry-devops-release | |
| ref: main | |
| - name: Move cloudberry-devops-release directory | |
| if: needs.check-skip.outputs.should_skip != 'true' | |
| run: | | |
| set -eo pipefail | |
| if ! mv ${GITHUB_WORKSPACE}/cloudberry-devops-release ${GITHUB_WORKSPACE}/..; then | |
| echo "::error::Container initialization failed" | |
| exit 1 | |
| fi | |
| - name: Setup Apache Cloudberry build environment | |
| if: needs.check-skip.outputs.should_skip != 'true' | |
| run: | | |
| set -eo pipefail | |
| if ! su - gpadmin -c "/tmp/init_system.sh"; then | |
| echo "::error::Container initialization failed" | |
| exit 1 | |
| fi | |
| mkdir -p build-logs/details | |
| chown -R gpadmin:gpadmin . | |
| chmod -R 755 . | |
| chmod 777 build-logs | |
| df -kh / | |
| rm -rf /__t/* | |
| df -kh / | |
| df -h | tee -a build-logs/details/disk-usage.log | |
| free -h | tee -a build-logs/details/memory-usage.log | |
| { | |
| echo "=== Environment Information ===" | |
| uname -a | |
| gcc --version | |
| df -h | |
| free -h | |
| env | |
| } | tee -a build-logs/details/environment.log | |
| echo "SRC_DIR=${GITHUB_WORKSPACE}" | tee -a $GITHUB_ENV | |
| - name: Generate Build Job Summary Start | |
| if: needs.check-skip.outputs.should_skip != 'true' | |
| run: | | |
| { | |
| echo "# Build Job Summary" >> $GITHUB_STEP_SUMMARY | |
| echo "## Environment" >> $GITHUB_STEP_SUMMARY | |
| echo "- Start Time: $(date -u +'%Y-%m-%d %H:%M:%S UTC')" >> $GITHUB_STEP_SUMMARY | |
| echo "- OS Version: $(cat /etc/redhat-release)" >> $GITHUB_STEP_SUMMARY | |
| echo "- GCC Version: $(gcc --version | head -n1)" >> $GITHUB_STEP_SUMMARY | |
| } | |
| - name: Run Apache Cloudberry configure script | |
| if: needs.check-skip.outputs.should_skip != 'true' | |
| env: | |
| SRC_DIR: ${{ github.workspace }} | |
| run: | | |
| set -eo pipefail | |
| chmod +x ${SRC_DIR}/../cloudberry-devops-release/build_automation/cloudberry/scripts/configure-cloudberry.sh | |
| if ! time su - gpadmin -c "cd ${SRC_DIR} && SRC_DIR=${SRC_DIR} ${SRC_DIR}/../cloudberry-devops-release/build_automation/cloudberry/scripts/configure-cloudberry.sh"; then | |
| echo "::error::Configure script failed" | |
| exit 1 | |
| fi | |
| - name: Run Apache Cloudberry build script | |
| if: needs.check-skip.outputs.should_skip != 'true' | |
| env: | |
| SRC_DIR: ${{ github.workspace }} | |
| run: | | |
| set -eo pipefail | |
| chmod +x ${SRC_DIR}/../cloudberry-devops-release/build_automation/cloudberry/scripts/build-cloudberry.sh | |
| if ! time su - gpadmin -c "cd ${SRC_DIR} && SRC_DIR=${SRC_DIR} ${SRC_DIR}/../cloudberry-devops-release/build_automation/cloudberry/scripts/build-cloudberry.sh"; then | |
| echo "::error::Build script failed" | |
| exit 1 | |
| fi | |
| - name: Verify build artifacts | |
| if: needs.check-skip.outputs.should_skip != 'true' | |
| run: | | |
| set -eo pipefail | |
| echo "Verifying build artifacts..." | |
| { | |
| echo "=== Build Artifacts Verification ===" | |
| echo "Timestamp: $(date -u)" | |
| if [ ! -d "/usr/local/cloudberry-db" ]; then | |
| echo "::error::Build artifacts directory not found" | |
| exit 1 | |
| fi | |
| # Verify critical binaries | |
| critical_binaries=( | |
| "/usr/local/cloudberry-db/bin/postgres" | |
| "/usr/local/cloudberry-db/bin/psql" | |
| ) | |
| echo "Checking critical binaries..." | |
| for binary in "${critical_binaries[@]}"; do | |
| if [ ! -f "$binary" ]; then | |
| echo "::error::Critical binary missing: $binary" | |
| exit 1 | |
| fi | |
| if [ ! -x "$binary" ]; then | |
| echo "::error::Binary not executable: $binary" | |
| exit 1 | |
| fi | |
| echo "Binary verified: $binary" | |
| ls -l "$binary" | |
| done | |
| # Test binary execution | |
| echo "Testing binary execution..." | |
| if ! /usr/local/cloudberry-db/bin/postgres --version; then | |
| echo "::error::postgres binary verification failed" | |
| exit 1 | |
| fi | |
| if ! /usr/local/cloudberry-db/bin/psql --version; then | |
| echo "::error::psql binary verification failed" | |
| exit 1 | |
| fi | |
| echo "All build artifacts verified successfully" | |
| } 2>&1 | tee -a build-logs/details/build-verification.log | |
| - name: Create Source tarball, create RPM and verify artifacts | |
| if: needs.check-skip.outputs.should_skip != 'true' | |
| id: create-artifacts | |
| env: | |
| CBDB_VERSION: 99.0.0 | |
| BUILD_NUMBER: 1 | |
| SRC_DIR: ${{ github.workspace }} | |
| run: | | |
| set -eo pipefail | |
| { | |
| echo "=== Artifact Creation Log ===" | |
| echo "Timestamp: $(date -u)" | |
| # Create source tarball | |
| echo "Creating source tarball..." | |
| tar czf ${SRC_DIR}/../apache-cloudberry-incubating-src.tgz -C ${SRC_DIR}/.. ./cloudberry | |
| mv ${SRC_DIR}/../apache-cloudberry-incubating-src.tgz ${SRC_DIR} | |
| # Verify tarball contents | |
| echo "Verifying source tarball contents..." | |
| if ! tar tzf ${SRC_DIR}/apache-cloudberry-incubating-src.tgz > /dev/null; then | |
| echo "::error::Source tarball verification failed" | |
| exit 1 | |
| fi | |
| # Create RPM | |
| echo "Creating RPM package..." | |
| rpmdev-setuptree | |
| ln -s ${SRC_DIR}/../cloudberry-devops-release/packaging/rpm/el/SPECS/apache-cloudberry-db-incubating.spec ${HOME}/rpmbuild/SPECS/apache-cloudberry-db-incubating.spec | |
| cp ${SRC_DIR}/LICENSE /usr/local/cloudberry-db | |
| ${SRC_DIR}/../cloudberry-devops-release/scripts/build-rpm.sh --version ${CBDB_VERSION} --release ${BUILD_NUMBER} | |
| # Get OS version and move RPM | |
| os_version=$(grep -oP '(?<=^VERSION_ID=")[0-9]' /etc/os-release) | |
| RPM_FILE=${HOME}/rpmbuild/RPMS/x86_64/apache-cloudberry-db-incubating-${CBDB_VERSION}-${BUILD_NUMBER}.el${os_version}.x86_64.rpm | |
| cp ${RPM_FILE} ${SRC_DIR} | |
| # Get package information | |
| echo "Package Information:" | |
| rpm -qip ${RPM_FILE} | |
| # Verify critical files in RPM | |
| echo "Verifying critical files in RPM..." | |
| for binary in "bin/postgres" "bin/psql"; do | |
| if ! rpm -qlp ${RPM_FILE} | grep -q "${binary}$"; then | |
| echo "::error::Critical binary '${binary}' not found in RPM" | |
| exit 1 | |
| fi | |
| done | |
| # Record checksums | |
| echo "Calculating checksums..." | |
| sha256sum ${RPM_FILE} | tee -a build-logs/details/checksums.log | |
| sha256sum ${SRC_DIR}/apache-cloudberry-incubating-src.tgz | tee -a build-logs/details/checksums.log | |
| echo "Artifacts created and verified successfully" | |
| } 2>&1 | tee -a build-logs/details/artifact-creation.log | |
| # Set outputs for subsequent steps | |
| echo "rpm_file=${RPM_FILE}" >> $GITHUB_OUTPUT | |
| echo "version=${CBDB_VERSION}" >> $GITHUB_OUTPUT | |
| echo "build_number=${BUILD_NUMBER}" >> $GITHUB_OUTPUT | |
| - name: Run Apache Cloudberry unittest script | |
| if: needs.check-skip.outputs.should_skip != 'true' | |
| env: | |
| SRC_DIR: ${{ github.workspace }} | |
| run: | | |
| set -eo pipefail | |
| chmod +x ${SRC_DIR}/../cloudberry-devops-release/build_automation/cloudberry/scripts/unittest-cloudberry.sh | |
| if ! time su - gpadmin -c "cd ${SRC_DIR} && SRC_DIR=${SRC_DIR} ${SRC_DIR}/../cloudberry-devops-release/build_automation/cloudberry/scripts/unittest-cloudberry.sh"; then | |
| echo "::error::Unittest script failed" | |
| exit 1 | |
| fi | |
| - name: Generate Build Job Summary End | |
| if: always() | |
| run: | | |
| { | |
| echo "## Build Results" >> $GITHUB_STEP_SUMMARY | |
| echo "- End Time: $(date -u +'%Y-%m-%d %H:%M:%S UTC')" >> $GITHUB_STEP_SUMMARY | |
| } | |
| - name: Upload build logs | |
| if: needs.check-skip.outputs.should_skip != 'true' | |
| uses: actions/upload-artifact@v4 | |
| with: | |
| name: build-logs-${{ env.BUILD_TIMESTAMP }} | |
| path: | | |
| build-logs/ | |
| retention-days: ${{ env.LOG_RETENTION_DAYS }} | |
| - name: Upload Cloudberry RPM build artifacts | |
| if: needs.check-skip.outputs.should_skip != 'true' | |
| uses: actions/upload-artifact@v4 | |
| with: | |
| name: apache-cloudberry-db-incubating-rpm-build-artifacts | |
| retention-days: ${{ env.LOG_RETENTION_DAYS }} | |
| if-no-files-found: error | |
| path: | | |
| *.rpm | |
| - name: Upload Cloudberry source build artifacts | |
| if: needs.check-skip.outputs.should_skip != 'true' | |
| uses: actions/upload-artifact@v4 | |
| with: | |
| name: apache-cloudberry-db-incubating-source-build-artifacts | |
| retention-days: ${{ env.LOG_RETENTION_DAYS }} | |
| if-no-files-found: error | |
| path: | | |
| apache-cloudberry-incubating-src.tgz | |
| rpm-install-test: | |
| name: RPM Install Test Apache Cloudberry | |
| needs: [check-skip, build] | |
| runs-on: ubuntu-latest | |
| timeout-minutes: 120 | |
| container: | |
| image: apache/incubator-cloudberry:cbdb-test-rocky9-latest | |
| options: >- | |
| --user root | |
| -h cdw | |
| steps: | |
| - name: Skip Check | |
| if: needs.check-skip.outputs.should_skip == 'true' | |
| run: | | |
| echo "RPM install test skipped via CI skip flag" >> $GITHUB_STEP_SUMMARY | |
| exit 0 | |
| - name: Download Cloudberry RPM build artifacts | |
| if: needs.check-skip.outputs.should_skip != 'true' | |
| uses: actions/download-artifact@v4 | |
| with: | |
| name: apache-cloudberry-db-incubating-rpm-build-artifacts | |
| path: ${{ github.workspace }}/rpm_build_artifacts | |
| merge-multiple: false | |
| - name: Setup Apache Cloudberry build environment | |
| if: needs.check-skip.outputs.should_skip != 'true' | |
| run: | | |
| set -eo pipefail | |
| if ! su - gpadmin -c "/tmp/init_system.sh"; then | |
| echo "::error::Container initialization failed" | |
| exit 1 | |
| fi | |
| mkdir -p install-logs/details | |
| chown -R gpadmin:gpadmin . | |
| chmod -R 755 . | |
| chmod 777 install-logs | |
| df -kh / | |
| rm -rf /__t/* | |
| df -kh / | |
| df -h | tee -a install-logs/details/disk-usage.log | |
| free -h | tee -a install-logs/details/memory-usage.log | |
| { | |
| echo "=== Environment Information ===" | |
| uname -a | |
| df -h | |
| free -h | |
| env | |
| } | tee -a install-logs/details/environment.log | |
| echo "SRC_DIR=${GITHUB_WORKSPACE}" | tee -a $GITHUB_ENV | |
| - name: Verify RPM artifacts | |
| if: needs.check-skip.outputs.should_skip != 'true' | |
| id: verify-artifacts | |
| run: | | |
| set -eo pipefail | |
| RPM_FILE=$(ls ${GITHUB_WORKSPACE}/rpm_build_artifacts/apache-cloudberry-db-incubating*.rpm) | |
| if [ ! -f "${RPM_FILE}" ]; then | |
| echo "::error::RPM file not found" | |
| exit 1 | |
| fi | |
| echo "rpm_file=${RPM_FILE}" >> $GITHUB_OUTPUT | |
| echo "Verifying RPM artifacts..." | |
| { | |
| echo "=== RPM Verification Summary ===" | |
| echo "Timestamp: $(date -u)" | |
| echo "RPM File: ${RPM_FILE}" | |
| # Get RPM metadata and verify contents | |
| echo "Package Information:" | |
| rpm -qip ${RPM_FILE} | |
| # Get key RPM attributes for verification | |
| RPM_VERSION=$(rpm -qp --queryformat "%{VERSION}" ${RPM_FILE}) | |
| RPM_RELEASE=$(rpm -qp --queryformat "%{RELEASE}" ${RPM_FILE}) | |
| echo "version=${RPM_VERSION}" >> $GITHUB_OUTPUT | |
| echo "release=${RPM_RELEASE}" >> $GITHUB_OUTPUT | |
| # Verify expected binaries are in the RPM | |
| echo "Verifying critical files in RPM..." | |
| for binary in "bin/postgres" "bin/psql"; do | |
| if ! rpm -qlp ${RPM_FILE} | grep -q "${binary}$"; then | |
| echo "::error::Critical binary '${binary}' not found in RPM" | |
| exit 1 | |
| fi | |
| done | |
| echo "RPM Details:" | |
| echo "- Version: ${RPM_VERSION}" | |
| echo "- Release: ${RPM_RELEASE}" | |
| # Calculate and store checksum | |
| echo "Checksum:" | |
| sha256sum ${RPM_FILE} | |
| } 2>&1 | tee -a install-logs/details/rpm-verification.log | |
| - name: Install Cloudberry RPM | |
| if: success() && needs.check-skip.outputs.should_skip != 'true' | |
| env: | |
| RPM_FILE: ${{ steps.verify-artifacts.outputs.rpm_file }} | |
| RPM_VERSION: ${{ steps.verify-artifacts.outputs.version }} | |
| RPM_RELEASE: ${{ steps.verify-artifacts.outputs.release }} | |
| run: | | |
| set -eo pipefail | |
| if [ -z "${RPM_FILE}" ]; then | |
| echo "::error::RPM_FILE environment variable is not set" | |
| exit 1 | |
| fi | |
| { | |
| echo "=== RPM Installation Log ===" | |
| echo "Timestamp: $(date -u)" | |
| echo "RPM File: ${RPM_FILE}" | |
| echo "Version: ${RPM_VERSION}" | |
| echo "Release: ${RPM_RELEASE}" | |
| # Clean install location | |
| rm -rf /usr/local/cloudberry-db | |
| # Install RPM | |
| echo "Starting installation..." | |
| if ! time dnf install -y "${RPM_FILE}"; then | |
| echo "::error::RPM installation failed" | |
| exit 1 | |
| fi | |
| echo "Installation completed successfully" | |
| rpm -qi apache-cloudberry-db-incubating | |
| echo "Installed files:" | |
| rpm -ql apache-cloudberry-db-incubating | |
| } 2>&1 | tee -a install-logs/details/rpm-installation.log | |
| - name: Upload install logs | |
| if: needs.check-skip.outputs.should_skip != 'true' | |
| uses: actions/upload-artifact@v4 | |
| with: | |
| name: install-logs-${{ needs.build.outputs.build_timestamp }} | |
| path: | | |
| install-logs/ | |
| retention-days: ${{ env.LOG_RETENTION_DAYS }} | |
| - name: Generate Install Test Job Summary End | |
| if: always() | |
| shell: bash {0} | |
| run: | | |
| { | |
| echo "# Installed Package Summary" | |
| echo "\`\`\`" | |
| rpm -qi apache-cloudberry-db-incubating | |
| echo "\`\`\`" | |
| } >> $GITHUB_STEP_SUMMARY || true | |
| test: | |
| name: ${{ matrix.test }} | |
| needs: [check-skip, build] | |
| runs-on: ubuntu-latest | |
| timeout-minutes: 120 | |
| strategy: | |
| fail-fast: false # Continue with other tests if one fails | |
| matrix: | |
| test: [ic-good-opt-off, ic-expandshrink] | |
| include: | |
| - test: ic-good-opt-off | |
| make_target: installcheck-good | |
| make_directory: --directory=src/test/regress | |
| pg_settings: | |
| optimizer: "off" | |
| - test: ic-expandshrink | |
| make_target: installcheck-expandshrink | |
| make_directory: --directory=src/test/isolation2 | |
| pg_settings: | |
| optimizer: "off" | |
| container: | |
| image: apache/incubator-cloudberry:cbdb-build-rocky9-latest | |
| options: >- | |
| --user root | |
| -h cdw | |
| steps: | |
| - name: Skip Check | |
| if: needs.check-skip.outputs.should_skip == 'true' | |
| run: | | |
| echo "Test ${{ matrix.test }} skipped via CI skip flag" >> $GITHUB_STEP_SUMMARY | |
| exit 0 | |
| - name: Use timestamp from previous job | |
| if: needs.check-skip.outputs.should_skip != 'true' | |
| run: | | |
| echo "Timestamp from output: ${{ needs.build.outputs.build_timestamp }}" | |
| - name: Checkout CI Build/Test Scripts (apache/cloudberry-devops-release) | |
| if: needs.check-skip.outputs.should_skip != 'true' | |
| uses: actions/checkout@v4 | |
| with: | |
| repository: apache/cloudberry-devops-release | |
| path: cloudberry-devops-release | |
| ref: main | |
| - name: Move cloudberry-devops-release directory | |
| if: needs.check-skip.outputs.should_skip != 'true' | |
| run: | | |
| set -eo pipefail | |
| if ! mv ${GITHUB_WORKSPACE}/cloudberry-devops-release ${GITHUB_WORKSPACE}/..; then | |
| echo "::error::Container initialization failed" | |
| exit 1 | |
| fi | |
| - name: Setup Apache Cloudberry build environment | |
| run: | | |
| set -eo pipefail | |
| if ! su - gpadmin -c "/tmp/init_system.sh"; then | |
| echo "::error::Container initialization failed" | |
| exit 1 | |
| fi | |
| mkdir -p build-logs/details | |
| chown -R gpadmin:gpadmin . | |
| chmod -R 755 . | |
| chmod 777 build-logs | |
| df -kh / | |
| rm -rf /__t/* | |
| df -kh / | |
| df -h | tee -a build-logs/details/disk-usage.log | |
| free -h | tee -a build-logs/details/memory-usage.log | |
| { | |
| echo "=== Environment Information ===" | |
| uname -a | |
| df -h | |
| free -h | |
| env | |
| } | tee -a build-logs/details/environment.log | |
| echo "SRC_DIR=${GITHUB_WORKSPACE}" | tee -a $GITHUB_ENV | |
| - name: "Generate Test Job Summary Start: ${{ matrix.test }}" | |
| if: always() | |
| run: | | |
| { | |
| echo "# Test Job Summary: ${{ matrix.test }}" >> $GITHUB_STEP_SUMMARY | |
| echo "## Environment" >> $GITHUB_STEP_SUMMARY | |
| echo "- Start Time: $(date -u +'%Y-%m-%d %H:%M:%S UTC')" >> $GITHUB_STEP_SUMMARY | |
| if [[ "${{ needs.check-skip.outputs.should_skip }}" == "true" ]]; then | |
| echo "## Skip Status" >> $GITHUB_STEP_SUMMARY | |
| echo "✓ Test execution skipped via CI skip flag" >> $GITHUB_STEP_SUMMARY | |
| else | |
| echo "- OS Version: $(cat /etc/redhat-release)" >> $GITHUB_STEP_SUMMARY | |
| fi | |
| } | |
| - name: Download Cloudberry RPM build artifacts | |
| if: needs.check-skip.outputs.should_skip != 'true' | |
| uses: actions/download-artifact@v4 | |
| with: | |
| name: apache-cloudberry-db-incubating-rpm-build-artifacts | |
| path: ${{ github.workspace }}/rpm_build_artifacts | |
| merge-multiple: false | |
| - name: Download Cloudberry Source build artifacts | |
| if: needs.check-skip.outputs.should_skip != 'true' | |
| uses: actions/download-artifact@v4 | |
| with: | |
| name: apache-cloudberry-db-incubating-source-build-artifacts | |
| path: ${{ github.workspace }}/source_build_artifacts | |
| merge-multiple: false | |
| - name: Verify downloaded artifacts | |
| if: needs.check-skip.outputs.should_skip != 'true' | |
| id: verify-artifacts | |
| run: | | |
| set -eo pipefail | |
| SRC_TARBALL_FILE=$(ls ${GITHUB_WORKSPACE}/source_build_artifacts/apache-cloudberry-incubating-src.tgz) | |
| if [ ! -f "${SRC_TARBALL_FILE}" ]; then | |
| echo "::error::SRC TARBALL file not found" | |
| exit 1 | |
| fi | |
| echo "src_tarball_file=${SRC_TARBALL_FILE}" >> $GITHUB_OUTPUT | |
| echo "Verifying SRC TARBALL artifacts..." | |
| { | |
| echo "=== SRC TARBALL Verification Summary ===" | |
| echo "Timestamp: $(date -u)" | |
| echo "SRC TARBALL File: ${SRC_TARBALL_FILE}" | |
| # Calculate and store checksum | |
| echo "Checksum:" | |
| sha256sum ${SRC_TARBALL_FILE} | |
| } 2>&1 | tee -a build-logs/details/src-tarball-verification.log | |
| RPM_FILE=$(ls ${GITHUB_WORKSPACE}/rpm_build_artifacts/apache-cloudberry-db-incubating*.rpm) | |
| if [ ! -f "${RPM_FILE}" ]; then | |
| echo "::error::RPM file not found" | |
| exit 1 | |
| fi | |
| echo "rpm_file=${RPM_FILE}" >> $GITHUB_OUTPUT | |
| echo "Verifying RPM artifacts..." | |
| { | |
| echo "=== RPM Verification Summary ===" | |
| echo "Timestamp: $(date -u)" | |
| echo "RPM File: ${RPM_FILE}" | |
| # Get RPM metadata and verify contents | |
| echo "Package Information:" | |
| rpm -qip ${RPM_FILE} | |
| # Get key RPM attributes for verification | |
| RPM_VERSION=$(rpm -qp --queryformat "%{VERSION}" ${RPM_FILE}) | |
| RPM_RELEASE=$(rpm -qp --queryformat "%{RELEASE}" ${RPM_FILE}) | |
| echo "version=${RPM_VERSION}" >> $GITHUB_OUTPUT | |
| echo "release=${RPM_RELEASE}" >> $GITHUB_OUTPUT | |
| # Verify expected binaries are in the RPM | |
| echo "Verifying critical files in RPM..." | |
| for binary in "bin/postgres" "bin/psql"; do | |
| if ! rpm -qlp ${RPM_FILE} | grep -q "${binary}$"; then | |
| echo "::error::Critical binary '${binary}' not found in RPM" | |
| exit 1 | |
| fi | |
| done | |
| echo "RPM Details:" | |
| echo "- Version: ${RPM_VERSION}" | |
| echo "- Release: ${RPM_RELEASE}" | |
| # Calculate and store checksum | |
| echo "Checksum:" | |
| sha256sum ${RPM_FILE} | |
| } 2>&1 | tee -a build-logs/details/rpm-verification.log | |
| - name: Install Cloudberry RPM | |
| if: success() && needs.check-skip.outputs.should_skip != 'true' | |
| env: | |
| RPM_FILE: ${{ steps.verify-artifacts.outputs.rpm_file }} | |
| RPM_VERSION: ${{ steps.verify-artifacts.outputs.version }} | |
| RPM_RELEASE: ${{ steps.verify-artifacts.outputs.release }} | |
| run: | | |
| set -eo pipefail | |
| if [ -z "${RPM_FILE}" ]; then | |
| echo "::error::RPM_FILE environment variable is not set" | |
| exit 1 | |
| fi | |
| { | |
| echo "=== RPM Installation Log ===" | |
| echo "Timestamp: $(date -u)" | |
| echo "RPM File: ${RPM_FILE}" | |
| echo "Version: ${RPM_VERSION}" | |
| echo "Release: ${RPM_RELEASE}" | |
| # Clean install location | |
| rm -rf /usr/local/cloudberry-db | |
| # Install RPM | |
| echo "Starting installation..." | |
| if ! time dnf install -y "${RPM_FILE}"; then | |
| echo "::error::RPM installation failed" | |
| exit 1 | |
| fi | |
| echo "Installation completed successfully" | |
| rpm -qi apache-cloudberry-db-incubating | |
| } 2>&1 | tee -a build-logs/details/rpm-installation.log | |
| - name: Extract source tarball | |
| if: success() && needs.check-skip.outputs.should_skip != 'true' | |
| env: | |
| SRC_TARBALL_FILE: ${{ steps.verify-artifacts.outputs.src_tarball_file }} | |
| SRC_DIR: ${{ github.workspace }} | |
| run: | | |
| set -eo pipefail | |
| { | |
| echo "=== Source Extraction Log ===" | |
| echo "Timestamp: $(date -u)" | |
| echo "Starting extraction..." | |
| if ! time tar zxf ${SRC_TARBALL_FILE} -C ${SRC_DIR}/.. ; then | |
| echo "::error::Source extraction failed" | |
| exit 1 | |
| fi | |
| echo "Extraction completed successfully" | |
| echo "Extracted contents:" | |
| ls -la "${SRC_DIR}/../cloudberry" | |
| echo "Directory size:" | |
| du -sh "${SRC_DIR}/../cloudberry" | |
| } 2>&1 | tee -a build-logs/details/source-extraction.log | |
| - name: Create Apache Cloudberry demo cluster | |
| if: success() && needs.check-skip.outputs.should_skip != 'true' | |
| env: | |
| SRC_DIR: ${{ github.workspace }} | |
| run: | | |
| set -eo pipefail | |
| { | |
| chmod +x ${SRC_DIR}/../cloudberry-devops-release/build_automation/cloudberry/scripts/create-cloudberry-demo-cluster.sh | |
| if ! time su - gpadmin -c "cd ${SRC_DIR} && SRC_DIR=${SRC_DIR} ${SRC_DIR}/../cloudberry-devops-release/build_automation/cloudberry/scripts/create-cloudberry-demo-cluster.sh"; then | |
| echo "::error::Demo cluster creation failed" | |
| exit 1 | |
| fi | |
| } 2>&1 | tee -a build-logs/details/create-cloudberry-demo-cluster.log | |
| - name: "Run Tests: ${{ matrix.test }}" | |
| if: success() && needs.check-skip.outputs.should_skip != 'true' | |
| env: | |
| SRC_DIR: ${{ github.workspace }} | |
| run: | | |
| set -eo pipefail | |
| { | |
| # Construct PGOPTIONS from pg_settings | |
| PG_OPTS="" | |
| if [[ -n "${{ matrix.pg_settings.optimizer }}" ]]; then | |
| PG_OPTS="$PG_OPTS -c optimizer=${{ matrix.pg_settings.optimizer }}" | |
| fi | |
| chmod +x ${SRC_DIR}/../cloudberry-devops-release/build_automation/cloudberry/scripts/test-cloudberry.sh | |
| if ! time su - gpadmin -c "cd ${SRC_DIR} && \ | |
| MAKE_NAME='${{ matrix.test }}' \ | |
| MAKE_TARGET='${{ matrix.make_target }}' \ | |
| MAKE_DIRECTORY='${{ matrix.make_directory }}' \ | |
| PGOPTIONS='${PG_OPTS}' \ | |
| SRC_DIR='${SRC_DIR}' \ | |
| ${SRC_DIR}/../cloudberry-devops-release/build_automation/cloudberry/scripts/test-cloudberry.sh"; then | |
| echo "::error::Test execution failed" | |
| df -kh / | |
| exit 1 | |
| fi | |
| } 2>&1 | tee -a build-logs/details/make-${{ matrix.test }}.log | |
| - name: Parse Test Results | |
| id: test-results | |
| if: always() | |
| shell: bash {0} | |
| env: | |
| SRC_DIR: ${{ github.workspace }} | |
| run: | | |
| set -o pipefail | |
| { | |
| if [[ "${{ needs.check-skip.outputs.should_skip }}" == "true" ]]; then | |
| echo "Tests skipped - setting default values" | |
| echo "status=skipped" >> $GITHUB_OUTPUT | |
| echo "total_tests=0" >> $GITHUB_OUTPUT | |
| echo "failed_tests=0" >> $GITHUB_OUTPUT | |
| echo "passed_tests=0" >> $GITHUB_OUTPUT | |
| echo "Skip status recorded" | tee -a build-logs/details/parse-test-results-${{ matrix.test }}.log | |
| exit 0 | |
| fi | |
| chmod +x ${SRC_DIR}/../cloudberry-devops-release/build_automation/cloudberry/scripts/parse-test-results.sh | |
| MAKE_NAME='${{ matrix.test }}' \ | |
| ${SRC_DIR}/../cloudberry-devops-release/build_automation/cloudberry/scripts/parse-test-results.sh \ | |
| build-logs/details/make-${{ matrix.test }}.log | |
| status_code=$? | |
| echo "status_code=$status_code" | |
| case $status_code in | |
| 0) # All tests passed | |
| echo "All tests passed successfully" | |
| ;; | |
| 1) # Tests failed but parsed successfully | |
| echo "Test failures detected but properly parsed" | |
| # Don't exit here - let the workflow continue | |
| ;; | |
| 2) # Parse error or missing file | |
| echo "::error::Could not find or access test results file" | |
| exit 1 | |
| ;; | |
| *) # Unexpected error | |
| echo "::error::Unexpected error during test results parsing" | |
| exit 1 | |
| ;; | |
| esac | |
| # Debug: verify outputs were set | |
| echo "Debug: Checking GITHUB_OUTPUT contents:" | |
| cat $GITHUB_OUTPUT || true | |
| } 2>&1 | tee -a build-logs/details/parse-test-results-${{ matrix.test }}.log | |
| - name: "Generate Test Job Summary End: ${{ matrix.test }}" | |
| if: always() | |
| shell: bash {0} | |
| run: | | |
| { | |
| if [[ "${{ needs.check-skip.outputs.should_skip }}" == "true" ]]; then | |
| echo "## Test Results - SKIPPED" | |
| echo "- End Time: $(date -u +'%Y-%m-%d %H:%M:%S UTC')" | |
| exit 0 | |
| fi | |
| echo "## Test Results" | |
| echo "- End Time: $(date -u +'%Y-%m-%d %H:%M:%S UTC')" | |
| # Add test execution results | |
| echo "### Test Execution Summary" | |
| echo "| Metric | Count |" | |
| echo "|--------|-------|" | |
| echo "| Total Tests | ${{ steps.test-results.outputs.total_tests }} |" | |
| echo "| Passed Tests | ${{ steps.test-results.outputs.passed_tests }} |" | |
| echo "| Failed Tests | ${{ steps.test-results.outputs.failed_tests }} |" | |
| # Test status with emoji based on results | |
| echo "### Test Status" | |
| if [[ "${{ steps.test-results.outputs.status }}" == "passed" ]]; then | |
| echo "✅ All ${{ steps.test-results.outputs.total_tests }} tests passed successfully" | |
| else | |
| echo "⚠️ ${{ steps.test-results.outputs.failed_tests }} of ${{ steps.test-results.outputs.total_tests }} tests failed" | |
| # Add failed tests as a bullet list if there are failures | |
| if [[ -n "${{ steps.test-results.outputs.failed_test_names }}" ]]; then | |
| echo "" | |
| echo "### Failed Tests" | |
| echo "The following tests failed:" | |
| echo "${{ steps.test-results.outputs.failed_test_names }}" | tr ',' '\n' | while read -r test; do | |
| if [[ -n "$test" ]]; then | |
| echo "* \`${test}\`" | |
| fi | |
| done | |
| fi | |
| fi | |
| } >> $GITHUB_STEP_SUMMARY || true | |
| - name: Upload test logs | |
| if: always() | |
| uses: actions/upload-artifact@v4 | |
| with: | |
| name: test-logs-${{ matrix.test }}-${{ needs.build.outputs.build_timestamp }} | |
| path: | | |
| build-logs/ | |
| **/regression.diffs | |
| **/regression.out | |
| retention-days: ${{ env.LOG_RETENTION_DAYS }} | |
| - name: Debug Upload Condition | |
| if: always() | |
| run: | | |
| echo "Upload condition check:" | |
| echo "status: '${{ steps.test-results.outputs.status }}'" | |
| echo "condition result: ${{ steps.test-results.outputs.status == 'failed' }}" | |
| - name: Upload test regression logs | |
| if: always() && steps.test-results.outputs.status == 'failed' | |
| uses: actions/upload-artifact@v4 | |
| with: | |
| name: regression-logs-${{ matrix.test }}-${{ needs.build.outputs.build_timestamp }} | |
| path: | | |
| src/test/regress/regression.out | |
| src/test/regress/regression.diffs | |
| src/test/regress/results/ | |
| src/test/regress/expected/ | |
| src/test/isolation2/regression.out | |
| src/test/isolation2/regression.diffs | |
| src/test/isolation2/results/ | |
| src/test/isolation2/expected/ | |
| gpAux/gpdemo/datadirs/standby/log/ | |
| gpAux/gpdemo/datadirs/qddir/demoDataDir-1/log/ | |
| gpAux/gpdemo/datadirs/dbfast1/demoDataDir0/log/ | |
| gpAux/gpdemo/datadirs/dbfast2/demoDataDir1/log/ | |
| gpAux/gpdemo/datadirs/dbfast3/demoDataDir2/log/ | |
| gpAux/gpdemo/datadirs/dbfast_mirror1/demoDataDir0/log/ | |
| gpAux/gpdemo/datadirs/dbfast_mirror2/demoDataDir1/log/ | |
| gpAux/gpdemo/datadirs/dbfast_mirror3/demoDataDir2/log/ | |
| retention-days: ${{ env.LOG_RETENTION_DAYS }} | |
| report: | |
| name: Generate Apache Cloudberry Build Report | |
| needs: [check-skip, build, rpm-install-test, test] | |
| if: always() | |
| runs-on: ubuntu-latest | |
| steps: | |
| - name: Generate Final Report | |
| run: | | |
| { | |
| echo "# Apache Cloudberry Build Pipeline Report" >> $GITHUB_STEP_SUMMARY | |
| if [[ "${{ needs.check-skip.outputs.should_skip }}" == "true" ]]; then | |
| echo "## CI Skip Status" >> $GITHUB_STEP_SUMMARY | |
| echo "✅ CI checks skipped via skip flag" >> $GITHUB_STEP_SUMMARY | |
| echo "- Completion Time: $(date -u +'%Y-%m-%d %H:%M:%S UTC')" >> $GITHUB_STEP_SUMMARY | |
| else | |
| echo "## Job Status" >> $GITHUB_STEP_SUMMARY | |
| echo "- Build Job: ${{ needs.build.result }}" >> $GITHUB_STEP_SUMMARY | |
| echo "- Test Job: ${{ needs.test.result }}" >> $GITHUB_STEP_SUMMARY | |
| echo "- Completion Time: $(date -u +'%Y-%m-%d %H:%M:%S UTC')" >> $GITHUB_STEP_SUMMARY | |
| if [[ "${{ needs.build.result }}" == "success" && "${{ needs.test.result }}" == "success" ]]; then | |
| echo "✅ Pipeline completed successfully" >> $GITHUB_STEP_SUMMARY | |
| else | |
| echo "⚠️ Pipeline completed with failures" >> $GITHUB_STEP_SUMMARY | |
| if [[ "${{ needs.build.result }}" != "success" ]]; then | |
| echo "### Build Job Failure" >> $GITHUB_STEP_SUMMARY | |
| echo "Check build logs for details" >> $GITHUB_STEP_SUMMARY | |
| fi | |
| if [[ "${{ needs.test.result }}" != "success" ]]; then | |
| echo "### Test Job Failure" >> $GITHUB_STEP_SUMMARY | |
| echo "Check test logs and regression files for details" >> $GITHUB_STEP_SUMMARY | |
| fi | |
| fi | |
| fi | |
| } | |
| - name: Notify on failure | |
| if: | | |
| needs.check-skip.outputs.should_skip != 'true' && | |
| (needs.build.result != 'success' || needs.test.result != 'success') | |
| run: | | |
| echo "::error::Build/Test pipeline failed! Check job summaries and logs for details" | |
| echo "Timestamp: $(date -u +'%Y-%m-%d %H:%M:%S UTC')" | |
| echo "Build Result: ${{ needs.build.result }}" | |
| echo "Test Result: ${{ needs.test.result }}" |