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:
- 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
- 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)
@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 triedmcr.microsoft.com/mssql/server:2022-CU8-ubuntu-20.04
with the same result.