run sqlserver tests on ubuntu 20.04

lu-zhengda commented 1 month ago

What does this PR do?

mssql container seeing fatal error on starting with ubuntu 22.04 runner follow kernel update on 9/15. This has caused sqlserver integration tests fail to connect to the test database. Change the test runner to ubuntu 20.04. (i've tried updating mssql to 2017-latest, 2019-latest & 2022-latest but that doesn't work. i kept the image tag as it is for now even thought these image tags are old and we should probably update them)

Motivation

Fix mssql container fatal error

E   Captured Output: sqlserver-1  | This program has encountered a fatal error and cannot continue running at Thu Sep 26 20:58:40 2024
E   sqlserver-1  | The following diagnostic information is available:
E   sqlserver-1  | 
E   sqlserver-1  |          Reason: 0x00000001
E   sqlserver-1  |          Signal: SIGABRT - Aborted (6)
E   sqlserver-1  |           Stack:
E   sqlserver-1  |                  IP               Function
E   sqlserver-1  |                  ---------------- --------------------------------------
E   sqlserver-1  |                  00005653c069549c <unknown>
E   sqlserver-1  |                  00005653c0694ee2 <unknown>
E   sqlserver-1  |                  00005653c06944f1 <unknown>
E   sqlserver-1  |                  00007fbf74715f10 killpg+0x40
E   sqlserver-1  |                  00007fbf74715e87 gsignal+0xc7
E   sqlserver-1  |                  00007fbf747177f1 abort+0x141
E   sqlserver-1  |                  00005653c061be42 <unknown>
E   sqlserver-1  |                  00005653c06a2cb4 <unknown>
E   sqlserver-1  |                  00005653c06d61f8 <unknown>
E   sqlserver-1  |                  00005653c06d5fda <unknown>
E   sqlserver-1  |                  00005653c0627cba <unknown>
E   sqlserver-1  |                  00005653c062790f <unknown>
E   sqlserver-1  |         Process: 13 - sqlservr
E   sqlserver-1  |          Thread: 86 (application thread 0x13c)
E   sqlserver-1  |     Instance Id: af15e99b-b1f1-4c2d-b194-677db0d75cda
E   sqlserver-1  |        Crash Id: 9dc641c6-4ba7-4970-b661-3fbf4fb164f9
E   sqlserver-1  |     Build stamp: a061e85be3fdd5c8d55a05c62bda0b9e1d6d267f3cac4d70d78ec1a9a6f57be0
E   sqlserver-1  |    Distribution: Ubuntu 18.04.6 LTS
E   sqlserver-1  |      Processors: 4
E   sqlserver-1  |    Total Memory: 16766763008 bytes
E   sqlserver-1  |       Timestamp: Thu Sep 26 20:58:40 2024
E   sqlserver-1  |      Last errno: 2
E   sqlserver-1  | Last errno text: No such file or directory
E   sqlserver-1  | Capturing a dump of 13
E   sqlserver-1  | Successfully captured dump: /var/opt/mssql/log/core.sqlservr.9_26_2024_20_58_40.13
E   sqlserver-1  | Executing: /opt/mssql/bin/handle-crash.sh with parameters
E   sqlserver-1  |      handle-crash.sh
E   sqlserver-1  |      /opt/mssql/bin/sqlservr
E   sqlserver-1  |      13
E   sqlserver-1  |      /opt/mssql/bin
E   sqlserver-1  |      /var/opt/mssql/log/
E   sqlserver-1  |      
E   sqlserver-1  |      af15e99b-b1f1-4c2d-b194-677db0d75cda
E   sqlserver-1  |      9dc641c6-4ba7-4970-b661-3fbf4fb164f9
E   sqlserver-1  |      
E   sqlserver-1  |      /var/opt/mssql/log/core.sqlservr.9_26_2024_20_58_40.13
E   sqlserver-1  | 
E   sqlserver-1  | Ubuntu 18.04.6 LTS
E   sqlserver-1  | Capturing core dump and information to /var/opt/mssql/log...
E   sqlserver-1  | dmesg: read kernel buffer failed: Operation not permitted
E   sqlserver-1  | /usr/bin/timeout: failed to run command '/bin/journalctl': No such file or directory
E   sqlserver-1  | /usr/bin/timeout: failed to run command '/bin/journalctl': No such file or directory
E   sqlserver-1  | Thu Sep 26 20:58:41 UTC 2024 Capturing program information
E   sqlserver-1  | Dump already generated: /var/opt/mssql/log/core.sqlservr.9_26_2024_20_58_40.13, moving to /var/opt/mssql/log/core.sqlservr.13.temp/core.sqlservr.13.gdmp
E   sqlserver-1  | Moving logs to /var/opt/mssql/log/core.sqlservr.13.temp/log/paldumper-debug.log
E   sqlserver-1  | Thu Sep 26 20:58:41 UTC 2024 Capturing program binaries
E   sqlserver-1  | Thu Sep 26 20:58:42 UTC 2024 Not compressing the dump files, moving instead to: /var/opt/mssql/log/core.sqlservr.09_26_2024_20_58_41.13.d

