search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.58k stars 903 forks source link

Error “collection was modified enumeration operation may not execute” when restoring database backup in Azure Data Studio #8808

Open bradstruss opened 4 years ago

bradstruss commented 4 years ago

Steps to Reproduce: Run SQL Server via Docker on a Mac Restore database file use Azure Data Studio's Restore feature from the Server Dashboard Error message: “collection was modified enumeration operation may not execute”

I get this error on both new .bak files and a bak file that was successfully restored with a previous version of Azure Data Studio.

Others are having this issue as well: https://stackoverflow.com/questions/59437429/error-collection-was-modified-enumeration-operation-may-not-execute-when-resto

Unfortunately, that suggested fix does not work for me.

Is it possible to install an older version of Azure Data Studio?

mattsbanner commented 4 years ago

I am also experiencing this and the solution shown on Stack Overflow did not work for me.

We are running a Ubuntu 18.04 server with a Docker container using the mcr.microsoft.com/mssql/server:2017-CU8-ubuntu image.

This does look to be an issue with Azure Data Studio itself as a colleague has not updated and is able to restore the database.

Both running Azure Data Studio on Ubuntu 18.04.

Not Working: v1.14.1 Working: v1.10.0

larvata commented 4 years ago

https://stackoverflow.com/questions/59437429/error-collection-was-modified-enumeration-operation-may-not-execute-when-resto

this works to me