search

microsoft / sql-server-samples

Azure Data SQL Samples - Official Microsoft GitHub Repository containing code samples for SQL Server, Azure SQL, Azure Synapse, and Azure SQL Edge
Other
10.09k stars 8.9k forks source link

Linux SQL VDI backup #752

Open 13hakta opened 4 years ago

13hakta commented 4 years ago

I took sample for Linux VDI backup from https://github.com/Microsoft/sql-server-samples/tree/master/samples/features/sqlvdi-linux Added system users and ran on a server. App is ran under mssql system user and credentials set for SQL user with sysadmin role. MS SQL for Linux ver 2019 on Ubuntu 19.10.

On a GetConfiguration invocation in console appears message:

Host_1b00a6e6-8afd-4ca4-a23b-c44bd8b33808_SQLVDIMemoryName_0: ClientBufferAreaManager::SyncWithGlobalTable: Open(hBufferMemory): error 2Host_1b00a6e6-8afd-4ca4-a23b-c44bd8b33808_SQLVDIMemoryName_0: TriggerAbort: invoked: error 0Host_1b00a6e6-8afd-4ca4-a23b-c44bd8b33808_SQLVDIMemoryName_0: TriggerAbort: ChannelSem: error 2

On sqlcmd side:

BackupVirtualDeviceSet::AllocateBuffer: failure on backup device '{1b00a6e6-8afd-4ca4-a23b-c44bd8b33808}'. Operating system error 995(error not found).

And finally OpenDevice:

VDS::OpenDevice fails: x80770004

pmacleod commented 3 years ago

I've run into the same error. Was there any resolution on this?