Adding and testing diagnostics steps

jgebal · jgebal · commit 07fcf3582fcb · 2022-02-08T01:34:02.000+02:00
diff --git a/.github/workflows/build.yml b/.github/workflows/build.yml
@@ -59,17 +59,19 @@ jobs:
         image: ${{matrix.oracle-version}}
         env:
           ORACLE_PASSWORD: oracle
-          MATRIX_JOB_ID: ${{matrix.id}}
         credentials:
           username: ${{ secrets.DOCKER_USER }}
           password: ${{ secrets.DOCKER_PASSWORD }}
+        volumes:
+          - ${{github.workspace}}:/utPLSQL
         ports:
           - 1521:1521
         options: >-
           --health-cmd healthcheck.sh
           --health-interval 10s
           --health-timeout 5s
           --health-retries 10
+          --name oracle
 
     steps:
       - uses: actions/checkout@v2
@@ -142,6 +144,20 @@ jobs:
         id: run-tests
         run: bash test/run_tests.sh
 
+#Needed to diagnose occasional failures of DB on test runs
+      - name: Get ORACLE_BASE/diag data
+        id: get-oracle-diag-data
+        if: ${{ always() && steps.run-tests.outcome == 'failure'  }}
+        run: docker exec oracle bash -c "cp -r ${ORACLE_BASE}/diag /utPLSQL/database-diag"
+#Needed to diagnose occasional failures of DB on test runs
+      - name: Upload ORACLE_BASE/diag data Artifact
+        id:  upload
+        if: ${{ always() && steps.run-tests.outcome == 'failure'  }}
+        uses: actions/upload-artifact@v2
+        with:
+          name: my-artifact$-${{matrix.db_version_name}}
+          path: ${{github.workspace}}/database-diag
+
       - name: Validate utPLSQL reports format
         id: validate-reports-format
         run:  bash .github/scripts/validate_report_files.sh
