ubuntu-24 or latest fails to load image, must downgrade to ubuntu-22

[matte]

Setup GithubAction

Current runner version: '2.321.0'
Operating System
  Ubuntu
  24.04.1
  LTS

Error with ubuntu-latest

Run Particular/[email protected]
  with:
    connection-string-env-var: SQL_SERVER_CONNECTION_STRING
    sqlserver-version: 2019
    catalog: nservicebus
  env:
    pythonLocation: /opt/hostedtoolcache/Python/3.11.8/x64
    PKG_CONFIG_PATH: /opt/hostedtoolcache/Python/3.11.8/x64/lib/pkgconfig
    Python_ROOT_DIR: /opt/hostedtoolcache/Python/3.11.8/x64
    Python2_ROOT_DIR: /opt/hostedtoolcache/Python/3.11.8/x64
    Python3_ROOT_DIR: /opt/hostedtoolcache/Python/3.11.8/x64
    LD_LIBRARY_PATH: /opt/hostedtoolcache/Python/3.11.8/x64/lib
Run # Linux SQL install via Docker
Starting SQL Server in a Docker container...
Unable to find image 'mcr.microsoft.com/mssql/server:2019-latest' locally
2019-latest: Pulling from mssql/server
b43df23e6f02: Pulling fs layer
9c3112081910: Pulling fs layer
9d1aa3cd942c: Pulling fs layer
b43df23e6f02: Verifying Checksum
b43df23e6f02: Download complete
9d1aa3cd942c: Verifying Checksum
9d1aa3cd942c: Download complete
9c3112081910: Verifying Checksum
9c3112081910: Download complete
b43df23e6f02: Pull complete
9c3112081910: Pull complete
9d1aa3cd942c: Pull complete
Digest: sha256:9b7a16515362447426b714e92e0f6bcb7d61ed1f7e6e382657c09a00bf7aa888
Status: Downloaded newer image for mcr.microsoft.com/mssql/server:2019-latest
6a606bb628e6e115503b471589e7573d241d20e103528ee8fd1733eea9e4174c
Setting environment variables for sqlcmd...
Setting environment variable SQL_SERVER_CONNECTION_STRING to SQL connection string...
Run # Wait for availability then create initial catalog
Attempt 1/30 to connect to SQL Server...
sqlcmd: /home/runner/work/_temp/e57b7abc-1d50-4897-93ea-f82c265a50e2.ps1:6
Line |
   6 |    sqlcmd -b -Q "SELECT @@SERVERNAME as ServerName" 2>&1>$null
     |    ~~~~~~
     | The term 'sqlcmd' is not recognized as a name of a cmdlet, function,
     | script file, or executable program. Check the spelling of the name, or
     | if a path was included, verify that the path is correct and try again.
Error: Process completed with exit code 1.

Downstream issue: Particular/install-sql-server-action#21

[stevenobird]

A reason could be one of two things:

1. sqlcmd's path changed in a certain release. See the note here:

Starting with SQL Server 2022 (16.x) CU 14 and SQL Server 2019 (15.x) CU 28, the container images include the new mssql-tools18 package. The previous directory /opt/mssql-tools/bin is being phased out. The new directory for Microsoft ODBC 18 tools is /opt/mssql-tools18/bin, aligning with the latest tools offering. For more information about changes and security enhancements, see ODBC Driver 18.0 for SQL Server Released.

2. it seems that official Ubuntu 24.04 support is lacking for SQL Server and its tools?

pwsh cannot find sqlcmd in $PATH which is a follow up issue.
Either sqlcmd is not installed at all, or it's installation directory is not in $PATH and therefore could not be found by pwsh.

EDIT: My bad, the cause is not in one of the Docker images but rather the runner images hat GitHub hosts. sqlcmd is pre-installed in ubuntu22.04, but not in ubuntu24.04 - take a look at both readmes and search for "sqlcmd". My guess is the lack of official support by Microsoft for Ubuntu 24.04 as of now.

A closer look at this issue in the runner-actions repository states the following regarding MS SQL Server Client Tools or sqlcmd / SqlPackage:

Removed from the Ubuntu 24.04 image due to maintenance reasons.