SQL server 2017 container failing to start up or crashing mid process when running inside ubuntu vm as part of azure deployment pipeline

[andyjbenham]

we are using SQL server 2017 image - mcr.microsoft.com/mssql/server:2017-latest - to build a service container insude an ubuntu vm as part of our azure deployment process, on a microsft hosted agent and run several suites of tests against it.

It is either failing to come online - even if we implement a step to wait for several minutes - or losing the connection during our test run. Its somewhat random, in the sometimes on of hte suites of tests will work and then other - which is running the same yaml templated job - will fail.

We have had a support ticket open with the azure support tema but they have determined that it is not an issue with our pipeline and point to the possibiity that it is an issue with the base image.

I have been able to use this image locally by running it in docker desktop and pointing my local visual studio instance to it and it works without issue.

[csaba-kovacs]

same here, we have the same issue, 924

[andyjbenham]

same here, we have the same issue, 924

Thanks that link (and more importantly the further link in 924) helped me resolve the issue. I have changed from using ubuntu-latest to ubuntu 20.04 and I am able to spin up the 2017 container with no issues. I also tested with 22.04 and that had the same issue as Latest (2404).

Not ideal, but it is good enough for me