azuredatastudio: import bacpac file hangs (mac OS Sonoma 14.0)

  • Azure Data Studio Version: 1.46.1 and previous ones
  • OS Version: macOS Sonoma 14.0

Steps to Reproduce:

  1. Run SQL Server in docker docker run --platform=linux/amd64 -e 'SA_PASSWORD={password}' -e 'ACCEPT_EULA=Y' -v storage:/var/opt/mssql -p 1433:1433 --name ms-sql-server mcr.microsoft.com/mssql/server:2017-latest
  2. Import bacpac file using Data-tier Application Wizard.

Result: Import bacpac file hangs (the file is successfully imported on Windows by MSSQL).

SQL Server logs:

spid60 Error: 17066, Severity: 16, State: 1.

spid60 SQL Server Assertion: File: <sql\ntdbms\storeng\include\allocationcachemanager.h>, line=419 Failed Assertion = 'm_refCountStack > 0'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.

spid60 Error: 3624, Severity: 20, State: 1.

spid60 A system assertion check has failed. Check the SQL Server error log for details. Typically, an assertion failure is caused by a software bug or data corruption. To check for database corruption, consider running DBCC CHECKDB. If you agreed to send dumps to Microsoft during setup, a mini dump will be sent to Microsoft. An update might be available from Microsoft in the latest Service Pack or in a Hotfix from Technicsuccessful.

Does this issue occur when all extensions are disabled?: Yes/No

About this issue

  • Original URL
  • State: closed
  • Created 9 months ago
  • Comments: 18 (6 by maintainers)

Most upvoted comments

@kisantia @dzsquared updating to macOS Sonoma 14.1 helped ✅

@alexpav-prodyna - we really appreciate you sharing what resolved the issue for you. It looks like at this point the currently GA version of Sonoma is 14.1 and Docker Desktop just released 4.25.0.

@Oktawski, @borbiuk, @henry-bettany - if you are able, will you check if the issue still occurs when updated to Sonoma 14.1?

thank you!

I had the same issue with multiple .bacpac files again and again.

Upgrading to Sonoma 14.1 solved it for me. See also: https://github.com/microsoft/mssql-docker/issues/858

@dzsquared I’ve already downgraded to Ventura, where it works flawlessly

@dzsquared maybe by tomorrow (Kyiv time) I will be able to tell you

I’m now seeing the same error having upgraded to macOS Sonoma. Known-good backups that were working previously are now not working.

I’m using the mcr.microsoft.com/mssql/server:2022-latest image (under Rosetta), but have tried mcr.microsoft.com/mssql/server:2022-CU8-ubuntu-20.04 with the same result.