mssql-docker icon indicating copy to clipboard operation
mssql-docker copied to clipboard

azure-sql-edge docker images fail on kernel 6.7+

Open andrea-reale opened this issue 1 year ago • 5 comments
trafficstars

Hey there,

this is a follow up to #868 , which was about a bug that prevented the MSSQL server container to start on docker when running on kernel 6.7 and later.

The bug seems to also affect azure-sql-server images, whose last update was 13 months ago (so before the fix for mssql-server was released).

This has been reported by several users whose workflow was broken after updating to Docker Desktop 4.33, which ships kernel 6.10: issue

Additionally, users also report non-2022 mssql-server images being affected by the issue.

Questions:

  • Are there plans to update the azure-sql-edge images to include the fix for kernel 6.7+?
  • Are there plans to update non-2022 mssql-server images to include the fix?

Thanks!

andrea-reale avatar Aug 08 '24 10:08 andrea-reale

This article indicates there won't be any further support releases for azure-sql-edge

https://techcommunity.microsoft.com/t5/sql-server-blog/azure-sql-edge-update-september-2023/ba-p/3930827

danielgary avatar Aug 09 '24 15:08 danielgary

Hello, I'm using mcr.microsoft.com/azure-sql-edge:latest on my M1 Mac, is there a better image to run MSSQL in Docker?

albertovelo avatar Aug 09 '24 16:08 albertovelo

@albertovelo

azure-sql-edge does no longer support Apple Silicon, see https://techcommunity.microsoft.com/t5/sql-server-blog/azure-sql-edge-update-september-2023/ba-p/3930827

Good news: Docker for Mac includes virtualization for AMD images (under Settings > General), so it's possible to use the image mcr.microsoft.com/mssql/server:2022-latest which includes the fix for the newer linux kernels.

See also https://www.justinjbird.me/blog/2024/running-sql-server-on-macos-using-docker/

nuarhu avatar Aug 13 '24 08:08 nuarhu

@nuarhu thank you so much ! :-D

albertovelo avatar Aug 13 '24 08:08 albertovelo

Also, the latest Cumulative Update for the SQL Server 2019 container includes the fixes, so I was able to get that working on my latest docker install (34)

ibiwan avatar Sep 13 '24 22:09 ibiwan