From 1c87d6080058f7e4cc4b91f2fc86a473f3480538 Mon Sep 17 00:00:00 2001 From: Simon Brandhof Date: Wed, 27 Mar 2019 19:53:49 +0100 Subject: [PATCH] Nightly run of DB upgrade tests --- .cirrus.yml | 136 ++++++++++++++++++++++++++++++++++++++++++++++++---- 1 file changed, 126 insertions(+), 10 deletions(-) diff --git a/.cirrus.yml b/.cirrus.yml index e4d59db3f37..fdac6b10fdc 100644 --- a/.cirrus.yml +++ b/.cirrus.yml @@ -135,6 +135,7 @@ qa_task: QA_CATEGORY: Billing QA_CATEGORY: License QA_CATEGORY: Branch + QA_CATEGORY: Upgrade # No need to clone the full history. # Depth of 1 is not enough because it would fail the build in case of consecutive pushes # (example of error: "Hard resetting to c968ecaf7a1942dacecd78480b3751ac74d53c33...Failed to force reset to c968ecaf7a1942dacecd78480b3751ac74d53c33: object not found!") @@ -169,11 +170,11 @@ promote_task: script: - ./private/cirrus/cirrus-promote.sh -db_unit_mysql57_task: +test_sql_mysql57_task: depends_on: build # Comment the following line and commit with message "DO NOT MERGE" in order to run # this task on your branch - only_if: $CIRRUS_BRANCH == "master" + only_if: $CIRRUS_TAG == "nightly-build" gke_container: image: gradle:4.10.1-jdk8 cluster_name: cirrus-euw3a-cluster @@ -199,11 +200,11 @@ db_unit_mysql57_task: cleanup_before_cache_script: - ./private/cirrus/cleanup-gradle-cache.sh -db_mssql2017_task: +test_sql_mssql2017_task: depends_on: build # Comment the following line and commit with message "DO NOT MERGE" in order to run # this task on your branch - only_if: $CIRRUS_BRANCH == "master" + only_if: $CIRRUS_TAG == "nightly-build" gke_container: image: gradle:4.10.1-jdk8 cluster_name: cirrus-euw3a-cluster @@ -228,11 +229,11 @@ db_mssql2017_task: cleanup_before_cache_script: - ./private/cirrus/cleanup-gradle-cache.sh -db_mssql2019_task: +test_sql_mssql2019_task: depends_on: build # Comment the following line and commit with message "DO NOT MERGE" in order to run # this task on your branch - only_if: $CIRRUS_BRANCH == "master" + only_if: $CIRRUS_TAG == "nightly-build" gke_container: image: gradle:4.10.1-jdk8 cluster_name: cirrus-euw3a-cluster @@ -258,11 +259,11 @@ db_mssql2019_task: - ./private/cirrus/cleanup-gradle-cache.sh # this is the oldest compatible version of PostgreSQL -db_postgres93_task: +test_sql_postgres93_task: depends_on: build # Comment the following line and commit with message "DO NOT MERGE" in order to run # this task on your branch - only_if: $CIRRUS_BRANCH == "master" + only_if: $CIRRUS_TAG == "nightly-build" gke_container: image: gradle:4.10.1-jdk8 cluster_name: cirrus-euw3a-cluster @@ -286,11 +287,11 @@ db_postgres93_task: cleanup_before_cache_script: - ./private/cirrus/cleanup-gradle-cache.sh -db_oracle12_task: +test_sql_oracle12_task: depends_on: build # Comment the following line and commit with message "DO NOT MERGE" in order to run # this task on your branch - only_if: $CIRRUS_BRANCH == "master" + only_if: $CIRRUS_TAG == "nightly-build" gke_container: image: gradle:4.10.1-jdk8 cluster_name: cirrus-euw3a-cluster @@ -312,3 +313,118 @@ db_oracle12_task: - ./private/cirrus/cirrus-db-unit-test.sh oracle12 cleanup_before_cache_script: - ./private/cirrus/cleanup-gradle-cache.sh + + +test_upgrade_mysql57_task: + depends_on: build + # Comment the following line and commit with message "DO NOT MERGE" in order to run + # this task on your branch + only_if: $CIRRUS_TAG == "nightly-build" + gke_container: + dockerfile: private/docker/Dockerfile-build + builder_image_project: ci-cd-215716 + builder_image_name: docker-builder-v1 + cluster_name: cirrus-euw3a-cluster + zone: europe-west3-a + namespace: default + cpu: 1.5 + memory: 6Gb + additional_containers: + - name: mysql + image: mysql:5.7 # see https://github.com/mysql/mysql-docker + port: 3306 + cpu: 1 + memory: 1Gb + env: + MYSQL_ROOT_PASSWORD: sonarsource + MYSQL_DATABASE: sonar + MYSQL_USER: sonar + MYSQL_PASSWORD: sonar + env: + matrix: + QA_CATEGORY: Upgrade + # No need to clone the full history. + # Depth of 1 is not enough because it would fail the build in case of consecutive pushes + # (example of error: "Hard resetting to c968ecaf7a1942dacecd78480b3751ac74d53c33...Failed to force reset to c968ecaf7a1942dacecd78480b3751ac74d53c33: object not found!") + CIRRUS_CLONE_DEPTH: 50 + gradle_cache: + folder: ~/.gradle/caches + script: + - ./private/cirrus/cirrus-qa.sh mysql57 + cleanup_before_cache_script: + - ./private/cirrus/cleanup-gradle-cache.sh + +test_upgrade_mssql2017_task: + depends_on: build + # Comment the following line and commit with message "DO NOT MERGE" in order to run + # this task on your branch + only_if: $CIRRUS_TAG == "nightly-build" + gke_container: + dockerfile: private/docker/Dockerfile-build + builder_image_project: ci-cd-215716 + builder_image_name: docker-builder-v1 + cluster_name: cirrus-euw3a-cluster + zone: europe-west3-a + namespace: default + cpu: 1.5 + memory: 6Gb + additional_containers: + - name: mssql + image: mcr.microsoft.com/mssql/server:2017-CU12-ubuntu + port: 1433 + cpu: 2 + memory: 5Gb + env: + MSSQL_PID: Developer # this is the default edition + ACCEPT_EULA: Y + SA_PASSWORD: sonarqube!1 + env: + matrix: + QA_CATEGORY: Upgrade + # No need to clone the full history. + # Depth of 1 is not enough because it would fail the build in case of consecutive pushes + # (example of error: "Hard resetting to c968ecaf7a1942dacecd78480b3751ac74d53c33...Failed to force reset to c968ecaf7a1942dacecd78480b3751ac74d53c33: object not found!") + CIRRUS_CLONE_DEPTH: 50 + gradle_cache: + folder: ~/.gradle/caches + script: + - ./private/cirrus/cirrus-qa.sh mssql2017 + cleanup_before_cache_script: + - ./private/cirrus/cleanup-gradle-cache.sh + + +test_upgrade_oracle12_task: + depends_on: build + # Comment the following line and commit with message "DO NOT MERGE" in order to run + # this task on your branch + only_if: $CIRRUS_TAG == "nightly-build" + gke_container: + dockerfile: private/docker/Dockerfile-build + builder_image_project: ci-cd-215716 + builder_image_name: docker-builder-v1 + cluster_name: cirrus-euw3a-cluster + zone: europe-west3-a + namespace: default + cpu: 1.5 + memory: 6Gb + additional_containers: + - name: oracle + image: gcr.io/ci-cd-215716/oracle12:0.0.1 # see https://github.com/SonarSource/vms/blob/master/docker/README.md#oracle-12c to build it + port: 1521 + cpu: 2 + memory: 5Gb + env: + ORACLE_PWD: sonarqube + env: + matrix: + QA_CATEGORY: Upgrade + # No need to clone the full history. + # Depth of 1 is not enough because it would fail the build in case of consecutive pushes + # (example of error: "Hard resetting to c968ecaf7a1942dacecd78480b3751ac74d53c33...Failed to force reset to c968ecaf7a1942dacecd78480b3751ac74d53c33: object not found!") + CIRRUS_CLONE_DEPTH: 50 + gradle_cache: + folder: ~/.gradle/caches + script: + - ./private/cirrus/cirrus-qa.sh oracle12 + cleanup_before_cache_script: + - ./private/cirrus/cleanup-gradle-cache.sh -- 2.39.5