Additional Notes

Review checklist (to be filled by reviewers)

[ ] Feature or bugfix MUST have appropriate tests (unit, integration, e2e)
[ ] Changelog entries must be created for modifications to shipped code
[ ] Add the qa/skip-qa label if the PR doesn't need to be tested during QA.
[ ] If you need to backport this PR to another branch, you can add the backport/<branch-name> label to the PR and it will automatically open a backport PR once this one is merged

github-actions[bot] commented 1 month ago

The validations job has failed; please review the Files changed tab for possible suggestions to resolve.

github-actions[bot] commented 1 month ago

The validations job has failed; please review the Files changed tab for possible suggestions to resolve.

github-actions[bot] commented 1 month ago

The validations job has failed; please review the Files changed tab for possible suggestions to resolve.

codecov[bot] commented 1 month ago

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 89.22%. Comparing base (965ba2d) to head (8566d17). Report is 2 commits behind head on master.

Additional details and impacted files

| [Flag](https://app.codecov.io/gh/DataDog/integrations-core/pull/18683/flags?src=pr&el=flags&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=DataDog) | Coverage Δ | | |---|---|---| | [activemq](https://app.codecov.io/gh/DataDog/integrations-core/pull/18683/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=DataDog) | `?` | | | [cassandra](https://app.codecov.io/gh/DataDog/integrations-core/pull/18683/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=DataDog) | `?` | | | [hive](https://app.codecov.io/gh/DataDog/integrations-core/pull/18683/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=DataDog) | `?` | | | [hivemq](https://app.codecov.io/gh/DataDog/integrations-core/pull/18683/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=DataDog) | `?` | | | [hudi](https://app.codecov.io/gh/DataDog/integrations-core/pull/18683/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=DataDog) | `?` | | | [ignite](https://app.codecov.io/gh/DataDog/integrations-core/pull/18683/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=DataDog) | `?` | | | [jboss_wildfly](https://app.codecov.io/gh/DataDog/integrations-core/pull/18683/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=DataDog) | `?` | | | [kafka](https://app.codecov.io/gh/DataDog/integrations-core/pull/18683/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=DataDog) | `?` | | | [presto](https://app.codecov.io/gh/DataDog/integrations-core/pull/18683/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=DataDog) | `?` | | | [solr](https://app.codecov.io/gh/DataDog/integrations-core/pull/18683/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=DataDog) | `?` | | | [sqlserver](https://app.codecov.io/gh/DataDog/integrations-core/pull/18683/flags?src=pr&el=flag&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=DataDog) | `89.50% <ø> (+9.67%)` | :arrow_up: | Flags with carried forward coverage won't be shown. [Click here](https://docs.codecov.io/docs/carryforward-flags?utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=DataDog#carryforward-flags-in-the-pull-request-comment) to find out more.

DataDog / integrations-core