Linux SQL VDI backup
Nobody has claimed this yet.
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 25/100
- Issue type
- Bug
- Clarity
- Needs clarification
- Activity status
- Stale
- Tech stack
- linux, sql, ubuntu
- Domain
- databases, operating-systems
Research direction
Review the sample in samples/features/sqlvdi-linux and reproduce the GetConfiguration, sqlcmd backup, and OpenDevice failures on SQL Server for Linux 2019 under Ubuntu. Trace the reported VDI memory, buffer allocation, and device-opening errors to determine whether the sample or its documented setup needs correction; done means the cause and required change are established.
Written by the indexing model from the issue text.
Description
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
- Dominant language
- PowerShell
- Stars
- 11.2k
- Forks
- 9.1k
- Avg merge
- 2d 7h
- Merged PRs (30d)
- 14
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from microsoft/sql-server-samples
-
Difficulty 1/5 Under an hour Newbie friendliness 85/100
microsoft/sql-server-samples#1499 ·
-
Difficulty 1/5 1-3 hours Newbie friendliness 76/100
microsoft/sql-server-samples#1495 · 3 reactions ·
-
Difficulty 1/5 Under an hour Newbie friendliness 62/100
microsoft/sql-server-samples#1341 ·
-
Difficulty 1/5 Under an hour Newbie friendliness 64/100
microsoft/sql-server-samples#276 ·
-
Difficulty 1/5 Under an hour Newbie friendliness 35/100
microsoft/sql-server-samples#1497 ·
All issues in microsoft/sql-server-samples
Similar issues
-
bug: AI Gateway client filter lists "Unknown" twice when NULL and literal Unknown clients coexist Openbug
Difficulty 2/5 1-3 hours Newbie friendliness 90/100
-
[BUG] A column whose default is the empty string is drawn in the ER diagram as having no default Openbug database-provider good first issue hacktoberfest
Difficulty 2/5 1-3 hours Newbie friendliness 90/100
libredb/libredb-studio#1030 · 6 comments ·
-
comp-datalake
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
ClickHouse/ClickHouse#121222 ·
-
bug
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
-
bug redshift
Difficulty 2/5 1-3 hours Newbie friendliness 88/100