MSSQL containers crashing after recent update

[HofmeisterAn]

Description

Hi, it looks like the recent update is causing issues with running MSSQL containers. Some Testcontainers users mentioned they're having trouble with the MSSQL module. I ran into similar issues before with Ubuntu 24.04 (testcontainers/testcontainers-dotnet#1248 (comment)). I just tried it now with 22.04, and the container crashes as well 😕. You can reproduce it by running the following command on the agent:

docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=YourStrong!Passw0rd' mcr.microsoft.com/mssql/server:2019-CU18-ubuntu-20.04

This program has encountered a fatal error and cannot continue running at Thu Sep 19 11:33:13 2024
The following diagnostic information is available:

         Reason: 0x00000001
         Signal: SIGABRT - Aborted (6)
          Stack:
                 IP               Function
                 ---------------- --------------------------------------
                 0000561e37a26bec <unknown>
                 0000561e37a26632 <unknown>
                 0000561e37a25c41 <unknown>
                 00007fa9f816a090 killpg+0x40
                 00007fa9f816a00b gsignal+0xcb
                 00007fa9f8149859 abort+0x12b
                 0000561e379af2a2 <unknown>
        Process: 9 - sqlservr
         Thread: 128 (application thread 0x1f8)
    Instance Id: e686a0a0-eb06-4753-ae51-d73296433979
       Crash Id: 5e19a47d-b473-48c7-a86b-68f8e5b84fc1
    Build stamp: f708684a2cfcb51177273c54f975ed8c62029cbc89aa962bf7d6b956f01a0c27
   Distribution: Ubuntu 20.04.5 LTS
     Processors: 4
   Total Memory: 16766771200 bytes
      Timestamp: Thu Sep 19 11:33:13 2024
     Last errno: 2
Last errno text: No such file or directory
/bin/cat: /proc/9/maps: Permission denied
/bin/cat: /proc/9/environ: Permission denied
/usr/bin/find: '/proc/9/task/9/fdinfo': Permission denied
/usr/bin/find: '/proc/9/task/11/fdinfo': Permission denied
/usr/bin/find: '/proc/9/task/12/fdinfo': Permission denied
/usr/bin/find: '/proc/9/task/13/fdinfo': Permission denied
/usr/bin/find: '/proc/9/task/14/fdinfo': Permission denied
/usr/bin/find: '/proc/9/task/15/fdinfo': Permission denied

Platforms affected

• Azure DevOps
• GitHub Actions - Standard Runners
• GitHub Actions - Larger Runners

Runner images affected

• Ubuntu 20.04
• Ubuntu 22.04
• Ubuntu 24.04
• macOS 12
• macOS 13
• macOS 13 Arm64
• macOS 14
• macOS 14 Arm64
• Windows Server 2019
• Windows Server 2022

Image version and build link

20240915.1.0

Is it regression?

Yes, 20240908.1.0

Expected behavior

The container starts successfully.

Actual behavior

The container crashes; please see the attached logs above.

Repro steps

runs-on: ubuntu-22.04
steps:
  - name: Debug MSSQL Container Start
    run: docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=YourStrong!Passw0rd' mcr.microsoft.com/mssql/server:2019-CU18-ubuntu-20.04

[RaviAkshintala]

Hi @HofmeisterAn Thank you for bringing this issue to us. We are looking into this issue and will update you on this issue after investigating.

[HofmeisterAn]

I would like to add that I am also seeing other containers failing to start. Many of the container images are (seem) outdated, but they worked previously. Developers might encounter breaking changes.

[RaviAkshintala]

Hi @HofmeisterAn Could you please add runs-on: ubuntu-20.04 to your workflow file and try it?

[HofmeisterAn]

It is running on Ubuntu-20.04, but the kernel has not changed here.