Skip to content

Scheduled ClickHouse 24.3 #38

Scheduled ClickHouse 24.3

Scheduled ClickHouse 24.3 #38

name: Scheduled ClickHouse 24.3
run-name: Scheduled ClickHouse 24.3
on:
workflow_dispatch:
#Run at 12:00 AM (UTC), Monday through Thursday
schedule:
- cron: "0 0 * * 1-4"
jobs:
get_clickhouse_version:
runs-on: [self-hosted, type-cpx41, image-x86-app-docker-ce]
outputs:
version: ${{ steps.version.outputs.version }}
steps:
- name: Pull Docker image
run: docker pull clickhouse/clickhouse-server:24.3
- name: Get version
id: version
run: |
VERSION_24_3=$(docker image inspect --format '{{json .}}' "clickhouse/clickhouse-server:24.3" | jq -r '.Config.Labels."com.clickhouse.build.version" | ltrimstr("v") | split("-")[0]')
echo "version=$VERSION_24_3" >> "$GITHUB_OUTPUT"
echo $VERSION_24_3
clickhouse-24-3-x86-with-analyzer:
needs: get_clickhouse_version
uses: ./.github/workflows/reusable-workflow-x86.yml
name: "x86-with-analyzer-${{ needs.get_clickhouse_version.outputs.version }}"
with:
package: "docker://clickhouse/clickhouse-server:${{ needs.get_clickhouse_version.outputs.version }}-alpine"
version: "${{ needs.get_clickhouse_version.outputs.version }}-alpine"
extra_args: '--with-analyzer'
secrets:
AWS_ACCESS_KEY_ID: ${{ secrets.AWS_REPORT_KEY_ID }}
AWS_SECRET_ACCESS_KEY: ${{ secrets.AWS_REPORT_SECRET_ACCESS_KEY }}
AWS_REPORT_REGION: ${{ secrets.AWS_REPORT_REGION }}
DOCKER_USERNAME: ${{ secrets.DOCKER_USERNAME }}
DOCKER_PASSWORD: ${{ secrets.DOCKER_PASSWORD }}
AWS_BUCKET: ${{ secrets.AWS_BUCKET }}
AWS_REGION: ${{ secrets.AWS_REGION }}
AWS_KEY_ID: ${{ secrets.AWS_KEY_ID }}
AWS_ACCESS_KEY: ${{ secrets.AWS_ACCESS_KEY }}
GCS_URI: ${{ secrets.GCS_URI }}
GCS_KEY_ID: ${{ secrets.GCS_KEY_ID }}
GCS_KEY_SECRET: ${{ secrets.GCS_KEY_SECRET }}
clickhouse-24-3-arm-with-analyzer:
needs: get_clickhouse_version
uses: ./.github/workflows/reusable-workflow-arm.yml
name: "arm-with-analyzer-${{ needs.get_clickhouse_version.outputs.version }}"
with:
package: "docker://clickhouse/clickhouse-server:${{ needs.get_clickhouse_version.outputs.version }}-alpine"
version: "${{ needs.get_clickhouse_version.outputs.version }}-alpine"
extra_args: '--with-analyzer'
secrets:
AWS_ACCESS_KEY_ID: ${{ secrets.AWS_REPORT_KEY_ID }}
AWS_SECRET_ACCESS_KEY: ${{ secrets.AWS_REPORT_SECRET_ACCESS_KEY }}
AWS_REPORT_REGION: ${{ secrets.AWS_REPORT_REGION }}
DOCKER_USERNAME: ${{ secrets.DOCKER_USERNAME }}
DOCKER_PASSWORD: ${{ secrets.DOCKER_PASSWORD }}
AWS_BUCKET: ${{ secrets.AWS_BUCKET }}
AWS_REGION: ${{ secrets.AWS_REGION }}
AWS_KEY_ID: ${{ secrets.AWS_KEY_ID }}
AWS_ACCESS_KEY: ${{ secrets.AWS_ACCESS_KEY }}
GCS_URI: ${{ secrets.GCS_URI }}
GCS_KEY_ID: ${{ secrets.GCS_KEY_ID }}
GCS_KEY_SECRET: ${{ secrets.GCS_KEY_SECRET }}
clickhouse-24-3-x86:
needs: get_clickhouse_version
uses: ./.github/workflows/reusable-workflow-x86.yml
name: "x86-${{ needs.get_clickhouse_version.outputs.version }}"
with:
package: "docker://clickhouse/clickhouse-server:${{ needs.get_clickhouse_version.outputs.version }}-alpine"
version: "${{ needs.get_clickhouse_version.outputs.version }}-alpine"
extra_args: '--with-analyzer'
secrets:
AWS_ACCESS_KEY_ID: ${{ secrets.AWS_REPORT_KEY_ID }}
AWS_SECRET_ACCESS_KEY: ${{ secrets.AWS_REPORT_SECRET_ACCESS_KEY }}
AWS_REPORT_REGION: ${{ secrets.AWS_REPORT_REGION }}
DOCKER_USERNAME: ${{ secrets.DOCKER_USERNAME }}
DOCKER_PASSWORD: ${{ secrets.DOCKER_PASSWORD }}
AWS_BUCKET: ${{ secrets.AWS_BUCKET }}
AWS_REGION: ${{ secrets.AWS_REGION }}
AWS_KEY_ID: ${{ secrets.AWS_KEY_ID }}
AWS_ACCESS_KEY: ${{ secrets.AWS_ACCESS_KEY }}
GCS_URI: ${{ secrets.GCS_URI }}
GCS_KEY_ID: ${{ secrets.GCS_KEY_ID }}
GCS_KEY_SECRET: ${{ secrets.GCS_KEY_SECRET }}
clickhouse-24-3-arm:
needs: get_clickhouse_version
uses: ./.github/workflows/reusable-workflow-arm.yml
name: "arm-${{ needs.get_clickhouse_version.outputs.version }}"
with:
package: "docker://clickhouse/clickhouse-server:${{ needs.get_clickhouse_version.outputs.version }}-alpine"
version: "${{ needs.get_clickhouse_version.outputs.version }}-alpine"
extra_args: '--with-analyzer'
secrets:
AWS_ACCESS_KEY_ID: ${{ secrets.AWS_REPORT_KEY_ID }}
AWS_SECRET_ACCESS_KEY: ${{ secrets.AWS_REPORT_SECRET_ACCESS_KEY }}
AWS_REPORT_REGION: ${{ secrets.AWS_REPORT_REGION }}
DOCKER_USERNAME: ${{ secrets.DOCKER_USERNAME }}
DOCKER_PASSWORD: ${{ secrets.DOCKER_PASSWORD }}
AWS_BUCKET: ${{ secrets.AWS_BUCKET }}
AWS_REGION: ${{ secrets.AWS_REGION }}
AWS_KEY_ID: ${{ secrets.AWS_KEY_ID }}
AWS_ACCESS_KEY: ${{ secrets.AWS_ACCESS_KEY }}
GCS_URI: ${{ secrets.GCS_URI }}
GCS_KEY_ID: ${{ secrets.GCS_KEY_ID }}
GCS_KEY_SECRET: ${{ secrets.GCS_KEY_SECRET }}