Docker Desktop 4.13 and sqlpackage with linux image

Docker Desktop for Windows
1

Hi,

After switching from version 4.12 to 4.13 of Docker Desktop, sqlpackage in linux image hangs completely.when Extract action is used:

Dockerfile:

FROM mcr.microsoft.com/mssql/server:2019-latest
...
/opt/sqlpackage/sqlpackage /a:Extract /tmss:4096 /scs:$SRC_DB_CONNECTION_STRING /tf:peggi.dacpac /df:/tmp/sql_extract_in.log /p:ExtractApplicationScopedObjectsOnly=True /p:ExtractAllTableData=True /p:ExtractReferencedServerScopedElements=False /p:IgnoreUserLoginMappings=True /p:IgnoreExtendedProperties=True /p:ExtractUsageProperties=False /p:DatabaseLockTimeout=180

As I can see, sqlpackage freezes on a table that has a column with MAX parameter for exemple: nvarchar(MAX)., maybe because of blob.

Error message on the faulty table:

*** A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - Success)
*** A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - Success)
*** A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - Success)
Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
Using 'xplog70.dll' version '2019.150.4298' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.

Has anyone already had this problem?

I don’t see which changes in Docker Desktop 4.13 over 4.12 are blocking sqlpackage when extracting a database

Best regards,
Alain

2

The current version of Docker Desktop is 4.18.0. Is there a reason why you are using an older version?

It doesn’t look like an actual Dockerfile. There are no instructions except FROM.

I don’t use Windows containers so I can’t help you with this problem, but I added code blocks to your post possibly incorrectly. Please format your post properly next time so we don’t have to guess how it should be interpreted (like the Dockerfile)